Skip to content

Instantly share code, notes, and snippets.

@geobabbler
Created May 8, 2015 14:29
Show Gist options
  • Save geobabbler/25297ca5dd4e9bd5388f to your computer and use it in GitHub Desktop.
Save geobabbler/25297ca5dd4e9bd5388f to your computer and use it in GitHub Desktop.
OGR export example for blog post
ogr2ogr -f "GeoJSON" statistics_%2_%1.geojson PG:"host=localhost user=wombat dbname=geo2 password=sufficiently_complex_password" -sql "SELECT * FROM vw_geojson_statistics_ytd WHERE year = 2015"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment