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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
