Geospatial Database Design for implementing enhanced Local Governance with spatial analysis: A Case study of Manesar area – India

Abstract Multi-agency investments require local coordination, planning, and implementation. GIS allows us to analyze and comprehend real-world processes by constructing and applying manipulation, analytical criteria, and models for daily decision making. This requires a geospatial database with surveyed land, assets, hydro, etc. Survey of India (SOI) is publishing a topographical map of India with significant cities, areas of interest, and a geodetic benchmark. Different states in India have set up a complete geographic database with land parcels, asset mapping, and administrative borders usually based on the national land record modernization program survey. Many state and local governments also have geospatial databases. Existing geospatial database designs are based on individual requirements that have generated a large volume of duplicate, unformatted, unstructured data. These datasets lacked coordination or logical intercorrelation with other departments' datasets. It served a single department's needs. This causes redundant data, low quality, and a lack of data understanding. The problem's appropriate representation is key to solving it. The Study creates a Common Geo Database for the region to improve collaboration and working. After consulting civil, electrical, and planning engineers, a common database is created. GIS adoption has improved day-to-day decision-making.