PostgreSQL/PostGIS - Exstract data from shapefile

Κλειστό Αναρτήθηκε Πριν 4 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

Extract the following information from "shapefile" files stored on a Postgres / PostGIS database:

- given a point on the map and a radius (expressed in meters) it will be necessary to identify the area of ​​a circle on the map.

A matrix of 0/1 values ​​containing the intersection of the shapemap with the area of ​​the circle must be extracted. A matrix for how many classes are present in the shapemap will be extracted. Everything must be exported to CSV;

- given a point on the map and a length and width (expressed in meters) it will be necessary to identify the area of ​​a rectangle on the map. A matrix of 0/1 values ​​containing the intersection of the shapemap with the area of ​​the rectangle must be extracted. A matrix for how many classes are present in the shapemap will be extracted. Everything must be exported to CSV.

The example shapefiles are OpenStreetMap format and will be provided on request.

It requires the development of queries or data extraction procedures.

Is it possible only to use open source software!!!

Χωροταξία Χαρτογραφία & Χάρτες PostgreSQL Γεωτοποθέτηση

Ταυτότητα Εργασίας: #24056497

Σχετικά με την εργασία

17 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 3 χρόνια

17 freelancers κάνουν προσφορές κατά μέσο όρο $176 για αυτή τη δουλειά

xtxskif

Hello! I graduated from AGH (Poland) and IFNTUOG (Ukraine). I have master degree in GIS and Cartography. I can help you. You can check my profile page to see my last experience. I'll use postgis/postgres for a long tim Περισσότερα

$250 USD σε 7 μέρες
(82 Αξιολογήσεις)
6.4
juniadsarfraz

EASY for me. 5+ years of professional experience as GIS Developer and Mapper. Have worked on ArcGIS JS api, ArcGIS Online, ArcGIS WAB, ArcGIS Pro ArcMap, ArcPY QGis, Python, Plugins PostgreSQL, Geospatial databases. Περισσότερα

$300 USD σε 7 μέρες
(7 Αξιολογήσεις)
5.8
khanjzthanjzt

Hi I have read and understand the latitude of the project. I'm GIS and Cartography expert. Allow me to complete the project. Warmest Regards

$250 USD σε 7 μέρες
(24 Αξιολογήσεις)
5.0
ishantrivedi15

Hi. I am a GIS Freelancer. I can definitely help you out in extracting the required data from shapefile.

$55 USD σε 3 μέρες
(17 Αξιολογήσεις)
4.8
smubeeen

Greetings! I have got your job posting “PostgreSQL/ PostGIS Extract data from Shapefile” and I am very much interested to work in your project. I am a GIS developer and have more than 2 years experience of working w Περισσότερα

$120 USD σε 1 μέρα
(20 Αξιολογήσεις)
4.4
RobertCogar

Hello, I can provide you perfect work as you looking for . we can discuss more in chat . I will be waiting for your response . I have very great experience about your project , if you want discuss more please send me Περισσότερα

$140 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
milosjovanovic88

Hi, My name is Milos from Serbia who is specialized in Web. I am familiar with CSV/PostgreSQL. I estimate to complete your project within a short time after clarifying all requirements, project details. I would appreci Περισσότερα

$300 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
yoloswagg

Hey! I've been working with PostgreSQL in production. I'd write a simple python script for your case which takes the data from Postgres and creates an output. Hit me up to discuss the details :)

$150 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
shahabadeli1887

hello. this is my exact skill and i do it for you with min price and period. you will be satisfied. my near 10 years' experience is in gis and geospatial science will help me to do your job. if you want i can send you Περισσότερα

$110 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
QASIM7862001

I can do this in 24 hours Hey there, i am developer from the UK with over 9 years experience in web development. Upon reading your project description this seems like a task which i can start on right now and will not Περισσότερα

$166 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
ozcanatay

Coğrafi Bilgi sistemleri Sistemleri Arcmap, Qgis, Globa Mapper İleri seviye Bilgi sahibiyim

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
grminnovation

Hi, I am A GIS specialist from freelancer. I have deep knowledge and strong skill in GIS, especially in database Postgis. I have read I will chat to your for discussing and would like to solve your problem. Please cont Περισσότερα

$140 USD σε 7 μέρες
(0 Αξιολογήσεις)
1.0
attiquem

Dear Employer, I have an experience of GIS mapping and conversion of maps from .DWG to .SHP or .GDB as per requirement, Clip / Export features inside polygon. as per your project description , you want to export featur Περισσότερα

$190 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
mpkprem

Having experience in similar projects Relevant Skills and Experience Having 22 years of experience in GIS

$222 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
kedarbhokarkar

i will be using Bentley peosucts with query generator for this to get tge data into csv. if thtats the case, the bid sounds ok to me.

$166 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
oabrarinef

My experience: Field Survey of Mapping Land System Scale 1: 50000 in Banten Province2019 Semi Detailed Detailed Soil Assessment in the PT. TRI INVESTAMA in Kutai RegencyEast, East Kalimantan Province

$222 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
hilalmohd

hi.. I'm a GIS expert. i read ur requirement. i have experience in postgreSQL and publishing maps through geoserver. I know how to extract values from shapefile. This work is very easy for me. I can deliver the work Περισσότερα

$55 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0