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 <[email protected]>
>To: PostGIS Users Discussion <[email protected]>
>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
>[email protected]
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
