MySQL offers ENVELOPE() to find the minimum bounding rectangle of a geometric object.
The result is a polygon with four segments, defined by five points. It took me a while to make sense of it, partially because the only documentation that I’ve run across so far for POLYGON() syntax is in the ENVELOPE() function mentioned above. I also had to draw a picture to think it through.
They write this: POLYGON(( MINX MINY, MAXX MINY, MAXX MAXY, MINX MAXY, MINX MINY )), I think this (in pseudocode-ish form): POLYGON(( $point_a, $point_b, $point_c, $point_d, $point_a )), with the $point_s corresponding to the diagram.
Posted June 13, 2008 by Casey Bisson
Categories: Technology. Tags: geolocation, MBR, minimum bounding rectangle, 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 games.com (43) - www.geo.pk (25) - sexurdu.com (16) - www.sex with animals.com (15) - sexurdu,com (15) - www.world sex.com (14) - www.sex-animals.com (14) - sex-animals.com (13) - www.geo urdu.com (12) - www.sex animals.com (11) - www.sexurdu.com (10) - world sex.come (9) - www.world sex.come (9) - www.filmsex.com (9) - www.geo news urdu.com (8) - www.world.sex.com (8) - www.world sex (8) - XXX89COM (8) - www.Geonews.pk (8) - worldsexanimals (6) - wwwworldsex.come (6) - point (5) - googalearth (5) - minimum bounding rectangle (5) - www.googalearth (5) - filmsex.com (5) - bounded sex (5) - www.sex.pk (5) - www.pink games.com (4) - Minimal Bounding Rectangle (4) - w.w.w.world.sex.come (4) - www animl world sex.com (4) - sex.pk (4) - www.world sex .com (4) - www.worald sex.com (4) - www.sex games animals.com (3) - sexurdu (3) - urdu.com.pk (3) - www.sex-and-animals.com (3) - www.world sex.com.pk (3) - www. googalearth.com (3) - www filmsex.com (3) - www.worldsexcome (3) - www.world sex come (3) - www.sex in urdu (3) - sex animal.tv (3) - geo urdu.com (3) - www.world.sex.pk (3) - www.geo.tv.com (3) - www.geo.tv.urdu.com (3) - www.geo tv.com (3) - www.googalearth.com (3) - www.world sex.come. (3) - www.orld sex.com (3) - www.sex.pk.com (3) - world.sex.com (3) - www.filmsex (3) - miny brewery (2) - geo.urdu.com (2) - www.world sex.com 20005 (2) - minimum bounding rectangle. (2) - mysql spatial find MBR (2) - SEX.ANIMAL.TV (2) - www.sex-and-animals.com/ (2) - www.sex mit animals.com (2) - minimum bounding rectangle US state (2) - www.sex.games.-com (2) - SEX XXL (2) - sexurdu.com.pk (2) - world sex.com (2) - www.geo news urdu .com (2) - www.geo urdu.com, (2) - www.geo.news.urdu.com (2) - animals vidio (2) - www.sex.games.com (2) - geonews.urdu (2) - geonews.pk (2) - sex with animals.com (2) - www.world.sex.com. (2) - www.geo.tv.urdu (2) - www.xxl,sexye (2) - 89.COM ANIMALS.COM (2) - urdu sex;com (2) - www.x.sex.com (2) - www.arab games.com (2) - www.world.sex.come (2) - bounding sex (2) - www.geo.tv/urdu.com (1) - www.geonews.urdu.com (1) - geonews urdu.com (1) - findstuff games (1) - Polygon bounding rectangle (1) - www.worldurdusex.com (1) - sex.urdu (1) - MBR mysql (1) - USA google map minimum bounding rectangle (1) - www.sex-and-animals (1) - www. sex.games.com (1) - miny porn (1) - xxx video in urdu.com (1) - gis create bounding rectangle (1) - mysql getting mbr from envelope (1) - minimum area bounding rectangle (1) - sex.com,pk (1) - www.geo news.urdu.com (1) - ? wwwworldsex.come (1) - geo sex vidio (1) - sex animal tv.com (1) - W ORLD SEX.COM (1) - www indian world sex come (1) - x sex.COM.PK (1) - world. sex.com (1) - www,indian world sex come (1) - pk.com sex (1) - www.sex animal; tv.com (1) - vidio sexye pk.com (1) - www worled sex.com.pk (1) - geo.tv/urdu.com (1) - www,worild,sex,com,pk,, (1) - www.Geonews pk (1) - www.world sex.pk (1) - world urdu.com (1) - www.worldsex.com in urdu (1) - www.geo.pk] (1) - sexurdu,com,pk (1) - mexxx sex.com (1) - www.worldsex animals.com (1) - www.sex animal to animals.com (1) - world urdu sex.com (1) - sex mit animals (1) - www.world sexs.com (1) - www.geo.urdu.com (1) - www.pink poison sex.com (1) - geotv.com pk (1) - www.Sex Fuck games.com (1) - minimal rectangle polygone (1) - www.xxl.com (7) (1) - get minimum bounding rectangle javascript (1) - envelope minimum bounding rectangle (1) - minimum bounding rectangle for a rectangle (1) - www. worald sex.com (1) - water bouding sex (1) - www.xxx89com (1) - www.sex animal video.com (1) - urdu.com pk (1) - www.sex on tv.com (1) - filmsex (1) - worldsex (1) - www sex animals.com (1) - Www world sex come (1) -
so i’m looking at all your posts about mysql and gis, and i’m kinda curious what you’re working on - might it be relating LCSH geographic subdivisions to map data? now there’s a world of fun and discovery!