Open main menu

Property talk:P1717

Documentation

SANDRE ID
identifer of the French national Water Information System
  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, SPARQL (every item), SPARQL (by value), SPARQL (new)
  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, SPARQL, SPARQL (new)
  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, SPARQL, SPARQL (new)
  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, SPARQL, SPARQL (new)
  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, search, SPARQL, SPARQL (new)
  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, search, SPARQL, SPARQL (new)
  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, SPARQL, SPARQL (new)
  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, search, SPARQL, SPARQL (new)
 

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
  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 lengthEdit

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)

Return to "P1717" page.