Re: [postgis-users] pgsql2shp

On 03/07/12 07:14, James Sewell wrote: Hello, When I run pgsql2shp like so: pgsql2shp -u plm25 -g the_geom database table I get the following output: Xcolumn number -1 is out of range 0..1 column number -1 is out of range 0..1 column number -1 is out of range 0..1 column number -1 is

Re: [postgis-users] Super weird problem: Cannot insert more than ~300 rows (or ~100 kb) into a table

On 03/07/12 12:34, René Fournier wrote: Well, I did some more testing, and found out that the failed query and subsequent crash of the postgresql client isn't caused by the lat/lng coordinates... It happens consistently after a certain number of rows (and/or amount of data) is inserted into the

Re: [postgis-users] Super weird problem: Cannot insert more than ~300 rows (or ~100 kb) into a table

On 03/07/12 13:20, René Fournier wrote: So, it seems that the table gets full and corrupted to some extent. After my import script inserts ~290 rows, and then postgres crashes... mydb=# select count(*) from addresses;INSERT INTO addresses ( account_id, territory_id, location ) VALUES (

Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install

On 07/06/12 14:00, Donald Kerr wrote: Thanks, Regina. After uninstalling, I tried a fresh install of PostgreSQL followed by a fresh install of PostGIS. The difference this time is that I did not use the existing data structure and started with a new one. The installation went well and without

Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

you think it's not redundant to ticket #660? Oops, It would. Sorry! I've just committed this feature to SVN trunk as r9027. Unfortunately due to the difference in architecture, it's not going to be possible to backport to 1.5. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect

Re: [postgis-users] pgsql2shp

pgsql2shp from one of the PostGIS 2.0 pre-releases at all? It's had a fairly hefty rewrite and so you might find that this will have solved the issue. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] character encoding problems

don't do this, since then you end up with data in a mixture of random encodings that you will never be able to output correctly across all platforms. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] ERROR: Operation on two geometries with different SRIDs

the EPSG prefix in front of it, e.g.: shp2pgsql -s 26191 -I -D morocco.shp morocco morocco.sql This should generate you a file with the SRID 26191 which should load without any further issues. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc

Re: [postgis-users] Indexes used in 1.3.3 but not in 1.5.3

if you want more help with this one. Also note that just because an index is there, it may not always be used because sequential scans can be used in a lot of cases. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through

Re: [postgis-users] Trouble with shp2pgsql-gui?

trying to load the data into a database that isn't PostGIS enabled? 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-devel] Vote On Project Sponsorship

be good. I'm tempted to vote +1, except for the fact that I know that I would be struggling to find any extra time to put into the management side of this... maybe a +1 in principle? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control

Re: [postgis-users] [postgis-devel] Vote On Project Sponsorship

be useful to fund Win32 and Win64 cloud instances so that I can help Regina with the Windows builds when she gets stuck. 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] compile on solaris 11 sparc

server should give you something that would work. 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] compile on solaris 11 sparc

when thinking about building other platforms such as Win32/64. I'm not exactly sure what the replacement should be 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

Re: [postgis-users] ERROR: could not find function isvalidreason in file /usr/local/postgresql-8.2.20/lib/postgis-1.4.so

is built against. 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 2.0 installation error

On 03/07/11 23:12, Denis Rykov wrote: I'm using PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit Hmmm. And no copies of 9.1 beta anywhere on that box either? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect

Re: [postgis-users] PostGIS 2.0 installation error

://gis.stackexchange.com/questions/11759/postgis-installation-error That's a strange error - it almost implies that a PostgreSQL 9.0-only macro has been used somewhere in the source code. Which version of PostgreSQL are you building against? ATB, Mark. -- Mark Cave-Ayland - Senior Technical

Re: [postgis-users] PostGIS 2.0 Install Error

-9.1/lib/postgis-2.0.so show? 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] Optimise this query, point in polygon on quite a large scale

at a combination of a cross join based upon the operator, ST_Intersects() and a GROUP BY over a SUM() aggregate in order to generate the totals for each grid square. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom

Re: [postgis-users] Failed POST GIS on Re-boot.

. pj_set_searchpath() was something that didn't exist in the really early versions of PROJ.4 - is there a chance you could have accidentally downgraded your version of PROJ.4? What does 'proj -v' show? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation

Re: [postgis-users] statistics on a spatial index

and Teodor's gevel utility: http://www.sai.msu.su/~megera/postgres/gist/ One day we should probably think about adding something like this into the main codebase... HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through

Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

