ideas icon indicating copy to clipboard operation
ideas copied to clipboard

Published 20 hours ago • verified publisher icon ckan

JSON/XML data handling

Open timotoots opened this issue 6 years ago • 2 comments

CKAN support for tabular data is much better that for nested data. Is there a point on the roadmap that would enhance support for nested data formats (JSON, XML etc)?

There are some things I am missing for my project built on CKAN:

  1. Previewing JSON and XML in UI like in "Data Explorer".
  2. Previewing GeoJSON from WMS as a map.
  3. Validate JSON data against provided schemas for quality control (maybe in ckanext-validation?).
  4. Convert (flatten) JSON/XML to tabular format for queries with SQL (would need a manual mapping scripts)

What would be the best place to implement this functionality? A separate plugin or try to enhance to current plugins? Or maybe something is planned already?

timotoots avatar Sep 10 '18 13:09 timotoots

Previewing GeoJSON from WMS as a map.

Hi @timotoots, you may want to check out ckanext-geoview and ckanext-agsview.

For agsview, check this sample viz - https://data.boston.gov/dataset/early-voting-locations1/resource/2b28c5ce-cd12-40a4-aef5-d2195e566fa3

jqnatividad avatar Sep 10 '18 13:09 jqnatividad

Hey @jqnatividad! Somehow missed that plugin, looks good! Thanks!

timotoots avatar Sep 10 '18 14:09 timotoots