Centre de documentation
scientifique

Integrating GIS and location modeling: A relational approach / Ting L. Lei in Transactions in GIS, Vol 25 n° 4 (August 2021)  

Public [article]  inTransactions in GIS > Vol 25 n° 4 (August 2021) . - pp 1693 - 1715 Titre : Integrating GIS and location modeling: A relational approach Type de document : Article/Communication Auteurs : Ting L. Lei, Auteur Année de publication : 2021 Article en page(s) : pp 1693 - 1715 Note générale : bibliographie Langues : Anglais (eng) Descripteur : [Vedettes matières IGN] Systèmes d'information géographique [Termes IGN] allocation [Termes IGN] base de données localisées [Termes IGN] base de données relationnelles [Termes IGN] langage de programmation [Termes IGN] programmation linéaire [Termes IGN] SQL [Termes IGN] système de gestion de bases de données relationnelles Résumé : (auteur) Planners and geospatial analysts have long been using GIS and optimization methods to solve a wide range of spatial decision problems from routing and facility location to political redistricting. However, there has been a notable disconnection between the tools of GIS and optimization, constraining the capability of spatial decision-making in GIS. This article presents relational linear programming (RELP), a new framework and tool for bridging the gap between the two fields by integrating a generic optimization solver into GIS: a solver for integer linear programming (ILP). In particular, we choose relational/spatial databases as the GIS platform. We demonstrate that not only data, but also programs for spatial problems (in the form of ILP) can be managed and executed in SQL inside spatial databases. The main focus of this article is on location modeling, and we show how classic models can be formulated succinctly in a declarative way using SQL. The declarative approach of RELP allows researchers to focus on formulating new spatial decision problems without being bogged down in sophisticated programming. The integrated approach allows data processing and decision-making in one language. Therefore, it brings the power of location modeling to non-specialist GIS practitioners. Numéro de notice : A2021-700 Affiliation des auteurs : non IGN Thématique : GEOMATIQUE Nature : Article DOI : 10.1111/tgis.12804 Date de publication en ligne : 29/07/2021 En ligne : https://doi.org/10.1111/tgis.12804 Format de la ressource électronique : URL article Permalink : https://documentation.ensg.eu/index.php?lvl=notice_display&id=98575 [article]