Develop query for PostgreSQL/PostGIS

$10-30 AUD

Completed

Posted

almost 9 years ago

$10-30 AUD

Paid on delivery

I have street name data in a PostgreSQL database. PostGIS is installed. The table "map_data" has many fields, but the important ones are ID (Intenger) NAME(char) the_geom(geometry(LineString,4326) Using the inputs Latitude and Longitude I need to return the streen name. Query may need to find nearest street if the co-ordinates do not fall exactly on street.

Geolocation

Geospatial

PostgreSQL

Project ID: 7649099

About the project

4 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@AlexYes

Hi, Thanks for inviting me! I have the experience of developing such kind of queries. Regards, Alex.

$25 AUD in 1 day

5.0

(29 reviews)

5.8

4 freelancers are bidding on average $60 AUD for this job

@andrewharvey4

...I don't have a one liner solution, but can put together a PL/pgSQL function for this. Cheers, Andrew

$168 AUD in 1 day

0.0

(0 reviews)

0.0

@pavelmoskotin

Good Day! I have experience with Postgres geometry and may quickly turn back to you with proposed solution on the task mentioned. Will be glad to hear, best regards, Pavel.

$25 AUD in 3 days

0.0

(0 reviews)

0.0

@krunalrp15

i have worked on postgresql to develop gis based applications from more than 3 years.

$40 AUD in 2 days

0.0

(0 reviews)

0.0

@adrase

I can do this. I work with PostGIS on daily basis. I do spatial analysis with milions of records. This is simple query with postgis functions.I can write procedure for you that will return street name from latlong inputs or simple query, what you prefer. I guarantee you will be pleased.

$23 AUD in 1 day