DOI: 10.6084/m9.figshare.14006138
title: Speedtest (Download Performance) vs NBN (Technology Maps)

description: This dataset merges two public datasets:- Speedtest network performance data for Australia (Q3, 2020), as loaded to AURIN geo-analysis platform (88,000 approx locations)- NBN mapping of Technology data (inc FTTN, FTTP, FTTC, FTTB, HFC, Wireless, Satellite); complete map of Australia, colour-coded by technology, in WMS or KML format. KML format used in this instance.<br>to produce an intersection datasets (Result: 319337 rows × 26 columns), including: <br>- data includes LocID, download speed, nbn tech, lat, Lon, SA2, SA3, SA4 (see ABS link below).But many techs in one Speedtest block (600m^2) so have to untangle.- a ten line sample (CSV) included.- see image as provided by AURIN - QGIS.png.<br>** Versionsv2.Load updated Jupyter Notebook v1.1 and locations csv, which shows location breakdown by NBN Technology (pivot table export).v1. Initial load, including Jupyter Notebook and human readable, geojson.<br>** METHOD: Advice from AURIN:<br>In order to join these two maps, you will need to perform a spatial join based on the two layers. It is possible to do this with geopandas.sjoin(), which by default performs an intersection join - that is, any portion of a matching polygon from the second layer is considered a match to join on. More information about spatial predicates is here in case you're looking for a different spatial relationship.<br>In this link, I've supplied a notebook (OoklaNBN-AURIN.ipynb) that collects the datasets from the AURIN API and data.gov.au, combines the several KML NBN layers into one, and joins them with the Ookla 2020 Q3 dataset. In order to use it, you will first need to input your AURIN API credentials into the first cell.<br>The spatial join occurs in the final notebook cell and writes its output to a geopackage (OoklaNBN.gpkg) which I've included also, as the script can take some time to run. You will notice that each Ookla cell now may be represented by many records, this is due to there being more than one overlapping NBN technology polygon. As one Ookla grid can cover many technology zones, aggregating these may be useful depending on how you approach your analysis.Regards AURIN.<br>The authors acknowledge the facilities and scientific and technical assistance of the NCRIS-enabled Australian Urban Research Infrastructure Network (AURIN)”Thanks Evan Thomas, AURIN - ORCiD: https://orcid.org/0000-0001-7564-4116<br>*** Preliminary Analysis1. Count of Tech TypeTech countFibre to the Basement (vectored or non-vectored) 14147Satellite 15946Fixed Wireless 23663Fibre to the Curb 36843Hybrid Fibre Coaxial (HFC) 41175Fibre to the Premises 93732Fibre to the Node 93831<br><br>2. Mean of Tech TypeNBN Tech Type Aus mean(mbps)Satellite 48.1674 Fixed Wireless 49.1477 Fibre to the Node 75.1639 Fibre to the Premises 83.71 Fibre to the Curb 86.8433 Hybrid Fibre Coaxial (HFC) 87.1248 Fibre to the Basement (vectored or non-vectored) 116.324<br>*** Licence;Speedtest licence (at AWS data licence) is "CC BY-NC-SA 4.0", so use of this data must be:- non-commercial (NC)- reuse must be share-alike (SA)(add same licence).This restricts the standard CC-BY Figshare licence.<br>