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

$450-3750 MXN

Cancelled

Posted

over 11 years ago

$450-3750 MXN

Paid on delivery

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.

Project ID: 2572125

About the project

10 proposals

Remote project

Active 12 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

10 freelancers are bidding on average $1,858 MXN for this job

@ganeshbaid

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

$3,200 MXN in 30 days

4.8

(143 reviews)

7.2

@rjsultan

nEED data structure I hopefully complete your requirement.

$450 MXN in 2 days

5.0

(48 reviews)

5.3

@talkadah

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

$3,750 MXN in 1 day

5.0

(12 reviews)

4.3

@ashtimer

i can do this project for you

$1,325 MXN in 9 days

5.0

(3 reviews)

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 in 1 day

0.0

(0 reviews)

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 in 3 days

0.0

(0 reviews)

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 in 15 days