PostGres - sql query

$30-250 USD

Cancelled

Posted

about 6 years ago

$30-250 USD

Paid on delivery

I'm looking for a SQL query on a postgres database that will find the closest road geometry and return the closest matching database record. Sample Latitude, Longitude for Lookup: 51.38356, 0.15047 51.42524,0.23797 51.40002,0.20599 This query needs to be able to handle a 1 lat/long value or multiple lat/long values It needs to search: Streets_polyline, B_Roads_polyline, Motorways_polyline searching the "geom" column as the road polyline line string sample DB [login to view URL]

Database Administration

Project ID: 16894663

About the project

3 proposals

Remote project

Active 6 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

3 freelancers are bidding on average $114 USD for this job

@juniadsarfraz

GIS Developer here. VERY EASY, I have analyzed all requirements. I am interested. Thanks

$120 USD in 1 day

5.0

(39 reviews)

6.4

@gursukh

hi I have 5 year experience. I can show you my precious work I'm ready to start now I'm individual freelancer I have no timing issue I can do work any time . so can we discuss once.

$122 USD in 2 days

4.9

(47 reviews)

5.4

@pakistansolution

hello sir i can give this work with 100% satisfaction within time limit,and also i have great hands on SQL ,waiting for your message Experience in PHP, PHP Frameworks Like Codeigniter, Yii 2 and laravel 5 and its customization.

$100 USD in 1 day