[postgis-users] Unprojected lat/long to 3081?

[Aren Cambre]

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 a PostGIS gemoetry field *the_geom* and project
into 3081 at the same time using this:

*UPDATE event_table*
*SET the_geom = ST_SetSRID(ST_Point(event_location[1], event_location[0]),
3081)*

(This derived from the example at
http://postgis.refractions.net/docs/ST_Point.html and reinforced by some
Google searching.)

The problem is when I import this layer into a QGIS project with several
3081-projected layers, all of my event points are ending up in the Pacific
Ocean just off Mexico's west coast. 3081 is a projection for Texas, and
that's where all my other data is.

Am I doing something wrong with the conversion? I assumed that there really
is not a projection *per se* because the input is pure lat/long?

Aren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110203/fae4395f/attachment.html>