Re: [postgis-users] Problem enabling postgis (Mac OS)

2012-08-11 Thread William Kyngesburye
really great. > Thanks, > Pedro > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ Theory of the Un

Re: [postgis-users] Problem enabling postgis (Mac OS)

2012-08-13 Thread William Kyngesburye
n pgadmin, choosing new, > postgis would show up as an option? > > Sorry if I'm missing something obvious. > Thanks, > Pedro > > On Sun, Aug 12, 2012 at 4:51 AM, William Kyngesburye > wrote: > On Aug 11, 2012, at 8:35 PM, António Rodrigues wrote: > > > Hi

Re: [postgis-users] Problem enabling postgis (Mac OS)

2012-08-13 Thread William Kyngesburye
odd that you have no PostGIS extension files. Try reinstalling just PostGIS, and you don't need to uninstall anything. > Thanks, > Pedro > > On Mon, Aug 13, 2012 at 11:29 PM, William Kyngesburye > wrote: > How did you remove Postgres? > > Were there any errors

[postgis-users] raster extent and performance problem

2012-08-16 Thread William Kyngesburye
t's a GDAL problem. A GDAL vrt of the geotiffs processes quickly and reports the correct extents. - William Kyngesburye http://www.kyngchaos.com/ "Time is an illusion - lunchtime doubly so." - Ford Prefect ___ postgis-users m

[postgis-users] raster extent and performance problem... anyone?

2012-08-23 Thread William Kyngesburye
ract some data to tif) or if it's a GDAL problem. A GDAL vrt of the geotiffs processes quickly and reports the correct extents. - William Kyngesburye http://www.kyngchaos.com/ "Time is an illusion - lunchtime doubly so." - Ford Prefect

Re: [postgis-users] raster extent and performance problem... anyone?

2012-08-23 Thread William Kyngesburye
almost forgot: PostGIS 2.0.1, on PG 9.1.4. PPC OS X. On Aug 23, 2012, at 8:46 AM, William Kyngesburye wrote: > I created a raster table for a large area of DEM data, with index and > constraints, no overviews. When I run gdalinfo on the table, it takes about > 15m to query to get th

Re: [postgis-users] raster extent and performance problem... anyone?

2012-08-23 Thread William Kyngesburye
gt; > -bborie > > On 08/23/2012 07:01 AM, William Kyngesburye wrote: >> almost forgot: PostGIS 2.0.1, on PG 9.1.4. PPC OS X. >> >> On Aug 23, 2012, at 8:46 AM, William Kyngesburye wrote: >> >>> I created a raster table for a large area of DEM data, with i

Re: [postgis-users] mac 10.8

2012-08-24 Thread William Kyngesburye
gres 9.1 is required. > (It is installed and running). ----- William Kyngesburye http://www.kyngchaos.com/ All generalizations are dangerous, even this one. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.

Re: [postgis-users] mac 10.8

2012-08-24 Thread William Kyngesburye
ew to the mac arena. > > > And thanks for the quick reply. All of us appreciate your site and helpful > work you do. > > > > > -Original Message- > From: William Kyngesburye [mailto:wokl...@kyngchaos.com] > Sent: Friday, August 24, 2012 8:36 AM &g

[postgis-users] replicating features on self-join

2012-09-25 Thread William Kyngesburye
a sort to make that work) adds a LOT to the processing time processing time. - William Kyngesburye http://www.kyngchaos.com/ "Oh, look, I seem to have fallen down a deep, dark hole. Now what does that remind me of? Ah, yes - life." - Marvin ___

Re: [postgis-users] replicating features on self-join

2012-09-26 Thread William Kyngesburye
Or, you could just SELECT a.id, MAX(newclass) and then join back to a to > recover the dependent columns. > > No idea whether any of these ideas will be performant. Maybe someone else > has a more clever way of doing this. > > On 9/25/2012 10:48 AM, William Kyngesburye wro

Re: [postgis-users] replicating features on self-join

2012-09-27 Thread William Kyngesburye
I shouldn't use a JOIN in an update, even a small region went on forever until I stopped it. Put the st_coveredby in the where and the whole table processed in a couple minutes. I doing the update in stages, for sanity. Now working on the touching updates. Phwew. > On 9/26/2012 7:21

[postgis-users] hierarchical topology and attributes at different levels

