mysql> SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483711.8127301318 4197090.13317122, 483711.8127301318 4197125.039515583, 483740.4671919224 4197125.039515583, 483740.4671919224 4197090.13317122, 483711.8127301318 4197090.13317122))', 2100))); +--------+---------------------------------------------------------------------------------------+ | FID | the_geom | +--------+---------------------------------------------------------------------------------------+ | 109671 | POLYGON((483737 4197116,483752 4197116,483752 4197126,483737 4197126,483737 4197116)) | | 109670 | POLYGON((483737 4197106,483752 4197106,483752 4197116,483737 4197116,483737 4197106)) | | 109669 | POLYGON((483737 4197096,483752 4197096,483752 4197106,483737 4197106,483737 4197096)) | | 109668 | POLYGON((483737 4197086,483752 4197086,483752 4197096,483737 4197096,483737 4197086)) | | 108721 | POLYGON((483722 4197116,483737 4197116,483737 4197126,483722 4197126,483722 4197116)) | | 108720 | POLYGON((483722 4197106,483737 4197106,483737 4197116,483722 4197116,483722 4197106)) | | 108719 | POLYGON((483722 4197096,483737 4197096,483737 4197106,483722 4197106,483722 4197096)) | | 108718 | POLYGON((483722 4197086,483737 4197086,483737 4197096,483722 4197096,483722 4197086)) | | 107772 | POLYGON((483707 4197116,483722 4197116,483722 4197126,483707 4197126,483707 4197116)) | | 107771 | POLYGON((483707 4197106,483722 4197106,483722 4197116,483707 4197116,483707 4197106)) | | 107770 | POLYGON((483707 4197096,483722 4197096,483722 4197106,483707 4197106,483707 4197096)) | | 107769 | POLYGON((483707 4197086,483722 4197086,483722 4197096,483707 4197096,483707 4197086)) | +--------+---------------------------------------------------------------------------------------+ 12 rows in set, 1 warning (0.01 sec) mysql> SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483855.08503908495 4197249.556176818, 483855.08503908495 4197298.008266755, 483888.94940301933 4197298.008266755, 483888.94940301933 4197249.556176818, 483855.08503908495 4197249.556176818))', 2100))); +--------+---------------------------------------------------------------------------------------+ | FID | the_geom | +--------+---------------------------------------------------------------------------------------+ | 119462 | POLYGON((483887 4197296,483902 4197296,483902 4197306,483887 4197306,483887 4197296)) | | 119461 | POLYGON((483887 4197286,483902 4197286,483902 4197296,483887 4197296,483887 4197286)) | | 119460 | POLYGON((483887 4197276,483902 4197276,483902 4197286,483887 4197286,483887 4197276)) | | 119459 | POLYGON((483887 4197266,483902 4197266,483902 4197276,483887 4197276,483887 4197266)) | | 119458 | POLYGON((483887 4197256,483902 4197256,483902 4197266,483887 4197266,483887 4197256)) | | 119457 | POLYGON((483887 4197246,483902 4197246,483902 4197256,483887 4197256,483887 4197246)) | | 118451 | POLYGON((483872 4197296,483887 4197296,483887 4197306,483872 4197306,483872 4197296)) | | 118450 | POLYGON((483872 4197286,483887 4197286,483887 4197296,483872 4197296,483872 4197286)) | | 118449 | POLYGON((483872 4197276,483887 4197276,483887 4197286,483872 4197286,483872 4197276)) | | 118448 | POLYGON((483872 4197266,483887 4197266,483887 4197276,483872 4197276,483872 4197266)) | | 118447 | POLYGON((483872 4197256,483887 4197256,483887 4197266,483872 4197266,483872 4197256)) | | 118446 | POLYGON((483872 4197246,483887 4197246,483887 4197256,483872 4197256,483872 4197246)) | | 117450 | POLYGON((483857 4197296,483872 4197296,483872 4197306,483857 4197306,483857 4197296)) | | 117449 | POLYGON((483857 4197286,483872 4197286,483872 4197296,483857 4197296,483857 4197286)) | | 117448 | POLYGON((483857 4197276,483872 4197276,483872 4197286,483857 4197286,483857 4197276)) | | 117447 | POLYGON((483857 4197266,483872 4197266,483872 4197276,483857 4197276,483857 4197266)) | | 117446 | POLYGON((483857 4197256,483872 4197256,483872 4197266,483857 4197266,483857 4197256)) | | 117445 | POLYGON((483857 4197246,483872 4197246,483872 4197256,483857 4197256,483857 4197246)) | | 116459 | POLYGON((483842 4197296,483857 4197296,483857 4197306,483842 4197306,483842 4197296)) | | 116458 | POLYGON((483842 4197286,483857 4197286,483857 4197296,483842 4197296,483842 4197286)) | | 116457 | POLYGON((483842 4197276,483857 4197276,483857 4197286,483842 4197286,483842 4197276)) | | 116456 | POLYGON((483842 4197266,483857 4197266,483857 4197276,483842 4197276,483842 4197266)) | | 116455 | POLYGON((483842 4197256,483857 4197256,483857 4197266,483842 4197266,483842 4197256)) | | 116454 | POLYGON((483842 4197246,483857 4197246,483857 4197256,483842 4197256,483842 4197246)) | +--------+---------------------------------------------------------------------------------------+ 24 rows in set, 1 warning (0.01 sec) mysql> SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483866.0258335868 4197122.955554726, 483866.0258335868 4197194.331214095, 483909.26802137995 4197194.331214095, 483909.26802137995 4197122.955554726, 483866.0258335868 4197122.955554726))', 2100))); +--------+---------------------------------------------------------------------------------------+ | FID | the_geom | +--------+---------------------------------------------------------------------------------------+ | 120465 | POLYGON((483902 4197186,483917 4197186,483917 4197196,483902 4197196,483902 4197186)) | | 120464 | POLYGON((483902 4197176,483917 4197176,483917 4197186,483902 4197186,483902 4197176)) | | 120463 | POLYGON((483902 4197166,483917 4197166,483917 4197176,483902 4197176,483902 4197166)) | | 120462 | POLYGON((483902 4197156,483917 4197156,483917 4197166,483902 4197166,483902 4197156)) | | 120461 | POLYGON((483902 4197146,483917 4197146,483917 4197156,483902 4197156,483902 4197146)) | | 120460 | POLYGON((483902 4197136,483917 4197136,483917 4197146,483902 4197146,483902 4197136)) | | 120459 | POLYGON((483902 4197126,483917 4197126,483917 4197136,483902 4197136,483902 4197126)) | | 120458 | POLYGON((483902 4197116,483917 4197116,483917 4197126,483902 4197126,483902 4197116)) | | 119451 | POLYGON((483887 4197186,483902 4197186,483902 4197196,483887 4197196,483887 4197186)) | | 119450 | POLYGON((483887 4197176,483902 4197176,483902 4197186,483887 4197186,483887 4197176)) | | 119449 | POLYGON((483887 4197166,483902 4197166,483902 4197176,483887 4197176,483887 4197166)) | | 119448 | POLYGON((483887 4197156,483902 4197156,483902 4197166,483887 4197166,483887 4197156)) | | 119447 | POLYGON((483887 4197146,483902 4197146,483902 4197156,483887 4197156,483887 4197146)) | | 119446 | POLYGON((483887 4197136,483902 4197136,483902 4197146,483887 4197146,483887 4197136)) | | 119445 | POLYGON((483887 4197126,483902 4197126,483902 4197136,483887 4197136,483887 4197126)) | | 119444 | POLYGON((483887 4197116,483902 4197116,483902 4197126,483887 4197126,483887 4197116)) | | 118440 | POLYGON((483872 4197186,483887 4197186,483887 4197196,483872 4197196,483872 4197186)) | | 118439 | POLYGON((483872 4197176,483887 4197176,483887 4197186,483872 4197186,483872 4197176)) | | 118438 | POLYGON((483872 4197166,483887 4197166,483887 4197176,483872 4197176,483872 4197166)) | | 118437 | POLYGON((483872 4197156,483887 4197156,483887 4197166,483872 4197166,483872 4197156)) | | 118436 | POLYGON((483872 4197146,483887 4197146,483887 4197156,483872 4197156,483872 4197146)) | | 118435 | POLYGON((483872 4197136,483887 4197136,483887 4197146,483872 4197146,483872 4197136)) | | 118434 | POLYGON((483872 4197126,483887 4197126,483887 4197136,483872 4197136,483872 4197126)) | | 118433 | POLYGON((483872 4197116,483887 4197116,483887 4197126,483872 4197126,483872 4197116)) | | 117439 | POLYGON((483857 4197186,483872 4197186,483872 4197196,483857 4197196,483857 4197186)) | | 117438 | POLYGON((483857 4197176,483872 4197176,483872 4197186,483857 4197186,483857 4197176)) | | 117437 | POLYGON((483857 4197166,483872 4197166,483872 4197176,483857 4197176,483857 4197166)) | | 117436 | POLYGON((483857 4197156,483872 4197156,483872 4197166,483857 4197166,483857 4197156)) | | 117435 | POLYGON((483857 4197146,483872 4197146,483872 4197156,483857 4197156,483857 4197146)) | | 117434 | POLYGON((483857 4197136,483872 4197136,483872 4197146,483857 4197146,483857 4197136)) | | 117433 | POLYGON((483857 4197126,483872 4197126,483872 4197136,483857 4197136,483857 4197126)) | | 117432 | POLYGON((483857 4197116,483872 4197116,483872 4197126,483857 4197126,483857 4197116)) | +--------+---------------------------------------------------------------------------------------+ 32 rows in set, 1 warning (0.01 sec) mysql> SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483866.0258335868 4197122.955554726, 483866.0258335868 4197194.331214095, 483909.26802137995 4197194.331214095, 483909.26802137995 4197122.955554726, 483866.0258335868 4197122.955554726))', 2100))); +--------+---------------------------------------------------------------------------------------+ | FID | the_geom | +--------+---------------------------------------------------------------------------------------+ | 120465 | POLYGON((483902 4197186,483917 4197186,483917 4197196,483902 4197196,483902 4197186)) | | 120464 | POLYGON((483902 4197176,483917 4197176,483917 4197186,483902 4197186,483902 4197176)) | | 120463 | POLYGON((483902 4197166,483917 4197166,483917 4197176,483902 4197176,483902 4197166)) | | 120462 | POLYGON((483902 4197156,483917 4197156,483917 4197166,483902 4197166,483902 4197156)) | | 120461 | POLYGON((483902 4197146,483917 4197146,483917 4197156,483902 4197156,483902 4197146)) | | 120460 | POLYGON((483902 4197136,483917 4197136,483917 4197146,483902 4197146,483902 4197136)) | | 120459 | POLYGON((483902 4197126,483917 4197126,483917 4197136,483902 4197136,483902 4197126)) | | 120458 | POLYGON((483902 4197116,483917 4197116,483917 4197126,483902 4197126,483902 4197116)) | | 119451 | POLYGON((483887 4197186,483902 4197186,483902 4197196,483887 4197196,483887 4197186)) | | 119450 | POLYGON((483887 4197176,483902 4197176,483902 4197186,483887 4197186,483887 4197176)) | | 119449 | POLYGON((483887 4197166,483902 4197166,483902 4197176,483887 4197176,483887 4197166)) | | 119448 | POLYGON((483887 4197156,483902 4197156,483902 4197166,483887 4197166,483887 4197156)) | | 119447 | POLYGON((483887 4197146,483902 4197146,483902 4197156,483887 4197156,483887 4197146)) | | 119446 | POLYGON((483887 4197136,483902 4197136,483902 4197146,483887 4197146,483887 4197136)) | | 119445 | POLYGON((483887 4197126,483902 4197126,483902 4197136,483887 4197136,483887 4197126)) | | 119444 | POLYGON((483887 4197116,483902 4197116,483902 4197126,483887 4197126,483887 4197116)) | | 118440 | POLYGON((483872 4197186,483887 4197186,483887 4197196,483872 4197196,483872 4197186)) | | 118439 | POLYGON((483872 4197176,483887 4197176,483887 4197186,483872 4197186,483872 4197176)) | | 118438 | POLYGON((483872 4197166,483887 4197166,483887 4197176,483872 4197176,483872 4197166)) | | 118437 | POLYGON((483872 4197156,483887 4197156,483887 4197166,483872 4197166,483872 4197156)) | | 118436 | POLYGON((483872 4197146,483887 4197146,483887 4197156,483872 4197156,483872 4197146)) | | 118435 | POLYGON((483872 4197136,483887 4197136,483887 4197146,483872 4197146,483872 4197136)) | | 118434 | POLYGON((483872 4197126,483887 4197126,483887 4197136,483872 4197136,483872 4197126)) | | 118433 | POLYGON((483872 4197116,483887 4197116,483887 4197126,483872 4197126,483872 4197116)) | | 117439 | POLYGON((483857 4197186,483872 4197186,483872 4197196,483857 4197196,483857 4197186)) | | 117438 | POLYGON((483857 4197176,483872 4197176,483872 4197186,483857 4197186,483857 4197176)) | | 117437 | POLYGON((483857 4197166,483872 4197166,483872 4197176,483857 4197176,483857 4197166)) | | 117436 | POLYGON((483857 4197156,483872 4197156,483872 4197166,483857 4197166,483857 4197156)) | | 117435 | POLYGON((483857 4197146,483872 4197146,483872 4197156,483857 4197156,483857 4197146)) | | 117434 | POLYGON((483857 4197136,483872 4197136,483872 4197146,483857 4197146,483857 4197136)) | | 117433 | POLYGON((483857 4197126,483872 4197126,483872 4197136,483857 4197136,483857 4197126)) | | 117432 | POLYGON((483857 4197116,483872 4197116,483872 4197126,483857 4197126,483857 4197116)) | +--------+---------------------------------------------------------------------------------------+ 32 rows in set, 1 warning (0.01 sec) mysql> SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483711.8127301318 4197090.13317122, 483711.8127301318 4197125.039515583, 483740.4671919224 4197125.039515583, 483740.4671919224 4197090.13317122, 483711.8127301318 4197090.13317122))', 2100)) OR (ST_Intersects(the_geom, GeomFromText('POLYGON ((483855.08503908495 4197249.556176818, 483855.08503908495 4197298.008266755, 483888.94940301933 4197298.008266755, 483888.94940301933 4197249.556176818, 483855.08503908495 4197249.556176818))', 2100)) OR (ST_Intersects(the_geom, GeomFromText('POLYGON ((483866.0258335868 4197122.955554726, 483866.0258335868 4197194.331214095, 483909.26802137995 4197194.331214095, 483909.26802137995 4197122.955554726, 483866.0258335868 4197122.955554726))', 2100)) OR ST_Intersects(the_geom, GeomFromText('POLYGON ((483722.23253441934 4197249.035186604, 483722.23253441934 4197315.2009438295, 483771.72660478496 4197315.2009438295, 483771.72660478496 4197249.035186604, 483722.23253441934 4197249.035186604))', 2100))))); +--------+---------------------------------------------------------------------------------------+ | FID | the_geom | +--------+---------------------------------------------------------------------------------------+ | 107769 | POLYGON((483707 4197086,483722 4197086,483722 4197096,483707 4197096,483707 4197086)) | | 107770 | POLYGON((483707 4197096,483722 4197096,483722 4197106,483707 4197106,483707 4197096)) | | 107771 | POLYGON((483707 4197106,483722 4197106,483722 4197116,483707 4197116,483707 4197106)) | | 107772 | POLYGON((483707 4197116,483722 4197116,483722 4197126,483707 4197126,483707 4197116)) | | 108718 | POLYGON((483722 4197086,483737 4197086,483737 4197096,483722 4197096,483722 4197086)) | | 108719 | POLYGON((483722 4197096,483737 4197096,483737 4197106,483722 4197106,483722 4197096)) | | 108720 | POLYGON((483722 4197106,483737 4197106,483737 4197116,483722 4197116,483722 4197106)) | | 108721 | POLYGON((483722 4197116,483737 4197116,483737 4197126,483722 4197126,483722 4197116)) | | 108734 | POLYGON((483722 4197246,483737 4197246,483737 4197256,483722 4197256,483722 4197246)) | | 108735 | POLYGON((483722 4197256,483737 4197256,483737 4197266,483722 4197266,483722 4197256)) | | 108736 | POLYGON((483722 4197266,483737 4197266,483737 4197276,483722 4197276,483722 4197266)) | | 108737 | POLYGON((483722 4197276,483737 4197276,483737 4197286,483722 4197286,483722 4197276)) | | 108738 | POLYGON((483722 4197286,483737 4197286,483737 4197296,483722 4197296,483722 4197286)) | | 108739 | POLYGON((483722 4197296,483737 4197296,483737 4197306,483722 4197306,483722 4197296)) | | 108740 | POLYGON((483722 4197306,483737 4197306,483737 4197316,483722 4197316,483722 4197306)) | | 109668 | POLYGON((483737 4197086,483752 4197086,483752 4197096,483737 4197096,483737 4197086)) | | 109669 | POLYGON((483737 4197096,483752 4197096,483752 4197106,483737 4197106,483737 4197096)) | | 109670 | POLYGON((483737 4197106,483752 4197106,483752 4197116,483737 4197116,483737 4197106)) | | 109671 | POLYGON((483737 4197116,483752 4197116,483752 4197126,483737 4197126,483737 4197116)) | | 109684 | POLYGON((483737 4197246,483752 4197246,483752 4197256,483737 4197256,483737 4197246)) | | 109685 | POLYGON((483737 4197256,483752 4197256,483752 4197266,483737 4197266,483737 4197256)) | | 109686 | POLYGON((483737 4197266,483752 4197266,483752 4197276,483737 4197276,483737 4197266)) | | 109687 | POLYGON((483737 4197276,483752 4197276,483752 4197286,483737 4197286,483737 4197276)) | | 109688 | POLYGON((483737 4197286,483752 4197286,483752 4197296,483737 4197296,483737 4197286)) | | 109689 | POLYGON((483737 4197296,483752 4197296,483752 4197306,483737 4197306,483737 4197296)) | | 109690 | POLYGON((483737 4197306,483752 4197306,483752 4197316,483737 4197316,483737 4197306)) | | 110635 | POLYGON((483752 4197246,483767 4197246,483767 4197256,483752 4197256,483752 4197246)) | | 110636 | POLYGON((483752 4197256,483767 4197256,483767 4197266,483752 4197266,483752 4197256)) | | 110637 | POLYGON((483752 4197266,483767 4197266,483767 4197276,483752 4197276,483752 4197266)) | | 110638 | POLYGON((483752 4197276,483767 4197276,483767 4197286,483752 4197286,483752 4197276)) | | 110639 | POLYGON((483752 4197286,483767 4197286,483767 4197296,483752 4197296,483752 4197286)) | | 110640 | POLYGON((483752 4197296,483767 4197296,483767 4197306,483752 4197306,483752 4197296)) | | 110641 | POLYGON((483752 4197306,483767 4197306,483767 4197316,483752 4197316,483752 4197306)) | | 111595 | POLYGON((483767 4197246,483782 4197246,483782 4197256,483767 4197256,483767 4197246)) | | 111596 | POLYGON((483767 4197256,483782 4197256,483782 4197266,483767 4197266,483767 4197256)) | | 111597 | POLYGON((483767 4197266,483782 4197266,483782 4197276,483767 4197276,483767 4197266)) | | 111598 | POLYGON((483767 4197276,483782 4197276,483782 4197286,483767 4197286,483767 4197276)) | | 111599 | POLYGON((483767 4197286,483782 4197286,483782 4197296,483767 4197296,483767 4197286)) | | 111600 | POLYGON((483767 4197296,483782 4197296,483782 4197306,483767 4197306,483767 4197296)) | | 111601 | POLYGON((483767 4197306,483782 4197306,483782 4197316,483767 4197316,483767 4197306)) | | 116454 | POLYGON((483842 4197246,483857 4197246,483857 4197256,483842 4197256,483842 4197246)) | | 116455 | POLYGON((483842 4197256,483857 4197256,483857 4197266,483842 4197266,483842 4197256)) | | 116456 | POLYGON((483842 4197266,483857 4197266,483857 4197276,483842 4197276,483842 4197266)) | | 116457 | POLYGON((483842 4197276,483857 4197276,483857 4197286,483842 4197286,483842 4197276)) | | 116458 | POLYGON((483842 4197286,483857 4197286,483857 4197296,483842 4197296,483842 4197286)) | | 116459 | POLYGON((483842 4197296,483857 4197296,483857 4197306,483842 4197306,483842 4197296)) | | 117432 | POLYGON((483857 4197116,483872 4197116,483872 4197126,483857 4197126,483857 4197116)) | | 117433 | POLYGON((483857 4197126,483872 4197126,483872 4197136,483857 4197136,483857 4197126)) | | 117434 | POLYGON((483857 4197136,483872 4197136,483872 4197146,483857 4197146,483857 4197136)) | | 117435 | POLYGON((483857 4197146,483872 4197146,483872 4197156,483857 4197156,483857 4197146)) | | 117436 | POLYGON((483857 4197156,483872 4197156,483872 4197166,483857 4197166,483857 4197156)) | | 117437 | POLYGON((483857 4197166,483872 4197166,483872 4197176,483857 4197176,483857 4197166)) | | 117438 | POLYGON((483857 4197176,483872 4197176,483872 4197186,483857 4197186,483857 4197176)) | | 117439 | POLYGON((483857 4197186,483872 4197186,483872 4197196,483857 4197196,483857 4197186)) | | 117445 | POLYGON((483857 4197246,483872 4197246,483872 4197256,483857 4197256,483857 4197246)) | | 117446 | POLYGON((483857 4197256,483872 4197256,483872 4197266,483857 4197266,483857 4197256)) | | 117447 | POLYGON((483857 4197266,483872 4197266,483872 4197276,483857 4197276,483857 4197266)) | | 117448 | POLYGON((483857 4197276,483872 4197276,483872 4197286,483857 4197286,483857 4197276)) | | 117449 | POLYGON((483857 4197286,483872 4197286,483872 4197296,483857 4197296,483857 4197286)) | | 117450 | POLYGON((483857 4197296,483872 4197296,483872 4197306,483857 4197306,483857 4197296)) | | 118433 | POLYGON((483872 4197116,483887 4197116,483887 4197126,483872 4197126,483872 4197116)) | | 118434 | POLYGON((483872 4197126,483887 4197126,483887 4197136,483872 4197136,483872 4197126)) | | 118435 | POLYGON((483872 4197136,483887 4197136,483887 4197146,483872 4197146,483872 4197136)) | | 118436 | POLYGON((483872 4197146,483887 4197146,483887 4197156,483872 4197156,483872 4197146)) | | 118437 | POLYGON((483872 4197156,483887 4197156,483887 4197166,483872 4197166,483872 4197156)) | | 118438 | POLYGON((483872 4197166,483887 4197166,483887 4197176,483872 4197176,483872 4197166)) | | 118439 | POLYGON((483872 4197176,483887 4197176,483887 4197186,483872 4197186,483872 4197176)) | | 118440 | POLYGON((483872 4197186,483887 4197186,483887 4197196,483872 4197196,483872 4197186)) | | 118446 | POLYGON((483872 4197246,483887 4197246,483887 4197256,483872 4197256,483872 4197246)) | | 118447 | POLYGON((483872 4197256,483887 4197256,483887 4197266,483872 4197266,483872 4197256)) | | 118448 | POLYGON((483872 4197266,483887 4197266,483887 4197276,483872 4197276,483872 4197266)) | | 118449 | POLYGON((483872 4197276,483887 4197276,483887 4197286,483872 4197286,483872 4197276)) | | 118450 | POLYGON((483872 4197286,483887 4197286,483887 4197296,483872 4197296,483872 4197286)) | | 118451 | POLYGON((483872 4197296,483887 4197296,483887 4197306,483872 4197306,483872 4197296)) | | 119444 | POLYGON((483887 4197116,483902 4197116,483902 4197126,483887 4197126,483887 4197116)) | | 119445 | POLYGON((483887 4197126,483902 4197126,483902 4197136,483887 4197136,483887 4197126)) | | 119446 | POLYGON((483887 4197136,483902 4197136,483902 4197146,483887 4197146,483887 4197136)) | | 119447 | POLYGON((483887 4197146,483902 4197146,483902 4197156,483887 4197156,483887 4197146)) | | 119448 | POLYGON((483887 4197156,483902 4197156,483902 4197166,483887 4197166,483887 4197156)) | | 119449 | POLYGON((483887 4197166,483902 4197166,483902 4197176,483887 4197176,483887 4197166)) | | 119450 | POLYGON((483887 4197176,483902 4197176,483902 4197186,483887 4197186,483887 4197176)) | | 119451 | POLYGON((483887 4197186,483902 4197186,483902 4197196,483887 4197196,483887 4197186)) | | 119457 | POLYGON((483887 4197246,483902 4197246,483902 4197256,483887 4197256,483887 4197246)) | | 119458 | POLYGON((483887 4197256,483902 4197256,483902 4197266,483887 4197266,483887 4197256)) | | 119459 | POLYGON((483887 4197266,483902 4197266,483902 4197276,483887 4197276,483887 4197266)) | | 119460 | POLYGON((483887 4197276,483902 4197276,483902 4197286,483887 4197286,483887 4197276)) | | 119461 | POLYGON((483887 4197286,483902 4197286,483902 4197296,483887 4197296,483887 4197286)) | | 119462 | POLYGON((483887 4197296,483902 4197296,483902 4197306,483887 4197306,483887 4197296)) | | 120458 | POLYGON((483902 4197116,483917 4197116,483917 4197126,483902 4197126,483902 4197116)) | | 120459 | POLYGON((483902 4197126,483917 4197126,483917 4197136,483902 4197136,483902 4197126)) | | 120460 | POLYGON((483902 4197136,483917 4197136,483917 4197146,483902 4197146,483902 4197136)) | | 120461 | POLYGON((483902 4197146,483917 4197146,483917 4197156,483902 4197156,483902 4197146)) | | 120462 | POLYGON((483902 4197156,483917 4197156,483917 4197166,483902 4197166,483902 4197156)) | | 120463 | POLYGON((483902 4197166,483917 4197166,483917 4197176,483902 4197176,483902 4197166)) | | 120464 | POLYGON((483902 4197176,483917 4197176,483917 4197186,483902 4197186,483902 4197176)) | | 120465 | POLYGON((483902 4197186,483917 4197186,483917 4197196,483902 4197196,483902 4197186)) | +--------+---------------------------------------------------------------------------------------+ 96 rows in set, 4 warnings (2 min 13.83 sec) mysql> (SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483711.8127301318 4197090.13317122, 483711.8127301318 4197125.039515583, 483740.4671919224 4197125.039515583, 483740.4671919224 4197090.13317122, 483711.8127301318 4197090.13317122))', 2100)))) UNION ALL (SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483855.08503908495 4197249.556176818, 483855.08503908495 4197298.008266755, 483888.94940301933 4197298.008266755, 483888.94940301933 4197249.556176818, 483855.08503908495 4197249.556176818))', 2100)))) UNION ALL (SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483866.0258335868 4197122.955554726, 483866.0258335868 4197194.331214095, 483909.26802137995 4197194.331214095, 483909.26802137995 4197122.955554726, 483866.0258335868 4197122.955554726))', 2100)))) UNION ALL (SELECT FID, ST_AsText(the_geom) as the_geom FROM `test_spatial`.`test_grid` WHERE (ST_Intersects(the_geom, GeomFromText('POLYGON ((483722.23253441934 4197249.035186604, 483722.23253441934 4197315.2009438295, 483771.72660478496 4197315.2009438295, 483771.72660478496 4197249.035186604, 483722.23253441934 4197249.035186604))', 2100)))); +--------+---------------------------------------------------------------------------------------+ | FID | the_geom | +--------+---------------------------------------------------------------------------------------+ | 109671 | POLYGON((483737 4197116,483752 4197116,483752 4197126,483737 4197126,483737 4197116)) | | 109670 | POLYGON((483737 4197106,483752 4197106,483752 4197116,483737 4197116,483737 4197106)) | | 109669 | POLYGON((483737 4197096,483752 4197096,483752 4197106,483737 4197106,483737 4197096)) | | 109668 | POLYGON((483737 4197086,483752 4197086,483752 4197096,483737 4197096,483737 4197086)) | | 108721 | POLYGON((483722 4197116,483737 4197116,483737 4197126,483722 4197126,483722 4197116)) | | 108720 | POLYGON((483722 4197106,483737 4197106,483737 4197116,483722 4197116,483722 4197106)) | | 108719 | POLYGON((483722 4197096,483737 4197096,483737 4197106,483722 4197106,483722 4197096)) | | 108718 | POLYGON((483722 4197086,483737 4197086,483737 4197096,483722 4197096,483722 4197086)) | | 107772 | POLYGON((483707 4197116,483722 4197116,483722 4197126,483707 4197126,483707 4197116)) | | 107771 | POLYGON((483707 4197106,483722 4197106,483722 4197116,483707 4197116,483707 4197106)) | | 107770 | POLYGON((483707 4197096,483722 4197096,483722 4197106,483707 4197106,483707 4197096)) | | 107769 | POLYGON((483707 4197086,483722 4197086,483722 4197096,483707 4197096,483707 4197086)) | | 119462 | POLYGON((483887 4197296,483902 4197296,483902 4197306,483887 4197306,483887 4197296)) | | 119461 | POLYGON((483887 4197286,483902 4197286,483902 4197296,483887 4197296,483887 4197286)) | | 119460 | POLYGON((483887 4197276,483902 4197276,483902 4197286,483887 4197286,483887 4197276)) | | 119459 | POLYGON((483887 4197266,483902 4197266,483902 4197276,483887 4197276,483887 4197266)) | | 119458 | POLYGON((483887 4197256,483902 4197256,483902 4197266,483887 4197266,483887 4197256)) | | 119457 | POLYGON((483887 4197246,483902 4197246,483902 4197256,483887 4197256,483887 4197246)) | | 118451 | POLYGON((483872 4197296,483887 4197296,483887 4197306,483872 4197306,483872 4197296)) | | 118450 | POLYGON((483872 4197286,483887 4197286,483887 4197296,483872 4197296,483872 4197286)) | | 118449 | POLYGON((483872 4197276,483887 4197276,483887 4197286,483872 4197286,483872 4197276)) | | 118448 | POLYGON((483872 4197266,483887 4197266,483887 4197276,483872 4197276,483872 4197266)) | | 118447 | POLYGON((483872 4197256,483887 4197256,483887 4197266,483872 4197266,483872 4197256)) | | 118446 | POLYGON((483872 4197246,483887 4197246,483887 4197256,483872 4197256,483872 4197246)) | | 117450 | POLYGON((483857 4197296,483872 4197296,483872 4197306,483857 4197306,483857 4197296)) | | 117449 | POLYGON((483857 4197286,483872 4197286,483872 4197296,483857 4197296,483857 4197286)) | | 117448 | POLYGON((483857 4197276,483872 4197276,483872 4197286,483857 4197286,483857 4197276)) | | 117447 | POLYGON((483857 4197266,483872 4197266,483872 4197276,483857 4197276,483857 4197266)) | | 117446 | POLYGON((483857 4197256,483872 4197256,483872 4197266,483857 4197266,483857 4197256)) | | 117445 | POLYGON((483857 4197246,483872 4197246,483872 4197256,483857 4197256,483857 4197246)) | | 116459 | POLYGON((483842 4197296,483857 4197296,483857 4197306,483842 4197306,483842 4197296)) | | 116458 | POLYGON((483842 4197286,483857 4197286,483857 4197296,483842 4197296,483842 4197286)) | | 116457 | POLYGON((483842 4197276,483857 4197276,483857 4197286,483842 4197286,483842 4197276)) | | 116456 | POLYGON((483842 4197266,483857 4197266,483857 4197276,483842 4197276,483842 4197266)) | | 116455 | POLYGON((483842 4197256,483857 4197256,483857 4197266,483842 4197266,483842 4197256)) | | 116454 | POLYGON((483842 4197246,483857 4197246,483857 4197256,483842 4197256,483842 4197246)) | | 120465 | POLYGON((483902 4197186,483917 4197186,483917 4197196,483902 4197196,483902 4197186)) | | 120464 | POLYGON((483902 4197176,483917 4197176,483917 4197186,483902 4197186,483902 4197176)) | | 120463 | POLYGON((483902 4197166,483917 4197166,483917 4197176,483902 4197176,483902 4197166)) | | 120462 | POLYGON((483902 4197156,483917 4197156,483917 4197166,483902 4197166,483902 4197156)) | | 120461 | POLYGON((483902 4197146,483917 4197146,483917 4197156,483902 4197156,483902 4197146)) | | 120460 | POLYGON((483902 4197136,483917 4197136,483917 4197146,483902 4197146,483902 4197136)) | | 120459 | POLYGON((483902 4197126,483917 4197126,483917 4197136,483902 4197136,483902 4197126)) | | 120458 | POLYGON((483902 4197116,483917 4197116,483917 4197126,483902 4197126,483902 4197116)) | | 119451 | POLYGON((483887 4197186,483902 4197186,483902 4197196,483887 4197196,483887 4197186)) | | 119450 | POLYGON((483887 4197176,483902 4197176,483902 4197186,483887 4197186,483887 4197176)) | | 119449 | POLYGON((483887 4197166,483902 4197166,483902 4197176,483887 4197176,483887 4197166)) | | 119448 | POLYGON((483887 4197156,483902 4197156,483902 4197166,483887 4197166,483887 4197156)) | | 119447 | POLYGON((483887 4197146,483902 4197146,483902 4197156,483887 4197156,483887 4197146)) | | 119446 | POLYGON((483887 4197136,483902 4197136,483902 4197146,483887 4197146,483887 4197136)) | | 119445 | POLYGON((483887 4197126,483902 4197126,483902 4197136,483887 4197136,483887 4197126)) | | 119444 | POLYGON((483887 4197116,483902 4197116,483902 4197126,483887 4197126,483887 4197116)) | | 118440 | POLYGON((483872 4197186,483887 4197186,483887 4197196,483872 4197196,483872 4197186)) | | 118439 | POLYGON((483872 4197176,483887 4197176,483887 4197186,483872 4197186,483872 4197176)) | | 118438 | POLYGON((483872 4197166,483887 4197166,483887 4197176,483872 4197176,483872 4197166)) | | 118437 | POLYGON((483872 4197156,483887 4197156,483887 4197166,483872 4197166,483872 4197156)) | | 118436 | POLYGON((483872 4197146,483887 4197146,483887 4197156,483872 4197156,483872 4197146)) | | 118435 | POLYGON((483872 4197136,483887 4197136,483887 4197146,483872 4197146,483872 4197136)) | | 118434 | POLYGON((483872 4197126,483887 4197126,483887 4197136,483872 4197136,483872 4197126)) | | 118433 | POLYGON((483872 4197116,483887 4197116,483887 4197126,483872 4197126,483872 4197116)) | | 117439 | POLYGON((483857 4197186,483872 4197186,483872 4197196,483857 4197196,483857 4197186)) | | 117438 | POLYGON((483857 4197176,483872 4197176,483872 4197186,483857 4197186,483857 4197176)) | | 117437 | POLYGON((483857 4197166,483872 4197166,483872 4197176,483857 4197176,483857 4197166)) | | 117436 | POLYGON((483857 4197156,483872 4197156,483872 4197166,483857 4197166,483857 4197156)) | | 117435 | POLYGON((483857 4197146,483872 4197146,483872 4197156,483857 4197156,483857 4197146)) | | 117434 | POLYGON((483857 4197136,483872 4197136,483872 4197146,483857 4197146,483857 4197136)) | | 117433 | POLYGON((483857 4197126,483872 4197126,483872 4197136,483857 4197136,483857 4197126)) | | 117432 | POLYGON((483857 4197116,483872 4197116,483872 4197126,483857 4197126,483857 4197116)) | | 111601 | POLYGON((483767 4197306,483782 4197306,483782 4197316,483767 4197316,483767 4197306)) | | 111600 | POLYGON((483767 4197296,483782 4197296,483782 4197306,483767 4197306,483767 4197296)) | | 111599 | POLYGON((483767 4197286,483782 4197286,483782 4197296,483767 4197296,483767 4197286)) | | 111598 | POLYGON((483767 4197276,483782 4197276,483782 4197286,483767 4197286,483767 4197276)) | | 111597 | POLYGON((483767 4197266,483782 4197266,483782 4197276,483767 4197276,483767 4197266)) | | 111596 | POLYGON((483767 4197256,483782 4197256,483782 4197266,483767 4197266,483767 4197256)) | | 111595 | POLYGON((483767 4197246,483782 4197246,483782 4197256,483767 4197256,483767 4197246)) | | 110641 | POLYGON((483752 4197306,483767 4197306,483767 4197316,483752 4197316,483752 4197306)) | | 110640 | POLYGON((483752 4197296,483767 4197296,483767 4197306,483752 4197306,483752 4197296)) | | 110639 | POLYGON((483752 4197286,483767 4197286,483767 4197296,483752 4197296,483752 4197286)) | | 110638 | POLYGON((483752 4197276,483767 4197276,483767 4197286,483752 4197286,483752 4197276)) | | 110637 | POLYGON((483752 4197266,483767 4197266,483767 4197276,483752 4197276,483752 4197266)) | | 110636 | POLYGON((483752 4197256,483767 4197256,483767 4197266,483752 4197266,483752 4197256)) | | 110635 | POLYGON((483752 4197246,483767 4197246,483767 4197256,483752 4197256,483752 4197246)) | | 109690 | POLYGON((483737 4197306,483752 4197306,483752 4197316,483737 4197316,483737 4197306)) | | 109689 | POLYGON((483737 4197296,483752 4197296,483752 4197306,483737 4197306,483737 4197296)) | | 109688 | POLYGON((483737 4197286,483752 4197286,483752 4197296,483737 4197296,483737 4197286)) | | 109687 | POLYGON((483737 4197276,483752 4197276,483752 4197286,483737 4197286,483737 4197276)) | | 109686 | POLYGON((483737 4197266,483752 4197266,483752 4197276,483737 4197276,483737 4197266)) | | 109685 | POLYGON((483737 4197256,483752 4197256,483752 4197266,483737 4197266,483737 4197256)) | | 109684 | POLYGON((483737 4197246,483752 4197246,483752 4197256,483737 4197256,483737 4197246)) | | 108740 | POLYGON((483722 4197306,483737 4197306,483737 4197316,483722 4197316,483722 4197306)) | | 108739 | POLYGON((483722 4197296,483737 4197296,483737 4197306,483722 4197306,483722 4197296)) | | 108738 | POLYGON((483722 4197286,483737 4197286,483737 4197296,483722 4197296,483722 4197286)) | | 108737 | POLYGON((483722 4197276,483737 4197276,483737 4197286,483722 4197286,483722 4197276)) | | 108736 | POLYGON((483722 4197266,483737 4197266,483737 4197276,483722 4197276,483722 4197266)) | | 108735 | POLYGON((483722 4197256,483737 4197256,483737 4197266,483722 4197266,483722 4197256)) | | 108734 | POLYGON((483722 4197246,483737 4197246,483737 4197256,483722 4197256,483722 4197246)) | +--------+---------------------------------------------------------------------------------------+ 96 rows in set, 4 warnings (0.03 sec)