Re: [postgis-users] No index usage on geography query plan?

FromText('SRID=4326;POLYGON((116.751709 -31.381779,116.883545 -32.676373,114.741211 -32.796510,114.796143 -31.316101,116.751709 -31.381779))'), 0.0, false) < 0.1; This should give us a better idea as to why this particular plan is being chosen. ATB, Mark. -- Mark Cave-Ayland - Senior Technical A

Re: [postgis-users] No index usage on geography query plan?

I missed the query switch somewhere in the thread ;) 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 Sirius Labs: http

Re: [postgis-users] No index usage on geography query plan?

I was outlining in this latter geometry example that a 9s intersection is not right and there is a problem with geograhies. Okay - so can we see the explain analyze output for your last query for the geography intersecting geography case for comparison? ATB, Mark. -- Mark Cave-Ayland - S

Re: [postgis-users] No index usage on geography query plan?

table but with a geography instead of geometry column for border, and you should see an improvement. 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 Sirius Labs: ht

Re: [postgis-users] No index usage on geography query plan?

ersion of PostGIS you are using. What does the output of: SELECT version(), postgis_full_version(); return? 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 Sirius La

Re: [postgis-users] No index usage on geography query plan?

. 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 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing lis

Re: [postgis-users] Problem with probe_geometry_columns()

H. Do you have multiple schemas in your database/PostGIS installation? Or have you tried to install PostGIS into a specific schema? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom

Re: [postgis-users] Bug or Problem with st_transform

transformation code had a good tidy up and some logic corrections within that timeframe, including better reporting of error messages. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.u

Re: [postgis-users] implement your own index

ttp://www.sai.msu.su/~megera/postgres/gist/ can be used as an aid to generate output suitable for rendering. 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 006

Re: [postgis-users] PostGIS 1.5.1 causing postmaster crash on index creation

causes the error... Paul If it's some kind of memory clobbering bug, then perhaps changing endian will make a difference. Has anyone tried this on a large endian architecture? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control

Re: [postgis-users] Nested loop join = very bad performance

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

Re: [postgis-users] shp2pgsql in quite mode????...(shp2pgsql -q)???

or shp2pgsql ... 2>&1 > /dev/null 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 Sirius Labs: http://www.sirius

Re: [postgis-users] Nested loop join = very bad performance

any of the settings in postgresql.conf from their defaults? 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 Sirius Labs: http://www.siriusit.co.uk/labs

Re: [postgis-users] Make install failure in PostGIS-1.5.1

apply the attached patch and then re-run "autoconf" to generate a new configure file that should work correctly. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.u

Re: [postgis-users] Missing postgis_config.h

from the archive. Should I do the same as well, or might there be another issue? Hi Dan, postgis_config.h is generated by running configure. What does the output of the configure command look like? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius

Re: [postgis-users] ESRI Shape to Postgres

database in order to spatially enable it, as per http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2797624. 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

Re: [postgis-users] ESRI Shape to Postgres

r for us to help you. 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 Sirius Labs: http://www.siriusit.co.uk/labs ___ po

Re: [postgis-users] postgis upgrade 1.4 to 1.5 sql file couldn't find $libdir/postgis-1.4

.deb packages you are using to find out why this is failing. 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 Sir

Re: [postgis-users] ESRI Shape to Postgres

more likely that someone will be able to help you. Note that the in-built postgres database is for maintenance/administration only - you need to create yourself a new database and load postgis.sql into it, as per the manual here: http://postgis.refractions.net/documentation/manual-1.

Re: [postgis-users] Postgis 1.3.7 wit PostgreSQL 8.4. (64bit) on OpenSolaris

nd you need to make sure that LD_LIBRARY_PATH is being set for the postgres user as you start the database, and not just the user you are logged in as. You may need to alter the /etc/init.d/postgresql script in order to do this. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect

Re: [postgis-users] [postgis-devel] Has anyone seen this before?

request size 18446744073709551613 Yup, this is totally wrong. I suspect bad RAM and/or disk on the machine in question. 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] Postgis on AIX

ory and can't use it until I fix this :-) Nice :) 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 Sirius Labs: http:

Re: [postgis-users] strange benchmark results

resented on your web pages. 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 Sirius Labs: http://www.siriusit.co.uk/labs _

Re: [postgis-users] Installing PostGIS-1.4.1

e missed just one thing after your PostGIS setup: psql -d gis -f spatial_ref_sys.sql Once you've done this you should then be able to see the entries in the spatial_ref_sys table with "select * from spatial_ref_sys;". HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect Post

Re: [postgis-users] strange benchmark results

ilder on Windows and compiled everything from source on debian. As you point out, the PROJ library shouldn't be called for the example queries you are giving and so I wouldn't expect this to have much of an effect yet. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect Postgr

Re: [postgis-users] st_summary meanings

