Skip to main content

Appendix A. DATA DICTIONARY FOR GIS-DATABASE

 



s

      2.

    3.
  • Tax
    • number     4.
    SN Feature
    Descriptiondescription    		 Features Featuregeometry
    Geometry    		Attributes Priority AttributesRemark
    		PriorityRemarks

      1.

    1.  

    		 City Boundary Polygon Polygon 
    • Total Areaarea in Sq. Km sq.km
    • Citycity Name name
    		 High


     
    2. Ward Boundary Polygon
    • Ward Numbernumber
    • Ward area in Sq.Km
    		 High
    3. Tax Zone Polygon
    		zone High
    4. Building Footprint Polygon
    • 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 
    		 High 
    		 
    5.5 Containment PolygonPoint
    • Containment 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)
    		   
           6. Public /Community toilet
     
    • 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
    		    
    Back to top