publicdata.au publicdata.au on GitHub

Traffic camera locations, ACT, version 2026-10-29

latest
Rows 1,283Fields 8Fetched 2 November 2026Source SHA-256 69453548cf66fce9…

This version is kept for as long as this site exists, and its URL can be cited. Its files change only for the reasons the terms give, and each change is recorded in its notes. The publisher's file is here as source.csv, byte for byte.

Files

  • data.csv171 KB CSV: UTF-8 without a byte-order mark, RFC 4180 quoting, one header row using the normalised field names. Opens in Excel, Numbers and Sheets.
  • data.csv-metadata.json2.6 KB
  • data.csv.gz38 KB CSV (gzip): The same CSV, gzipped, at about a tenth of the size. curl, pandas, DuckDB and R read it directly.
  • data.duckdb DuckDB: One DuckDB database with a records table of typed columns, a fields table and a publicdata metadata table. It attaches read-only over HTTPS, so DuckDB, Python and R can query it without downloading it.
  • data.geo.parquet65 KB GeoParquet: the Parquet table with a WKB geometry column and its coordinate system in the file's geo metadata. Reads directly in DuckDB, GeoPandas, QGIS and GDAL.
  • data.geojson474 KB GeoJSON: A FeatureCollection with one Point per row and every field as a property. Rows without coordinates have a null geometry. Ready for QGIS, Leaflet, MapLibre and geopandas.
  • data.gpkg307 KB GeoPackage: A GeoPackage with one point layer, records, in the publisher's coordinate system, plus the fields and publicdata tables. Drag it into QGIS or ArcGIS.
  • data.json351 KB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 1,283 objects with typed values. Blank cells are null.
  • data.ndjson349 KB NDJSON: The first line is the provenance header, then one JSON object per line. For streaming and for tools that read line by line.
  • data.parquet60 KB Parquet: Columnar and typed. The smallest download and the fastest to query. Reads directly in DuckDB, pandas, Polars, Arrow and Spark. The provenance header is in the file metadata.
  • data.sqlite193 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx86 KB Excel: One workbook with a records sheet of 1,283 typed rows, a fields sheet and a publicdata sheet with the provenance. Dates are real Excel dates. Opens in Excel, Numbers, LibreOffice and Sheets.
  • manifest.json1.7 KB
  • schema.json1.2 KB
  • schema.sql954 B
  • source.csv163 KB

SHA256SUMS holds the SHA-256 of every file in this version under the name it downloads as. Check what you downloaded with sha256sum -c --ignore-missing SHA256SUMS in the same folder. On a Mac, use shasum -a 256 -c --ignore-missing SHA256SUMS. Each list is signed by the deploy that wrote it: gh attestation verify SHA256SUMS --repo National-Digital/publicdata.au --source-ref refs/heads/main shows it came from this project's main branch.

Smaller files by field: by/camera_type/.

Change from 2026-08-21

1,262 rows in 2026-08-21 and 1,283 in this version. No key is declared, so rows are compared by count only. The comparison is in diff/2026-08-21..2026-10-29.json.

Attribution the licence asks for

Access Canberra, ACT Government, Traffic speed camera locations, https://www.data.act.gov.au/d/426s-vdu4, accessed 2 November 2026, licensed under CC BY 4.0.

Provenance

Fetched from www.data.act.gov.au on 2 November 2026. The portal listed the licence as Creative Commons Attribution 4.0 International at that moment. manifest.json has every detail.

012342002 MOBILE SPEED CAMERA: 220022007 MOBILE SPEED CAMERA: 220072008 MOBILE SPEED CAMERA: 420082009 MOBILE SPEED CAMERA: 220092016 MOBILE SPEED CAMERA: 22016 POINT TO POINT CAMERA: 220162017 MOBILE SPEED CAMERA: 320172020 MOBILE SPEED CAMERA: 320202022 MOBILE SPEED CAMERA: 22022
MOBILE SPEED CAMERAPOINT TO POINT CAMERA
Camera locations decommissioned per year by camera type, 2002 to 2022. 2001 is not drawn because the rows begin on 1 April 2001. 2024 is not drawn because the rows run to 1 October 2024. A count of rows in this version, worked out in the build.
Change from the version before

1,262 rows before, 1,283 now

Against 2026-08-21. No key is declared, so rows are compared by count only. The comparison is in diff/2026-08-21..2026-10-29.json.

Other versions: 2026-08-21.