Importing Data Sources to PostGIS

ETL stuff relates to importing data sources into new tables or existing ones …

When working with GIS we want to import data from different data sources …

To import a given data source we will:

1. download the file
2. import using ogr2ogr
   1. may have specific settings for the data source

First we want to import the file using ogr2ogr. I’ll build a wrapper around the CLI tool and point it to the right file.

Viewing the data

3. Download QGIS, it’s easy to download
4. Connect to the PostGIS database
   1. From the menu: Layer → Add Layer → Add PostGIS Layers → New
5. Done

Data source: https://github.com/microsoft/USBuildingFootprints

Add OSM: 6. From the Browser, scroll down to XYZ Tiles → OpenStreetMap 7. Bring the OSM layer down

References

8. PostGIS Workshop