No description, website, or topics provided.
JavaScript
Switch branches/tags
Nothing to show
Clone or download
Latest commit 6561dc1 Mar 12, 2014
Permalink
Failed to load latest commit information.
bin
.gitignore Initial version Oct 29, 2013
README.md Limitations Mar 11, 2014
package.json 0.0.1 Nov 6, 2013

README.md

geojson2pgsql

When ogr2ogr isn't enough. Imports GeoJSON into PostgreSQL, using features' id as the primary key, their geometry as a PostGIS geometry, and their properties as a JSON column.

Requires PostgreSQL 9.2 for JSON storage, 9.3 for meaningful query functionality.

Usage

Import data.json into a data table and display keys present in properties.

createdb json-test
psql -d json-test -c "create extension postgis"
DATABASE_URL=postgres://localhost/json-test geojson2pgsql data.json data
psql -d json-test -c "select json_object_keys(properties) from data"

Environment Variables

  • DATABASE_URL - Postgres connection info. Required.

Limitations

  • Only supports Points
  • Presumably other things