Property talk:P1717

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

Sandre river ID
identifier of the French national Water Information System

Description	ID of the French national Water Information System
Associated item	Sandre (Q1520862)
Applicable "stated in" value	Référentiel Sandre (Q56317090)
Data type	External identifier
Domain	According to this template: body of water (Q15324) According to statements in the property: body of water (Q15324) When possible, data should only be stored as statements
Allowed values	[A-Z-]?[0-9-]{6,8}[AG]?
Example	Rivière du Mât (Q3433924) → 402-0100 Ariège (Q18451) → O1--0250
Source	http://www.sandre.eaufrance.fr/Rechercher-une-donnee-d-un-jeu
Formatter URL	http://www.sandre.eaufrance.fr/geo/CoursEau/$1 http://www.services.eaufrance.fr/donnees/service/$1
Tracking: usage	Category:Pages using Wikidata property P1717 (Q20990004)
Related to country	France (Q142) (See 638 others)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Database reports/Complex constraint violations/P1717 Database reports/Constraint violations/P1717 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 7,901 Main statement 5,567 70.5% of uses Qualifier 2 <0.1% of uses Reference 2,332 29.5% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1717#Unique value, SPARQL (every item), SPARQL (by value)

Format “[A-Z-]?[0-9-]{6,8}[AG]?”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P1717#Format, hourly updated report, SPARQL

Type “body of water (Q15324)”: item must contain property “instance of (P31)” with classes “body of water (Q15324)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P1717#Type Q15324, hourly updated report, SPARQL

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1717#Single value, SPARQL

Item “country (P17): France (Q142)”: Items with this property should also have “country (P17): France (Q142)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Toran River (Q21124998), no label (Q3002520)
List of violations of this constraint: Database reports/Constraint violations/P1717#Item P17, search, SPARQL

Item “mouth of the watercourse (P403)”: Items with this property should also have “mouth of the watercourse (P403)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1717#Item P403, search, SPARQL

Item “coordinate location (P625)”: Items with this property should also have “coordinate location (P625)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1717#Item P625, SPARQL

Item “drainage basin (P4614)”: Items with this property should also have “drainage basin (P4614)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1717#Item P4614, search, SPARQL

Item “country (P17)”: Items with this property should also have “country (P17)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P1717#Item P17, hourly updated report, search, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1717#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1717#Scope, SPARQL

This property is being used by: es:Plantilla:Sandre fr:Modèle:Sandre ja:Template:Sandre pt:Predefinição:Sandre uk:Шаблон:Затока, uk:Шаблон:Річка frp:Modèlo:Sandre Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Check countries
(Help)
Violations query: SELECT ?item WHERE { ?item wdt:P1717 []. ?item wdt:P17 ?country . FILTER (?item NOT IN (wd:Q584, wd:Q1369002)). FILTER (?country NOT IN (wd:Q142, wd:Q55)). FILTER (?country NOT IN (wd:Q29, wd:Q31, wd:Q32, wd:Q38, wd:Q39, wd:Q155, wd:Q183, wd:Q228, wd:Q235, wd:Q717, wd:Q730, wd:Q13116, wd:Q25227, wd:Q29999, wd:Q138837, wd:Q153943, wd:Q2290328)). } ORDER BY ?item
List of this constraint violations: Database reports/Complex constraint violations/P1717#Check countries

Number of countries crossed greater than or equal to three
This query use a blacklist for 5 items. (Help)
Violations query: SELECT ?item (COUNT(DISTINCT ?country) as ?countryCount) WHERE { ?item wdt:P1717 []. ?item wdt:P17 ?country . FILTER (?item NOT IN (wd:Q584, wd:Q1667, wd:Q37620, wd:Q41986, wd:Q635969)). } GROUP BY ?item ?itemLabel HAVING (?countryCount > 2) ORDER BY ?item
List of this constraint violations: Database reports/Complex constraint violations/P1717#Number of countries crossed greater than or equal to three

Too long river
TODO: check the unit (Help)
Violations query: SELECT ?item ?long WHERE { ?item wdt:P1717 []. ?item wdt:P2043 ?long . FILTER (?long > 1000). FILTER (?item NOT IN (wd:Q584, wd:Q1469)). } ORDER BY ?item
List of this constraint violations: Database reports/Complex constraint violations/P1717#Too long river

Source pour la longueur - Usage as reference for length

La longueur indiquée sur Sandre pour les cours d'eaux trans-frontaliers ne concerne que la partie située en France. Donc attention pour l'utilisation comme source de la length (P2043). La query citée à la fin liste les éléments ayant à la fois un Sandre river ID (P1717) et une length (P2043) et ayant plus de 2 country (P17), pour vérifications.

(Au passage, la différence entre les 2 attributs "longueur" et "longueur (en France)" n'est pas très claire. J'ai préféré utiliser la première.)

English version: For bodies of water which span accross several countries, Sandre gives only the length of the French section. It must be used carefully as reference for length (P2043). The following query lists items with both Sandre river ID (P1717) and length (P2043), and more than 2 country (P17).

[1]

--LBE (talk) 18:38, 24 May 2016 (UTC)

Autres usages de SANDRE

SANDRE référence aussi des stations de traitements des eaux usées.

Exemple : la station d'épuration de Jonquières 060984056002

--Pyrog (talk) 09:02, 8 August 2020‎ (UTC)

Codes sandre non limités aux cours d'eau

@Ayack: Les codes sandres semblent aussi indexer d'autres jeux de données que les cours d'eau, comme les « obstacles à l'écoulement ». (ex: ROE86149 est un "code sandre" qui correspondrait à Pont de Gouédic (Q101245494)). La propriété « code Sandre » actuelle n'est-elle que le sous-ensemble des codes sandre pour les cours d'eau ?

• Si oui, solution la plus simple : modifier le libellé actuel (→ « code Sandre d'un cours d'eau »), (et j'imagine rajouter d'autres propriétés pour les autres jeux de données au besoin),
• Si non, on garde le libellé actuel et on accepte tous les types de code sandre, mais ça complique l'intégration wikidata : il faut élargir les expressions régulières et les contraintes de types autorisés, et trouver un lien externe qui marche pour tous les jeux de données gérés.

-- FoeNyx (talk) 15:12, 4 December 2020 (UTC)