2012-10-19 Thread William Kyngesburye
eed a hierarchical setup for this reversed query? - William Kyngesburye http://www.kyngchaos.com/ The equator is so long, it could encircle the earth completely once. ___ postgis-users mailing list postgis-users@postgis.refractions.net

Re: [postgis-users] hierarchical topology and attributes at different levels

2012-10-22 Thread William Kyngesburye
On Oct 21, 2012, at 2:40 PM, Sandro Santilli wrote: > On Fri, Oct 19, 2012 at 11:56:18AM -0500, William Kyngesburye wrote: > >> Can the attributes of child layers be seen from a layer? > > Sure, given enough neurons to build the appropriate SQL query... > (TopoGeomeometry

Re: [postgis-users] SQLite and postGIS

2008-04-07 Thread William Kyngesburye
ctions.net/mailman/listinfo/postgis-users ----- William Kyngesburye http://www.kyngchaos.com/ "Oh, look, I seem to have fallen down a deep, dark hole. Now what does that remind me of? Ah, yes - life." - Marvin ___ postgis-users mailin

Re: [postgis-users] Postgis Import Problems

2008-04-10 Thread William Kyngesburye
list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users - Willia

Re: [postgis-users] Proper Installation of Postgres and Postgis on 10.5 Intel

2008-04-10 Thread William Kyngesburye
such advice! Stef ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "Those people who most want to rule people are, ipso-facto, th

Re: [postgis-users] Proper Installation of Postgres and Postgis on 10.5 Intel

2008-04-10 Thread William Kyngesburye
machine... Thanks thousand times for any such advice! Stef ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "Th

Re: [postgis-users] Updated shapefile to update postgres database

2008-05-06 Thread William Kyngesburye
is.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ The equator is so long, it could encircle the earth completely once. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postg

Re: [postgis-users] Building SVN version of PostGIS on Mac OS X Leopard

2008-08-20 Thread William Kyngesburye
geom.so, which is what the new liblwpostgis.so is replacing. Delete /usr/local/pgsql/lib/liblwgeom.* and try again. - William Kyngesburye http://www.kyngchaos.com/ "History is an illusion caused by the passage of time, and time is an illusion caused by the passage of history.&qu

Re: [postgis-users] Building SVN version of PostGIS on Mac OS X Leopard

2008-08-20 Thread William Kyngesburye
On Aug 20, 2008, at 9:18 AM, William Kyngesburye wrote: Can anyone give me a hint as to how to proceed? I'm only doing this build because one of my colleagues wants to use the JSON functionality, so if there's some other way of getting this on a Mac build we'd be very happy.

Re: [postgis-users] Building SVN version of PostGIS on Mac OS X Leopard

2008-08-20 Thread William Kyngesburye
On Aug 20, 2008, at 9:35 AM, Mark Cave-Ayland wrote: William Kyngesburye wrote: For the internal build linking, it looks like it's supposed to link to the new liblwgeom.a. But the -L/usr/local/pgsql/lib option is after -L../liblwgeom AND the OSX linker prefers dynamic libs, so

Re: [postgis-users] Building SVN version of PostGIS on Mac OS X Leopard

2008-08-20 Thread William Kyngesburye
On Aug 20, 2008, at 10:14 AM, Mark Cave-Ayland wrote: William Kyngesburye wrote: Even if it's renamed (404 on that email link Mark), it will still try to link the installed liblwgeom.so instead of the internal liblwgeom.a, at compile time. Unless you mean liblwgeom.a -> libp

Re: [postgis-users] Building SVN version of PostGIS on Mac OS X Leopard

2008-08-20 Thread William Kyngesburye
HLIB_LINK="-arch x86_64" export PG_LIBS="-arch x86_64" ./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config \ --mandir=/usr/local/pgsql/man \ --with-geosconfig=/Library/Frameworks/GEOS.framework/Programs/geos- config \ --with-projdir=/Library/Frameworks/PROJ.framework/un

Re: [postgis-users] Installing PostGIS on Mac OS X

2008-10-09 Thread William Kyngesburye
PATHS at runtime (a linux problem, doesn't apply to OSX). Maybe the logs have something helpful? Open Console.app and see if there is anything in "All Messages" first. Hopefully there will be an expanded error message about that $libdir - what did Postgres actually try.

Re: [postgis-users]Re: Installing PostGIS on Mac OS X

2008-10-09 Thread William Kyngesburye
start of Postgres is all that's needed. - William Kyngesburye http://www.kyngchaos.com/ "Time is an illusion - lunchtime doubly so." - Ford Prefect ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postg

[postgis-users] problems cleaning geometry - other options?

2008-12-03 Thread William Kyngesburye
ometry (I'm not sure it's supported in shapefiles). I wonder if there is a simpler operation that could reorder sub- polygons to put the one that contains all the others first? And would it be faster or slower? - William Kyngesburye http://www.kyngchaos.com/ "Histor

[postgis-users] relationship functions not working well

2008-12-04 Thread William Kyngesburye
nt? hmmm, maybe a combination (but would that slow it down a lot)? - William Kyngesburye http://www.kyngchaos.com/ [Trillian] What are you supposed to do WITH a maniacally depressed robot? [Marvin] You think you have problems? What are you supposed to do if you ARE a maniacally

Re: [postgis-users] relationship functions not working well

2008-12-04 Thread William Kyngesburye
ect * from swbd where ST_Intersects(wkb_geometry, SetSRID('BOX3D(-162 55,-161 56)'::box3d,4326)); - William Kyngesburye http://www.kyngchaos.com/ "Oh, look, I seem to have fallen down a deep, dark hole. Now what does that remind me of

Re: [postgis-users] relationship functions not working well

2008-12-04 Thread William Kyngesburye
7.org/presentations/view.php?abstract_id=117 Nicolas I was wondering about that function. Unfortunately postgis 1.3 documentation doesn't have that handy link about the intersectionPatternMatrix that's in the svn documentation. I'll look at that, thanks. - Willi

Re: [postgis-users] problems cleaning geometry - other options?

2008-12-04 Thread William Kyngesburye
d it works. -- Kevin William Kyngesburye wrote: That works. It looks essentially the same as what's in the cleangeometry function from the wiki, but much simpler. There's st_union and st_multi in there betwen the buildarea and boundary functions, probably to handle other invalid stuff.

Re: [postgis-users] problems cleaning geometry - other options?

2008-12-04 Thread William Kyngesburye
feld wrote: Have you tried updating the geometry with a new polygonized polygon constructed from the linework? UPDATE swbd SET wkb_geometry = ST_BuildArea(ST_Boundary(wkb_geometry)) WHERE cell = 145018 AND wb = 353; Cheers, -- Kevin ----- William Kyngesburye http://www.kyngchaos.com/ First P

Re: [postgis-users] relationship functions not working well

2008-12-04 Thread William Kyngesburye
I'm trying to make it too complex? Is there a simple way to select all features within a rectangle? There should be, it's a common thing to do. - William Kyngesburye http://www.kyngchaos.com/ "We are at war with them. Neither in hatred nor revenge and with no particu

Re: [postgis-users] relationship functions not working well

2008-12-05 Thread William Kyngesburye
take care of the initial selection: ST_Intersects(wkb_geometry, SetSRID('BOX3D(-162 55,-161 56)'::box3d, 4326)) AND ST_relate(wkb_geometry, SetSRID('BOX3D(-162 55,-161 56)'::box3d,4326), 'T') That's reasonably fast, for a small box at least. It wil

Re: [postgis-users] relationship functions not working well

2008-12-05 Thread William Kyngesburye
RID('BOX3D(-162 55,-161 56)'::box3d, 4326)) AND ST_relate(wkb_geometry, SetSRID('BOX3D(-162 55,-161 56)'::box3d, 4326), 'T') That's reasonably fast, for a small box at least. It will likely slow down on a larger box. - William Kyngesburye http://www.kyng

Re: [postgis-users] relationship functions not working well

2008-12-05 Thread William Kyngesburye
, it wouldn't need to do the relate. I would be interested in the timing differences if you did them. Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of William Kyngesburye Sent: Friday, December 05, 2008 2:31 PM To: PostGIS Users

Re: [postgis-users] relationship functions not working well

2008-12-05 Thread William Kyngesburye
average: 380 ms intersect average: 1100 ms && + relate average: 7200 ms intersect + relate average: 7900 ms -Original Message----- From: [EMAIL PROTECTED] on behalf of William Kyngesburye Sent: Fri 12/5/2008 5:34 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] relat

[postgis-users] Re: [geos-devel] GEOS 3.1.0

2009-03-22 Thread William Kyngesburye
to some substantial performance improvements and some extra functions. ___ geos-devel mailing list geos-de...@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/geos-devel - William Kyngesburye http://www.kyngchaos.com/ "We are at war with

Re: [postgis-users] raster2pgsql vs gdal2wktraster ...can someone clarify?

2011-03-14 Thread William Kyngesburye
gt; version. The last version is always better. > Just remember that trunk (2.0/SVN) is in development, though I don't know how stable it is. There may be other problems. Last version *may* be better ;) - William Kyngesburye http://www.kyngchaos.com/ Theory of the Universe There is

Re: [postgis-users] postgis 2 installation failing

2011-03-18 Thread William Kyngesburye
__ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "I ache, therefore I am. Or in my case - I am, theref

Re: [postgis-users] postgis 2 installation failing

2011-03-18 Thread William Kyngesburye
a month old. Don't know about that - I just compiled with released GEOS 3.2.2 with no errors in lwgeom. It looks like the error is in shp2pgsql, which doesn't need GEOS. - William Kyngesburye http://www.kyngchaos.com/ "I ache, therefore I am. Or in my ca

Re: [postgis-users] postgis 2 installation failing

2011-03-18 Thread William Kyngesburye
On Mar 18, 2011, at 8:34 AM, William Kyngesburye wrote: > How are you configuring PostGIS? I have build instructions on my site (use > the framework alternate at the bottom of the postgis page). It's more than a > simple configure, you need to set some environment variables. Of

Re: [postgis-users] postgis 2 installation failing

2011-03-18 Thread William Kyngesburye
On Mar 18, 2011, at 9:13 AM, William Kyngesburye wrote: > On Mar 18, 2011, at 8:34 AM, William Kyngesburye wrote: > >> How are you configuring PostGIS? I have build instructions on my site (use >> the framework alternate at the bottom of the postgis page). It's

Re: [postgis-users] postgis 2 installation failing

2011-03-18 Thread William Kyngesburye
is confusing the configuration. Generally, I don't think Macports is automatically checked, it depends on the software. Straight Gnu configure won't, but some software checks for it. > On 18 March 2011 14:26, William Kyngesburye wrote: > On Mar 18, 2011, at 9:13 AM, Wi

Re: [postgis-users] postgis 2 installation failing

2011-03-18 Thread William Kyngesburye
On Mar 18, 2011, at 9:31 AM, Ackbar Joolia wrote: > the compile works (although the make is still failing), ... it looks like the --disable-nls option is broken, it's not disabling it, thus the same compile error. - William Kyngesburye http://www.kyngchaos.com/ "Mon Dieu!

Re: [postgis-users] postgis 2 installation failing

2011-03-18 Thread William Kyngesburye
ails. > > using the gettext didn't make any difference, I still get the error: > checking for xmlInitParser in -lxml2... no > configure: error: could not find libxml2 > > (btw, I want to get postgis2.0 installed on the snow leopard 10.6 to use the > postgis ras

Re: [postgis-users] Error when building from source on mac os x 10.6

2011-07-18 Thread William Kyngesburye
> directory) > make[1]: *** [postgis-1.5.so] Error 1 > make: *** [postgis] Error 2 > > So I've checked my /var/tmp dir and I really don't have ccsIJfa2.out file. > What am I doing wrong here? > > ___ > postgis-users mailing list &g

Re: [postgis-users] Error when building from source on mac os x 10.6

2011-07-19 Thread William Kyngesburye
file: /var/tmp//cccyfTRP.out (No such file or > directory) > make[1]: *** [postgis-2.0.so] Error 1 > make: *** [all] Error 1 > > Is there still a library built for a different arch? > How to check that out? > > > 2011/7/18 William Kyngesburye > It looks like the d

Re: [postgis-users] geos 3.3.0 installing problem on Lion

2011-08-01 Thread William Kyngesburye
unit tests: http://trac.osgeo.org/geos/ticket/299 The only simple solution there is to use gcc-4.0/g++-4.0, BUT Lion Xcode does not includes this. The other solution is to compile GEOS *and* whatever uses GEOS without optimization. So we're stuck. - William Kyngesburye http://www

Re: [postgis-users] geos 3.3.0 installing problem on Lion

2011-08-01 Thread William Kyngesburye
> On Mon, Aug 1, 2011 at 2:33 PM, William Kyngesburye > wrote: >> Unfortunately when using GCC 4.2, there is another bug that shows up in the >> unit tests: >> >> http://trac.osgeo.org/geos/ticket/299 >> >> The only simple solution there is to use gc

Re: [postgis-users] OSX Server (Lion) linking failures on i386 architecture

2011-09-14 Thread William Kyngesburye
ing GCC version 'i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1' > which is shipped with Xcode 4.2. > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http:/

Re: [postgis-users] OSX Server (Lion) linking failures on i386 architecture

2011-09-14 Thread William Kyngesburye
gt; > -=- Jerry > > > On Sep 14, 2011, at 12:57 PM, William Kyngesburye wrote: > >> 2 thoughts: >> >> • See my postgis build instructions. >> >> http://www.kyngchaos.com/macosx/build/postgis >> >> The Snow Leopard instructions should wo

Re: [postgis-users] OSX Server (Lion) link failures with Apple-provided PostgreSQL

2011-09-14 Thread William Kyngesburye
On the linking step, I noticed that the architecture flags specify both 32 >> and 64 bit, i.e. "-arch x86_64 -arch i386", but can't figure out how to >> disable 32 bit. I've already rebuilt Proj.4 4.7.0 and GEOS 3.2.2 as hybrid >> 32+64 bit libraries. >

Re: [postgis-users] Error when building from source on mac os x 10.6

2011-10-06 Thread William Kyngesburye
th-pgconfig=/usr/local/pgsql-9.1/bin/pg_config \ --with-geosconfig=/Library/Frameworks/GEOS.framework/unix/bin/geos-config \ --with-projdir=/Library/Frameworks/PROJ.framework/unix \ --with-raster --with-topology \ --with-gdalconfig=/Library/Frameworks/GDAL.framework/Programs/gdal-config - William

Re: [postgis-users] configure: error: GDAL Python bindings required by raster2pgsql.py loader

2011-10-17 Thread William Kyngesburye
gt; Date: October 16, 2011 2:29:19 PM CDT >> To: PostGIS Users Discussion >> >> >> I believe I did install the GDAL Python bindings (via MacPorts), but my >> PostGIS 2.0 configure script claims I don't have it. Is there are way I can >> determine whether or

Re: [postgis-users] configure: error: GDAL Python bindings required by raster2pgsql.py loader

2011-10-18 Thread William Kyngesburye
ct 16, 2011, at 2:31 PM, Mr. Puneet Kishor wrote: >>> >>>> From: "Mr. Puneet Kishor" >>>> Subject: configure: error: GDAL Python bindings required by >>>> raster2pgsql.py loader >>>> Date: October 16, 2011 2:29:19 PM CDT >>&g

Re: [postgis-users] configure: error: GDAL Python bindings required by raster2pgsql.py loader

2011-10-18 Thread William Kyngesburye
ge). On Oct 18, 2011, at 10:50 AM, Puneet Kishor wrote: > > On Oct 18, 2011, at 8:28 AM, William Kyngesburye wrote: > >> I don't think GDALFPolygonize is the problem, that's just a test for a new >> feature in development GDAL and it's OK if it fails. Aft

Re: [postgis-users] When will the PostGIS 2.0 be released?

2011-10-25 Thread William Kyngesburye
___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "We are at war with them. Neither in hatred nor revenge an

Re: [postgis-users] QGIS Plugin PostGIS Manager

2012-01-22 Thread William Kyngesburye
.faunalia.eu > Full contact details at www.faunalia.eu/pc > _______ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ Al

Re: [postgis-users] Is there a homebrew formula for postgis 2.0 ?

2012-03-27 Thread William Kyngesburye
list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ Earth: "Mostly harmless" - revised entry in the HitchHiker's Guide to the Galaxy __

Re: [postgis-users] OSX PostGIS 9.1 installer not working

2012-05-11 Thread William Kyngesburye
__ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "This is a question about the past, is it? ... How can I tell that

Re: [postgis-users] PostGIS 2.0 make problems on Mac Lion

2012-06-12 Thread William Kyngesburye
cale.h: No > such file or directory > … > > > Any tip is very much appreciated, as I have no idea how to proceed. > > Stefan > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.

Re: [postgis-users] Best way to safely remove Kyng Chaos PSQL from a Mac?

2012-06-19 Thread William Kyngesburye
postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ All generalizations are dangerous, even this one. ___ postgis-users mailing list postgis-users@postgis.refractions.

Re: [postgis-users] Install problem with PROJ directory

2012-06-29 Thread William Kyngesburye
OJ.framework/Versions/Current/Headers/ > > Can anyone help me with the appropriate form for the extra bit for the > ./configure statement? > > Thanks > > Bob > > > > > > _______ > postgis-users mailing lis

