Somalia - Subnational Administrative Boundaries - som_admgz_ocha_20250108.xlsx

Somali administrative level 0-2 and operational zone level 1 and 2 gazetteer derived from ITOS tabular data

Data Dictionary

ID: OPZ2_EN
Type: text
Label: OPZ2_EN

ID: OPZ1_EN
Type: text
Label: OPZ1_EN

ID: OPZ1_ID
Type: numeric
Label: OPZ1_ID

ID: ADM2_EN
Type: text
Label: ADM2_EN

ID: ADM2_PCODE
Type: text
Label: ADM2_PCODE

ID: ADM1_EN
Type: text
Label: ADM1_EN

ID: ADM1_PCODE
Type: text
Label: ADM1_PCODE

ID: ADM0_EN
Type: text
Label: ADM0_EN

ID: ADM0_PCODE
Type: text
Label: ADM0_PCODE

ID: AREA_SQKM
Type: numeric
Label: AREA_SQKM

Additional Information

Field	Value
Data last updated	January 15, 2025
Metadata last updated	May 23, 2025
Created	December 20, 2022
Format	XLSX
License	cc-by-igo
Alt url	https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/
Datastore active	True
Download url	https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_admgz_ocha_20250108.xlsx
Fs check info	[{"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2023-03-09T21:26:45.634383"}, {"state": "success", "message": "Hxl Proxy data received successfully", "timestamp": "2023-03-09T21:26:50.422034", "hxl_proxy_response": {"url_or_filename": "https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_adminboundaries_tabulardata.xlsx", "format": "XLSX", "sheets": [{"name": "OPZ2", "is_hidden": false, "nrows": 25, "ncols": 16, "has_merged_cells": false, "is_hxlated": false, "header_hash": "2629c6a017afacb9c0cbacd28cfac0f3", "hashtag_hash": null}, {"name": "OPZ1", "is_hidden": false, "nrows": 333, "ncols": 14, "has_merged_cells": false, "is_hxlated": false, "header_hash": "d61fa4dc65b2c0ad753dd3c28cf0f22e", "hashtag_hash": null}, {"name": "Admin2", "is_hidden": false, "nrows": 75, "ncols": 17, "has_merged_cells": false, "is_hxlated": false, "header_hash": "6f4ffaf3a3518efd3f118bdcb5cb8323", "hashtag_hash": null}, {"name": "Admin1", "is_hidden": false, "nrows": 19, "ncols": 12, "has_merged_cells": false, "is_hxlated": false, "header_hash": "cee23a97044938d591bc5c592510229a", "hashtag_hash": null}, {"name": "State", "is_hidden": false, "nrows": 9, "ncols": 29, "has_merged_cells": false, "is_hxlated": false, "header_hash": "5e51ce314d2d1aee33bca1a3c6ae6b5b", "hashtag_hash": null}, {"name": "Admin0", "is_hidden": false, "nrows": 2, "ncols": 10, "has_merged_cells": false, "is_hxlated": false, "header_hash": "462220d1392ef702848171bd1b089198", "hashtag_hash": null}]}}, {"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2023-03-15T15:41:30.681830"}, {"state": "success", "message": "Hxl Proxy data received successfully", "timestamp": "2023-03-15T15:41:35.259846", "hxl_proxy_response": {"url_or_filename": "https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_adminboundaries_tabulardata.xlsx", "format": "XLSX", "sheets": [{"name": "OPZ2", "is_hidden": false, "nrows": 25, "ncols": 16, "has_merged_cells": false, "is_hxlated": false, "header_hash": "2629c6a017afacb9c0cbacd28cfac0f3", "hashtag_hash": null}, {"name": "OPZ1", "is_hidden": false, "nrows": 333, "ncols": 14, "has_merged_cells": false, "is_hxlated": false, "header_hash": "d61fa4dc65b2c0ad753dd3c28cf0f22e", "hashtag_hash": null}, {"name": "Admin2", "is_hidden": false, "nrows": 75, "ncols": 17, "has_merged_cells": false, "is_hxlated": false, "header_hash": "6f4ffaf3a3518efd3f118bdcb5cb8323", "hashtag_hash": null}, {"name": "Admin1", "is_hidden": false, "nrows": 19, "ncols": 12, "has_merged_cells": false, "is_hxlated": false, "header_hash": "cee23a97044938d591bc5c592510229a", "hashtag_hash": null}, {"name": "State", "is_hidden": false, "nrows": 9, "ncols": 29, "has_merged_cells": false, "is_hxlated": false, "header_hash": "5e51ce314d2d1aee33bca1a3c6ae6b5b", "hashtag_hash": null}, {"name": "Admin0", "is_hidden": false, "nrows": 2, "ncols": 10, "has_merged_cells": false, "is_hxlated": false, "header_hash": "462220d1392ef702848171bd1b089198", "hashtag_hash": null}]}}, {"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2023-03-15T16:04:33.331668"}, {"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2025-01-15T21:24:53.875035"}, {"state": "success", "message": "File structure check completed", "timestamp": "2025-01-15T21:24:56.943105", "sheet_changes": [{"name": "ADM2", "event_type": "spreadsheet-sheet-created", "changed_fields": ""}, {"name": "ADM1", "event_type": "spreadsheet-sheet-created", "changed_fields": ""}, {"name": "ADM0", "event_type": "spreadsheet-sheet-created", "changed_fields": ""}, {"name": "Admin2", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "Admin0", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "State", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "Admin1", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "OPZ2", "event_type": "spreadsheet-sheet-changed", "changed_fields": [{"field": "header_hash", "new_value": "ca3876633ec0dd085d2c9104d8089d49", "new_display_value": "ca3876633ec0dd085d2c9104d8089d49", "old_value": "2629c6a017afacb9c0cbacd28cfac0f3", "old_display_value": "2629c6a017afacb9c0cbacd28cfac0f3"}, {"field": "ncols", "new_value": 10, "new_display_value": 10, "old_value": 16, "old_display_value": 16}]}, {"name": "OPZ1", "event_type": "spreadsheet-sheet-changed", "changed_fields": [{"field": "header_hash", "new_value": "93905821759f15e1a6485d7c437a9fd7", "new_display_value": "93905821759f15e1a6485d7c437a9fd7", "old_value": "d61fa4dc65b2c0ad753dd3c28cf0f22e", "old_display_value": "d61fa4dc65b2c0ad753dd3c28cf0f22e"}, {"field": "ncols", "new_value": 8, "new_display_value": 8, "old_value": 14, "old_display_value": 14}]}], "hxl_proxy_response": {"url_or_filename": "https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_admgz_ocha_20250108.xlsx", "format": "XLSX", "sheets": [{"name": "OPZ2", "is_hidden": false, "nrows": 25, "ncols": 10, "has_merged_cells": false, "is_hxlated": false, "header_hash": "ca3876633ec0dd085d2c9104d8089d49", "hxl_header_hash": null, "headers": ["OPZ2_EN", "OPZ1_EN", "OPZ1_ID", "ADM2_EN", "ADM2_PCODE", "ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "OPZ1", "is_hidden": false, "nrows": 333, "ncols": 8, "has_merged_cells": false, "is_hxlated": false, "header_hash": "93905821759f15e1a6485d7c437a9fd7", "hxl_header_hash": null, "headers": ["OPZ1_EN", "ADM2_EN", "ADM2_PCODE", "ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "ADM2", "is_hidden": false, "nrows": 92, "ncols": 8, "has_merged_cells": false, "is_hxlated": false, "header_hash": "131b535cbb5143de842c6019c281676e", "hxl_header_hash": null, "headers": ["ADM2_EN", "ADM2_PCODE", "ADM2_REF", "ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "ADM1", "is_hidden": false, "nrows": 19, "ncols": 5, "has_merged_cells": false, "is_hxlated": false, "header_hash": "7030286b2d7e2c231b7c1fdbec135720", "hxl_header_hash": null, "headers": ["ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "ADM0", "is_hidden": false, "nrows": 2, "ncols": 3, "has_merged_cells": false, "is_hxlated": false, "header_hash": "adc3ec1c8ec31a4043955e41eb2261d2", "hxl_header_hash": null, "headers": ["ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}]}}]
Has views	True
Hash	340f8c8d53f1c1c3f24b55400836047e
Hdx rel url	/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_admgz_ocha_20250108.xlsx
Id	2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5
Microdata	False
Mimetype	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Originalhash	-1,378,639,868
P coded	True
Package id	ec140a63-5330-4376-a3df-c7ebf73cfc3c
Pii	false
Position	0
Preview	True
Preview rows	24
Resource type	file.upload
Size	39.6 KiB
State	active
Total record count	24
Tracking summary	{'total': 0, 'recent': 0}

Field

Value

Data last updated

January 15, 2025

Metadata last updated

May 23, 2025

Created

December 20, 2022

Format

XLSX

License

cc-by-igo

Alt url

https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/

Datastore active

True

Download url

https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_admgz_ocha_20250108.xlsx

Fs check info

[{"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2023-03-09T21:26:45.634383"}, {"state": "success", "message": "Hxl Proxy data received successfully", "timestamp": "2023-03-09T21:26:50.422034", "hxl_proxy_response": {"url_or_filename": "https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_adminboundaries_tabulardata.xlsx", "format": "XLSX", "sheets": [{"name": "OPZ2", "is_hidden": false, "nrows": 25, "ncols": 16, "has_merged_cells": false, "is_hxlated": false, "header_hash": "2629c6a017afacb9c0cbacd28cfac0f3", "hashtag_hash": null}, {"name": "OPZ1", "is_hidden": false, "nrows": 333, "ncols": 14, "has_merged_cells": false, "is_hxlated": false, "header_hash": "d61fa4dc65b2c0ad753dd3c28cf0f22e", "hashtag_hash": null}, {"name": "Admin2", "is_hidden": false, "nrows": 75, "ncols": 17, "has_merged_cells": false, "is_hxlated": false, "header_hash": "6f4ffaf3a3518efd3f118bdcb5cb8323", "hashtag_hash": null}, {"name": "Admin1", "is_hidden": false, "nrows": 19, "ncols": 12, "has_merged_cells": false, "is_hxlated": false, "header_hash": "cee23a97044938d591bc5c592510229a", "hashtag_hash": null}, {"name": "State", "is_hidden": false, "nrows": 9, "ncols": 29, "has_merged_cells": false, "is_hxlated": false, "header_hash": "5e51ce314d2d1aee33bca1a3c6ae6b5b", "hashtag_hash": null}, {"name": "Admin0", "is_hidden": false, "nrows": 2, "ncols": 10, "has_merged_cells": false, "is_hxlated": false, "header_hash": "462220d1392ef702848171bd1b089198", "hashtag_hash": null}]}}, {"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2023-03-15T15:41:30.681830"}, {"state": "success", "message": "Hxl Proxy data received successfully", "timestamp": "2023-03-15T15:41:35.259846", "hxl_proxy_response": {"url_or_filename": "https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_adminboundaries_tabulardata.xlsx", "format": "XLSX", "sheets": [{"name": "OPZ2", "is_hidden": false, "nrows": 25, "ncols": 16, "has_merged_cells": false, "is_hxlated": false, "header_hash": "2629c6a017afacb9c0cbacd28cfac0f3", "hashtag_hash": null}, {"name": "OPZ1", "is_hidden": false, "nrows": 333, "ncols": 14, "has_merged_cells": false, "is_hxlated": false, "header_hash": "d61fa4dc65b2c0ad753dd3c28cf0f22e", "hashtag_hash": null}, {"name": "Admin2", "is_hidden": false, "nrows": 75, "ncols": 17, "has_merged_cells": false, "is_hxlated": false, "header_hash": "6f4ffaf3a3518efd3f118bdcb5cb8323", "hashtag_hash": null}, {"name": "Admin1", "is_hidden": false, "nrows": 19, "ncols": 12, "has_merged_cells": false, "is_hxlated": false, "header_hash": "cee23a97044938d591bc5c592510229a", "hashtag_hash": null}, {"name": "State", "is_hidden": false, "nrows": 9, "ncols": 29, "has_merged_cells": false, "is_hxlated": false, "header_hash": "5e51ce314d2d1aee33bca1a3c6ae6b5b", "hashtag_hash": null}, {"name": "Admin0", "is_hidden": false, "nrows": 2, "ncols": 10, "has_merged_cells": false, "is_hxlated": false, "header_hash": "462220d1392ef702848171bd1b089198", "hashtag_hash": null}]}}, {"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2023-03-15T16:04:33.331668"}, {"state": "processing", "message": "The processing of the file structure check has started", "timestamp": "2025-01-15T21:24:53.875035"}, {"state": "success", "message": "File structure check completed", "timestamp": "2025-01-15T21:24:56.943105", "sheet_changes": [{"name": "ADM2", "event_type": "spreadsheet-sheet-created", "changed_fields": ""}, {"name": "ADM1", "event_type": "spreadsheet-sheet-created", "changed_fields": ""}, {"name": "ADM0", "event_type": "spreadsheet-sheet-created", "changed_fields": ""}, {"name": "Admin2", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "Admin0", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "State", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "Admin1", "event_type": "spreadsheet-sheet-deleted", "changed_fields": ""}, {"name": "OPZ2", "event_type": "spreadsheet-sheet-changed", "changed_fields": [{"field": "header_hash", "new_value": "ca3876633ec0dd085d2c9104d8089d49", "new_display_value": "ca3876633ec0dd085d2c9104d8089d49", "old_value": "2629c6a017afacb9c0cbacd28cfac0f3", "old_display_value": "2629c6a017afacb9c0cbacd28cfac0f3"}, {"field": "ncols", "new_value": 10, "new_display_value": 10, "old_value": 16, "old_display_value": 16}]}, {"name": "OPZ1", "event_type": "spreadsheet-sheet-changed", "changed_fields": [{"field": "header_hash", "new_value": "93905821759f15e1a6485d7c437a9fd7", "new_display_value": "93905821759f15e1a6485d7c437a9fd7", "old_value": "d61fa4dc65b2c0ad753dd3c28cf0f22e", "old_display_value": "d61fa4dc65b2c0ad753dd3c28cf0f22e"}, {"field": "ncols", "new_value": 8, "new_display_value": 8, "old_value": 14, "old_display_value": 14}]}], "hxl_proxy_response": {"url_or_filename": "https://data.humdata.org/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_admgz_ocha_20250108.xlsx", "format": "XLSX", "sheets": [{"name": "OPZ2", "is_hidden": false, "nrows": 25, "ncols": 10, "has_merged_cells": false, "is_hxlated": false, "header_hash": "ca3876633ec0dd085d2c9104d8089d49", "hxl_header_hash": null, "headers": ["OPZ2_EN", "OPZ1_EN", "OPZ1_ID", "ADM2_EN", "ADM2_PCODE", "ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "OPZ1", "is_hidden": false, "nrows": 333, "ncols": 8, "has_merged_cells": false, "is_hxlated": false, "header_hash": "93905821759f15e1a6485d7c437a9fd7", "hxl_header_hash": null, "headers": ["OPZ1_EN", "ADM2_EN", "ADM2_PCODE", "ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "ADM2", "is_hidden": false, "nrows": 92, "ncols": 8, "has_merged_cells": false, "is_hxlated": false, "header_hash": "131b535cbb5143de842c6019c281676e", "hxl_header_hash": null, "headers": ["ADM2_EN", "ADM2_PCODE", "ADM2_REF", "ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "ADM1", "is_hidden": false, "nrows": 19, "ncols": 5, "has_merged_cells": false, "is_hxlated": false, "header_hash": "7030286b2d7e2c231b7c1fdbec135720", "hxl_header_hash": null, "headers": ["ADM1_EN", "ADM1_PCODE", "ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}, {"name": "ADM0", "is_hidden": false, "nrows": 2, "ncols": 3, "has_merged_cells": false, "is_hxlated": false, "header_hash": "adc3ec1c8ec31a4043955e41eb2261d2", "hxl_header_hash": null, "headers": ["ADM0_EN", "ADM0_PCODE", "AREA_SQKM"], "hxl_headers": null}]}}]

Has views

True

Hash

340f8c8d53f1c1c3f24b55400836047e

Hdx rel url

/dataset/ec140a63-5330-4376-a3df-c7ebf73cfc3c/resource/2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5/download/som_admgz_ocha_20250108.xlsx

2bb93a9e-bb50-42e3-bd30-5b0f86b16ee5

Microdata

False

Mimetype

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Originalhash

-1,378,639,868

P coded

True

Package id

ec140a63-5330-4376-a3df-c7ebf73cfc3c

Pii

false

Position

Preview

True

Preview rows

Resource type

file.upload

Size

39.6 KiB

State

active

Total record count

Tracking summary

{'total': 0, 'recent': 0}

som_admgz_ocha_20250108.xlsx

Embed resource view

Data Dictionary

1.OPZ2_EN text

2.OPZ1_EN text

3.OPZ1_ID numeric

4.ADM2_EN text

5.ADM2_PCODE text

6.ADM1_EN text

7.ADM1_PCODE text

8.ADM0_EN text

9.ADM0_PCODE text

10.AREA_SQKM numeric

Additional Information