Re: [postgis-users] Problems compiling PostGIS on Solaris 2.10/SparcV9

to pass to configure for the 1.3 series is --with-pgsql=/path/to/pg_config. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 __

Re: [postgis-users] Compiling PostGIS SVN on Gentoo amd64

n/ch02.html for the new configure parameters). If that doesn't help then you'll need to post the output of configure for us to look at. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation

Re: [postgis-users] Postgis 1.3.5 installation issue

v package installs a lobotomised pg_config which doesn't respond to any of the options required to build server plugins. Installing the above package will install a new version along with all of the headers required to support this. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Archi

Re: [postgis-users] newbie question about non closed rings

Paragon Corporation wrote: Mark Cave-Ayland, I forget were we planning on making this a switch option in later versions of PostGIS? So that you could bring in polygons with unclosed rings and fix them in the db? Well the result of the earlier investigation showed that having a switch will

Re: [postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

e PostgreSQL documentation, or even better, upgrading to a new version of PostgreSQL. 8.0.3 is old, and won't be supported when 1.4 eventually pops out of the door. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through fre

Re: [postgis-users] Shp2Pgsql - how to handle carriage returns ?

nd INSERT modes. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refra

Re: [postgis-users] Shp2Pgsql - how to handle carriage returns ?

easy to modify. Hope you find it helpful. -Dave Hmmm this sounds like a shp2pgsql bug, since the escaping behaviours for COPY output and INSERT output should be different. Dave, could you add this to the bug tracker? Many thanks, Mark. -- Mark Cave-Ayland - Senior Technical Architect

Re: [postgis-users] PostGIS/PostgreSQL - error in creating table

, typically the postgres database generated during installation is used for these kinds of administration tasks. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063

Re: [postgis-users] postgis on postgresql 8.2 vs 8.3

ading from 8.2 to 8.3 then a database dump and restore cycle will be required. And since you're upgrading to a new PostgreSQL version, make sure that you test your application thoroughly first before it goes live. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL -

Re: [postgis-users] optimum no of slices in pgis_fn_nn() ?

either 1.3 or trunk. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 ___ postgis-users mailing list pos

Re: [postgis-users] equal area projection

art and it appears it's blank in your SQL above. If you can find the equivalent PROJ.4 description, you should be fine. BTW I'm quite surprised that PROJ.4 crashes with an empty proj4text - which version of PostGIS are you using? ATB, Mark. -- Mark Cave-Ayland - Senior Technical

Re: [postgis-users] index-based inconsistencies

8.3.6 and a re-build of your GiST indices before spending more time on this... ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608

Re: [postgis-users] website down?

Martin Landa wrote: Hi, www.postgis.org doesn't seems to work. I get only white page (no HTML code). Thanks, Martin Yeah, the guys at Refractions are aware of this. Please bear with them while they get everything up and running again... ATB, Mark. -- Mark Cave-Ayland - S

Re: [postgis-users] writing function using C

es. I'd suggest that you take a look at http://www.postgresql.org/docs/8.3/interactive/xfunc-c.html, the PostGIS codebase, and ask further questions on the PostgreSQL mailing lists. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation p

Re: [postgis-users] Error using PostGIS and GEOM

Geoserver is configured to connect to the wrong database (i.e. one which is not PostGIS-enabled). HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063

Re: [postgis-users] Stack Builder freezing on Windows

around for the next release. Does your original error show up if you remove PostGIS and then attempt to install it again? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870

Re: [postgis-users] Error using PostGIS and GEOM

ackword support for the extent function? thanks! Giri Hi Giri, There has been talk of removing the old non-ST prefix functions from PostGIS, but so far this hasn't happened. Perhaps you need to check your installation? HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect

Re: [postgis-users] Error en postgres

server headers? You can do this with: aptitude install postgresql-server-dev-8.1 HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063

Re: [postgis-users] Stack Builder freezing on Windows

-c "SELECT version();" If there is an issue here, it should be fairly easy to spot. Have you altered the configuration of pg_hba.conf/postgresql.conf from the installed default? And could you have a firewall/virus checker installed blocking connections to localhost? ATB, Mark. -- Mark

Re: [postgis-users] Error using PostGIS and GEOM

. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refra

Re: [postgis-users] troubles installing PostGIS

last message didn't make it through either - anyone at Refractions know who the list moderator is? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 87

Re: [postgis-users] troubles installing PostGIS

r contain this change. The reason that you see the error at the moment is, of course, because your current PostgreSQL instance already has the libiconv-2.dll file open for its own use. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation

Re: [postgis-users] troubles installing PostGIS

various permissions errors coming up on the list, but so far I haven't been able to find out enough information in order to determine what is going wrong. Does the NSIS installer log (appears at the end of the wizard) provide any useful information at all? ATB, Mark. -- Mark Cave-A

Re: [postgis-users] ST_AsSVG crashes with large/complex geometries

g that might be fixable? Thanks for any advice, Mike Hi Mike, Yeah, that sounds like a bug. What versions of PostgreSQL/PostGIS are you using? You may want to open a bug with a sample geometry on the PostGIS bugtracker. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Sour

Re: [postgis-users] Installing postgis from an NSIS installer

is fairly easy to find out what is going wrong by running these files manually. 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

Re: [postgis-users] Re: Mapserver layer selects - resolved

was not being set at the start of an index scan, which would affect tuple visibility. 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] Installing postgis from an NSIS installer

Hi Yves, You can download a zip-file containing the GPL'd source for the Win32 installer from here: http://pgfoundry.org/frs/?group_id=1000256&release_id=1274. This should then answer all your questions :) HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [postgis-users] still problems with Mapserver and MULTIPOLYGON layer

expectedly terminated the connection, and not the server. 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.refraction

Re: [postgis-users] Error installing PostGIS 1.3.5 on Windows Server 2003 Enterprise R2

o the PostgreSQL installation directory. 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

Re: [postgis-users] Re: Test the Future (GEOS 3.1RC2)

ig=/c/path/to/mingw/pg_config option. 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.refraction

Re: [postgis-users] Re: Test the Future (GEOS 3.1RC2)

the PostgreSQL people will support. 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.refracti

Re: [postgis-users] Call for Semantics (ST_CollectionTypes())

t an idea of exactly what these proposed functions are trying to achieve. Can you show some potential problems/SQL statements showing how you would envisage these functions being used? ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The

Re: [postgis-users] Shapes to PG

Regards Hi Neil, Well, the shapefile provider should tell you what encoding they've supplied the data in as it's a property of the data. However, LATIN1 or LATIN9 are quite common choices - simply use the -W flag for shp2pgsql to specify the shapefile encoding and see if you get a

Re: [postgis-users] distance query is not returning expected result

4326), 27700), ST_Transform( ST_SetSRID(ST_Point(-1.784876, 53.6451179), 4326), 27700) ) / 1000; which returns: ?column? -- 23.1860213462966 (1 row) HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Ope

Re: [postgis-users] buffer(the_geom, 0) crashes the database

y help. 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] buffer(the_geom, 0) crashes the database

te table, then posting just the SQL part may allow people to help you. 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.r

Re: [postgis-users] lspostgis.sql shows errors

stGIS installation, and what does the definition for the geometry_dump() function look like in lwpostgis.sql? 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] lspostgis.sql shows errors

st be logged in as the database superuser (normally postgres) in order to load lwpostgis.sql. Incidentally you really should be using 1.3.5 rather than 1.3.3; 1.3.3 contains some very nasty bugs and memory leaks. HTH, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts

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

al/lib ./configure" when 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

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

quot; in the DATA clause 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

Re: [postgis-users] Strange behaviour with st_difference

get the output of "SELECT 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 po

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

ng from certain clients to certain databases. 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

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

_geom)" "Filter: (selected_geography.the_geom && geography.the_geom)" Please can we see the EXPLAIN ANALYZE rather then just EXPLAIN of the above query? This will give extra information showing where the time is being spent during query execution. ATB

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

more people... 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 __

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 F

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

verything etc. 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

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

y-one. 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

Re: [postgis-users] ST_AsKML changes in 1.3.3

t the renaming brings 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 ___

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

n your Vista box to get 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

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

afraid I do not have 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 ___ p

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

x27;t see 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 lis

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

