I am doing the same thing with success:
use my script:
cheers Markus
*
param 1: name the directory in which the files are located
param2: name of the table in which the files are loaded
*
more raster2pgHydroalp.sh
#!/bin/bash
# this script imports raster ascii file into
I just tried the following (following your example) and get the following
error:
./raster2pgsql -d -s 2273 -t 256x256 -C -F /home/rcgeoadmin/temp/979801.tif
public.testmosaic /home/rcgeoadmin/temp/979801mosaic.sql
psql -d mydb -f 979801mosaic.sql
./raster2pgsql -a -s 2273 -t 256x256 -M -F
...@postgis.refractions.net] On Behalf Of Brian Fitzgerald
Sent: Tuesday, September 11, 2012 1:10 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS 2.0 Raster Mosaic...
I just tried the following (following your example) and get the following
error:
./raster2pgsql -d -s 2273
... trying to create a raster mosaic using the raster2pgsql tool... I
imported a tif image and now I want to append a second adjacent tiff to the
first one... figured I could just run the same command with -F -I -t
256x256 etc and tack on the -a? I tried this and got an error saying:
Hi,
Glad to hear that:
bug reports are usually the main subject
Not a bug but the function behavior.
I've got to polygons
One with a hole, the second is the hole of the first.
The second is passed to the function at first. A face is created.
The first is passed to the function : no face
On Mon, Sep 03, 2012 at 08:22:25AM +0200, Christophe Vergon wrote:
Hi,
Glad to hear that:
bug reports are usually the main subject
Not a bug but the function behavior.
I've got to polygons
One with a hole, the second is the hole of the first.
The second is passed to the
On Thu, Aug 30, 2012 at 08:20:27AM +0200, Christophe Vergon wrote:
TopoGeo_AddPolygon works perfectly !
Glad to hear that:
bug reports are usually the main subject :)
--strk;
___
postgis-users mailing list
postgis-users@postgis.refractions.net
Hi,
When we try to use TopoGeo_AddPolygon an error occure the sended msg is:
St_GetFaceGeometry does not exist ???
But the St_GetFaceFunction exist in topology ... we use it.
Our problem is how to include polygons directly in a topology, those
polygons have matching points each other.
Of
Christophe Vergon
Sent: Tuesday, August 28, 2012 11:50 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Postgis 2.0 TopoGeo_AddPolygon
Hi,
When we try to use TopoGeo_AddPolygon an error occure the sended msg is:
St_GetFaceGeometry does not exist ???
But the St_GetFaceFunction exist
Hi there,
I upgraded my machine from Snow Leopard to Lion, and ran, as usual, into some
Postgres update problems.
I used Kyngchaos libraries for all frameworks and Postgres. Now, I'd like to
compile PostGIS, in order to get the postgis_restore.pl function.
I use:
export
There is no need to compile - postgis_restore.pl IS in my PostGIS package.
It's in pgsql/share/contrib/postgis-2.0.
On Jun 12, 2012, at 7:14 AM, Stefan Schwarzer wrote:
Hi there,
I upgraded my machine from Snow Leopard to Lion, and ran, as usual, into some
Postgres update problems.
I
1:29 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS 2.0 on CentOS 5
You'll need gcc-g++ among a few other things. If you want pgAdminIII to work,
it gets trickier since you have to have postgresql-9.1.
Easy solution is to get the 9.1 postgres from the PGDG repo
Anybody knows where CentOS 5 binaries are available (if they exists)?
No. Dependencies like Gdal, etc. are too old on RHEL 5.
And how hard is it to compile everything?
___
postgis-users mailing list
postgis-users@postgis.refractions.net
On Mon, 2012-05-21 at 12:18 -0400, Pierre Racine wrote:
No. Dependencies like Gdal, etc. are too old on RHEL 5.
And how hard is it to compile everything?
Compile for building RPMs? If you expect it from me (as the packager),
no, I'm not doing it :-) OTOH, I have no idea how hard it is.
That
:37 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS 2.0 on CentOS 5
On Mon, 2012-05-21 at 12:18 -0400, Pierre Racine wrote:
No. Dependencies like Gdal, etc. are too old on RHEL 5.
And how hard is it to compile everything?
Compile for building RPMs? If you expect it from me
-boun...@postgis.refractions.net] On Behalf Of Gold, Jack
L (US SSA)
Sent: Monday, May 21, 2012 1:16 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS 2.0 on CentOS 5
It's not hard to build for CentOS 5. That's where I'm running it, but I don't
use the RPMs.
-J Gold
consistent... as long as I know which is correct.
Thanks!
Jeff
From: Stephen Woodbridge wood...@swoodbridge.com
To: postgis-users@postgis.refractions.net
Sent: Friday, May 4, 2012 10:00 PM
Subject: Re: [postgis-users] PostGIS 2.0 installation problem - Ubuntu
I re-installed postgreSQL (which works fine), then tried to install PostGIS
2.0 using the Stack Builder but yet again it throws the could not load
library error. I'm also confident that all the required files are in the
correct directories.
In another thread I read about people having to delete
Hi all - apologies if this is posted elsewhere - I couldn't find anything
about it:
the postGIS2.0 README states:
To install PostGIS library and utilities, as postgres run::
make install
But, make install requires su privileges (in order to create certain
directories) and the default
On 5/4/2012 7:02 PM, jeffmeyer wrote:
Hi all - apologies if this is posted elsewhere - I couldn't find anything
about it:
the postGIS2.0 README states:
To install PostGIS library and utilities, as postgres run::
make install
But, make install requires su privileges (in order to create
Hi Steve - thanks for the speedy reply.
I understand that have been able to make install PostGIS as a different
user, just not as postgres, as the PostGIS instructions direct. Are the
instructions wrong?
I'm concerned that - by not installing as postgres, as the instructions
indicate - I might
On 5/4/2012 7:16 PM, jeffmeyer wrote:
Hi Steve - thanks for the speedy reply.
I understand that have been able to make install PostGIS as a different
user, just not as postgres, as the PostGIS instructions direct. Are the
instructions wrong?
I'm concerned that - by not installing as postgres,
On 5/4/2012 8:47 PM, jeffmeyer wrote:
Yes - I've tried all that install fails. Here's what comes next after sudo
make install:
postgres@jeffmetp:~/postgis-2.0.1SVN$ sudo make install
[sudo] password for postgres:
postgres is not in the sudoers file. This incident will be reported.
...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
Behalf Of wobo
Sent: Tuesday, May 01, 2012 6:56 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] PostGIS 2.0 instalation problem
Hi all,
I'm a newbie student, just finished reading
Thanks for the quick response.
First I succesfully installed PostgreSQl 9.1.3 using the win x86-32
installer from
http://www.enterprisedb.com/products-services-training/pgdownload#windows
http://www.enterprisedb.com/products-services-training/pgdownload#windows .
I was able to create extensions
...@postgis.refractions.net] On
Behalf Of wobo
Sent: Wednesday, May 02, 2012 6:49 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] PostGIS 2.0 instalation problem
Thanks for the quick response.
First I succesfully installed PostgreSQl 9.1.3 using the win
x86-32 installer
You can find a cached copy here:
http://www.java2s.com/Code/Jar/p/Downloadpostgis200SVNjar.htm
Nicolas
On 30 April 2012 17:10, Brian Sanjeewa Rupasinghe jink...@gmail.com wrote:
Hi,
Where can i find postgis 2.0.jar file to connect postGIS with Java. Link in
the PostGIS site is broken.
Hi all,
I'm a newbie student, just finished reading 'Postgis in action' and now
trying to get PostGIS2.0 up and running for the first time. Now I'm
suffering a similar problem in setup like the one mentioned earlier in this
thread.
Using Windows XP SP3 I was able to install the latest PostgreSQl
Hi,
Where can i find postgis 2.0.jar file to connect postGIS with Java. Link in
the PostGIS site is broken.
Brian.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
I've been building the driver from SVN, it's worked out fine for me.
On Apr 30, 2012 11:10 AM, Brian Sanjeewa Rupasinghe jink...@gmail.com
wrote:
Hi,
Where can i find postgis 2.0.jar file to connect postGIS with Java. Link
in the PostGIS site is broken.
Brian.
On Wed, Apr 25, 2012 at 11:09:10PM +0100, Alexandre Neto wrote:
undefined reference to `GEOSGeom_createEmptyPolygon'
...
Something to do with more than one GEOS installed
The presented solution would be to change the order of -L/usr/lib
-lgdal1.8.0 and -L/usr/local/lib
-lgeos_c in the
Lets see I have the enough strenght to fight it! :-D
Probably I will start by uninstall and purge GEOS, and start from the
beginning. And then other software might not work, that means I will have
to fight it too.
Thanks,
Alexandre Neto
On Thu, Apr 26, 2012 at 10:27 AM, Sandro Santilli
I'm trying to install Postgis 2.0 in a ubuntu machine.
It's the first time I try compiling code
I was able to configure and make with sucess, but after make check I
receive the following error:
---
make[1]: Leaving directory
Hi,
PostGIS 2.0.0 RPMS are out along with GEOS 3.3.3 and Proj 4.8.0. The
latest, the greatest!
Packages are only available for Fedora 15,16 and RHEL/Scientific
Linux/CentOS 6. To provide alternatives to users, I changed the name of
the package to postgis2, but they cannot be installed along
Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
Behalf Of Pierre Racine
Sent: Monday, March 26, 2012 2:23 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] POSTGIS 2.0 on WIn
Hi at all,
I wished test POSTGIS 2.0
Pachól [mailto:piotrpac...@gmail.com]
Sent: Wednesday, March 28, 2012 3:57 PM
To: PostGIS Users Discussion
Cc: Paragon Corporation
Subject: Re: [postgis-users] POSTGIS 2.0 on WIn
Hello,
I tried all hints from this thread and that:
http://postgis.refractions.net/pipermail/postgis-users/2012
Hi at all,
I wished test POSTGIS 2.0 on Win, so after installed on WinXP32
PostgreSQL 9.1.1, and following instruction for postgis-pg91-binaries-2.0.
0beta4w32 but I get the following error
On Mon, Mar 26, 2012 at 07:42:02PM +0200, Francesco Zucca wrote:
ERROR: could not load library
C:/Programmi/PostgreSQL/9.1/lib/postgis-2.0.dll
: unknown error 126 .
...
Any hints?
Stop using an operating system that talks to you using such
an obscure language, and doesn't let you look at
Il giorno lun, 26/03/2012 alle 19.47 +0200, Sandro Santilli ha scritto:
On Mon, Mar 26, 2012 at 07:42:02PM +0200, Francesco Zucca wrote:
ERROR: could not load library
C:/Programmi/PostgreSQL/9.1/lib/postgis-2.0.dll
: unknown error 126 .
...
Any hints?
Stop using an operating system
Hi at all,
I wished test POSTGIS 2.0 on Win, so after installed on WinXP32 PostgreSQL
9.1.1, and following instruction for postgis-pg91-binaries-2.0.
0beta4w32 but I get the following error ...C:\postgis-pg91-binaries-
2.0.0beta4w32\postgis-pg91-binaries-
...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
Behalf Of Pierre Racine
Sent: Monday, March 26, 2012 2:23 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] POSTGIS 2.0 on WIn
Hi at all,
I wished test POSTGIS 2.0 on Win, so after installed on
WinXP32
Hello,
I installed postgres and postgis directly in c:/postgres directory
Unfortunately the same unknown error 126 occured
Piotr
W dniu 2012-03-18 23:44, Hemin Tofiq pisze:
Hi,
Try to install it to another directory, I have seen that the space in
Program Files gives problems.
Regards,
Hemin
W dniu 2012-03-16 18:13, Bborie Park pisze:
On 03/16/2012 04:45 AM, Piotr Pachół wrote:
Hello,
I try to install PostGIS 2.0 on Windows XP using script file
makepostgisdb_using_extensions.bat
During executing of line: %PGBIN%\psql -d %THEDB% -c CREATE
EXTENSION
postgis;
I received error:
Hi,
Try to install it to another directory, I have seen that the space in
Program Files gives problems.
Regards,
Hemin
--
View this message in context:
http://postgis.17.n6.nabble.com/PostGIS-2-0-instalation-problem-tp4624902p4631437.html
Sent from the PostGIS - User mailing list archive at
On 03/16/2012 04:45 AM, Piotr Pachół wrote:
Hello,
I try to install PostGIS 2.0 on Windows XP using script file
makepostgisdb_using_extensions.bat
During executing of line: %PGBIN%\psql -d %THEDB% -c CREATE EXTENSION
postgis;
I received error: can't load library C:/Program
Hi All,
Hopefully this isn't unnecessary chatter, but I have nothing
earth-shattering to report on PostGIS 2.0 beta 3. Installed and compiled
easily on Ubuntu 11.10 oneiric. Thanks for all the hard work.
Best,
Steve
The error i get is :
postgres@zelio-desktop:/usr/lib/postgresql/9.1/bin$ *raster2pgsql -s 4236 -I
-C -M /home/zelio/Desktop/Zelio/Zelio/L3-NE43A16-094-059-13oct08-BAND2.tif
-F -t 30x30 public.demelevation | psql -d mydb*
raster2pgsql: command not found
On Tue, Feb 14, 2012 at 05:15:25AM -0800, Zelio Fernandes wrote:
The error i get is :
postgres@zelio-desktop:/usr/lib/postgresql/9.1/bin$ *raster2pgsql -s 4236 -I
-C -M /home/zelio/Desktop/Zelio/Zelio/L3-NE43A16-094-059-13oct08-BAND2.tif
-F -t 30x30 public.demelevation | psql -d mydb*
Iam Very thankful to Sandro santilli and all the others who patiently replied
to my posts regarding import of POSTGIS raster , I Re-Read the post of
Sandro santilli
Use this:
* $ /usr/lib/postgresql/9.1/bin/raster2pgsql*
Or set your path:
$ PATH=$PATH:/usr/lib/postgresql/9.1/bin/
I've to
On Tue, Jan 24, 2012 at 08:52:54AM +0100, willi8...@web.de wrote:
Hi,
I'm trying to build a linear application (topology network) with PostGIS
2.0.0SVN.
My real world situation has crosses edges with no nodes (water lines or
hiqh voltage power lines in different heights or
Hi Sandro,
Thank you very much for your quick response - helps me a lot!!
Best wishes, willi
-Ursprüngliche Nachricht-
Von: Sandro Santilli s...@keybit.net
Gesendet: 24.01.2012 09:03:01
An: PostGIS Users Discussion postgis-users@postgis.refractions.net
Betreff: Re: [postgis-users
Hi Sandro,
Approximately how much time/money would you project to enable SQL/MM Network
Topology?
Thanks,Chris
Date: Tue, 24 Jan 2012 09:34:21 +0100
From: willi8...@web.de
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] PostGIS 2.0 - network topology - crosses edges
On Tue, Jan 24, 2012 at 10:06:45AM -0500, Chris English wrote:
Approximately how much time/money would you project to enable SQL/MM Network
Topology?
I think we're around 30k EUR for a full implementation.
A kick-starter could probably be done with 1/5 of that.
--strk;
() Free GIS
Hi,
Im trying to build a linear application (topology network) with PostGIS 2.0.0SVN.
My real world situation has crosses edges with no nodes (water lines or hiqh voltage power lines in different heights or levels, where both edges have nothing to do with each other).
Topo-Geo assumes full
@postgis.refractions.net
Subject: [postgis-users] PostGIS 2.0 Alpha
Hi All,
Is PostGIS 2.0 Alpha released? Where can I find the installer?
Thanks a lot!
Bart
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman
On Wed, Nov 30, 2011 at 03:06:46PM -0800, Bob Pawley wrote:
Do you yet have a timeline for the Postgis 2.0 release??
Spring at worst, but it's much more likely that you could
have something to test by the first days of the new year.
A lot depends on how good the postgis users have been
Hi
Do you yet have a timeline for the Postgis 2.0 release??
Bob___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Sorry for the lack of subject on the last one.
Steve
http://www.clemetparks.com/images/esig/cmp-ms-90x122.pngStephen Mather
Geographic Information Systems (GIS) Manager
(216) 635-3243
s...@clevelandmetroparks.com
http://www.clemetparks.com/ clevelandmetroparks.com
From:
On 1 November 2011 14:21, Stephen V. Mather s...@clevelandmetroparks.com
wrote:
psql:postgis.sql:70: ERROR: could not load library
/usr/lib/postgresql/postgis-2.0.so:
/usr/lib/postgresql/postgis-2.0.so: undefined symbol: GEOSHausdorffDistance
I suppose the complain is about GEOS library.
Message-
From: Mateusz Loskot [mailto:mate...@loskot.net]
Sent: Tuesday, November 01, 2011 10:30 AM
To: s...@clevelandmetroparks.com; PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS 2.0 compilation and install
On 1 November 2011 14:21, Stephen V. Mather s
Hi Bborie,
I did get this to work. All the dependencies needed to be compiled
+universal (geos only compiled properly by configuring the compile for an
older version of gcc). See details here:
http://lists.macosforge.org/pipermail/macports-users/2011-August/025349.html
I like using Macports
On 08/27/2011 08:59 AM, JP Glutting wrote:
I am bumping this post up. I was never able to compile rev 7683 - I am
working with revision 7059, which I was able to compile. I am trying to
compile revision 7789 now, and I am having the same problem. This is what I
get:
...
I am bumping this post up. I was never able to compile rev 7683 - I am
working with revision 7059, which I was able to compile. I am trying to
compile revision 7789 now, and I am having the same problem. This is what I
get:
...
_lwgeom_calculate_gbox_geodetic, referenced from:
For those who are interested in quick web based rendering tools for PostGIS
raster and geometry. We've whipped up one for PHP and ASP.NET.
These are more a proof of concept to demonstrate how to use the new raster
output functions and how they help augment what you can do with postgis
Hello All,
I'm trying to build PostGIS based on MacPorts dependencies (GEOS and
PostgreSQL 9.0) on OS X 10.7 (Lion) with the new XCode. Macports puts
everything into /opt/local.
I amsetting the following environmental variables:
export CPPFLAGS=-I/opt/local/include
export
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
In the beginning I tried to install 2.0 in PostgreSQL 9.1 and got an error
message, then I uninstalled it, installed 9.0 and got the same error
message.
Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?
On Mon, Jul 4, 2011 at 3:17 PM, Mark Cave-Ayland
mark.cave-ayl...@siriusit.co.uk wrote:
Denis Rykov wrote:
Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?
No ;-)
Recent PostGIS SVN works nicely here, at least on a test-scenario I'm
running with PostgreSQL 9.1beta2,
Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
ERROR: could not load library
/usr/lib/postgresql/9.0/lib/postgis-2.0.so:
/usr/lib/postgresql/9.0/lib/postgis-2.0.so: undefined symbol:
DirectFunctionCall3Coll
More detailed information at :
http://gis.stackexchange.com/questions/11759/postgis-installation-error
On 03/07/11 16:41, Denis Rykov wrote:
|ERROR: could not load library/usr/lib/postgresql/9.0/lib/postgis-2.0.so
http://postgis-2.0.so: /usr/lib/postgresql/9.0/lib/postgis-2.0.so
http://postgis-2.0.so: undefined symbol: DirectFunctionCall3Coll
|
More detailed information at :
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
On Mon, Jul 4, 2011 at 2:20 AM, Mark Cave-Ayland
mark.cave-ayl...@siriusit.co.uk wrote:
On 03/07/11 16:41, Denis Rykov wrote:
|ERROR: could not load
On 27/06/11 19:45, Chris Seker wrote:
I have downloaded and installed PROJ4.6.1 and PostGIS-2.0 SVN. Still
having the following error.
sh-3.2$ psql -d template_postgis20 -f postgis2.sql
SET
BEGIN
psql:postgis2.sql:65: ERROR: could not load library
/usr/pgsql-9.1/lib/postgis-2.0.so:
I have downloaded and installed PROJ4.6.1 and PostGIS-2.0 SVN. Still having
the following error.
sh-3.2$ psql -d template_postgis20 -f postgis2.sql
SET
BEGIN
psql:postgis2.sql:65: ERROR: could not load library
/usr/pgsql-9.1/lib/postgis-2.0.so: /usr/pgsql-9.1/lib/postgis-2.0.so:
undefined
Try to install PostGIS 2.0 from
http://postgis.refractions.net/download/windows/pg84/experimental/postgis/postgis-pg84-binaries-2.0.0svn.zipand
get an error:
ERROR: could not find function geometry_analyze in file C:/Program Files
(x86)/PostgreSQL/8.4/lib/postgis-2.0.dll
Hi, I am getting the following error when trying to add a layer from a postgis
2.0 database:
java.lang.RuntimeException: java.io.IOException: Error occured calculating
bounds at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:476)
at
El Monday 18 April 2011, 龙龙 escribió:
Hi, I am getting the following error when trying to add a layer from a
postgis 2.0 database: java.lang.RuntimeException: java.io.IOException:
Error occured calculating bounds at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.ja
: Monday, April 18, 2011 8:06 AM
To: PostGIS Users Discussion
Subject: [postgis-users] ??: Postgis 2.0 and geoserver 2.1 rc4
Thanks for your kind-hearted answer. The data from the table is the same.
There is a sample data in geoserver's user documentation named
nyc_buildings.sql.
When we use
77 matches
Mail list logo