Hi Wagner, I'm not sure what you mean by "geo" and "non-geo" .. you mean georeferenced, like longitude/latitude?
For points, you can keep thing binary and just use ST_MakePoint(x,y). And to assign a coordinate system, use it with ST_SetSRID: SELECT ST_SetSRID(ST_MakePoint(p[0], p[1]), 4326) from ( select point '(-123.112793, 49.246293)' as p ) as foo; I'm not sure how to do similar binary conversions for path and polygon, or other types. You might have to cast to text, and wrangle it into some form of WKT, then pass it to ST_SetSRID(text, integer) to make a geometry object for PostGIS. -Mike On 26 October 2010 18:17, Wagner Santos <wagner.des...@gmail.com> wrote: > I created a Postgis Geometry from Postgres Polygon converting them from > string and using linefromtext to create a geometry but this information > isn't geo. > I have non geo points and I want to convert to my correct position and set > SRID, for example P(70 72) to P(-54 -25), how can I do this? > Thanks! > > On Tue, Oct 26, 2010 at 1:18 PM, Wagner Santos <wagner.des...@gmail.com> > wrote: >> >> Hello, >> I'm new with postgis and I have a legacy database with Postgres Polygon, I >> want to convert this to a Postgis Geometry. Is there a way? >> I try to do with replace string and linefromtext with sucess, but I think >> doesn't better solution because I can't set a valid SRID. >> Thanks! > > _______________________________________________ > 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
