Bob, can you try something like this? select st_astext(st_setsrid(st_geomfromtext('POINT(-48 -19)'),4326)) as "wgs84", st_astext(st_transform(st_setsrid(st_geomfromtext('POINT(-48 -19)'),4326),29192)) as "sad69-utm22"
Here are my results: "POINT(-48 -19)" ; "POINT(815865.331177955 7896471.32478341)" Looking at your coordinates, I see a -93.1268 as latitude. Perhaps the input needs a little validating? On Tue, Mar 6, 2012 at 4:25 PM, Bob Basques <bob.basq...@ci.stpaul.mn.us>wrote: > 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 > > -- George R. C. Silva Desenvolvimento em GIS http://geoprocessamento.net http://blog.geoprocessamento.net
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users