Hi Aren,
In this sort of case I usually prefer to keep my source data as a reference, as
well as an indexed reprojected (working) version of the geometry. Instead of
doing it as you have done, and create a new table, I add a new geometry column
of the appropriate type & SRID to the original ta
Thank you. Now my shp2pgsql conversion results in a PostGIS table with an
SRID. I then ran this query to reproject the data into a new table:
*INSERT INTO txdot_roadways_3081_transform*
*SELECT [all other fields go here], ST_Transform(the_geom, 3081) as the_geom
*
*FROM txdot_roadways;*
Loading in
Right, use 4269, that's a good NAD83-geographic-coordinates number.
Import with shp2pgsql -s 4269 and go from there.
P
On Mon, Dec 27, 2010 at 3:54 PM, Aren Cambre wrote:
> Brent and Paul,
> Thank you for your help!
> So here's my (new) dilemma--my PostGIS table doesn't appear to have a
> projec
Brent and Paul,
Thank you for your help!
So here's my (new) dilemma--my PostGIS table doesn't appear to have a
projection specified, and I am not clear how to get to one.
I don't think it has a projection because this table's corresponding entry
in the *geometry_columns* table has *-1* for the *