Relevant bibliographies by topics / PostGis/PostgreSQL

Academic literature on the topic 'PostGis/PostgreSQL'

Author: Grafiati
Published: 30 May 2022
Last updated: 31 May 2022

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Contents

Consult the lists of relevant articles, books, theses, conference reports, and other scholarly sources on the topic 'PostGis/PostgreSQL.'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Journal articles on the topic "PostGis/PostgreSQL"

1

Růžička, Jan. "Comparing speed of Web Map Service with GeoServer on ESRI Shapefile and PostGIS." Geoinformatics FCE CTU 15, no. 1 (July 22, 2016): 3–9. http://dx.doi.org/10.14311/gi.15.1.1.

Full text
Abstract:
There are several options how to configure Web Map Service using several map servers. GeoServer is one of most popular map servers nowadays. GeoServer is able to read data from several sources. Very popular data source is ESRI Shapefile. It is well documented and most of software for geodata processing is able to read and write data in this format. Another very popular data store is PostgreSQL/PostGIS object-relational database. Both data sources has advantages and disadvantages and user of GeoServer has to decide which one to use. The paper describes comparison of performance of GeoServer Web Map Service when reading data from ESRI Shapefile or from PostgreSQL/PostGIS database.
APA, Harvard, Vancouver, ISO, and other styles
2

Liashenko, O., S. Lytvynov, and N. Solodka. "PERFORMANCE ANALYSIS FOR GEOSPATIAL QUERIES POSTGRESQL/POSTGIS DATABASE VS. MONGODB." Transactions of Kremenchuk Mykhailo Ostrohradskyi National University 6 (December 27, 2019): 60–67. http://dx.doi.org/10.30929/1995-0519.2019.6.60-67.

Full text
APA, Harvard, Vancouver, ISO, and other styles
3

Kepka, Michal, and Jan Ježek. "Web client for PostGIS—the concept and implementation." Geoinformatics FCE CTU 11 (December 28, 2013): 63–76. http://dx.doi.org/10.14311/gi.11.5.

Full text
Abstract:
PostgreSQL with PostGIS extension plays one of the major roles in many complex GIS frameworks. There exist many possibilities how to access such data storage, but most of them might be seen as not simple for new users. In this paper we would like to introduce the concept of the implementation of a web based PostGIS client application. The main emphasis of described solution is placed on simplicity and straightforward approach for visualisation of general SQL queries.
APA, Harvard, Vancouver, ISO, and other styles
4

Li, W., S. Zlatanova, and B. Gorte. "VOXEL DATA MANAGEMENT AND ANALYSIS IN POSTGRESQL/POSTGIS UNDER DIFFERENT DATA LAYOUTS." ISPRS Annals of Photogrammetry, Remote Sensing and Spatial Information Sciences VI-3/W1-2020 (November 17, 2020): 35–42. http://dx.doi.org/10.5194/isprs-annals-vi-3-w1-2020-35-2020.

Full text
Abstract:
Abstract. Three-dimensional (3D) raster data (also named voxel) is important sources for 3D geo-information applications, which have long been used for modelling continuous phenomena such as geological and medical objects. Our world can be represented in voxels by gridding the 3D space and specifying what each grid represents by attaching every voxel to a real-world object. Nature-triggered disasters can also be modelled in volumetric representation. Unlike point cloud, it is still a lack of wide research on how to efficiently store and manage such semantic 3D raster data. In this work, we would like to investigate four different data layouts for voxel management in open-source (spatial) DBMS - PostgreSQL/PostGIS, which is suitable for efficiently retrieving and quick querying. Besides, a benchmark has been developed to compare various voxel data management solutions concerning functionality and performance. The main test dataset is the groups of buildings of UNSW Kensington Campus, with 10cm resolution. The obtained storage and query results suggest that the presented approach can be successfully used to handle voxel management, semantic and range queries on large voxel dataset.
APA, Harvard, Vancouver, ISO, and other styles
5

Nguyen, Quoc Khac, and Sang Van Nguyen. "DATA VISUALIZATION FOR PIG HERDS IN TRA VINH PROVINCE BASED ON GEOGRAPHIC INFORMATION SYSTEM (GIS)." Scientific Journal of Tra Vinh University 1, no. 1 (June 13, 2019): 37–41. http://dx.doi.org/10.35382/18594816.1.1.2019.85.

Full text
Abstract:
Building a system of data visualization of pig herds in Tra Vinh province based on GIS (Geographic Information System) will help management agencies update, do statistical analysis of and forecast the fluctuation in pig herds within the provincial area. Since then, pig farmers will have reliable information, which canmake their investment more efficient. The system is built on the WebGIS platform combining solutions for processing map data with PostGIS - an extension of PostgreSQL database management system to manage GIS objects. Additionally, the system will also provide solutions to handle and share pig herd data on the map with Geoserver - an open source server with the aim of connecting geographic information from PostGIS to Geoweb.
APA, Harvard, Vancouver, ISO, and other styles
6

Коваценко, И. О., and Сергеев А.И. "Зоны спортивного досуга относительно спроса жителей г. Кемерово и расположения спортивных объектов." ТЕНДЕНЦИИ РАЗВИТИЯ НАУКИ И ОБРАЗОВАНИЯ 70, no. 1 (2021): 19–22. http://dx.doi.org/10.18411/lj-02-2021-05.

Full text
Abstract:
В данной статье изучается показатель потенциального спроса к спортивному досугу в зависимости от географической удаленности спортивных объектов и общих предпочтений граждан в выборе спорта с использованием инструментария QGIS, PostgreSQL и PostGIS. Это позволит более разумно подходить к открытию новых точек или к перепрофилированию имеющихся. Исследовательская работа должна показать пиковые точки потенциального спроса жителей города и обозначить проблемные зоны с минимальным развитием объектов спортивной направленности.
APA, Harvard, Vancouver, ISO, and other styles
7

Martinho, Nuno, José-Paulo de Almeida, Nuno E. Simões, and Alfeu Sá-Marques. "UrbanWater: Integrating EPANET 2 in a PostgreSQL/PostGIS-Based Geospatial Database Management System." ISPRS International Journal of Geo-Information 9, no. 11 (October 22, 2020): 613. http://dx.doi.org/10.3390/ijgi9110613.

Full text
Abstract:
Incorporating data stored in a geographical information system (GIS) within the development of hydraulic simulation models is crucial for operating, updating, and hence redesigning water supply systems (WSS). Building and updating hydraulic models can be both time and resource consuming; moreover, the need to update infrastructure cadastral information makes the model itself outdated. In addition, typical dispersion of data across several databases requires extra effort to maintain the whole system and ensure it is properly assembled. Albeit there are some GIS-based hydraulic modelling solutions available, they typically use external connections to assemble all components resulting in additional costs and less flexibility. In order to be able to establish a single fully integrated data model towards global characterization of a WSS and associate hydraulic simulation, this paper proposes the specific implementation of an EPANET 2 model in PostgreSQL along with PostGIS extension. The system developed enables the construction of the model, hydraulic simulation, and storage of results within a single database. Required procedures and functions were coded either in pgSQL or Python and their execution were carried out using SQL statements. Finally, a case study was selected in order to test the system proposed. Results show that an integrated approach indeed allows the expedited creation of more realistic hydraulic models based on the stored cadastral information.
APA, Harvard, Vancouver, ISO, and other styles
8

Yadav, Monika. "A Comparative Analysis of Spatial Indexing Schemes in PostGreSQL/PostGIS Using Java-API." International Journal of Emerging Research in Management and Technology 6, no. 6 (June 29, 2018): 350. http://dx.doi.org/10.23956/ijermt.v6i6.291.

Full text
Abstract:
There are several indexing techniques used in retrieval of spatial data. In this paper a comparative analysis is performed on three spatial indexing techniques- GiST (Generalized Search Tree), SP_GiST (Space partition Generalized Search Tree) and R-tree (Rectangle tree) in spatial database PostgreSQL/Postgre using Java API. The comparison is performed on five categories of spatial and non spatial queries ,namely Simple SQL, Geometry, Spatial Relational ship, Spatial Join and Nearest Neighborhood based on benchmark dataset of New York city. This paper performs experiment in all five categories and compares performance for each category on index structure.
APA, Harvard, Vancouver, ISO, and other styles
9

Li, Yuzhen, Jianming Lu, Jihong Guan, Mingying Fan, Ayman Haggag, and Takashi Yahagi. "GML Topology Data Storage Schema Design." Journal of Advanced Computational Intelligence and Intelligent Informatics 11, no. 6 (July 20, 2007): 701–8. http://dx.doi.org/10.20965/jaciii.2007.p0701.

Full text
Abstract:
Geography Markup Language (GML) was developed to standardize the representation of geographical data in extensible markup language (XML), which facilitates geographical information exchange and sharing. Increasing amounts of geographical data are being presented in GML as its use widens, raising the question of how to store GML data efficiently to facilitate its management and retrieval. We analyze topology data in GML and propose storing nonspatial and spatial data from GML documents in spatial databases (e.g, Oracle Spatial, DB2 Spatial, and PostGIS/PostgreSQL.). We then use an example to analyze the topology relation.
APA, Harvard, Vancouver, ISO, and other styles
10

Alvarez, Miguel, Michael Curran, and Itambo Malombe. "SWEA-Dataveg: A vegetation database for sub-Saharan Africa." Vegetation Classification and Survey 2 (May 5, 2021): 59–63. http://dx.doi.org/10.3897/vcs/2021/64911.

Full text
Abstract:
SWEA-Dataveg is a vegetation-plot database collecting observations mainly in sub-Saharan Africa but also open to the rest of the African continent. To date this database contains more than 5,500 plot observations provided by 47 sources (projects, monographs, and articles). While the database is stored in PostgreSQL (including the PostGIS extension), the R-package “vegtable” implements a suitable exchange format. In this article we assess the current content of SWEA-Database and introduce its history and future as a repository of data for syntaxonomic assessments and macroecological research.
APA, Harvard, Vancouver, ISO, and other styles
More sources

Dissertations / Theses on the topic "PostGis/PostgreSQL"

1

Bartolucci, Davide. "Estrazione classi spettrali su immagini satellitari preclassificate tramite postgis/postgresql." Bachelor's thesis, Alma Mater Studiorum - Università di Bologna, 2014. http://amslaurea.unibo.it/7160/.

Full text
Abstract:
Obiettivo di questa tesi è quello di sviluppare, coordinato da Gaiag, un sistema per identificare una o più classi semantiche da associare ai pixel di un'immagine satellitare preclassificata. Più precisamente, il mio scopo è stato quello di selezionare e analizzare solo quei pixel caratterizzati da specifici attributi semantici come la vegetazione, il suolo urbano o l'acqua, da un immagine satellitare cui sono state associate le classi semantiche grazie ad un programma utilizzato all'interno dell'azienda e grazie a delle query ho ridefinito i cromatismi dei pixel differenti dalla nostra classe e successivamente ho sviluppato un'applicazione Java che permette di visualizzare le immagini caricate all'interno dei database spaziali dopo la colorazione.
APA, Harvard, Vancouver, ISO, and other styles
2

Santana, Rodrigo da Rocha Borges de. "DBST: uma API para criação de trajetórias semânticas no SGBD PostgreSQL/Postgis." Universidade Federal de Pernambuco, 2013. https://repositorio.ufpe.br/handle/123456789/12369.

Full text
Abstract:
Submitted by Luiz Felipe Barbosa (luiz.fbabreu2@ufpe.br) on 2015-03-12T14:48:44Z No. of bitstreams: 2 Dissertacao RodrigoSantana.pdf: 2888143 bytes, checksum: 937f7fa91f618165df547717df77b4be (MD5) license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5)
Approved for entry into archive by Daniella Sodre (daniella.sodre@ufpe.br) on 2015-03-13T12:59:03Z (GMT) No. of bitstreams: 2 Dissertacao RodrigoSantana.pdf: 2888143 bytes, checksum: 937f7fa91f618165df547717df77b4be (MD5) license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5)
Made available in DSpace on 2015-03-13T12:59:03Z (GMT). No. of bitstreams: 2 Dissertacao RodrigoSantana.pdf: 2888143 bytes, checksum: 937f7fa91f618165df547717df77b4be (MD5) license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5) Previous issue date: 2013-04-19
Atualmente, cada vez mais existem Sistemas de Gerenciamento de Banco de dados (SGBD) que disponibilizam tipos de dados com características geométricas e temporais, para indicar a localização de um dado objeto móvel no espaço e no tempo, ou demarcar topologicamente uma dada região. Isso se deve ao aumento do uso de tecnologias de localização geográfica, tal como o Sistema de Posicionamento Global (GPS). Cada vez mais cresce o uso de GPS por aplicações de domínios distintos. No entanto, os dados coletados por dispositivos de localização acoplados a objetos móveis que se deslocam ao longo do espaço e do tempo, não apresentam informações semânticas, dificultando a análise e compreensão destes dados. Por isso, foi identifcado a falta de SGBD capazes de representar e manipular trajetórias semânticas. Existem vários trabalhos na literatura voltados para modelagem de trajetórias semânticas e para análise de trajetórias brutas obtidas de GPS para extração de conhecimento. Uma vez geradas e modeladas, as trajetórias semânticas precisam ser armazenadas em um SGBD. Por isso, este trabalho tem como objetivo estender o SGBD PostgreSQL/Postgis com novos tipos de dados para representação de trajetória semântica. Para facilitar a utilização desses novos tipos de dados, é também proposta uma Application Programming Interface (API) denominada de DBST (Database of Semantic Trajectories). A validação destes novos tipos de dados e da API DBST foi feita pela geração de bases de dados de trajetórias semânticas para dois domínios de aplicação distintos e com base em dados reais de trajetórias de objetos móveis.
APA, Harvard, Vancouver, ISO, and other styles
3

