Sample SQL query which shows how to make use of Geo spatial features in MS SQL Server and MySQL
$10-30 USD
ชำระเงินเมื่อจัดส่ง
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.
หมายเลขโปรเจค: #7685846
เกี่ยวกับโปรเจกต์
freelancer 2 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $22
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 เพิ่มเติม
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 เพิ่มเติม
