Completed

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

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

[url removed, login to view]

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

See more: 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, 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, 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

About the Employer:
( 14 reviews ) Dublin, Ireland

Project ID: #16894663

Awarded to:

jacobcarl222

Hello I read your job post carefully, I think this project is good fit for me. Because I have very good experience in PostgreSQL, MySql, JSON, REST API, JQuery, HTML and CSS. So I think I carry out your task succ More

$120 USD in 3 days
(2 Reviews)
1.4

6 freelancers are bidding on average $122 for this job

juniadsarfraz

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

$120 USD in 1 day
(37 Reviews)
6.2
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
(14 Reviews)
4.3
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 More

$100 USD in 1 day
(9 Reviews)
3.6
gooddeveloper923

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
(3 Reviews)
3.7
CrazyWebGuru

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
(4 Reviews)
3.0