Re: [postgis-users] mac os install

2009-09-30 Thread William Kyngesburye
list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "I ache, therefore I am. Or in my case - I am, therefore I ache." - Marvin __

[postgis-users] No geography_columns view on upgrade

2010-02-09 Thread William Kyngesburye
Is it intentional that running one of the upgrade SQL scripts on an old DB doesn't add the geometry_columns view for 1.5? - William Kyngesburye http://www.kyngchaos.com/ [Trillian] What are you supposed to do WITH a maniacally depressed robot? [Marvin] You think you have problems?

Re: [postgis-users] Build errors in MAC OSX

2010-04-26 Thread William Kyngesburye
gt; --with-pgconfig=../bin/pg_config >>>>> >>> > --with-geosconfig=../../../Frameworks/GEOS.framework/Versions/3/Programs/geos-config >>>>> --with-projdir=../../../Frameworks/PROJ.framework/unix - William Kyngesburye http://www.kyngchaos.com/ "

Re: [postgis-users] WKT raster installation on mac

2010-07-07 Thread William Kyngesburye
wrote: > >> On Mon, Jul 5, 2010 at 6:15 PM, Shaun Langley wrote: >>> it returns /Library/PostgreSQL/8.4/lib >>> >>> what's the option syntax to add the lib directory during configuration? >>> can I specify something like >>> >

Re: [postgis-users] WKT raster installation on Mac Snow Leopard

2010-07-20 Thread William Kyngesburye
n/pg_config \ --with-gdal=/Library/Frameworks/GDAL.framework/Programs/gdal-config \ --with-geos=/Library/Frameworks/GEOS.framework/Programs/geos-config \ --with-postgis-sources=/Users/jatorre/workspace/postgis-1.5.1 ... hmm, it seems there is some interest in WKTraster on OS X...

Re: [postgis-users] WKT raster installation on Mac Snow Leopard

2010-07-20 Thread William Kyngesburye
On Jul 20, 2010, at 2:54 PM, P Kishor wrote: > On Tue, Jul 20, 2010 at 2:38 PM, William Kyngesburye > wrote: >> export CFLAGS="-Os -arch i386 -arch x86_64" >> export PG_CPPFLAGS="-arch i386 -arch x86_64" > > > Does that build for both 32 an

Re: [postgis-users] WKT raster installation on Mac Snow Leopard

2010-07-21 Thread William Kyngesburye
gt;> >> Javier. >> www.vizzuality.com >> >> ___________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > ___

[postgis-users] OS X WKTRaster installer now available

2010-07-21 Thread William Kyngesburye
OK, here you go! Ready to use with my Postgres/PostGIS packages. Sorry, I haven't done any testing. http://www.kyngchaos.com/software/postgres - William Kyngesburye http://www.kyngchaos.com/ Theory of the Universe There is a theory which states that if ever anyone discovers ex

Re: [postgis-users] OS X WKTRaster installer now available

2010-08-01 Thread William Kyngesburye
dates on my Postgres download page ;) On Jul 21, 2010, at 7:52 PM, William Kyngesburye wrote: > OK, here you go! Ready to use with my Postgres/PostGIS packages. Sorry, I > haven't done any testing. > > http://www.kyngchaos.com/software/postgres > - William Kyngesburye

Re: [postgis-users] Can't find postgis-1.4.so?

2010-08-23 Thread William Kyngesburye
installed Postgres. You should take this to EnterpriseDB. - William Kyngesburye http://www.kyngchaos.com/ "This is a question about the past, is it? ... How can I tell that the past isn't a fiction designed to account for the discrepancy between my immediate physical sensatio

Re: [postgis-users] Kyng chaos Postgis -- "PostGIS requires PostgreSQL 9.0."

2010-12-13 Thread William Kyngesburye
pq.5.3.dylib. Are you sure the Postgres install finished and succeeded? Is this a new install or upgrade of Postgres/PostGIS? - William Kyngesburye http://www.kyngchaos.com/ "Those people who most want to rule people are, ipso-facto, those least suited to do it." - A rule of the

Re: [postgis-users] Kyng chaos Postgis -- "PostGIS requires PostgreSQL 9.0."

