Property talk:P4496
Documentation
code in the statistical classification of economic activities in the European Community (NACE rev.2)
List of violations of this constraint: Database reports/Constraint violations/P4496#Type Q8187769, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P4496#Unique value, SPARQL (every item), SPARQL (by value)
List of violations of this constraint: Database reports/Constraint violations/P4496#Single value, SPARQL
[A-Z]|\d{2}|\d{2}\.\d|\d{2}\.\d{2}”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P4496#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P4496#Conflicts with P31, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P4496#Entity types
How to link to the entries by notation?[edit]
WikiProject Taxonomy has more than 50 participants and couldn't be pinged. Please post on the WikiProject's talk page instead.
Notified participants of WikiProject Economics
Notified participants of WikiProject Companies
Unfortunately http://ec.europa.eu/eurostat/ramon/nomenclatures/index.cfm?TargetUrl=LST_NOM_DTL&StrNom=NACE_REV2&StrLanguageCode=EN does not support linking to search results (it uses a HTTP POST). It's problematic not being able to click on a value and get to the classification for verification. Is there any other copy of NACE to link to? -- JakobVoss (talk) 20:49, 7 November 2017 (UTC)
- https://ec.europa.eu/competition/mergers/cases/index/nace_all.html is a nice page listing all NACE codes hierarchically
- I may be crazy but it seems this can serve as property formatter:
- https://ec.europa.eu/eurostat/ramon/nomenclatures/index.cfm?TargetUrl=DSP_NOM_DTL_VIEW&StrNom=NACE_REV2&StrLanguageCode=EN&IntPcKey=&IntKey=$1&StrLayoutCode=HIERARCHIC&IntCurrentPage=1
- where $1 is 18493724 for the first row of the page (18493724 A - Agriculture, forestry and fishing)
- then you increment by 30 for each row. But there's some discrepancy along the way, eg (plain=computed, link=actual):
- Any takers to try and figure this out completely?
- Then we need a resolver at toolserver --Vladimir Alexiev (talk) 14:46, 22 November 2021 (UTC)
NACE version[edit]
NACE code rev.2 (P4496) has Wikidata item of this property (P1629) Statistical Classification of Economic Activities in the European Community, Rev. 2 (2008) (Q732298), but the latter refers to editions (1, ) 1.1 and 2.0. --AVRS (talk) 19:59, 9 December 2017 (UTC)
added Constraints, please help to work out WD Industry hierarchy[edit]
WikiProject Taxonomy has more than 50 participants and couldn't be pinged. Please post on the WikiProject's talk page instead.
Notified participants of WikiProject Economics
Notified participants of WikiProject Companies
I've added Unique values, Single-value and Format constraints to "NACE code".
- Until the "constraint exceptions" pages are populated, you can check them from the "SPARQL" links above.
- For Format Violations, use this simpler query
SELECT ?item ?itemLabel ?value WHERE {
?item wdt:P4496 ?value
filter(!REGEX(STR(?value), "^([A-Z]|\\d{2}|\\d{2}\\.\\d|\\d{2}\\.\\d{2})$" ))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,no,nn,nb,fr,de" } .
} order by ?value
- The NACE hierarchy is an excellent way to organize and flesh out the WD Industry hierarchy
- This query finds all WD items used as "industry" and returns their NACE and SIC codes:
select ?ind ?indLabel ?sic ?nace ?c {
{select ?ind (count(*) as ?c) {?x wdt:P452 ?ind} group by ?ind}
optional {?ind wdt:P3242 ?sic}
optional {?ind wdt:P3242 ?nace}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,fr,it,ru,nn,no,nl,ja" }
} order by desc(?c)
- Eg I used it to find and merge items like
- Q4498099 Хлебопекарное и кондитерское производства to Q12167297 bakery industry (хлебобулочная промышленность)
- Q10689377 TV-distribution (sv) to Q4453957 телевизионное вещание (television broadcasting).
- The Single-value constraint is a bit too strong: exceptions are possible when division=group=class (eg 37=37.0=37.00). But I think it's better to leave it active for now until we fix actual problems, and disable it later.
- I posted some problems on a couple of user pages; everyone should avoid such errors:
Need your help to check Wikidata industries against the NACE classification! --Vladimir Alexiev (talk) 15:04, 22 November 2021 (UTC)
constraint "NOT instance of Organization or subclass"[edit]
This prop already has "type constraint; relation: instance of; class: economic activity".
But people still attach it to specific organizations rather than industries.
So how can I add a constraint "NOT instance of Organization or a subclass thereof"? I tried two ways but it complains (in red above):
- conflicts-with constraint; relation: instance or subclass of; item of property constraint: organization
- conflicts-with constraint; relation: instance or subclass of; class: organization
It works with:
- conflicts-with constraint; property: instance of; item of property constraint: organization
But:
- Only direct instances of "organization" are checked, as per this query, 105 results (after removing LIMIT 100)
- If I add the usual P279*, this query returns 225 results (times out sometimes)
@Jura1: is there a way to include "or subclass of" in a "conflicts-with constraint"? --Vladimir Alexiev (talk) 08:59, 23 November 2021 (UTC)
Documentation - Requêtes Wikidata[edit]
(en français, adaptables aux autres langues)
Arpyia (talk) 09:17, 3 December 2022 (UTC)
- Excellent! --Vladimir Alexiev (talk) 09:26, 27 September 2023 (UTC)
Merge singleton classes with their subclasses[edit]
https://www.wikidata.org/w/index.php?title=Talk%3AQ112122645#merge_to_plant_propagation_(Q29584389)
This also means that "single value" constraint should be removed.
@Arpyia: do you agree? Vladimir Alexiev (talk) 09:31, 27 September 2023 (UTC)
Merge "n.e.c" classes to parent class[edit]
Consider this part of the hierarchy:
S96 - Other personal service activities S96.0 - Other personal service activities S96.0.1 - Washing and (dry-)cleaning of textile and fur products S96.0.2 - Hairdressing and other beauty treatment S96.0.3 - Funeral and related activities S96.0.4 - Physical well-being activities S96.0.9 - Other personal service activities n.e.c.
(This is from a display version of NACE that includes the letter. The "official NACE code of eg S96.0.9 is "96.09")
The previous section asks to merge S96 with S96.0 because it means the same thing (S96 has a singleton child).
I'd also like to propose to merge S96.0.9 to the same node S96: i.e. merge "foo n.e.c." (not elsewhere classified) to "foo". I think that the distinction between "foo" and "foo n.e.c." is not significant for WD and is not appropriate for an encyclopedic knowledge graph like WD.
@Arpyia: what do you think? Vladimir Alexiev (talk) 09:39, 27 September 2023 (UTC)
formatter URL[edit]
I added this formatter URL:
https://showvoc.op.europa.eu/#/datasets/ESTAT_Statistical_Classification_of_Economic_Activities_in_the_European_Community_Rev._2.1._%28NACE_2.1%29/data?resId=http:%2F%2Fdata.europa.eu%2Fux2%2Fnace2.1%2F$1
For example, 01.11 Growing of cereals, other than rice, leguminous crops and oil seeds
However, we need an extra feature in Wikidata External ID redirector (Q108047563): remove the dot in the middle, i.e. from "01.11" to "0111".
Posted https://github.com/arthurpsmith/wikidata-tools/issues/32 -- Vladimir Alexiev (talk) 10:20, 27 September 2023 (UTC)
change to externalId[edit]
ArthurPSmith (talk • contribs • logs) wrote in https://github.com/arthurpsmith/wikidata-tools/issues/32: "won't work because the property datatype is set to "string". Formatter URL's are only used for External ID data types". Can a property creator please change P4496 to "externalID" ? --Vladimir Alexiev (talk) 13:38, 22 December 2023 (UTC)
- Wikidata:Property_proposal/NACE_code says "it's a classification code, so the same code may be applied to many different wikidata items. String datatype is correct.".--GZWDer (talk) 15:48, 22 December 2023 (UTC)
- As you can see at https://www.wikidata.org/wiki/Property:P4496#P2302:
- It's applied to "economic activities" (not to companies)
- There is a Distinct Values constraint and there are no violations: https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P4496#Unique_value
- So I don't think the quote is correct. It is by @ArthurPSmith: can you comment? -- Vladimir Alexiev (talk) 07:07, 23 February 2024 (UTC)
- Sounds good to me to change the datatype to external ID then. ArthurPSmith (talk) 11:08, 27 February 2024 (UTC)
- As you can see at https://www.wikidata.org/wiki/Property:P4496#P2302:
- All Properties
- Properties with external-id-datatype
- Properties used on 1000+ items
- Properties with constraints on type
- Properties with scope constraints
- Properties with unique value constraints
- Properties with single value constraints
- Properties with format constraints
- Properties with conflicts with constraints
- Properties with entity type constraints