Skip to content

Instantly share code, notes, and snippets.

@MattMS

MattMS/sql_server_geoserver.sql

Created June 23, 2015 08:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MattMS/7fd44112023701757138 to your computer and use it in GitHub Desktop.
Save MattMS/7fd44112023701757138 to your computer and use it in GitHub Desktop.
Download ZIP
Create SQL Server geometry table for GeoServer.
Raw
sql_server_geoserver.sql
CREATE TABLE GEOMETRY_COLUMNS(
F_TABLE_SCHEMA VARCHAR(30) NOT NULL,
F_TABLE_NAME VARCHAR(30) NOT NULL,
F_GEOMETRY_COLUMN VARCHAR(30) NOT NULL,
COORD_DIMENSION INTEGER,
SRID INTEGER NOT NULL,
TYPE VARCHAR(30) NOT NULL,
UNIQUE(F_TABLE_SCHEMA, F_TABLE_NAME, F_GEOMETRY_COLUMN),
CHECK(
TYPE IN ('POINT','LINE', 'POLYGON', 'COLLECTION', 'MULTIPOINT', 'MULTILINE', 'MULTIPOLYGON', 'GEOMETRY')
)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment