Skip to content

Instantly share code, notes, and snippets.

@wayneburkett wayneburkett/nyctrees
Last active Sep 2, 2019

Embed
What would you like to do?
# get a pared-down database of the trees in NYC
# the downloaded CSV is ~210M
# the generated DB is ~22M
mkdir trees && \
curl -L https://data.cityofnewyork.us/api/views/uvpi-gqnh/rows.csv?accessType=DOWNLOAD -o trees/trees.csv && \
ogr2ogr -f SQLite trees.db trees/trees.csv -nln trees -dialect sqlite \
-sql "SELECT tree_id AS id, \
ROUND(latitude, 6) lat, \
ROUND(longitude, 6) lon \
FROM trees"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.