Advertising
advertising
related pastes to tag 'spatial'
- 1717481 - points for sql server 2008: sql server 2008 points spatial
-
- -- drop table points;
- CREATE TABLE points (id integer PRIMARY KEY, geom geometry);
- INSERT INTO points (id, geom) VALUES (1, geometry::Parse('POINT(154597 159517)'));
- INSERT INTO points (id, geom) VALUES (2, geometry::Parse('POINT(159929 157759)'));
- INSERT INTO points (id, geom) VALUES (3, geometry::Parse('POINT(157482 164124)'));
- 1717471 - polygon for sql server import: sql server 2008 spatial polygon
-
- -- drop table poly;
- CREATE TABLE poly (id integer PRIMARY KEY, geom geometry);
- INSERT INTO poly (id, geom) VALUES (1, geometry::Parse('
- MULTIPOLYGON (((
- 0 228366,
- 746 227274,