[postgis-users] Problem in migrating shapefile to postgis

Lê Viết Thanh lethanhx2k at gmail.com
Tue Nov 11 06:29:32 PST 2008


But there are some problems to this data, do not based on the information in
PRJ to say that SRID is 4326. This guy doesnt know any thing about
geographic/coordinate system (IMO). With my knowledge and location of this
data, the SRID must be 32648 or WGS 84 / UTM zone 48N.

On Tue, Nov 11, 2008 at 9:09 PM, Ervin Ramonllari <
ervin.ramonllari at hotmail.com> wrote:

>  Hi,
>
> You are trying to load some data to a PostGIS and your data are in lat/long
> (according to .prj file).
> This means that the SRID to be used is 4326 (the value for -s parameter).
>
> I don't know if you really need the other parameters (-i, -D), but if you
> don't need them, better don't use.
> First try with few parameters, like :
> shp2pgsql -s 4326 LopGiaoThong.shp LopGiaoThong > LopGiaoThong.sql
> psql -d postgis -h dbhost -U postgres -f LopGiaoThong.sql        where
> dbhost is the host machine of your database.
>
> hope that helps!
>
> ------------------------------
> Date: Tue, 11 Nov 2008 20:14:18 +0800
> From: nguyenquangvinh20052005 at yahoo.com
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Problem in migrating shapefile to postgis
>
>
> 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!
>
>
>
>
> ------------------------------
> Bạn có ý kiến về Mỹ Tâm? Hãy cùng chia sẻ với mọi người tại Yahoo! Việt
> Nam Music
> ------------------------------
> Connect to the next generation of MSN Messenger  Get it now!
> <http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
Thanh Le Viet
GIS Specialist
Oxford University Clinical Research Unit
78 Giai Phong - Ha Noi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081111/a61c8145/attachment.html>


More information about the postgis-users mailing list