Skip to content

Home

Jump to bottom Edit New page
Paul D Barham edited this page Mar 9, 2021 · 67 revisions

Current Good Datasets

These are datasets we feel are good and should be used. Please add to this list as you find sources.

Crime Data

  • KCPD Crime Data 2015, data.kcmo.gov Crime data by address, type of crime, and over time. Eric: Crime Data is accurate, but rounded to the nearest 100 level block. So if a crime happened at 414 East 12th Street it’s location is noted as 400 East 12th Street. Police does this to protect victims’ identities.

    Developers see the KCPD Crime Data 2015 API page it contains documentation on getting API keys, the updated API endpoints (search within_polygon), and documentation on the fields.

  • Sex Offender Registry, Missouri State Highway Patrol This page has a download tab, that downloads three .xls files.

Reported Issues

  • 311 Call Center Service Requests This data set contains call record data from the 311 call center in Kansas City, MO. This dataset used to be published under the name "KCMOPS311". This name was changed to make the dataset name more reflective of it's contents.

    Developers see the 311 Call Center Service Requests API page it contains documentation on getting API keys, the updated API endpoints (search within_polygon), and documentation on the fields.

  • Property Violations Peter with Legal Aid went through different types of code violations and scored them, from weakest (1) to strongest (3).

    Developers see the Property Violations API page it contains documentation on getting API keys, the updated API endpoints (search within_polygon), and documentation on the fields.

Business

You can also search through MO Open Data and see if they have any sort of information that would be useful.

  • Business License Holders, data.kcmo.org A business operating in the city must obtain an occupational license. This requirement applies to business entities regardless of their size or composition: corporation, partnership, association, company, individual, or any other type of business arrangement. A few professions, which are licensed by the state--most notably doctors, dentists, and lawyers--are not required to have occupational licenses. To verify if you need a business/occupational license, contact the Business License section at (816) 513-1135.

  • City of Independence business licenses. Data formats include csv and json. Information available includes address, business name, SIC, business description, status, start date, effective date, account status, account status description, latitude, longitude, number of employees, employee range, and whether it is a home-based business.

  • City of Independence contractor licenses. Data formats include csv and json. Information available includes license number, buiding name, business address, phone number, contractor type, status, application date, and expiration date.

  • City of Independence Limited Liability Companies (LLCs). Data formats include csv and json. Information available includes license number, business name, and natural person name.

  • City of Independence landlord licenses. Data formats include csv and json. Information available includes license number, business name, status, application date, and expiration date. You may also be interested in the data on rental properties, which is listed below in the Buildings section.

Liquor Licenses

Food

  • Food Access Research Atlas A map and data showing limited access to supermarkets, supercenters, grocery stores, or other sources of healthy and affordable food may make it harder for some Americans to eat a healthy diet. Has good documentation and data is downloadable http://gis.ers.usda.gov/arcgis/rest/services/foodaccess/MapServer?f=jsapi through ArcGIS.

  • City of Independence Restaurant Violations, all violations observed during food inspections in the last year. Data formats include csv and json. Information available includes name of the restaurant, address, whether smoking is allowed, whether it is an excellence award winner, latitude, longitude, violation date, violation, and whether there was a critical violation.

Traffic

Are there online services that will share their data? MARC may be another source.

Special Events

  • The City of Independence requires permits for special events. One type of special event is described as any non-traditional or non-routine uses of city facilities or property; another is a gathering on private property with significant impact on city resources not otherwise permited by zoning regulations. The city maintains a database of all special event permits issued since September 2018. Data formats include csv and json. Information available includes event name, event date, location, description, and estimated attendance.

Bus Transit

Census

They have a new API and some old docs about APIs.
Also of interest will be the Census Bureau Relationship Files which include the relationship of Census tabulation geography to zip code.

Election

Misc

  • GIS/Polygon data for Economic incentive districts - EDC and tax abatement boundaries (including MO 353), LCRA, historic, Urban Renewal - so we should show there outlines on a map.. GIS Data -> http://maps.kcmo.org/apps/parcelviewer/ Is it contained in the Download tab > “Other?” I can display them on the map via Layers > TIF, PIEA, ETC.

Parks, Boulevards, Buildings, Parcels, Lots

Kansas City Missouri Parks and Boulevards Map

A map of Kansas City Missouri Parks and Boulevards, in the correct format to allow for shapefile/kml/geojson extraction.

City of Independence Recreation

  • All parks located in the city. The available format is json.

  • All trails located in the city. The available format is json.

Land Bank Properties

Parcels

See also, GIS section.

  • Geocoded Kansas City Addresses A list of addresses in Kansas City as of 3/9/16 that have been geocoded by the city and provide latitude and longitude.
  • Delinquent Land Tax has all properties that have gone through tax foreclosure in the 16th Circuit Court of Jackson County, Missouri (NOT MACHINE READABLE)
  • City Owned Parcels This is a list of parcels owned by the City of Kansas City, Missouri.

