Wikidata:Property proposal/WPI ID

WPI ID edit

Originally proposed at Wikidata:Property proposal/Authority control

Done: WPI ID (P7625) (Talk and documentation)

Description	Port ID in World Port Index database
Represents	World Port Index (Q2248637)
Data type	External identifier
Domain	port (Q44782)
Allowed values	\d{2,5}
Example 1	Toulon Port (Q34966696) → 38870
Example 2	Port of Brisbane (Q1064859) → 53490
Example 3	Port of Catania (Q3909225) → 40270
Example 4	Plymouth Port (Q24677903) → 35370
Example 5	Port of Plymouth (Q76319283) → 7280
Formatter URL	https://msi.nga.mil/queryBreakout?publications/world-port-index?indexNumber=$1&output=html
See also	MarineTraffic 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

Comment @Pyrog: Please make the examples links.Thank you David (talk) 06:59, 21 November 2019 (UTC)[reply]
- You're welcome :-) Pyrog (talk) 07:27, 21 November 2019 (UTC)[reply]
  - Support David (talk) 07:35, 21 November 2019 (UTC)[reply]

@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)[reply]

@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)[reply]

@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)[reply]

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)[reply]

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)[reply]

I sended an email to webmaster_nss@nga.mil about this issue.

Pyrog (talk) 19:47, 24 November 2019 (UTC)[reply]

This issue is fixed, thank you very much -- Pyrog (talk) 19:07, 25 November 2019 (UTC)[reply]

Support --Bamyers99 (talk) 18:27, 27 November 2019 (UTC)[reply]

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