Ткаченко, В. Ф., and Н. И. Губа. "Геоинформационная система портала открытых данных региона." Thesis, ТОВ «ДРУКАРНЯ МАДРИД», 2015. http://openarchive.nure.ua/handle/document/5292.

Full text
Abstract:
В докладе рассматривается концептуальная архитектура геоинформационной системы Портала открытых данных Харьковской области и технология ее создания на базе программных продуктов с открытым кодом PostGis/PostgreSQL.
APA, Harvard, Vancouver, ISO, and other styles
4

Fackel, Edvin, and Robin Kolmodin. "Webbapplikation för felsökning på nätverksnoder." Thesis, Högskolan i Gävle, Datavetenskap, 2020. http://urn.kb.se/resolve?urn=urn:nbn:se:hig:diva-32494.

Full text
Abstract:
Hantering av larm från nätverksnoder är i dagsläget en process som kräver att nätverkstekniker besöker flera olika källor av information för att dra en slutsats över vad orsaken till larmet kan vara. Genom att besöka flera olika källor av information kan det vara komplicerat att få en överblick över problemet. Studien utförs på uppdrag av Trafikverket för att underlätta arbetet för Trafikverkets nätverkstekniker på avdelningen network operations center (NOC). En webbapplikation har utvecklats för att sammanställa de vanligaste källorna som nätverkstekniker besöker. Webbapplikationen amalgamerar och presenterar information på ett sätt som bör underlätta felsökningsprocessen för nätverkstekniker. Webbapplikationen indikerar de vanligaste felorsakerna, beroende på vilken typ av larm som hanteras. Valmöjligheter vid utveckling av en webbapplikation kan göra det svårt för utvecklare att välja mjukvara. Även om mjukvara delvis sorteras ut beroende på i vilket syfte som utvecklingen sker finns fortfarande en stor mängd alternativ. Denna studie har förtydligat och bevisat att mjukvaran NodeJS, PostgreSQL och PostGIS fungerar enhetligt och är att föredra för en webbapplikation med spatiala funktioner. För att utvärdera webbapplikationen genomfördes ett användartest där nio personer, 47% av personalen på Trafikverket NOC deltog. Användartestet visar positiva resultat gällande hur väl webbapplikationen fyllde sitt syfte med att indikera möjliga orsaker för nätverkslarm samt deltagarnas upplevelse med webbapplikationen. I användartestet anser 100% av deltagarna att webbapplikationen skulle spara dem tid och de tre populäraste funktionerna var polygoner för att visa elnätägare, realtids väderdata samt en sammanställning av interna data på samma ställe.
Handling of alarms on network nodes is a process that requires network technicians to visit several sources of information before they can draw a conclusion on the reason behind the alarm. By visiting several different sources of information, it may be difficult to establish a good overview of the problem. This study is made on request by the Swedish traffic authority Trafikverket to ease the workload of the co-workers at the department network operations center (NOC). A web application has been developed to amalgamate the most common sources a network technician visits. The web application presents the amalgamated information in a way that eases the troubleshooting process for the network technicians. The web application also indicates what the most common reasons are, depending on which kind of alarm that is being handled. Due to the large availability of different software it can be difficult for a developer to choose a suitable software. Even if some are excluded based on the purpose of the development there are still many choices. This study emphasizes that the software NodeJS, PostgreSQL and PostGIS works well together and is a suitable choice when creating a web application that needs to use spatial functions. To evaluate the web application a user test was conducted were nine participants, 47% of the personnel at Trafikverket NOC participated. The result shows positive results in both how well the web application filled its purpose by indicating possible reasons for a network alarm as well as the participants experiences with the web application. In the user test 100% of the participants claim that the web application would save them time and the three most popular features were polygons of electricity distributors, real time weather data and an amalgamation of internal data in one place.
APA, Harvard, Vancouver, ISO, and other styles
5

Silva, Jefferson Luiz Gonçalves. "Identificação das áreas aptas a aplicação de biofertilizantes suínos com utilização de SIG." Universidade Estadual do Oeste do Paraná, 2017. http://tede.unioeste.br/handle/tede/3299.

Full text
Abstract:
Submitted by Neusa Fagundes (neusa.fagundes@unioeste.br) on 2018-02-09T16:58:35Z No. of bitstreams: 2 Jefferson_Silva2017.pdf: 21962500 bytes, checksum: b5f3e1638dea54ab903a20e7e41671d6 (MD5) license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)
Made available in DSpace on 2018-02-09T16:58:35Z (GMT). No. of bitstreams: 2 Jefferson_Silva2017.pdf: 21962500 bytes, checksum: b5f3e1638dea54ab903a20e7e41671d6 (MD5) license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) Previous issue date: 2017-07-10
Brazil is the fourth largest swine producer and exporter in world, with swine farming being very representative in the national scenario. This production, however, implies generation of waste and this needs to be mitigated. One of the alternatives to reduce the impact caused by pig waste is the application of anaerobic biodigestion treatment, obtaining biogas and digestate as by-products. Digestate can be used as biofertilizer, generating a new product. In this context, this work proposes to define a geographic database from different sources about the national production of swine and to estimate, supported by calculation methodology defined in activities of the BiogasFert Network, the respective production of waste and biogas. These results were provided in an web system using GeoServer map server. In addition, a methodology was defined in this work to identify areas of permanent preservation in top of hills, based on the Brazilian new forest code published since 2012, and in classes of declivity unfit for fertilizer inputs (regions with slopes greater than 45%). As result, a total of 60,879,431 km² (0,72%) of areas considered inapt for the application of fertilizers in the national territory were identified. Another objective of this work was to highlight the use of free GIS software and its processing power, since the metrics applied here were elaborated using exclusively open source software.
O Brasil é o quarto maior produtor e exportador de carne suína mundial, tendo a suinocultura uma grande representatividade no cenário agropecuário nacional. Essa produção, contudo, implica na geração de resíduos, que necessitam ser mitigados. Uma das alternativas para reduzir o impacto causado por dejetos de suínos é a aplicação de um tratamento de biodigestão anaeróbia, obtendo-se como subproduto o biogás e o digestato, o qual pode ser utilizado como biofertilizante, tornando-se não só uma forma de tratamento como também de geração de novos produtos. Neste contexto, este trabalho propôs definir uma base de dados geográfica a partir da integração de fontes distintas acerca da produção nacional de suínos e estimar, apoiado por metodologia de cálculo definida em atividades da Rede BiogásFert, a respectiva produção de dejetos e biogás. Tais resultados foram aportados em sistema web via servidor de mapas GeoServer. Além disso, define-se neste trabalho metodologia para identificar áreas de preservação permanente em topo de morro, a partir do novo código florestal veiculado desde 2012, bem como as classes de declividade inaptas ao aporte de fertilizantes (regiões com declividade superior a 45%). Como resultado, foi identificado um total de 60.879,431 km² (0,72%) de áreas consideradas inaptas à aplicação de fertilizantes no território nacional. Um outro objetivo deste trabalho foi o de evidenciar o uso de softwares SIG livres e o seu poder de processamento, visto que as metologias aqui aplicadas foram elaboradas com uso exclusivo de softwares open source.
APA, Harvard, Vancouver, ISO, and other styles
6

Ткаченко, В. Ф., Н. И. Губа, and И. А. Божинский. "Архитектура и инструментальные средства создания муниципальной геоинформационной системы." Thesis, ХНУРЄ, 2014. http://openarchive.nure.ua/handle/document/5276.

Full text
APA, Harvard, Vancouver, ISO, and other styles
7

Matula, Lukáš. "Indexování databází: SP-GiST pro PostGIS." Master's thesis, Vysoké učení technické v Brně. Fakulta informačních technologií, 2016. http://www.nusl.cz/ntk/nusl-255451.

Full text
Abstract:
The goal of the master ́s thesis is to study index methods, spatial data type objects in PostgreSQL database systems and to create SP-GiST index by quadtree in the PostGIS. The PostGIS is spatial database, which extends of PostgreSQL. PostGIS adds support for geographic and spatial objects. It is a big benefit. PostGIS has its own data types, methods and GiST index too, but there is SP-GiST index missing, therefore master's thesis was created.
APA, Harvard, Vancouver, ISO, and other styles
8

Wong, James C. "Use of the general transit feed specification (GTFS) in transit performance measurement." Thesis, Georgia Institute of Technology, 2013. http://hdl.handle.net/1853/50341.

Full text
Abstract:
Until recently, transit data lacked a common data format that could be used to share and integrate information among multiple agencies. In 2005, however, Google worked with Tri-Met in Oregon to create the General Transit Feed Specification (GTFS), an open data format now used by all transit agencies that participate in Google Maps. GTFS feeds contain data for scheduled transit service including stop and route locations, schedules and fare information. The broad adoption of GTFS by transit agencies has made it a de facto standard. Those agencies using it are able to participate in a host of traveler services designed for GTFS, most notably transit trip planners. Still, analysts have not widely used GTFS as a data source for transit planning because of the newness of the technology. The objectives of this project are to demonstrate that GTFS feeds are an efficient data source for calculating key transit service metrics and to evaluate the validity of GTFS feeds as a data source. To demonstrate GTFS feeds’ analytic potential, the author created a tool called GTFS Reader, which imports GTFS feeds into a database using open-source products. GTFS Reader also includes a series of queries that calculate metrics like headways, route lengths and stop-spacing. To evaluate the validity of GTFS feeds, annual vehicle revenue miles and hours from the National Transit Database (NTD) are compared to the calculated values from agencies whose GTFS feeds are available. The key finding of this work is that well-formed GTFS feeds are an accurate representation of transit networks and that the method of aggregation presented in this research can be used to effectively and efficiently calculate metrics for transit agencies. The daily aggregation method is more accurate than the weekly aggregation method, both introduced in this thesis, but practical limitations on processing time favor the weekly method. The reliability of GTFS feed data for smaller agencies is less conclusive than that of larger agencies because of discrepancies found in smaller agencies when their GTFS-generated metrics were compared to those in the NTD. This research will be of particular interest to transit and policy analysts, researchers and transit planners.
APA, Harvard, Vancouver, ISO, and other styles
9

Marešová, Kristýna. "Analýza únikových tras v 3D modelu budovy." Master's thesis, Vysoké učení technické v Brně. Fakulta stavební, 2016. http://www.nusl.cz/ntk/nusl-390179.

Full text
Abstract:
The primary object of the master thesis is creating escape route analysis in 3D model of a building. Analysis is created using mainly open source tools like PostgreSQL with PostGIS and pgRouting extensions.
APA, Harvard, Vancouver, ISO, and other styles
10

Martinho, Nuno Miguel Rodrigues. "Integração do modelo EPANET no sistema de gestão de base de dados espaciais PostgreSQL/PostGIS: UrbanWater." Master's thesis, 2015. http://hdl.handle.net/10316/31719.

