[postgis-users] Problem after reprojecting: Extent: BOX(inf inf, inf inf)

[Phil James]

The coordinates you get from extent do not look like WGS84 (lat/lon) which is EPSG code 4326.  Are they UTC zone 33N (which covers Austria?).  If the original projection is incorrect this would explain the inf results from ST_TRANSFORM.

Phil



>________________________________
>From: Jan Peters <petersjan at gmx.at>
>To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>Sent: Monday, 7 November 2011, 17:47
>Subject: [postgis-users]  Problem after reprojecting: Extent: BOX(inf inf, inf inf)
>
>Sorry for posting in a reply last time:
>
>Dear all,
>I am a bit stuck: I just encountered that some of my PostGIS datasets were defined as EPSG:31259 in the geometry_colums table, but the geometry data was actually EPSG:4326. Now I wanted to project this data from 4326 to 31259 via:
>
>CREATE TABLE table_31259 AS 
>SELECT 
>table_4326.id,
>ST_Transform(the_geom,31259) AS the_geom  
>FROM table_4326;
>
>which had already been working for other tables, but the newest tables seem to resist correct projection because when I run 
>
>select ST_extent(table_4326.the_geom)
>FROM table_4326;
>
>I get:
>
>st_extent:
>BOX(4130129.75 -3197344.75,4439015 -2797768.25) /*which is correct*/
>
>after projecting the data to EPSG:31259 I get:
>
>st_extent:
>BOX(inf inf,inf inf) /*which means there is obviously something wrong*/
>
>Do I miss something here? I also tried to update the SRID in table_4326 like:
>
>SELECT updategeometrysrid('table_4326', 'the_geom', 4326);
>and then:
>SELECT setsrid(the_geom, 4326) from table_4326;
>
>and after that projecting the data to EPSG:31259 again, so there must be something going fundamentally wrong I fear. 
>
>Thanks for any replies
>Jan
>
>-- 
>NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!        
>Jetzt informieren: http://www.gmx.net/de/go/freephone
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111107/4f8e7389/attachment.html>