Wikidata

Kq-hit

Joined 15 February 2015
Babel user information
de-N Dieser Benutzer spricht Deutsch als Muttersprache.
en-4 This user has near native speaker knowledge of English.
fi-3 Tämä käyttäjä osaa suomea erinomaisesti.
fr-2 Cet utilisateur dispose de connaissances intermédiaires en français.
nl-1 Deze gebruiker heeft elementaire kennis van het Nederlands.
sv-1 Den här användaren har grundläggande kunskaper i svenska.
nb-1 Denne brukeren har grunnleggende kjennskap til norsk bokmål.
nn-1 Denne brukaren meistrar nynorsk på eit grunnleggjande nivå.
da-1 Denne bruger har grundlæggende kendskab til dansk.
Users by language

LNG | Laivaluettelo 1989

Resources edit

Template usage edit

SPARQL queries edit

Vessels edit

Items with an IMO number and their labels in Chinese and English 

SELECT ?item ?imo ?itemLabelZH ?itemLabelEN  where {
  ?item wdt:P458 ?imo.
  ?item rdfs:label ?itemLabelZH.
  FILTER(LANG(?itemLabelZH) = 'zh').
  OPTIONAL {
    ?item rdfs:label ?itemLabelEN.
    FILTER(LANG(?itemLabelEN) = 'en')
  }
}
Try it!

Items with an IMO number and a Commons category 

SELECT ?item ?imo ?image ?comm where {
  ?item wdt:P458 ?imo.
  ?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .
  OPTIONAL {
  ?item wdt:P18 ?image.
  }
}
Try it!

Duplicate IMO numbers 

SELECT DISTINCT ?imo (GROUP_CONCAT(?itemLabelEN; separator=',') as ?names) (COUNT(?item) AS ?ccount) (MIN(?item) AS ?min_item) (MAX(?item) AS ?max_item)
WHERE  {
  ?item wdt:P458 ?imo.
  OPTIONAL {
    ?item rdfs:label ?itemLabelEN.
    FILTER(LANG(?itemLabelEN) = 'en')
  }
}
GROUP BY ?imo
HAVING (COUNT(?item) > 1)
ORDER BY ?imo
Try it!

Ships 

SELECT ?item ?itemLabelEN ?service_entry
WHERE  {
  ?item wdt:P31 wd:Q11446.
  OPTIONAL { ?item wdt:P729 ?service_entry. }
  OPTIONAL {
    ?item rdfs:label ?itemLabelEN.
    FILTER(LANG(?itemLabelEN) = 'en')
  }
}
Try it!

Ships built by Meyer Werft 

SELECT ?item ?itemLabelEN ?yard_number ?imo ?service_entry ?instance_of
WHERE  {
  ?item wdt:P176 wd:Q705377.
  OPTIONAL { ?item wdt:P617 ?yard_number. }
  OPTIONAL { ?item wdt:P31 ?instance_of. }
    FILTER(?instance_of != wd:Q559026).
  OPTIONAL { ?item wdt:P458 ?imo. }
  OPTIONAL { ?item wdt:P729 ?service_entry. }
  OPTIONAL {
    ?item rdfs:label ?itemLabelEN.
    FILTER(LANG(?itemLabelEN) = 'en')
  }
}
ORDER BY ?yard_number
Try it!

Sentinel-class cutters 

SELECT ?item ?item_en ?instance_of_en ?manufacturer_en ?operator_en ?pennant_number ?country_of_registry_en ?country ?mmsi ?service_entry ?named_after_en
WHERE  {
  ?item wdt:P289 wd:Q6468587
  OPTIONAL { ?item wdt:P176 ?manufacturer. }
  OPTIONAL { ?item wdt:P137 ?operator. }
  OPTIONAL { ?item wdt:P617 ?yard_number. }
  OPTIONAL { ?item wdt:P31 ?instance_of. }
  OPTIONAL { ?item wdt:P587 ?mmsi. }
  OPTIONAL { ?item wdt:P8047 ?country_of_registry. }  
  OPTIONAL { ?item wdt:P17 ?country. }  
  OPTIONAL { ?item wdt:P879 ?pennant_number. }
  OPTIONAL { ?item wdt:P138 ?named_after. }
  OPTIONAL { ?item wdt:P729 ?service_entry. }
  OPTIONAL { ?item wdt:P504 ?shipping_port. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
    ?item rdfs:label ?item_en .
    ?manufacturer rdfs:label ?manufacturer_en .
    ?operator rdfs:label ?operator_en .
    ?country_of_registry rdfs:label ?country_of_registry_en .
    ?named_after rdfs:label ?named_after_en .
    ?instance_of rdfs:label ?instance_of_en .
  }
}
ORDER BY ?pennant_number
Try it!

