Sample SQL query which shows how to make use of Geo spatial features in MS SQL Server and MySQL
$10-30 USD
Pago na entrega
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.
ID do Projeto: #7685846
Sobre o projeto
2 freelancers estão ofertando em média $22 nesse trabalho
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 Mais
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 Mais