Ung. `shp2pgsql` is very useful tool, but it doesn't use the `.prj` file for a shapefile? Is there a better, more modern “import this shapefile” tool? #xp
@rory thanks for posting this, I've been wanting to create an OSM layer from my local governments open GIS data, so I can fill in addresses that are not posted on buildings. I will try out these two tools
@hinton Geofabrik (where I work) provides various thematic shapefiles from #OpenStreetMap data. Give that a try in case those help.
https://download.geofabrik.de/