point-and-polygons.sql

CREATE TABLE `points` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `point` point NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

INSERT INTO `points` VALUES (1,0x0000000001010000005C2041F163344A40BA490C022B471340),(2,0x000000000101000000E9B7AF03E7344A40302AA913D0441340),(3,0x0000000001010000006ADE718A8E344A4052499D8026421340),(4,0x000000000101000000083D9B559F334A40832F4CA60A461340),(5,0x0000000001010000001283C0CAA1354A40E9482EFF213D1340),(6,0x00000000010100000076E09C11A5354A40B0726891ED3C1340),(7,0x00000000010100000042CF66D5E7324A402DB29DEFA7461340);



CREATE TABLE `polygons` (
  `id` int(11) NOT NULL,
  `polygon` polygon NOT NULL,
  PRIMARY KEY (`id`),
  SPATIAL KEY `polygon` (`polygon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `polygons` VALUES (9980,0x00000000010300000001000000050000006CD9E94E88334A409383BE470D4A1340DC2FDE3686334A403AD871B2B64913403B660438CF334A4093A22EA388481340CDCF7A70D1334A407FEEC074E44813406CD9E94E88334A409383BE470D4A1340),(10411,0x0000000001030000000100000005000000BDDBACB35C354A402046A92C923F13400ADE817159354A401028FEED0B3F134084CDB9688B354A40F7EBF611453E134049A473808E354A4022EC0E7CC43E1340BDDBACB35C354A402046A92C923F1340),(9994,0x00000000010300000001000000050000000ADE817159354A401028FEED0B3F1340BDDBACB35C354A402046A92C923F134030ADACFE31354A400002788E424013400CD179CF2E354A409623115DBF3F13400ADE817159354A401028FEED0B3F1340),(10010,0x0000000001030000000100000005000000FB9AB4E3CA334A40AE64BA773C4513405810D87F6E344A40114C77A995421340B865331272344A403DC18F8228431340BFFC4D87CE334A404EE75825D6451340FB9AB4E3CA334A40AE64BA773C451340),(10038,0x00000000010300000001000000050000000AB78849E1324A404BBCDC0D014A1340F2980183E1324A4096DCD4D1874A134075FBD81FC1324A40E6E0A10B914A1340BC4360E6C0324A40628626470A4A13400AB78849E1324A404BBCDC0D014A1340),(10060,0x00000000010300000001000000050000001C67EE67FF354A4066AF3BBD74311340467DD06603364A40EA7856A8C53113403C762E4AE2354A402588359BE532134036B8484BDE354A407DA9AFAF943213401C67EE67FF354A4066AF3BBD74311340),(10061,0x000000000103000000010000000500000018B95DBAD6354A40C2E0FB6755331340A97608D7F7354A40ABAF5A7635321340C1B17BFDFF354A40AF6A9CEFD5321340DADC99E0DE354A400E4062DDF533134018B95DBAD6354A40C2E0FB6755331340),(10062,0x0000000001030000000100000005000000B67553F7CE354A40F91D5F85A33813401ED842F1CF354A40B63DEC07593B1340407C958DAF354A40B38A5ED4603B1340B2B7A793AE354A4068C7E055AB381340B67553F7CE354A40F91D5F85A3381340),(10063,0x00000000010300000001000000050000005BE9FB9E7C354A402A60D9FD9E3C1340B5F3836D7C354A40433943CFB73B1340FAE8C82EA4354A4010B7281EB23B1340134A4160A4354A400CE55D4E993C13405BE9FB9E7C354A402A60D9FD9E3C1340),(10064,0x00000000010300000001000000050000001D857E0083354A40C139EE77903D1340A64615CF82354A40FBE11249A93C1340A3915A90AA354A40E4F2A799A33C1340663BC4C1AA354A40E85222CA8A3D13401D857E0083354A40C139EE77903D1340),(10098,0x00000000010300000001000000050000009F23EE81E7324A405798CF6BFF491340389B9049F3324A402FDDAC8EFE49134043C05A58F3324A40E2D2F45B854A13407241B890E7324A40E31FE938864A13409F23EE81E7324A405798CF6BFF491340),(10123,0x0000000001030000000100000005000000C28D6081CF354A40E041C29974351340FAD2349EF0354A408F74AAAB54341340791C91C4F8354A40B79F8025F534134085C085A7D7354A404509BD0F15361340C28D6081CF354A40E041C29974351340),(10124,0x00000000010300000001000000050000008D468C7ECD354A404D8A306C90341340F62E4F9BEE354A403E44DE7C70331340751EB5C1F6354A40DA9251F610341340141FBBA4D5354A409079C8E1303513408D468C7ECD354A404D8A306C90341340),(10156,0x00000000010300000001000000050000001583F9F6E3354A4092FA2BE96837134092649A12EC354A406C64549D6B351340C514C1D6F1354A40E6FEBF547B351340BC211EBBE9354A405C9B16A1783713401583F9F6E3354A4092FA2BE968371340),(10197,0x000000000103000000010000000C00000000EEB6300F354A40D0C9C2FE66401340A03DD1460F354A402457990F6440134096305C9B23354A40192720045D3F1340963FF0D023354A40022ED8EB5B3F1340D368F80524354A40E0D05B155D3F1340E730671B24354A40D0FDF4C95F3F134015ED8E0524354A40FE5F717C623F134068B2A7B00F354A40C11AB08C6940134053B6008B0F354A40C49F40916A4013408D7592600F354A407CCB5F616A4013402EF1E33E0F354A40B7C3380C6940134000EEB6300F354A40D0C9C2FE66401340),(10198,0x000000000103000000010000000D0000004FC8024EEC344A4081A73BE90141134037826D5BEC344A4024428881FF40134043C1E682EC344A40530B5007FE40134036E299580B354A40127FCE9183401340EAA203920B354A409FFA3ADD83401340CFF088B60B354A409A47D325864013400289F6B00B354A40E3411D1089401340C43BE4840B354A406C4D88EF8A40134034380EAFEC344A405DA99B650541134007044A8DEC344A407EBFD98205411340DBCDF36DEC344A40510E0CDC04411340429F5657EC344A4066CDC592034113404FC8024EEC344A4081A73BE901411340),(10199,0x000000000103000000010000000F000000CE86FE993A334A409C5963BCCC4613407AE478823A334A40BE1B8623CA461340C2A5B9963A334A4090B3784DC74613408FBDCACC3A334A4005CB8D15C64613402E1934265B334A40EA1447A3C046134011D8C83A5B334A40593F59CE31471340882DFD8ACB334A40AB76832059451340718585C4CB334A40213DF45D594513406712DDE9CB334A40E487C99D5B4513406C0732E5CB334A4030258C8C5E451340415B5CB9CB334A40928C2A7560451340675517985A334A403AC9B0923C4713407BA0F7825A334A40D243F572C8461340545416CE3A334A4071C191C9CD461340CE86FE993A334A409C5963BCCC461340),(10200,0x000000000103000000010000000D00000029A7FF6116344A40337671C13548134067902C6F16344A40FD75695E33481340A276199616344A40E89812E3314813401097CB0B32344A403C15A2CBC04713407983434532344A40AE379E0FC14713402CD7386A32344A408F664B53C3471340526A3F6532344A40C96D803DC647134066F79E3932344A405508C322C84713406656C0C316344A4013A3E03A394813405827D4A116344A402AD3215C3948134088E23C8216344A40EE1404B738481340382D6A6B16344A4014A9176D3748134029A7FF6116344A40337671C135481340),(10201,0x000000000103000000010000000D0000007E6614B56E344A406D99F78AB2421340020C48C26E344A406D8A4A27B042134043C945E96E344A4012C714ACAE421340F8ECDC58AF344A40FA63C670A24113401C375A92AF344A400B1059B1A2411340665482B7AF344A40F361F1F2A44113401075ABB2AF344A40938AA8E0A74113406C34D086AF344A40D6D882C7A94113402F7A3A176F344A407DE3BD02B6421340088A37F56E344A405A224F26B6421340F16E7DD56E344A408D841D82B5421340E54E8BBE6E344A403CDDCF37B44213407E6614B56E344A406D99F78AB2421340),(10203,0x000000000103000000010000000D0000001F83E19BB5344A408B31D97BE7411340286A0DA9B5344A406E8CD518E5411340FBE0F3CFB5344A409088699DE3411340266FE1F6E6344A40ABCBEF89164113407AB25E30E7344A40422A4FCA16411340D6A68C55E7344A408E1FB90B19411340996EBF50E7344A406602C6F81B411340E255FF24E7344A402D6208E01D4113401E49FAFDB5344A40B5EBDAF3EA411340602CFBDBB5344A4074B22117EB411340A7E144BCB5344A409887D572EA411340928C56A5B5344A408C2D8428E94113401F83E19BB5344A408B31D97BE7411340),(10377,0x000000000103000000010000000B000000D7B24A91D1324A401F1057EDD8461340EECD9AA5D1324A40E0E3A416D6461340A81BC5DBD1324A408A086EDFD44613402E4F29CD3A334A4061188415C6461340120791023B334A409EA1C62FC7461340B0DA25193B334A40A6C4BDE4C9461340C1A1A4033B334A40C2892FA1CC46134012D991CE3A334A40F91685C9CD461340607831DDD1324A403E264A93DC461340589CE9A8D1324A407EA06D87DB461340D7B24A91D1324A401F1057EDD8461340),(10380,0x00000000010300000001000000170000002480A93A0B354A401E0FA7B5E243134068CAE8470B354A40F09B1E51E0431340E1C1FF6E0B354A40105810D6DE4313400D1AC6AF5A354A40B102F39596421340415488DC5A354A405D374BDC9642134097AFF9BD5B354A40E65F0DCF9C42134021CE99E05B354A409803A1BD9E421340734567C65E354A40D851B30217431340BB5867C8B8354A406D615116A24113401907BE03B9354A4045BDE366A241134042F00628B9354A40D21C82D2A44113407F3ED320B9354A400A1AD0A2A7411340392FE5F5B8354A40E2BD516FA941134006EF9DA75E354A40647FC3951F431340870A57715E354A40D823103D1F431340F01DEE4D5E354A40B369901B1D431340B95A875C5B354A40867DCCE8A2421340F60EA2B65A354A40243E17879E421340A875639C0B354A40ED71432FE6431340573E797A0B354A40034A7350E6431340ABB6E35A0B354A40A02E3BABE5431340F39012440B354A40AECF4461E44313402480A93A0B354A401E0FA7B5E2431340),(10381,0x000000000103000000010000000D0000002463190C6F354A400C6AC9283E421340390960196F354A4034E39CC33B42134012298A406F354A40E889B5483A421340263AA2A1AF354A405D15DB9231411340841F1ADBAF354A400BE019D6314113402B061A00B0354A40D6037D193441134086290DFBAF354A402003100737411340DEC912CFAF354A40DB26F2EB38411340D5E2E86D6F354A40C1F206A24142134013FAF84B6F354A40CAC4B8C341421340F79E5D2C6F354A409437B31E41421340359984156F354A409A4AA0D43F4213402463190C6F354A400C6AC9283E421340),(10382,0x000000000103000000010000000D000000E62DC58309354A405A3BF3C54A43134047FD359109354A40B02FBF5D48431340C1DCC0B809354A402ACAB9E346431340C601946449354A407495760C48421340D720039E49354A4085947055484213406D91ACC249354A40A421619C4A42134028792FBD49354A4072AE73894D42134023DBEC9049354A4055FAE1694F421340C3D209E509354A40FB5F5F414E4313407A3C3AC309354A4059D4FC5F4E431340D90ACDA309354A40E0AFABB94D431340C396208D09354A40A37E30704C431340E62DC58309354A405A3BF3C54A431340),(10383,0x000000000103000000010000000D0000004ED8EE1735344A40E235A0FDB2471340DD51382535344A40E5B49898B04713400B00634C35344A40ECCAB61DAF471340AA40A4FE04354A406D9BA8E652441340067B233805354A40CC02A827534413402E5E475D05354A407FB69969554413409430555805354A406E69F258584413400E7E412C05354A40614BF13E5A44134074CDF87935344A40A576DB75B64713401E83FB5735344A400296CC98B6471340213D4B3835344A40C8F961F4B54713405444612135344A407EAF11AAB44713404ED8EE1735344A40E235A0FDB2471340);