definitely recommend 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] postgis-1.5.2 build failure on HP-UX

, 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] (no subject)

a different table name for each load? I'm just wondering if you're seeing some kind of database bloat if VACUUM fixes the issue. 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] (no subject)

of this information. 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] Strange problem building postgis 1.4.2 with geos

... PostGIS was built successfully. Ready to install. That's strange. Could it be a permissions problem? Does make clean remove postgis/libpostgis-1.4.so? If so, do a configure, make and then make install and check again. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL

Re: [postgis-users] postgis 2 installation failing

(No such file or directory) make[1]: *** [postgis-2.0.so] Error 1 make: *** [all] Error 1 - The ./configure worked fine. any ideas? thanks That looks strange. I've only seen similar symptoms before when I've run out of memory/disk space when attempting a build. ATB, Mark. -- Mark Cave-Ayland

Re: [postgis-users] make generates incorrect PERL variable value on v1.5.2

if this is actually a bug or is it something about my system that caused this problem? That sounds strange. Can you show us the mangled and un-mangled versions? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] make install as root on v1.5.2

that this is either a permissions or an SELinux issue (if 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 Sirius Labs: http://www.siriusit.co.uk/labs -- This message has

Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed

Re: [postgis-users] Increase query 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-users

Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

workaround looks good, but I'd still be interested on Frank's thoughts re: whether infinity is a valid projection output point in order to determine the best place for the check. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through

Re: [postgis-users] insert to database - error

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

Re: [postgis-users] speed of query

your entire geometry column to SRID 4326 first in order to calculate the intersection, which involves scanning the entire table and converting all the geometries on the fly... ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control

Re: [postgis-users] Securing postgis

be of interest to enough people to add it somewhere to the user part of the wiki. 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] Securing postgis

() can just add/remove the column from the table directly, so this can only happen on tables for which the current role has SQL permissions. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] shp2pgsql

shp2pgsql doesn't alter the input geometries, it merely converts them to binary for storage within the database. 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] [GENERAL] How to improve this query?

, 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] Why use C procedurals for Postgres

the ownership of your tables back to your normal (non-super) user. 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] Build PostGIS 1.5.2 under Windows

if you do manage to get any further please do update the wiki with your progress. Is there any particular reason that you can't use the MingW builds? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] Build PostGIS 1.5.2 under Windows

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] Null value when inserting large linestrings or multilinestrings in windows

this on the pgadmin-support list (see http://www.pgadmin.org/development/list.php for more information). 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] import shape or sql to postgres automatically

for maintenance and shouldn't be used to store user data. Can I write this code to php? Indeed - you'll need to look at the exec() function. Don't forget to escape your shell characters for security. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius

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

version or ??? Thanks! There was a bug in PostGIS 1.5.1 that would probably cause this error (related to the change in version number from PostgreSQL 8.5 to 9.0). Can you confirm that you are using PostGIS 1.5.2? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS

Re: [postgis-users] import shape or sql to postgres automatically

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

[postgis-users] PostGIS training courses @ PGDay EU 2010

in-depth about PostgreSQL/PostGIS but also to meet other users developing their own applications. Looking forward to seeing you in Stuttgart, 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] pgsql2shp dbf file encoding

it reacts with a .cpg file? Frank? 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] pgsql2shp - No GID variable

public.pgfinal2008 SELECT *, gid as g_id FROM pgfinal2008 Any ideas how i manage to extract the gid column from my tables? Hi Andreas, Have you tried looking at the -r option for pgsql2shp? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control

Re: [postgis-users] pgsql2shp dbf file encoding

, 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] pgsql2shp dbf file encoding

with PostGIS didn't support the encoding field), so I guess WIN1252 must be the shapelib default. 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] issue while building postgis-1.5.2 with pg-9

uses MSVC for more help. 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] issue while building postgis-1.5.2 with pg-9

-with-platform-sdk-compiler.aspx 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 1.5 is crashing

and runs through ogr2ogr without a problem. -Steve W Hi Steve, If you're not already running 1.5.2, I'd try that as I seem to remember there were a couple of bugfixes that might be relevant here. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius

Re: [postgis-users] query gist bbox

a few years ago, but it needs some work as the visibility of the bounding boxes (i.e. whether they belong to geometry that has been deleted or not) is held in the heap and not the index. Unfortunately I don't have the URL to hand at the moment. HTH, Mark. -- Mark Cave-Ayland - Senior

