nbn-upgrade-map icon indicating copy to clipboard operation
nbn-upgrade-map copied to clipboard

Canberra Central not returning any data

Open duckw opened this issue 1 year ago • 4 comments

Looks like Canberra Central stopped showing results somewhere between January and March 2024.

Last commit that worked: https://nbn.lukeprior.com/?suburb=canberra-central&state=ACT&commit=edbdb71f8d0c7b5636ecf47ee95f16c9b4389fd3

Not working: https://nbn.lukeprior.com/?suburb=canberra-central&state=ACT&commit=latest

duckw avatar Oct 07 '24 22:10 duckw

PLACEHOLDER COMMENT

Here is the file in question: https://github.com/LukePrior/nbn-upgrade-map/blob/22424bfb39619a62e23a3d60a687e96eff53eaf4/results/ACT/canberra-central.geojson

I'm guessing it had to do with some update to GNAF database version.

LukePrior avatar Oct 08 '24 02:10 LukePrior

I'll try and have a look over the weekend

lyricnz avatar Oct 09 '24 22:10 lyricnz

Last file with 5 addresses (Jan 30th) https://github.com/LukePrior/nbn-upgrade-map/blob/edbdb71f8d0c7b5636ecf47ee95f16c9b4389fd3/results/ACT/canberra-central.geojson?short_path=ecc0537

Next version, empty (Mar 8th) https://github.com/LukePrior/nbn-upgrade-map/blob/bbbb38d306c5162a67d36992ec483a3b3eb19870/results/ACT/canberra-central.geojson?short_path=b85e458

All the old addresses have the "bogus" locid, where there was no real "LOCID..." value, just some string of hex. It was probably filtered by this @LukePrior commit https://github.com/LukePrior/nbn-upgrade-map/commit/2722628fa61a0450dda511f26db553cb5152bb2f

lyricnz avatar Oct 10 '24 22:10 lyricnz

❯ ./code/main.py --suburb 'Canberra Central' --state ACT --dbhost address_principals.sqlite
2024-10-11 09:14:47,854 INFO MainThread Checking for externally updated geojson results...
2024-10-11 09:14:48,915 INFO MainThread ...done
2024-10-11 09:14:48,960 INFO MainThread Selecting explicit Canberra Central, ACT
2024-10-11 09:14:48,960 INFO MainThread Processing Canberra Central, ACT
2024-10-11 09:14:48,961 INFO MainThread Fetching all addresses for Canberra Central, ACT
2024-10-11 09:14:48,961 INFO MainThread Executing query:
            SELECT gnaf_pid, address, postcode, latitude, longitude
            FROM address_principals
            WHERE locality_name = ? AND state = ?
            LIMIT 100000
2024-10-11 09:14:48,961 INFO MainThread Fetched 5 addresses from database
2024-10-11 09:14:48,961 INFO MainThread Loaded 0 addresses from output file
2024-10-11 09:14:48,961 INFO MainThread Submitting 5 requests to add NBNco data...
2024-10-11 09:14:49,268 WARNING nbn_0 No valid suggestions for 100 BLACK MOUNTAIN DRIVE CANBERRA CENTRAL 2601
2024-10-11 09:14:49,495 WARNING nbn_0 No valid suggestions for 245 LADY DENMAN DRIVE CANBERRA CENTRAL 2601
2024-10-11 09:14:49,741 WARNING nbn_0 No valid suggestions for 50 CLUNIES ROSS STREET CANBERRA CENTRAL 2601
2024-10-11 09:14:50,108 WARNING nbn_0 No valid suggestions for SHOP 1, 100 BLACK MOUNTAIN DRIVE CANBERRA CENTRAL 2601
2024-10-11 09:14:50,532 WARNING nbn_0 No valid suggestions for SHOP 2, 100 BLACK MOUNTAIN DRIVE CANBERRA CENTRAL 2601
2024-10-11 09:14:50,532 INFO nbn_0 Completed 5 requests
2024-10-11 09:14:50,532 INFO MainThread Completed. Tally of tech types: {None: 5}
2024-10-11 09:14:50,532 INFO MainThread Location ID types: {'None': 5}
2024-10-11 09:14:50,532 INFO MainThread Writing results to results/ACT/canberra-central.geojson
2024-10-11 09:14:50,910 INFO MainThread Updating progress.json

lyricnz avatar Oct 10 '24 22:10 lyricnz