« Return to Thread: How to identify start node and end node in shortest_path_astar when the user click 2 points on the map?

Re: GeomUnion returns a Null geometry

by Bingo :: Rate this Message:

Reply to Author | View in Thread

Markus Schaber wrote:

> HI, Arnaud,
>
> Arnaud Lesauvage wrote:
>
>> I join to this message a csv of the problematic dataset.
>
>> gid;geom
>> 100013;MULTIPOLYGON((([...])))
>> ;
>> ;
>> ;
>> ;
>
> Sounds like only the first of your five polygons was output.
>
> Could the others be null?
>
> Could you give us the results of
>
>   SELECT gid;geom is null;isvalid(geom) FROM yourtable;
>


Hi Markus,
I slept on this and rewrote my queries from scratch. They now work
fine !
I believe that I had some null geometries in the union before and
not anymore.
Does a geomunion return null whenever one of the geometries is null ?

Thanks a lot for suggestiong this !

Arnaud
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

 « Return to Thread: How to identify start node and end node in shortest_path_astar when the user click 2 points on the map?