Naming Conventions

For the database it is important to set up conventions for naming our files so everyone knows what files are and it will be more organized. A few of us met today to define major categories and this is what we came up with. We can discuss this tomorrow further, so it is more suitable for everyones projects, but until then use this naming for the new database. Just a reminder… do not use spaces or upper case letters in your table names.

City Geom:
– ex. Sidewalks, City Limits, Streets, Building Footprints
– should ideally just be an “id” and “geom” column as this will be used mainly for visualizing in QGIS
– start layers in this category with cty_

Transportation:
– ex. Bus Routes, CTA Stops
– start layers in this category with trn_

Demographics:
– ex. Census by Block 2010, Income by Block 2000
– start layers in this category with dmo_

Landscape:
– ex. Parks, Trees
– start layers in this category with lnd_

Jurisdiction:
– ex. Police Districts, TIF Districts, Neighborhoods, Wards
– start layers in this category with jur_

Report:
– ex. Crime 2013, 311 Requests, Permits, Business Licenses
– start layers in this category with rpt_

Social:
– ex. Facebook API, Yelp API
– start layers in this category with soc_

Agent:
– ex. Customer, Alderman, Dogs
– start layers in this category with agt_

conventions

Another place to get data: https://opendata.socrata.com/
(worldwide, but has all Chicago Data Portal data and then some)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s