1

Topic: SingleSpecies Map not working

The maps have not been working for a couple of days now. A query like this...

https://gis.nbn.org.uk/SingleSpecies/NH … magesize=4

...returns an error containing the following exception...

msDrawMap(): Image handling error. Failed to draw layer named 'Grid-10km'.
msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL statement: SELECT [geom],convert(varchar(36), [identifier]) from (select geom.STCentroid() [geom], [dbo].[Feature].[identifier] from [dbo].[Feature] with (INDEX(sidx_Feature_geom)) join (select distinct [alias_11105611].[FEATUREID] from ((select [dbo].[MappingDataPublic].[featureID] [FEATUREID] from [dbo].[MappingDataPublic] join [dbo].[TaxonTree] on [dbo].[TaxonTree].[childPTVK] = [dbo].[MappingDataPublic].[pTaxonVersionKey] where ([dbo].[TaxonTree].[nodePTVK] = 'NHMSYS0000530681' and [dbo].[MappingDataPublic].[absence] = 0 and [dbo].[MappingDataPublic].[resolutionID] = 1)) union all (select [dbo].[MappingDataEnhanced].[featureID] from [dbo].[MappingDataEnhanced] join [dbo].[TaxonTree] on [dbo].[TaxonTree].[childPTVK] = [dbo].[MappingDataEnhanced].[pTaxonVersionKey] join [dbo].[UserTaxonObservationID] on [dbo].[UserTaxonObservationID].[observationID] = [dbo].[MappingDataEnhanced].[id] where ([dbo].[TaxonTree].[nodePTVK] = 'NHMSYS0000530681' and [dbo].[UserTaxonObservationID].[userID] = 1 and [dbo].[MappingDataEnhanced].[absence] = 0 and [dbo].[MappingDataEnhanced].[resolutionID] = 1))) [alias_11105611]) [alias_23491131] on [dbo].[Feature].[id] = [alias_23491131].[FEATUREID]) AS foo WHERE geom.STIntersects(geometry::STGeomFromText('POLYGON((-14.0555598402195 49.1178643161011,4.53864053218213 49.1178643161011,4.53864053218213 61.569739031998,-14.0555598402195 61.569739031998,-14.0555598402195 49.1178643161011))',4326)) = 1 
-[Microsoft][ODBC SQL Server Driver][SQL Server]The query processor could not produce a query plan for a query with a spatial index hint.  Reason: Could not find required binary spatial method in a condition.  Try removing the index hints or removing SET FORCEPLAN.

2

Re: SingleSpecies Map not working

Thanks for letting us know, I will look into it now

Matt Debont
Application Developer
Joint Nature Conservation Committee, Monkstone House, City Road, Peterborough PE1 1JY, UK

3

Re: SingleSpecies Map not working

The atlas grade mapping services should be up again, there was an issue with a spatial index in the database, but should be working correctly now, sorry for any issues caused.

Matt Debont
Application Developer
Joint Nature Conservation Committee, Monkstone House, City Road, Peterborough PE1 1JY, UK