Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Canberra Central not returning any data #393

Open
duckw opened this issue Oct 7, 2024 · 4 comments
Open

Canberra Central not returning any data #393

duckw opened this issue Oct 7, 2024 · 4 comments
Labels
bug Something isn't working

Comments

@duckw
Copy link

duckw commented Oct 7, 2024

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

@LukePrior LukePrior added the bug Something isn't working label Oct 8, 2024
@LukePrior
Copy link
Owner

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.

@lyricnz
Copy link
Contributor

lyricnz commented Oct 9, 2024

I'll try and have a look over the weekend

@lyricnz
Copy link
Contributor

lyricnz commented Oct 10, 2024

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
2722628

@lyricnz
Copy link
Contributor

lyricnz commented Oct 10, 2024

❯ ./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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants