Shortcut: WD:RIVERS

Wikidata:WikiProject Rivers

From Wikidata
Jump to navigation Jump to search

This is the project that will try to maintain and improve river items in Wikidata.

The project started with lists taken from English Wikipedia, en:List of rivers of Europe and similar articles.

River Properties[edit]

In Wikidata there are several properties to describe rivers and other waterways.

Title ID Data type Description Examples Inverse
mouth of the watercourseP403Itemriver mouth: the body of water to which the watercourse drainsVltava <mouth of the watercourse> Elbe-
origin of the watercourseP885Itemriver source: main source of a river, stream or lakeInn <origin of the watercourse> Lunghinsee-
watershed areaP2053Quantitydrainage basin: size of a stream's watershed (drainage basin)Po <watershed area> 71,000 square kilometre-
basin countryP205Itemcountry that have drainage to/from or border the body of waterVltava <basin country> Czech Republic-
tributaryP974Itemtributary: watercourse that flows into an other one (for lake inflows use P200)Mississippi River <tributary> Missouri River-
inflowsP200Iteminflow: major inflow sources — rivers, aquifers, glacial runoff, etc. Some terms may not be place names, e.g. noneLake Baikal <inflows> Upper Angara-
lake outflowP201Itemchannel runof: rivers and other outflows waterway names. If evaporation or seepage are notable outflows, they may be included. Some terms may not be place names, e.g. evaporationLake Ontario <lake outflow> St. Lawrence Riverorigin of the watercourse
lake on watercourseP469Itemlake: lakes or reservoirs the river or stream flows throughMissouri River <lake on watercourse> Lake Sharpe-
bodies of water basin categoryP1200Itemthe Wikimedia category associated with the basin of a bodies of waterDanube <bodies of water basin category> Category:Danube basin-
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Volga <instance of> river-
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Panama Canal <instance of> canal-
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Molenbeek <instance of> stream-
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Rhine <instance of> main stream-
distance from river mouthP2148Quantityriver mile and river mouth: qualifier for P974 statements on streamsProperty talk:P2148-
dischargeP2225Quantitydischarge: volume rate of water flow which is transported through a given cross-sectional areaAb-donbal qanat <discharge> 0.16 cubic metre per second-

The item is likely to have at least one of the following identifiers.

Title ID Data type Description Examples Inverse
GewässerkennzahlP1183Stringwaterbody number: a number to hydrographically order rivers and streams, use more specific properties where possiblePfreimd <Gewässerkennzahl> CZ/4-01-02-001-
GeoNames IDP1566External identifierGeoNames: identifier in the GeoNames geographical databasePiton de la Fournaise <GeoNames ID> 935877-
GNIS IDP590External identifierGNIS ID: identifier for geographic objects in the US issued by the USGS. For Antarctica, use Property:P804Lebanon <GNIS ID> 867976-
Sandre river IDP1717External identifieridentifer of the French national Water Information SystemRivière du Mât <Sandre river ID> 402-0100-
State Water Register Code (Russia)P884External identifierState Water Register: identifier of a body of water in RussiaVoyevolikhan <State Water Register Code (Russia)> 17040200112117600008474-
Lake ID (Sweden)P761External identifierSwedish National Water Information Database: Identification code for lakes in Sweden, for lakes important enough also used, with SE- prefix, as EU_CDOrlången <Lake ID (Sweden)> 656833-162888-
EU Surface Water Body CodeP2856External identifierunique EU identifier for a surface water bodyOrlången <EU Surface Water Body Code> SE656833-162888-
LAWA waterbody IDP3866External identifierGewässerkennzahl: identifier for bodies of water in Germany according to the Bund/Länder-Arbeitsgemeinschaft Wasser (LAWA)Rhine <LAWA waterbody ID> 2-

How to use[edit]

Notes[edit]

  • OpenStreetMap relation ID (P402) can be used to link a watercourse or body of water to its corresponding relation in OSM but there are no properties for nodes or ways (previous proposals were rejected because OSM IDs are not stable enough). If you want to link OSM and Wikidata, it's a good idea to add Wikidata tags to the objects in OpenStreetMap.

