GSIP 150

GSIP 150 - Support for jsonb fields in PostGIS tables as FeatureType attributes

Overview

Currently, the jsonb data type is not supported when creating a FeatureType. Any jsonb fields in a PostGIS database will be ignored when creating the FeatureType.

Proposed By

Ben Coleman

Assigned to Release

This proposal is for GeoServer 2.8.0 and later.

State

• Under Discussion
• In Progress
• Completed
• Rejected
• Deferred

Motivation

Implementing this functionality could provide a powerful means for querying data via a CQL Filter. For example, the fields of multiple shapefiles could be serialized as a jsonb field in a single PostGIS table, allowing for storage of data with different schemas in a single table.

Proposal

Add support for jsonb as a FeatureType attribute.

Backwards Compatibility

unknown

Discussion

Voting

Project Steering Committee:

• Alessio Fabiani:
• Andrea Aime:
• Ben Caradoc-Davies:
• Brad Hards:
• Christian Mueller:
• Ian Turton:
• Jody Garnett:
• Jukka Rahkonen:
• Kevin Smith:
• Simone Giannecchini:

Links