Re: [postgis-users] Anyone *using* PostGIS with Slony-I?

2009-04-28 Thread Tim Bowden
use blobs. Shouldn't have any issues with Slony-I. Regards, Tim Bowden > Regards, > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users __

Re: [postgis-users] Get concave hull from an array of longitude inlatitude points

2008-11-25 Thread Tim Bowden
On Wed, 2008-11-26 at 05:38 +0900, Tim Bowden wrote: > Thanks to crschmidt on irc for pointing me in the direction of Schuyler > Erle's work: > http://code.flickr.com/blog/tag/clustr/ > http://code.flickr.com/svn/trunk/clustr/ > > Looks promising so far. Schuyler's

RE: [postgis-users] Get concave hull from an array of longitude inlatitude points

2008-11-25 Thread Tim Bowden
On Tue, 2008-11-25 at 13:36 -0700, Rob Tester wrote: > I think you were hit by the blind stick. > > The license is LGPL and QPL. They will sell you a commercial license if you > require one. > > > http://www.cgal.org/Manual/3.3/doc_html/cgal_manual/Alpha_shapes_2/Chapter_m > ain.html > > > Thi

Re: [postgis-users] Get concave hull from an array of longitude inlatitude points

2008-11-25 Thread Tim Bowden
Thanks to crschmidt on irc for pointing me in the direction of Schuyler Erle's work: http://code.flickr.com/blog/tag/clustr/ http://code.flickr.com/svn/trunk/clustr/ Looks promising so far. Regards, Tim -- Experience is that marvelous thing that enables you recognize a mistake when you make it a

RE: [postgis-users] Get concave hull from an array of longitude inlatitude points

2008-11-25 Thread Tim Bowden
On Tue, 2008-11-25 at 06:22 -0700, Rob Tester wrote: > CGAL has an open source implementation of the algorithm. (Along with some > other really neat things like vonoroi). > > http://www.cgal.org/ > There is certainly some quite interesting (mostly non free) stuff there. I can see an lgpl convex

Re: [postgis-users] Get concave hull from an array of longitude inlatitude points

2008-11-24 Thread Tim Bowden
the longest wanted tin face and the shortest unwanted tin vertex. That method will do a gross cleanup, but fine tuning will always be needed. Regards, Tim Bowden > > In any case, obviously this isn't in PostGIS right now. > > Obe, Regina wrote: > > > > Evidentall

Re: [postgis-users] return boundary

2008-11-24 Thread Tim Bowden
On Tue, 2008-11-25 at 10:48 +0900, Tim Bowden wrote: > On Mon, 2008-11-24 at 17:15 -0800, Martin Davis wrote: > > They're similar, but I'm not sure they're 100% the same in all cases. > > > > In the "mainland plus islands" case it seems there is a

Re: [postgis-users] return boundary

2008-11-24 Thread Tim Bowden
On Tue, 2008-11-25 at 10:48 +0900, Tim Bowden wrote: > Not sure what would happen if there are tin's involved). Complete red herring. Tim -- Experience is that marvelous thing that enables you recognize a mistake when you make it again. ___

Re: [postgis-users] return boundary

2008-11-24 Thread Tim Bowden
(or solutions- easier?) into multiple pieces and then pick and choosing to stitch them together again to get a final result. Awful way to go though. Regards, Tim > Of course it all depends on the data - there's probably lots of cases > where both would produce similar results. > >

Re: [postgis-users] return boundary

2008-11-24 Thread Tim Bowden
On Mon, 2008-11-24 at 11:45 -0500, Travis Kirstine wrote: > I don't think that the geom union would in combination with the > boundary would attach the island to the mainland. I don't think that > there is a simple answer to my problem but I have attached a pic to > help illustrate what I'm trying

Re: [postgis-users] PGRaster SQL Interface implemented?

2008-11-24 Thread Tim Bowden
According to the devel mailing list things don't look overly optimistic on the PGRaster front: http://postgis.refractions.net/pipermail/postgis-devel/2008-November/004130.html Regards, Tim Bowden > ___ > postgis-users mailing list >

Re: [postgis-users] PGRaster

2008-11-21 Thread Tim Bowden
n it would be > much appreciated. > Rasters in PostGIS is a well worn subject (though doubtless has much more mileage still left in it). For the best summary so far see: http://postgis.refractions.net/support/wiki/index.php?RasterNotes > Have a good weekend > John Having a good one, Ti

Re: [postgis-users] PostGIS 1.3.4 RC3 released