Full text
Abstract:
Dissertação de Mestrado em Engenharia Geográfica, apresentada à Faculdade de Ciências e Tecnologia da Universidade de Coimbra
A definição de metodologias de gestão e operação mais eficientes de um sistema de abastecimento de água (SAA) não pode hoje em dia deixar de passar pela adoção de Sistemas de Informação Geográfica (SIG) dada a natureza espacial da informação decorrente da sua atividade. A partir de um SIG a informação pode ser utilizada para a construção e desenvolvimento de modelos de simulação hidráulica. Estes constituem uma ferramenta de apoio para a Entidade Gestora (EG) no projeto e operação de um SAA. A construção e atualização de um modelo hidráulico pode ser um processo moroso e consumidor de recursos. A atualização da informação cadastral torna o modelo desajustado e consequentemente menos rigoroso. A existência de duas bases de dados, uma para o cadastro e outra referente ao modelo, obriga a um esforço adicional da EG na sua manutenção. Apesar da existência de soluções destinadas à modelação hidráulica, dotadas de funcionalidades de ligação e uso da informação armazenada num SIG estas representam custos adicionais, podendo deter menor flexibilidade face a procedimentos existentes na EG ou a satisfazer novas necessidades. A presente dissertação teve como objetivo a definição de um modelo de dados destinado a caracterizar as componentes do SAA e a integração da capacidade de modelação hidráulica, baseada no modelo EPANET 2, no Sistema de Gestão de Base de Dados (SGBD) open source PostgreSQL, dotado da extensão espacial PostGIS. O sistema desenvolvido permite a construção do modelo, a corrida da simulação hidráulica e armazenamento dos resultados numa base de dados única. Os procedimentos e funções necessárias foram escritos em pgSQL ou Python, sendo a sua execução levada a cabo pelo uso de instruções SQL, permitindo ao utilizador a seleção entre diferentes front-ends ou aplicações SIG Desktop. Por fim efetuou-se uma aplicação prática do sistema desenvolvido, considerando-se o SAA de Casal do Ribeiro (Ourém), gerido pela Be Water S.A.. O sistema desenvolvido mostra que uma abordagem integrada permite a criação de um modelo hidráulico de modo expedito a partir da informação cadastral armazenada, possibilitando o mapeamento dos resultados obtidos e a criação de consultas ou vistas mediante a utilização das capacidades do SGBD.
The establishment of more efficient management and operating approaches of a water supply system, cannot be done nowadays without the use of Geographical Information Systems (GIS). This fact is due to the spatial nature of data used and produced by the water utility. Within a GIS, the data could be used to develop and construct a hydraulic models. These are fundamental tools to support the design and operation of a water supply system. The construction and maintenance of a hydraulic model can be both a time and resource consuming process. The water supply data updating process renders the hydraulic model obsolete so less accurate. Using two databases, one for the GIS and another for the model, requires additional data updating efforts. In spite of the existence of hydraulic modeling softwares capable of connecting and importing GIS data, these solutions represent additional costs and may have lower flexibility to water utility existing procedures or sustaining future needs. This MSc dissertation aimed to design and implement a data model capable of characterizing water system’s main components and to integrate EPANET based hydraulic model into the open source database management system (DBMS) PostgreSQL, along with spatial extension PostGIS. The developed system is capable of assembling a hydraulic model, running a simulation and storing the results in a single database. The implemented procedures were coded in pgSQL or Python and can be executed using SQL instructions. This permits the user to choose among different front-ends or GIS Desktop solutions. Finally, a case study was conducted where the developed system was applied to Casal Ribeiro water system (Ourém), managed by Be Water S.A.. The implemented system showed that an integrated approach provides a fast method to create a hydraulic model using stored GIS data, in mapping results, and in creating queries or views using the DBMS capabilities.
APA, Harvard, Vancouver, ISO, and other styles
More sources

Books on the topic "PostGis/PostgreSQL"

1

Urbano, Ferdinando, and Francesca Cagnacci. Spatial Database for GPS Wildlife Tracking Data: A Practical Guide to Creating a Data Management System with PostgreSQL/PostGIS and R. Springer, 2016.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
2

Spatial Database for GPS Wildlife Tracking Data: A Practical Guide to Creating a Data Management System with PostgreSQL/PostGIS and R. Springer, 2014.

Find full text
APA, Harvard, Vancouver, ISO, and other styles

Book chapters on the topic "PostGis/PostgreSQL"

1

Fröhlich, Lutz. "PostGIS." In PostgreSQL 10, 245–60. München: Carl Hanser Verlag GmbH & Co. KG, 2018. http://dx.doi.org/10.3139/9783446456419.014.

Full text
APA, Harvard, Vancouver, ISO, and other styles
2

Charvát, Karel, and Michal Kepka. "Crowdsourced Data." In Big Data in Bioeconomy, 63–67. Cham: Springer International Publishing, 2021. http://dx.doi.org/10.1007/978-3-030-71069-9_5.

Full text
Abstract:
AbstractCrowdsourcing together with Volunteered Geographic Information (VGI) are currently part of a broader concept – Citizens Science. The methods provide information on existing geospatial data or is a part of data collection from geolocated devices. They enable opening parts of scientific work to the general public. DataBio Crowdsourcing Solution is a combination of the SensLog server platform and HSLayers web and mobile applications. SensLog is a server system for managing sensor data, volunteered geographic information and other geospatial data. Web and mobile applications are used to collect and visualize SensLog data. SensLog data model builds on the Observations & Measurements conceptual model from ISO 19156 and includes additional sections, e.g., for user authentication or volunteered geographic information (VGI) collection. It uses PostgreSQL database with PostGIS for data storage and several API endpoints.
APA, Harvard, Vancouver, ISO, and other styles
3

Ďuračiová, Renata, and Jana Faixová Chalachanová. "Fuzzy Spatio-Temporal Querying the PostgreSQL/PostGIS Database for Multiple Criteria Decision Making." In Lecture Notes in Geoinformation and Cartography, 81–97. Cham: Springer International Publishing, 2017. http://dx.doi.org/10.1007/978-3-319-61297-3_7.

Full text
APA, Harvard, Vancouver, ISO, and other styles
4

