Invalid number of points in LineString (found 1 - must be 0 or >= 2)

[Eija]

Hi,

When I try to check a layer in map preview I get this error in a lot of tiles in some layers. Does it mean that some points have been erroneously defined as lines in the database? And if so, is there some trick to get past it or do we have to go thruogh the whole databse and search for those onepoint LineStrings?

code="Internal error"org.vfny.geoserver.wms.WmsException: Rendering process failed
Rendering process failed
Error rendering feature
Invalid number of points in LineString (found 1 - must be 0 or >= 2)

Eija

[Ignacio Talavera]

hi Eija, I't seems that you have wrong geometry in your data, to solve this you could identify those rows to correct the geom or
create a view in your DB that filter it.

If you're using Postgis function npoints could help you.
Whether correct or to filter out.

For example If you want to filter the condition would be

Select table where
npoints(the_geom)>=2

regards
Nacho

On Wed, Nov 4, 2009 at 12:32 PM, Eija <eija@...> wrote:

Hi,

When I try to check a layer in map preview I get this error in a lot of
tiles in some layers. Does it mean that some points have been erroneously
defined as lines in the database? And if so, is there some trick to get past
it or do we have to go thruogh the whole databse and search for those
onepoint LineStrings?

code="Internal error"org.vfny.geoserver.wms.WmsException: Rendering process
failed
Rendering process failed
Error rendering feature
Invalid number of points in LineString (found 1 - must be 0 or >= 2)

Eija
--
View this message in context: http://old.nabble.com/Invalid-number-of-points-in-LineString-%28found-1---must-be-0-or-%3E%3D-2%29-tp26197307p26197307.html
Sent from the GeoServer - User mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Eija]

Hi Ignacio,

sorry, we use Oracle and its locator feature. I don't really have much rights in the database so I'll have to check if the data can be corrected or if we need to use a view.

If it will be done with a view, how will it be with the metadata and spatial index? Are they accessed as if we were using the original tables or do I need to do something for it to work?

Eija

Ignacio Talavera wrote:

hi Eija, I't seems that you have wrong geometry in your data, to solve this
you could identify those rows to correct the geom or
create a view in your DB that filter it.

If you're using Postgis function npoints could help you.
Whether correct or to filter out.

For example If you want to filter the condition would be

Select table where
npoints(the_geom)>=2

regards
Nacho



On Wed, Nov 4, 2009 at 12:32 PM, Eija <[e-mail]> wrote:

>
> Hi,
>
> When I try to check a layer in map preview I get this error in a lot of
> tiles in some layers. Does it mean that some points have been erroneously
> defined as lines in the database? And if so, is there some trick to get
> past
> it or do we have to go thruogh the whole databse and search for those
> onepoint LineStrings?
>
> code="Internal error"org.vfny.geoserver.wms.WmsException: Rendering process
> failed
> Rendering process failed
> Error rendering feature
> Invalid number of points in LineString (found 1 - must be 0 or >= 2)
>
> Eija
> --
> View this message in context:
> http://old.nabble.com/Invalid-number-of-points-in-LineString-%28found-1---must-be-0-or-%3E%3D-2%29-tp26197307p26197307.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Geoserver-users mailing list
> [e-mail]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-users mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/geoserver-users