ckan / ckan/ideas

Geo-enable datastore/datapusher

Open
#156 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
39
Forks
1
PR merge metrics
No merged PRs in 30d

Description

Suggested via https://twitter.com/timwis/status/631068707955961861

"Do you have any plans to add geospatial queries to DataStore API? I don't see it on the roadmap and surprised no one's asked"

**Datastore**

A possible starting point (and an assumption) is that if the datastore db is postgis, that `datastore_search_sql` will 'just work'. The other action methods would probably need further work (to ensure insertions etc).

**DataPusher**

The real problem is likely the type-guessing in datapusher, it needs to be able to determine that the float it has just found is a lat, or that the string it has is geojson (for example). Perhaps as a first pass this could be done based on convention of column headers? It's a bit fragile but would simplify a first version.

Possibly related to #151

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reading the DataStore API actions, especially datastore_search_sql, alongside DataPusher's type-guessing behavior. The issue leaves the query, insertion, and geospatial type-detection requirements open; done would require an agreed scope and tests covering the selected DataStore and DataPusher behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
api, backend-api-design, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.