Yoo, Byounghyun. "Web-Based Information Exploration of Sensor Web Using the HTML5/X3D Integration Model." In Geospatial Research, 1046–65. IGI Global, 2016. http://dx.doi.org/10.4018/978-1-4666-9845-1.ch049.

Full text
Abstract:
This chapter investigates how the visualization of sensor resources on a 3D Web-based globe organized by level-of-detail can enhance search and exploration of information by easing the formulation of geospatial queries against the metadata of sensor systems. The case study provides an approach inspired by geographical mashups in which freely available functionality and data are flexibly combined. The authors use PostgreSQL, PostGIS, PHP, X3D-Earth, and X3DOM to allow the Web3D standard and its geospatial component to be used for visual exploration and level-of-detail control of a dynamic scene. The proposed approach facilitates the dynamic exploration of the Sensor Web and allows the user to seamlessly focus in on a particular sensor system from a set of registered sensor networks deployed across the globe. In this chapter, the authors present a prototype metadata exploration system featuring levels-of-detail for a multi-scaled Sensor Web and use it to visually explore sensor data of weather stations.
APA, Harvard, Vancouver, ISO, and other styles
5

Yoo, Byounghyun. "Web-Based Information Exploration of Sensor Web Using the HTML5/X3D Integration Model." In Artificial Intelligence Technologies and the Evolution of Web 3.0, 189–208. IGI Global, 2015. http://dx.doi.org/10.4018/978-1-4666-8147-7.ch009.

Full text
Abstract:
This chapter investigates how the visualization of sensor resources on a 3D Web-based globe organized by level-of-detail can enhance search and exploration of information by easing the formulation of geospatial queries against the metadata of sensor systems. The case study provides an approach inspired by geographical mashups in which freely available functionality and data are flexibly combined. The authors use PostgreSQL, PostGIS, PHP, X3D-Earth, and X3DOM to allow the Web3D standard and its geospatial component to be used for visual exploration and level-of-detail control of a dynamic scene. The proposed approach facilitates the dynamic exploration of the Sensor Web and allows the user to seamlessly focus in on a particular sensor system from a set of registered sensor networks deployed across the globe. In this chapter, the authors present a prototype metadata exploration system featuring levels-of-detail for a multi-scaled Sensor Web and use it to visually explore sensor data of weather stations.
APA, Harvard, Vancouver, ISO, and other styles

Conference papers on the topic "PostGis/PostgreSQL"

1

Kucuk, Ahmet, Shah Muhammad Hamdi, Berkay Aydin, Michael A. Schuh, and Rafal A. Angryk. "Pg-Trajectory: A PostgreSQL/PostGIS Based Data Model for Spatiotemporal Trajectories." In 2016 IEEE International Conferences on Big Data and Cloud Computing (BDCloud), Social Computing and Networking (SocialCom), Sustainable Computing and Communications (SustainCom) (BDCloud-SocialCom-SustainCom). IEEE, 2016. http://dx.doi.org/10.1109/bdcloud-socialcom-sustaincom.2016.23.

Full text
APA, Harvard, Vancouver, ISO, and other styles
2

Meyer, Theresa, and Ansgar Brunn. "3D Point Clouds in PostgreSQL/PostGIS for Applications in GIS and Geodesy." In 5th International Conference on Geographical Information Systems Theory, Applications and Management. SCITEPRESS - Science and Technology Publications, 2019. http://dx.doi.org/10.5220/0007840901540163.

Full text
APA, Harvard, Vancouver, ISO, and other styles
3

Colonese, Giovanni, Rodrigo Soares Manhães, Sahudy Montenegro González, Rogério Atem De Carvalho, and Asterio Kiyoshi Tanaka. "PostGeoOlap: an Open-Source Tool for Decision Support." In II Simpósio Brasileiro de Sistemas de Informação. Sociedade Brasileira de Computação, 2005. http://dx.doi.org/10.5753/sbsi.2005.14976.

Full text
Abstract:
This work describes PostGeoOlap, a decision support tool that integrates OLAP (On-Line Analytical Processing) and GIS (Geographical Information System) technologies in a single application. PostGeoOlap is an open source and a general-purpose tool to be used by application developers to easily develop their decision support applications. This tool works on the PostGreSQL DBMS using its spatial extensions (PostGIS) and performs the analytical and geographical functionalities using data warehouses.
APA, Harvard, Vancouver, ISO, and other styles
You might also be interested in the extended bibliographies on the topic 'PostGis/PostgreSQL' for particular source types:
Journal articles Dissertations / Theses
We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!

To the bibliography