Re: [postgis-users] 1.3.3 Pre-Release Notice

machine. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo

Re: [postgis-users] 1.3.3 Pre-Release Notice

to test SVN ready for release, and I'm getting a failure in the regress_ogc section :( Unfortunately this will have to wait until later tomorrow before I can look at it... ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] 1.3.3 Pre-Release Notice

. Being self-taught in C, it's always interesting to learn something new - even if it does go against intuition :) ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis

Re: [postgis-users] ST_Contains()

The function ST_Contains() doesn't work in version 1.3,2. Is it fixed in version 1.3.3? Regards, Stephan Hi Stephan, In what way did you think it was broken in 1.3.2? You'll need to post some form of test case in order for someone to help you. ATB, Mark. -- Mark Cave-Ayland Sirius

Re: [postgis-users] ST_Union and geomunion Windows Fix Soon?

code that I need to squash before I can roll them out. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] equals and =

equality. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo

[postgis-users] Win32 Installers for PostGIS 1.3.3 now available

, StackBuilder users will need to uninstall their existing version before 1.3.3 can be installed. Please report any issues to the lists/bug tracker as normal. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] can't find lwlgeom

that liblwgeom can't find one or more of its dependent libraries such as GEOS and/or PROJ.4. Check your ld.so.conf to make sure it includes /usr/local/lib if you built by hand, and then don't forget to restart the PostgreSQL server so it can pick up the changes. HTH, Mark. -- Mark Cave

Re: [postgis-users] Win32 Installers for PostGIS 1.3.3 now available

this changed. The installer should still work without any problems, however. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] PostGIS install on postgres 8.3 running on 64bit OpenSuse10.3

in any non-standard parameters to configure? As a first course of action, I would try removing all liblwgeom files from /usr/lib64 and trying to run lwpostgis.sql again. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] PostGIS install on postgres 8.3 running on 64bit OpenSuse10.3

try which pg_config to see from where configure is finding your PostgreSQL configuration information. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing

Re: [postgis-users] Does ST_AsText truncate or round

ST_EWKT() function which will output the extra information, but is not spec-compliant. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] I'm missing something

away. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis

Re: [postgis-users] pgpass.conf

. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] Roadmap for next major release of PostGIS

. [Note: I have also CC-d to postgis-devel, but please keep any resulting discussion on postgis-users] ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list

Re: [postgis-users] Roadmap for next major release of PostGIS

features, several people have recently been asking about multi-dimensional indices. If enough interested parties could donate some money for developer time, I'm sure this would help fund the developers required to do the work. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source

Re: [postgis-users] Roadmap for next major release of PostGIS

? ;) ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis

Re: [postgis-users] Roadmap for next major release of PostGIS

. Other than basic human error, the only thing I can think of is that another package somewhere in the GIS application bundle supplied with Hardy Heron still depends on GEOS 2.2.x series. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44

Re: [postgis-users] build_histogram2d function problem

of the deprecated statistics subsystem which only ever got used for PostgreSQL versions 8.0. If you want access to the 2D histograms created during ANALYZE, I think you should be able to get at them through the pg_statistic table or the related pg_stats view. HTH, Mark. -- Mark Cave-Ayland Sirius

Re: [postgis-users] mybe OT: Offline-Win32-installation w/ PostgreSQL 8.3.x possible?

. The website does not say anything about that. Thanks for any pointers. Stephan Hi Stephan, You can download the Win32 installer direct from pgfoundry.org if you wish; look for the StackBuilder project. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] GIST index speed

index scan. The above output doesn't look quite right somehow (it's missing at least one node indicator) - can you try cutting and pasting the exact output from EXPLAIN into an email again? Also we'll need the output of \d geography from within psql. ATB, Mark. -- Mark Cave-Ayland Sirius

Re: [postgis-users] GIST index speed

into this. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] GIST index speed

Mark Cave-Ayland wrote: *blinks* this is definitely a bug somewhere - there is no way that adding a function wrapper to a constant should make the query several orders of magnitude quicker :( Hmmm. It seems the problem is related to whether or not we copy the incoming geometry. I've just

Re: [postgis-users] GIST index speed

the IMMUTABLE definition from SQL definition of mcatest() and it didn't make any difference to me - probably because adding a POSTGIS_DEBUG macro shows that it only gets called once in total rather than once per iteration of the nested loop scan. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation

Re: [postgis-users] GIST index speed

with profiling under OS X? If so, it would be good to get at least a working profile output of both query cases, so we can try and determine where the time is being swallowed during the index scan. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] X3d export

Paragon Corporation wrote: I guess the only concern with that which Paul Ramsey or Mark Cave-Ayland can clarify on is that since they are restructuring at least the PostGIS part not sure how easily it will stream up. I presume the Geos part is undergoing some changes too with the Prepared

Re: [postgis-users] where to register to submit bug?

beyond what Buffer(0) can accomplish. There does seem to be a lot of discussion recently about new features; perhaps we need to add a How to sponsor a feature section to the wiki explaining how companies can approach developers to get new features implemented... ATB, Mark. -- Mark Cave-Ayland

Re: [postgis-users] Postgis installation - Trouble with 'make check'

Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] box2d return from function!

break a lot of applications, so the earliest it will happen is somewhere in 1.4. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] box2d return from function!

tempted to make ST_Extent return a POLYGON geometry in the SVN head... ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] Error running lwpostgis.sql - Missing PG_MODULE_MAGIC

argument to force it to pick up the newer installation. Follow this with make install and you should then be good to go. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] geometry contains non-closed rings

should report the offending line number for you, i.e.: psql -d mydatabase -f shapefile.sql HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis

[postgis-users] Renaming lwpostgis.sql and other files

object to this at all? Of course, the documentation would also be updated to reflect these changes. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list

Re: [postgis-users] Postgis to ESRI shape file encoding problem

interested? ;) ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman

Re: [postgis-users] Two solaris 10 compilation problems

will display an error during the configure phase if this happens again. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] postgis on Debian 4.0

are both extremely old - you should really consider building the latest PostGIS 1.3.x release to avoid several nasty PostGIS bugs, and preferably a newer version of PostgreSQL at the same time. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] asGML Error

, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] problem with postgree 8.3 and mapserver 2.2.8

would suggest checking the Mapserver/PostgreSQL log files in order to find any error messages that will point you in the right direction. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] Memory problem with ST_Within

postgis_full_version(). ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo

Re: [postgis-users] postgis install error in windows

, It almost looks like it's just a simple file permissions problem. Are you running the installer as an administrator, and does the administrator user have the correct file permissions on the relevant directories? HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] pl/python query variables

list over at postgresql.org. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net

Re: [postgis-users] Memory problem with ST_Within

: Could this have been resolved by some of the recent memory fixes in GEOS SVN? ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] large intersection and resulting query plan

) field value, you may find that things can start to work better... ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] postgis install problems

to detect this, however the relevant changes have been made in SVN trunk. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] postgis install problems

if the version you are using is too old. Compiling a newer version of PROJ (I'd grab the latest stable) and then re-building PostGIS 1.3.3 should be enough to resolve this. PROJ can be found at: http://trac.osgeo.org/proj/. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source

Re: [postgis-users] Function 60821c60 returned NULL

/documentation/manual-svn/release_notes.html#id2692480. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] Function 60821c60 returned NULL

. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis

Re: [postgis-users] custom data type on basis of 3d geometry type?

table to find tables containing geometries... ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] Setup problems: cache lookup failed

broken. I'd reinstall the PostgreSQL PostGIS packages, making sure that they match your architecture and try again. If that doesn't work, I'd try compiling PostgreSQL from source and verifying that the regression tests actually pass. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation

Re: [postgis-users] ST_SPHEROID_LENGTH SLOW

using autovacuum on both systems? If not, a VACUUM FULL test; REINDEX TABLE test may help if you are suffering from table/index bloat. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] GeometryCollection(Empty) is SRID dependent (orsupporting nulls in st_union)

. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] st_box2d

the returned polygon. Thanks for your help. Hi JP, BOX2Ds are simply expressed as BOX2D(x1 y1, x2 y2) where x1, y1 is the lower left corner and x2, y2 is upper right corner. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608

Re: [postgis-users] GeometryCollection(Empty) is SRID dependent (orsupporting nulls in st_union)

entirely sensible. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo

Re: [postgis-users] Restoring db with indexes using PostGIS functions

in-built stored procedures. Otherwise it could simply be that the dump ordering is wrong, and altering the restore order so that geometrytype() is restored *before* ST_geometrytype should resolve the issue. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] st_box2d

