[ckan-dev] "Geo"-Datastore?

Dominik Moritz dominik.moritz at okfn.org
Tue Jan 8 21:41:58 UTC 2013


Hi Christoph,

At the moment, the DataStore does not support PostGIS and there are no plugin hooks into the DataStore. We have actually had a discussion about this matter some time ago but there were not enough requests for this feature. However, if you plan to add this functionality to the datastore, I'd be very happy to help you find your way around in the code.
The last option (modifying the datastore extension) is certainly the best option and it shouldn't be too difficult to add the missing column types and the code to add the columns. 

Best wishes,
Dominik

On 8 Jan 2013, at 20:11, Ryan Clark <ryan.clark at azgs.az.gov> wrote:

> I'm working on a project that will involve users uploading .csv files containing lat/lng columns. The goal is to accept these uploads and put the data into PostGIS tables which will be exposed through Geoserver as WMS/WFS layers. 
> 
> The way I see it, the Datastorer -> Datastore chain already takes care of most of what needs to be done, minus two important aspects:
> Need to create a PostGIS geometry column in the PostgreSQL table currently built by the Datastore extension
> Need to convert lat/lng columns into WKT or WKB formats to be loaded into the PostGIS geometry column
> Configure Geoserver to look at that table (but I'm not worried about this just yet)
> 
> What I'm struggling with is trying to find the right way to bundle this functionality as an extension. I tried to follow the Datastore function chain through, from the JSON POSTed to .../dataset_create until the data is loaded into a PostgreSQL table. It didn't appear that there were any plugin hooks in the chain that could be used to accomplish these two extra tasks. 
> 
> Does anyone have any good ideas where I might be able to hook in? Its very possible I missed something, or perhaps there is some other plugin interface that I should consider?
> 
> My last ditch effort would involve modifying the Datastorer extension to POST to my own URL, and mimic Datastore functionality there, plus my geo-extras. Another option could be to modify the Datastore extension and plant my own plugin hooks.
> 
> Thanks!
> ____________________
> 
> Ryan Clark
> ryan.clark at azgs.az.gov
> (520) 302-4871
> 
> 
> 
> 
> 
> 
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev





More information about the ckan-dev mailing list