UNLOCODE validation with linked data Stefano Sabatini UNLOCODE

UN/LOCODE validation with linked data Stefano Sabatini UN/LOCODE Advisory Group Launch Meeting, 30 November 2017

Edition 2017 -1 in Italy 5581 entries: ● 1751 without subdivision ● 862 without coordinates ● 95 with Function 0 Status Change Count # 28 + 15 ¦ Count AA 142 AI 167 QQ 2 RL 4171 17 RQ 1066 X 33 XX 33 Total 93 Total 5581

New DMRs for consideration 495 new requests submitted before October 31 st: • 44 duplicates • 66 coordinate changes (example: outside of Italy) • 332 subdivision, of which 255 are new (previously missing), the others are fixes • remaining are name fixes (diacritic signs, official names) More will be submitted. How they were made?

Wikidata • Editable knowledge • Linked open data • Authority control

Reconciling to Wikidata ● ● ● 5137 entries were successfully verified 440 no (including 33 already marked for deletion + 46 duplicates) 354 remaining Voltri = Q 1516072 = ITVTI

Analysis: coordinates quality ● ● 4433 entries 51, 6% > 1 km 4, 2% > 10 km Max: 6490 km

Analysis: entities ● ● ● 5137 entries In Italy there are currently 7978 municipalities (3 rd administrative level) Almost all UN/LOCODEs identify an urban area Urban classes Municipality Count 4286 Former Municipality 66 Seat of Municipality 10 Sparse Municipality 8 Quarter / Neighborhood Settlement 24 726 Other Count Airport 3 Industrial area 8 Island 3 Other 3

Current municipalities as area If we consider municipalities as area 2 ● Official area of Italy: 301338 km 2 ● Municipalities with UN/LOCODE: 179241 km (~60%) ● ~700 municipalities have more than one UN/LOCODE inside WD Name KM 2 Count Q 2683 Parma 259. 627 11 Q 641 Venezia 416. 511 10 Q 13364 Ravenna 651. 089 9 Q 1449 Genova 241. 073 8 Q 220 Roma 1287. 462 7

Example 1 Parma: • 1 municipality • 10 settlements

Example 2 Genoa: • 1 municipality • 7 neighborhoods

Point vs Area? Picking an Area datatype implies: • a precise definition of it, or • having geodata for each one • marking properly the entry (in the Function column? ) One criterion: • If the location equals an admin unit → Area • Otherwise → Point Conclusion: Recommendation 16 needs an update

Thank you Stefano Sabatini stefano. sabatini@coscoshipping. it