It’s MySQL spatial data week here, though I am spreading out the posts to, um, ease the pain (or boredom). Anyway, here are some commands/functions I don’t want to forget about later:
Start with an existing table called geometry, add a spatial column and index it:
ALTER TABLE GEOMETRY ADD coord POINT NOT NULL;
CREATE SPATIAL INDEX coord ON GEOMETRY (coord);
Insert some data; think in terms of POINT(X Y) or POINT(lat lon):
INSERT INTO GEOMETRY (coord) VALUES( GeomFromText( 'POINT(40 -100)' ));
INSERT INTO GEOMETRY (coord) VALUES( GeomFromText( 'POINT(1 1)' ));
Get those X,Y coordinates back from the table:
SELECT X(coord), Y(coord) FROM GEOMETRY
Get points within a bounding rectangle:
SELECT MBRContains(
GeomFromText( 'POLYGON((0 0,0 3,3 3,3 0,0 0))' ),
coord
)
FROM GEOMETRY
Posted June 12, 2008 by Casey Bisson
Categories: Technology. Tags: geolocation, mysql, MySQL spatial functions, spatial data, spatial functions.
1 Comment(s)
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
www.sex-on-tv.com (85) - www.sex_on_tv.com (83) - mysql spatial (43) - www.sex.on.tv.com (29) - mysql geometry (21) - mysql polygon (21) - www.family sex.com (20) - mysql spatial data (19) - mysql GEOMFROMTEXT (13) - www.sex-on-tv-com (12) - www-sex-on-tv-com (12) - sex-on-tv.com (12) - WWW.SEX TV.COM (12) - mysql spatial example (10) - sex.on.tv.com (10) - Spatial Mysql (9) - www.sex-on-tv (9) - sex_on_tv.com (8) - mysql polygon example (8) - www.sex_on_tv (8) - GeomFromText mysql (8) - mysql point (8) - WWW.FAMILYSEX.COM (8) - wwwسكس.com (7) - mysql point in polygon (7) - www.sex-on-tv.com. (7) - www.family-sex.biz.com (7) - mysql point example (7) - mysql lat long (6) - MySQL Spacial (6) - www.family.sex.com (6) - www.family-sex.biz (6) - داستانهای سک (6) - mysql insert polygon (6) - mysql geometry data type (6) - www.family.sex.biz.com (5) - www.sex.on.tv (5) - mysql spatial distance (5) - family-sex.biz.com (5) - spacial data in mysql (5) - mysql spatial search (5) - spatial data mysql (5) - mysql geometry example (5) - www.sex total.com (4) - geometry to x y mysql (4) - insert polygon mysql (4) - geometry mysql data type (4) - mysql spatial database (4) - polygon mysql (4) - SEXSPACE.TV.COM (4) - www.family-sex.com (4) - mysql spatial calculate distance (4) - mysql geometry point (3) - mysql points (3) - spacial database (3) - mysql create spatial point (3) - insert polygon mysql spatial (3) - mysql point insert (3) - mysql spatial polygon (3) - www.18 tv.com (3) - www.sex-on- tv.com (3) - to generate spatial data from MySQL (3) - animalsextv (3) - mysql create point (3) - mysql spatial within (3) - mysql spatial rectangle (3) - www.family sex.com. (3) - www.porno total.com (3) - mysql geometry examples (3) - سک (3) - clip xy data mysql php (3) - mysql spatial functions (3) - mysql spatial inserting lat long (3) - mysql index lat lon (3) - mysql spatial database example (3) - mysql polygon data type example (3) - www.sex.-on-tv.com (3) - www.sex.on.tv. (3) - coord (3) - mysql spatial insert (3) - x y coordinate mysql (3) - geometry spatial index mysql (3) - mysql spatial index distance (3) - mysql insert polygon example (3) - mysql create spatial index from long lat (3) - mysql spatial commands (3) - سک3 (3) - mysql spatial index (3) - MySQL POINT examples -"point-in-time (2) - MySQL INSERT point (2) - mysql convert lat long to geometry (2) - MYSQL and spatial data (2) - mysql save latlong (2) - mysql polygon datatype (2) - sexspace tv.com (2) - www.sex.on-tv.com (2) - mysql geometry polygon how to (2) - google maps mysql geometry (2) - mysql create spatial table (2) - sex-on-tv. com/site/index-1.html (2) - www.sex-on-tv.com video (2) - geometry mysql (2) - mysql geometry index (2) - spatial mysql search (2) - wwwsexontv (2) - mysql point distance (2) - geospatial data with mysql (2) - spacial database in mysql (2) - mysql lat lon bounding box (2) - mysql point lat lon (2) - mysql spatial lat (2) - mysql geometry within distance (2) - w w w .sex_on_tv.com (2) - mysql spacial index (2) - w.w.w.SEX.ON.TV.COM. (2) - 40 100 select X Y geometry (2) - www.family.sex.com. (2) - sex videoları (2) - mysql spatial point (2) - mysql POINT php geometry (2) - mysql geometry distance (2) - mysql polygon insert (2) - Working with MySQL spatial data (2) - mysql google maps bounding box (2) - mysql spatial lat long (2) - mysql GEOMETRY sample (2) - php mysql spatial (2) - mysql POLYGON examples (2) - coordinate for sex-on-tv (2) - SPATIAL INDEX mysql (2) - spacial tv (2) - mssql spatial insert (2) - mysql spatial x y (2) - www.sex-on.tv.com (2) - www.sex on.tv.com (2) - www.sex on tv .com (2) - GeomFromText( mysql (2) - mysql spatial examples (2) - www.total-verboten.de (2) - mysql create spatial index (2) - www.sex.on.tv.com. (2) - date type geometry MySQL (2) - Mysql within() geometry (2) - mysql point x y (2) - FAMILY-SEX-BIZ.COM (2) - www.sex family.com (2) - mysql within() spatial (2) - www.18to19.com (2) - www.sex.on-tv-com (2) - total verboten.de (2) -
Hi,
We were planning to implement spatial database for a community site that we are building and were reading articles related to the same. As oracle/sql server seems to be heavily prices, we were thinking if we could use mysql for that purpose.
We were thinking about integrating google maps along with spatial database and wanted to know if there had been successful implementation of spatial databases with mysql and its comparison with services offered by oracle/ms-sql.
Any information or references related to this highly appreciated.
With regards,
Haran