[postgis-users] Problem in migrating shapefile to postgis

[Tom Glancy]

Hi Vinh,

Here is your LopGiaoThong.prj file:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]

Searching the spatial_ref_sys table for something equivalent, here is
text for srid 4326
"GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS
84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]"

So I would use -s 4326

Regards,
Tom


---------------------------------------
Tom Glancy
Ecological Services Division IT Supervisor

tom.glancy at dnr.state.mn.us
651-259-5097

Minnesota Department of Natural Resources
500 Lafayette Road - Box 25
St. Paul, MN 55155-4025
---------------------------------------
>>> vinh nguyenquang <nguyenquangvinh20052005 at yahoo.com> 11/11/08 6:17
AM >>>
Hi, everyone
Can you help me load LopGiaoThong.shp vao trong postgis? I have problem
with SRID or something else i don't know.
I do it in this way: shp2pgsql -i -D -s LopGiaoThong.shp LopGiaoThong >
LopGiaoThong.sql
                           psql -d postgis -U postgres -f
LopGiaoThong.sql
I do not know the parameter -s: what value it is to load
LopGiaoThong.shp
Can you show mw how to find the value of -s parameter (SRID) of my data
or how to load my data to postgis?
Thank you very much!
 





      Địa chỉ email mới dành cho bạn! 
Chọn ngay một tên truy nhập bạn từng muốn lập với tên miền mới ymail và
rocketmail. Nhanh nhanh trước khi có người xí mất!
http://mail.promotions.yahoo.com/newdomains/vn/