us-counties-datasette

https://us-counties.datasette.io/

A Datasette instance exposing US counties, FIPS codes and polygons.

Source data: the cb_2018_us_county_500k.zip shapefile released by the US census.

Download that from https://www.census.gov/geographies/mapping-files/time-series/geo/carto-boundary-file.html

Run ./build.sh to build the database.

To run locally:

datasette counties.db -m metadata.yml --load-extension=spatialite

I run ./deploy.sh to deploy it to Cloud Run.

API

This query will return the county for a latitude and longitude:

https://us-counties.datasette.io/counties/county_for_latitude_longitude

Here's that as a JSON API:

https://us-counties.datasette.io/counties/county_for_latitude_longitude.json?longitude=-122.676968&latitude=45.266289&_shape=array

Related Projects

datasette-cluster-map

Datasette plugin that shows a map for any data with latitude/longitude columns

19 Apr 2018 87

datasette-leaflet-geojson

Datasette plugin that replaces any GeoJSON column values with a Leaflet map.

27 May 2018 19

timezones-api

A Datasette-powered API for finding the time zone for a latitude/longitude point

12 Dec 2017 28

calands-datasette

Datasette instance with data from calands.org

21 Aug 2020 4

datasette-leaflet-freedraw

Draw polygons on maps in Datasette

20 Jan 2021 16

datasette-geo

A Datasette plugin to make Spatialite databases effortlessly explorable

29 Apr 2019 10

fivethirtyeight-datasette

Code to package FiveThirtyEight data using Datasette

18 May 2018 16

datasette-haversine

Datasette plugin that adds a custom SQL function for haversine distances

24 Oct 2019 2

datasette-basemap

A basemap for Datasette and datasette-leaflet

02 Feb 2021 2

datasette-yaml

Export Datasette records as YAML

29 Aug 2020 5

datasette-sqlite-fts4

Datasette plugin that adds custom SQL functions for working with SQLite FTS4

02 Jan 2019 3

geojson-to-sqlite

CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

30 Jan 2020 56

datasette-tiles

Mapping tile server for Datasette, serving tiles from MBTiles packages

02 Feb 2021 7

covid-19-datasette

Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times

10 Mar 2020 61

shapefile-to-sqlite

Load shapefiles into a SQLite (optionally SpatiaLite) database

16 Feb 2020 27