Create tallies of the different NBN property details

[lyricnz]

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]

Removed - updated below.

[lyricnz]

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

[lyricnz]

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]

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]

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]

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

[LukePrior]

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:

• is tech='FTTP': FTTP

• is tech_change_status='Eligible To Order' && (tech='FTTN' || 'FTTC'): FTTP Upgrade

• is (tech_change_status='Build Finalised' || 'MDU Complex Eligible To Apply' || 'MDU Complex Premises In Build') && (tech='FTTN' || 'FTTC'): FTTP Soon

• is target_eligibility_quarter < 3 months from file generated && (tech='FTTN' || 'FTTC'): FTTP Soon

• is target_eligibility_quarter not provided (historical records) &&(upgrade='FTTP_SA': FTTP Upgrade

• is target_eligibility_quarter not provided (historical records) &&(upgrade='FTTP_NA': FTTP Soon

• finally simply match to corresponding current technology