Wikidata:Property proposal/WPI ID

From Wikidata
Jump to navigation Jump to search

WPI ID[edit]

Originally proposed at Wikidata:Property proposal/Authority control

   Done: WPI ID (P7625) (Talk and documentation)
DescriptionPort ID in World Port Index database
RepresentsWorld Port Index (Q2248637)
Data typeExternal identifier
Domainport (Q44782)
Allowed values\d{2,5}
Example 1Q3496669638870
Example 2Port of Brisbane (Q1064859)53490
Example 3Port of Catania (Q3909225)40270
Example 4Plymouth Port (Q24677903)35370
Example 5Port of Plymouth (Q76319283)7280
Formatter URLhttps://msi.nga.mil/queryBreakout?publications/world-port-index?indexNumber=$1&output=html
See alsoMarineTraffic Port ID (P1624)

Motivation[edit]

Like NGA Lighthouse ID (P3563) for lighthouses, there is a need to create a WPI ID to link wikidata items to WPI

Discussion[edit]

  • Pictogram voting comment.svg Comment @Pyrog: Please make the examples links.Thank you David (talk) 06:59, 21 November 2019 (UTC)
    • You're welcome :-) Pyrog (talk) 07:27, 21 November 2019 (UTC)
      • Symbol support vote.svg Support David (talk) 07:35, 21 November 2019 (UTC)
@David: Sorry David, but this ID is numerical ;-)
Of course it's simpler to use the port name, but is it stable in time ?
We could ask to the NGA a search by numerical ID ?
Or I could update Wikidata External ID redirector for this task?
Pyrog (talk) 08:01, 21 November 2019 (UTC)
@Pyrog: The ID that you typed does not contain numbers.If a number reaches the same page, you can type it instead of the name David (talk) 08:58, 21 November 2019 (UTC)
@David: You're right :-).
But the ID in the original WPI database is the numerical ID.
The source is The World Port Index (Pub 150)

1. INDEX NUMBER—Each port and place listed in the text of this publication is numbered consecutively. Only the approved index number and name will appear in this list. Ports and places can be located by referring to the alphabetical index to find the index number. In cases where there is an alternate and/or more familiar name, that name will have the same index number. The page number will not be listed.

2. PORTS—Ports are grouped according to country and locality, and are listed in geographic sequence as shown on the chartlets in the fore part of the volume, following, in general, the coastal trend. The listing of ports in off-lying islands normally interrupts the coastal listing at some convenient place abreast of the island. River ports are listed toward the head of navigation, alternating from bank to bank, except where local considerations make other arrangements more practicable.

In general, ports are listed under the names approved by the U.S. Board on Geographic Names. Alternate or more familiar names, however, are also included in the index, under the same index number.

I suggest to wait the comments of WPI specialist (sailor men ?)
Pyrog (talk) 10:22, 21 November 2019 (UTC)
I got one answer 😀 Index numbers are unique, names no.
There is 160 duplicated names (70 names with 2-5 ports).
Try to click on the links on the following examples :
GEORGETOWN
PLYMOUTH
HUSUM
Parameters of queries are documented in API.
Pyrog (talk) 21:53, 23 November 2019 (UTC)
Symbol support vote.svg Support
That's weird: their use of a non unique column that make the link unusable.
But using the number indexNumber is fine: https://msi.nga.mil/api/publications/world-port-index?indexNumber=12370&output=json or https://msi.nga.mil/queryBreakout?publications/world-port-index?indexNumber=12370&output=html
So the choice is pretty easy^^: the name is NOT an ID, the numeric value is an ID. --OuiQui (talk) 19:34, 24 November 2019 (UTC)
I sended an email to webmaster_nss@nga.mil about this issue.
Pyrog (talk) 19:47, 24 November 2019 (UTC)
This issue is fixed, thank you very much -- Pyrog (talk) 19:07, 25 November 2019 (UTC)

@ديفيد عادل وهبة خليل 2, Pyrog: ✓ Done: WPI ID (P7625). − Pintoch (talk) 09:22, 28 November 2019 (UTC)