Island-class patrol boats 

SELECT ?item ?item_en ?instance_of_en ?manufacturer_en ?operator_en ?pennant_number ?country_of_registry_en ?country ?mmsi ?service_entry ?named_after_en
WHERE  {
  ?item wdt:P289 wd:Q6082954
  OPTIONAL { ?item wdt:P176 ?manufacturer. }
  OPTIONAL { ?item wdt:P137 ?operator. }
  OPTIONAL { ?item wdt:P617 ?yard_number. }
  OPTIONAL { ?item wdt:P31 ?instance_of. }
    FILTER(?instance_of != wd:Q559026).
  OPTIONAL { ?item wdt:P587 ?mmsi. }
  OPTIONAL { ?item wdt:P8047 ?country_of_registry. }  
  OPTIONAL { ?item wdt:P17 ?country. }  
  OPTIONAL { ?item wdt:P879 ?pennant_number. }
  OPTIONAL { ?item wdt:P138 ?named_after. }
  OPTIONAL { ?item wdt:P729 ?service_entry. }
  OPTIONAL { ?item wdt:P504 ?shipping_port. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
    ?item rdfs:label ?item_en .
    ?manufacturer rdfs:label ?manufacturer_en .
    ?operator rdfs:label ?operator_en .
    ?country_of_registry rdfs:label ?country_of_registry_en .
    ?named_after rdfs:label ?named_after_en .
    ?instance_of rdfs:label ?instance_of_en .
  }
}
ORDER BY ?pennant_number
Try it!

Vulkan Bremen 

SELECT * {
  {
    SELECT * {
      ?item wdt:P176 wd:Q527466 .
      OPTIONAL { ?item wdt:P458 ?imo . }
      OPTIONAL { ?item wdt:P729 ?service_entry . }
      OPTIONAL { ?item wdt:P617 ?yard_number . }
      OPTIONAL { ?item wdt:P31 ?instance_of . }
    }
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en,en,de,fr,ja,es,ru,pt,it,zh,fa,ar,pl,nl,uk,tr,id,he,cs,sv,hu,fi,vi,ko,el,hi,bn,no,ca,ro,th,da,sr,bg,az,ms,et,uz,hr,sk,eu,hy,sl,lt,eo,ta,kk,lv,be,kn,sq,ur,mk" .
    ?item rdfs:label ?label . ?item schema:description ?description . ?instance_of rdfs:label ?iol
  }
}
ORDER BY xsd:integer(?yard_number)
Try it!

Ships built in Finland 

