Retrieve place names with population (.e00) and put into a Postgres database

index.sh

# Retrieve data from https://water.usgs.gov/GIS/metadata/usgswrd/XML/places.xml#stdorder
# curl https://water.usgs.gov/GIS/dsdl/places.e00.gz

# put the data into "Web Mercator" projection
PRJ="EPSG:4326"
DB=gis_db

# The original files were coverages, so I have to know something about
# what I want to transfer. For example for this file I want only LAB
# ogrinfo places.e00
# 1: LAB (Point) This is the one I want.

# Load the contents of the file into the "places" table
ogr2ogr -t_srs $PRJ -f PostgreSQL \
PG:"user=postgres dbname=$DB" \
places.e00 LAB \
-lco GEOMETRY_NAME=the_geom -nln places