Link to home
Start Free TrialLog in
Avatar of trevor1940
trevor1940

asked on

MYSQL Spatial Data

I wish to store google coordinates in a  Database

Unfortunately web host Don't support  Postgress/ PostGIS so have to use MYSQL

many examples on the WWW including google developers suggest using float for both latitude & longitude

Why is this in preference to using point?

Should point be used for Lat Long values or is this for grid based co-ordinates?

How do you specify projection perimeters (SRID)?

If you use floats how do you perform any spatial analysis?
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of trevor1940
trevor1940

ASKER

Thanx