This is a
playground to test code. It runs a full
Node.js environment and already has all of
npm’s 400,000 packages pre-installed, including
geojson2pgsql with all
npm packages installed. Try it out:
geojson2pgsql lists no main file and has no index.js, so it can't be directly required. If this is a mistake, please let us know. It may however contain internal files that you can require manually:
This service is provided by RunKit and is not affiliated with npm, Inc or the package authors.
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.
data.json into a
data table and display keys present in
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"
DATABASE_URL- Postgres connection info. Required.