2010-12-13 Thread William Kyngesburye
way in /usr/local/pgsql-9.0). >> Is this a new install or upgrade of Postgres/PostGIS? > > New, and I *think* i used your binary. - William Kyngesburye http://www.kyngchaos.com/ "Oh, look, I seem to have fallen down a deep, d

Re: [postgis-users] cant find shp2pgsql on mac osx

2011-02-25 Thread William Kyngesburye
direction I'd be more than happy... > .....thanks... > - William Kyngesburye http://www.kyngchaos.com/ Theory of the Universe There is a theory which states that if ever anyone discovers exactly what the universe is for and why it is here, it will instantly disappear and be

Re: [postgis-users] Shared memory extesion on a a Mac for PostgreSQL/PostGIS

2011-03-04 Thread William Kyngesburye
. With the OS X defaults the Postgres server may not run at all, especially with large and/or many databases, and on 64bit processors. It doesn't hurt the system. Odd, I thought I had that info in my package readme. I'll have to dig through my memory and notes to see

Re: [postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

2011-03-05 Thread William Kyngesburye
stuff. Check the Postgres documentation and other help resources for more details. My Postgres distribution has some basics, to get people started. > Any help is good, > rosemary. > > > ___ > postgis-users mailing list > postgis-users@po

Re: [postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

2011-03-05 Thread William Kyngesburye
e PostGIS binaries > from: http://www.kyngchaos.com/software:postgres? > > Thanks much, > rosemary. > > > On Sat, Mar 5, 2011 at 8:54 AM, William Kyngesburye > wrote: > On Mar 5, 2011, at 4:38 AM, Rosemary Alles wrote: > > > Hullo all, > > > > A

Re: [postgis-users] Problem with WKTRaster: cannot get raster type in database

2011-03-11 Thread William Kyngesburye
__ >>>>>> postgis-users mailing list >>>>>> postgis-users@postgis.refractions.net >>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>> ___ >>>>

Re: [postgis-users] Problem with WKTRaster: cannot get raster type in database

2011-03-11 Thread William Kyngesburye
> Try running the psql command as I specified below - does that work? > Is there a way that I can change $libdir to point to /usr/local/pgsql/lib > instead of /usr/local/pgsql-9.0/lib? > That should not be necessary. > Pierre, > I don't have the libgdal.so > And yo

Re: [postgis-users] Problem with WKTRaster: cannot get raster type in database

2011-03-11 Thread William Kyngesburye
same ($libdir/...). On Mar 11, 2011, at 1:11 PM, AJ7 wrote: > > sorry - meant to add that the command didn't work (got the same errors) > > > William Kyngesburye wrote: >> >> On Mar 11, 2011, at 11:05 AM, AJ7 wrote: >> >>> >>> Hi Willia

[postgis-users] Trying to figure out topology

2007-06-05 Thread William Kyngesburye
those be the geom types and feature IDs of the layer? Would I use a SQL select to pipe in all the rows of the layer? Examples would be much appreciated. - William Kyngesburye http://www.kyngchaos.com/ Earth: "Mostly harmless" - revised entry in the HitchHiker's Guid

Re: [postgis-users] Trying to figure out topology

2007-06-05 Thread William Kyngesburye
On Jun 5, 2007, at 12:38 PM, William Kyngesburye wrote: Now I get to generating topology for each line in the layer. The wiki has: select topology.CreateTopoGeom(topology_name, feature_type, layer_id [as returned from AddTopoGeometryColumn], TopoElementArray); but the link to

Re: [postgis-users] Mac OS X installation problem - no "coveredby" in liblwgeom.1.3.so"

2007-08-18 Thread William Kyngesburye
s. I intsalled geos right before building installing postgis. - William Kyngesburye http://www.kyngchaos.com/ "Those people who most want to rule people are, ipso-facto, those least suited to do it." - A rule of the universe, from the HitchHi

Re: [postgis-users] Mac OS X regression failures - 13/35 (was no "coveredby" in liblwgeom.1.3.so")

2007-08-19 Thread William Kyngesburye
;t make any sense to me. Follows, though is the result of make test, and I can provide the diffs upon request. I am running SVN, so maybe I get what I deserve: - William Kyngesburye http://www.kyngchaos.com/ "We are at war with them. Neither in hatred nor revenge and with no par

Re: [postgis-users] Mac OS X regression failures - 13/35 (was no "coveredby" in liblwgeom.1.3.so")

2007-08-24 Thread William Kyngesburye
don't see any server crashes at all: - William Kyngesburye http://www.kyngchaos.com/ "Those people who most want to rule people are, ipso-facto, those least suited to do it." - A rule of the universe, from the HitchHiker's Guide to the Galaxy _

Re: [postgis-users] Mac OS X development - anyone have a Mac available for testing?

2007-09-02 Thread William Kyngesburye
d out. -W ----- William Kyngesburye http://www.kyngchaos.com/ First Pogril: Why is life like sticking your head in a bucket filled with hyena offal? Second Pogril: I don't know. Why IS life like sticking your head in a bucket filled with hyena offal? First Pogril: I don't know either.

Re: [postgis-users] Mac OS X development - anyone have a Mac available for testing?

2007-09-02 Thread William Kyngesburye
and using it later? Or maybe you have Fink installed, but compiled proj and geos from scratch? - William Kyngesburye http://www.kyngchaos.com/ All generalizations are dangerous, even this one. ___ postgis-users mailing list postgis

Re: [postgis-users] indexing images stored in PostGres

2007-10-03 Thread William Kyngesburye
tunity to store your images in the database entirely (fools!) feel free to review Xing Lin's work in this branch. It's good work, though obviously I have religious objections to it... :) http://svn.refractions.net/postgis/branches/gSoC2007_raster/ - William Kyngesburye http:

Re: [postgis-users] "make check" failures w/ 1.3.1 on Mac OS 10.5

2007-11-25 Thread William Kyngesburye
__________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "We are at war with them. Neither in hatred nor revenge and with no particular p

Re: [postgis-users] "make check" failures w/ 1.3.1 on Mac OS 10.5

2007-11-25 Thread William Kyngesburye
0x00010082ba80 r15: 0x000382fc rip: 0x7fff8269ceea rfl: 0x00010283 cr2: 0x0002 On Nov 25, 2007, at 2:19 PM, William Kyngesburye wrote: Possibly a permissions problem? I just ran the tests on my new Leopard build, using GEOS 3, and got 36/37 fails.

Re: [postgis-users] "make check" failures w/ 1.3.1 on Mac OS 10.5

2007-11-25 Thread William Kyngesburye
get_uint32). They're in these files: liblwgeom.h lwcurve.c lwgeom_api.c lwgeom_pg.c lwline.c lwpoint.c lwpoly.c I now have 5/37 fails. Time to check on those. On Nov 25, 2007, at 3:49 PM, William Kyngesburye wrote: Thread 0 Crashed: 0 libSystem.B.dylib 0x900e18

Re: [postgis-users] "make check" failures w/ 1.3.1 on Mac OS 10.5

2007-11-25 Thread William Kyngesburye
And once more... there was some leftover junk from the previous failed tests (a bunch of errors about relation already exists). After those were cleared out, all tests succeeded! On Nov 25, 2007, at 5:02 PM, William Kyngesburye wrote: Sorry to keep replying to myself. I think I see the

Re: [postgis-users] "make check" failures w/ 1.3.1 on Mac OS 10.5

2007-11-25 Thread William Kyngesburye
. Any ideas on what might be wrong? Thanks again for your help! --john On Nov 25, 2007, at 4:09 PM, William Kyngesburye wrote: And once more... there was some leftover junk from the previous failed tests (a bunch of errors about relation already exists). After those were cleared out, al

Re: [postgis-users] "make check" failures w/ 1.3.1 on Mac OS 10.5

2007-11-30 Thread William Kyngesburye
g because it can't open the loader test files - it's good to see that the build works which is the important thing. The only thing I can think of is filesystem permissions - what do the permissions for the loader/ directory look like? Are the shape files actually present? Kind regards,

Re: [postgis-users] shp2pgsql problems on Mac OS X Leopard

2007-12-06 Thread William Kyngesburye
Engineer, Priority 5 > http://www.priority5.com/ > > > > _______ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailma

Re: [postgis-users] shp2pgsql problem with Leopard

2007-12-30 Thread William Kyngesburye
_ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ The equator is so long, it could encircle the earth completely once. __

Re: [postgis-users] shp2pgsql problem with Leopard

2007-12-30 Thread William Kyngesburye
On Dec 30, 2007, at 12:16 PM, William Kyngesburye wrote: If the two different declarations of getopt are causing the problem, I wonder if Apple's getopt will work (it's BSD getopt)? Or did you customize getopt for postgis? Well, Apple's BSD getopt works in 64bit mode, but

  1   2   >