(-81.507568359375 42.3016891479492,-76.036376953125 44.8636589050293) (1 row) ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] The_geom is empty

a certain number of bytes cannot be displayed. However you can verify that they exist correctly using psql. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing

Re: [postgis-users] bounding box incorrect on circularstring

150406.421875,220227.34375 150406.421875)) ... is this a known issue that is being addressed? Ken Hi Ken, Which PostGIS version are you using? Any chance you could file this on the PostGIS bugtracker? Many thanks, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk

Re: [postgis-users] ST_SPHEROID_LENGTH SLOW

then this should immediately resolve it. Also just to confirm - where are you getting your debian packages from? HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list

Re: [postgis-users] Installing PostGre SQL

. Regards Hi Prestige, The issue is that the installer doesn't have permissions to write the files to the PostgreSQL installation directory - you are running this as an administrator, aren't you? HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] 1.3.4SVN Testers Wanted

. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] 1.3.4SVN Testers Wanted

to do make clean before configure and make to force a rebuild of the source tree. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] SRID tranformations (OSGB 1936)

, but if this is the case then simply append +datum=OSGB36 to the proj4text field and try again. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list

Re: [postgis-users] WKT polygon and interior ring orientation

thing to notice is the MS-SQL's geometry type enforces ring orientation, so we can only guess that they need this property for some of their spherical calculations. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] pgsql2shp problem

users have reported problems with 3rd party firewalls and/or virus checkers interfering with normal operation - it may be worth trying to disable these temporarily and trying again. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44

Re: [postgis-users] Strange problem with

Paragon Corporation wrote: I thought maybe this was a bug in GIST from before my upgrade, so I dropped my gist index on the affected table and readded it and still get the same bizarre behavior. Hi Regina, Does changing ST_box2d() to ST_box3d() help at all? ATB, Mark. -- Mark Cave-Ayland

[postgis-users] PostGIS 1.3.4 RC3 released

, or experience a regression failure, please feel free to post the relevant make check output to the mailing list. Happy testing! ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] PostGIS 1.3.4 RC3 released

/pgis_reg_1107 PostgreSQL 7.3.19 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.3.2-1) 4.3.2 Postgis 1.3.4rc3 - 2008-11-13 14:24:10 GEOS: 3.0.0-CAPI-1.4.1 PROJ: Rel. 4.6.0, 21 Dec 2007 ... ... Run tests: 39 Failed: 0 ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open

Re: [postgis-users] PostgreSQL 8.3 GiST Bug

. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 1.3.4 RC3 released

is the introduction of sed within Makefile.config rather than cut, and this should only affect the extraction of the PostgreSQL version. I think a good test is whether 1.3.3 suffers from the same problem on the same server. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source

Re: [postgis-users] Postgre 8.3.5 PostGIS SVN 2008-11-13 Updates

, you're probably being hit a change in parser rules (and it's likely these will change again before 1.4 final). So in other words, leave PostGIS as it is and for the moment just upgrade PostgreSQL to 8.3.5 and you should be fine. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open

Re: [postgis-users] PostGIS 1.3.4 RC3 released

On Thu, 2008-11-13 at 09:44 +, Mark Cave-Ayland wrote: Hi everyone, The PostGIS team are pleased to announce that PostGIS 1.3.4 RC3 is now available for download from http://postgis.refractions.net/download/postgis-1.3.4rc3.tar.gz. In particular, the team are interested

Re: [postgis-users] PostGIS 1.3.4 RC3 released

at least enable us to get rid those final compilation warnings. Feel free to put forward a proposal on -devel :) ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users

Re: [postgis-users] ST_AsKML changes in 1.3.3

as if something went wrong as part of a database upgrade from an earlier PostGIS version so that the wrapper function is not present in your new database. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] PostGIS 1.3.4 RC3 released

up something based upon the patches in SVN trunk, but it would be fairly unmaintainable unless they get added to SVN. I wonder if it's worth putting out a 2.2.4 release containing just compilation fixes? ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] ST_AsKML changes in 1.3.3

is why only this function is visible. I'll go and fix this in 1.3 branch (trunk requires PROJ.4) - I wonder if it's worth a note in the 1.3 documentation that ST_AsKML() requires PROJ.4 support - Regina? HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] fabs() testing for y-coordinates in lwgeom_svg.c

by the majority of coordinate systems. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] fabs() testing for y-coordinates in lwgeom_svg.c

