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

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 e

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

x27;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 Archi

Re: [postgis-users] pgsql2shp

ble to try 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 throu

Re: [postgis-users] character encoding problems

uld highly recommend that you 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

Re: [postgis-users] Workaround for "transform: couldn't project point" error?

e run into it. Hi Evan, The "couldn't project point" message isn't being caused by PostGIS at all - PostGIS is simply passing back the error message from the PROJ.4 library. Do you see the same error when using the proj executable to project the same point manually? A

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

ve 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 Co

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

ANALYZE output 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 -

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

7;t, perhaps you're 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:

Re: [postgis-users] shp2pgsql nulls

h yes - that looks like an ogr2ogr bug. Never mind. 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.s

Re: [postgis-users] shp2pgsql nulls

000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |0 | 20 | 20 |0 | 0 | | 0 | (1 row) That seems to indicate that the recorded date field is set to NULL as intended? This is using the c

Re: [postgis-users] shp2pgsql nulls

geometries to understand what's going on here. Also you didn't mention which version of shp2psql you are using, as there has been a lot of work done there in recent times. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - con

Re: [postgis-users] pgsql2shp

de an example shapefile for us to look at? And also which version of PostGIS/shp2pgsql 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 Siri

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

n that would 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 Corpo

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

nding some kind of build infrastructure. For example, I think it would 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 p

Re: [postgis-users] compile on solaris 11 sparc

and PostGIS on your 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

Re: [postgis-users] compile on solaris 11 sparc

#x27;s compiler is though. I think we need to start thinking about ripping the CPP code out and finding something more suitable instead, particularly when thinking about building other platforms such as Win32/64. I'm not exactly sure what the replacement should be though

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

you which version of GEOS your custom-built PostGIS 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

Re: [postgis-users] PostGIS 2.0 installation error

you just need to "svn up" to a newer version (although there are still some outstanding regression errors here that need Paul's attention). The output of configure should show you exactly which versions of various components have been detected if that helps at all? ATB, M

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 Tech

Re: [postgis-users] PostGIS 2.0 installation error

information at : http://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 Cav

Re: [postgis-users] Optimise this query, point in polygon on quite a large scale

x27;s likely you'll be looking 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 - PostG

Re: [postgis-users] PostGIS 2.0 Install Error

does "ldd /usr/pgsql-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:

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

a simple ENV setting. 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 Ar

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 th

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-devel] Infinite loop in st_intersects - because of incorrect data out of st_transform?

/029125.html for the relevant thread. If you could follow this up on the PROJ.4 list, that would be greatly appreciated. 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-1.5.2 build failure on HP-UX

tem I started working on a while back... 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 subject)

t first, and/or use 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 htt

Re: [postgis-users] Strange problem building postgis 1.4.2 with geos

0 All looks good, so we build ... 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,

Re: [postgis-users] (no subject)

e 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 ___ post

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

;s on any of the PostGIS lists. 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 -- This message has been scanned for viruses

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

d be absolutely fine to build and install as the postgres user. It seems to me 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.sir

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

ally 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://www.sirius

Re: [postgis-users] postgis 2 installation failing

A.out (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. -- M

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

basic 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 -

Re: [postgis-users] Increase query performance

take a look at 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 ___ postgis-

Re: [postgis-users] Securing postgis

() and DropGeometryColumn() 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 - con

Re: [postgis-users] Securing postgis

ably 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.siri

Re: [postgis-users] speed of query

has to convert 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 Corporatio

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

nds that were executed. 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 ___ post

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

a PostGIS bug because we should detect this condition and fail the transformation with a suitable error. Frank - what's your take on this? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freed

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

Re: [postgis-users] ST_DWithin Performance

, we'd need a lot more information than this - in particular the schema of the tables (\d in psql output) and the EXPLAIN ANALYZE of the slow query would be the bare minimum information you'd need to provide. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL

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 lis

Re: [postgis-users] Core dumps

invalid) geometry. If you can find the offending geometries and post the WKT/WKB here, we should be able to fix this reasonably easily. 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] r tree bulk loading algorithm

ink anyone is actively working on this. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.

Re: [postgis-users] Why use C procedurals for Postgres

...OWNER... to change 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:

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

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

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

On 01/01/11 17:16, Paul Ramsey wrote: On 64bit machines it works. P. Does changing int to unsigned int work too? That would seem to be a more sensible change. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

one of the developers to test and commit. 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://ww

Re: [postgis-users] query error when combining UPDATE, CASE and WHERE

me? You probably want something along the lines of this (untested so please check it first): update table1 set book = (select case when price > 200 and price < 400 then '40' else book end) where catalog = '112'; HTH, Mark. -- Mark Cave-Ayland - Senior Technical A

Re: [postgis-users] Null value when inserting large linestrings or multilinestrings in windows

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

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

issue is raised/fixed there and then we can just resync once 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 Sirius Labs: http://www.siri

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 -

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

ark. -- 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-us

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

r "I can't find the right 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

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

learn more 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.sirius

Re: [postgis-users] pgsql2shp - No GID variable

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

Re: [postgis-users] pgsql2shp dbf file encoding

s of how 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

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

Re: [postgis-users] pgsql2shp dbf file encoding

nts? 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 li

Re: [postgis-users] issue while building postgis-1.5.2 with pg-9

settings somewhere, but you'd need to ask someone who 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: +

Re: [postgis-users] issue while building postgis-1.5.2 with pg-9

security-cookie-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.siri

Re: [postgis-users] shp2pgsql 1.5 is crashing

penEV 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 -

Re: [postgis-users] bad formed wkt from shp2pgsql

In previous versions it didnt happend to me. dont know..maybe this is already fixed in the 1.5.2 version. Best, Jose Hi Jose, Yes, this is fixed in 1.5.2. See http://trac.osgeo.org/postgis/ticket/603 for more information. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Arch

Re: [postgis-users] query gist bbox

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 - S

Re: [postgis-users] refractions web site

d I'm 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.

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

formation back to the user (or to a logfile). 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] Size of .dbf file produced with pgsql2shp

test from bash: pgsql2shp -f dagestan.shp "SELECT 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 thro

Re: [postgis-users] pgsql2shp revision

release process?). It's not a great solution, 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 Sir

Re: [postgis-users] pgsql2shp revision

e it is re-used 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 Corpor

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 functio

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

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 :( Will fix later, as I have to head out now. ATB, Mark. --

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

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

essed? 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] Size of .dbf file produced with pgsql2shp

y how the new code in trunk currently works - you 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 Tech

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

ue to 226 or this is a bug? 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?

Re: [postgis-users] pgsql2shp fails

you do an "svn 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

Re: [postgis-users] pgsql2shp fails

ther apparent bug is that I forgot to set the svn id property on pgsql2shp-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 throu

Re: [postgis-users] Shape file importer. broken multipolygon

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

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

e provided 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: +

Re: [postgis-users] FME and Postgis-SVN problems

GUC in postgresql.conf 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:

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

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

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 S

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

breaking 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 ___ pos

Re: [postgis-users] shp2pgsql

ndows 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

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

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

taining a few 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

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

d is using permanent a "not st_isEmpty) in the where clause. Thank you, Sorin Hi Sorin, In order to debug this, we need much more information such as the versions of PostgreSQL/PostGIS you are using and a simple, reproducable test case. ATB, Mark. -- Mark Cave-Ayland - Senior Tech

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

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

ll_version --- 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 - Seni

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

e relevant 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 Corpo

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 Postgre

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

a transaction, 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

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

x.so.2 (0x8000) Looks as if there is a GEOS v2 already 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.siriu

  1   2   3   4   5   6   >