Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for PostgreSQL hstore #1101

Open
techteam-bln opened this issue Nov 24, 2023 · 0 comments
Open

Support for PostgreSQL hstore #1101

techteam-bln opened this issue Nov 24, 2023 · 0 comments

Comments

@techteam-bln
Copy link

Describe the Feature Request

Support the map like PostgreSQL HStore feature in the SQL feature provider as result type.

Describe the Use Case

While working with OSM data, you can have tag column, with all availabe tags on the features.
As company internal dataprovider, i doesn't know, what tags are interesting for different users and base on the big variety of tags it is not usefull to generate a new cloumn for every tag.
If all tags would be automatic generated into a property , our users can filter this information's in later processes.

Describe Preferred Solution

It would be nice to have a new resultype like "VALUE_MAP"

myTagProperty:
        sourcePath: my_tags
        type: VALUE_MAP
        valueType: STRING

results in:

{
  "type" : "Feature",
  "id" : "1",
  "geometry" : {
    "type" : "Point",
    "coordinates" : [ 7.0, 50.0 ]
  },
  "properties" : {
    "name" : "Beispiel",
    "inspireId" : "https://example.org/id/soziales/kindergarten/1",
    "tags" : {
      "type" : "Kinderbetreuung",
      "href" : "https://inspire.ec.europa.eu/codelist/ServiceTypeValue/childCareService"
      "thoroughfare" : "Beispielstr.",
      "locatorDesignator" : "123",
      "postCode" : "99999",
       "adminUnit" : "Irgendwo"
      "telephoneVoice" : "0211 16021740",
      "typeOfOccupant" : "vorschule",
      "numberOfOccupants" : 20
    } 
  }
}

Additional Information

A additional enhancement would be to queryalbe the hstore columns.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant