Mysql query for Geodata

$15-25 USD / hour

Fullført

Lagt ut

omtrent 6 år siden

$15-25 USD / hour

I have data of about 5 MB (attached) I want query to display 100 meters from my location (Lat, Long) please check the table (27.721791666666665, 85.32254833333333) as reference point. It works for Geospatial query on mysql. Please show me the real thing on video then i can accept it. Only the successful developer can bid on this.

Database Administration

Database Programming

MySQL

PHP

Software Architecture

Prosjekt-ID: 16541359

Om prosjektet

8 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@audelk

hi sir, i have the script ready to show you. let me know thank you odel ...........................................................

$15 USD om 1 dag

4,9

(41 omtaler)

6,0

8 frilansere byr i gjennomsnitt $20 USD/time for denne jobben

@NourElDeen

A proposal has not yet been provided

$25 USD om 10 dager

5,0

(26 omtaler)

5,5

@khyatitankariya

Hi, I am a php developer and I have worked on one website which have this kind of functionality. To show users nearby feed stores which are around 15km. So I can do your task. I just need to create a video for that. I will create one or send you my works link on chat after a while. If you believe in quality work then please message me on freelancer so that we can disscuss more details. Thank you!

$20 USD om 1 dag

5,0

(3 omtaler)

4,1

@gjberto

I am a systems programmer analyst with over 25 years experience in the field, I developed desktop applications as well WEB utlizando also various methodologies and programming tools. I experience in several programming languages since its inception , Visual Studio/ Visual InterDEV / ASP / VB6 / VB.NET, PHP /C+ / Java / ASP.NET / Crystal Reports as well also varied databases such as Oracle / SQL / MySQL / QLIK / QLIKVIEW.. I have worked with VB6 graphics libraries, such as VeCAD to cite one example. I've migrated some applications from VB6 to .net , just 1 using the Interop Forms Toolkit I have the necessary skills to work on your project, but do not speak it fluently read and understand English very well. I can work from 4 to 6 hours a day. I pass a query to you to look, that query given the point that you had takes the values less than 100mts : SELECT id, ( 6371 * acos ( cos ( radians(27.721791666666665) ) * cos( radians( latitude ) ) * cos( radians( longitude) - radians(85.32254833333333) ) + sin ( radians(27.721791666666665) ) * sin( radians( latitude ) ) ) ) AS distance FROM positions HAVING distance < 0.10 ORDER BY distance Check it.

$22 USD om 30 dager