1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| USE tempdb;
GO
CREATE TABLE T_GEO
(GEO_ID INT PRIMARY KEY,
GEO GEOMETRY);
GO
INSERT INTO T_GEO
VALUES (1, 'GEOMETRYCOLLECTION(POINT(0 0), POLYGON ((0 0, 1 1, 2 2, 3 3, 3 0, 0 0)))'),
(2, 'GEOMETRYCOLLECTION(POLYGON ((0 0, 1 1, 2 2, 3 3, 3 0, 0 0)))'),
(3, 'GEOMETRYCOLLECTION(POINT(0 0))'),
(4, 'GEOMETRYCOLLECTION(POLYGON ((0 0, 1 1, 2 2, 3 3, 3 0, 0 0)), POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0)))'),
(5, 'GEOMETRYCOLLECTION(POLYGON ((0 0, 1 1, 2 2, 3 3, 3 0, 0 0)), POLYGON ((10 10, 10 11, 11 11, 11 10, 10 10)))');
GO |
Partager