Property talk:P3517

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

Geographical Names Board of NSW ID
historical identifier of a geographical feature on a retired Geographical Names Board of New South Wales website

Description	Identifier on the Geographical Names Board of New South Wales website. Do not use the reference number
Associated item	Geographical Names Board of New South Wales (Q5535075)
Applicable "stated in" value	Geographical Names Register (Q63408358)
Data type	External identifier
Template parameter	en:Template:NSW GNR
Domain	According to this template: place According to statements in the property: geographical feature (Q618123) or educational institution (Q2385804) When possible, data should only be stored as statements
Allowed values	(JP|Ma|an|uj|TR|SX|KW|Mn|It)(jL|Kq|qw|IO|ck|Yb|lp|jt|Ql|wG)?(Wy|vq|lM|wp|BK|oe|Fx|Xt|jz|Zx)?(rX|ZT|Km|sE|WA|qb|tL|Ul|sy|xO)?(GH|JP|Ma|an|uj|TR|SX|KW|Mn|It)?
Example	Shooters Hill (Q7500539) → TRqwZxWAMa Kedumba River (Q1737704) → MalplMtLuj
Source	https://www.gnb.nsw.gov.au/place_naming/place_name_search
Formatter URL	https://web.archive.org/web/*/https://www.gnb.nsw.gov.au/place_naming/placename_search/extract?id=$1
Robot and gadget jobs	From Wikipedia
Tracking: usage	Category:Pages using Wikidata property P3517 (Q28530219)
Related to country	Australia (Q408) (See 200 others)
See also	Geographical Names Board of NSW geoname ID (P10008)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Mix'n'match (Report) Database reports/Constraint violations/P3517 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 41,154 Main statement 21,760 out of 61,991 (35% complete) 52.9% of uses Qualifier 2 <0.1% of uses Reference 19,392 47.1% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Unique value, SPARQL (every item), SPARQL (by value)

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Single value, SPARQL

Item “country (P17): Australia (Q408)”: Items with this property should also have “country (P17): Australia (Q408)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3517#Item P17, hourly updated report, search, SPARQL

Format “(JP|Ma|an|uj|TR|SX|KW|Mn|It)(jL|Kq|qw|IO|ck|Yb|lp|jt|Ql|wG)?(Wy|vq|lM|wp|BK|oe|Fx|Xt|jz|Zx)?(rX|ZT|Km|sE|WA|qb|tL|Ul|sy|xO)?(GH|JP|Ma|an|uj|TR|SX|KW|Mn|It)?”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Format, SPARQL

Item “coordinate location (P625)”: Items with this property should also have “coordinate location (P625)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Item P625, SPARQL

Item “instance of (P31)”: Items with this property should also have “instance of (P31)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Item P31, search, SPARQL

Item “located in the administrative territorial entity (P131)”: Items with this property should also have “located in the administrative territorial entity (P131)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Item P131, search, SPARQL

Item “GeoNames ID (P1566)”: Items with this property should also have “GeoNames ID (P1566)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Item P1566, search, SPARQL

Type “geographical feature (Q618123), educational institution (Q2385804)”: item must contain property “instance of (P31)” with classes “geographical feature (Q618123), educational institution (Q2385804)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Type Q618123, Q2385804, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Scope, SPARQL

Item “Geographical Names Board of NSW geoname ID (P10008)”: Items with this property should also have “Geographical Names Board of NSW geoname ID (P10008)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3517#Item P10008, search, SPARQL

Here's the conversion to map to this ID from the "reference ID" in the GNR database, which can can be accessed on bulk by using the facility to download every record. (concatenate the following):

First digit 1 JP 2 Ma 3 an 4 uj 5 TR 6 SX 7 KW 8 Mn 9 It

Second digit 0 jL 1 Kq 2 qw 3 IO 4 ck 5 Yb 6 lp 7 jt 8 Ql 9 wG

