Centre de documentation
scientifique

Dépouillements

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]

A high-efficiency global model of optimization design of impervious surfaces for alleviating urban waterlogging in urban renewal / Huafei Yu in Transactions in GIS, Vol 25 n° 4 (August 2021)  

Public [article]  inTransactions in GIS > Vol 25 n° 4 (August 2021) . - pp 1716 - 1740 Titre : A high-efficiency global model of optimization design of impervious surfaces for alleviating urban waterlogging in urban renewal Type de document : Article/Communication Auteurs : Huafei Yu, Auteur ; Yaolong Zhao, Auteur ; Tao Xu, Auteur ; et al., Auteur Année de publication : 2021 Article en page(s) : pp 1716 - 1740 Note générale : bibliographie Langues : Anglais (eng) Descripteur : [Vedettes matières IGN] Analyse spatiale [Termes IGN] Canton (Kouangtoung) [Termes IGN] eau pluviale [Termes IGN] écoulement des eaux [Termes IGN] optimisation par colonie de fourmis [Termes IGN] programmation linéaire [Termes IGN] sol hydromorphe [Termes IGN] surface imperméable [Termes IGN] urbanisation [Termes IGN] utilisation du sol Résumé : (auteur) The rapid expansion and unreasonable design of impervious surfaces caused by urbanization have seriously aggravated urban waterlogging. Determining how to optimize the spatial layout of impervious surfaces is the focus of urban waterlogging prevention in urban renewal. The existing urban-renewal methods include constructing low-impact development measures by reducing the area of impervious surfaces or implementing a local high-strength design based on the ant colony algorithm (ACA) from the viewpoint of optimization design. However, these methods have obvious shortcomings in terms of time efficiency, and their optimized design schemes are insufficient at considering the global impervious surface design. Therefore, to address these problems, the study proposes a coupled model of multivariate linear programming and Soil Conservation Service curve number. The model is employed in the central city of Guangzhou, China. The results show, first, that the optimal design of impervious surfaces in urban renewal is to construct a discontinuous connection of high-low-high-density impervious surfaces; second, that, compared with ACA, our method has higher robustness, increases the average optimization rate by 4.48 to 14.00%, and reduces the optimization time over 30 days to 20.8 s; and third, that the optimal results realize the global low-strength transformation as complements of the existing design scheme of local high-strength transformation. This study optimizes methods for alleviating urban waterlogging urban renewal at different scales or intensities. Numéro de notice : A2021-701 Affiliation des auteurs : non IGN Thématique : GEOMATIQUE/URBANISME Nature : Article DOI : 10.1111/tgis.12757 Date de publication en ligne : 05/05/2021 En ligne : https://doi.org/10.1111/tgis.12757 Format de la ressource électronique : URL article Permalink : https://documentation.ensg.eu/index.php?lvl=notice_display&id=98576 [article]