Watercourses, waterbodies and systems[edit]

Waterways can flow into other waterways like rivers, canals and stream or into waterbodies.

Here is a list of different watercourses: main stream (Q573344), river (Q4022), stream (Q47521), tidal creek (Q27250), canal (Q12284), gracht (Q523166), watercourse (Q355304),

Here is a list of geographical objects (mostly waterbodies) where a watercourse might flow into (mouth of the watercourse (P403) possible values) : ocean (Q9430), sea (Q165), mediterranean sea (Q986177), Adjacent sea (Q1973404), marginal sea (Q204894), strait (Q37901), gulf (Q1322134), bay (Q39594), bayou (Q812585), harbor (Q283202), inlet (Q1172599), sound (Q491713), cove (Q31615), firth (Q558116), fjord (Q45776), fjard (Q319714), estuary (Q47053), wetland (Q170321), group of lakes (Q5926864), lake (Q23397), glacial lake (Q211302), salt lake (Q188025), salt pan (Q935277), rift lake (Q6341928), volcanic crater lake (Q204324), endorheic lake (Q12779976), pluvial lake (Q7205721), Rift Valley lakes (Q2915867), meromictic lake (Q1165822), monomictic lake (Q4862338), reservoir (Q131681), ribbon lake (Q2623499), pond (Q3253281), lagoon (Q187223), estuarine lagoon (Q3705882)

Watercourses are part of watersystems: drainage basin (Q166620), drainage system (Q285451)

River Lists[edit]

Lists of Rivers / Watercourses

Tools[edit]

Wikidata contraint violation checks in for rivers:

Mix'n'match: GNIS Streams entity resolution

General Wikidata tools are here

Items without claims[edit]

Check queries[edit]

Ideally these queries should be empty at all times.

#Rivers without any coordinates
SELECT * WHERE {
  ?river wdt:P31/wdt:P279* wd:Q355304 .
  MINUS { ?river p:P625 [] }
}
Try it!
#Rivers where the source and mouth are more than 3500 km apart
SELECT * WHERE {
  ?river wdt:P31/wdt:P279* wd:Q355304 .
  ?river p:P625 [ ps:P625 ?coord1 ; pq:P518 wd:Q7376362 ] .
  ?river p:P625 [ ps:P625 ?coord2 ; pq:P518 wd:Q1233637 ] .
  BIND(geof:distance(?coord1, ?coord2) AS ?dist).
  FILTER(?dist > 3500 ).
}
Try it!
#Rivers where the source and mouth are more less 100 m apart
SELECT * WHERE {
  ?river wdt:P31/wdt:P279* wd:Q355304 .
  ?river p:P625 [ ps:P625 ?coord1 ; pq:P518 wd:Q7376362 ] .
  ?river p:P625 [ ps:P625 ?coord2 ; pq:P518 wd:Q1233637 ] .
  BIND(geof:distance(?coord1, ?coord2) AS ?dist).
  FILTER(?dist < 0.1 ).
}
Try it!


SELECT ?item ?itemLabel ?pic ?count ?coor ?dist (ROUND(?dist/10) as ?layer)
WITH
{
  SELECT ?item (COUNT(DISTINCT ?down) as ?count)
  {  ?item wdt:P177 wd:Q19686 ; wdt:P2674* ?down } 
  GROUP BY ?item
  ORDER BY DESC(?count) ?item
} as %ct
WHERE 
{
  INCLUDE %ct
  ?item wdt:P177 wd:Q19686 .
  OPTIONAL { ?item wdt:P18 ?pic }
  wd:Q19686 p:P625 [ ps:P625 ?coor_orig ; pq:P518 wd:Q7376362 ] .
  OPTIONAL { ?item wdt:P625 ?coor }
  FILTER ( ?item != wd:Q1868889 )
  BIND(ROUND(geof:distance(?coor_orig, ?coor)) as ?dist)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count) DESC(?dist) ?item
Try it!

Usage of River Data[edit]

Created by SPARQL query service.

Longest Rivers by Continent[edit]

See also[edit]