Importing GeoJSON files into PostGIS
Last updated on August 16, 2022.
GeoJSON is one of the easier formats to upload into PostGIS. Most people download and install the command line tools for PostGIS, which includes ogr2ogr, a command line tool that can help someone directly upload a GeoJSON file to a PostgreSQL database that they can self-host.
To streamline the process, you can upload the GeoJSON file here and download it as a spatial .sql file. You can directly upload this .sql file to your PostGIS instance. Or, you can choose to have us host it for you.
GeoJSON Format Support:
- WGS84 default CRS
Once the file is converted to PostGIS, you can either download the file as
.sql and upload to your database with
psql, or host the file with us for free. This file fits on our free plan, which is under 128MB of storage and shared compute time. Larger datasets can be stored for $2.50/GB/month.
Uploading to PostGIS (self-host)
To load your .psql file into your PostGIS instance (local, Amazon RDS, or other), you can use the
psql command line tool.
psql -U postgres -h localhost -d postgres -f downloaded_file.sql
Database Connection (managed)
If you choose Bunting as your host, connect to the PostGIS database with your username and password:
psql -W -U username --dbname data_gis \
Connection can also be made through GeoDjango or GeoPandas, like so:
from sqlalchemy import create_engine
db_connection_url = "postgresql://username:[email protected]:5432/data_gis"
con = create_engine(db_connection_url)
sql = "SELECT geom, highway FROM target_table"
gdf = geopandas.GeoDataFrame.from_postgis(sql, con)