Geoserver 1.7.2 and SQL (2008) data
Items installed
Geoserver 1.7.2
Microsoft SQL 2008 Express
JDBC SQL Driver
GeoServer SQL Plug in
I can create the data store and it will connect properly (As long as I do not specify a database name)
I have used the information at http://www.bostongis.com/?content_name=sql2008_tut01#181
to import some sample data (ftp://data.massgis.state.ma.us/pub/shape/state/towns.exe) using
the Shape2Sql utility.
Where can I find a reference on creating the schema tables so GeoServer will
allow me to create a new FeatureType using the data now in SQL Server? I am assuming there is a table that should
be created on the SQL server to describe the information (tables, views) available with the column mappings.
Here is the table created from the Shape2Sql utility
CREATE TABLE [dbo].[TOWNS_POLY](
[ID] [int] IDENTITY(1,1) NOT NULL,
[OBJECTID] [bigint] NULL,
[TOWNS_ID] [bigint] NULL,
[TOWN_ID] [int] NULL,
[TOWN] nvarchar NULL,
[FIPS_STCO] [bigint] NULL,
[CCD_MCD] nvarchar NULL,
[FIPS_PLACE] nvarchar NULL,
[POP1980] [bigint] NULL,
[POP1990] [bigint] NULL,
[POP2000] [bigint] NULL,
[POPCH80_90] [bigint] NULL,
[POPCH90_00] [bigint] NULL,
[FOURCOLOR] [smallint] NULL,
[TYPE] nvarchar NULL,
[ISLAND] [smallint] NULL,
[FIPS_MCD] [bigint] NULL,
[FIPS_COUNT] [int] NULL,
[SHAPE_AREA] [real] NULL,
[SHAPE_LEN] [real] NULL,
[geom] [geometry] NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
---- Msg sent via CableONE.net MyMail - http://www.cableone.net