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

$450-3750 MXN

Cancelado

Publicado

hace más de 11 años

$450-3750 MXN

Pagado a la entrega

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.

ID del proyecto: 2572125

Información sobre el proyecto

13 propuestas

Proyecto remoto

Activo hace 11 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

13 freelancers están ofertando un promedio de $1.650 MXN por este trabajo

@ganeshbaid

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

$3.200 MXN en 30 días

4,8

(143 comentarios)

7,2

@rjsultan

nEED data structure I hopefully complete your requirement.

$450 MXN en 2 días

5,0

(48 comentarios)

5,3

@talkadah

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

$3.750 MXN en 1 día

5,0

(15 comentarios)

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 en 2 días

5,0

(1 comentario)

2,7

@AndreyCDI

Hi, check your PMB

$1.925 MXN en 1 día

5,0

(2 comentarios)

2,9

@ashtimer

i can do this project for you

$1.325 MXN en 9 días

5,0

(3 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 3 días

0,0

(0 comentarios)

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 en 3 días

0,0

(0 comentarios)

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 en 15 días