;; if ( TYPE_HASBBOX(type) ) flags[flagno++] = 'B'; if ( TYPE_HASSRID(type) ) flags[flagno++] = 'S'; 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] st_equals strangeness

here. I believe this part should be removed from the function. 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 Sirius L

Re: [postgis-users] st_equals strangeness

es does not. P Again, another demonstration as to why BOX2DFLOAT4s should never be used for calculations and only for internal "within" checks :( ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom ht

Re: [postgis-users] Problems compiling Postgis from source in Ubuntu 9.10

Dave Potts wrote: Mark Cave-Ayland wrote: Has anybody read this web page ? http://workingonnothing.blogspot.com/2009/08/setting-up-ubuntu-server-installig.html Its somebodies successful attempt to install postgis 1-4.0 using the installed version of 8.3 on ubuntu Jaunty Dave. Hmmm

Re: [postgis-users] Problems compiling Postgis from source in Ubuntu 9.10

ll a machine from scratch :( Glad that you managed to get it all installed though. 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 Sirius L

Re: [postgis-users] strange benchmark results

i.e. slowly increasing query times. I'd also be interested to see your results of just Test 1 on a Linux OS too to see whether it is an OS specific issue that you are seeing. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation

Re: [postgis-users] Problems compiling Postgis from source in Ubuntu 9.10

packaging as it seems to catch a lot of people out... 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 Sirius Labs: http://ww

Re: [postgis-users] Seeing the value of a geometry string before an error message is issued.

untime-config-logging.html#GUC-LOG-STATEMENT for more details. 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 Sirius Labs:

Re: [postgis-users] Getting the exact extent of a geometry

non aggregate function which returns the exact extent (float8s) of a geometry? If not, why not? Because it's a bug ;) 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] strange benchmark results

ticular, this will confirm which versions of GEOS are being used in each setup. 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 Sirius Labs: http://www.siriusit.co.uk/

Re: [postgis-users] Getting the exact extent of a geometry

try)); Thanks, Pierre Uggg. Nothing should *ever* return the contents of a BOX2DFLOAT4 back to the user. If ST_Envelope() does, then this is definitely a bug. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http:/

Re: [postgis-users] PostGIS 1.4.1rc2

.a into libpostgis.so, but that doesn't seem to work. Clearly I need to look into this further, but would like to know the plan so I can understand where my build is going wrong Is there supposed to be a liblwgeom.a installed? Where? Nope - it's currently a static library and so ge

Re: [postgis-users] Cannot install 1.4.0 as non-root user

; on PostGIS so that the directory containing the pg_config you really want to use is listed first like this: PATH=/path/to/8.2/install:$PATH make install HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www

Re: [postgis-users] Length of Bigint, Double and Text fields

ctually clarify these changes with regard to parts of the official shapefile spec, or have they been found purely through experimentation? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.c

Re: [postgis-users] identifying blank geometry fields

(I can't remember if it's 32K or 64K at the moment). If you try the same query from the command line in psql, you should be able to see your geometries without any problems. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation p

Re: [postgis-users] How to use AddBBox function

ly by PostGIS so you don't need to worry about it. In the 1.4 manual it's listed under "Exception Functions" which really means you don't want to be using it unless you're a developer. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostG

Re: [postgis-users] St_LineToCurve error, geometry requires more points

S 1.4 if you wish to trace through it yourself. 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 Sirius Labs: http://www

Re: [postgis-users] Can we use PostgreSQL/PostGIS without Python?

ssing the Python development packages from your system - if you install them, then the build should proceed normally. 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

Re: [postgis-users] Why can't PostGIS ./configure find libgeos_c ??

Mark Cave-Ayland wrote: Actually the original poster is right, and the message is not particularly clear. Let me see about changing it... Hmmm I think the original poster has misquoted the message. According to SVN, if geos-config can't be found in the current path then the error me

Re: [postgis-users] Why can't PostGIS ./configure find libgeos_c ??

en you'll need to look at config.log which is generated when you run configure. Note that if it's large, it makes more sense to upload the contents onto a pastebin somewhere and send just the link to the list. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostG

Re: [postgis-users] Why can't PostGIS ./configure find libgeos_c ??

age is not particularly clear. Let me see about changing it... 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 Sirius Labs: http://www.siriusit.

Re: [postgis-users] Best (safest) postGIS version for postgreSQL 8.3.5?

x27;t work with PostGIS, but if you go with the versions above, you should be fine. 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 Sirius Labs: http://www.siriusit.

Re: [postgis-users] Unable to build WKT Raster

there? PGXS makes use of the DESTDIR variable for installation, so for a relocated install all you need to do is: ./configure make DESTDIR=/path/to/output install HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom

Re: [postgis-users] Problem building PostGIS 1.4.0 on Ubuntu 9.04 (missing pgxs.mk)

