Jason,
CREATE OR REPLACE is done for the other functions, so you won't have issues
there unless signatures changed, which they didn't.
We have to drop aggregates if they change because PostgreSQL has no CREATE
OR REPLACE AGGREGATE technically because an AGGREGATE is mostly a structure
thing so
What was the output when restoring your backup? And what was your restore
command?
I've never had problems dumping and restoring in my production environments.
-bborie
On Wed, Mar 19, 2014 at 6:19 AM, Andreas Laggner wrote:
> Hi list,
>
> i have some problems with raster datasets since i use
What happen when you dump only a raster table or schema without using the
pg_dump -b option?
Pierre
From: postgis-users-boun...@lists.osgeo.org
[postgis-users-boun...@lists.osgeo.org] On Behalf Of Bborie Park
[dustym...@gmail.com]
Sent: Wednesday, March
On Wed, Mar 19, 2014 at 06:43:21PM +0100, Rémi Cura wrote:
> Hey,
>
> We tried several way to load an already topologically correct shapefile
> into postgis topology .
>
> 10k lines loaded
> _Using totopogeom : 750 sec
> _Using addlinestring : 246 sec
> _Manually using addnode and st_addedgemodfa
Hey,
We tried several way to load an already topologically correct shapefile
into postgis topology .
10k lines loaded
_Using totopogeom : 750 sec
_Using addlinestring : 246 sec
_Manually using addnode and st_addedgemodface : 86 sec.
Still very slow :-/
Considering manually filling table /and/o
If your restored raster data was in-db, it would have nothing to do with
GDAL. GDAL only kicks in when accessing out-db raster, polygonization and
warping...
Are you able to post the output of ST_Metadata() and ST_BandMetadata() for
one of the rasters in the database that returning no values?
-bb
aahh gotcha. Continue on my friend thanks for the assist.
-jason
On Tuesday, March 18, 2014 3:52:00 PM UTC-6, Jason wrote:
>
> Hi All,
>
> OS: centos 6.5
> Postgres: 9.2.7
> PostGIS: 2.0.3
>
> We have recently finished cleaning up and consolidating apps/servers and
> upgraded to postgres 9.2.
Everything was ok, no errors and no warnings, like it is when i import
raster now. But there are no pixel values!!
I think it has something to do with my PostGIS installation and gdal
Am 19.03.2014 16:50, schrieb Bborie Park:
What was the output when restoring your backup? And what was
On Wed, Mar 19, 2014 at 08:00:29AM -0700, Jason wrote:
> Although my concern is if any functions HAVE changed that we will run into
> the same issue. We have a good amount of views that reference postgis
> functions. Why not do a "create or replace" instead of a drop and create?
There's no "cr
Hey,
I encountered countinuous trouble with raster regarding gdal.
Only working solution for me was to update it.
Also,
maybe you could write
raster2pgsql -s 31467 -I -C -M /disk1/samba/importdb/dgm_25.t
if -t 100x100 rast.dgm25 |
to disk,
so to see what it says,
then try to manually execute it in
Thanks Regina! I meant to "post reply" so reiterating what I replied to you
earlier..
We will wait since its no rush on our part. I have plenty of things to keep
me busy for two weeks:)
Although my concern is if any functions HAVE changed that we will run into
the same issue. We have a goo
Hi all,
I try to calculate the slope at precise points by intersection between a
vector layer of points and a raster DEM (both with the same SRID).
I would like to get the result in percent, giving the slope on each point of
my vector layer.
Here is the query I use :
SELECT p.id, p.x, p.y, ST_Va
Hi list,
i have some problems with raster datasets since i use postgis 2.1.1 and
postgres 9.3.3
"POSTGIS="2.1.1 r12113" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"
LIBJSON="UNKNOWN" TOPOLOGY RASTER"
First all my rasters were e
On Wed, Mar 19, 2014 at 11:53:33AM +0100, Rémi Cura wrote:
> Hey Dear List,
>
> somebody knows exactly what is the difference bteween those 2 columns in
> postgis topology?
The "abs" one was just a facility to allow for
the field to be a valid foreign key into edge_id.
Not sure it's still needed
Hey Dear List,
somebody knows exactly what is the difference bteween those 2 columns in
postgis topology?
Thanks,
Cheers,
Rémi-C
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Hi Resmi-C,
We have a new cover each 16-day from Landsat 8. But I only want one cover
in result of my query. I had add new column 'date_of_data' to store date of
a raster. And I think range could solve my problem.
Thank you!
On Wed, Mar 19, 2014 at 4:16 PM, Rémi Cura wrote:
> It is a little bit
It is a little bit hard to understand what you mean..
As a summary :
_you have lot's of rasters.
_Each one as a position (and a date associated?).
You need to get a raster based on its position (where st_intersects(..))),
but it is not sufficient and you would like too also filter by date.
You ca
Hi PostGIS Users,
I have a huge dataset of raster in PostGIS. Each scene is divided into
tiles (tile-size 500x500). I was trying to SELECT rast FROM landsat8 WHERE
ST_Intersects(rast, polygon). It runs very slow, because it returns
longitudinal scenes of raster. Where I just want one day's scene.
18 matches
Mail list logo