Countries

The file ne_10m_admin_0_countries.sml contains mappings for countries based on the Natural Earth countries dataset (direct download).

States

The file ne_10m_admin_0_countries.sml contains SML mappings for states in Germany based on the Natural Earth states and provinces dataset (direct download).

shp2pgsql -W 'LATIN1' -g 'the_geom' -s '4326' 'ne_10m_admin_0_countries.shp' 'ne_10m_admin_0_countries' | psql -h "$dbHost" -d "$dbName" -U "$dbUser"

shp2pgsql -W 'LATIN1' -g 'the_geom' -s '4326' 'ne_10m_admin_1_states_provinces.shp' 'ne_10m_admin_1_states_provinces' | psql -h "$dbHost" -d "$dbName" -U "$dbUser"