|

»

[PostGIS] #229: shp2pgsql ability to transform from one spatial ref to another

View: New views

6 Messages — Rating Filter: Alert me

	[PostGIS] #229: shp2pgsql ability to transform from one spatial ref to another by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #229: shp2pgsql ability to transform from one spatial ref to another -------------------------+-------------------------------------------------- Reporter: robe \| Owner: pramsey Type: enhancement \| Status: new Priority: medium \| Milestone: postgis 1.5.0 Component: postgis \| Version: trunk Keywords: \| -------------------------+-------------------------------------------------- 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. -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/229> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #229: shp2pgsql ability to transform from one spatial ref to another by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #229: shp2pgsql ability to transform from one spatial ref to another --------------------------+------------------------------------------------- Reporter: robe \| Owner: pramsey Type: enhancement \| Status: closed Priority: medium \| Milestone: postgis 1.5.0 Component: postgis \| Version: trunk Resolution: wontfix \| Keywords: --------------------------+------------------------------------------------- Changes (by pramsey): * status: new => closed * resolution: => wontfix Comment: I think we'll always have more important things to do. For people who need this functionality operationally, there's ogr2ogr. -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/229#comment:1> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #229: shp2pgsql ability to transform from one spatial ref to another by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #229: shp2pgsql ability to transform from one spatial ref to another --------------------------+------------------------------------------------- Reporter: robe \| Owner: pramsey Type: enhancement \| Status: reopened Priority: medium \| Milestone: postgis 1.5.0 Component: postgis \| Version: trunk Resolution: \| Keywords: --------------------------+------------------------------------------------- Changes (by robe): * status: closed => reopened * resolution: wontfix => Comment: Well ogr2ogr doesn't support geography yet and I still prefer the dbf handling ability of shp2pgsql over that of ogr2ogr. My thinking for this was more of the usecase geometry (of stateplane/nad../utm) -> directly convert to geography and for that you will have to write transform glue anyway is my understanding so why not offer the same logic for those who want to transform on the fly. When you are trying to load up all of tiger -- its really nice to have that be a one step process. Instead of load --> transform -> drop column -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/229#comment:2> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #229: shp2pgsql ability to transform from one spatial ref to another by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #229: shp2pgsql ability to transform from one spatial ref to another --------------------------+------------------------------------------------- Reporter: robe \| Owner: pramsey Type: enhancement \| Status: reopened Priority: medium \| Milestone: postgis 2.0.0 Component: postgis \| Version: trunk Resolution: \| Keywords: --------------------------+------------------------------------------------- Changes (by pramsey): * milestone: postgis 1.5.0 => postgis 2.0.0 Comment: Without a native SRTEXT handler, this isn't going to happen. Remember that shp2pgsql has no access to the spatial_ref_sys table so it would have to handle the SRTEXT in the .prj file itself. Basically, if we make shp2pgsql depend on OGR, then we could do it. At which point... maybe we drop our shp2pgsql code more-or-less entirely and replace it with an OGR-based loader? -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/229#comment:3> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #229: shp2pgsql ability to transform from one spatial ref to another by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #229: shp2pgsql ability to transform from one spatial ref to another --------------------------+------------------------------------------------- Reporter: robe \| Owner: pramsey Type: enhancement \| Status: reopened Priority: medium \| Milestone: postgis 2.0.0 Component: postgis \| Version: trunk Resolution: \| Keywords: --------------------------+------------------------------------------------- Comment (by robe): I suppose that wouldn't work in copy mode. I guess I was thinking about the sql insert mode and that we would do something like INSERT INT.... ST_Transform(goemhere, 4326) In which case the not having spatial_ref_sys access is kind of a non-issue since psql will have such access -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/229#comment:4> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #229: shp2pgsql ability to transform from one spatial ref to another by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #229: shp2pgsql ability to transform from one spatial ref to another --------------------------+------------------------------------------------- Reporter: robe \| Owner: pramsey Type: enhancement \| Status: reopened Priority: medium \| Milestone: FUTURE Component: postgis \| Version: trunk Resolution: \| Keywords: --------------------------+------------------------------------------------- Changes (by pramsey): * milestone: postgis 2.0.0 => FUTURE -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/229#comment:5> PostGIS <http://trac.osgeo.org/postgis/> The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project. _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel