Manuj Dev Vanama Venkata Sai Krishna Deepak Kumar Manas Kumar Jha


The absence of an integrated geospatial database hinders effective decision-making among various stakeholders in national projects and programs. The study aimed to create an integrated geospatial database for the Manesar tehsil, District Gurugram, Haryana. Another objective was to create a land use map to analyze the temporal change in land use patterns and its socioeconomic impact along the surrounding areas. The first stage of the study involved creating an integrated database after interviewing different stakeholders. In the second stage, the satellite imagery was georeferenced using Ground Control Points, and the land use patterns were digitized using Landsat imagery for 1987, 2011, 2014, and 2022. The study suggested that the construction area has grown up to 6% while cultivation has dropped significantly from 76% in 1987 to 50% in 2022. Likewise, the industrial area has grown up to 2% and natural vegetation dropped in coverage from 11% to 4%. The area witnessed a population growth rate of 3.2% per year and a decadal growth rate of 39.7%. Less than 50% of the land in the tehsil is used for agricultural purposes. It estimates that 4% of the tehsil's entire surface was covered by natural vegetation in 2019, down from 11% in 1987. The study recommends the creation of an integrated geospatial database that will help reduce duplication and speed up decision-making in government. This will pave the way for improving e-governance in local bodies.  The framework created for developing the database system is universally applicable and can be used appropriately by other states, regions, and the entire country.





E-governance, Geographical information system, Geospatial database, Land use, Remote sensing, Temporal analysis, Urban planning

Aswin, K. & Thangavel, Santhosh. (2023). The predictive analysis for economic development and financial status of India in 2023. BOHR Journal of Financial market and Corporate Finance (BJFMCF). 1. 65-71, doi: 10.54646/bjfmcf.2023.12
Amini Parsa, V., Yavari, A. & Nejadi, A. (2016). Spatio-temporal analysis of land use/land cover pattern changes in Arasbaran Biosphere Reserve: Iran. Modeling Earth Systems and Environment, 2(4), 1–13. doi:10.1007/s40808-016-0227-2
Arroyo Ohori, K., Diakité, A., Krijnen, T., Ledoux, H. & Stoter, J. (2018). Processing BIM and GIS Models in Practice: Experiences and Recommendations from a GeoBIM Project in The Netherlands. ISPRS International Journal of Geo-Information., 7, 311, doi: 10.3390/ijgi7080311
Al-Saffar, A.A. & Al-Sarawi, M. (2018). Geo-visualization of the distribution and properties of landfill gases at Al-Qurain Landfill, Kuwait. Kuwait Journal of Science, 45(3), 93-104.
Amirebrahimi, S., Rajabifard, A., Mendis, P. & Ngo, T. (2016). A BIM-GIS integration method in support of the assessment and 3D visualisation of flood damage to a building. Journal of Spatial Science, 61, 317–350, doi: 10.1080/14498596.2016.1189365
Azzalini, F., Jin, S., Renzi, M. & Tanca, L (2021). Blocking techniques for entity linkage: a semantics-based approach. Data Science and Engineering, 6, (1), 20–38, doi:10.1007/s41019-020-00146-w
Borrmann, A., König, M., Koch, C. & Beetz, J. (Eds.). (2015). Building Information Modeling. Springer International Publishing: Berlin, Germany, 1-24, doi:10.1007/978-3-319-92862-3_1
Breunig, Martin & Bradley, Patrick & Jahn, Markus & Kuper, Paul & Mazroob Semnani, Nima & Rösch, Norbert & Al-Doori, Mulhim & Stefanakis, Emmanuel & Jadidi, Mojgan. (2020). Geospatial Data Management Research: Progress and Future Directions. ISPRS International Journal of Geo-Information, 9, 95, doi:10.3390/ijgi9020095
Boguslawski, P., Mahdjoubi, L., Zverovich, V., Fadli, F. & Barki, H. (2015). BIM-GIS Modelling in Support of Emergency Response Applications. Conference Building Information Modelling in design, construction and operations, Bristol, UK, 149, 381–391, doi:10.2495/BIM150321
Borrmann, A. (2010). From GIS to BIM and back again—A spatial query language for 3D building models and 3D city models. International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 38, 4/W15.
Breunig, M., Schilberg, B., Thomsen, A., Kuper, P.V., Jahn, M. & Butwilowski, E. (2010). DB4GeO, a 3D/4D Geodatabase and Its Application for the Analysis of Landslides. Geographic Information and Cartography for Risk and Crisis Management, 83–101, doi:10.1007/978-3-642-03442-8_6
Breunig, M., Kuper, P.V., Butwilowski, E., Thomsen, A., Jahn, M., Dittrich, A., Al-Doori, M., Golovko, D. & Menninghaus, M. (2016). The story of DB4GeO—A service-based geo-database architecture to support multi-dimensional data analysis and visualization. ISPRS Journal of Photogrammetry and Remote Sensing, 117, 187–205, doi:10.1016/j.isprsjprs.2015.12.006
Bradley, P.E. & Paul, N. (2010). Using the Relational Model to Capture Topological Information of Spaces. The Computer Journal, 53, 69–89, doi:10.1093/comjnl/bxn054
Carrion, Daniela & Maffeis, Andrea & Migliaccio, Federica. (2009). A database-oriented approach to GIS design. Applied Geomatics, 1, 75-84, doi:10.1007/s12518-009-0008-y
Chen P. P. (1976). The entity relationship model: toward a unified view of data. ACM Transactions on Database Systems, 1(1):1–36, doi:10.1145/320434.320440
Dalla Valle, L. & Kenett, K. (2018). Social media big data integration: a new approach based on calibration. Expert Systems with Applications, 111, 76–90.
Daraio,C., Di Leo, S. & Scannapieco, M. (2022). Accounting for quality in data integration systems: a completeness-aware integration approach. Scientometrics, 127 (3), 1465–1490, doi:10.1007/s11192-022-04266-0
Economou, F., Panagopoulos, Y. & E. Tsouma. (2018). Uncovering asymmetries in the relationship between fear and the stock market using a hidden co-integration approach. Research in International Business and Finance, 44, 459–470, doi:10.1016/j.ribaf.2017.07.116
Egenhofer. (1991). M.J. Reasoning about binary topological relations. Conference in Advances in Spatial Databases, Springer: Berlin/Heidelberg, Germany, 525, 141–160, ISBN 978-3-540-54414-2.
Fikri, N., Rida, M. Abghour, N. & Moussaid, K.A. (2019). An adaptive and real-time based architecture for financial data integration. Journal of Big Data, 6(1) 97, doi:10.1186/s40537-019-0260-x
Fosu, R., Suprabhas, K., Rathore, Z. & Cory, C. (2015). Integration of Building Information Modeling (BIM) and Geographic Information Systems (GIS)—A Literature Review and Future Needs. 32nd CIB W78 Conference, Eindhoven, The Netherlands, 9.
Gabriel, P., Gietzel, J., Le, H.H., Schaeben, H. GST, (2015). A Network Based Datastore for Geoscience Data and Geomodels and its Implementation—ProMine’s Contribution Towards Interoperability. 3D, 4D and Predictive Modelling of Major Mineral Belts in Europe, 59-71, doi:10.1007/978-3-319-17428-0_3
Goyal, H., Sharma, C. & Joshi, N. (2017). An integrated approach of GIS and spatial data mining in big data. International journal of computer application, 169(11), 8887–8975, doi:10.5120/ijca2017914012
Hazra, Sukla & Khan, Atanu & Saradar Jhantu. (2013). Asset Mapping of Gram Panchayat and Web based Interface for Development. Indian Cartographer, 23, 123-127
Hor, A.-H., Jadidi, A. & Sohn, G. Bim(2016). GIS Integrated Geospatial Information Model Using Semantic Web and RDF Graphs. ISPRS Annual Photogrammetry Remote Sensing Spatial Information Science, 3, 73–79, doi:10.5194/isprs-annals-III-4-73-2016
Hor, A.-H., Sohn, G., Claudio, P., Jadidi, M. & Afnan, A. (2018). A Semantic Graph Database for Bim-Gis Integrated Information Model for an Intelligent Urban Mobility Web Application. ISPRS Annual Photogrammetry Remote Sensing Spatial Information Science, 4, 89–96, doi:10.5194/isprs-annals-IV-4-89-2018
Hu, F., Xu, M.; Yang, J., Liang, Y., Cui, K., Little, M.M., Lynnes, C.S., Duffy, D.Q. & Yang, C. (2018). Evaluating the Open-Source Data Containers for Handling Big Geospatial Raster Data. ISPRS International Journal Geo Information, 7, 144, doi:10.3390/ijgi7040144.
Irizarry, J., Karan, E.P. & Jalaei, F. (2013). Integrating BIM and GIS to improve the visual monitoring of construction. Supply chain management, Automation, Construction, 31, 241–254, doi:10.1016/j.autcon.2012.12.005
Jain, M., Dawa, D., Mehta, R., Dimri, A. P. & Pandit, M. K. (2016). Monitoring land use change and its drivers in Delhi, India using multi-temporal satellite data. Modeling Earth Systems and Environment, 2(1). doi:10.1007/s40808-016-0075-0
Jain, R.K., Kamal Jain & Rehan Ali, S. (2017). Remote Sensing Enabled Urban Growth Analysis for Gurgaon from 1995 To 2015. Advances in Computational Sciences and Technology, ISSN 0973-6107, 10(6), 1745-1757.
Jyothi. S, Saritha, K. & Manjula. K. R. (2013). Classification of Deforestation Factors using Data Mining Techniques. International Journal of Computer Science Engineering and Information Technology Research (IJCSEITR), 3 (4), 159-172.
Kaushik, Saurabh & Kandpal, Kishor & Pandey, Arvind. (2017). Application of GIS in Panchayati raj System in India: A Case Study of Naugaon Village, Uttarakhand, India (An Initiative of G- governance). International Journal of Advanced Remote Sensing and GIS, 6. 2367-2376. doi:10.23953/cloud.ijarsg.301
Khovrichev, M., Elkhovskaya, L. Fonin, V. & Balakhontceva, M. (2019). Intelligent approach for heterogeneous data integration: information processes analysis engine in clinical remote monitoring systems. Procedia Computer Science, 156, 134–141, doi:10.1016/j.procs.2019.08.188
Kumar M. & Duffy C. (2010). An Object-Oriented Shared Data Model for GIS and Distributed Hydrologic Models. International Journal of Geographical Information Science, 24 (7), 1061-79, 2010. doi:10.1080/ 13658810903289460
Li, Daqian. (2022). Data Integration Method Design of Decision Spatial Information System. Security and Communication Networks, 1-12. Doi:10.1155/2022/8114454
Lienhardt, P. (1994). N-Dimensional Generalized Combinatorial Maps and Cellular Quasi-Manifolds. International Journal of Computational Geometry and Applications, 4, 275–324, doi:10.1142/S0218195994000173
Le, H.H., Gabriel, P., Gietzel, J. & Schaeben, H. (2013). An object-relational spatio-temporal geoscience data model. Computer Geoscience, 57, 104–115.
Manjula K. R. & Jyothi, S. (2012). Mining Multilevel Spatiotemporal Association Rules for Analyzing the Factors of Deforestation. First International Conference on Intelligent Infrastructure and 47th Annual National Convention, CSI, 256 – 260.
Manoj Panwar, Ar. & Er. Pardeep Sindhu. (2016). Critical Analysis of Land Use Planning along Kundli Manesar Palwal Expressway. International Journal of Latest Trends in Engineering and Technology (IJLTET), 6(3), ISSN:2278-621X
Mekala, A. (2020). An ontology approach to data integration using mapping method. International Journal for Modern Trends in Science and Technology, 6(12), 28–32, doi: 10.46501/IJMTST061206
M. Masmoudi, S. B. A. B. Lamine, H. B. Zghal, B. Archimede & M. H. Karray. (2021). Knowledge hypergraph-based approach for data integration and querying: application to Earth Observation. Future Generation Computer Systems, 115(1),720–740, doi:10.1016/j.future.2020.09.029
M. Wiedau, L. Von Wedel, H. Temmen * R. N. Welke. (2019). ENPRO data integration: extending DEXPI towards the asset lifecycle. Chemie Ingenieur Technik, 91(3), 240–255, doi:10.1002/cite.201800112
M. Lenzerini. (2002). Data integration: A theoretical perspective. 21st ACM SIGMOD-SIGACT-SIGART. Symposium on Principles of Database Systems (PODS), 233–246, doi:10.1145/543613.543644
Michael, F. Worboys, Hilary M. Hearnshaw, and David J. Maguire. (1990). Object-Oriented Data modeling for Spatial databases. International Journal of Geographical Information Systems, 4, 369–383, doi:10.1080/0269 3799008941553
Mohan, Manju & Kandya, Anurag & Battiprolu, Arunachalam. (2011). Urban Heat Island Effect over National Capital Region of India: A Study using the Temperature Trends. Journal of Environmental Protection, 2, 465-472, doi:10.4236/jep.2011.24054
Nyoni Thabani, Keen Marozva, Tafadzwa Manddizvidza & Chipo Mutongi (2020). Geodatabase design and webgis for land information management: a case study of the ministry of lands and rural resettlement, Zimbabwe. International Journal of Advance Research and Innovative Ideas in Education, 6 (6), 1279-1289.
Ozel, F. (2000). Spatial databases, and the analysis of dynamic processes in buildings. Fifth Conference on Computer Aided Architectural Design Research in Asia, Singapore, 2, 97–106.
Park, S., Kim, J.K. & Stukel, D (2017). A measurement error model approach to survey data integration: combining information from two surveys, Metron, 75 (3), 345–357, doi:10.1007/s40300-017-0124-0
Pranav, N. Desai (2018). Gurgaon-Manesar Urban Complex Challenges of Water Governance, Policy Brief No. 1/2018. Transdisciplinary Research Cluster on Sustainability Studies Jawaharlal Nehru University, New Delhi
Rupali, P. Zope (2013). The planning strategies for urban land use pattern: a case study of Pune city, India. International Journal of Innovative Research in Science, Engineering and Technology, 2(7).
Zadeh, P. A., Wei, L. & Dee, A (2019). BIM-CITYGML data integration for modern urban challenges. Electronic Journal of Information Technology in Construction, 24 (17), 318–340.
Suzanchi, K. & Kaur, R. (2011). Land use land cover change in National Capital Region of India: A remote sensing & GIS based two decadal spatial-temporal analyses. Procedia - Social and Behavioral Sciences, 21, 212–221. doi:10.1016/j.sbspro.2011.07.044
Strauch, Julia & Strauch, Mercedes & Souza, Jano & Mattoso, Marta (2000). A Methodology for GIS Databases Integration. https://www.researchgate.net/publication/26 27102
Singh, Balwan (2018). Role of Smart Cities in Urbanization of Haryana: A Case Study, IJSRSET, 4(1), Print ISSN: 2395-1990, Online ISSN: 2394-4099
Shakeel Ahmad Mir. (2019). Rapid Population Growth and Its Effect on Economic Development of India. International Journal of Research in Engineering, IT and Social Sciences, ISSN 2250-0588, 09 (01), 182-188
Shruti Rajagopalan and Alexander Tabarrok. (2014). Lessons from Gurgaon, India’s Private City. George Mason University, Department of Economics, Working Paper No. 14-32, doi:10.2139/ssrn.2514652
Tiwari, A., Merugu Suresh & Arun Kumar Rai (2014). Ecological Planning for Sustainable Development with a Green Technology: GIS. International Journal of Advanced Research in Computer Engineering & Technology (IJARCET), 3(3).
Tan, Z., Yue, P. & Gong, J. (2017). An Array Database Approach for Earth Observation Data Management and Processing. ISPRS International Journal of Geo-Information, 6, 220, doi:10.3390/ijgi6070220
Vathy-Fogarassy, Á. & Hugyák, T. (2017). Uniform data access platform for SQL and NoSQL database systems. Information Systems, 69, 93–105, doi:10.1016/j.is.2017.04.002
Wu, C., Zhu, Q., Zhang, Y., Du, Z., Ye, X., Qin, H., Zhou, Y. (2017). A NoSQL–SQL Hybrid Organization and Management Approach for Real-Time Geospatial Data: A Case Study of Public Security Video Surveillance. International Journal of Geo-Information, 6(1), 21, https://doi.org/10.3390/ijgi6010021
Winter, S. & Frank, A.U. (2000). Topology in Raster and Vector Representation. GeoInformatica, 4, 35–65, doi:10.1023/A:1009828425380
Zhang, X., Song, W. & Liu, U. (2014). An implementation approach to store GIS spatial data on NoSQL database. 22nd International Conference on Geoinformatics, 4–8, doi:10.1109/GEOINFORMATICS.2014.6950846
Zhu, J., Wright, G., Wang, J. &Wang, X. (2018). A Critical Review of the Integration of Geographic Information System and Building Information Modelling at the Data Level. International journal of Geo-Information, 7, 66, doi:10.3390/ijgi7020066
Research Articles

How to Cite

Integrated geospatial database design for land use pattern analysis and its impact on local governance: A case study of Manesar Urban Complex, Gurugram, India. (2023). Journal of Applied and Natural Science, 15(4), 1541-1556. https://doi.org/10.31018/jans.v15i4.5084