tion which doesn't contain the files required for building PostgreSQL modules. Installing the postgresql-server-dev package should resolve this. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.s

Re: [postgis-users] aggregate functions

older version of PostGIS went wrong in the past, rather than being a vanilla new install. Does this sound like it could be your situation? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t

Re: [postgis-users] make install problem in v. 1.4.0 as well as in 1.4.1.SVN

in a separate target. However, a manual "make install" in the docs/ directory should attempt to put things in the right place for you - if it doesn't, then please let us know. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation

Re: [postgis-users] NAD conversion problem

also agree with Frank that this is something that you want to be very careful with. 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

Re: [postgis-users] trouble getting nearest neighbor with ST_DWithin and ST_Distance

oads table which is why it seq scans. Assuming that all the geometries in your roads table are SRID 9102003, then as a starting point, the following query should be quick: SELECT * FROM roads WHERE ST_DWithin(roads.the_geom, GeomFromText('POINT(-2026631.3499604 135

Re: [postgis-users] shp2pgsql encoding problem - Thai Language

to a UTF-8 encoded database without any problems. I do agree that the documentation on this is a little vague though (I had to refer to the source to see what was happening...) ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control throu

Re: [postgis-users] srid on wkb

ing the ouput above, your input geometry has a SRID of *4236* whereas your dwr_well table has a SRID of *4326*. Looks like an accidental typo in your application somewhere... HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc

Re: [postgis-users] PostgreSQL 8.3.8 and 8.4.1 out

. 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 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing

Re: [postgis-users] SRS Table Upgrade documentation

or a new installation), while the table content is in spatial_ref_sys.sql. So the short answer is to copy/paste the spatial_ref_sys table definition from postgis.sql into psql/pgAdmin and everything should work fine. I'm not necessarily sure that this is a bug, however it doesn't se

Re: [postgis-users] compiling agains GEOS-3.1.1

u send me the generated config.log file off-list, and also let me know which version of autoconf you are using (autoconf -V)? TIA, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +4

Re: [postgis-users] postgis.sql

up script to ensure that LD_LIBRARY_PATH is being set correctly for the postgres user when PostgreSQL is launched. 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 Si

Re: [postgis-users] postgis.sql

e. So you can either tweak your PostgreSQL startup script to include a LD_LIBRARY_PATH=/usr/local/lib declaration (assuming you used the defaults when you built GEOS/PROJ.4), or tweak /etc/ld.so.conf with the relevant locations and then re-run ldconfig. HTH, Mark. -- Mark Cave-Ayland -

Re: [postgis-users] Points and lines

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

Re: [postgis-users] Points and lines

to change to contents of a single row. 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 Sirius Labs: http://www.siriusit.co.uk/labs __

Re: [postgis-users] opensolaris 2009.06

directory on the "gmake" command line if required. Incidentally, I don't see any errors in your output, so it's a bit difficult to understand what the problem is... ATB, M-D. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Siri

Re: [postgis-users] PostGIS test failures

ed something in the new build system. Feel free to post the output of "make" and the various regression diffs as as starting point. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusi

Re: [postgis-users] functions st_covers, st_coveredby, st_simplifypreservetopology does not exist

/local/bin:$PATH ./configure 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 Sirius Labs: http://www.siriusit.co.uk/labs

Re: [postgis-users] functions st_covers, st_coveredby, st_simplifypreservetopology does not exist

geos-config executable in the current path. So the quick check would be: geos-config --version 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 Sirius Labs: http

Re: [postgis-users] Acces to grid creation functions ?

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 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-

Re: [postgis-users] functions st_covers, st_coveredby, st_simplifypreservetopology does not exist

ision) does not exist -bash-3.2$ Any ideas why last script fails? Hmmm maybe the postgis_comments.sql generation script doesn't take into account that you are using an older version of GEOS (pre 3.1)? Regina? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - Post

Re: [postgis-users] How to deal with linestring that is not simple (OGC compliant)

n some test data so that you can verify the results. 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 Sirius Labs: http:

Re: [postgis-users] Acces to grid creation functions ?

PostgreSQL generate_series() function. 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 Sirius Labs: http://www.siriusit.co.uk/labs _

Re: [postgis-users] Acces to grid creation functions ?

oGrid() depending the input geometry type (i.e. they are equivalent), so I'm not sure I understand what you're trying to do? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 6

Re: [postgis-users] Strange result about spatial indexes?

from here: http://cid-40b8dee7bf5b661f.skydrive.live.com/self.aspx/.Public/data.tgz Great, thanks for this! I'll see if I can find some time over the weekend to find out what's happening in this test case. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - Post

Re: [postgis-users] Version mismatch

3? PostgreSQL is complaining that the binary module is compiled for PostgreSQL 8.3, whereas your server version is PostgreSQL 8.4. You need to either find PostGIS packages for PostgreSQL 8.4, or build it yourself from source - the 1.4 manual has a really helpful section on this. HTH, Mark.

