francbartoli/MBTiles: Pipe GeoJSON from PostGIS to Tippecanoe.md

Forked from johnniehard/MBTiles: Pipe GeoJSON from PostGIS to Tippecanoe.md

Created April 11, 2020 20:49

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/francbartoli/964126a08ba0326feda2c5ee14f61bca.js"></script>
Save francbartoli/964126a08ba0326feda2c5ee14f61bca to your computer and use it in GitHub Desktop.

Download ZIP

MBTiles: Pipe GeoJSON from PostGIS to Tippecanoe

Raw

MBTiles: Pipe GeoJSON from PostGIS to Tippecanoe.md

I had a large dataset in postgis and wanted to avoid the hassle of first exporting it to a several GB geojson file before tiling it with Tippecanoe.

ogr2ogr -f GeoJSON /dev/stdout \                                                                            
PG:"host=localhost dbname=postgres user=postgres password=thepassword" \
-sql "select * from a, roi where a.geom && roi.geom" \
| docker run -i -v ${PWD}:/data tippecanoe:latest tippecanoe \
--output=/data/yourtiles.mbtiles