[postgis-users] Postgis topology help

I'm after some pointers on how I might use topology in this case: We regularly undertake random stratified two phase trawl surveys for fisheries stock assessments. This requires the survey area to be divided into arbitrary strata, with sample sites randomly defined for each strata. Generally t

[postgis-users] Postgis geometries to KML

Hi, Does anyone know of a way to generate a KML file directly from postgis geometries? I have open street map road geometries stored in a table which I would like to dump out as a KML to visualise on Google Earth. Would love to hear if someone has already done something like this in the past. Chee

[postgis-users] PostGIS 2.0.0rc2

The second release candidate of PostGIS 2.0.0 is now available: http://postgis.org/download/postgis-2.0.0rc2.tar.gz We hope you'll test and let us know (http://trac.osgeo.org/postgis) if you find problems! Yours, The PostGIS Team ___ postgis-users m

[postgis-users] what about 3d-srids

Hey there i was wondering how 3D referencing systems will be handled in the future in PostGIS? When 3D-Datatypes, -Indexes, -Functions are introduced to the PostGIS-World why are no 3D-srids delivered in the spatial_ref_sys by default? I know that there are insert-stmts out there (spatialrefer

Re: [postgis-users] raster efficiency

Hi Pierre, Thanks for your answer. To compute profile, here is what I do: Input is a linestring Initializes raster ID to NULL I segmentize to the desired length Force 3D For all points do: Get point in 2d If point does not intersect with current raster ID: get new raster ID G