Re: [postgis-users] refractions web site

sure will post an update when everything is back to normal. 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] pgsql2shp revision

, but probably the least worse out of all the alternatives. 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] Size of .dbf file produced with pgsql2shp

st_intersection as geom from dagestan_point_attr WHERE highway='bus_stop' echo $? 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] pgsql2shp revision

in more than one place) then you don't see the true repository revision. Perhaps we could touch the pgsql2shp-core.h file but that just seems messy :( ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

? Checking the resulting file size is not the right way to be trying to detect whether the query returned 0 rows. It strikes me that the best way to detect this would be to return a different exit code from pgsql2shp if no rows are returned - would this work for you? ATB, Mark. -- Mark Cave-Ayland

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

get an exit code of 0 to indicate success, and an exit code of 1 if an error occurred. I was thinking of adding a new exit code of 2 to indicate success, but also that 0 records were processed. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

? 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 mailing list

Re: [postgis-users] Index on the Geometry Column and GEOMETRYCOLLECTION EMPTY

on at the moment... 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] Size of .dbf file produced with pgsql2shp

place. It looks like there is still some (old) pgsql2shp code which hasn't been updated to use the new error handling, and hence it doesn't get propagated back up to the main function correctly :( Will fix later, as I have to head out now. ATB, Mark. -- Mark Cave-Ayland - Senior Technical

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

Mark Cave-Ayland wrote: Ah wait a second, you're right - I've been looking in the wrong place. It looks like there is still some (old) pgsql2shp code which hasn't been updated to use the new error handling, and hence it doesn't get propagated back up to the main function correctly

Re: [postgis-users] pgsql2shp fails

up and confirm that it now works for you? 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 Sirius Labs: http://www.siriusit.co.uk/labs

Re: [postgis-users] pgsql2shp fails

-core.h too). What does the output of \d public.results look like in psql? 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] Shape file importer. broken multipolygon

as if this bug has already been fixed in r5195, and hence should be included from PostGIS 1.5.0 onwards. Where did you get your PostGIS binaries from? HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] Update to current shapelib

in the bugtracker and attach a patch in diff -u format against SVN 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 Sirius Labs: http://www.siriusit.co.uk/labs

Re: [postgis-users] Help in Defending FOSS SDI

are so full of lies that I can't help but feel there is a clash of commercial interest somewhere in this project. 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] FME and Postgis-SVN problems

if updating the software proves to be impossible. 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] may have postgis store limits for a big project?

that you have plenty of RAM for caching (more than 4Gb) with nice fast disks to boot. As long as the majority of your queries don't return more than a few hundred rows then I think you will be fine. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius

Re: [postgis-users] Index on the Geometry Column and GEOMETRYCOLLECTION EMPTY

it in detail. 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 mailing

Re: [postgis-users] may have postgis store limits for a big project?

a sweat :) 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] shp2pgsql

installer, and can normally be found in the PostgreSQL bin directory once the installer has been run. 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] Index on the Geometry Column and GEOMETRYCOLLECTION EMPTY

attempt to look at this over the next few days. 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 Sirius Labs: http://www.siriusit.co.uk/labs

Re: [postgis-users] shp2pgsql date quirk

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

Re: [postgis-users] Instructions on Installing Postgis on Solaris

to create a Solaris page on the PostGIS wiki containing this information? 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: make check works, but I can't manually create a spatial database

, then if you can call any PostGIS function then the installation has completed correctly. Does SELECT postgis_full_version() work for you? If so, you should be fine. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http

Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database

explicit type casts. Okay so something has gone wrong somewhere. Firstly, after make check, did you run make install? Secondly, what happens if you load the postgis.sql file into a brand new database? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius

Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database

output. The only other thing I can think of is that someone has installed another version of PostGIS into the template1 database so that it gets automatically added to any new database. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc

Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database

--- POSTGIS=1.5.0SVN GEOS=3.2.0-CAPI-1.6.0 PROJ=Rel. 4.6.1, 21 August 2008 LIBXML=2.7.6 USE_STATS (1 row) Yep; that looks good to me :) ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation

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

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

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

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

Re: [postgis-users] ERROR: could not load library /usr/local/pgsql/lib/postgis-1.5.so

installed (probably installed via a package manager) causing problems. 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] No index usage on geography query plan?

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

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

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

to install PostGIS into a specific schema? 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 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] 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] 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] 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] 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

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

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

  1   2   3   4   >