Creating Hub Open Data feeds

Creating Hub Open Data feeds

Populating the Source table:

To published a new Open-Data set to the Hub Open-Data pages you need to update the gx_hub.open_data source table. There are various ways to do this either through Dbeaver, PG-Admin or QGIS. Please contact your Account Manager to discuss the best method for you to update this. 

Update the following columns:
  1. od_name: This is the title of the data being published e.g Conservation Areas (Designated)
  2. od_description: A brief description of the dataset to be published. e.g Designated Conservation Areas, as listed in the 2023-2030 Adopted Local Plan for Mappington District Council. 
  3. od_layerid: This is used to create the file name for downloads. This must be in lowercase and spaces replaced with underscores. e.g conservation_areas_mdc
  4. od_web_feed: IMPORTANT! In you wish to list the URLs to WFS/WMS feeds then this needs to be populated with the XMAP layer ID, and the table needs to be made public in XMAP. e.g conservation_areas
  5. od_date_published: Used within the final API to inform users of when this data was first published by the council (Optional)
  6. od_date_updated: Used within the final API to inform users of when this data was last updated by the council (Optional)
  7. od_source_table: Include the schema.table details of the source table for this Hub View. This is used to automate the updates/republish of data. 
  8. od_source_table: This is a boolean (true/false) value that needs to be set to true so that it can be published as a Open-Data Hub API. Before setting to true, please contact Geoxphere to make sure that XMAP is configured correctly to publish your Open Data layers. 
  9. od_published: Once set to TRUE this will update the Hub Open-Data page with information on the Open-Data layer. 

How to disable or remove an Open-Data Feed:

To disable an entry on the Open Data page set the od_published field to FALSE.
To remove an entry the row needs to be deleted, please contact your Account Manager to discuss the best method for you to do this.

Before you begin:

Make sure that you have contacted Geoxphere prior to publishing new Open-Data feeds after the initial setup of the feeds. 

    • Related Articles

    • Hub Overview

      Hub is a fully hosted web application that gives residents access to property specific information, access to download Open-Data and the ability to find interactive maps quickly. Fully responsive and accessibility compliant, Hub is built on the ...

    • Creating Hub Maps links

      Populating the Source table: To published a new link on the Hub Maps page you need to update the gx_hub.open_maps source table. There are various ways to do this either through Dbeaver, PG-Admin or QGIS. Please contact your Account Manager to discuss ...

    • Details of change

      August 2024: Hub webpages: Greater ability to customise Headings and Sub-Headings Ability to customise breadcrumbs and Quick Links Hub Channels: Addition of TPO, Heritage and Environment Channels Hub APIs: Addition of new APIs for TPO (TPO channel), ...

    • Before you begin

      Prerequisites: Postgres/PostGIS: For customers to use Hub they are required to have a PostGIS (PG) instance, running at a minimum of version 16. If a customer is hosting the PG instance themselves then Geoxphere will require additional admin rights ...

    • Overview of Views

      Summary: This article covers the concept of Hub Views and how they relate to the source table of data. If you are not familiar with Postgres views, then we would recommend having a read of this article, but as part of the Hub implementation we will ...