<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div>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.</div><div><br></div><div>Phil</div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-size: 12pt; font-family: 'Courier New', courier, monaco, monospace, sans-serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Jan Peters <petersjan@gmx.at><br><b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion
<postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Sent:</span></b> Monday, 7 November 2011, 17:47<br><b><span style="font-weight: bold;">Subject:</span></b> [postgis-users] Problem after reprojecting: Extent: BOX(inf inf, inf inf)<br></font><br>Sorry for posting in a reply last time:<br><br>Dear all,<br>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:<br><br>CREATE TABLE table_31259 AS <br>SELECT <br>table_4326.id,<br>ST_Transform(the_geom,31259) AS the_geom <br>FROM table_4326;<br><br>which had already been working for other tables, but the newest tables seem to resist correct projection because when I run <br><br>select ST_extent(table_4326.the_geom)<br>FROM table_4326;<br><br>I get:<br><br>st_extent:<br>BOX(4130129.75
-3197344.75,4439015 -2797768.25) /*which is correct*/<br><br>after projecting the data to EPSG:31259 I get:<br><br>st_extent:<br>BOX(inf inf,inf inf) /*which means there is obviously something wrong*/<br><br>Do I miss something here? I also tried to update the SRID in table_4326 like:<br><br>SELECT updategeometrysrid('table_4326', 'the_geom', 4326);<br>and then:<br>SELECT setsrid(the_geom, 4326) from table_4326;<br><br>and after that projecting the data to EPSG:31259 again, so there must be something going fundamentally wrong I fear. <br><br>Thanks for any replies<br>Jan<br><br>-- <br>NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! <br>Jetzt informieren: <a href="http://www.gmx.net/de/go/freephone" target="_blank">http://www.gmx.net/de/go/freephone</a><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br></div></div></blockquote></div></div></body></html>