Tagged Questions

3
votes
1answer
4k views

Drawing polyline that grows as the car moves by taking data from MySql and PHP in Google API

I wanted to show the polyline on google Map as car moves with animation (like in this site: http://econym.org.uk/gmap/example_cartrip2.htm) by taking data from MySQL and PHP. For that i refered the ...
0
votes
1answer
487 views

Reference materials for learning Google API V3 with PHP and MySQL (tracking)

I am new to this Google API. Now i wanted to learn Google API with PHP and MySQL. Actually i wanted to create an application that will track x,y coordinates coordinates on real time bases for ...
6
votes
1answer
212 views

Trigger geocoding without having to visit page

I'm using Google's geocoder to store results in database then display them on a map on another page. The problem is that each company profile page needs to be visited before it's geocoded. Is there a ...
0
votes
1answer
276 views

shp2MySQL GIS Import Coordinates Not Correct

I'm attempting to import the Chicago Neighborhood Boundaries into a MySQL database from the shape files available at ...
1
vote
1answer
202 views

Calculate MBR envelope for different geometry shapes in different rows

I have some different kinds of geometry (Polygons and line strings) stored in my mysql database. On different rows. I know I can retrieve the envelope of one row with: SELECT Envelope(zoneShape) FROM ...
1
vote
1answer
1k views

How to add polygon in MySQL database

I have a table which contains an field zoneShape of the type Polygon. When inserting some geometry in this field, in phpmyadmin it says: affected 1 row. The row is added, but the geometry field says ...
5
votes
4answers
3k views

How to Geocode 300,000 addresses on the fly?

I have a database which has 300,000 address, which are to be shown on map. I know if I geo-code all the address it will be too expensive for me. So I was wondering if it is possible to geo-code the ...
2
votes
2answers
618 views

MySQL Query to fetch all cities and POI's near the route

I'm implementing alghorithm to search POI near the route (array of Lat, Long points). My problem is that I don't know how to calculate distance beetween line segment and POI. Look at picture that I ...