Sample SQL query which shows how to make use of Geo spatial features in MS SQL Server and MySQL

Lukket Lagt ut May 16, 2015 Betales ved levering

$10-30 USD

Betales ved levering

Lukket Betales ved levering

I have data in SQL Server and MySQL which contains latitude and longitude. I want someone to give me a 2 hour training on how i can make it better by using geospatial feature. As a part of training i want a SQL query to be provided which can give list of points near to a specific location and another SQL query which sorts the points based on distance from a given point. It should not make use of explicit distance calculation but rather use the database feature.

PHP Programvarearkitektur

Prosjekt-ID: #7685846

Om prosjektet

2 bud Eksternt prosjekt Aktiv Jun 23, 2015

Ønsker du å tjene litt penger?

Fordeler med budgivning på Freelancer

Oppgi ditt budsjett og tidsramme
Få betalt for ditt arbeid
Skisser ditt forslag
Det er gratis å registrere seg og by på jobber

2 frilansere byr i gjennomsnitt $22 for denne jobben

tikumishra sitt profilbilde
tikumishra

Hi I can give you sample code and explain over chat to show how this can be achieved. Definitely it cannt be done only in MySQL. PHP is needed to get the JSON data of Latt and Long from Google based on Address, Po Mer

$25 USD på 1 dag
(83 Omtaler)
6.1
robnicholson sitt profilbilde
robnicholson

I can help on the MSSQL side. I am a Microsoft Certified Solutions Master: SQL Server. I am a SQL Server Consultant working as a Developer and DBA, I have had 14 years experience (SQL Server 2005 - 2014). I have my own Mer

$19 USD på 1 dag
(1 anmeldelse)
0.9
Legg ut et slikt prosjekt