Postgis logopekerjaan

I am looking for an experienced Django developer who can take on a long-term project. The key responsibilities will include: - Back...experienced Django developer who can take on a long-term project. The key responsibilities will include: - Backend development - Database management - API integration - Deployment using Docker, Celery, RabbitMQ, Redis The ideal candidate must showcase proficiency in: - Docker - Celery - RabbitMQ - Redis - Geodjango - GeoServer - PostGIS Moreover, I desire that the developer also has some hands-on experience with Geodjango, GeoServer, and PostGIS. GIS knowledge is a definite plus. This project will require someone who is quick to learn and adapt to new technologies or tools if needed. Let's connect if this sounds like a good fi...

I'm looking for an experienced GIS developer who is proficient in Python programming, qgis, Mapbox, rasterio, postGIS and other integration. Your primary role will be to explain GIS concepts relevant to my project; specifically, spatial analysis, cartography, and remote sensing. The ideal candidate: - Is confident in their ability to simplify complex GIS concepts - Possesses expert knowledge in Python and Mapbox - Can deliver the project as soon as possible Your input will significantly enhance my understanding of these GIS concepts and enable me to better navigate the system. Please state your relevant experience and availability in your bid.

I have an RHEL 8 Linux local server (vm) I want to install postgresql ,pgadmin4 and postgis extension on it

...SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programming, and familiarity with libraries such as pandas, geopandas, and GDAL for data manipulation and analysis. **Ideal Skills and Experience:** - Demonstra...

...SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programming, and familiarity with libraries such as pandas, geopandas, and GDAL for data manipulation and analysis. **Ideal Skills and Experience:** - Demonstrated abil...

...SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programming, and familiarity with libraries such as pandas, geopandas, and GDAL for data manipulation and analysis. **Ideal Skills and Experience:** - Demonstrated abil...

...SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programming, and familiarity with libraries such as pandas, geopandas, and GDAL for data manipulation and analysis. **Ideal Skills and Experience:** - Demonstrated abil...

I'm putting together a project focused on the visualization of LiDAR data using a combination of powerful tools and frameworks. This system is aimed at providing a clear and effective display of geographic data for various uses, primarily focusing on data visualization. **Core Requirements:** - Integration of PostgreSQL with PostGIS for efficient data storage and mangement. - Utilization of Potree for rendering large-scale point clouds in the browser, ensuring smooth and interactive data visualization. - Implementation of Leaflet for additional mapping capabilities, focusing on overlaying different types of data. - Experience with GeoServer for data publication needs, allowing different formats and services to be used seamlessly. - Development of RESTful APIs using Python (Fl...

I am in need of an experienced PostGIS developer, well-versed in geospatial data analysis, query optimization, and spatial database design. The main goal of this project is to design a spatial database for a specific GIS project I am currently working on. While no specific tools or software were selected, Your tasks will include: - Conducting a comprehensive geospatial data analysis - Implementing query optimization methods to enhance performance - Designing an efficient spatial database for the GIS project - help the team under the concepts of PostGIS so that they can write SQL queries using geospatial data. A proven track record in geospatial data projects and advanced knowledge of query optimization and spatial database design will be vital for successful complet...

I need a backend that utilizes PostgreSQL and PostGIS. I need a very simple UI, which can use HTML tags if the developer prefers (Or Reactjs, no other option), where a data profile can be created saving coordinates. For example, a profile is: Latitude: -989898 Longitude: -409390 User ID: 123 Name: Rafael Type: Singer There are 10 of these profiles. I want to be able to find the one closest to me. To determine my location, the geolocation from my browser should be used. Additionally, I want to be able to search for the closest profile of a certain type. An open-source map, OpenStreetMap, should be used to display the closest profiles on a map and also show simple balloons above each coordinate (No need for elaborate design; it can just display the name.) The delivery includes: (...

Hi. I need a Google presentation page with the following logos (png format). Laravel, php, Filament, Inertia, Svelte, Vue 3, ReactJS, , , Node.js, NestJS, Horizon, Typescript, Javascript, Nova, GraphQL (Apollo), i18n, , Keycloak, OAuth, Webhooks, Contentful, Brevo, Discourse, MySQL, MongoDB, PostgreSQL, postGIS, REST, TailwindCSS, Figma Azure Events Hub, Docker, Docker-Compose, AWS S3, Redis, Jest, git, Github, github actions, JIRA, Slack There should be aesthetic harmony: The logos must be aligned in lines (same vertical distance between lines) and the logos, within each line, should have the same height. Here is an example (with other technologies): When

...version control using git (GitHub) Desired Skills - Fundamental understanding of PHP 8+ and its nuances - Strong foundational understanding of HTTP (nginx) - Experience building JSON APIs (REST or RPC) - Experience building packages and using Composer - Experience writing unit tests and integration tests (Postman) - Understanding of both functional and OOP coding styles - Working experience with PostGIS and GeoJSON data - Working experience with OpenAPI schemas Target Profile - Enjoy working on challenging and complicated technical problems - Able to work autonomously with intiative and apply creative solutions - Understands the value of documentation, with some experience writing specs - Capable of taking/giving constructive feedback and engaging in discussions - Good commun...

On an existing Postgres 14.3 server I want to install postgis extension Red hat 6.5 Operating System Postgres was installed from source code and some extensions as well

...работы с messaging system NATS (или подобными, вроде Kafka); Опыт работы в проектах с микросервисной архитектурой: как написание самих микросервисов, так и настройка и взаимодействие с инфраструктурой; Технологический стек нашего проекта: Core api building: - Golang. User interface: - Vue3 - Web socket RPC for real-time data and REST for communication with API Base database: - Postgresql - PostGis Messaging between components: - High performance distributed system NATS Infrastructure Management: - Terraform - Ansible Migration to CI/CD: - CodeCommit - BitBucket - AWS Cloud Что будете делать: Разрабатывать новые микросервисы для существующего веб-приложения, добавлять новый функционал в уже готовые микросервисы. Помогать главному разработчику, выполняя менее приоритетные...

Hello everyone, have an exciting project with lots of traction in the UK. It is a expansion tool that allows companies to visualise key data including population age and income. Looking for someone to hep drive the development of the software which is already 80% completed. Existing tech has been built with CSS, Node, React, PostGIS, AWS. Screenshot of the existing tool. Looking for a problem solver that is hard working. Need a good level of english.

...серьезных интерфейсов на Vue.js; Коммуникабельность, умение эффективно взаимодействовать с командой; Умение взаимодействовать с чужим кодом (легаси-код, отсутствие документации); Опыт работы и понимание технологическим стека нашего проекта: Core api building: - Golang. User interface: - Vue3 - Web socket RPC for real-time data and REST for communication with API Base database: - Postgresql - PostGis Messaging between components: - High performance distributed system NATS Infrastructure Management: - Terraform - Ansible Migration to CI/CD: - CodeCommit - BitBucket - AWS Cloud Что будете делать: Разрабатывать новые микросервисы для существующего веб-приложения, добавлять новый функционал в уже готовые микросервисы. Помогать главному разработчику, выполняя менее приоритетные...

...серьезных интерфейсов на Vue.js; Коммуникабельность, умение эффективно взаимодействовать с командой; Умение взаимодействовать с чужим кодом (легаси-код, отсутствие документации); Опыт работы и понимание технологическим стека нашего проекта: Core api building: - Golang. User interface: - Vue3 - Web socket RPC for real-time data and REST for communication with API Base database: - Postgresql - PostGis Messaging between components: - High performance distributed system NATS Infrastructure Management: - Terraform - Ansible Migration to CI/CD: - CodeCommit - BitBucket - AWS Cloud Что будете делать: Разрабатывать новые микросервисы для существующего веб-приложения, добавлять новый функционал в уже готовые микросервисы. Помогать главному разработчику, выполняя менее приоритетные...

...интерфейсов на Vue.js; Опыт работы с REST, RPC, WebSocket API Коммуникабельность, умение эффективно взаимодействовать с командой; Умение взаимодействовать с чужим кодом (легаси-код, отсутствие документации); Технологический стека нашего проекта: Core api building: - Golang. User interface: - Vue3 - Web socket RPC for real-time data and REST for communication with API Base database: - Postgresql - PostGis Messaging between components: - High performance distributed system NATS Infrastructure Management: - Terraform - Ansible Migration to CI/CD: - CodeCommit - BitBucket - AWS Cloud Что будете делать: Разрабатывать новый функционал и вносить правки в существующий интерфейс веб-приложения. Помогать главному разработчику, выполняя менее приоритетные задачи, тем самым освобож...

...серьезных интерфейсов на Vue.js; Коммуникабельность, умение эффективно взаимодействовать с командой; Умение взаимодействовать с чужим кодом (легаси-код, отсутствие документации); Опыт работы и понимание технологическим стека нашего проекта: Core api building: - Golang. User interface: - Vue3 - Web socket RPC for real-time data and REST for communication with API Base database: - Postgresql - PostGis Messaging between components: - High performance distributed system NATS Infrastructure Management: - Terraform - Ansible Migration to CI/CD: - CodeCommit - BitBucket - AWS Cloud Что будете делать: Разрабатывать новые микросервисы для существующего веб-приложения, добавлять новый функционал в уже готовые микросервисы. Помогать главному разработчику, выполняя менее приоритетные...

I am looking for a freelancer who can assist me in converting my DWG files into Postgres/PostGis. The purpose of these files is for Geography/GIS. I require specific attributes to be extracted from the DWG files and a moderate level of detail in the output PostGIS data. Ideal skills and experience for this job include: - Strong knowledge of DWG to PostGIS conversion - Experience in extracting specific attributes from DWG files - Expertise in Postgres/PostGis - Understanding of Geography/GIS - Attention to detail and accuracy in output data. Once the conversion is done a web interface should be built to view the Autocad file converted, including all metadata and name references. the web engine should be apache over rockylinux, using leaflet or openlayers

I am looking for a freelancer who can help me set up a geoserver for displaying data on a world map and a detailed map of India. Specifically, I need to display population data on both maps. I require all levels of detail for the India map, including state, district, and city level data. The database I am using is PostGis. Ideal skills and experience for this job include: - Experience working with geoserver and PostGis databases - Knowledge of mapping and GIS software - Familiarity with population data and how to display it on a map.

Ищем front-end специалиста, с хорошими навыками и опытом Vue 3 на part-time занятость (ориентировочно 10-15ч/нед, по мере поступления новых задач) в логистический стартап. Русскоязычная команда, переписка и созвоны на ру...созвоны на русском языке. Оплата почасовая, укажите свой рейт и ссылку на портфолио. Tech stack приложения: Product building: •Microservices architecture. Core api building: •Golang. ETL pipelines: •Python •Golang User interface: •Vue3 •Web socket RPC for real-time data and REST for communication with API Geographic data and routing: •OpenStreetMap Base database: •Postgresql •PostGis Messaging between components: •High performance distributed system NATS

Ищем Middle+/Senior full-stack специалиста для интеграции готового веб-приложения с WhatsApp и Telegram рассылками. Part-time занятость ориентировочно 10ч/нед. Обязательно наличие опыта с WhatsApp и Telegram API integrations. ...full-stack задач. О нас: Логистический стартап с украинскими корнями для рынка США. Tech stack приложения: Product building: •Microservices architecture. Core api building: •Golang. ETL pipelines: •Python •Golang User interface: •Vue3 •Web socket RPC for real-time data and REST for communication with API Geographic data and routing: •OpenStreetMap Base database: •Postgresql •PostGis Messaging between components: •High performance distributed system NATS

I need someone with experience in POSTGIS to help me fix invalid geometries. I have a query that is giving an error: select (st_area(st_union(st_intersection(, ))::geography)) as cov_area, zip from a, b where st_intersects(,) group by zip ERROR: GEOIntersects: TopologyException: side location conflict at -x, y. This can occur if the input geometry is invalid.

Estamos buscando un Desarrollador Full-stack con experiencia en React, PostGIS + prisma ORM, firebase para Auth y Leaflet. Para trabajar en la creación de un Dashboard para una Web App ya existente. El objetivo del proyecto es desarrollar una serie de gráficos preestablecidos y cuadros de resumen que interactúen con un repositorio ya creado. El candidato ideal para este proyecto debe ser un desarrollador proactivo, con capacidad para trabajar en equipo, con habilidades analíticas y de resolución de problemas. La posición es para trabajar de forma remota, con la posibilidad de tener una relación a largo plazo con nuestro equipo. La confidencialidad es fundamental para nosotros, y requerimos de un desarrollador que esté dispuest...

this error appear when i try to backup the odoo database Database backup error: Postgres subprocess ('/usr/...sql', '2023') error 1 i know the reson of this error Because I was trying to install a module in Odoo But this message popped up for me when I installed it is ask me to creat a EXTENSION in postgris So I executed the commands in the postgres if i use this code DROP EXTENSION postgis CASCADE; then i can take backup So how can we keep the extension and at the same time we can make a backup copy ? You can check the problem on your device Try creating an extension in a database used by Odoo CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; And after that, you will not be able to make a backup for it from Odo If you solve this problem...

this error appear when i try to backup the odoo database Database backup error: Postgres subprocess ('/us...sql', '2023') error 1 i know the reson of this error Because I was trying to install a module in Odoo But this message popped up for me when I installed it is ask me to creat a EXTENSION in postgris So I executed the commands in the postgres if i use this code DROP EXTENSION postgis CASCADE; then i can take backup So how can we keep the extension and at the same time we can make a backup copy ? You can check the problem on your device Try creating an extension in a database used by Odoo CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; And after that, you will not be able to make a backup for it from Odo If you solve this problem, ...

...impediments to success. Present project outcome directly with customer, supporting analysis, methodology and outcomes. Working Skills & Experience Requirements  Bachelor’s degree or commensurate working experience; Master’s degree in GIS, Data Analytics, Engineering, Computer Science, or related field preferred. Minimum 5 years of relevant experience. Experience with Python, ArcGIS, QGIS, gdal, postgis, PostgreSQL, geo server, and Mapbox. Experience automating workflows. Experience implementing customized data models. Experienced in Advanced GIS Analysis. Experience administering PostgreSQL or other DBMS. Excellent written and oral communications skills with the ability to effectively communicate across the organization as well as to directly with the ...

Languages: - Python - JavaScript - css - html - sql Framework: - Django - postgresql - VueJS - Postgis (geospatial Postgres database) - internationalization i18n (nice to have) - tailwindcss (nice to have)

I installed a PostGre database on amazon RDS, I now need someone specialized in PostGre + PostGis to: - Explain to me the basics of PostGre + how to use RDS - Give me the setup in php to be able to connect remotely to the database - create a table containing polygons - Generate a postgre query to merge multiple polygons into one single polygon

Postgres/PostGIS - PG Routing Assistance Needed Must have vast and DOCUMENTED experience with Postgres/PostGIS especially with PG Routing A plus if you know leaflet and mapbox!

Se requiere realizar un nuevo modulo a app existente, se requiere en web, ios, android. Frontend app tecnologias: - Flutter - Dart Backend: - Spring 4.1 - Java 8 Base de datos: - Postgresql version 11+ - Postgis 3 Servidor actual: - Linux ubuntu 18 terminal - Apache tomcat 9 - Postgres 11 Visual Code Android Studio Unicamente personas que hablan español

I will collaborate with someone on a long-term permanent basis on work involving PostGreSQL, PostGIS, NoSQL, Oracle and Python. Please be prepared to speak about and show demos of your abilities in these technologies.

Este proyecto consiste en un servicio de consultoría para ...un proyecto de muestra donde se publiquen dos servicios basados en contenedores: 1. Geoserver (). 2. PostGIS (). También se dejará configurado el toolkit para Devops (CI/CD) GITLAB para kubernetes, configurando una pipeline sencilla de ejemplo que se conecte el repositorio GIT interno con una aplicación de muestra, permitiendo compilar, testear (con un test sencillo de muestra) y desplegar una nueva versión de la aplicación a partir del código fuente en el cluster de kubernetes. Como resultado, quedarán publicadas tres aplicaciones en kubesphere: Geoserver, PostGIS y otra aplicación interna de muestra como muestra de integración contínua...

1. Install the PostGIS spatial database software (if not already completed during week 7); 2. Extend their own existing assignment 1 PostgreSQL relational database to a PostGIS spatial database; 3. Write SQL commands in pgAdmin4 to create spatial data in the extended database; 4. Write spatial queries using SQL; 5. Install the MongoDB document database software, MongoDBCompass GUI and associated software (if not already completed in week 8); 6. Understand the embedded schema proposed and understand the examples given in Appendix A: 7. Use MongoDBCompass or mongosh to: a. Create a document database; b. Create a collection in that document database; c. Create documents within that collection; d. Write MongoDB commands to populate the collection; e. Write MQL to query the datab...

I want to make a project like the website bellow, the idea is to open a map, and make symboles and print the results in pdf file.

Dear POSTGIS expert. I need query (SQL) to generate table or view (preferred) with overlapping features or holes. I've 12 feature classes (12 postgres tables) with polygon data. I need to check if they cover all dataset range. I need to detect overlapping features and places without any feature. It is possible, to should be database view. If we agree I'll pay exactly amount we agree. I'll pay only if script will work.

- Create database with shapefile and associated information (relational database and geospatial database) - Integrate with website, retrieve and visualize the information on a map with possibility to enter additional data - Integration with back-end with remote sensing capabilities such as retrieve satellite imagery - ...retrieve and visualize the information on a map with possibility to enter additional data - Integration with back-end with remote sensing capabilities such as retrieve satellite imagery - Application of forestry and agriculture algorithms such as LULC/NDVI, including graphical and GIS visualization of results - Python - ArcPy - GeoTIFF files - React - React.JS - Leaflet - Chart Interface - RestAPI - PostGIS/mongoDB/PostgreSQL - Google Cloud/Google Earth Engine/Goog...

We have a map search feature on our existing website that needs some enhancements using Django backend and PostgreSQL (POSTGIS). We would like something similar to Zillow as much as possible using Google Map API. Thank you

The Role: The 3D Developer is responsible for creating interactive 3D map-based GIS applications. Job Responsibilities ● Use technologies such as Cesium, Mapbox, , PostGIS, Geoserver, QGIS to build interactive 3D web interfaces integrated with a React-based frontend ● Creating, handle and host 3D TileSets, Terrain tile like HeightMaps and (quantized-mesh) ● Research innovative solutions for original construction and architectural issues Job Requirements: ● Bachelor’s degree ● 3+ years of professional software development experience ● Some familiarity with cartesian System and other 3D Libraries like and ● Knowledge of Spatial databases, design, development, maintenance and administration ● Experience with modern javascript frameworks such as React & Express

...Technologies Java 8, Collections Framework, Spring Framework, JTS. Web Technologies RESTFul Web Service (Spring Boot), Google Map API Operating System Linux, Unix, Windows Methodologies Agile, SDLC ORM Tools Hibernate, Spring Data JPA IDE Tools Eclipse, STS, Visual Studio Code Build Tool Apache Ant, Apache Maven Identity Tool Keycloak Version Control Tools CVS, SVN GIT Database Technologies PostgreSQL, PostGIS Web/Application Server Tomcat, JBoss (WilddFly), WebLogic. Others PuTTY, FileZilla, winCVS, SoapUI, JIRA, Confluence, QGIS Senior Resource 5 + years ...

Project overview: - Web development / Existing project - Expected to be completed by May 09, 2022 Request details: We need a web developer with very good skills in: - Developing in OpenLayers (or similar Map API) - Administration and usage of GeoServer - PostGIS databases Good skills in: - HTML/CSS/JS - Geospatial things like intersecting polygon with line - git - English language You need a computer, an Android 10 (or newer) and iOS 15 device for testing your code. Our Openlayers map is already existing for different applications, for example showing location of trees or playgrounds. This map is used by public administrations for their periodic inspection of their objects. Now customers need another applicataion in existing map: Tracking their winter service, means removing sn...

...SIG multiplataforma, que permita visualização, edição e análise de dados georreferenciados. Deve permitir integração com outros pacotes open-source, tais como GRASS e MapServer, bem como estende funcionalidades através de plugins, desenvolvidos preferencialmente em Python e C++ e permitir conexão e uso de dados geoespaciais em formatos Drawing Exchange Format's, shapfiles, coverages, Mapinfo, PostGis, Image Files, entre outros, além integrar-se a Webservices no formato WMS e WFS. 1.1 - Além do módulo base que compõe as funcionalidades do software. 2 - • operar e ser compatível com todos os browsers (navegadores de internet) existentes no mercado e totalmente responsivo pa...

Hello, We are looking for a Web GIS Developer who can work with us for a long time. We have projects in Telecom, Agriculture, Property, Hazard & Mitigation domain. Candidate should have sound knowledge in: 1) ArcGIS API for JS 2) Openlayers 3) ArcGIS Server / Geoserver 4) PostGIS 5) Python Good to have: 1) PHP 2) Django 3) Node.js Looking forward for a long term partnership

You are required to be an expert in Python: - Specialised in Pandas, numpy, geopandas and NetworkX. - Specialised in Postgres SQL (PostGIS, PGRouting). - Understanding of the design pattern and OOP. - Developing standalone python package - Documentation A series of Jupyter notebook will be provided to you where an ETL process is coded in python (functional programming approach). The task requires you to adhere to the proposed data structure and convert these codes into OOP.

Project overview: - Web development / Existing project - Expected to be completed by Apr 01, 2022 Request details: We need a web developer with very good skills in: - Developing in OpenLayers - Administration and usage of GeoServer - PostGis databases Good skills in: - HTML/CSS/JS - Geospatial things like intersecting polygon with line - Design of buttons and dialogs - git - English language You need a computer, an Android 10 (or newer) and iOS 15 device. Our Openlayers map is already existing for different applications, for example showing location of trees or playgrounds. This map is used by public administrations for their periodic inspection of their objects. Now customers need another applicataion in existing map: Tracking their winter service, means removing snow and ice ...

Se solicita Instructor para dictar capacitación especializada en PostGIS- PostgreSQL, se requiere experiencia en el desarrollo sobre el lenguaje PSQL y la utilización de la extensión PostGIS, la capacitación es presencial en la CDMX

We are looking for a specialist to develop the Potree 1.8 point cloud view and 360 photo module. We need to create modules that allow to vectorize objects from the point cloud and write them into the PostGis database. The document (Potree ) describes the changes we are interested in. What must be new. At the end of the document is a table with a list of changes and priorities. Please refer to this table first to see what can be done (priority 1 is mandatory). The deadline and your price. Competencies: Web Development, Amazon S3, Python, PostgreSQL, Web Design, JavaScript, GIS, potree1.8 etc.

I need SQL script to update one table using another table for selected records form both tables. I have one table with countries for all world (COUNTRY table). The table has a geometry field (polygon). Record represent a country with country code. It is a referential table. Next, I have table (ROADS) represent roads for all world. In the table, I've empty field named country_code, which I have to fill country code from COUNTRY table. Additional I need to decide witch country will be processed. I think, that it should work like that: Q1. select on countries using county code. Q2 spatial query on roads using the Q1 (details will be given). Q3 Update ROADS table using Q2. Note, that I need filter both input sources - due huge data amount. In general, features should divide on country ...

[READ attached file] Technical specification for mobile application Backend: NodeJS some dependencies express, pg, camelcase-keys, jwt, etc Database: Postgres with postgis extension App: Flutter(plus) or React Native(NO Expo)