Appendix A. DATA DICTIONARY FOR GIS-DATABASE

SN	Feature description	Features geometry	Attributes	Priority
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 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
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, management, others) Year of experience in years Monthly wage Employment start date Training obtained (Yes, No)	supervisor,	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 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
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