Ticket #229 (closed enhancement: fixed)
shp2pgsql ability to transform from one spatial ref to another
|Reported by:||robe||Owned by:||jadams|
I'm thinking this is a very simple thing to add to have another switch that allows a user to transform from the native spatial ref of the data to the desired spatial ref. (of course if they want this, they would be obliged to specify a from and a to similar to ogr2ogr)
If the -s and whatever switch for to (maybe a -t) is specified, then we add an ST_Tranform call to the insert/copy. Or am I making this sound simpler than it is.
Would save me a bit of hassle, though no one has complained about it. I'm also thinking it might be more important when we have geography --- if you get state plane data or something of that sort (that you commonly get on state sites), then you'll want to transform it to 4326 before feeding into geography.