I need the query (SELECT) in MYSQL to know the line (Polyline) closest to a polygon.

$450-3750 MXN

Kansellert

Lagt ut

over 11 år siden

$450-3750 MXN

Betalt ved levering

I need the query (SELECT) in MYSQL to know the line (Polyline) closest to a polygon. mysql_query("This is i need"). I have a longitude and latitude google maps sends me, then I want a query to find me the lines that are within 500m of the point that sent me google maps I have the coordinates of the routes in the database and the criteria is that the query returns the lines (routes) that are within 500m Public transport routes are in the database as LineString Saludos.

Prosjekt-ID: 2572125

Om prosjektet

13 forslag

Eksternt prosjekt

Aktiv 11 å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

13 frilansere byr i gjennomsnitt $1 650 MXN for denne jobben

@ganeshbaid

Time bounded Delivery. Fast and Quick Response. Quality Assured. Let's do it. Check PMB for more details.

$3 200 MXN om 30 dager

4,8

(143 omtaler)

7,2

@rjsultan

nEED data structure I hopefully complete your requirement.

$450 MXN om 2 dager

5,0

(48 omtaler)

5,3

@talkadah

Hello, I have the appropriate experience to do well this project.

$3 750 MXN om 1 dag

5,0

(15 omtaler)

4,3

@Toporchillo

Hola! Please, provide me information about database table fields and stored data. SQL-dump (or its part) will be very useful. Final bid depends on it.

$450 MXN om 2 dager

5,0

(1 omtale)

2,7

@AndreyCDI

Hi, check your PMB

$1 925 MXN om 1 dag

5,0

(2 omtaler)

2,9

@ashtimer

i can do this project for you

$1 325 MXN om 9 dager

5,0

(3 omtaler)

1,6

@GQS5knM10

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$3 750 MXN om 1 dag

0,0

(0 omtaler)

0,0

@dbland1026

I work with a software team in the transportation field, so I know what geo formulas to use to get the closest distance to a polygon. I would need to know the exact table structure, but I'm confident it can be accomplished.

$500 MXN om 3 dager

0,0

(0 omtaler)

0,0

@Elgraf

Hello I'll be glad to help you. A few days ago to perform this task. I have enough experience, knowledge and skills Thank you.

$499 MXN om 3 dager

0,0

(0 omtaler)

0,0

@FastAccurateSW

I have MySQL and GIS experience for this job. 30+ years of programming and database. I did GIS applications for urban spatial analysis of amenities. MySQL spatial extensions will handle your needs easily. Thanks!

$2 000 MXN om 15 dager