CSV of NZ Postcodes

Forums › Off topic › CSV of NZ Postcodes

Paul1977

5042 posts

Uber Geek

#317339 7-Oct-2024 14:31

I'm hoping to get a CSV of all NZ postcodes that lists suburb and town/region next to each postcode, but NZ Post want a $400 subscription to their "Postcode Network File". This is for a one-off project, so just wondering if anyone already has access to the PNF that they could give me a CSV?

Thanks

wellygary

8315 posts

Uber Geek

#3293977 7-Oct-2024 14:40

Google suggests this

https://www.matthewproctor.com/newzealand_postcodes

Paul1977

5042 posts

Uber Geek

#3293980 7-Oct-2024 14:48

wellygary:

Google suggests this

https://www.matthewproctor.com/newzealand_postcodes

Thanks, but looked at that one and it's missing a good number of them, and then it's too granular with what it has (it lists a lot of postcodes multiple times with different suburbs next to it).

Senecio

2710 posts

Uber Geek

ID Verified

Lifetime subscriber

#3293998 7-Oct-2024 15:29

Paul1977:

Thanks, but looked at that one and it's missing a good number of them, and then it's too granular with what it has (it lists a lot of postcodes multiple times with different suburbs next to it).

How else do you expect the list to look? Postcodes and suburbs are not a 1-1 list. I live in 0604 which comprises 8 different suburbs in West Auckland. Three of those suburbs cross borders with adjacent postcodes meaning you could be in 0604 or 0602 depending on which side of the road you live on.

Behodar

10503 posts

Uber Geek

Trusted

Lifetime subscriber

#3294002 7-Oct-2024 15:47

I've done a quick and dirty export of the postcodes from the "Postal Address File", version V2024Q3V01, which I believe is the latest.

[Removed as discussed below]

snj

185 posts

Master Geek

#3294003 7-Oct-2024 15:51

Senecio:

Paul1977:

Thanks, but looked at that one and it's missing a good number of them, and then it's too granular with what it has (it lists a lot of postcodes multiple times with different suburbs next to it).

How else do you expect the list to look? Postcodes and suburbs are not a 1-1 list. I live in 0604 which comprises 8 different suburbs in West Auckland. Three of those suburbs cross borders with adjacent postcodes meaning you could be in 0604 or 0602 depending on which side of the road you live on.

Another good example is that one of the Auckland Central postcodes also includes one of the islands, (this becomes apparent when you use store finders that use the midpoint of the GIS area, and tell you that it's 10km+ to the Auckland CBD store from the CBD postcode).

But yeah, rural areas (especially Auckland fringe) also might have 3-6 postcodes for a single suburb, (urban township area, PO Box lobby, and then one for each RD route).

Paul1977

5042 posts

Uber Geek

#3297324 14-Oct-2024 16:49

Behodar:

I've done a quick and dirty export of the postcodes from the "Postal Address File", version V2024Q3V01, which I believe is the latest.

@Behodar thanks for that. Sorry for the late acknowledgement, I got sidetracked on other projects for a couple of days.

gehenna

8499 posts

Uber Geek

Moderator

Trusted

Lifetime subscriber

#3297331 14-Oct-2024 17:16

This is what we use: https://www.nzpost.co.nz/business/shipping-in-nz/quality-addressing/postal-address-file-paf

Lenovo

Shop now for Lenovo laptops and other devices (affiliate link).

freitasm

BDFL - Memuneh
79263 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#3297380 14-Oct-2024 17:24

@behodar it looks like your file is in breach of the licensing agreement for its use.

I would remove that file and link.

Behodar

10503 posts

Uber Geek

Trusted

Lifetime subscriber

#3297389 14-Oct-2024 17:25

I wondered about that. I only have the data, not the licence itself, but I imagined that as it's simply factual information that it wouldn't be a problem. Nevertheless I'll remove it.

freitasm

BDFL - Memuneh
79263 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#3297390 14-Oct-2024 17:26

The licence explicitly says not allowed to copy or distribute.

Kyanar

4089 posts

Uber Geek

ID Verified

Trusted

#3297409 14-Oct-2024 19:29

If it's for a non-profit or personal project, have you considered emailing NZ Post and asking if they would be willing to give you an extract under non-commercial, not-for-distribution terms? Especially if you aren't asking for the whole dataset that could have commercial applications, sign an agreement stating you won't redistribute it. I guess you could also offer to credit them and link to their data solutions. I don't know how much latitude their teams have to go "off-script", but the only way to be guaranteed a "no" is not to ask.

Interestingly, I was curious if they published anything on the Open Data Portal (they don't) and what Australia Post does in the same situation. AP's approach is "for personal use, here's a free PDF. One-off CSV purchases are $77 for commercial use, and subscriptions cost up to $310/yr. for monthly updates").