Open Hamilton

Hamilton County data inventory

One of the key challenges governments face in making data open is identifying which datasets to prioritize.

We reviewed the records and search tools available on Hamilton County’s website and compared them to the datasets and visualizations published on Baton Rouge’s and Chattanooga’s respective data portals.

Some Hamilton County records are already available in PDF format or through Web search forms. Those sets are identified in the tables below and would serve as a good starting point for implementing a data policy.

Business and financial

Dataset Baton Rouge Chattanooga Hamilton County
Registered businesses Yes Yes Search form
Sales tax collections Yes
New businesses Yes Search form
Growing economy indicators Yes
New jobs Yes
Number of non-residential building permits Yes
Non-residential building permits dollars invested Yes

Culture and recreation

Dataset Baton Rouge Chattanooga Hamilton County
Public parks Yes
Map of public parks Yes
Landmark map Yes
Scenic views map Yes
Points of interest map Yes Yes
Waterfalls Yes
Bike share Yes
Disk golf courses Yes
TRGT lands Yes
Local farms Yes
Museums Yes
Golf courses Yes
Bike share locations Yes
Entertainment Yes
Bike routes Yes
Farm trails Yes
Rock climbing Yes
Mountain bike trails Yes
Bicycle lanes and trails Yes
Museums Yes
Bike routes Yes
Places Yes
Blueways Yes
Access, parking, and trailheads Yes
Greenways, trails, and routes Yes
Boat ramps and marinas Yes
Farmers markets Yes
Primitive camping Yes
Hang gliding Yes
Mountain biking trails Yes
Organic farms Yes
Trail parking Yes
Road bike routes Yes
Community gardens Yes
Trails on the creek watershed Yes
All recreation trails Yes
State forests Yes
Greenways and urban trails Yes
Wildlife centers and zoos Yes
Entertainment venues Yes
Amenities camping Yes
Tennessee road bike routes Yes
50-mile food shed Yes
Recreation trails Yes
100-mile food shed Yes
Public library circulations Yes

Education

Dataset Baton Rouge Chattanooga Hamilton County
Smarter students stronger families indicators Yes
Head start Yes
Differentiated pay plan PDF
Coaching supplemental pay PDF
Salary scale PDF
Agendas and minutes PDF
School finder Search form

Government

Dataset Baton Rouge Chattanooga Hamilton County
Rail Yes
Legislation PDF Search form
Legislator spending reports PDF
Legislative agendas PDF PDF
Marriage licenses Search form
Car reports PDF
Tax roll Yes Yes Text file
Delinquent tax roll Yes Text file
Voting precincts Map
Election results Yes PDF
Disclosures for candidates and elected officials Yes PDF
Bid solicitations Yes Web
311 service requests Yes
All permit status history Yes
City website analytics Yes Yes
All permit inspector Yes
Service requests Yes
Government operating budget Yes
All permits Yes
BFO data Yes
2015 capital budget treemap Yes
Open data automated job log Yes
Open data inventory Yes
Work orders Yes
Community survey results Yes
All permit contractors information Yes
Map of workforce recruiting and training providers Yes
Proposed 2015 capital budget Yes
Spending by the government Yes
Capital project list Yes
Dead animal pick-up 311 request Yes
List of open data portal items Yes
Directory of workforce recruiting and training resources Yes
Government capital budget Yes
EPB average cost per KWH per residential customer (visualized) Yes
Open data policy Yes
Open data report Yes
Garbage pick-up satisfaction Yes
Garbage satisfaction (visualized) Yes
Garbage satisfaction Yes
City limit Yes Yes
Proposed capital budget by department Yes
Budget alternative 2014 Yes
County boundary Yes Map
City-parish employee annual salaries Yes
City-parish employees Yes
Active city_parish employees Yes
2014 city-parish employee annual salaries Yes
Active DPW employees Yes
Purchase orders Yes
Public facilities Yes
GIS web services Yes
Map of public facilities Yes
2014 department and salary comparison Yes
Percentage of city-parish workforce by department Yes
Purchase orders - header only Yes
EPB operating revenues Yes
311 service requests by type Yes
Government project phase list Yes
Community survey visualization Yes
Waste resources division Yes
High performing government indicators Yes
Council districts Yes Map
Department and salary comparison 2015 Yes
Employee annual salaries 2015 Yes
Census demographics Yes Yes
Thrive 2055 counties Yes
Schools and universities Yes
City bond rating Yes
Community survey results Yes
Numbers of 311 service requests created each year Yes
FY2016 service requests by request type Yes
Community survey results - city services ranking chart Yes
Street cleanup work orders Yes
Citizen satisfaction with 311 services overall Yes
Citizen satisfaction - city streets Yes
FY2016 service requests by division and type Yes
FY2016 CWS service requests by request type Yes
Street cleanup work orders Yes
Side-by-side budget approved and recommended Yes
Citizen use of 311 Yes
Public works pothole work orders Yes
FY2016 work orders by asset group Yes
Public works pothole service requests Yes
Average cost per KWH per residential customer Yes
Building permits by type Yes
Permits by type pie chart Yes

Health

