I downloaded the full United States OSM data from cloudmade and imported it into a postGIS database using osm2postgresql_05rc4.sh. I have been working with this data successfully except for the coastline and greatlakes data. The oceans near the US coastline don’t appear to be present in the US data, and the great lakes all appear in the polygons data with null geometry values.
In attempt to remedy this, I downloaded the full coastlines shapefile. I imported that into my database using shp2pgsql. But I can’t successfully merge it with the osm US data on the geometry fields.
For context, here is the shp2pgsql command that I ran to import the coastline data:
shp2pgsql -c -D -s 4269 -i -I ./processed_p.shp public.coastlines > shoreline.sql
psql osmUS -f shoreline.sql
Does anybody have any insight into what I might be doing wrong? My maps look rather empty with all these white spaces…