LukePrior / nbn-upgrade-map

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

1000+ results in geojson have different gnaf_pid to the DB #116

Closed lyricnz closed 1 year ago

lyricnz commented 1 year ago

For example

2023-06-05 12:55:46,542 INFO Processing NSW, ALBION PARK RAIL
2023-06-05 12:55:46,620 INFO Fetched 3782 addresses from database
2023-06-05 12:55:46,623 WARNING gnaf_pid mismatch for 1 BALL PLACE ALBION PARK RAIL 2527 (NSW): GANSW703886680 (geojson) vs GANSW703886683 (DB)
2023-06-05 12:55:46,624 WARNING gnaf_pid mismatch for 1 CANDLEBARK STREET ALBION PARK RAIL 2527 (NSW): GANSW703891804 (geojson) vs GANSW703891806 (DB)
2023-06-05 12:55:46,624 WARNING gnaf_pid mismatch for 1 CROOME ROAD ALBION PARK RAIL 2527 (NSW): GANSW712466755 (geojson) vs GANSW717210028 (DB)
2023-06-05 12:55:46,624 WARNING gnaf_pid mismatch for 1 MIALL WAY ALBION PARK RAIL 2527 (NSW): GANSW706662194 (geojson) vs GANSW708444876 (DB)
2023-06-05 12:55:46,624 WARNING gnaf_pid mismatch for 1 POPLAR AVENUE ALBION PARK RAIL 2527 (NSW): GANSW703890121 (geojson) vs GANSW718268440 (DB)
2023-06-05 12:55:46,624 WARNING gnaf_pid mismatch for 1 WINDANG STREET ALBION PARK RAIL 2527 (NSW): GANSW703891357 (geojson) vs GANSW703891360 (DB)
lyricnz commented 1 year ago

Only three currently processed suburbs have this:

lyricnz commented 1 year ago

After removing duplicates in #235 there are less bad gnaf_pid. Adding fix for wrong-id to that PR.

lyricnz commented 1 year ago

I've no idea how these happen - updates in DB?

lyricnz commented 1 year ago
2023-08-15 12:35:50,338 INFO MainThread Writing Campbelltown, NSW - updated 5 addresses
2023-08-15 12:36:20,050 INFO MainThread Writing Homebush West, NSW - updated 108 addresses
2023-08-15 12:36:21,416 INFO MainThread Writing Hurstville, NSW - updated 53 addresses
2023-08-15 12:36:40,631 INFO MainThread Writing Mosman, NSW - updated 6 addresses
2023-08-15 12:36:50,340 INFO MainThread Writing Northmead, NSW - updated 16 addresses
2023-08-15 12:36:54,396 INFO MainThread Writing Penshurst, NSW - updated 1 addresses
2023-08-15 12:37:01,277 INFO MainThread Writing Rushcutters Bay, NSW - updated 17 addresses
2023-08-15 12:37:06,413 INFO MainThread Writing St Peters, NSW - updated 16 addresses
2023-08-15 12:37:09,702 INFO MainThread Writing Tanilba Bay, NSW - updated 4 addresses
2023-08-15 12:37:11,490 INFO MainThread Writing Thirlmere, NSW - updated 8 addresses
2023-08-15 12:37:19,203 INFO MainThread Writing White Cliffs, NSW - updated 4 addresses
2023-08-15 12:37:25,197 INFO MainThread Writing Mount Liebig, NT - updated 6 addresses
2023-08-15 12:37:26,829 INFO MainThread Writing Albany Creek, QLD - updated 20 addresses
2023-08-15 12:37:29,218 INFO MainThread Writing Ashmore, QLD - updated 38 addresses
2023-08-15 12:37:35,540 INFO MainThread Writing Brisbane City, QLD - updated 1 addresses
2023-08-15 12:37:45,663 INFO MainThread Writing Curtis Island, QLD - updated 1 addresses
2023-08-15 12:38:07,261 INFO MainThread Writing Nambour, QLD - updated 12 addresses
2023-08-15 12:38:07,881 INFO MainThread Writing Nerang, QLD - updated 19 addresses
2023-08-15 12:38:19,441 INFO MainThread Writing Sinnamon Park, QLD - updated 72 addresses
2023-08-15 12:38:20,957 INFO MainThread Writing Southport, QLD - updated 90 addresses
2023-08-15 12:39:01,639 INFO MainThread Writing Lindisfarne, TAS - updated 8 addresses
2023-08-15 12:39:09,153 INFO MainThread Writing Avondale Heights, VIC - updated 1 addresses
2023-08-15 12:40:17,846 INFO MainThread Writing Torquay, VIC - updated 96 addresses
2023-08-15 12:40:22,161 INFO MainThread Writing Warrnambool, VIC - updated 13 addresses
2023-08-15 12:40:35,133 INFO MainThread Writing Crawley, WA - updated 9 addresses
2023-08-15 12:40:46,832 INFO MainThread Writing Port Hedland, WA - updated 5 addresses
2023-08-15 12:40:51,843 INFO MainThread Writing Wembley, WA - updated 23 addresses
lyricnz commented 1 year ago

Fixed I think