postgis2geojson

KO | EN

gitlite — search

#typescript #ai-agents #ai #dsh-plugin #deepseek-harness #open-source #cli #claude-code #codex #developer-tools #react #windows

postgis2geojson

★ 31 Open GitHub ↗

Extract PostGIS tables as GeoJSON and TopoJSON

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# PostGIS2GeoJSON

## postgis2geojson.py

A simple tool for exporting from a PostGIS table to GeoJSON and TopoJSON. Assumes [Python 2.7+](http://www.python.org/download/), 
[psycopg2](http://initd.org/psycopg/download/), and [TopoJSON](https://github.com/mbostock/topojson/wiki/Installation) are already installed and in your ````PATH````.

Adapted from Bryan McBride's excellent [PHP implementation](https://gist.github.com/bmcbride/1913855/).

####Example usage:

To export table ````boundaries```` from database ````gisdata```` as user ````user```` to both GeoJSON and TopoJSON:

````
python postgis2geojson.py -d gisdata -t boundaries -u user --topojson
````

or, also specify that the geometry column is ````the_geom````, only fields ````oid```` and ````name```` should be returned, and the output file should be called ````boundary_data````:

````
python postgis2geojson.py -d gisdata -t boundaries -u user -p password -g the_geom -f oid name -o boundary_data --topojson
````

####Arguments:

| Name         | Argument           | Default value |  Required  | Description  |
|--------------|:------------------:|:-------------:|:----------:|------------------|
| Help         | ````-h````         |               |            | Show friendly help message |
| Database     | ````-d````         |               |      Y     | Database to use |
| Host         | ````-H````         | localhost     |            | Host to connect to |
| User         | ````-U````         | postgres      |            | Postgres user to use |
| Password     | ````-p````         |               |            | Password for Postgres user |
| Port         | ````-P````         | 5432          |            | Database port |
| Table        | ````-t ````        |               |      Y     | Table to query |
| Fields       | ````-f ````        | *             |            | Database fields to return, separated by a single space |
| Geometry     | ````-g````         | geom          |            | Name of geometry column |
| Where        | ````-w````         |               |            | Optional WHERE clause to add to the SQL query |
| File         | ````-o````         | data.geojson  |            | Name of output file |
| Topojson     | ````--topojson```` |               |            | Creates a TopoJSON file in addtion to a GeoJSON |
| Pretty print | ````--pretty````   |               |            | Pretty print the output |

A full list of options is also available via ````python postgis2geojson.py --help````.

postgis2geojson

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README