Local Government Locations

This dataset contains the latitude, longitude and total square miles for every city, township and village in the State of Michigan. This dataset can be joined by location name with other datasets to create map visualizations in data.michigan.gov or other mapping software.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"michigan-gov/local-government-locations-fa5w-f99v\".\"local_government_locations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.