Appendix A. DATA DICTIONARY FOR GIS-DATABASE

SN

Feature Description

Feature Geometry

Attributes

Priority

Remarks

1

City Boundary

Polygon

·       Total Area in Sq. Km

·       City Name

High

2

Ward Boundary

Polygon

·       Ward number

·       Ward area in Sq. Km

High

3

Tax Zone

Polygon

·       Tax zone number

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 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

High

·       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

5

Containment

Point

·       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

6

Public/Community toilet

Point

·       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

7

Emptying Service providers

Point

·       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

8

Emptying service providers

employees’ inventory

Non- spatial

·       Service provider Code

·       Employee Name

·       Employee gender (Male, Female, Other)

·       Employee contact number

·       Employee      type      (Driver,           helper,  supervisor, management, others)

·       Year of experience in years

·       Monthly wage

·       Employment start date

·       Training obtained (Yes, No)

High

9

Emptying service providers vehicles inventory

Non- spatial

·       Service provider Code

·       Vehicle plate number

·       Size of desludging vehicle in liters

·       Width of desludging vehicle in meter

High

10

Treatment plants

Point

·       Treatment Plant Code (Unique)

·       Treatment plant location

High

·       Ward number

·       Treatment capacity/day in m3

·       Caretaker name

·       Caretaker gender (Male, female, others)

·       Caretaker number

11

Road Network

Line

·       Road Code (Unique code)

·       Road Name

·       Road Hierarchy (Highway, district road, Feeder Road, urban roads, trial)

·       Road             Surface         Type             (Metaled,             Earthen,             gravel, stone/brick)

·       Road length in Meter

·       Road carriage width in Meter

·       Right of Way

High

12

Water                    supply Network

Line

·       Water supply Code (Unique)

·       Water supply pipe diameter in mm

·       Water supply pipe length in Meter

·       Corresponding Road Code

Medium

Through                    secondary sources only

13

Sewer network

Line

·       Sewer Code (Unique)

·       Sewer pipe diameter in mm

·       Sewer length in Meter

·       Corresponding Road Code

Medium

Through                    secondary sources only

14

Drain network

Line

·       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

Medium

Through                    secondary sources only

15

Water body

Polygon

·       Water body Code (Unique)

·       Water body Type (River, Pond, canal, lake)

·       Area in sq. m

High

16

Environmental sensitive                      areas

(ESAs)

Polygon

·       ESA Code (Unique)

·       ESA type (Landslide/Erosion, flooding, agriculture etc.)

Low

Through                    secondary sources only

17

Contour

Line

·       Elevation in Meter

High

18

Land            cover/Land use map

Polygon

·       Land use class (Built up, commercial, open space, forest, water body,)

Medium

19

Low Income Areas

Polygon

·       LIC Code (Unique)

·       Economic                    situation (Extremely, poor, very poor, moderately poor, poor)

High

20

Water table

Polygon

Low

Through                    secondary sources only

21

Soil

Polygon

Low

Through                    secondary sources only

22

Point   of Interest (POIs)

Point

·       POIs Code (Unique)

·       POIs Type (Educational, health, business, place, ward offices, post offices, petrol stations)

High

23

Water                      borne diseases hotspot

Polygon

Medium

Through                    secondary sources only

24

Water                  logging areas

Polygon

Medium

Through                    secondary sources only

25

Landfill site

Point

·       Coverage area in Sq. Meter