From: Frank Warmerdam Date: Sun, 03 Nov 2002 10:07:11 -0500 Subject: [postgis-users] (no subject) References: Message-ID: <3DC53B9F.1060907@pobox.com> Geoff Anderson wrote: > Hi, > > I am eagerly awaiting the addition of topological operators to > PostGIS. In the mean time for fun I'm hacking together a GML centric > vector overlay thing built around PostGIS, Java2D and a lot of PHP. > Clearly there's lot's of good reasons why you can't do real spatial > processing around massive text files, but is there a particularly > good/fast PostGIS to GML writer out there? What's the best way to > bounding box intersect two tables? (select the features from table_a > that intersect the selected features of table_b...) And how soon will I > be able to construct new geometries from of-the-shelf PostGIS sql? Geoff, My ogr2ogr utility can be used to dump the results of a PostGIS query to GML. It is written in C++ and is I think at least reasonably fast. Let me know if you want more info. Best regards, -- ---------------------------------------+-------------------------------------- I set the clouds in motion - turn up | Frank Warmerdam, warmerdam at pobox.com light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush | Geospatial Programmer for Rent