search

LukePrior / nbn-upgrade-map

Interactive map showing premises eligible for the NBN FTTP upgrade program.
https://lukeprior.github.io/nbn-upgrade-map/
MIT License
100 stars 11 forks source link

Create tallies of the different NBN property details #298

Open lyricnz opened 7 months ago

lyricnz commented 7 months ago

Per https://github.com/LukePrior/nbn-upgrade-map/issues/285#issuecomment-1793762830

Create a set of tallies of the additional properties in the NBN results. For example:

   "properties": {
    "name": "UNIT 2, 10 CLARINDA STREET SOMERVILLE 3912",
    "locID": "LOC000073574183",
    "tech": "FTTN",
    "upgrade": "FTTP_SA",
    "gnaf_pid": "GAVIC412300078",
    "tech_change_status": "Eligible To Order",
    "program_type": "On-Demand N2P SDU/MDU Simple",
    "target_eligibility_quarter": "NA"
   }

Exclude the unique-per-address ones (name, locID, gnaf_pid).

lyricnz commented 7 months ago

Removed - updated below.

lyricnz commented 7 months ago

@LukePrior what do you want to do with this data? (it's currently incomplete around the new fields)

lyricnz commented 7 months ago

Updated PR to add percent section, and add placeholder "None" values where the property was not specified, to help identify incomplete data/coverage.

{
 "tech": {
  "FTTP": 2943258,
  "FTTN": 4490662,
  "NULL": 380519,
  "SATELLITE": 650276,
  "HFC": 2892106,
  "FTTC": 1688757,
  "FTTB": 650699,
  "WIRELESS": 976890
 },
 "upgrade": {
  "NULL_NA": 8185879,
  "UNKNOWN": 1523402,
  "FTTP_NA": 2717253,
  "FTTN_CT": 42068,
  "FTTP_SA": 2195559,
  "FTTC_CT": 2873,
  "FTTB_CT": 493,
  "SAT_CT": 3155,
  "FW_CT": 2046,
  "FW_NA": 309,
  "HFC_CT": 124,
  "FTTN_NA": 5,
  "FTTC_NA": 1
 },
 "tech_change_status": {
  "Not Planned": 239028,
  "In Design": 433232,
  "Committed": 622095,
  "Previous Tech Disconnected": 90203,
  "Eligible To Order": 1099763,
  "Planned": 7778,
  "MDU Complex Eligible To Apply": 256852,
  "Build Finalised": 39019,
  "New Tech Connected": 5842,
  "Eligible to Order": 33,
  "MDU Complex Premises In Build": 155,
  "None": 11879167
 },
 "program_type": {
  "On-Demand N2P SDU/MDU Simple": 1880273,
  "Customer-initiated N2P MDU Complex": 384829,
  "None": 12408065
 },
 "target_eligibility_quarter": {
  "Mar 2025": 77576,
  "Sep 2025": 139576,
  "Dec 2023": 217913,
  "NA": 1000811,
  "Sep 2023": 7532,
  "Dec 2024": 96140,
  "Sep 2024": 99710,
  "Jun 2023": 8114,
  "Dec 2025": 111016,
  "Jun 2024": 85792,
  "Dec 2022": 4269,
  "Mar 2023": 3662,
  "Jun 2022": 2739,
  "Sep 2022": 4658,
  "Dec 2021": 498,
  "Jun 2025": 128813,
  "Mar 2024": 75005,
  "Mar 2022": 881,
  "Mar 2026": 3074,
  "Sep 2021": 1,
  "None": 12605387
 },
 "percent": {
  "tech_change_status": {
   "Not Planned": "1.63%",
   "In Design": "2.95%",
   "Committed": "4.24%",
   "Previous Tech Disconnected": "0.61%",
   "Eligible To Order": "7.50%",
   "Planned": "0.05%",
   "MDU Complex Eligible To Apply": "1.75%",
   "Build Finalised": "0.27%",
   "New Tech Connected": "0.04%",
   "Eligible to Order": "0.00%",
   "MDU Complex Premises In Build": "0.00%",
   "None": "80.96%"
  },
  "program_type": {
   "On-Demand N2P SDU/MDU Simple": "12.81%",
   "Customer-initiated N2P MDU Complex": "2.62%",
   "None": "84.56%"
  },
  "target_eligibility_quarter": {
   "Mar 2025": "0.53%",
   "Sep 2025": "0.95%",
   "Dec 2023": "1.49%",
   "NA": "6.82%",
   "Sep 2023": "0.05%",
   "Dec 2024": "0.66%",
   "Sep 2024": "0.68%",
   "Jun 2023": "0.06%",
   "Dec 2025": "0.76%",
   "Jun 2024": "0.58%",
   "Dec 2022": "0.03%",
   "Mar 2023": "0.02%",
   "Jun 2022": "0.02%",
   "Sep 2022": "0.03%",
   "Dec 2021": "0.00%",
   "Jun 2025": "0.88%",
   "Mar 2024": "0.51%",
   "Mar 2022": "0.01%",
   "Mar 2026": "0.02%",
   "Sep 2021": "0.00%",
   "None": "85.91%"
  }
 }
}
lyricnz commented 7 months ago

PR is merged, but it doesn't run automatically, or check anything into the repo.
@LukePrior What do you want to do with this output/report?

LukePrior commented 7 months ago

Once all suburbs are updated, I want to see if it makes sense to update any of the text on site or change logic of available soon colouring.

Also probably include the number of properties expected each quarter in the stats page.

lyricnz commented 7 months ago

The data capture was started Nov 3, so I'm expecting the first full refresh to complete about Nov 21.

LukePrior commented 7 months ago

Posting this here as it might need to change as understanding of these fields evolves:

Yes, I have updated the logic here is the current flow: