I have a database containing a Postgres native point data type *event* that
has the latitude and longitude for certain events. An example value of *
event* is *(32.7748777996749,-96.7680574022233)*. Note: this is *not* a
PostGIS data type. It's a native Postgres type.
I tried to convert this into
EPSG 3081 is a metre projection, so you need to transform your points from
lat long into the appropriate projection. Try something like this:
*UPDATE event_table*
*SET the_geom = ST_Transform(ST_SetSRID(ST_Point(event_location[1],
event_location[0]), 4326), 3081)
*
This assumes your input
Thank you. That was it!
I did some more online reading and finally realized I'm dealing with a
conversion from a spherical projection to Cartesian.
Aren
On Thu, Feb 3, 2011 at 7:24 PM, Francis Markham fmark...@gmail.com wrote:
EPSG 3081 is a metre projection, so you need to transform your