| # | Table | Primary Key | Dashboard |
|---|---|---|---|
| 1 | geographic_region | sm_code int | 02 Geography |
| 2 | regional_population | population_id serial | 03 Population |
| 3 | Ownership | ownership_id serial | 04 Ownership |
| 4 | parcel | land_id serial | 05 Land |
| 5 | regional_crop | crop_id serial | 06 Crops |
| 6 | regional_livestock | livestock_id serial | 06 Livestock |
| 7 | regional_irrigation | irrigation_id serial | 07 Irrigation |
| 8 | regional_institutions | institution_id serial | 08 Institutions |
| 9 | regional_information_access | access_id serial | 08 Info Access |
| 10 | regional_aquaculture | aquaculture_id serial | 08 Aquaculture |
geographic_region — Administrative hierarchy and enumeration area metadata| Field | Type | Constraint | Description |
|---|---|---|---|
| sm_codePK | integer | NOT NULL | Unique sub-municipality identifier — used as FK in all 9 related tables |
| sub_municipality | varchar(100) | NOT NULL | Name of the sub-municipality administrative unit |
| m_code | integer | NOT NULL | Parent municipality code for geographic grouping / aggregation |
| municipality | varchar(100) | NOT NULL | Name of the parent municipality |
| no_of_eas | integer | nullable | Number of enumeration areas within this sub-municipality |
| census_year | integer | NOT NULL | Year the census data was collected — enables multi-year comparisons |
regional_population — Total and agricultural population and household statistics| Field | Type | Description |
|---|---|---|
| population_idPK | serial | Auto-increment primary key |
| sm_codeFK | integer | References geographic_region.sm_code |
| total_households | integer | Total number of households in sub-municipality |
| agricultural_households | integer | Households engaged in agricultural activities |
| total_population | integer | Total registered population count |
| agricultural_population | integer | Population engaged in agricultural activities |
Ownership — Individual and joint land ownership disaggregated by gender of household head| Field | Type | Description |
|---|---|---|
| ownership_idPK | serial | Auto-increment primary key |
| sm_codeFK | integer | References geographic_region |
| individual_owner_male_headed_households | integer | HH with individual land ownership, male head |
| individual_owner_female_headed_households | integer | HH with individual land ownership, female head |
| joint_owners_male_headed_households | integer | HH with joint land ownership, male head |
| joint_owners_female_headed_households | integer | HH with joint land ownership, female head |
| agricultural_male_headed_households | integer | Agricultural HH with male head |
| agricultural_female_headed_households | integer | Agricultural HH with female head |
parcel — Land area (ha) and parcel counts by agricultural use type| Land Use Type | Area Field (ha) | Parcel Count Field | Notes |
|---|---|---|---|
| 🌾 Temporary Crops | temporary_crops_area_ha | temporary_crop_parcels | Seasonal, annually replanted crops |
| 🌿 Temporary Fallow | temporary_fallow_area_ha | temporary_fallow_parcels | Resting land in crop rotation cycle |
| 🌱 Temp. Meadows/Pastures | temporary_meadows_pastures_area_ha | temporary_meadows_pastures_parcels | Short-term grazing land |
| 🌳 Permanent Crops | permanent_crops_area_ha | permanent_crop_parcels | Orchards, vineyards, tree crops |
| 🟢 Perm. Meadows/Pastures | permanent_meadows_pastures_area_ha | permanent_meadows_pastures_parcels | Long-term grazing and fodder land |
| 🏚 Farm Buildings/Farmyards | farm_buildings_farmyards_area_ha | farm_buildings_farmyards_parcels | Structures and operational farm areas |
| 🐟 Aquaculture | aquaculture_area_ha | aquaculture_parcels | Fish/shrimp ponds and water areas |
| ⬜ Other | other_area_ha | other_parcels | Unclassified agricultural land |
| 📊 Totals | total_land_area_ha | total_parcels | Aggregate area and parcel count |
regional_crop + regional_livestock — Farm household types and animal headcounts| Field | Type | Description |
|---|---|---|
| crop_idPK | serial | Auto-increment PK |
| sm_codeFK | integer | Sub-municipality reference |
| no_of_farm_households | integer | Total farm households in the region |
| households_cultivated_crops_last_12m | integer | HH that actively cultivated in past year |
| households_with_permanent_crops | integer | HH with orchards, tree crops, etc. |
| households_with_temp_crops | integer | HH with seasonal annual crops |
| households_with_both | integer | HH with both permanent and temporary crops |
| households_without_crops | integer | Farm HH with no active crop cultivation |
| Field | Type | Category |
|---|---|---|
| livestock_idPK | serial | — |
| sm_codeFK | integer | — |
| no_households_owning_livestock | integer | HH Summary |
| no_households_with_large_head_livestock | integer | HH Summary |
| no_households_with_small_head_livestock | integer | HH Summary |
| no_households_with_poultry | integer | HH Summary |
| buffalo | integer | Large Livestock |
| cattle_cow | integer | Large Livestock |
| dairy_cow | integer | Large Livestock |
| horses | integer | Large Livestock |
| goats | integer | Small Livestock |
| sheep | integer | Small Livestock |
| dairy_sheep | integer | Small Livestock |
| pigs | integer | Small Livestock |
| rabbits | integer | Small Livestock |
| chicken_local | integer | Poultry |
| chicken_broiler | integer | Poultry |
| chicken_layer | integer | Poultry |
| ducks | integer | Poultry |
regional_irrigation — Water sources, irrigation methods, and payment structures| Field | Type | Category | Description |
|---|---|---|---|
| irrigation_idPK | serial | — | Auto-increment PK |
| sm_codeFK | integer | — | Sub-municipality reference |
| households_with_irrigation | integer | Summary | Total HH using any irrigation |
| surface_water | integer | Water Source | Rivers, lakes, streams |
| underground_water | integer | Water Source | Wells, boreholes |
| mixed_water | integer | Water Source | Combination of sources |
| municipal_water_supply | integer | Water Source | Municipal piped supply |
| other_water_source | integer | Water Source | Rainwater harvest, etc. |
| natural_flow | integer | Method | Gravity-fed natural channels |
| channel_irrigation | integer | Method | Constructed channels/canals |
| pump_irrigation | integer | Method | Motorized pump systems |
| manual_irrigation | integer | Method | Hand watering, bucket |
| sprinkler_irrigation | integer | Method | Overhead sprinkler systems |
| drip_irrigation | integer | Method | Precision drip/trickle systems |
| other_irrigation_method | integer | Method | Other unspecified methods |
| payment_own_water | integer | Payment | Self-owned water source |
| payment_free_of_charge | integer | Payment | No charge for water access |
| payment_by_area | integer | Payment | Charged per hectare irrigated |
| payment_by_volume | integer | Payment | Charged per unit volume used |
| payment_other | integer | Payment | Other payment arrangement |
regional_institutions · regional_information_access · regional_aquaculture| Field | Type | Description |
|---|---|---|
| institution_idPK | serial | Auto-increment PK |
| sm_codeFK | integer | Sub-municipality reference |
| total_institutions | integer | All registered institutions in area |
| total_farm_institutions | integer | Institutions with agricultural holdings |
| total_area_institutional_agri_holdings | decimal(12,2) | Total ha of institutionally held agricultural land |
| corporation | integer | Corporate-owned farm institutions |
| cooperative | integer | Agricultural cooperatives |
| government | integer | Government-owned farm institutions |
| religious_nonprofit | integer | Religious bodies and non-profit organizations |
| Field | Type | Description |
|---|---|---|
| access_idPK | serial | — |
| sm_codeFK | integer | Sub-municipality reference |
| households_accessed_agri_info | integer | HH that accessed any agricultural information |
| source_government | integer | Government extension services |
| source_radio | integer | Agricultural radio programs |
| source_television | integer | TV broadcasts and programs |
| source_journal_newspapers | integer | Print media and journals |
| source_internet | integer | Online sources and websites |
| source_other_farmers | integer | Peer farmer knowledge sharing |
| source_ngo | integer | NGO-provided information |
| source_membership_associations | integer | Farmer associations and cooperatives |
| source_other | integer | Other unspecified sources |
| Field | Type | Category | Description |
|---|---|---|---|
| aquaculture_idPK | serial | — | — |
| sm_codeFK | integer | — | — |
| households_fishing | integer | HH Summary | HH engaged in fishing activities |
| households_aquaculture | integer | HH Summary | HH with aquaculture operations |
| vessel_motorized_owned_solely | integer | Vessels | Solely-owned motorized boats |
| vessel_motorized_jointly_owned | integer | Vessels | Jointly-owned motorized boats |
| vessel_motorized_lent | integer | Vessels | Borrowed/rented motorized boats |
| vessel_non_motorized_owned_solely | integer | Vessels | Solely-owned non-motorized boats |
| vessel_non_motorized_jointly_owned | integer | Vessels | Jointly-owned non-motorized boats |
| vessel_non_motorized_lent | integer | Vessels | Borrowed/rented non-motorized |
| vessel_none_used | integer | Vessels | Fishing without any vessel |
| purpose_home_consumption_social | integer | Purpose | Subsistence and social fishing |
| purpose_home_consumption_occasional_sale | integer | Purpose | Mostly subsistence with some sales |
| purpose_mainly_for_sale | integer | Purpose | Commercial fishing operations |