wayneburkett

# download the shapefile and dump it into a database
mkdir tmp && \
curl -L "https://data.providenceri.gov/api/geospatial/78bu-i8at?method=export&format=Shapefile" -o tmp/prcl.zip && \
cd tmp && \
unzip prcl.zip && \
ogr2ogr -f SQLite prcl_raw.db geo_export_*.shp -t_srs EPSG:4326

# create a table with everything you'd need to run an everylot bot
# http://fakeisthenewreal.org/everylot/
# change the table name to whatever the downloads give you (it's randomized)

wayneburkett

Originally here: https://stackoverflow.com/questions/6735470/get-pixel-color-from-canvas-on-mouseover

Refresh to get new colors.

wayneburkett

How to create this file

1. First you'll need to download the latest parcel data (shapefiles and extended parcel records) and generate a SQLite database:

# download the shapefiles and parcel data, merge it all together, and dump it into a database
curl -L "https://www.stlouis-mo.gov/data/upload/data-files/prcl_shape.zip" -o prcl.zip && \
unzip prcl.zip && \
curl -LO "https://www.stlouis-mo.gov/data/upload/data-files/par.zip" && \
unzip par.zip && \

wayneburkett

This is every address posted by https://twitter.com/everylotstl as of 2021-05-25.