CREATE TABLE [dbo].[MetesAndBoundsHeader](
[PKey] [int] IDENTITY(1,1) NOT NULL,
[SpatialDataKey] [int] NULL,
[StartX] [decimal](18, 4) NULL,
[StartY] [decimal](18, 4) NULL,
[Feature] [geometry] NULL,
CONSTRAINT [PK_MetesAndBoundsDescription] PRIMARY KEY CLUSTERED
(
[PKey] 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
SET IDENTITY_INSERT [dbo].[MetesAndBoundsHeader] ON
INSERT [dbo].[MetesAndBoundsHeader] ([PKey], [SpatialDataKey], [StartX],
[StartY], [Feature]) VALUES (8, 7, CAST(463644.9082 AS Decimal(18, 4)),
CAST(1484517.3764 AS Decimal(18, 4)),
0xE60E00000104050000009A999999734C1C4100000000E5A636419A999999734C1C41000000
00F5CD36419A99999939B01B4100000000A4CE36419A99999939B01B410000000094A736419A
999999734C1C4100000000E5A6364101000000020000000001000000FFFFFFFF0000000003)
INSERT [dbo].[MetesAndBoundsHeader] ([PKey], [SpatialDataKey], [StartX],
[StartY], [Feature]) VALUES (9, 8, CAST(416571.3699 AS Decimal(18, 4)),
CAST(1465354.3699 AS Decimal(18, 4)),
0xE60E00000104050000009A999999ED6C1941000000000A5C36419A999999ED6C1941000000
001A8336419A999999B3D0184100000000C98336419A999999B3D0184100000000B95C36419A
999999ED6C1941000000000A5C364101000000020000000001000000FFFFFFFF0000000003)
SET IDENTITY_INSERT [dbo].[MetesAndBoundsHeader] OFF
David Lowther
Coordinate Solutions, Inc.
_____
From: Tamas Szekeres [mailto:szeker...@gmail.com]
Sent: Monday, September 20, 2010 4:56 PM
To: David Lowther
Cc: gdal-dev
Subject: Re: [gdal-dev] OGR MS SQL Spatial driver has been added
2010/9/20 David Lowther <dlowt...@coordinatesolutions.com>
It seems almost as if there is an index off in the field information.
David,
That's strange indeed. What is the database type of this field in the table?
Could you provide your test data to reproduce this?
I am also not seeing any features when I render the layer in Mapserver
(though that could be any number of things as I am just getting started with
OGR MSSQL in Mapserver).
It would be helpful to see your mapfile to make sure about the problem.
Best regards,
Tamas
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
