Damn typo
3) should be
UPDATE sometable SET new_column = ST_Transform(old_column, new_srid);
-Original Message-
From: [EMAIL PROTECTED] on behalf of Obe, Regina
Sent: Tue 11/11/2008 10:09 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Coordinates transform
Yes. Use ST_T
vinh nguyenquang,
Where did you get this data from? According to the .prj it is in 4326 (WGS 84
degree) like
others have mentioned, but if you actually look at the data, there is no
way it is in degrees since it has points like
484344.9842453949 1480036.13293874
So there is no way that is 4326
Yes. Use ST_Transform.
Basic approach is
1) bring your data in with right SRID
2) Use AddGeometrycolumn to add a new column
http://postgis.refractions.net/documentation/manual-svn/AddGeometryColumn.html
to add a new column with new srid you want to use
3) Update the new column with
UPDATE ne
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
Hi All,
I have a list of longitude / latitude records in TM65 projection which
needs to be transformed into Google Map standard (UTM). Is Postgis proper
tool for that kind of transformations ? I mean .. can I import the data and
then use sql function to transform the data ? If yes could you po
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
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",DA
Hi Vinh,How about the errors displayed when you tried to translate shp
format into postgis?
You can define srid = 32648 or 3405
Hope this help!
2008/11/11 vinh nguyenquang <[EMAIL PROTECTED]>
> Hi, everyone
> Can you help me load LopGiaoThong.shp vao trong postgis? I have problem
> with SRID or s
