Guest User

Untitled

a guest
Sep 24th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. >ogrinfo -al -so someshapefile.shp
  2.  
  3. GEOGCS["NAD83",
  4. DATUM["North_American_Datum_1983",
  5. SPHEROID["GRS 1980",6378137,298.257222101,
  6. AUTHORITY["EPSG","7019"]],
  7. AUTHORITY["EPSG","6269"]],
  8. PRIMEM["Greenwich",0,
  9. AUTHORITY["EPSG","8901"]],
  10. UNIT["degree",0.01745329251994328,
  11. AUTHORITY["EPSG","9122"]],
  12. AUTHORITY["EPSG","4269"]]
  13.  
  14. >shp2pgsql -I -s 4269 someshapefile.shp <schema>.<table> | psql -U <user> -d <dbname> -h <hostaddress> -p 5432
  15.  
  16. >ogr2ogr -f "PostgreSQL" "PG:host=<hostaddress> user=<user> dbname=<dbname> password=<password>" "C:/shapefile.shp" -nln <schema>.<table>
Add Comment
Please, Sign In to add comment