Third digit 0 Wy 1 vq 2 lM 3 wp 4 BK 5 oe 6 Fx 7 Xt 8 jz 9 Zx

Fourth digit 0 rX 1 ZT 2 Km 3 sE 4 WA 5 qb 6 tL 7 Ul 8 sy 9 xO

Fifth digit 0 GH 1 JP 2 Ma 3 an 4 uj 5 TR 6 SX 7 KW 8 Mn 9 It

Also see discussion at w:Template_talk:NSW_GNR. --99of9 (talk) 03:07, 19 March 2019 (UTC)

@Canley, Thierry Caro, Dhx1, Mattinbgn: Please can you hold off on the Mix'n'matching of this set for a bit. I made an error in the 5th digit, switching all the 1's for 2's (corrected above). I will go through and fix the 70 we've done so far that this affects, but will then need to upload a new Mix'n'match set. Sorry for the inconvenience, and thanks for your help. --99of9 (talk) 00:48, 22 March 2019 (UTC)

@Canley, Thierry Caro, Dhx1, Mattinbgn, Kerry Raymond: The replacement set is now ready here. --99of9 (talk) 05:04, 22 March 2019 (UTC)

Queries to help with error-checking and QA

https://w.wiki/UzM a map coloured by region, so points in the wrong region stand out. --99of9 (talk) 13:39, 23 June 2020 (UTC)

https://w.wiki/WmD shows items which ended up with two very different coordinates, possibly due to mis-matching. --99of9 (talk) 01:25, 13 July 2020 (UTC)

GNB site

Just noticed that the NSW Geographical Names Board seems to have changed its site breaking the old URL formatter, and are using completely different identifiers for place names: for example Awaba (Q4829653) has a Geographical Names Board of NSW ID (P3517) of "TRQlXt", but the page for that location is now https://proposals.gnb.nsw.gov.au/public/geonames/976e623e-da20-4884-acf5-61d7a007a573 . The new search page is here: https://proposals.gnb.nsw.gov.au/public/geonames/search . They still offer a download of the place names data, but the reference column is blank and there seem to be no other identifiers, so might take some digging to find a way to migrate the data. --Canley (talk) 14:12, 31 August 2020 (UTC)

@Canley: Annoying eh? I'm on other things at the moment, but if things stay the way they are now, I will probably contact them. --99of9 (talk) 14:49, 31 August 2020 (UTC)

Came here to say the same thing? I would have thought it's better to be using the reference number. This is still present in the bulk data download. Why aren't we using the reference number? --AndrewHarvey4 (talk) 03:50, 31 December 2020 (UTC)

Also, the web archive URL doesn't seem to work. Why not use the proper GNB URL with its proper identifiers? -- Michael Bednarek (talk) 23:53, 4 October 2021 (UTC)

@Michael Bednarek: I think the archive may work for some pages, but their format switch has certainly reduced the value of this current property. For the new format, what you call "proper identifiers", we will need a new property. Let's propose one soon. --99of9 (talk) 01:04, 5 October 2021 (UTC)

@AndrewHarvey4: It's good that the reference number is still of some value, but annoying that it can no longer be used to construct a URL. The identifier format we currently have can be mapped 1:1 to the reference numbers (using the scheme in the section above). We used this format so we could make links, but I agree that we may want to explicitly convert for users, e.g. qualified by object named as (P1932) -> ref_num. This conversion could be done in bulk with QuickStatements. --99of9 (talk) 01:21, 5 October 2021 (UTC)

replacement web ID proposed

Wikidata:Property proposal/Geographical Names Board of NSW geoname ID --99of9 (talk) 11:31, 10 October 2021 (UTC)

@Canley: It looks like the "version" bit of the new UUID is set to 4 w:Universally_unique_identifier#Version_4_(random), so most of the other bits are meant to be set randomly. So that makes it hard to unhash! --99of9 (talk) 10:15, 11 October 2021 (UTC)