Wikidata:Property proposal/Geographical Names Board of NSW geoname ID

From Wikidata
Jump to navigation Jump to search

Geographical Names Board of NSW geoname ID[edit]

Originally proposed at Wikidata:Property proposal/Authority control

Descriptionidentifier for a registered place in the Geographical Names Board of NSW website
RepresentsGeographical Names Board of New South Wales (Q5535075)
Data typeExternal identifier
Domaingeographical feature (Q618123)
Allowed values[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}
Example 1Epping (Q985485)3b629fd9-9de6-4305-b99d-5fd496bdc665
Example 2Lavender Bay (Q21907230)9a3f8195-b584-4f3b-ba19-922c42203dbf
Example 3Lavender Bay (Q21907230)85202793-400a-49a3-aadd-358f987d4369
Sourcehttps://proposals.gnb.nsw.gov.au/public/geonames/search
External linksUse in sister projects: [ar][de][en][es][fr][he][it][ja][ko][nl][pl][pt][ru][sv][vi][zh][commons][species][wd][en.wikt][fr.wikt].
Planned usegradual migration from old format to new format
Number of IDs in sourcea LOT
Expected completenessalways incomplete (Q21873886)
Formatter URLhttps://proposals.gnb.nsw.gov.au/public/geonames/$1
Robot and gadget jobsyes
See alsoGeographical Names Board of NSW ID (P3517)
Applicable "stated in"-valueGeographical Names Board of New South Wales (Q5535075)
Distinct-values constraintyes
Wikidata projectWikiProject Australia (Q11036831)

Motivation[edit]

This is to replace Geographical Names Board of NSW ID (P3517), which unfortunately no longer works as a formatter (but can still be mapped one-to-one to the GNB file number). They have moved their web IDs to the new format proposed above. Note that one of the examples given has been dual-named, to recognise original Aboriginal name, so it won't necessarily always obey the single value constraint. 99of9 (talk) 11:29, 10 October 2021 (UTC)[reply]

Discussion[edit]

Thierry Caro 99of9 Canley Mattinbgn Samwilson JarrahTree ScottDavis Oronsay Pru.mitchell Bidgee Harryboyles Dhx1 SJK Nickw25 Danadl MargaretRDonald Nicolekearney Calistemon Eothan Evolution and evolvability REMerrick Atroche The-Pope Bjenks hfordsa SHB2000 AmandaSLawrence Rtbk Chris.sherlock3

Notified participants of WikiProject Australia --99of9 (talk) 11:29, 10 October 2021 (UTC)[reply]

 Support JarrahTree (talk) 12:08, 10 October 2021 (UTC)[reply]
 Support MargaretRDonald (talk) 21:11, 10 October 2021 (UTC)[reply]
 Support until GNBNSW decides to obfuscate all their identifiers again! Do you have a list of the new identifiers or a way of converting them (the new IDs don't seem to be in the file when you download all GNR records, and I tried various ways of hashing the old IDs to see if that was how it was derived but no luck)? --Canley (talk) 08:31, 11 October 2021 (UTC)[reply]
Ha, yes. I also haven't worked out the hash function yet, and nor do I know of a list. So for now it will be a slow rollout! --99of9 (talk) 08:36, 11 October 2021 (UTC)[reply]
@99of9: I would guess based on the format that it is a random/unique database row key generated via Microsoft Transact-SQL's NEWID function and thus not a case of obfuscation of an underlying identifier format. It is likely to change again in the future if they pick a different database server implementation for hosting the data.
 Support --Dhx1 (talk) 13:10, 11 October 2021 (UTC)[reply]