Visualizing Pittsburgh
- Building footprints (spatial vector)
- Parcels (spatial vector)
- Property assessments (csv only)
The server provides mbtiles layers using mbtileserver for fast user visualization.
Spatial analysis is performed using PostGIS.
MBTiles are generated using Tippecanoe.
ogr2ogr is used to load the shapefiles into PostGIS. Shapefiles may contain invalid geometry which can be repaired using QGIS before loading with ogr2ogr.
assessments.csv contains interesting parcel features, but we would prefer to visualize the building footprints. To associate the interesting data with each footprint, the footprints must be spatially joined with the parcel shapes.
Many footprints (how many?) are contained neatly inside parcels, but some overlap several parcels. These overlaps may be meaningful or accidental. Analysis is required to distinguish meaningful overlaps from accidental.