[postgis-users] couldn't get the correct projected values

[orkun]

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
orkun at orkun-desktop:/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 İşleri Gen. Md.lüğü
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.