[mapserver-users] Getfeatureinfo and MSsql 2008 server

Tamas Szekeres szekerest at gmail.com
Fri Feb 26 05:02:37 EST 2010


How about setting the TOLERANCE parameter for the layer in the mapfile?

Best regards,

Tamas

2010/2/26 Afroz K <afrozk at gmail.com>

> Dear Tamaz,
>                 I guess this cannot be done as I am not using QuerybyPoint.
> I just use the GetfeatureInfo from my html page.
>
> Thanks
> Afroz
>
> On Fri, Feb 26, 2010 at 2:06 AM, Tamas Szekeres <szekerest at gmail.com>wrote:
>
>> Afroz,
>>
>> This error message says you must specify a search shape with area > 0
>> during the query. Assuming you use a queryByPoint operation, either the
>> buffer parameter of the tolerance of the layer should be specified as a
>> positive number.
>>
>> Best regards,
>>
>> Tamas
>>
>>
>>
>> 2010/2/25 Afroz Kannancheri <afrozk at gmail.com>
>>
>>
>>> Hi All,
>>>
>>> I have a layer drawn from the shape information stored in MSSQL 2008
>>> server.
>>> The layer has around 300 polygons which are drawn perfectly on a world
>>> base
>>> map.
>>> When i try to get the details for each polygon using the Getfeatureinfo
>>> during the click event, i get the following error from MSSQL 2008 server.
>>>
>>> msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL
>>> statement: SELECT convert(varchar(max), numb1),convert(varchar(max),
>>> poprate),geom.STAsBinary(),convert(varchar(20), ID) from table1 WHERE
>>> geom.STIntersects(Geometry::STGeomFromText('POLYGON((-16.4101563310658
>>> 17.724609875,-16.4101563310658 17.724609875,-16.4101563310658
>>> 17.724609875,-16.4101563310658 17.724609875,-16.4101563310658
>>> 17.724609875))',0)) = 1 -[Microsoft][ODBC SQL Server Driver][SQL Server]A
>>> .NET Framework error occurred during execution of user defined routine or
>>> aggregate 'geometry': System.FormatException: 24118: The Polygon input is
>>> not valid because the exterior ring does not have enough points. Each
>>> ring
>>> of a polygon must contain at least three distinct points.
>>> System.FormatException: at
>>> Microsoft.SqlServer.Types.GeometryDataBuilder.EndFigure() at
>>>
>>> Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText(FigureAttributes
>>> attributes) at
>>> Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText()
>>> at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonTaggedText() at
>>> Microsoft.SqlServer.Types.OpenGisWktReader.ParseGeometryTaggedText() at
>>> Microsoft.SqlServer.Types.OpenGisWktReader.ReadGeometry() at
>>> Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars
>>> geometryTaggedText, Int32 srid)
>>>
>>>
>>> Has anyone faced such an issue before.
>>>
>>>
>>> Thanks and regards
>>> AFroz Kannancheri
>>> --
>>> View this message in context:
>>> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631717p4631717.html
>>> Sent from the Mapserver - User mailing list archive at Nabble.com.
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100226/a55ddb24/attachment-0001.html


More information about the mapserver-users mailing list