Dataset Baton Rouge Chattanooga Hamilton County
Community health data profile PDF
Infant mortality report PDF
Adults: Behavioral risk factors PDF
Youth: Behavioral risk factors PDF
Fact sheets on various health topics PDF
Environmental health inspections Search form

Housing and development

Dataset Baton Rouge Chattanooga Hamilton County
Property appraisal information Yes Yes Search form
PILOT agreements Yes Web page
Deeds, mortgages and reconveyances Subscription-only search
PILOT agreements map Yes
Building permit heat map 2015 Yes
Building permit heat map 2016 Yes
Permits by type pie chart 2015 Yes
Permits by type pie chart 2016 Yes
Building permits by type 2015 Yes
Building permits by type 2016 Yes
Adjudicated property 2013 Yes
Adjudicated property 2014 Yes
Adjudicated property 2015 Yes
Adjudicated property point map with council districts 2013 Yes
Adjudicated property point map with council districts 2014 Yes
Adjudicated property point map with council districts 2015 Yes
Adjudicated property heat map 2013 Yes
Adjudicated property heat map 2014 Yes
Adjudicated property heat map 2015 Yes
Adjudicated property Yes
Adjudicated property by council district 2013 Yes
Adjudicated property by council district 2014 Yes
Adjudicated property by council district 2015 Yes
Residential new constructions per year Yes
Residential new constructions per year (chart) Yes
Historical land development story map Yes
Building permits Yes Yes Calendar
Building permit heat map Yes
Subdivisions Yes
Property tax data 5-year Yes Search form
Address data Yes Map
Property owners Map
Property zoning Yes Map
Condemned properties Yes
Land parcels Yes Map
Condemned property report Yes
Condemned properties by jurisdiction (visualized) Yes
Blighted properties demolished Yes
Properties transitioned to affordable housing Yes
Blight related violation notices issued Yes
Build better homes Yes
Stronger neighborhoods Yes
PILOT agreements - investments grouped by agreement beginning year Yes
PILOT agreements - jobs commitments grouped by agreement beginning year Yes
Innovation district boundary spatial lens Yes

Public safety

Dataset Baton Rouge Chattanooga Hamilton County
Jail booking by day Web page
Mugshots Search form
Court record captions Search form
Circuit court dockets PDF
Criminal court dockets PDF
Dispositions and court dates Search form
Dockets - civil division Search form
Dockets - criminal division Search form
Dockets PDF
Sex offender registry Map
911 active calls Yes Web page
Traffic citations by location Yes Yes
Map of citations (2012-2014) Yes Yes
Safer neighborhoods - vision extract with beat Yes
E911 active calls - police view Yes
Police incident data Yes Yes
Missionary ridge - police incidents Yes
Police incident data Yes Yes
Traffic citations by location 2012 to 2014 Yes Yes
Missionary ridge - 911 data Yes
Code violations Yes
Chart of crime data by type Yes
Crime data by type Yes
Safer neighborhoods - category Yes
Safer neighborhoods - chart of incidents by category Yes
Code violations Yes
Offense roll-up Yes
Police data filtered Yes
Safer streets Yes
Police incident data 2015 Yes Yes
911 calls past Yes
Crime heat map Yes Yes
Crime data by category Yes Yes
Average response time Yes
Shootings Yes
Family Justice Center activities - timeline Yes
Non-fire calls Yes
Part 1 violent crimes Yes
Family Justice Center activities Yes
Domestic violence aggravated assaults Yes
False calls Yes
Robberies Yes
Fire marshal inspections Yes
Fire incidents Yes
City court warrants Yes
Animal control incidents Yes
Police districts Yes
Street lighting Yes
Traffic signals Yes
Traffic control signs Yes
Crime data Yes
Fires Yes
Tornadoes Yes
Fire incidents by description Yes

Sustainability

Dataset Baton Rouge Chattanooga Hamilton County
Temperature change by 2080 Yes
Public or protected lands and waterways Yes
Public recycling sites Yes
Precipitation increase by 2050 Yes
Temperature change by 2015 Yes
Bus stops Yes
Public and protected lands Yes
Bus routes Yes
Average precipitation 1951-2006 Yes
Level II ecoregions Yes
Sewage water treatment Yes
Leadership in energy and environmental design buildings Yes
Green roofs Yes
AMD treatment site Yes
Creek watershed Yes
Green hospitality certifies businesses Yes
Hemlock stands Yes
Free shuttles Yes
Bus stops Yes
Dams Yes
Mine or quarry Yes
Free shuttles Yes
Strip mines Yes
Stream Yes
Geology Yes
Solar energy sites Yes
Aquifers Yes
Impervious area Yes
Recycling participation Yes
Recycling vs. garbage (tons collected) Yes

Transportation

Dataset Baton Rouge Chattanooga Hamilton County
Street names Yes Yes Map
Bike Chattanooga trip data Yes
Bike Chattanooga subscribers Yes
Bicycle parking locations Yes
Bus GTFS Yes
Bike real time station feed Map
Map of bicycle parking locations Yes
Bike trips per day of the week Yes
Bike stations Yes
Electric vehicle charging stations Yes
Rail Yes
Airports Yes
Metropolitan airport activity Yes
Electronic shuttle ridership Yes
CARTA bus monthly ridership Yes
311 street light request Yes
Public works waste resource data Yes