All, I hit this earlier in my testing, so I must have had things in the right order at some earlier point in the process.
This : select ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326) as geom, ST_AsText(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)) as geom_text, ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326), 200068)) as geom_city from (select rxtime, split_part(cmd, ',', 3) as part3, split_part(cmd, ',', 4) as part4 from cmdstpinfo where cmd like '>Plot:%') AS first_pass; is producing this (which I did hit early on but thought I had the syntax wrong at the time) : ERROR: transform: couldn't project point (44.9677 -93.1268 0): latitude or longitude exceeded limits (-14) ********** Error ********** ERROR: transform: couldn't project point (44.9677 -93.1268 0): latitude or longitude exceeded limits (-14) SQL state: XX000 This indicates to me that the transform stuff is there , but that it failed. I haven't found many references to this error online. The numbers above are the numbers from the first record in the table. When I hit this earlier, I thought I might be trying to transform against the TEXT (those numbers) object vs the GEOM object (which I'm supposed to use, right??). The result of the ST_SetSRID seems to be the correct type of object to pass to ST_Transform based on what I found in my searches. Maybe I'm not supposed to try the transform in this manner. bobb >>> Mike Toews <mwto...@gmail.com> wrote: On 7 March 2012 06:10, Bob Basques <bob.basq...@ci.stpaul.mn.us> wrote: > ... > ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric, > part4::numeric),4326)), 200068) as geom_city > ... > ERROR: function st_transform(geometry) does not exist > LINE 4: ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa... It looks like "4326)), 200068)" should be "4326), 200068))" -Mike _______________________________________________ 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