Mike,
Thanks!
On Wed, Oct 27, 2010 at 1:17 AM, Mike Toews wrote:
> Ah, you are looking for this:
>
> http://postgis.refractions.net/docs/ST_Transform.html
>
> So you need to cast your object as a polygon, set the SRID to your
> projected coordinate system (I'm just guessing SRID=29181 for your
>
Ah, you are looking for this:
http://postgis.refractions.net/docs/ST_Transform.html
So you need to cast your object as a polygon, set the SRID to your
projected coordinate system (I'm just guessing SRID=29181 for your
example http://spatialreference.org/ref/epsg/29181/ .. look up the
SRID for you
Mike,
Yes, I mean georeferenced (sorry for my English). I made a cast to text and
converted to postgis geometry, but I couldn't use ST_SetSRID.
I would like to tranfer a polygon to correct position. I have a
Polygon "BOX(743295.3125 7182512.5,744414.75 7183817.5)" and I like to
transfer it to "BOX(
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
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
