1. Mineral Resources
2. Online Spatial Data
3. Geology
4. by state
5. CAgrCZ?;0

SGMC polygons matching unit identifier CAgrCZ?;0

The shapefile could not be created.
pgsql2shp -f output/CAgrCZ?_0 -h igsaws910svrds1.er.usgs.gov -u emrt -P usgs -g wgs84_geom mrdata "select gid,state,unit_link,ref_id,generalize,src_url,'https://mrdata.usgs.gov/geology/state/sgmc-unit.php?unit='||unit_link as url,wgs84_geom from sgmc2.geol_poly where unit_link='CAgrCZ?;0'"
Initializing...
Done (postgis major version: 3).
Output shape: Polygon
Dumping: X [1 rows].
zip -m CAgrCZ?_0.zip CAgrCZ?_0.*
  adding: CAgrCZ?_0.cpg (stored 0%)
  adding: CAgrCZ?_0.dbf (deflated 53%)
  adding: CAgrCZ?_0.prj (deflated 40%)
  adding: CAgrCZ?_0.shp (deflated 23%)
  adding: CAgrCZ?_0.shx (deflated 45%)