Development QueueChannel: geojson → postgis sql
GeoJSON to PostGIS SQL Converter
Import web JSON coordinates into central Postgres databases.
Seamlessly migrate web geometries to central servers. This upcoming tool parses GeoJSON datasets and writes them to PostGIS as spatially-indexed database tables, complete with attributes.
Direct Target Stream Unavailable
This direct channel is planned for an upcoming release. In the meantime, consult the technical specifications and guidelines below.
Specification Rules
- Save user-generated drawing shapes from web maps directly to server databases
- Consolidate crowdsourced map layers in central enterprise systems
- Batch-import spatial JSON lists to high-capacity server instances
- JSON properties must match target database field types
- Subject to column width limitations inside target architectures
- Requires active spatial metadata profiles in the target database
GDAL Direct Equivalent Terminal Command
sh console shell
$ogr2ogr -f PostgreSQL PG:"dbname=gis_db user=admin" input.geojson
Frequently Asked Queries
How are JSON properties mapped to columns?
GDAL automatically reads root key properties, creating matching column names in the PostgreSQL tables.
Can I append data to existing tables?
Yes, you can configure the importer to append layers to existing tables using database write options.
Does this require coordinate system adjustments?
Coordinates map automatically, but you can configure the importer to reproject coordinates to match your database defaults.