You are confusing setsrid with transform. Remember setsrid - doesn't change the geometry it simple certifies that a geometry is of a particular projection - basically
I am because I say I am Transform - moves a geometry from one projection to another I am not , but please make me so. Of course the please make me so will fail if you don't know what it is to begin with So all being said, your statement 2 is wrong and should be update izmir_il4 set the_geom=Transform(the_geom,32635); Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of orkun Sent: Friday, May 16, 2008 4:00 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] couldn't get the correct projected values hello whatever I have done, I couldn't get the correct projected values in postgis environment. 1. # lon/lat to utm projection create table izmir_il4 as select gid,il_kod,iladi,transform(the_geom,32635) as the_geom from il_izmir3; 2. update izmir_il4 set the_geom=setsrid(the_geom,32635); 3. select extent(the_geom) from izmir_il4; extent -------------------------------------------------------------------------- BOX(26.2226982116699 37.8668251037598,28.4587249755859 39.3925666809082) but these are not utm values. They are still in lon/lat values I checked extent values with proj values. I got correct values: echo "26.2226982116699 37.8668251037598" | proj +proj=utm +zone=35 +ellps=WGS84 +datum=WGS84 431631.23 4191323.84 [EMAIL PROTECTED]:/usr/local/izmir/veri/izmir3$ echo "28.4587249755859 39.3925666809082" | proj +proj=utm +zone=35 +ellps=WGS84 +datum=WGS84 625615.27 4361356.53 how can get values generated from "proj" in postgis environment ? what am I doing wrong ? here is the srid values of 32635 : 32635 | +proj=utm +zone=35 +ellps=WGS84 +datum=WGS84 +units=m +no_defs regards -- Ahmet Temiz Jeo. Müh. Afet Isleri Gen. Md.lügü Deprem Ar. D. Ahmet Temiz Geo. Eng. General Dir. of Disaster Affairs -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
