Closed

PostgreSQL/PostGIS - Exstract data from shapefile

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!!!

Skills: Geospatial, Cartography & Maps, PostgreSQL, Geolocation

See more: restore data folder postgresql windows, data entry job home hardcopy given chennai, identify possibilities given set data excel lotto, data create footprint shapefile, extract data xml given schema, postgresql data cnet, url want extract data given url, chennai vector data shapefile, using postgresql store gps data, custom field type save additional data sharepoint, read data shapefile asp net3 , postgresql postgis lion, highstock data series format, data entry given site, postgis elevation data, debian postgresql postgis pgrouting, install postgresql postgis, Fill in a Spreadsheet with Data from given website or google or facebook page, data entry, photo edit, list building, research leads generation, PDF conversion to word or excel format, Excel or spreadsheet t

About the Employer:
( 5 reviews ) Bitonto, Italy

Project ID: #24056497

20 freelancers are bidding on average $177 for this job

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 More

$250 USD in 7 days
(77 Reviews)
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. More

$300 USD in 7 days
(7 Reviews)
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 in 7 days
(24 Reviews)
4.9
ishantrivedi15

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

$55 USD in 3 days
(10 Reviews)
4.4
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 More

$120 USD in 1 day
(12 Reviews)
4.1
EduwardDementyev

Hello. I am a GIS(Geographical Information System) expert and Web&Mobile(iOS, android) developer. I graduated GIS special education course and I have been working on the GIS application development 10 years ago. I have More

$250 USD in 7 days
(1 Review)
1.1
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 More

$140 USD in 7 days
(0 Reviews)
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 More

$140 USD in 7 days
(0 Reviews)
1.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 in 3 days
(0 Reviews)
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 in 2 days
(0 Reviews)
0.0
mpkprem

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

$222 USD in 3 days
(0 Reviews)
0.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 More

$190 USD in 5 days
(0 Reviews)
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 More

$110 USD in 5 days
(0 Reviews)
0.0
ozcanatay

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

$155 USD in 3 days
(0 Reviews)
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 More

$166 USD in 1 day
(0 Reviews)
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 More

$300 USD in 3 days
(0 Reviews)
0.0
krim11

hi, share please the shape file. I am using AutoCAD map.

$166 USD in 3 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
KherlenS

Dear Client! I am very happy to see your project detail. I think it is just my project. :) I read your requirement carefully and understood fully. I am sure I can do your project. I have much experience with 8+years. More

$140 USD in 7 days
(0 Reviews)
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 More

$55 USD in 7 days
(0 Reviews)
0.0