Skip to main content

Appendix A. DATA DICTIONARY FOR GIS-DATABASE

     

 

SNFeature descriptionFeatures geometryAttributesPriorityRemark s

1.

 

City BoundaryPolygon
  • Total area in sq.km
  • city name
High


 

2.Ward BoundaryPolygon
  • Ward number
  • Ward area in Sq.Km
High
3.Tax ZonePolygon
  • Tax zone number
High
4.Building FootprintPolygon
  • BIN (Unique Building Identification Number) 
  • House Address
  • Holding ID/Tax Code
  • Ward number
  • Owner name
  • Owner gender (Male. Female, Others)
  • Owner contact number
  • Structural type (RCC, Load Bearing with cement mortar, load bearing High with mud/lime mortar, wooden/mud/CGI/Temporary, steel structures)
  • Floor counts 
  • Building plan area in Sq.m
  • Building Construction year in A.D
  • Use purpose (Residential,commercial, mixed,offices, educational, hospital/clinic, industrial, Assembly)
  • Number of households
  • Male Population
  • Female population 


   
  • Others population
  • Differently abled Male population
  • Differently abled Female population
  • Differently abled others population
  • Offices/business names
  • Low Income Household Status
  • Low Income Community Name if Low Income Household
  • Toilet use information (Private, shared, public toilet, community toilet, Open defecation)
  • Toilet counts in the building
  • Toilet connection (Sewer Network, Drain Network, Septic Tank, Pit/ Holding Tank, Onsite Treatment (e.g., Anaerobic Digestor/ Biogas, DEWATS), Composting Toilet (e.g., ecosan, UDDT, etc.), Water Body, Open Ground, Shared Septic Tank)
  • Well presence (Yes, No)
  • Distance from the nearest well in meter
  • Road Code
  • Drain code if connected to drain
  • Water supply pipe code if connected to water supply
  • Water supply customer code if connected to water supply
  • Sewer code if connected to sewer
  • Sewerage customer code if connected to sewer
  • Solid waste customer code if availing solid waste collection service
  
5ContainmentPointContainment Code (Unique Containment Identification Number)High 
   
  • Associated House Number/Holding ID/Tax Code
  
   
  • Containment type (Septic Tank connected to Sewer Network, Septic Tank connected to Drain Network, Septic Tank connected to Soak Pit, Septic Tank connected to Water body, Septic Tank connected to Open Ground, Septic Tank without Outlet Connection, Septic Tank with Unknown Outlet Connection, Double Pit, Permeable/ Unlined Pit/Holding Tank, Lined Pit connected to a Soak Pit, Lined Pit connected to Water Body, Lined Pit connected to Open Ground, Lined Pit connected to Sewer Network, Lined Pit connected to Drain Network, Lined Pit without Outlet, Lined Pit with Unknown Outlet Connection,)
  
   
  • Containment location (Outside/inside the building footprint)
  
   
  • Septic tank standard compliance (Yes, No)
  
   
  • Containment construction year in A.D
  
   
  • Containment emptying status (Yes, No)
  
   
  • Containment last emptying year in A.D
  
6Public/Community toiletPoint
  • Unique Code
  • Associated BIN
  • Ward Number
  • Category (Public/Community)
  • Nearest road distance in meter
  • Separate facility for male and female (Yes, No)
  • No. of male seats
  • No. of female seats
  • Facility for handicapped people (Yes, No)
  • Facility for children (Yes, No)
  • Facility of sanitary supplies and disposal (Yes, No)
High 
   
  • Presence of proper sign (Yes, No)
   
   
  • Owner (Municipality, Private)
   
   
  • Operator entity name
   
   
  • Caretaker name
   
   
  • Caretake contact number
   
7Emptying Service providersPoint
  • Service provider Code (Unique Code)
  • Company name of the service provider
  • Ward number
  • Place
  • Email of the service provider
  • Contact person name
  • Contact person gender (Male, female, others)
  • Contact person contact number
High  
8Emptying service providers employees’ inventoryNon- spatial
  • Service provider Code
  • Employee Name
  • Employee gender (Male, Female, Other)
  • Employee contact number
  • Employee type (Driver, helper, management, others)
  • Year of experience in years
  • Monthly wage
  • Employment start date
  • Training obtained (Yes, No)
supervisor,High 
9Emptying service providers vehicles inventoryNon- spatial
  • Service provider Code
  •  Vehicle plate number
  • Size of desludging vehicle in liters
  • Width of desludging vehicle in meter
 High 
10Treatment plantsPoint
  • Treatment Plant Code (Unique)
  •  Treatment plant location
 High 
   
  • Ward number
    
   
  • Treatment capacity/day in m3
    
   
  • Caretaker name
    
   
  • Caretaker gender (Male, female, others)
    
   
  • Caretaker number
    
11Road NetworkLine
  • Road Code (Unique code)
  • Road Name
  • Road Hierarchy (Highway, district road, Feeder urban roads, trial)
  • Road Surface Type (Metaled, stone/brick)
  • Road length in Meter
  • Road carriage width in Meter
  • Right of Way
Earthen,Road, gravel,High 
12Water supply NetworkLine
  • Water supply Code (Unique)
  • Water supply pipe diameter in mm
  • Water supply pipe length in Meter
  •  Corresponding Road Code
  MediumThrough secondary sources only
13Sewer networkLine
  • Sewer Code (Unique)
  • Sewer pipe diameter in mm
  • Sewer length in Meter
  • Corresponding Road Code
  MediumThrough secondary sources only
14Drain networkLine
  • Drain Code (Unique)
  • Drain diameter in mm
  • Drain Cover Type (Open, closed)
  • Drain Surface Type (Lined, Unlined, Unknown)
  • Drain length in Meter
  • Corresponding Road Code
MediumThrough secondary sources only  
15Water bodyPolygon
  • Water body Code (Unique)
  • Water body Type (River, Pond, canal, lake)
  • Area in sq. m
High   
16Environmental sensitive areas (ESAs)Polygon
  • ESA Code (Unique)
  • ESA type (Landslide/Erosion, flooding, agriculture etc.)
LowThrough secondary sources only  
17ContourLine
  • Elevation in Meter
High   
18Land cover/Land use mapPolygon
  • Land use class (Built up, commercial, open space, forest, water body,)
Medium   
19Low Income AreasPolygon
  • LIC Code (Unique)
  • Economic situation (Extremely, poor, very poor, moderately poor, poor)
High   
20Water tablePolygon LowThrough secondary sources only  
21SoilPolygon LowThrough secondary sources only  
22Point of Interest (POIs)Point
  • POIs Code (Unique)
  • POIs Type (Educational, health, business, place, ward offices, post offices, petrol stations)
High   
23Water borne diseases hotspotPolygon MediumThrough secondary sources only  
24Water logging areasPolygon MediumThrough secondary sources only  
25Landfill sitePoint
  • Coverage area in Sq. Meter