Before you begin

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 to access source tables and to create the necessary schema, tables, functions and user for Hub to function. 

Data:

To utilise the Hub APIs and Channels the customer will require the necessary source data/tables for the API to be available within the same PG instance.

UPRN: Waste:Collection and Elections:Polling Place Hub APIs require the data to contain a UPRN. If your UPRNs contain a leading zero then this will need to be removed. Geoxphere will be able to provide the SQL to do this. 

Geometry:  Other than the Waste:Collection and Elections:Polling Place Hub APIs, all other APIs require the source data to contain a geometry column and geometry values. The source project is irrelevant as this will be reprojected to 27700 in the Hub View. 

Recommendations:

Software:

We would recommend having access to either Dbeabver or PG-admin so that you can update, copy, modify or create your own Hub APIs.  

SQL:

While it is not necessary to be proficient in PG SQL it is an advantage. Geoxphere will provide SQL snippets and examples of Hub APIs, as well as provide full support and training. 

    • Related Articles

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

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

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

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