GeoTools

Publish table description information

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: 2.7.5
  • Component/s: jdbc-postgis plugin
  • Labels:
    None

Description

This is a simple request: if the table or column description information has been filled in - publish this description (somehow) through the geotools api.

There are two good candidates:

  • DataStore.getInfo and DataStore.getInfo( Name ) to retrieve database and table descriptions
  • AttributeDescriptor for column description information; even if we need to make use of the user properties for the short term

We should be able to communicate:

  • display name --> title
  • description --> abstract

The driver for this bug report is the CCIP integration showcase where MarkLeslie has filled in all the table descriptions in the PostGIS database; and a lot of the column descriptions as well. It would be good to leverage this work as default descriptions; rather than copying and pasting the text out of pgAdmin.

Issue Links

Activity

Hide
Justin Deoliveira added a comment -
I imagine this will come across through JDBC through the REMARKS attribute in both database and result set metadata. So yeah, it would be easy enough to hook up. Hooking it up to DataStore.getInfo() seems relatively straight forward, but what about for AttributeDescriptor? Oh you mention user properties in the original description. Yeah, makes sense.

Show
Justin Deoliveira added a comment - I imagine this will come across through JDBC through the REMARKS attribute in both database and result set metadata. So yeah, it would be easy enough to hook up. Hooking it up to DataStore.getInfo() seems relatively straight forward, but what about for AttributeDescriptor? Oh you mention user properties in the original description. Yeah, makes sense.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated: