stephen-gates / service-locations

An experiment repackaging service location data

Service Locations

An experiment in packaging location data

Aim

The aim of this repository is to:

• recommend new ways to publish location data on data.qld.gov.au
• provide feedback on the Open Knowledge Spatial Data Package Investigation recommendations to the Frictionless Data specification.

Background

There are many tabular location datasets published on data.qld.gov.au, that describe location using:

• points (longitude and latitude coordinate pairs)
• boundary identifiers or names

These datasets could be linked to spatial boundary data.

Service location point data

A subset of point location datasets describe service locations, e.g. the locations of hospitals, schools and fire stations.

These are not published in a consistent way making it hard to combine the data. Some location datasets also include services available at the location and opening times, e.g. Transport and motoring customer service centres.

Some datasets are messy e.g.

• missing column headers
• column headers with no dataset
• inconsistent data types in columns
• markdown in columns
• html fragments in column to support a specific use case

In some cases these datasets drive the display of service locations on qld.gov.au. While it's great to see organisations using their own open data to deliver information, this should not be at the expense of others wanting to use the same information.

This repository for point data:

• collects service location point data from data.qld.gov.au
• analyses the headers in the source data and groups common headers to help design a template.
• suggests a template to capture service location and related data. The template uses the recommendations from the Spatial Data Package Investigation and explores refinements discussed on the Open Knowledge Forum
• repackages the service location data into point data data packages in line with the recommendations

Linked Boundary data

This repository for linked boundary data:

• collects csv files with a link to boundaries and repackages the linked boundary data into data packages that reference spatial boundary data

Non-spatial Boundary data

This repository for non-spatial boundary data:

• collects boundary names and packages then so they can be used to validate boundary names in other csv files.

Spatial Boundary dataset

This repository for spatial boundary data:

• converts the data to GeoJSON
• packages the data into data packages in line with the recommendations

Data Validation

Based on the validation settings in goodtables.yml the tabular data is

Software

As highlighted in the User Stories, Software is needed to implement spatial functions for discovering, validating and displaying:

• point data
• boundary data
• boundary-linked data

References

As part of the work we will also explore leveraging existing concepts, data, and services, e.g.

• When are open (geospatial) identifiers useful?
• persistent resolvable identifiers
• Place names gazetteer - Queensland
• Services
• Property Location Service Plus- Queensland Government version
• data versioning and spatial data versioning
• UK standards
• OpenBanking Branch API Specification - v2.1.1

service-locations's Issues

Add old versions of boundary data

to demonstrate how referring to different data package versions would work

+

service-locations/boundary-linked-data-user-stories.md

Lines 1 to 6 in 4213245

	@todo
	# Boundary-linked Data User Stories
	## Describe boundary-linked data

---

This issue was generated by todo based on a @todo comment in 4213245. It's been assigned to @Stephen-Gates because they committed the code.

write /template/service-locations/README.md

service-locations/README.md

Lines 40 to 45 in e10720a

	- analyses the [headers in the source data](/template/header-analysis.csv) and [groups common headers](/template/header-grouping.xls) to help design a template.
	- suggests a [template](/template/service-locations/) to capture service location and related data. The template uses the recommendations from the Spatial Data Package Investigation and explores [refinements discussed on the Open Knowledge Forum](https://discuss.okfn.org/t/geo-data-package/6143/25)
	- repackages the service location data into [data packages](/datapackages/) in line with the recommendations
	### Linked Boundary data

---

This issue was generated by todo based on a @todo comment in e10720a. It's been assigned to @Stephen-Gates because they committed the code.

update repo readme with software required from user stories

Can't add CSV file to Queensland Globe

Tried adding QRide data to Queensland Globe and got

Warning: "https://raw.githubusercontent.com/Stephen-Gates/service-locations/master/point-data/171027qrideprovidersa.csv" has not been added: Invalid or Unsupported url