SELECT ?item ?label ?description ?imo (GROUP_CONCAT(DISTINCT ?manufacturer_name;separator=", ") AS ?manufacturer_names) (GROUP_CONCAT(DISTINCT ?location_of_creation_name;separator=", ") AS ?location_of_creation_names) ?yard_number (GROUP_CONCAT(DISTINCT ?iol;separator=", ") AS ?instance_ofs) ?service_entry {
  {
    SELECT * {
      VALUES ?manufacturer_list {wd:Q327429 wd:Q11874481 wd:Q4117007 wd:Q11887488 wd:Q2944983 wd:Q17334709 wd:Q18688797 wd:Q12358532 wd:Q11890180 wd:Q21927194 wd:Q7943682 wd:Q30638410 wd:Q1524298 wd:Q12358532 wd:Q65072048 wd:Q1278953 wd:Q3817603 wd:Q105019750 wd:Q7224811 wd:Q98204447 wd:Q18688871 wd:Q1197161 wd:Q43082510 wd:Q113458692 wd:Q112845005 wd:Q112653321 wd:Q124485935}
      ?item wdt:P176 ?manufacturer_list .
      OPTIONAL { ?item wdt:P458 ?imo . }
      OPTIONAL { ?item wdt:P176 ?manufacturer . }
      OPTIONAL { ?item wdt:P1071 ?location_of_creation . }
      OPTIONAL { ?item wdt:P729 ?service_entry . }
      OPTIONAL { ?item wdt:P617 ?yard_number . }
      OPTIONAL { ?item wdt:P31 ?instance_of . }
       FILTER(?instance_of not in (wd:Q118017625, wd:Q15057021, wd:Q15057020, wd:Q559026, wd:Q19832486, wd:Q15142894, wd:Q15056995, wd:Q34336, wd:Q55725952, wd:Q811704, wd:Q376, wd:Q11436, wd:Q76154857, wd:Q121289722, wd:Q15056993, wd:Q18758641, wd:Q63040754)).
    }
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
    ?item rdfs:label ?label . ?item schema:description ?description . ?instance_of rdfs:label ?iol . ?manufacturer rdfs:label ?manufacturer_name . ?location_of_creation rdfs:label ?location_of_creation_name
  }
}
GROUP BY ?item ?label ?description ?imo ?yard_number ?service_entry
ORDER BY xsd:integer(?yard_number)
#ORDER BY DESC(?service_entry)
Try it!

Finnish Navy ships 

SELECT * {
  {
    SELECT * {
      ?item wdt:P137 wd:Q2071948 .
      ?item wdt:P31 ?instance_of .
      OPTIONAL { ?item wdt:P879 ?pennant_number}
    } LIMIT 100
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en,en,de,fr,ja,es,ru,pt,it,zh,fa,ar,pl,nl,uk,tr,id,he,cs,sv,hu,fi,vi,ko,el,hi,bn,no,ca,ro,th,da,sr,bg,az,ms,et,uz,hr,sk,eu,hy,sl,lt,eo,ta,kk,lv,be,kn,sq,ur,mk" .
    ?item rdfs:label ?label . ?item schema:description ?description . ?instance_of rdfs:label ?instance_type
  }
}
Try it!

Finnish shipyards 

SELECT * {
  {
    SELECT * {
      ?item wdt:P31 wd:Q190928 .
      ?item wdt:P17 wd:Q33 .
      OPTIONAL { ?item wdt:P131 ?location}
      OPTIONAL { ?item wdt:P625 ?coordinates}
    } LIMIT 100
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en,en,de,fr,ja,es,ru,pt,it,zh,fa,ar,pl,nl,uk,tr,id,he,cs,sv,hu,fi,vi,ko,el,hi,bn,no,ca,ro,th,da,sr,bg,az,ms,et,uz,hr,sk,eu,hy,sl,lt,eo,ta,kk,lv,be,kn,sq,ur,mk" .
    ?item rdfs:label ?label . ?item schema:description ?description . ?location rdfs:label ?location_name
  }
}
Try it!

Ports edit

Related:

Items of type port 

SELECT ?wpi ?port ?portLabel ?countryLabel (GROUP_CONCAT(DISTINCT ?unlocode;separator=", ") AS ?unlocodes) ?mt (GROUP_CONCAT(DISTINCT ?website;separator=", ") AS ?websites) (GROUP_CONCAT(DISTINCT ?typeLabel;separator=", ") AS ?types) ?coordinates
  WHERE {
    ?port wdt:P31 wd:Q44782 .
    OPTIONAL { ?port wdt:P17 ?country } .
    OPTIONAL { ?port wdt:P7625 ?wpi } .
    #?port rdf:type wdno:P7625 .
    OPTIONAL { ?port wdt:P1937 ?unlocode } .
    OPTIONAL { ?port wdt:P856 ?website } .
    OPTIONAL { ?port wdt:P625 ?coordinates } .
    OPTIONAL { ?port wdt:P1624 ?mt } .
    FILTER NOT EXISTS {
      ?port p:P31 ?instance_of_statement .
      ?instance_of_statement ps:P31 wd:Q44782 .
      ?instance_of_statement ?qualifier ?value .
      ?prop wikibase:qualifier ?qualifier
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr".
                           ?port rdfs:label ?portLabel .
                           ?type rdfs:label ?typeLabel .
                           ?country rdfs:label ?countryLabel .
                           }
}
GROUP BY ?wpi ?port ?portLabel ?countryLabel ?coordinates ?mt
ORDER BY ASC(?countryLabel) ASC(?portLabel)
Try it!

