Loading an LPK file into PostGIS

Last updated on September 15, 2022.

LPK files are often downloaded from ArcGIS Online, but are supported by very few file formats. This is because LPK files are compressed folders containing a geodatabase.

Converting LPK files into other formats, like a Shapefile, requires multiple command line tools. First, the LPK file can be renamed to .7z and decompressed with 7-Zip. Then, the subfolder has a .gdb folder that can be converted into other formats using ogr2ogr. This blog article shows how that works.

Here, you can upload your LPK file and download it as a spatial .sql file. That file can be easily imported into PostGIS with the psql command line tool. Alternatively, Bunting GIS can host the table and let you query it.

LPK Format Support:

  • One layer imported
  • Handles up to 256MB
  • Detect encoding (UTF8, Latin1, etc)

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