Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
How about setting the TOLERANCE parameter for the layer in the mapfile?
Best regards,
Tamas
2010/2/26 Afroz K afr...@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 szeker...@gmail.comwrote:
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 afr...@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Getfeatureinfo and MSsql 2008 server
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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
The Mssql2008 driver is incomplete...
GetFeatureInfo, Nquery, Query doesnt work at all...
http://trac.osgeo.org/mapserver/ticket/3058
Paul
On Thu, Feb 25, 2010 at 7:57 AM, Afroz Kannancheri afr...@gmail.com wrote:
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-tp4631781p4631781.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
.queryByPoint works OK for me from C# mapscript
On Thu, Feb 25, 2010 at 11:51 AM, Paul james paulj...@gmail.com wrote:
The Mssql2008 driver is incomplete...
GetFeatureInfo, Nquery, Query doesnt work at all...
http://trac.osgeo.org/mapserver/ticket/3058
Paul
On Thu, Feb 25, 2010 at 7:57 AM, Afroz Kannancheri afr...@gmail.com wrote:
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-tp4631781p4631781.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Dr James Perrins
exeGesIS SDM Ltd
Great House Barn
New Street, Talgarth
Powys LD3 0AH.
Direct Line: 01646 686650
Tel: 01874 711145
Fax: 01874 711156
Email: jam...@esdm.co.uk
This E-mail and any files transmitted with it are private and intended
solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient, the E-mail and any
files have been transmitted to you in error and any copying,
distribution or other use of the information contained in them is
strictly prohibited.
Nothing in this E-mail message amounts to a contractual or other legal
commitment on the part of exeGesIS SDM Ltd unless confirmed by a
signed communication.
exeGesIS SDM Ltd will make every effort to keep its network free of
viruses. However, the recipient of this message will need to scan this
message, and any attachments, for viruses, as exeGesIS SDM Ltd can
take no responsibility for any computer virus that might be
transferred by this e-mail.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
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 afr...@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
Paul,
I don't see any compelling reason why these use cases wouldn't work. Could
you provide a sample data/mapfile/example URL to reproduce this?
Best regards,
Tamas
2010/2/25 Paul james paulj...@gmail.com
The Mssql2008 driver is incomplete...
GetFeatureInfo, Nquery, Query doesnt work at all...
http://trac.osgeo.org/mapserver/ticket/3058
Paul
On Thu, Feb 25, 2010 at 7:57 AM, Afroz Kannancheri afr...@gmail.comwrote:
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-tp4631781p4631781.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
Dear tamas,
I'll try the buffer parameter that u have mentioned once I m back in office on
sunday and update u guys about the output.
Thanks a lot guys..
Sent from my BlackBerry® smartphone from du
-Original Message-
From: Tamas Szekeres szeker...@gmail.com
Date: Thu, 25 Feb 2010 23:06:47
To: Afroz Kannancheriafr...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
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 afr...@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server
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 szeker...@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 afr...@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
