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

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 http

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

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 list

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

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

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

. 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] distance query is not returning expected result

? -- 23.1860213462966 (1 row) 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] Shapes to PG

, 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 any further. HTH, Mark. -- Mark Cave-Ayland

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

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 Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063

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

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.refractions.net/mailman

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

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

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

to 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 http

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

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

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

then answer all your questions :) 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] 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

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-users@postgis.refractions.net http

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

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 Source Experts http

Re: [postgis-users] troubles installing PostGIS

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-Ayland - Senior Technical Architect PostgreSQL

Re: [postgis-users] troubles installing PostGIS

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 plc - control through freedom http

Re: [postgis-users] troubles installing PostGIS

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 870 608 0063

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

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

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

(); 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 Cave-Ayland - Senior

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] Error using PostGIS and GEOM

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 PostgreSQL - PostGIS

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

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 608 0063 ___ postgis-users mailing list

Re: [postgis-users] writing function using C

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 plc - control through freedom

Re: [postgis-users] equal area projection

are you using? 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

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

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 postgis-users

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

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 - PostGIS Sirius

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] Shp2Pgsql - how to handle carriage returns ?

be 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] Shp2Pgsql - how to handle carriage returns ?

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

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

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 freedom http://www.siriusit.co.uk t: +44

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

Re: [postgis-users] Postgis 1.3.5 installation issue

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 Architect PostgreSQL - PostGIS

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

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 plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063

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

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

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

is missing. Note that you need to make sure that all of the dependent libraries are visible by the user that runs the PostgreSQL server; setting LD_LIBRARY_PATH in a console and using ldd will not make the libraries visible to you but not to the database server. HTH, Mark. -- Mark Cave-Ayland

Re: [postgis-users] Postgis upgrade

see any references to cleaning in the current manual? 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

Re: [postgis-users] Postgis upgrade

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 ___ postgis-users

Re: [postgis-users] Postgis upgrade

? 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 Sirius Corporation plc - control through freedom http

Re: [postgis-users] Postgis upgrade

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 freedom http

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

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 ___ postgis-users mailing list postgis-users

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 plc - control through

Re: [postgis-users] The EWKB/EWKT specs should be part of the PostGIS manual

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 t: +44 870 608 0063

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

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. -- Mark Cave-Ayland - Senior

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

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

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

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 - control through freedom http://www.siriusit.co.uk t: +44

Re: [postgis-users] postgis 1.4 and curves

:( 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.refractions.net

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] 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 Corporation

Re: [postgis-users] shp2pgsql not working

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: +44 870 608 0063

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] 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 - PostGIS Sirius

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

by the 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] PostGIS test failures

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.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http

Re: [postgis-users] opensolaris 2009.06

difficult to understand what the problem is... ATB, M-D. -- 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] Points and lines

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 ___ postgis-users

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] postgis.sql

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 - Senior Technical Architect PostgreSQL

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

)', 9102003), 50) 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

Re: [postgis-users] NAD conversion problem

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

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

, 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 plc - control through freedom http

Re: [postgis-users] aggregate functions

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: +44

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

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.siriusit.co.uk t

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

, is 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 http

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

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.co.uk/labs

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

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 - PostGIS Sirius Corporation plc - control

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 message

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

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 0063

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

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.siriusit.co.uk/labs

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

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 - PostGIS Sirius Corporation plc - control

Re: [postgis-users] identifying blank geometry fields

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 plc - control through

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

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.co.uk t: +44 870 608

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

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.siriusit.co.uk t: +44 870 608 0063

Re: [postgis-users] PostGIS 1.4.1rc2

is going wrong Is there supposed to be a liblwgeom.a installed? Where? Nope - it's currently a static library and so gets manually linked to everything that needs it. In short, you don't need to worry about this. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL

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

. 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://www.siriusit.co.uk t: +44 870

Re: [postgis-users] strange benchmark results

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/labs ___ postgis-users

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

: Is there a 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 0063

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

-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: http://www.siriusit.co.uk/labs

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

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://www.siriusit.co.uk/labs

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] st_equals strangeness

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 http://www.siriusit.co.uk t: +44

Re: [postgis-users] st_equals strangeness

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 Labs: http://www.siriusit.co.uk/labs

Re: [postgis-users] st_summary meanings

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

Re: [postgis-users] strange benchmark results

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 PostgreSQL - PostGIS Sirius Corporation plc - control through

Re: [postgis-users] Installing PostGIS-1.4.1

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 PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063

Re: [postgis-users] strange benchmark results

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 ___ postgis-users

Re: [postgis-users] Postgis on AIX

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://www.siriusit.co.uk/labs

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] ESRI Shape to Postgres

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.5/ch02.html#id2797624. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc

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

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

Re: [postgis-users] ESRI Shape to Postgres

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 ___ postgis

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] 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] Make install failure in PostGIS-1.5.1

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.uk t: +44 870 608 0063 Sirius Labs: http

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] shp2pgsql in quite mode????...(shp2pgsql -q)???

or shp2pgsql ... 21 /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.siriusit.co.uk/labs

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

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] PostGIS 1.5.1 causing postmaster crash on index creation

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 through freedom

Re: [postgis-users] implement your own index

/~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 0063 Sirius Labs: http

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

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.uk t: +44 870 608 0063 Sirius Labs: http

<    1   2   3   4   >