LOREM IPSUM DOLOR SIT AMET, CONSECTETUR ADIPISCING ELIT, SED DO EIUSMOD TEMPOR INCIDIDUNT UT LABORE ET DOLORE MAGNA ALIQUA. UT ENIM AD MINIM VENIAM, QUIS NOSTRUD EXERCITATION ULLAMCO LABORIS NISI UT ALIQUIP EX EA COMMODO CONSEQUAT. DUIS AUTE IRURE DOLOR IN REPREHENDERIT IN VOLUPTATE VELIT ESSE CILLUM DOLORE EU FUGIAT NULLA PARIATUR.
DATABASES AND INTEGRATIONS
Our company specialises in providing competent support for PostgreSQL databases. We provide services such as installing and configuring a database, creating or reorganising the database structure, importing data into the database, troubleshooting and improving performance, updating the database, creating backups and restoring data, automating processes on the database, migrating data between different systems, and auditing spatial databases.
nasze systemy opensource GIS
POSTGRESQL DATABASES: DATABASE IMPLEMENTATION, INTEGRATION WITH AN EXTERNAL SYSTEM
As part of the provided service, the designed PostgreSQL database was implemented and the data held by the client was integrated. The process began with installing the relevant extensions on the PostgreSQL database and creating schemes and tables, including dictionary tables. Next, relationships between the tables were created, users and user groups were established and given appropriate permissions.
The following step consisted of creating triggers and views on the database, including triggers to retrieve plot geometry, automatically calculate area, and merge plot geometry. The data held by the client was implemented into the created database, functional and iterative testing was carried out. GIS objects have also been linked to Comarch's DMS, creating redirection links to selected objects in the QGIS project. Finally, the database backup process was automated by creating appropriate scripts.
ORACLE DATABASES: RECONFIGURATION AND SECURITY ENHANCEMENTS, DATA MIGRATION
As part of providing the service, we've carried out a diagnosis of the state of the Oracle database, including performance and security pre-tests, server configuration optimisation, and security configuration. Moreover, we took care of installing and configuring automatic backups, covering both the configuration of the disk array as well as creating backup scripts and restoring instructions.
The service delivery process began with an initial server and database audit, which verified the server's security. We then proceeded to install the SSL certificate, optimise the server configuration as well as the Oracle database itself. The following step consisted in migrating the spatial data from the old to the new database. The whole project ended with performance and data restoration tests.
GIS INTEGRATIONS: BILLING SYSTEMS
We perform integrations with billing systems so that users can access water meters and readings from the GIS. In the process, we gain access to information contained in billing databases as well as the location of water meters, which can be used for a range of analyses and processes.
These integrations allow for effective management based on up-to-date data, resulting in cost and time optimisation.
GIS INTEGRATIONS: SCADA
We perform integrations with SCADA class systems, allowing access to equipment signals from the GIS system. Obtaining a real-time view enables direct and precise monitoring of the network's operating status. The information collected in the databases can be used for visualisation and constitutes the foundation of a range of advanced hydraulic analyses.
This integration allows for faster responses to failures as well as optimised maintenance and repairs. Thanks to this, infrastructure management becomes more efficient and reliable.
GIS INTEGRATIONS: CRM SYSTEMS (BITRIX24)
We develop web-based GIS map apps (geoportals), which we integrate with external CRM systems. The solution allows the visualization of customers with CRM on an interactive map, allowing the card of the indicated lead to be viewed quickly and easily.
Integration significantly improves customer relationship management processes and supports sales strategy planning. Additional functions, such as filtering and searching, allow to easily manage clients according to various criteria.
ACCOUNT NUMBER
Santander Bank Polska
PL 72 1090 2590 0000 0001 3059 5136
INVOICE DATA
EnviroSolutions LLC
74 Glowna Str.
05-505 Wola Prazmowska
TIN: PL1231288496
KRS: 0000518057
XIV Commercial Division of KRS
FOLLOW US
WE SUPPORT THE DEVELOPMENT OF
%22%3E%3Cpath%20d%3D%22M21.8331%204.33313C23.3789%204.33774%2024.8601%204.95385%2025.9531%206.04689C27.0462%207.13993%2027.6623%208.62109%2027.6669%2010.1669V21.8331C27.6623%2023.3789%2027.0462%2024.8601%2025.9531%2025.9531C24.8601%2027.0462%2023.3789%2027.6623%2021.8331%2027.6669H10.1669C8.62109%2027.6623%207.13993%2027.0462%206.04689%2025.9531C4.95385%2024.8601%204.33774%2023.3789%204.33313%2021.8331V10.1669C4.33774%208.62109%204.95385%207.13993%206.04689%206.04689C7.13993%204.95385%208.62109%204.33774%2010.1669%204.33313H21.8331ZM21.8331%202H10.1669C5.675%202%202%205.675%202%2010.1669V21.8331C2%2026.325%205.675%2030%2010.1669%2030H21.8331C26.325%2030%2030%2026.325%2030%2021.8331V10.1669C30%205.675%2026.325%202%2021.8331%202Z%22%3E%3C%2Fpath%3E%3Cpath%20d%3D%22M23.583%2010.166C23.2369%2010.166%2022.8985%2010.0634%2022.6108%209.87109C22.323%209.6788%2022.0987%209.40549%2021.9662%209.08572C21.8338%208.76595%2021.7991%208.41408%2021.8666%208.07461C21.9342%207.73514%2022.1008%207.42332%2022.3456%207.17858C22.5903%206.93384%2022.9021%206.76717%2023.2416%206.69964C23.5811%206.63212%2023.9329%206.66677%2024.2527%206.79923C24.5725%206.93168%2024.8458%207.15598%2025.0381%207.44377C25.2304%207.73156%2025.333%208.0699%2025.333%208.41602C25.3335%208.64597%2025.2886%208.87376%2025.2008%209.0863C25.113%209.29884%2024.9842%209.49196%2024.8216%209.65456C24.659%209.81716%2024.4658%209.94605%2024.2533%2010.0338C24.0407%2010.1216%2023.813%2010.1665%2023.583%2010.166Z%22%3E%3C%2Fpath%3E%3Cpath%20d%3D%22M16%2011.3331C16.923%2011.3331%2017.8253%2011.6068%2018.5928%2012.1196C19.3602%2012.6324%2019.9584%2013.3613%2020.3116%2014.2141C20.6648%2015.0668%2020.7573%2016.0052%2020.5772%2016.9105C20.3971%2017.8157%2019.9526%2018.6473%2019.3%2019.3C18.6473%2019.9527%2017.8157%2020.3971%2016.9105%2020.5772C16.0052%2020.7573%2015.0668%2020.6649%2014.2141%2020.3116C13.3613%2019.9584%2012.6324%2019.3602%2012.1196%2018.5928C11.6068%2017.8253%2011.3331%2016.923%2011.3331%2016C11.3344%2014.7627%2011.8266%2013.5764%2012.7015%2012.7015C13.5764%2011.8266%2014.7627%2011.3344%2016%2011.3331ZM16%209C14.6155%209%2013.2622%209.41054%2012.111%2010.1797C10.9599%2010.9489%2010.0627%2012.0421%209.53285%2013.3212C9.00303%2014.6003%208.86441%2016.0078%209.13451%2017.3656C9.4046%2018.7235%2010.0713%2019.9708%2011.0503%2020.9497C12.0292%2021.9287%2013.2765%2022.5954%2014.6344%2022.8655C15.9922%2023.1356%2017.3997%2022.997%2018.6788%2022.4672C19.9579%2021.9373%2021.0511%2021.0401%2021.8203%2019.889C22.5894%2018.7378%2023%2017.3845%2023%2016C23%2014.1435%2022.2625%2012.363%2020.9497%2011.0503C19.637%209.7375%2017.8565%209%2016%209Z%22%3E%3C%2Fpath%3E%3C%2Fsvg%3E)
@2024 by EnviroSolutions
CONTACT
THE COMPANY
EnviroSolutions LLC
222/148 Gorczewska Str.
01-460 Warsaw
Poland