Changes between Initial Version and Version 1 of UsersWikiExamplesShp2Pgsql


Ignore:
Timestamp:
Apr 13, 2009, 2:04:57 PM (15 years ago)
Author:
pierre
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiExamplesShp2Pgsql

    v1 v1  
     1
     2= Examples shp2pgsql =
     3
     4
     5shp2pgsql -s <SRID> shapefile nameoftable > sqlfileforimport.sql
     6
     7shp2pgsql -s 26986  cities tblcities > cities.sql
     8
     9In the above we are outputting an shp file called cities.shp to a table tblcities and dumping the sql insert statements to a file called cities.sql.  The Spatial Ref system is 26986 (which if you look in spatial_ref_sys is Massachusetts State Plane NAD 83 meters).