Property talk:P14
Documentation
graphic symbol describing the item, used at the side of or above roads to give instructions or provide information to road users
(?i).+\.(svg|png|jpg|gif|tif|tiff|jpeg|jfif|webp)
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P14#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P14#Type Q83620, Q34442, Q25631158, Q120367839, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P14#allowed qualifiers, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P14#Scope, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P14#Item P17, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P14#Item P1824, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P14#Entity types
End by 'table.svg' without Hungary (Q28) (Help)
Violations query:
SELECT ?item ?value WHERE { ?item wdt:P14 ?value. FILTER(REGEX(STR(?value), "http:\\/\\/commons\\.wikimedia\\.org\\/wiki\\/Special:FilePath\\/.*Otszogletu%20zold%20tabla.svg")) . FILTER NOT EXISTS { ?item wdt:P17 wd:Q28. } } ORDER BY ?value
List of this constraint violations: Database reports/Complex constraint violations/P14#Hungary roads
USA roads without country (P17) : United States of America (Q30) (Help)
Violations query:
SELECT ?item ?value WHERE { ?item wdt:P14 ?value. FILTER(REGEX(STR(?value), "^((?i).+(US |Alabama|Alaska|Arizona|Arkansas|California|Colorado|Connecticut|Delaware|Florida|Georgia|Hawaii|Idaho|Illinois|Indiana|Iowa|Kansas|Kentucky|Louisiana|Maine|Maryland|Massachusetts|Michigan|Minnesota|Mississippi|Missouri|Montana|Nebraska|Nevada|New Hampshire|New Jersey|New Mexico|New York|North Carolina|North Dakota|Ohio|Oklahoma|Oregon|Pennsylvania|Rhode Island|South Carolina|South Dakota|Tennessee|Texas|Utah|Vermont|Virginia|Washington|West Virginia|Wisconsin|Wyoming).+)$")) . FILTER NOT EXISTS { ?item wdt:P17 wd:Q30. } FILTER( ?item NOT IN ( wd:Q2740646 ) ) . }
List of this constraint violations: Database reports/Complex constraint violations/P14#USA roads
(Help)
Violations query:
SELECT ?item ?value ?country WHERE { ?item wdt:P14 ?value. ?item wdt:P17 ?country. FILTER(REGEX(STR(?value), "fran%C3%A7")) . FILTER(?country != wd:Q142). FILTER( ?item NOT IN ( wd:Q1666149 ) ) . }
List of this constraint violations: Database reports/Complex constraint violations/P14#French roads
Estonia (Q191) roads (Help)
Violations query:
SELECT ?item ?value ?country WHERE { ?item wdt:P14 ?value. ?item wdt:P17 ?country. FILTER(REGEX(STR(?value), "\\-EE")) . FILTER(?country != wd:Q191). }
List of this constraint violations: Database reports/Complex constraint violations/P14#EE roads
Austria (Q40) roads (Help)
Violations query:
SELECT ?item ?value ?country WHERE { ?item wdt:P14 ?value. ?item wdt:P17 ?country. FILTER(REGEX(STR(?value), "\\-AT")) . FILTER(?country != wd:Q40). }
List of this constraint violations: Database reports/Complex constraint violations/P14#AT roads
Check if a USA road image is reused on a no-USA road (Help)
Violations query:
SELECT ?item ?value ?country WHERE { ?item wdt:P14 ?value. ?item wdt:P17 ?country. FILTER(REGEX(STR(?value), "(AK|AL|AR|AS|AZ|CA|CO|CT|DC|DE|FL|FM|GA|GU|HI|IA|ID|IL|IN|KS|KY|LA|MA|MD|ME|MH|MI|MN|MO|MP|MS|MT|NC|ND|NE|NH|NJ|NM|NV|NY|OH|OK|OR|PA|PR|PW|RI|SC|SD|TN|TX|UM|UT|VA|VI|VT|WA|WI|WV|WY)\\-\\d+\\.(svg|png)")) . FILTER NOT EXISTS { ?item wdt:P17 wd:Q30. } FILTER( ?item NOT IN ( wd:Q5736742, wd:Q10343098 ) ) . }
List of this constraint violations: Database reports/Complex constraint violations/P14#Check USA images
German roads Bundesstraße (Q561431) without Bundesstraße (Q561431) (Help)
Violations query:
SELECT ?item ?value WHERE { ?item wdt:P14 ?value. FILTER(REGEX(STR(?value), "Bundesstra%C3%9Fe")) . FILTER NOT EXISTS { ?item wdt:P31 wd:Q561431} ?item wdt:P17 ?country. FILTER(?country = wd:Q183). }
List of this constraint violations: Database reports/Complex constraint violations/P14#Bundesstraße in Germany
(Help)
Violations query:
SELECT ?item { ?item wdt:P361 wd:Q262160 MINUS { ?item p:P14 [] } }
List of this constraint violations: Database reports/Complex constraint violations/P14#EuroVelo without P14
This property is being used by: Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.) |
This entity (P14) is used by Wikimedia's setting of Wikidata. Please contact the development team or file a bug on Phabricator before big changes (renaming, deletion, merging, etc.). |
Trail blazes
[edit]I have widened this so that it can include symbols used for trail blazing (Q1042490). This is useful for Template:Infobox hiking trail (Q13362630). Thierry Caro (talk) 23:18, 15 October 2016 (UTC)
Can this be used for railways/metros too?
[edit]AFAIK, it's also likely that a lot of railway/metro lines can have their corresponding icons/markers, e.g. File:JR JA line symbol.svg for Saikyō Line (Q1372061), File:Berlin_U2.svg for U2 (Q99697), etc. --Liuxinyu970226 (talk) 09:05, 2 February 2017 (UTC)
- Notified participants of WikiProject Railways --Liuxinyu970226 (talk) 01:49, 3 February 2017 (UTC)
- Seems reasonable to me. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 18:42, 3 February 2017 (UTC)
- I have no objections to this. -happy5214 20:53, 4 February 2017 (UTC)
- @Liuxinyu970226: It doesn't matter for me, but why not to use logo image (P154)?--Sascha GPD (talk) 10:46, 5 February 2017 (UTC)
Cancel distinct-values constraint (Q21502410) or not?
[edit]It looks like many Japanese and UK motorways are having overlapped road signs, and maintaining exception to constraint (P2303) qualifier values of this restriction is really more and more hard, this only wastes my RAM when editing, so instead of adding a large dozens of P2303, should we just remove this restriction now? --Liuxinyu970226 (talk) 03:00, 30 January 2020 (UTC)
- Yes, yes, yes. The US has hundreds of exceptions like these, and it's clear that this constraint makes no sense here. -happy5214 13:06, 16 June 2020 (UTC)
- I agree, this constraint does make a lot of sense, I would remove it too. Pinging the top 10 uer of this property: @Mahir256, Gz260, An Errant Knight, Liuxinyu970226, Puclik1: @3453955E08!, Apalsola, Wikidatist, Bergenga, Nvrandow:. Cheers, VIGNERON (talk) 13:40, 1 September 2022 (UTC)
- If this editor understands correctly, this issue is in particularly in reference to the traffic signs (shields) for highways and the matter of insisting that each Wikidata item (for roads) have a unique traffic sign (shield), even though they are parts of the same road using the same traffic sign (shield). There are also a growing number of items (for roads) that would still use the same sign (shield), even though the only relation between the roads is that they are of the same type (i.e., county road) and the same number.
- If this is correct, this editor fully supports removing the constraint in this situation. An Errant Knight (talk) 18:34, 1 September 2022 (UTC)
- @An Errant Knight: yes, this editor understood correctly .
- For a clear example (and a bit extreme one), the file File:Route départementale française 1.svg is used - right now - on:
- Route départementale 1 (Q3444243),
- Route départementale 1 (Q3444244),
- Route départementale 1 (Q3444245),
- Route départementale 1 (Q3444246),
- Route départementale 1 (Q3444248),
- Route départementale 1 (Q3444250),
- Route départementale 1 (Q3444253),
- Route départementale 1 (Q3444255),
- Route départementale 1 (Q16009461),
- Route départementale 1 (Q43261372),
- Route départementale 1 (Q56576249),
- Route départementale 1 (Q59531585),
- Q63859242,
- Route départementale 1 (Q91303583),
- Route départementale 1 (Q101473355),
- Route départementale 1 (Q101475162),
- Route départementale 1 (Q109391344)
- All are called "route départementale 1" ("departmental road 1") since there is a "road 1" in each French department (and actually, a lot of data are missing, there is ~100 department in France and all have a road number 1 same for road number 2, 3, 4, 5, etc.) and all have the exact same sign.
- Cheers, VIGNERON (talk) 13:37, 2 September 2022 (UTC)
- I also support the removal of this constraint. It is apparent that it is not based on a real-world scenario. It probably applies in some countries, but as long as it doesn't apply everywhere, it shouldn't be there. That mile-long list of exceptions could in itself be a proof that the constraint is failed. Bergenga (talk) 21:21, 10 September 2022 (UTC)
- I agree, this constraint does make a lot of sense, I would remove it too. Pinging the top 10 uer of this property: @Mahir256, Gz260, An Errant Knight, Liuxinyu970226, Puclik1: @3453955E08!, Apalsola, Wikidatist, Bergenga, Nvrandow:. Cheers, VIGNERON (talk) 13:40, 1 September 2022 (UTC)
- All Properties
- Properties with commonsMedia-datatype
- Properties used on 10000+ items
- Properties with Commons link constraints
- Properties with format constraints
- Properties with constraints on type
- Properties with qualifiers constraints
- Properties with scope constraints
- Properties with constraints on items using them
- Properties with entity type constraints
- Properties with complex constraints
- Entities used by Wikimedia