search

ondrejivanic / G-NAF

Geocoded National Address File is Australia’s authoritative, geocoded address file. This repo has few tools / scripts to create derived datasets
Apache License 2.0
20 stars 7 forks source link

Incorrect Join #4

Closed danwwilson closed 6 years ago

danwwilson commented 6 years ago

Line 613 of your current g-naf.sql uses the line left outer join staging.locality l on l.locality_pid = ad.locality_pid you may wish to update this to left outer join staging.locality l on l.street_locality_pid = ad.street_locality_pid

At present your join will create extra records as the locality_pid is a 1:n join.

danwwilson commented 6 years ago

my bad, it turns out I had an issue with my import.