Creative Commons Attribution 3.0 New Zealand
You may use this work for commercial purposes.
You must attribute the creator in your own works.
This dataset was last updated on LINZ Data Service on 01 Jul 2017.
Are either of rna_id or rcl_id permanent identifiers for an address? That is, are they stable between versions of the data, and resistant to things like correction of spelling mistakes or exact locations?
3:39 a.m. 30th July 2014
The rna_id and rcl_id should remain static between versions.
3:16 a.m. 31st July 2014
Thanks. What are they? And I should have looked harder before I asked, because they don't seem to be unique keys. Is the combination of an rna_id an rcl_id and a street number unique?
I probably should have said sooner: I'm looking for a key that will uniquely and permanently identify an address. I imagine street numbers, names and locations are all subject to correction?
3:20 a.m. 31st July 2014
The rna_id is the Landonline id for the road name + locality combination.
The rcl_id is the Landonline id for the road centreline segment.
These won't be unique within the Street Address (Electoral) table, as any address which shares the same road name or road segment, will share these ids.
What you should be using is the id field in this table, as this is the static and unique id for the street address.
3:44 a.m. 31st July 2014
Thanks Jason. Sorry, I should have asked the right question from the start. I had assumed that because the id started from one and I couldn't find any gaps that it was more like a row number than a permanent id. I should have asked straight up.
3:54 a.m. 31st July 2014
No worries. We only implemented the static id for this table around 6 weeks ago, which will be the reason you couldn't find any gaps.
4:02 a.m. 31st July 2014
Hi, is it possible to add a summarised version of these comments to your Metadata tab? That tab currently provides all kinds of metadata about the table itself, but not about all the columns inside it. Would be great to have it all in one spot if possible!
3:55 a.m. 24th Oct. 2014
Please sign in to add a reply.
Please sign in to post a comment.