Wikidata:Property proposal/USCG MIC ID
USCG MIC ID
[edit]Originally proposed at Wikidata:Property proposal/Authority control
Motivation
[edit]The United States Coast Guard (Q11224) issues Manufacturer's Identification Code ("MIC") to identify boat manufacturers and importers in the USA. It is listed as a Federal dataset from USCG on data.gov. It will help better identify and remove duplicate boat manufacturing company (Q73126803). Example of what the property would look like USCG manufacturers list (Q106135311) Simon.letort (talk) 19:27, 26 March 2021 (UTC)
Discussion
[edit]Notified participants of WikiProject Authority control,
Notified participants of WikiProject Ships,
Notified participants of WikiProject Sailing. Simon.letort (talk) 12:14, 27 March 2021 (UTC)
- Support - PKM (talk) 19:27, 27 March 2021 (UTC)
- Support useful and authoritative source (and maybe unique, I don't see any other identifiers for these company?), it's obviously a support. VIGNERON (talk) 09:52, 28 March 2021 (UTC)
- Support. --Carlobia (talk) 07:03, 29 March 2021 (UTC)
- Support - --AhavaCohen (talk) 15:08, 29 March 2021 (UTC)
- Support This is a good idea. De728631 (talk) 18:56, 29 March 2021 (UTC)
- Support --1-Byte (talk) 13:42, 30 March 2021 (UTC)
Thanks a lot for the various Support. Given that it's been a week since proposal, I changed to status=ready. WikiProject Properties has more than 50 participants and couldn't be pinged. Please post on the WikiProject's talk page instead. Simon.letort (talk) 19:24, 2 April 2021 (UTC)
- Support actually excited to see good work done on boats in the future. Josh Baumgartner (talk) 19:32, 2 April 2021 (UTC)
- Wait Hello Simon.letort ,
Cette proposition ne peut pas aboutir à une propriété dans l'état où vous l'avez laissée.- Vous avez proposé un identifiant externe avec
https://uscgboating.org/content/manufacturers-identification-detail.php?id=$1
pour formatter URL (P1630). Le datatype est le champ le plus important, alors je le prends pour faire les corrections: $1 doit être un nombre, sinon l'URL n’aboutit pas. Le RegEx était déjà faux auparavant (exemple 5). - Pour inclure le MIC, un item-requires-statement constraint (Q21503247) et mandatory (Q29557567) peuvent être ajoutée : short name (P1813).
- Vous ne devez absolument pas créer un Élément Qxxxx pour représenter une Propriété ou faire des essais ! Pour cela, vous pouvez vous aider de Sandbox-External identifier (P2536) et des autres bacs à sable.
- Si vous utilisez cette URL, mes corrections sont la seule manière d'avoir cette propriété d'identifiant externe, sinon il faut trouvez une autre URL qui incorpore les MIC. Si mes modifications vous conviennent, vous pouvez remettre ready, sinon c'est withdrawn (pour refaire une autre proposition par exemple).
- Comme vous ne semblez pas à l'aise, je vous propose de demander l'avis d'un créateur de propriété ou d'un administrateur pour changer le status de vos propositions de propriétés ou pour des conseils. Cordialement. —Eihel (talk) 22:59, 2 April 2021 (UTC)
- Hello Eihel . Merci beaucoup pour les corrections. Le code numerique de l'url convient tres bien comme identifiant. Je vais donc remettre ready. Encore merci pour toutes ces corrections! Simon.letort (talk) 23:32, 2 April 2021 (UTC)
- Vous avez proposé un identifiant externe avec
- @Simon.letort, PKM, VIGNERON, Joshbaumgartner, Eihel, Carlobia: Notified participants of WikiProject Authority control, Notified participants of WikiProject Ships, Notified participants of WikiProject Sailing Done as USCG MIC (P9411). UWashPrincipalCataloger (talk) 20:40, 4 April 2021 (UTC)
- Thanks a lot UWashPrincipalCataloger. I started to reconcile this identifier. Simon.letort (talk) 22:54, 4 April 2021 (UTC)
- @Simon.letort: de rien! UWashPrincipalCataloger (talk) 00:56, 5 April 2021 (UTC)
- Thanks a lot UWashPrincipalCataloger. I started to reconcile this identifier. Simon.letort (talk) 22:54, 4 April 2021 (UTC)
Some post-creation questions: @Simon.letort, UWashPrincipalCataloger, PKM, VIGNERON, Joshbaumgartner, Eihel:
Notified participants of WikiProject Ships
Notified participants of WikiProject Sailing
- Why the IDs are not shown as links using the formatterURL? Weird...
- Please import the dataset to a Mix-n-Match Catalog, so that others can help with the reconciliation.
- Why is there "item requires statement constraint: short name"? Eg Hunter Marine (Q5944454) doesn't have it --Vladimir Alexiev (talk) 08:08, 5 April 2021 (UTC)
@Vladimir Alexiev, Simon.letort: It takes a day or two before the links become active. That is normal. Check again in another day. I didn't add the short name constraint. It was added after I created the property. I don't see why that should be a constraint either, but if there is a good reason for it, it should not be mandatory. UWashPrincipalCataloger (talk) 18:41, 5 April 2021 (UTC)
@Vladimir Alexiev: 1- formatterURL now shows as link. 2- Mix-n-Match Catalog 4346, and also as csv file (I'm working on adding the coordinate location). 3- I plan to use short name (P1813) with qualifier Q106366270 to input the 3 letter USCG MIC code, exemple JBO for J/Boats (Q85770361). Simon.letort (talk) 04:50, 6 April 2021 (UTC)
- @Simon.letort: Please don't use short name (P1813) for that: "JBO" is an abbreviation/code not a name. Please propose a second USCG identifier ("USCG manufacturer mnemonic" or "abbreviation"), I'm sure it will be approved quickly. (Or else you could use catalog code (P528) with qualifier catalog (P972) but a separate external-id is better) --Vladimir Alexiev (talk) 06:45, 10 April 2021 (UTC)
- @Vladimir Alexiev: I like the idea of creating a property for the mnemonic. However, I haven't found a formatter URL (P1630) that would take the mnemonic as $1. Is formatter URL (P1630) mandatory for creating an external-id? Example for Hunter Marine, mnemonic HUN, the url takes 5288 as $1: https://uscgboating.org/content/manufacturers-identification-detail.php?id=5288 Simon.letort (talk) 10:27, 10 April 2021 (UTC)
- @Simon.letort: formatterURL is optional --Vladimir Alexiev (talk) 07:06, 12 April 2021 (UTC)
- @Vladimir Alexiev: I like the idea of creating a property for the mnemonic. However, I haven't found a formatter URL (P1630) that would take the mnemonic as $1. Is formatter URL (P1630) mandatory for creating an external-id? Example for Hunter Marine, mnemonic HUN, the url takes 5288 as $1: https://uscgboating.org/content/manufacturers-identification-detail.php?id=5288 Simon.letort (talk) 10:27, 10 April 2021 (UTC)
- Hello Vladimir Alexiev , Hello Simon.letort Many abbreviations or code are already used in short name (P1813), when creating this property: example, Ph. D (See Aliases). I added: USCG MIC (P9411)qualifier for this property (P8379)code (P3295). You can remove formatter URL (P1630) if you want to put the MIC instead, but you cannot include the MIC in the URL you provided (as I wrote before, the link fails). If you don't want to put P1813 in the items used by this property, you can use code (P3295). It takes all your problems away from you, Vladimir. With this property, you have the option to add it as a qualifier or as a main value (like the change I made on P9411). While preparing the filling of WD, I realize that this site is filled with a lot of errors even in the MICs! Simon, there was no need to create Q106366270, applicable 'stated in' value (P9073) is expected to reference datas from this site (so with USCG manufacturers list (Q106135311)). You can add required qualifier constraint (Q21510856) to P9411 to force to put the MIC with P3295, for example. Or item-requires-statement constraint (Q21503247) as I had done: really no need to do another property for that. Cordially. —Eihel (talk) 06:36, 16 April 2021 (UTC)
- Hello Eihel . Thanks again for your knowledgeable input. I now understand how to use code (P3295) as a qualifier for USCG MIC (P9411). I've updated J/Boats (Q85770361) and Catalina Yachts (Q5051288) accordingly. And I'll clean up the rest of the "mess" in the next days: remove Q106366270, add required qualifier constraint (Q21510856) and add code (P3295) to the 35 items with a MIC. Simon.letort (talk) 17:52, 16 April 2021 (UTC)
- Hello Vladimir Alexiev , Hello Simon.letort Many abbreviations or code are already used in short name (P1813), when creating this property: example, Ph. D (See Aliases). I added: USCG MIC (P9411)qualifier for this property (P8379)code (P3295). You can remove formatter URL (P1630) if you want to put the MIC instead, but you cannot include the MIC in the URL you provided (as I wrote before, the link fails). If you don't want to put P1813 in the items used by this property, you can use code (P3295). It takes all your problems away from you, Vladimir. With this property, you have the option to add it as a qualifier or as a main value (like the change I made on P9411). While preparing the filling of WD, I realize that this site is filled with a lot of errors even in the MICs! Simon, there was no need to create Q106366270, applicable 'stated in' value (P9073) is expected to reference datas from this site (so with USCG manufacturers list (Q106135311)). You can add required qualifier constraint (Q21510856) to P9411 to force to put the MIC with P3295, for example. Or item-requires-statement constraint (Q21503247) as I had done: really no need to do another property for that. Cordially. —Eihel (talk) 06:36, 16 April 2021 (UTC)