Opened 13 years ago

Closed 10 years ago

#974 closed enhancement (wontfix)

Geospatial Foreign Data Wrappers

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 2.2.0
Component: postgis Version: master
Keywords: Cc: mateusz@…, bitner

Description

Now that PostgreSQL 9.1 has produced usable SQL/MED bindings and with raster we now have libgdal dependency. It seems to me we have all the ingredients to make some very slick geospatial data wrappers.

Here is an example from PgCon2011 talk leveraging these bindings:

http://www.pgcon.org/2011/schedule/events/353.en.html

Change History (20)

comment:1 by pracine, 13 years ago

You mean that could be an easy way to implement full support for out-of-db rasters (and out-of-db vectors of course!)?

comment:4 by robe, 13 years ago

Yes that is what I was thinking.

comment:5 by mloskot, 13 years ago

Cc: mateusz@… added

comment:6 by bitner, 13 years ago

Cc: bitner added

comment:7 by nicklas, 13 years ago

Type: defectenhancement

To add more possible fdw-implementations

If fdw can be used against twitter it ought to be possible to use it against a gps-stream.

A fdw catching the data from gpsd.

comment:8 by robe, 12 years ago

This may need to require 9.2+ or higher. They've changed the API quite a bit in 9.2 for FDW to the point that trying to do a bunch of IFDEFs could become painful and most 9.1 FDWs are broken I believe. I got wind of this when I complained to Andrew I couldn't build my favortie FDW anymore on 9.2 and he fixed it but decided to have two parallel branches instead after that.

https://github.com/adunstan/file_text_array_fdw/commit/9d173bc89fef92e280e8803ceca962d7393a7bc5

comment:9 by strk, 11 years ago

Did anyone start on this ? I'm starting to work on a ogr2ogr FWD for both vectors and rasters, with 9.3 min dependency as a focus. Not sure it'd make sense for it to be immediately part of postgis, rather than a separate module (as most FWD are).

comment:10 by robe, 11 years ago

not to my knowledge. I would like it to be part of postgis. Well as a separate extension similar to postgis_topology and postgis_tiger_geocoder that people can choose to or not to install. I figure the biggest group of users for it will already have postgis installed so why package separately :)

comment:11 by robe, 11 years ago

Are you planning to have write support?

comment:12 by strk, 11 years ago

No write support planned initially. The reason for a separate repository would mainly be to be able to have a faster release cycle.

comment:13 by robe, 11 years ago

okay got it or slower release cycle :) so along the lines of point_cloud.

For first version makes sense. I guess we can always decide later to bring it back in.

comment:14 by robe, 11 years ago

Owner: changed from pramsey to strk

comment:15 by strk, 11 years ago

I found this project which may make implementation of an ogr2ogr (or generally GDAL) FDW easier: http://multicorn.org

It basically makes you do that in python…

comment:16 by robe, 11 years ago

I saw that but couldn't get the darn thing to work on windows :(. Perhaps I didn't try hard enough.

comment:18 by robe, 10 years ago

Milestone: PostGIS FuturePostGIS 2.2.0

I knew someone would step up to the plate to do this. Thanks pramsey. I'll be screaming if this doesn't compile on windows :)

https://github.com/pramsey/pgsql-ogr-fdw

comment:19 by robe, 10 years ago

Owner: changed from strk to pramsey

comment:20 by pramsey, 10 years ago

Resolution: wontfix
Status: newclosed

This really isn't a postgis concern, FDW's might work w/ postgis, but postgis doesn't have to do anything to make it happen.

Note: See TracTickets for help on using tickets.