2008-11-21 Thread Tim Bowden
On Fri, 2008-11-21 at 08:42 -0800, Paul Ramsey wrote: > Tim, what did the diff file look like? Attached. Regards, Tim > > tmp/pgis_reg_15519/test_38_diff > > P > > On Fri, Nov 21, 2008 at 5:50 AM, Tim Bowden <[EMAIL PROTECTED]> wrote: > > > > On Fr

Re: [postgis-users] PostGIS 1.3.4 RC3 released

2008-11-21 Thread Tim Bowden
On Fri, 2008-11-21 at 12:25 +, Mark Cave-Ayland wrote: > Tim Bowden wrote: > > > On Fri, 2008-11-21 at 00:42 +0900, Tim Bowden wrote: > >> Debian etch, AMD64 dual core > >> gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) > >> postgresql 8.1.1

Re: [postgis-users] PostGIS 1.3.4 RC3 released

2008-11-20 Thread Tim Bowden
On Fri, 2008-11-21 at 00:42 +0900, Tim Bowden wrote: > Debian etch, AMD64 dual core > gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) > postgresql 8.1.15 > postgis 1.3.4rc3 > geos 2.2.3, 3.0.3 & 3.1 all make and install fine. Tested all with > importing a shp file u

Re: [postgis-users] PostGIS 1.3.4 RC3 released

2008-11-20 Thread Tim Bowden
On Thu, 2008-11-20 at 19:38 +0900, Tim Bowden wrote: > On Mon, 2008-11-17 at 20:53 +, Mark Cave-Ayland wrote: > > > For the record, PostgreSQL 8.3 with PostGIS 1.3.4rc3 compiles and passes > > all regression tests on MingW/Win32. Note we're still missing the > &

Re: [postgis-users] PostGIS 1.3.4 RC3 released

2008-11-20 Thread Tim Bowden
- GEOS 2.2.3 - Linux > PostgreSQL 8.1+ - GEOS 3.0.3 - Linux > PostgreSQL 8.1+ - GEOS 3.1 - Linux > > Remember: the sooner we pass the tests, the sooner we can release 1.3.4 :) > > I'll test these tonight on debian etch unless anyone else is already doing

Re: [postgis-users] PDF version of manual?

2008-09-10 Thread Tim Bowden
The new 1.4 docs look very nice. Well done. Regards, Tim Bowden On Wed, 2008-09-10 at 09:10 -0700, Kevin Neufeld wrote: > Yeah, it looks like things got a little jumbled with the new > documentation shuffle. > > I've reinstated the link on the documentation webpage to an old

Re: [postgis-users] PDF version of manual?

2008-09-09 Thread Tim Bowden
hough that the documentation is released before the code. I suspect that's unprecedented. Regards, Tim Bowden On Tue, 2008-09-09 at 20:35 +0200, Hernán De Angelis wrote: > Hi, > > Is there a PDF file of the manual for the most recent version of PostGIS? > In the past there used to

Re: [postgis-users] Points inside polygon...

2008-09-08 Thread Tim Bowden
ns or both are not stored as postgis geometries? If not, how are they stored? Regards, Tim Bowden > > How can I evaluate if a point is inside of all my records.. > I need to construct a box with all may records?? > > > Thanks...!! > _

Re: [postgis-users] Geometry appears empty

2008-07-02 Thread Tim Bowden
> > {lots of blank space then} The geom column is set to the width of the widest output, hence the massive line wrap. > > So, the geometry is present in both the "good" and "bad" records. > Next, what is GeoServer doing? It's probably over to that forum t

Re: [postgis-users] Geometry appears empty

2008-07-01 Thread Tim Bowden
rs? Are you having minscale or maxscale issues in visualising the data? Given FME can see the data it is in there and appears to be doing what it is supposed to do. I'm starting to think it is an issue with geoserver of some sort. Regards, Tim Bowden > So, we've established that all

Re: [postgis-users] Geometry appears empty

2008-07-01 Thread Tim Bowden
gt; same information that "appears" in PostGIS. > > Any other thoughts? > Check the validity of your geoms. select count(*) from where not ST_IsValid(the_geom); (or whatever your geom column is called). Regards, Tim Bowden > > > > > Tim Bowden wrote: > >

Re: [postgis-users] Geometry appears empty

2008-07-01 Thread Tim Bowden
result? Are you sure you don't have any invalid geometries? I don't know how FME handles these. HTH, Tim Bowden On Tue, 2008-07-01 at 17:12 -0700, geoffi wrote: > I have translated some polygon data into a PostGIS table using FME. The > translation was successful with no errors r

RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

