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 ...

    • OS PSGA WMS/WFS Feeds

      If your subscription includes it, OS Mapping is available via our own web services. The URL's are: Service URL WMS https://feeds.xmap.cloud/wms WFS https://feeds.xmap.cloud/wfs If your subscription includes access to these services, you will be ...

    • Changelog

      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), ...

    • Web Service Compatibility

      There are various ways to access WMS/WFS data depending on your requirements. Public Access: To make a public WMS/WFS feed WITH attributes/columns, in the admin panel go to: DATA >> LAYERS and find the layer that you want to make Public. Set the ...