Property talk:P3990

Documentation

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

BG EKATTE place ID
Bulgarian place ID (settlement, community=Kmetstvo, municipality=Obshtina, province=Oblast) by the BG National Statistical Institute (NSI)

Description	Bulgarian place ID (settlement, community=Kmetstvo, municipality=Obshtina, province=Oblast by BG National Statistical Institute (NSI)
Represents	EKATTE (Q3658617)
Data type	External identifier
Template parameter	"екатте" in bg:Шаблон:Селище_в_България
Domain	Places in Bulgaria (note: this should be moved to the property statements)
Allowed values	According to this template: string: (\d{6}|[A-Z]{3}\d{2})(-\d{2})? According to statements in the property: (\d{5}|[A-Z]{3}\d{2})(-\d{2})? When possible, data should only be stored as statements
Usage notes	To record kmetstvo ID, add qualifier "applies to part" (P518), eg Sofia (Q472) P3990 ЕКАТТE ID "SOF46-00", applies to part Kmetstvo (Q4224624)
Example	According to this template: Eg a few examples of the admin hierarchy in Kardzhali province: Kardzhali Province (Q1104675) → KRZ / applies to part (P518) Oblast (province) Krumovgrad Municipality (Q545555) → KRZ15 / Obshtina (municipality) Krumovgrad (Q406057) → 39970 / settlement (town), KRZ15-00 / Kmetstvo (community) Avren (Q2714851) → 00093 / settlement (village), KRZ15-01 / Kmetstvo (community) More complicated around Sofia: Sofia Province (Q202904) → SFO / Oblast (province) Sofia City Province (Q1585725) → SOF / Oblast (province) Sofia Capital Municipality (Q4442915) → SOF46 / Obshtina (municipality) Sofia (Q472) → 68134 as settlement (city), SOF46-00 / Kmetstvo (community) Bankya District (Q9305797) → 68134-24 / Raion (quarter) of Sofia. Includes city of Bankya Bankya (Q806817) → 02659 / settlement (city). Part of Sofia community, so no separate community code According to statements in the property: Kardzhali Province (Q1104675) → KRZ Krumovgrad Municipality (Q545555) → KRZ15 Krumovgrad (Q406057) → 39970 Avren (Q2714851) → 00093 Sofia Province (Q202904) → SFO Sofia City Province (Q1585725) → SOF Sofia Capital Municipality (Q4442915) → SOF46 Sofia (Q472) → 68134 Bankya District (Q9305797) → 68134-24 Bankya (Q806817) → 02659 When possible, data should only be stored as statements
Source	http://www.nsi.bg/nrnm/index.php?ezik=en http://www.nsi.bg/sites/default/files/files/EKATTE/Ekatte.zip
Robot and gadget jobs	http://www.nsi.bg/sites/default/files/files/EKATTE/Ekatte.zip, http://bg.dbpedia.org/sparql (see bg:Уикипедия:Разговори#ЕКАТТЕ for query)
Related to country	Bulgaria (Q219) (See 13 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/Constraint violations/P3990 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 10,931 Main statement 10,921 >99.9% of uses Qualifier 10 <0.1% of uses
Search for values

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

Format “(\d{5}|[A-Z]{3}\d{2})(-\d{2})?”: value must be formatted using this pattern (PCRE syntax). (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/P3990#Format, SPARQL

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

List of violations of this constraint: Database reports/Constraint violations/P3990#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/P3990#Entity types

This property is being used by: bg:Шаблон:Селище в България uk:Шаблон:НП Болгарії Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Added EKATTE data

31 May 2017: added 7362 EKATTE codes to 5305 settlements, see this query. Thanks to Plamen Tarkalanov from Ontotext! --Vladimir Alexiev (talk) 09:08, 6 June 2017 (UTC)