point numbers), but even then I'm not 100% convinced by the logic. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] PostGIS 1.3.4 RC3 released

see that users can complain as they are getting bugfixes for their installation. Any other grumbles should be directed squarely at Canonical, and should not stop us moving to GEOS 3.0.0 minimum for the 1.4 series if there is a valid reason to do so. ATB, Mark. -- Mark Cave-Ayland Sirius

Re: [postgis-users] ST_AsKML changes in 1.3.3

Obe, Regina wrote: Yah its worth a note. Guess that should be done for ST_Transform too. Any other functions require Proj? Not sure off the top of my head. A quick search for USE_PROJ in lwpostgis.sql.in for the 1.3 branch should tell you all... HTH, Mark. -- Mark Cave-Ayland Sirius

Re: [postgis-users] PostGIS 1.3.4 RC3 released

submitted some patches for GEOS 2.2 branch, so at least now I have a way of testing them against my system here. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users

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

from this array of points, but this is not really helpful. What I'm trying to get is some kind of concave hull polygon from an array of points, which I would further like to use in Google Earth kml file. Thanks. Hi Aleš, Does ST_Union() help you at all? ATB, Mark. -- Mark Cave-Ayland

Re: [postgis-users] PostGIS 1.3.4 RC3 released

... ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] 1.3.4rc3 regression failure

0.5 0.5 2) All else seems AOK. Cheers, Stephen Davies Hmmm there is chance this is related to the GBT#21 fix, although I can't recreate it here. I think we'd need access to the system in question to determine exactly what is happening :( ATB, Mark. -- Mark Cave-Ayland Sirius Corporation

Re: [postgis-users] 1.3.4rc3 regression failure

0.5 0.5 2) All else seems AOK. Cheers, Stephen Davies One more quick question: does make check on 1.3.3 pass without any errors? ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] Curve polygon

there is a technical reason for it somewhere? Then again, PostGIS is always happy for companies to sponsor developers for specific bits of work, so that could be another option for you. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T

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

, it sounds like an internal error. If you can extract a standalone test case and post it on the bug tracker, I'll take a look at it. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] Changed bahaviour of PostGIS confuses MapServer

://postgis.refractions.net/pipermail/postgis-commits/2008-December/000866.html if you can't wait for a 1.3.5 release. Please let us know whether this resolves the problem for you. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] pgsql2shp.exe fails with Windows Vista

it on my build system - I might need to go and do some more checks... HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] pgsql2shp.exe fails with Windows Vista

access to a copy of Vista to help you here, so I'll have to put this back out to others on the list. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list

Re: [postgis-users] pgsql2shp.exe fails with Windows Vista

a backtrace. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis

Re: [postgis-users] ST_AsKML changes in 1.3.3

it in line with the existing PostGIS convention for internal functions which is always good. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis

Re: [postgis-users] CONTAINS function still existing in 1.3.5 version?

. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Help with Bad Query Plan

. Still no luck. Many thanks, Oliver. Hi Oliver, Please can we see the EXPLAIN ANALYZE output for queries STEP 3 and STEP 4? Many thanks, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

Re: [postgis-users] Help with Bad Query Plan

Oliver Snowden wrote: Hi Paul (Ramsay), STEP 4 is exactly the same query as part 8 only I have created an index in part 7. Hi Mark (Cave-Ayland), please see below the EXPLAIN ANALYZE output for STEP 3 and STEP 4. My understanding is that the first choice of Join Filter

Re: [postgis-users] Help with Bad Query Plan

... If this is the case, it seems Oliver is almost certainly being bitten by the operator RECHECK :( ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users

Re: [postgis-users] Help with Bad Query Plan

where the time is being spent during query execution. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] How to disable password in postgreSQL (pardon the stupid question)

, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Strange behaviour with st_difference

postgis_full_version() while you're at it :) ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] newbie: Error in first atttempt to use postgis with mapserver?

for a PostGIS layer? It's scary how many people I meet who think it is a bug in PostgreSQL and then spend several days reloading their entire database with oids enabled... *sigh* ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608

Re: [postgis-users] PostGIS Solaris 10 compile issue - detecting iconv versions [SEC=UNCLASSIFIED]

building PostGIS, does it get any further? If not, you'll need to post a copy of the configure output and config.log somewhere where we can take a look at them. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

<    1   2   3   4   >