BridgeStation

Overview

BridgeStation provides asset management software. Local authorities use BridgeStation to manage highways assets such as bridges and tunnels and any fault reporting that occurs.

Integration with BridgeStation TLDR

• Confirm GeoJSON API endpoint is available and obtain credentials

• Request whitelisting

• Use a Python script to make an authenticated request to the endpoint

• A standard spatial data transformation task is used to import the data into the Spatial Data Warehouse.

Confirm GeoJSON endpoint is available and obtain credentials

BridgeStation will supply a GeoJSON API endpoint URL and an API key.

Request whitelisting

Confirm that BridgeStation allow HTTPS requests from your iShare Studio/iShare Studio ETL server to their GeoJSON endpoint.

Use a Python script to make an authenticated request to the endpoint

The following is a Python script used to download the data from the GeoJSON API endpoint.

• Run the task and confirm the file has downloaded

Create a Program Task in Studio to run the script

Create a program task with the following details. Adjust the location of the configuration file.

Create the Spatial Data Transformation task

Create a mapsource to use the data

Now that the data is loaded into the Spatial Data Warehouse we need to create a mapsource and layer that uses the data. If any classification styling is required it is recommended to load the data into QGIS. Choose categorised styling and export the style SLD file. This can be imported into iShare. Ensure the field that is used for categorised styling is exposed as an attribute field.