2008-05-23 Thread Tim Bowden
On Fri, 2008-05-23 at 14:18 -0400, Obe, Regina wrote: > > Yes, using SDE effectively castrates the spatial database. It still > > walks and talks, but it's a shell of the man it was before. > > > > >> Ah, but a much cheaper shell than previously available to SDE users > >> (with at least 87%(?) o

Re: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

2008-05-23 Thread Tim Bowden
On Fri, 2008-05-23 at 11:13 -0700, Paul Ramsey wrote: > On Fri, May 23, 2008 at 11:05 AM, Tim Bowden <[EMAIL PROTECTED]> wrote: > > >> In general, if you restrict yourself ot reading with 3rd party tools > >> and writing with ESRI tools, or non-ESRI tools working

Re: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

2008-05-23 Thread Tim Bowden
, using SDE effectively castrates the spatial database. It still > walks and talks, but it's a shell of the man it was before. > Ah, but a much cheaper shell than previously available to SDE users (with at least 87%(?) of the performance as I vaguely recall from some semi-releva

RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

2008-05-23 Thread Tim Bowden
e? Does this mean editing the PostGIS geometries directly will put SDE in an inconsistent state wrt PostGIS? > I have also patched ZigGIS so that it works with just the ArcGIS Engine > which is what we use to develop our applications. > > Rob. > Regards, Tim Bowden > >

Re: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

2008-05-23 Thread Tim Bowden
On Fri, 2008-05-23 at 09:29 -0500, Stephen Woodbridge wrote: > Tim Bowden wrote: > > Hi all, > > > > I've read bits and pieces about PostgreSQL/PostGIS and ArcGIS Server 9.3 > > and how they (might) inter-operate. Can anybody point me to a concise > > s

[postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

2008-05-22 Thread Tim Bowden
rmance and functionality)? Does this mean we can have ArcGIS and open source clients editing the same geometries? ArcGIS Server 9.3 beta is in the wild, and I've read that the final release is due "soon". Anyone have any idea if soon is measured in weeks or mon

Re: [postgis-users] geometry types

2008-05-21 Thread Tim Bowden
racle's DeWitt clause? > > \\kristian Doesn't that depend on the results? Tim Bowden ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Client/Web based GIS using PostGIS

2008-04-21 Thread Tim Bowden
rland for the managmente of different kinds of > spatial data. > > If interessed fell free to contact me. Sounds interesting. How does this compare functionality wise with developing a custom app in mapguide? Regards, Tim

Re: [postgis-users] FOSS4G Architectures/options for Distributed DBs

2008-04-16 Thread Tim Bowden
rt contract in place that covers MapGuideOS. I don't see that as a significant obstacle. Regards, Tim Bowden > > Cheers, > > Brent Wood > > > --- Tim Bowden <[EMAIL PROTECTED]> wrote: > > > On Wed, 2008-04-16 at 11:30 +0200, Willy-Bas Loos w

Re: [postgis-users] FOSS4G Architectures/options for Distributed DBs

2008-04-16 Thread Tim Bowden
As such, delayed (or asynchronous) updates is manageable so long as you know when you last replicated. If such requirements can be answered without significant dev costs, I'd love to know how. Regards, Tim Bowden > > WBL > > > > On Wed, Apr 16, 2008 at 12:09 PM, Tim

Re: [postgis-users] FOSS4G Architectures/options for Distributed DBs

2008-04-16 Thread Tim Bowden
On Wed, 2008-04-16 at 11:30 +0200, Willy-Bas Loos wrote: > Hi Shaun, > > I think i saw a colleage of yours at the FOSS4G2007, Tim Bowden. > http://www.foss4g2007.org/presentations/view.php?abstract_id=261 > (i'm missing the presentation file at the website, maybe put it up &

RE: [postgis-users] facing problems while loading lwpostgis.sql inPostGIS

2008-02-02 Thread Tim Bowden
On Fri, 2008-02-01 at 18:58 +, Mark Cave-Ayland wrote: > On Fri, 2008-02-01 at 16:38 +0900, Tim Bowden wrote: > > > I vaguely recall there was a requirement for postgresql to be run before > > installing postgis. Is this still the case, or have I not correctly > >

RE: [postgis-users] facing problems while loading lwpostgis.sqlinPostGIS

2008-02-01 Thread Tim Bowden
this. Nobody can help you if you won't provide the information asked for. Tim Bowden On Fri, 2008-02-01 at 14:45 +0530, [EMAIL PROTECTED] wrote: > Tim, > > Thanks once again, > > As per the installation document, PostgreSQL is required to be installed &g

