KML into MySQL or PostGIS

In Progress Posted Jan 17, 2011 Paid on delivery
In Progress Paid on delivery

A relatively straightforward requirement...

1. Create a polygon in Google Earth eg a rectangle, pentagon etc, and save as KML.

2. Import the KML polygon into MySQL (or PostGIS) as a spatial object and index (R-tree?).

3. For a series of lat/long points determine if the points are within the polygon by using spatial queries.

We would like this to run from a browser, but may require server side processing?

Also we would like the polygon stored in the database to be shown on Google Maps with a transparent fill, say red.

MySQL v5.5 is our preference but we are open to using PostGIS if this is easier/better. Please advise your recommendation as to the database.

Geolocation Google Earth MySQL

Project ID: #915977

About the project

8 proposals Remote project Active Jan 26, 2011

Awarded to:

happycoder2010

Hi, I'm highly interested on this project. Please check your PMB.

$150 USD in 1 day
(3 Reviews)
2.8

8 freelancers are bidding on average $275 for this job

hegazy

easy.. 1 day task.. I delivered more than 25 geolocation apps before.

$800 USD in 1 day
(7 Reviews)
4.9
MolikJain

Hi, We have done this already, Please check PMB.

$250 USD in 1 day
(0 Reviews)
2.0
kientt86

I worked on similar project before and have much experience in this kind of project. Please PM me, i send private message about detail project i did before.

$150 USD in 1 day
(0 Reviews)
0.0
milosSerbia

Think I could help. Worked with kml,and MySQL.

$150 USD in 2 days
(0 Reviews)
0.0
ckrath

I am working as a GIS Developer with 4 years experience and I have done similar projects before.

$200 USD in 3 days
(0 Reviews)
0.0
mcfoi

I did something like the what you did, based on both MySQL and Postgres exactly to probe the strnght and weakness of both dbms. The purpose of the 'proof of concept' was to plot on a map the position of several hundre More

$250 USD in 5 days
(0 Reviews)
0.0
willcadell

Hi there, I run a small geoweb consulting company up here in Northern Canada, we specialize in building mapping applications for the web. I have built numerous Google Maps & Earth apps and am very happy living in th More

$250 USD in 1 day
(0 Reviews)
0.0