We have a table which has polygon related data stored.
For finding if a point (long,lat) is within that polygon I am using following query in mysql
SET @vasantKunjSectorC = 'polygon((77.161266 28.546614, 77.16029 28.545304))';CREATE TABLE poly (g polygon);insert into poly values (GeomFromText(@vasantKunjSectorC))select * from poly
أكثر...
For finding if a point (long,lat) is within that polygon I am using following query in mysql
SET @vasantKunjSectorC = 'polygon((77.161266 28.546614, 77.16029 28.545304))';CREATE TABLE poly (g polygon);insert into poly values (GeomFromText(@vasantKunjSectorC))select * from poly
أكثر...