Re: [postgis-users] PostGIS on Solaris 10

strong arguments for not doing 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 0063 Sirius Labs: http://www.siriusit.co.uk/labs

Re: [postgis-users] PostGIS on Solaris 10

probably work, but that's so old I'm afraid you're on your own with that one... ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +

Re: [postgis-users] Creating compoundcurve

Paul Ramsey wrote: Good question. An arc requires at least 3 points, but a linestring does not. Mark? I'm assuming you mean Mark L here, but just in case you don't then I agree that this is a bug ;) ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - Post

Re: [postgis-users] ST_Union (8.4) and TopologyException

ST_Union() in 1.4, does that mean that your query worked in 1.3? And secondly, which version of GEOS are you using? ( SELECT postgis_full_version(); ) ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] shp2pgsql not working

inations then it's just a standard file permissions issue. Check your file permissions carefully. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t

Re: [postgis-users] liblwgeom is missing after postgis 1.4 build

Suhr, Ralf wrote: Hi Otto, the libraryname has changed from liblwgeom.so to postgis-1.4.so. Gr Ralf Ralf is correct, although as before, "make install" will do all the magic for you... ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius C

Re: [postgis-users] Returning multiple fields from a plpgsql function

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

Re: [postgis-users] postgis 1.4 and curves

done :( 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.refraction

Re: [postgis-users] Issue with BOX3D and distance

ches your area of interest, then that should give you the best overall performance. 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 1.4 and curves

1.951 121025.188) (1 row) (Note that there are some small rounding errors since the CIRCULARSTRING conversions occur in different places, but again remember that these conversions are lossy) HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius C

Re: [postgis-users] postgis 1.4 and curves

, however we can't really help you much without a test case :) 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 ___ po

Re: [postgis-users] shp2pgsql Solved

en 8.2/8.4 Leo Hmmm this looks like the issue we had a while back, whereby the pgis_getopt()/getopt() function struggles on some platforms - although I thought Paul's last set of fixes had resolved this :( ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL -

Re: [postgis-users] postgis1.4.0 installation errors on pgsql8.4.. Solution

e misunderstood the part about how to extract the binaries into the PostgreSQL installation directory... 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 _

Re: [postgis-users] Issue with BOX3D and distance

of data in your tables. So the only way to get a feel for real performance is to load in a reasonably large representative dataset and then start digging into performance issues... HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - contr

Re: [postgis-users] How install postgis 1.2.1 with PostgreSQL 7.3.7 ?

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

Re: [postgis-users] postgis newbie install

mentation/manual-1.3.7SVN/ch02.html#PGInstall from step 7 onwards for what you need to do. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.

Re: [postgis-users] Memory usage optimized for postgresql/postgis

reSQL memory tuning guide. There is a reasonably good explanation of the various parameters in the manual itself, but otherwise there are plenty of resources available to find using Google. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporatio

Re: [postgis-users] Postgis - Line to Point distance

r way around? Nope. PostGIS uses the computer standard of X followed by Y. Hence for "POINT(X Y)", X is longitude (or eastings) and Y is latitude (or northings). This is true for all PostGIS functions, and I believe is the same for all spatial databases too. ATB, Mark. -- M

Re: [postgis-users] add geos after installing

rd "configure; make install", the extra routines should be 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] The EWKB/EWKT specs should be part of the PostGIS manual

m this smells like a bug. Are you working with 1.4 or 1.3? Can you post a specific test case for us to look at? Many thanks, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk

Re: [postgis-users] Moving to SpatiaLite: best practice

/postgis/ticket/123 Note that this patch won't apply "as-is" since the string-escaping parts have already been applied to SVN trunk. Shouldn't be too far off though... HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation p

Re: [postgis-users] Coordinate changes using transform from 1.3.1 to 1.3.6

irm that the spatial_ref_sys entries for 23029 and 4326 are identical between the two servers? 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 __

Re: [postgis-users] Postgis upgrade

? I don't recognise the ST_AsUKML() variant, but the others still exist in 1.3.5 but with different function signatures (related to number of parameters). HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through fr

Re: [postgis-users] Postgis upgrade

a liblwgeom.so.1.2 in the PostgreSQL lib directory? Another question. Is there a way to check if my Postgis is ok after upgrade ? No official way at the moment, other than running the regression tests. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sir

Re: [postgis-users] Postgis upgrade

. This guarantees that the SQL definitions and the PostGIS shared library are always in sync. 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 upgrade

uot; described in "Hard upgrade" in postgis documentation. Is is important ? Are missing functions important ? I'm not sure what you mean here as I don't see any references to cleaning in the current manual? ATB, Mark. -- M

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

ut not to the database server. 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@

<    1   2   3   4   5   6   >