.4 causing segfaults :( The patch you need is very simple and can be found here: http://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,

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

is this? Since the error message in question is only in the lwcurve curve, 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 Corporatio

Re: [postgis-users] Postgres/PostGIS and date field

s: select the_geom .. (end_date - now() >= '10 days'::interval) as green and (end_date - now() < '0'::interval) as red from I'm not sure exactly what units you were using, but you should be able to work with the example above to get what you want.

Re: [postgis-users] Curve polygon

ut I guess 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.sirius

Re: [postgis-users] 1.3.4rc3 regression failure

.5 0.5 2,9.5 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:

Re: [postgis-users] 1.3.4rc3 regression failure

.5 0.5 2,9.5 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 Ca

Re: [postgis-users] PostGIS 1.3.4 RC3 released

Paul... 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] Get concave hull from an array of longitude in latitude points

lygon 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 C

Re: [postgis-users] PostGIS 1.3.4 RC3 released

Incidentally I 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 _

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

don't 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-Ayl

Re: [postgis-users] PostGIS 1.3.4 RC3 released

finishing this until later this evening. 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.

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

as +/- 0 are separate numbers in IEEE-754 floating 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 __

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

osed to a bottom-left origin point used 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 pos

Re: [postgis-users] ST_AsKML changes in 1.3.3

e #ifdef section which 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 Corpora

Re: [postgis-users] PostGIS 1.3.4 RC3 released

.0 a minimum requirement - this would 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 _

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

Re: [postgis-users] PostGIS 1.3.4 RC3 released

hack 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 Ex

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 t

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

know what you're doing. In terms of the upgrade, 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

Re: [postgis-users] PostGIS 1.3.4 RC3 released

ged in RC3 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

Re: [postgis-users] PostgreSQL 8.3 GiST Bug

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] PostGIS 1.3.4 RC3 released

/tmp/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

[postgis-users] PostGIS 1.3.4 RC3 released

forms, 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

postgis-users@postgis.refractions.net

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

Re: [postgis-users] pgsql2shp problem

( Some PostgreSQL on Windows 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:/

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

ies that the restriction is related to functions that determine whether one thing is within another. Hmmm. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mail

Re: [postgis-users] SRID confusion

rsion? If so, I would suggest creating a fresh database, loading in PostGIS, and trying your example .sql again. This is just to eliminate the chance that something has gone wrong as part of an upgrade at some time in the past. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Op

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

me orientation. Now the interesting 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:

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

re using PROJ >= 4.5, 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 _

Re: [postgis-users] Contains failing

Kevin Neufeld wrote: I don't get your results - I get TRUE in both cases. What version of postgis/geos are you running? -- Kevin Hmmm seems like the famous GEOS 3.0.0 rectangle containment bug rears its head again... :( ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open S

Re: [postgis-users] 1.3.4SVN Testers Wanted

is generated after the SVN test build, you need 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 __

Re: [postgis-users] 1.3.4SVN Testers Wanted

. 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] Installing PostGre SQL

he install. 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

Re: [postgis-users] ST_SPHEROID_LENGTH SLOW

bloat 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-use

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

53125 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.

Re: [postgis-users] The_geom is empty

metries above 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 __

Re: [postgis-users] st_box2d

- BOX(-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 pos

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

ed procedures was restricted to stop people from overriding 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 C

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

ounds 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/lis

Re: [postgis-users] st_box2d

t describe 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: +

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

should be. 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] Comparing Geometries with Different SRIDs

ink ST_EQUALS should return false here, not blow up. Me too. Having a function to check equality that blows up rather than returning a false result when two inputs are unequal seems fairly silly to me. Charlie, would you like to file this on the PostGIS bugtracker? Many thanks, Mark. -- Mar

Re: [postgis-users] Comparing Geometries with Different SRIDs

nt entries are equal. Hence why UNION will fall over while UNION ALL passes with flying colours. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailin

Re: [postgis-users] ST_SPHEROID_LENGTH SLOW

e you definitely 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

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

OS/hardware is just plain 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.

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

ry_columns 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.refraction

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

l-1.3/ch02.html. 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/listin

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

://postgis.refractions.net/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-use

<    1   2   3   4   5   6   >