AirGIS, a Geographic Information Systems (GIS) based air pollution and human exposure modelling system, is routinely used in conjunction with the Operational Street Pollution Model (OSPM®), across ...the globe, to assess local- or street-scale air pollution. We developed a substantially revised version of AirGIS (hereafter, new AirGIS) as a new modelling system in open-source GIS i.e. PostgreSQL software with its spatial extension PostGIS to (1) optimize the model performance enabling model calculations for a large number of sites over a large geographical area, with limited computing resources (2) replace the outdated programming language Avenue (3) become independent of commercial GIS software. This paper, therefore, aims to describe the overall structure of new AirGIS modelling system together with its strengths and limitations. Furthermore, the new AirGIS has been evaluated against various measured datasets of ambient air pollution (NOx, NO2, PM10 and PM2.5). In terms of reproducing temporal variation (single location, time series of concentrations e.g. annual, daily etc.) of air pollution, the new model achieved correlations (R) in the range 0.45–0.96. While, in terms of reproducing the spatial variation (several locations, single time interval), the new AirGIS achieved correlations in the range 0.32–0.92. The new model, therefore, can be used for both short- and long-term air pollution exposure assessments to facilitate health related studies. However, the present evaluation of the new modelling system also revealed that the new AirGIS significantly overestimated the observed concentrations for two out of four datasets. The possible reasons for these errors and future directions to reducing the bias in the new model output have been discussed.
•Development of an updated version of AirGIS air pollution and human exposure modelling system.•Overview of the new system's architecture and workflow.•Evaluation of the new model system against various measurements datasets.•Overview of the new system's strengths, limitations and future outlook.
The study answers the question which database is the best choice for efficient data storage of UML models. Three products were considered: MongoDB, PostgreSQL and Neo4J. The effectiveness test ...consists of measurement the response time of queries that save and load data. This study also take into account the memory increase ratio during data insertion and the level of complexity of the implementation of the test data mappers used in database queries.
The article discusses an efficient and automated way to import large amounts of data from Excel tables into a database. In various projects, there are tasks in which the flow of huge data, such as ...logs of program operations or manual operations performed at work sites, is vital for effective analysis.
Purpose – development of a module for automatic import of a large amount of data from Excel format into a database.
Method or methodology of work: the article discusses a method that implements automatic import of data from Excel tables into a Postgresql database.
Result: developed its own unique module that is able to process huge Excel tables and import them into a Postgresql database without manual operations.
Scope of the results: the data obtained, which are stored in the database, should be used to identify high-yield accounts for subsequent investment.
Para las empresas de desarrollo de software el capital intelectual constituye su activo más valioso, es por ello que la continua formación de sus recursos humanos, resulta imprescindible para lograr ...el éxito. El presente trabajo describe el modelo de capacitación en la línea de desarrollo de software implementado en la empresa DESOFT. Se enumeran las acciones de diagnóstico y de enseñanza realizadas, así como los resultados obtenidos.
The relevance of the topic under consideration is since in one of the Discord channel communities there was a need to collect the activity of channel members for a certain time and duration.
To solve ...this problem, it was decided to develop a database and a special bot to interact with this database and the Discord API to collect information.
The goal: development of a system for analyzing, collecting, and displaying information on the activity of participants, developing a database to store all information.
The method or methodology of the work: the article considers a project for collecting, storing, and displaying information about the activity of participants.
Results: a Python discord bot was developed that keeps statistics on the activity of channel members, a PostgreSQL database was developed that stores data on all participants and their activity.
Scope of the results: the functionality of the bot can be used to manage channel members, highlight the most active and allocate incentives for greater activity
Automatic Identification Systems (AIS) are collision avoidance devices used on-board both commercial and leisure craft. These systems report the position, track and speed of the vessel through Very ...High Frequency radio transmissions which are accessible to any suitable receiver. This paper explores the potential to use AIS data to inform small scale fisheries management and marine spatial planning. First, the propagation and reception of the line of sight AIS transmissions was modelled around the coast of Scotland to identify areas where the use of AIS may be compromised. Using open source Geographic Information System and relational database software, computationally efficient methods of processing and analysing AIS data were explored. Three months of AIS data derived from 274 Scottish small scale fishing vessels were used to provide spatio-temporal analyses of trip duration and distance travelled, location of fishing activities, and vessel dependency on fishing grounds. The coverage, opportunities and challenges of using AIS are discussed together with broader applications and future developments.
•Model predicts AIS data reception in the majority of Scottish coastal waters.•Open source software provides a useful and effective platform for AIS data analyses.•AIS data facilitates incorporation of small scale fisheries into spatial planning.•AIS data useful to characterise fishing trips and most important fishing grounds.•Important limitations of using AIS data for regulatory purposes identified.
Sistem Informasi Akademik (SIAKA) adalah sistem pengelola data sehingga memudahkan pengguna dalam kegiatan administrasi akademik secara online. Single Page Application (SPA) adalah aplikasi web yang ...sesuai pada satu halaman web dinamis tanpa refresh page. Penelitian bertujuan untuk mengaplikasikan SIAKA sesuai kebutuhan pengguna, bermanfaat, dan mudah digunakan, mengembangkan pengelolaan informasi realtime dan membantu komunikasi data lebih cepat serta menghemat sumber daya perangkat lunak. Metode penelitian meliputi studi lapangan dan kepustakaan sehubungan pembahasan terkait SPA, SIAKA, Forlap, PDPT dan Feeder Dikti. Perancangan sistem informasi menggunakan paradigma Convention Over Configuration. Pengelolaan aplikasi DBMS menggunakan PostgreSQL, dan port TCP-IP sebagai sarana komunikasi data. Hasil penelitian berupa aplikasi Sistem Informasi Akademik (xSIA) yang user friendly dengan tampilan informasi berbentuk teks dan grafik yang sinkron. Serta pengelolaan informasi realtime yang menghemat sumber daya perangkat lunak, karena Client side mengelola sendiri data yang dibutuhkan sesuai permintaan tanpa membebani kinerja server dengan tidak melakukan proses Rendering Data berulang-ulang.
As tecnologias geoespaciais fornecem ferramentas importantes para o planejamento e gestão do território, como por meio do Cadastro Territorial Multifinalitário (CTM), Nesse sentido, o objetivo deste ...trabalho é propor uma metodologia de CTM de baixo custo, com softwares livres, para auxiliar a tomada de decisão e atualização cadastral mediante uma Aplicação Web. A testagem da metodologia proposta foi desenvolvida no Distrito de Vale Vêneto, município de São João do Polêsine, Rio Grande do Sul, Brasil. Foram realizados dois trabalhos de campo na área de estudo para levantamento de dados aerofotogramétricos e cadastrais. Foram elaborados mapas estáticos e interativos para espacialização dos dados cadastrais, bem como uma Interface Web para a edição e atualização dos dados de maneira prática. A metodologia sugerida viabiliza a implementação do CTM em municípios com restrições orçamentárias, fomentando a aquisição de conhecimento territorial e facilitando o processo de tomada de decisão por meio da utilização de softwares de código aberto em diversos setores de órgãos públicos.
Les technologies géospatiales fournissent des outils essentiels pour la planification et la gestion du territoire, notamment à travers le Cadastre Territorial Multifinalitaire (CTM). Dans ce contexte, l'objectif de ce travail est de proposer une méthodologie de CTM à faible coût, utilisant des logiciels libres, pour aider à la prise de décision et à la mise à jour cadastrale à travers une application web. La validation de la méthodologie proposée a été réalisée dans le district de Vale Vêneto, commune de São João do Polêsine, Rio Grande do Sul, Brésil. Deux travaux de terrain ont été effectués dans la zone d'étude pour la collecte de données aérophotogrammétriques et cadastrales. Des cartes statiques et interactives ont été élaborées pour la spatialisation des données cadastrales, ainsi qu'une interface web pour l'édition et la mise à jour pratique des données. La méthodologie suggérée permet la mise en œuvre du CTM dans les municipalités avec des contraintes budgétaires, favorisant l'acquisition de connaissances territoriales et facilitant le processus de prise de décision grâce à l'utilisation de logiciels open source dans divers secteurs des organismes publics.
Geospatial technologies provide crucial tools for territory planning and management, such as the Multifunctional Territorial Cadastre (MTC). In this context, the objective of this study is to propose a low-cost MTC methodology using open-source software to aid decision-making and cadastral updates through a web application. The proposed methodology was tested in the Vale Vêneto District, São João do Polêsine, Rio Grande do Sul, Brazil. Two fieldwork campaigns were conducted to gather aerophotogrammetric and cadastral data in the study area. Static and interactive maps were created for spatial representation of cadastral data, along with a web interface for practical data editing and updates. The suggested methodology enables the implementation of MTC in municipalities with budget constraints, promoting territorial knowledge acquisition and streamlining decision-making processes through the use of open-source software across various sectors of public organizations.
The aim of this paper is to conduct research on the most popular database management systems such as MySQL, PostgreSQL and Firebird in terms of query performance, CPU load and disk usage. At the ...first stage, the analysis of the popularity of databases was carried out. In the second stage an application was created that allows for communication with selected databases. At the third stage, tests were carried out using a written application and analysis of results.
Floodplains provide ecosystem services (ES). Their evaluation is complex and integrative assessment remains challenging for sciences and practices. Studies have been published in the last two decades ...reporting ES monetary values of floodplains. Since ES are site-specific, we focus on those studies regarding the Europe's second largest river basin, namely the Danube River Basin (DRB). By analyzing these studies, we aim to answer the questions: “Do the significant predictor variables differ from previous meta-analyses?” and “Does the spatial database improve the meta-analysis?” In this context, we conducted a systematic review on Scopus and Web of Science combining the four themes “value”, “ES”, “floodplain”, and “location”. We conducted a meta-analysis of the Danube floodplains' ES values with different sub-groups based on the ES classes (provisioning, regulating, and cultural) and implemented model selection based on the corrected Akaike Information Criterion. We selected 251 entries from 25 studies to set up with a PostgreSQL spatial database, which provides limitless possibilities to enrich the information on the study areas. We observed that the most important variables to describe ES values of DRB floodplains depend on the ES class, but in general the area proportions of water bodies and riparian landscapes are important, together with the valuation method and the chemical or ecological status of the corresponding river section. Finally, we provided two versions of unconditional benefit-transfer functions to evaluate provisioning, regulating, and cultural ES. This paper complements previously conducted meta-analyses to recognize significant characteristics to value ES and it is a valid basis to help determine the ES value of Danube floodplains.
Display omitted
•Search of studies on ecosystem services values of floodplains in Danube countries•A spatial database stores the search results and connects them to additional data.•Multi (mixed-effects-)model inference produces reliable benefit transfer functions.•A fast valuation of Danube floodplains' ecosystem services is now possible.
PDF