Evergreen A-class container ships 

SELECT * {
  {
    SELECT * {
      ?item wdt:P289 wd:Q107241737 .
      OPTIONAL { ?item wdt:P617 ?yard_number . }
      OPTIONAL { ?item wdt:P176 ?manufacturer . }
      OPTIONAL { ?item wdt:P8047 ?country_of_registry . }
      OPTIONAL { ?item wdt:P729 ?service_entry . }
    } LIMIT 100
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en,en,de,fr,ja,es,ru,pt,it,zh,fa,ar,pl,nl,uk,tr,id,he,cs,sv,hu,fi,vi,ko,el,hi,bn,no,ca,ro,th,da,sr,bg,az,ms,et,uz,hr,sk,eu,hy,sl,lt,eo,ta,kk,lv,be,kn,sq,ur,mk" .
    ?item rdfs:label ?label . ?item schema:description ?description . ?manufacturer rdfs:label ?manufacturer_name . ?country_of_registry rdfs:label ?country_name
  }
}
Try it!

World Port Index edit

Items with a World Port Index Number 

SELECT ?wpi ?port ?portLabel (GROUP_CONCAT(DISTINCT ?unlocode;separator=", ") AS ?unlocodes) ?mt (GROUP_CONCAT(DISTINCT ?website;separator=", ") AS ?websites) (GROUP_CONCAT(DISTINCT ?typeLabel;separator=", ") AS ?types) ?coordinates
  WHERE {
    ?port wdt:P7625 ?wpi
    OPTIONAL { ?port wdt:P31 ?type } .
    OPTIONAL { ?port wdt:P7625 ?wpi } .
    OPTIONAL { ?port wdt:P1937 ?unlocode } .
    OPTIONAL { ?port wdt:P856 ?website } .
    OPTIONAL { ?port wdt:P625 ?coordinates } .
    OPTIONAL { ?port wdt:P1624 ?mt } .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr".
                           ?port rdfs:label ?portLabel .
                           ?type rdfs:label ?typeLabel}
}
GROUP BY ?wpi ?port ?portLabel ?coordinates ?mt
ORDER BY ASC(xsd:integer(?wpi))
Try it!

Port of Shenzhen map edit

Map of the locations for the port of Shenzhen 

#defaultView:Map
SELECT ?part ?partLabel ?coords
WHERE {
  {
    wd:Q1116518 wdt:P527 ?part.
    ?part wdt:P625 ?coords
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Ports in Saudi Arabia edit 

SELECT ?item ?label ?_coords ?_unlocode ?_wpi ?_mt ?_operator ?_water WHERE {
  ?item wdt:P31 wd:Q44782.
  ?item wdt:P17 wd:Q851
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" . 
    ?item rdfs:label ?label .
    ?_operatorId rdfs:label ?_operator .
    ?_waterId rdfs:label ?_water .
  }
  
OPTIONAL { ?item wdt:P625 ?_coords. }
OPTIONAL { ?item wdt:P1937 ?_unlocode. }
OPTIONAL { ?item wdt:P7625 ?_wpi. }
OPTIONAL { ?item wdt:P1624 ?_mt. }
OPTIONAL { ?item wdt:P137 ?_operatorId. }
OPTIONAL { ?item wdt:P206 ?_waterId. }
}
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Kq-hit&oldid=2093106175"