RE: [postgis-users] facing problems while loading lwpostgis.sql inPostGIS

2008-01-31 Thread Tim Bowden
PMs) and your new 8.2.6 installation in /usr/local/pgsql. > > Unfortunately it looks as if ./configure for PostGIS has picked up the > wrong one, so you need to do a "make clean" on your PostGIS installation > and then rebuild like this: > > ./config

RE: [postgis-users] facing problems while loading lwpostgis.sql inPostGIS

2008-01-31 Thread Tim Bowden
lled and running from an RHES rpm. Please post results of pg_config. 2. Does the /usr/local/pgsql/ directory exist, and does it have anything in it? Tim Bowden > > Secondly, the results of ldd /usr/local/pgsql/lib/liblwgeom.so > gives no such file or directory > >

Re: [postgis-users] facing problems while loading lwpostgis.sql in PostGIS

2008-01-31 Thread Tim Bowden
source it shouldn't. > e) We also tried hardcoding the path /usr/lib/pgsql instead of $libdir > in lwpostgis.sql when we tried loading functions and types in > lwpostgis.sql > f) When I hardcode the path /usr/lib/pgsql - it gives the followin

[Fwd: RE: [postgis-users] Problems while loadinglwpostgis.sql...Pleaseprovide your inputs / help]

2008-01-30 Thread Tim Bowden
resending... Forwarded Message From: Tim Bowden <[EMAIL PROTECTED]> To: PostGIS Users Discussion Subject: RE: [postgis-users] Problems while loadinglwpostgis.sql...Pleaseprovide your inputs / help Date: Thu, 31 Jan 2008 13:41:04 +0900 On Thu, 2008-01-31 at 09:29 +0530,

[Fwd: RE: [postgis-users] Problems while loading lwpostgis.sql...Pleaseprovide your inputs / help]

2008-01-30 Thread Tim Bowden
Resending because it looks like the original got mangled by Paul's use of sorbs.net to filter the mailing list... Forwarded Message From: Tim Bowden <[EMAIL PROTECTED]> To: PostGIS Users Discussion Subject: RE: [postgis-users] Problems while loading lwpostgis.sql...Pl

RE: [postgis-users] Problems while loading lwpostgis.sql... Pleaseprovide your inputs / help

2008-01-30 Thread Tim Bowden
On Wed, 2008-01-30 at 19:05 +0530, [EMAIL PROTECTED] wrote: > Yes andy > > a) /usr/local/lib was already present in /etc/ld.so.conf > b) ldconfig was also performed If you've used the default source install of postgresql, you'll need /usr/local/pgsql/lib HTH, Tim

Re: [postgis-users] detabase design question

2008-01-25 Thread Tim Bowden
quite a large job. I'd strongly recommend getting some expert consulting advice on site as database design is often not a straightforward exercise. Also start small, and add data sets gradually. Iron out the kinks for each one before moving onto the next. HTH, Tim Bowden ___

Re: [postgis-users] psql:/usr/local/pgsql/share/lwpostgis.sql:44: ERREUR: Impossible d'accéder au fichier "$libdir/liblwgeom" : No such file or directory

2008-01-08 Thread Tim Bowden
'à la fon du > bloc de la transaction > ... > My French is not so good but put /usr/local/pgsql/lib in /etc/ld.so.conf (or /etc/ld.so.conf.d/.conf depending on distribution) and then run ldconfig. That may solve the issue. Regards, Tim Bowden > This error seems to be ve

Re: [postgis-users] FOSS GIS clients - thanks for all the replies, on and offline

2008-01-05 Thread Tim Bowden
.org.uk/~sgtatham/bugs.html which is a very useful guide to reporting bugs or issues with software. Regards, Tim Bowden > > I would second that the discussion held here represents extreme points > of view perhaps to make for a more lucid debate. In reality we as > developers do great

Re: [postgis-users] Best way to

2007-11-21 Thread Tim Bowden
generic benchmarks are going to be of little use. Your best bet may well be to profile the load you're putting on postgis and then do performance testing using something like jmeter. That way you'll get a reasonable idea of how far you can push your system before it hits the wall. Re

Re: [postgis-users] Warning GEOS is NOT enabled

2007-07-25 Thread Tim Bowden
r under which the PostgreSQL server runs to find the directories > containing all the .so files - you'll need something like this: > > LD_LIBRARY_PATH=/data/ulysse/postgis_geos/GEOS/lib:/data/ulysse/postgis_geos/PROJ4/lib > > > HTH, > > Mark. > Or put the lib locatio