Loan

  • Home Mortgage Applicaiton/Loan data. Data is loan level data, but has a census tract identifier. You will have to following the links to the download section.
    It has a nice preview, and data is avaliable in csv, json, as well as others.

Buildings

  • Demolished Dangerous Buildings, data.kcmo.org This is a list of buildings that were once on the dangerous buildings list (https://data.kcmo.org/Property/Dangerous-Buildings-List/ax3m-jhxx) but have been demolished. Once a structure is demolished it is removed from the dangerous buildings list.

  • Dangerous Buildings List, data.kcmo.org Updated daily. Dangerous Buildings are scored according to several objective criteria. The higher the score, the more likely it is that the City will be forced to demolish the property, and the shorter the timeline the property owner has to avoid this. Non-emergency cases start with the owner being given a 30 day Order to Repair or Demolish.

  • $10M Demolition List, data.kcmo.org This dataset contains a list of the dangerous buildings that are scheduled to be demolished through the $10,000,000 demolition program.

    How is this different than the dangerous buildings list? - This is a list of the structures that are being demolished through the $10M program. No additional buildings will be added to the $10M Demolition list, however as the city discovers new dangerous buildings they will be added to the Dangerous Buildings List, data.kcmo.org. This dataset also contains additional information on the status of dangerous buildings being demolished.

  • Permits - Core Dataset - Development This dataset contains Permits from the CompassKC system. It is structured according to the Building & Land Development Specification. Specifically, this dataset is the "core" portion of the standard. Information about the standard can be found.

  • Permits, older datasets

  • Buildings list of buildings, housefacts, last updated September 25, 2014. Contains Building ID, Parcel ID, Building Type, address of building, Lat, Lng, owner name & address.

  • City of Independence Building Permits issued in the past three months. Data formats available include csv and json. Available information includes permit number, type code, description, address, estimated cost, date issued, latitude, and longitude.

  • City of Independence active rental properties. Formats include csv and json. Available information includes rental address, landlord name, landlord address, license number, and status.

  • City of Independence active property maintenance violation cases. Formats include csv and json. Available information includes case number, status, case type, address, latitude, longitude, contact, description, case date.

  • City of Independence Rental Unit Inspections within the last year. Formats include csv and json. Available information includes license number, owner, address, inspection date, and whether the inspection was pass or fail.

Building Meta Data

  • KCMO Land Use Codes This table contains a code for how land use is labeled, along with a description of what that code means.

  • Approximate Building Area is now in the Address API see API Docs at the bottom. The Microsoft Bldg Outline (https://github.com/Microsoft/USBuildingFootprints) file was used, converted the polygons to centroids, then determined which centroids fell within each of the KC Parcels (polygon) file from KCMO Parcel Finder.

GIS Data \ API's \ Map Services(Free) \ Templates

Data

Map and Templates

  • Map Time is a great resource for OpenStreeMap and has a great "Resource" page.

  • D3 is a introduction to using D3 for mapping.

  • BootLeaf A responsive template for building simple and elegant web mapping applications using Bootstrap, jQuery and Leaflet Map API, by Bryan McBride. Demo

  • BootGMap Similar to and based upon BootLeaf, BootGMap was created for use with the Google Maps API and accesses data stored in Google Fusion Tables, also responsive using Bootstrap and jQuery - might be preferred if you require use of the Google Geocoding and GeoLocation API's. This is a work in progress, by Ron House - please fork and add functionality \ improvements. Live Demo

Other

  • GIS and data analysts highlights sources with interactive map interfaces to make accessing data at local and submarket levels easy.

API's - just a few of the many, JavaScript only

Leaflet Great open-source map API with a small footprint and a good selection of plugins (including Geocoding) and engaged community, ideal for mobile map apps. Plugin Page - Tutorials:

Google Maps The map API most users are familiar with - good if you can work within their licensing. Great if you need to use in conjunction with Google's vast list of API's, such as Geocoding and GeoLocation. Tutorials: -

Microsoft (Bing) Maps API

Nokia Ovi (Here) Maps API

MapQuest: (http://developer.mapquest.com/) -

OpenStreetMap API: (http://wiki.openstreetmap.org/wiki/API_v0.6)

Routing \ Geocoding \ Map Services with free (but limited) subscriptions - excluding those already mentioned above...

CartoDb: (https://cartodb.com/) -

MapBox: (https://www.mapbox.com/)

GraphHopper Directions and Matrix API: (https://graphhopper.com/#directions-api) -

TinyGeoCoder: (http://tinygeocoder.com/blog/about/) -

Route-Me: (http://code.google.com/p/route-me/)

MARC - Datasets

We need to detail these

About City and State

Future Datasets

Code Violations

Open Property Violations Pre Feb 2010, data.kcmo.gov We would like to see over time to help identify problem properties.

Comment: Eric R. Working on it! Should be our highest quality data yet. Also, about 250,000-300,000 observations in the dataset.

Demographic data

Demographic data recent - ethnicity, race, median household income, age, education, owned versus rental, multi-family versus single family, population count and density.

Comment: Eric R. We are trying to assemble this in house but our timeline is 1-2 months out. It’s fairly challenging for us to assemble this data. The Census is where we get our info. We are going to talk with NYC and see how they pull their ACS/Census data. I’m guessing it’s via API.

Property value

KIVA This will be a great dataset. We are actively working with Jackson County to create an automatic feed of this data from them to our servers. Data would be available with keys to parcel id and such. We will have all 4 counties worth of data once we get Jackson counties feed built. The Data would come from our Treasury division. You may be able to scrape it via the county APN -> For example > http://maps.jacksongov.org/PropertyReport/propertyReport.cfm?pid=12-940-05-03-00-0-00-000

Looking for sources

Absentee owners

A list of absentee owners by address - currently they go through KIVA and find properties where the property address does not match the owners address. Buildings might be a way to find, it is a list of buildings, housefacts, last updated September 25, 2014. Contains Building ID, Parcel ID, Building Type, address of building, Lat, Lng, owner name & address.

Foreclosures - county/state may be sources.

Population

Population / number of households moving in/out of a neighborhood (census data, property tax data, car registrations, etc.) Most of this would come from the ACS and Census data. Would be super interesting to see this over time. However, neighborhood boundaries shift over time too. Our neighborhood boundaries are presently mapped to census neighborhoods.

Zoning variances

Eric R. is check with planning on this but it may be a long-term project.

State Data

Kansas City Metropolitan Area Data

According to the U.S. Census Bureau, there are 14 counties in the metropolitan Kansas City area. The anchor city for this area is Kansas City, MO. So far most of the data gathered by Code for KC comes from there and from the Unified Government of Wyandotte County on the Kansas side of the state line.

In order to serve the entire metro area, data from other cities and counties would be useful. In addition to the anchor city, there are four other large cities in the metro area. All have populations of at least 100,000:

  • Overland Park, KS -- For more information about access to open records, contact the city's Freedom of Information Officer at 913-895-6150.
  • Kansas City, KS (included in the Unified Government of Wyandotte County) -- Open data is available through UG Open Data. Maps and tabular data are available through the Unified Government's DotMaps Public Web Mapper. To make a an open records request, contact the Clerk's office.
  • Olathe, KS -- To make an open records request, contact the City Clerk.
  • Independence, MO -- Open data is available through Open Independence. To obtain other public records, either contact the appropriate city office informally or submit an official request to the City Clerk.

Counties in the metro area (in order of population size) are:

  • Jackson County, MO -- Information about how to obtain public records in accordance with the state's Sunshine Law is available HERE.
  • Johnson County, KS -- Online public datasets are available through the county's Automated Information Mapping System. To make an open recors request, contact the County Manager.
  • Clay County, MO -- Information about how to obtain public records in accordance with the state's Sunshine Law is available from the County Administrator.
  • Wyandotte County, KS (included in the Unified Government of Wyandotte County) -- See Kansas City, KS listed above.
  • Cass County, MO -- Information about how to obtain public records in accordance with the state's Sunshine Law is available from the County Clerk.
  • Platte County, MO -- Information about how to obtain public records in accordance with the state's Sunshine Law is available from the County Clerk.
  • Leavenworth County, KS
  • Miami County, KS -- Information about how to obtain public records in accordance with the state's Open Records Act is available from the County Clerk.
  • Lafayette County, MO -- GIS maps are available HERE.
  • Ray County, MO -- Information about how to obtain public records in accordance with the state's Sunshine Law is available from the County Clerk.
  • Clinton County, MO -- Information about how to obtain public records in accordance with the state's Sunshine Law is available from the County Clerk, the Circuit Clerk, and the Recorder of Deeds.
  • Bates County, MO --
  • Linn County, KS -- Digital map files are available from the GIS/Mapping Department. Information about how to obtain public records in accordance with the state's Open Records Law is available from the Master County Clerk.
  • Caldwell County, MO -- Information about how to obain public records in accordance with the state's Sunshine Law is available from the County Clerk.

More information about the metropolitan area (including lists of smaller municipalities) can be found Metropolitan Kansas City Wiki.

Other Data Sites

These have been suggested, so let us know if they are useful to you.

  • James R. DeLisle "Show Me the Data". Their are non-traditional sources cited on this page, you can join our journey into the world of "big data." As you will find, this new regime is characterized by an explosion of data from disparate sources that are continuously expanding in scope and rapidly replenished.
  • http://data.world Discover and share cool data, connect with interesting people, and work together to solve problems faster.
  • http://plenar.io/ Plenario is a centralized hub for open datasets from around the world, ready to search and download. You can add data at this site.
  • https://www.nhtsa.gov/research-data/fatality-analysis-reporting-system-fars Detailing the Factors Behind Traffic Fatalities on our Roads - FARS is a nationwide census providing NHTSA, Congress and the American public yearly data regarding fatal injuries suffered in motor vehicle traffic crashes.
Add a custom footer
Add a custom sidebar
Clone this wiki locally