Property talk:P1717

From Wikidata
Jump to navigation Jump to search

Documentation

SANDRE ID
identifer of the French national Water Information System
DescriptionID of the French national Water Information System
Associated itemSandre (Q1520862)
Data typeExternal 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]?
ExampleRivière du Mât (Q3433924)402-0100
Ariège (Q18451)O1--0250
Sourcehttp://www.sandre.eaufrance.fr/Rechercher-une-donnee-d-un-jeu
Formatter URLhttp://www.sandre.eaufrance.fr/geo/CoursEau/$1
Tracking: usageCategory:Pages using Wikidata property P1717 (Q20990004)
Related to countryFlag of France.svg France (Q142) (See 304 others)
Lists
Proposal discussionProposal discussion
Current uses4,131
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.
List of this constraint violations: Database reports/Constraint violations/P1717#Unique value
Format “[A-Z-]?[0-9-]{6,8}[AG]?: value must be formatted using this pattern (PCRE syntax). (Help)
List of this constraint violations: Database reports/Constraint violations/P1717#Format, hourly updated report
Type “body of water (Q15324): element must contain property “instance of (P31)” with classes “body of water (Q15324)” or their subclasses (defined using subclass of (P279)). (Help)
List of this constraint violations: Database reports/Constraint violations/P1717#type Q15324, hourly updated report
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist.
List of this constraint violations: Database reports/Constraint violations/P1717#Single value
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. Known exceptions: no label (Q21124998), no label (Q3002520)
List of this constraint violations: Database reports/Constraint violations/P1717#Item P17
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.
List of this constraint violations: Database reports/Constraint violations/P1717#Item P403
Item “coordinate location (P625): Items with this property should also have “coordinate location (P625)”. (Help)
Exceptions are possible as rare values may exist.
List of this constraint violations: Database reports/Constraint violations/P1717#Item P625
Item “drainage basin (P4614): Items with this property should also have “drainage basin (P4614)”. (Help)
Exceptions are possible as rare values may exist.
List of this constraint violations: Database reports/Constraint violations/P1717#Item P4614

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Pictogram voting comment.svg 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
Pictogram voting comment.svg 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
Pictogram voting comment.svg Check length
TODO: check the unit (Help)
Violations query: SELECT ?item ?long WHERE { ?item wdt:P1717 []. ?item wdt:P2043 ?long . FILTER (?long > 1000
List of this constraint violations: Database reports/Complex constraint violations/P1717#Check length



Source pour la longueur - Usage as reference for length[edit]

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 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 ID (P1717) and length (P2043), and more than 2 country (P17).

[1]

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