PostGres - sql query

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



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]

Skills: Database Administration, Elasticsearch, MySQL, PostgreSQL, SQL

See more: https translate google com gh m hl en&sl en&tl fr&ie utf 8&prev m&q hello friend please i need your help, i m looking for a grant writer in nj, i m looking for a good autocad student, postgresql query multiple tables, postgresql advanced queries, psql query command line, postgres show tables, complex queries in postgresql, postgresql query tool, postgresql query create table, postgresql select query example, postgresql, i m looking for a gasmask designer, i m looking for a excel teacher, i m looking for a dress designers list, i m looking for a developer startup, i m looking for a content editor, i m looking for a computer coder, i m looking for a cloud software developer, i m looking for a bookkeeper for my small company

About the Employer:
( 15 reviews ) Dublin, Ireland

Project ID: #16894663

5 freelancers are bidding on average $123 for this job


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

$120 USD in 1 day
(39 Reviews)

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
(30 Reviews)

Hello how are you? I am very interested with your job post. I have rich experience with postgreSQL, MySQL, debgging SQL statement. So I think your job is good fit for me . I am looking forward to hearing good new More

$155 USD in 3 days
(7 Reviews)

Hi, there. I've read your project description carefully and I’m interested in your project. I have many good experiences in web development and postgresql. It's no problem for me to do this work. I can do your work More

$116 USD in 3 days
(14 Reviews)

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 More

$100 USD in 1 day
(13 Reviews)