[mapserver-users] The Case of the Disappearing Roads

[Joseph Marlin]

select count(*) from wkt_link where not ST_IsValid(link);

Ran that and correctly got 0. Which sort of makes sense since they display in QGIS just fine. 

----- Original Message -----
From: "andy" <andy at squeakycode.net; >
To: "Joseph Marlin" <jmarlin at saucontech.com>
Cc: "MapserverList OSGEO" <mapserver-users at lists.osgeo.org>
Sent: Fri Aug 9 10:21:40 PDT 2013
Subject: Re: [mapserver-users] The Case of the Disappearing Roads

I've seen that problem when the data is invalid.  Try something like:

select count(*) from roads where not ST_IsValid(the_geom);

You should get zero.

-Andy