[postgis-users] Error in simple SQL

George R. C. Silva georger.silva at gmail.com
Tue Apr 22 10:28:08 PDT 2008


Hello Paul,

i checked both geometries, and quadras have 4 invalid geometries. How to 
fix them? Or i can only fix them by drawing again?

Att.

George

Paul Ramsey escreveu:
> somehow you have odd geometries in your geometry columns...
>
>  select gid from quadras_poligono where not st_isvalid(the_geom);
>  select gid from bairros_poligono where not st_isvalid(the_geom);
>
> P
>
> On Tue, Apr 22, 2008 at 8:18 AM, George R. C. Silva
> <georger.silva at gmail.com> wrote:
>   
>> Hello everyone.
>>
>>  Am i doing something wrong? In pg 8.2 and pgis 1.2 this query worked...
>>
>>  select * from quadras_poligono, bairros_poligono where
>> ST_intersects(bairros_poligono.the_geom,st_centroid(quadras_poligono.the_geom))
>> and bairros_poligono.codbairro = 1;
>>
>>  now this doenst work. gives me this error. i dont know if it worked before
>> or am i confusing with something else.
>>  heres the error.
>>
>>  NOTICE:  IllegalArgumentException: Number of points must be 0 or >3
>>
>>  ERROR:  POSTGIS2GEOS conversion failed
>>
>>  what can i do for this to work?
>>  _______________________________________________
>>  postgis-users mailing list
>>  postgis-users at postgis.refractions.net
>>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>     
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   



More information about the postgis-users mailing list