Field schema

The fields every polygon layer carries, with their types. Each layer repeats its parents' fields, so it works on its own.

First draft reviewed by UN80 Data QuintJuly 2026

Each polygon layer at level L carries all of the following fields. Fields whose names contain {N} repeat for every level from 0 through L, making each layer self-contained: upper-level units can be derived by dissolving on the embedded parent fields without reference to any other layer. All other fields are constant across all rows within a layer.

FieldTypeDescription
adm{N}_pcodeStringOCHA P-code. Format: ISO3 country prefix, dot delimiter, 3-digit zero-padded integer groups (e.g., AFG, AFG.001, AFG.001.012). See Format Standard above.
adm{N}_nameStringOfficial romanized name. The language is declared in lang. Not null.
adm{N}_name1StringAlternate-language name. The language is declared in lang1. Null if lang1 is null.
adm{N}_name2StringAlternate-language name. The language is declared in lang2. Null if lang2 is null.
adm{N}_name3StringAlternate-language name. The language is declared in lang3. Null if lang3 is null.
adm{N}_typeString*-50*Administrative unit type drawn from a controlled taxonomy. Values in the taxonomy may be translated into local languages.
adm{N}_srcidString -20Source-assigned code (government, GADM, OSM, or other). Null where no source code exists.
versionIntegerRelease version, identical across all rows and all levels for the same dataset release (e.g., 1).
updatedDateDate of last name / metadata change to the dataset; empty on release and populated when a minor change has been made.
valid_fromDateDate from which the dataset is valid for humanitarian use. Automatically set when a dataset is added to the global central registry.
valid_toDateEnd of validity period. Null for the current release.
langStringBCP 47 language code for adm{N}_name. Must identify a romanized script.
lang1–lang3StringBCP 47 language code for adm{N}_name1–name3. Null if the corresponding name column is unused.
area_sqkmFloatPolygon area in square kilometers, computed in an equal-area projection. WGS84 area is not used.
levelIntegerAdministrative level of this layer.
latestBoolean / IntegerVirtual field: true where valid_to is null.

Language codes MUST be valid BCP 47 tags. For each language, look up its entry in the IANA Language Subtag Registry (Type: language). If that entry defines a 2-letter Subtag (ISO 639-1), it MUST be used. A 3-letter Subtag (ISO 639-2/639-3) MUST NOT be used unless no 2-letter Subtag exists for that language.