Re: [postgis-users] ST_AsRaster and pixeltype

Ciaoi, Michi ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu

Re: [postgis-users] ST_AsRaster and pixeltype

- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of Bborie Park Sent: Monday, November 19, 2012 11:30 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] ST_AsRaster and pixeltype This would be a limitation on the datatypes supported

Re: [postgis-users] Adding raster to PostGIS database

, Nov 26, 2012 at 2:46 PM, Bborie Park bkp...@ucdavis.edu wrote: That error would only happen if raster2pgsql can't find the file in your current working directory. raster2pgsql supports relative paths for input rasters. -bborie On 11/26/2012 01:37 PM, Smaran Harihar wrote: Thanks

Re: [postgis-users] Effectively combining rasters

; As a side note I can tell that both rasters are equal in geographical sense (different bands from the same data). Looking in 2 rasters takes 1.4 sec. and in one raster is 60ms This is PostgreSQL 9.1.6, PostGIS 2.0.1 Thanks in advance! Regards, -- Bborie Park Programmer Center

Re: [postgis-users] Posgist raster overviews created with bicubic resampling

. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list

Re: [postgis-users] Effectively combining rasters

raster it's faster to do in the program and not in the DB. Thanks again, Kim On 2012-11-27 19:04, Bborie Park wrote: WITH pos AS ( SELECT ST_GeomFromText('MULTIPOLYGON(((15.000 54.800,15.000 55.000,14.800 55.000,14.800 54.800,15.000 54.800)))',4326) AS geom ), foo AS ( SELECT

Re: [postgis-users] should I be using st_mapalgebra?

anything that would be faster would also be great. Regards, Rhys ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Bborie Park Programmer Center

Re: [postgis-users] No intersection between two rasters notice

st_intersects(alti.rast, slopes.rast) ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp

Re: [postgis-users] problem with 'sobel' ST_MapAlgebraFctNgb

@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@lists.osgeo.org http

Re: [postgis-users] ST_SetSRID

Your query needs a FROM clause to specify the table. The error message is indicating that the database does not know the rast column... SELECT rast As bd_ortho, ST_Transform(rast,4326) As bd_ortho_wgs84 FROM mytable Also, you really should upgrade your PostGIS installation to 2.0.1. -bborie

Re: [postgis-users] Vote: PAGC address standardizer in extras

+1 On Sat, Apr 6, 2013 at 9:36 PM, Paragon Corporation l...@pcorp.us wrote: I would like at some point (soon) fork the standardizer part of pagc and include in extras/pagc_standardizer folder of PostGIS to make it easier to install as part of the PostGIS build. I'd like a vote on this (PSC,

Re: [postgis-users] 2.1.0beta3dev upgrade error

Steve, Which version of the json library are you using? http://trac.osgeo.org/postgis/ticket/2213 -bborie On Wed, May 22, 2013 at 10:22 PM, Stephen Woodbridge wood...@swoodbridge.com wrote: Some more data points. I also created a new database and tried: pgis21=# create extension postgis;

Re: [postgis-users] 2.1.0beta3dev upgrade error

in the Debian Squeeze repository. Also, I just noticed the note that I need GEOS 3.4 for the Delauney triangles, so I'm rebuilding the latest GEOS nightly snapshot and will install that. Thanks, -Steve On 5/23/2013 10:00 AM, Bborie Park wrote: Steve, Which version of the json library

Re: [postgis-users] ST_Line_Locate_Point VS ST_LineLocatePoint

ST_LineLocatePoint() was introduced in 2.1. I was going to suggest using PL/pgSQL exception handling but that has a significant performance hit... -bborie On Thu, May 23, 2013 at 1:52 PM, Stephen Woodbridge wood...@swoodbridge.com wrote: Hi, I just notice in pgRouting that I'm getting:

Re: [postgis-users] Raster - is it possible to use names for bands?

No. Bands are referenced by index in PostGIS. Your idea of using an extra column for the band names is probably your best solution. -bborie On Fri, May 24, 2013 at 7:56 AM, Ricardo Filipe Soares Garcia da ricardo.garcia.si...@gmail.com wrote: Hello list I'm taking my first steps in PostGIS

Re: [postgis-users] ST_MapAlgebra in JAVA app

If you're talking about a pl/java callback function passed to ST_MapAlgebra, you shouldn't have any problems. -bborie On Sun, May 26, 2013 at 12:48 AM, Ahmet Temiz ahmettemi...@gmail.com wrote: Is it possible to use ST_MapAlgebra with Create Function in JAVA app ? where can I find an example

Re: [postgis-users] Inconsistency between St_Value and ST_DumpAsPolygons

ST_Value and ST_DumpAsPolygons do very different things. ST_Value gets a value for a specific pixel while ST_DumpAsPolygons() dumps values by merging pixels with same value in an area. -bborie On Thu, Jun 6, 2013 at 12:38 PM, Jean Marchal jean.d.marc...@gmail.comwrote: Dear List, value's

Re: [postgis-users] selected aligned tiles in pgraster between several large raster tables.

Have you considered storing your rasters outside the database with raster2pgsql's -R flag? I usually recommend this if the rasters are readonly. This also minimizes the amount of information stored within the database to just the metadata of the out-db rasters. -bborie On Wed, Jun 12, 2013 at

Re: [postgis-users] ST_AsPNG is problematic in Java

Ahmet, Can you try one of the example code found in the docs? http://www.postgis.net/docs/manual-dev/using_raster_dataman.html#RT_Raster_Applications By testing out one of the examples, you should be able to tell if the problem is in the database or in your java code. -bborie On Mon, Jun 17,

Re: [postgis-users] selected aligned tiles in pgraster between several large raster tables.

Graeme, robe2 and I were discussing this thread and we were wondering if using the ~= operator would work for your problem. http://www.postgis.net/docs/manual-2.0/ST_Geometry_Same.html -bborie On Mon, Jun 17, 2013 at 7:22 AM, Graeme B. Bell g...@skogoglandskap.no wrote: Hello bborie (and

Re: [postgis-users] PostGIS Raster ST_Value ST_SetValue performance

Hey Miguel, If you're on PostGIS 2.0, there aren't faster alternatives for ST_SetValue() and ST_Value(). PostGIS 2.1 (hopefully released in the next several weeks) brings ST_SetValues() and ST_DumpValues(). As for your specific implementation, You could consider the use of ST_MapAlgebraFct()

Re: [postgis-users] OpenBSd installation problem

Marcelo, Those missing symbols are all from PostgreSQL. You'll want to make sure the PostgreSQL libs and dev files are provided. -bborie On Mon, Jul 1, 2013 at 1:17 PM, Marcelo Bacha dro...@gmail.com wrote: Hi, This is my first posting, I´m new to Postgis. I´ve seen similar problems related

Re: [postgis-users] Creating a multiband raster from 3 single bandrasters

:* postgis-users-boun...@lists.osgeo.org [mailto: postgis-users-boun...@lists.osgeo.org] *On Behalf Of *Bborie Park *Sent:* Monday, July 08, 2013 12:38 AM *To:* PostGIS Users Discussion *Subject:* Re: [postgis-users] Creating a multiband raster from 3 single bandrasters Check out the last

Re: [postgis-users] Status of Postgis-related rpms

There shouldn't be any issues between PostgreSQL 9.2 and PostGIS 2.0. If there are, they'd be Fedora derived problems... -bborie On Mon, Jul 22, 2013 at 11:48 AM, Max Pyziur p...@brama.com wrote: Greetings, With the release of Fedora 18 there were interoperability issues with PostGIS and

Re: [postgis-users] Querying Multiple Rasters

You may not need to drop all the constraints when adding additional data to the table. You most likely will need to drop is the maximum extent constraint. Assuming the input rasters have the same scale, skew and SRID as that found in the table, you don't need to drop those corresponding

Re: [postgis-users] Status of Postgis-related rpms

/package. -bborie On Tue, Jul 23, 2013 at 12:03 PM, Max Pyziur p...@brama.com wrote: On Mon, 22 Jul 2013, Bborie Park wrote: There shouldn't be any issues between PostgreSQL 9.2 and PostGIS 2.0. If there are, they'd be Fedora derived problems... Is there any chance that this will be corrected

Re: [postgis-users] Querying Multiple Rasters

Gallardo jaysontra...@gmail.comwrote: Okay, is there a specific reason why? As your link states: raster2pgsql loader uses this function to register raster tables. Are you saying I should specify constraints that will be similar across all tables? On Tue, Jul 23, 2013 at 2:53 PM, Bborie Park

Re: [postgis-users] Querying Multiple Rasters

, Jul 23, 2013 at 2:53 PM, Bborie Park dustym...@gmail.comwrote: I'd suggest adding constraints after the fact through SQL instead of letting raster2pgsql do it. http://www.postgis.net/docs/manual-2.0/RT_AddRasterConstraints.html -bborie On Tue, Jul 23, 2013 at 12:51 PM, Jayson Gallardo

Re: [postgis-users] Querying Multiple Rasters

on each table. How can I be sure that when I query the parent database that it's not querying every single table? On Tue, Jul 23, 2013 at 3:14 PM, Bborie Park dustym...@gmail.com wrote: I'm just glad to help. Feel free to post your experience, feedback, issues and/or wishes on the mailing

Re: [postgis-users] Querying Multiple Rasters

- Processed raster is displayed as an overlay on the map On Tue, Jul 30, 2013 at 11:31 AM, Bborie Park dustym...@gmail.com wrote: Are you able to transform the wkt before passing it to the sql? Partitioning only works on constant values, not values that need processing, e.g. ST_Transform

Re: [postgis-users] Querying Multiple Rasters

? On Tue, Jul 30, 2013 at 11:39 AM, Bborie Park dustym...@gmail.com wrote: The quick and dirty approach is to have a query before that query that transforms the WKT. Something like SELECT ST_AsEWKT(ST_Transform(...)) -bborie On Tue, Jul 30, 2013 at 9:35 AM, Jayson Gallardo jaysontra

Re: [postgis-users] Querying Multiple Rasters

? Would that help? Or would the query still check the constraint for each child of each subparent? On Tue, Jul 30, 2013 at 11:54 AM, Bborie Park dustym...@gmail.com wrote: 3m NED data doesn't exist for the continental US (at least from USGS). But if you were to do so, you could consider

Re: [postgis-users] St_Union crashing

David, How much RAM does the server have? How many records are there in the demelevation table? -bborie On Wed, Jul 31, 2013 at 11:43 AM, David Rowley dgrowle...@gmail.com wrote: I'm experiencing a crash with PostgreSQL 9.2 on windows 64 bit. psql 1060 idle 2013-08-01 06:34:21 NZST 0 LOG:

Re: [postgis-users] St_Union crashing

, Jul 31, 2013 at 11:53 AM, David Rowley dgrowle...@gmail.com wrote: On Thu, Aug 1, 2013 at 6:47 AM, Bborie Park dustym...@gmail.com wrote: David, How much RAM does the server have? How many records are there in the demelevation table? -bborie I'm testing on my laptop which has 8GB

Re: [postgis-users] St_Union crashing

On Wed, Jul 31, 2013 at 12:09 PM, David Rowley dgrowle...@gmail.com wrote: On Thu, Aug 1, 2013 at 7:00 AM, Bborie Park dustym...@gmail.com wrote: Are you using the latest version of PostGIS 2.0? What's the minor version? SELECT postgis_full_version() Full version is: POSTGIS=2.0.3

Re: [postgis-users] St_Union crashing

Sure. I've created a smallish recreation script with about 2000 16x16 rasters which still crashes with me. http://www.davidrowley.co.uk/files/st_union_crash.sql Just send ctrl+C while the St_Union is in progress. I get: test=# SELECT ST_Union(rast) FROM rasttest; Cancel request sent

Re: [postgis-users] St_Union crashing

You can find experimental builds at... http://winnie.postgis.net/download/windows/pg92/buildbot/ -bborie On Wed, Jul 31, 2013 at 3:07 PM, David Rowley dgrowle...@gmail.com wrote: On Thu, Aug 1, 2013 at 10:01 AM, Bborie Park dustym...@gmail.com wrote: Sure. I've created a smallish

Re: [postgis-users] St_Union crashing

On Wed, Jul 31, 2013 at 4:00 PM, David Rowley dgrowle...@gmail.com wrote: On Thu, Aug 1, 2013 at 10:10 AM, Bborie Park dustym...@gmail.com wrote: You can find experimental builds at... http://winnie.postgis.net/download/windows/pg92/buildbot/ Thanks, OK, I've tried 2 more versions

Re: [postgis-users] St_Union crashing

Did this change between 2.0.3 and 2.0.4? Though I guess there's not much that can be done if it is fixed in 2.0.4 apart from push windows users harder to upgrade. I just emailed my hosting company to ask them if they would move me up to 2.0.4, but I guess if that is the problem then it

Re: [postgis-users] raster intersect with polygon resulting in false NULL value

Her table constraints indicate that the NODATA value is properly set to -. -bborie On Wed, Aug 21, 2013 at 12:51 PM, Tim Keitt tke...@utexas.edu wrote: Gdal is honoring the no-data value encoded in the raster file, but postgis is not. I see this problem in a lot of code out there. THK

Re: [postgis-users] raster intersect with polygon resulting in false NULL value

Hailey, Can you run a query such as the following and post the results? I had to do a double-take for the ST_SummaryStatsAgg() function as I'm not familiar with that function. WITH foo AS ( SELECT * FROM zben_allwshds WHERE bid = 61 ) SELECT a.rid, ST_SummaryStats(ST_Clip(a.rast,1, f.geom,

Re: [postgis-users] When is PostGIS 2.1.0 Windows binary coming out?

http://www.postgresonline.com/journal/archives/319-PostGIS-2.1-windows-bundle.html On Tue, Sep 10, 2013 at 1:07 PM, John Smith jayzee.sm...@gmail.com wrote: (sorry for the double-posting) guys, I got PostgreSQL 9.3 and looking for a compatible PostGIS Windows binary. From this

Re: [postgis-users] 'Spatial Extensions' missing from Stack Builder?

http://www.postgresonline.com/journal/archives/319-PostGIS-2.1-windows-bundle.html See Regina's blog post... On Tue, Sep 10, 2013 at 1:02 PM, Stephen V. Mather s...@clevelandmetroparks.com wrote: I can't confirm, but given 9.3 dropped yesterday, I'd say it's quite likely it hasn't been

Re: [postgis-users] Problem with ST_MapAlgebraExpr

://postgis.net/docs/manual-2.0/RT_ST_MapAlgebraExpr2.html -bborie On Fri, Sep 13, 2013 at 4:27 AM, g.si...@utwente.nl wrote: Thanks Bborie Park, Can you please tell me what should I use for rast1.val and rast2.val. I am asking this because when I used '[maxrast.val] * [minrast.val]' I get

Re: [postgis-users] tile size

Steve, There really isn't. What I do recommend is that if your raster data is not going to change over time (and you don't need to replicate the database), load them as out-db rasters. That way, you can easily change tile size within the database with ST_Tile. -bborie On Fri, Sep 13, 2013 at

Re: [postgis-users] PostgreSQL 9.3 Error when trying to run Create Extension postgis

You'll want to ask whoever created the CentOS package as it looks the package is incomplete. -bborie On Fri, Sep 13, 2013 at 8:42 AM, DFE mimmopastic...@gmail.com wrote: As reported in [1] there is an error during the postgis2.1 extension installation. [1]

Re: [postgis-users] tile size

: Re: [postgis-users] tile size OK, thanks. I will give that a try. On 9/13/2013 12:31 PM, Adam Eskreis wrote: The most common tile size that I've seen in production is 256x256 On Fri, Sep 13, 2013 at 10:33 AM, Bborie Park dustym...@gmail.com wrote

Re: [postgis-users] About 2-dimensional arrays of postgresql

Miguel, Are you saying that the FOR loops are taking most of the time? What's the time breakdown for each major step (ST_DumpValues, the FOR loop and ST_SetValues). The looping itself may not be the primary cause of your problem but rather what is going on within the loop. What is going on

Re: [postgis-users] Cannot access offline value raster

You'll want to make sure that the account running the PostgreSQL service has access to C:\Users\user\Desktop\. -bborie On Tue, Oct 8, 2013 at 3:55 AM, irina.coviello irina.covie...@imaa.cnr.itwrote: Dear all, this is my first post and I hope someone can help me. I cannot access to the

Re: [postgis-users] [postgis-devel] ST_Union() performance problem (with possible funding)

Your best bet is to consider splitting the workload among several postgresql connections. darkblueb had a blog post about this... http://blog.light42.com/wordpress/?p=23 On Wed, Oct 16, 2013 at 5:21 PM, Brent Wood pcr...@pcreso.com wrote: Hi, Any advice appreciated!! I'm undertaking a

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

Its your code, pick the one you want. +1. If there was one true answer to the licensing question, this would be it. -bborie ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] Raster clipping vs. intersection

The behavior of ST_Clip and ST_Intersection for raster and geometry are very different. ST_Intersection() converts the raster into a set of geometries and then returns the intersection of the input geometry and the raster's geometries. ST_Clip() does the exact opposite. The input geometry is

Re: [postgis-users] ST_RotateX with pointOrigin!

, Dec 15, 2013 at 1:02 AM, Bborie Park dustym...@gmail.com wrote: Sweet. Can you create a ticket and attach the patch? Some unit tests would be nice so that expected behavior is maintained... and bugs are caught. Thanks! -bborie On Sat, Dec 14, 2013 at 7:57 PM, Stephen Mather step

Re: [postgis-users] PostgreSQL geometric data types vs GEOMETRY data type

Correct. PostGIS supports PostGIS datatypes. -bborie On Thu, Jan 2, 2014 at 11:10 AM, Peter Len petera...@earthlink.net wrote: I am using PostgreSQL 9.1 with PostGIS. I am still doing a lot of documentation reading but have the following question PostgreSQL comes with some default

Re: [postgis-users] Look for Help on Libraries and Dependencies for Compiling Postgis2.1 Source for Suse 11 SP3

Are you using GDAL provided by OpenSUSE? Or did you compile your own? -bborie On Wed, Jan 15, 2014 at 7:25 PM, Marco marco91...@gmail.com wrote: Hi, I am trying to build postgis 2.1 from the source for SUSE 11 SP 3. However it requires openjp2, hdf5, mfhdf, df (all devel version I think)

Re: [postgis-users] Look for Help on Libraries and Dependencies for Compiling Postgis2.1 Source for Suse 11 SP3

in OpenSUSE repo that I can find, but I am using the gdal from 11 SP 2 repo. Thanks On Wed, Jan 15, 2014 at 7:44 PM, Bborie Park dustym...@gmail.com wrote: Are you using GDAL provided by OpenSUSE? Or did you compile your own? -bborie On Wed, Jan 15, 2014 at 7:25 PM, Marco marco91

Re: [postgis-users] Look for Help on Libraries and Dependencies for Compiling Postgis2.1 Source for Suse 11 SP3

-devel-1.10.1-1.4. Do you think all the complains of missing libraries like openjp2, hdf5 etc. are related to gdal-dev package? Thanks On Thu, Jan 16, 2014 at 9:57 AM, Bborie Park dustym...@gmail.com wrote: And SP2 does not have gdal-dev packages? I suggest you compile gdal yourself with what

Re: [postgis-users] ST_SummaryStatsAgg not working with PostgreSQL 9.3 + PostGIS 2.1.1

on, ST_SummaryStats.sql, has it remained the same? Thanks, Hailey On Fri, Jan 31, 2014 at 6:53 AM, Bborie Park dustym...@gmail.com wrote: Can you change line 56 of that code from ... $$ LANGUAGE 'SQL'; to $$ LANGUAGE 'sql'; I believe PostgreSQL 9.3 (maybe 9.2) became case-sensitive with regards

Re: [postgis-users] ST_SummaryStatsAgg not working with PostgreSQL 9.3 + PostGIS 2.1.1

, Bborie Park dustym...@gmail.com wrote: PostGIS 2.1 does not have the data type summarystats. Where did you get this function? PostGIS 2.2 (in development now) does have that data type though for a built in ST_SummaryStatsAgg function. -bborie On Jan 31, 2014 9:23 AM, Hailey Eckstrand

Re: [postgis-users] import raster

Do you need the maximum extent constraint? Generally, it is safe to disable the maximum extent constraint. -bborie On Thu, Feb 27, 2014 at 7:06 AM, Eloi Ribeiro e...@openmailbox.org wrote: On 2014-02-27 11:19, Rémi Cura wrote: Maybe you can try to separate raster2pgsql and psql . First

Re: [postgis-users] import raster

, Eloi e...@openmailbox.org wrote: Thanks bborie, It is possible to do that in the import statement or just after the import? Cheers, Eloi On February 27, 2014 5:11:23 PM CET, Bborie Park dustym...@gmail.com wrote: Do you need the maximum extent constraint? Generally, it is safe

Re: [postgis-users] in-base raster wrong use by gdalinfo and gdal_translate

It sounds like it might be a problem with the GDAL PostGIS Raster driver. From the GDAL driver page, it looks like they recommend 1.10.1... http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html On Fri, Mar 7, 2014 at 7:42 AM, Rémi Cura remi.c...@gmail.com wrote: Hey, I am faced with a problem

Re: [postgis-users] no pixels in raster

19.03.2014 16:50, schrieb Bborie Park: 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 andreas.lagg...@ti.bund.de wrote

Re: [postgis-users] no pixels in raster

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 andreas.lagg...@ti.bund.de wrote: Hi list, i have some problems with

Re: [postgis-users] point - raster, multiband at once

setvalues with a standard array is faster than an array of geomvals. -bborie On Mon, Mar 24, 2014 at 11:59 AM, Rémi Cura remi.c...@gmail.com wrote: Hey, somebody knows a way to set multiple bands at once? It is about rasterizing points (into raster). Currently it is extremely slow (50*50

Re: [postgis-users] more memory issues with raster2pgsql

You should tell raster2pgsql to tile the raster into smaller bite-size chucks, 256x256 is a safe value. It sounds like the raster is too big for what memory is available. -bborie On Fri, Mar 28, 2014 at 5:29 PM, georgew gws...@hotmail.com wrote: Hi, I am trying to convert a raster from SAGA

Re: [postgis-users] more memory issues with raster2pgsql

How big is the original? Numbers of pixels width and height? Number of bands? Pixel types of the bands? I just want to know so that I can tell you if its even possible to store that raster as one database value. Utf-8 shouldn't be an issue as the raster data itself isn't in any character set

Re: [postgis-users] more memory issues with raster2pgsql

Wait a minute. I wonder what your psql's client encoding is. This seems familiar... -bborie On Mar 28, 2014 5:30 PM, georgew gws...@hotmail.com wrote: Hi, I am trying to convert a raster from SAGA GIS to Postgis using raster2pgsql.The command line and its output is:

Re: [postgis-users] more memory issues with raster2pgsql

Found the answer. http://postgis.net/docs/RT_FAQ.html#qa_raster_fails_encoding_conversion Got to love robe2 and her due diligence. -bborie On Mar 28, 2014 5:30 PM, georgew gws...@hotmail.com wrote: Hi, I am trying to convert a raster from SAGA GIS to Postgis using raster2pgsql.The command

Re: [postgis-users] more memory issues with raster2pgsql

Assuming you are running psql at the terminal/console, you should run set PGCLIENTENCODING=UTF8 before running psql. I can't say I can be of much more help as I don't have a windows box handy. -bborie On Mar 28, 2014 7:01 PM, georgew gws...@hotmail.com wrote: thanks again bborie, my original

Re: [postgis-users] more memory issues with raster2pgsql

I think you can just connect to the database with psql and issue the following: postgres=# SHOW client_encoding; It should return something like... client_encoding - UTF8 (1 row) If your database doesn't return UTF8, you can forcefully set client_encoding ALTER DATABASE mydb

Re: [postgis-users] Accessing lots of missing outdb/offline rasters appear to cause PostgreSQL to crash

So, you were hitting two separate problems. Can we see the query that you're actually trying to run? The assert itself indicates that somehow rt_raster_from_band received a raster from which bands are to be extracted but the raster is NULL. You've going to have to examine your query and the

Re: [postgis-users] ArcGIS issue - specified coordinate exceeds the valid coordinate range

Mark, You'll need to provide a lot more information about your layer. Saying that the layer works in one application but not another does not help much. You should inspect the geometries of your layer to see if one of them has a coordinate exceeding the valid range. For example, if your

Re: [postgis-users] Raster ST_Union memory limit

RAM available. -bborie On Tue, May 6, 2014 at 6:35 AM, Pierre Racine pierre.rac...@sbf.ulaval.cawrote: Hi, What maximum size the result of a ST_Union(rast) can be if it is embedded in a ST_Tile() call? SELECT ST_Tile(ST_Union(rast), 100, 100) rast FROM ... The RAM available to

Re: [postgis-users] Raster ST_Union memory limit

RAM, are each resulting row flushed to the disk so that my whole query does not explode? Pierre -Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of Bborie Park Sent: Tuesday, May 06, 2014 9:52 AM

Re: [postgis-users] Problem with postgis raster

Double-checking the error you provided from QGIS, it looks like you haven't specified a value for host... -bborie On Mon, May 19, 2014 at 4:15 PM, dandrigo lcel...@latitude-geosystems.comwrote: Hello, below, i paste my DOS interface showing gdalinfo for the srtm file : SS_gdalinfo.JPG

Re: [postgis-users] ST_AddBand

You're probably better served using the first variant which gives you full control over each raster and band to be added. All the other variants of ST_AddBand are wrappers around the first variant. -bborie On Wed, Aug 13, 2014 at 6:37 AM, David Haynes hayne...@gmail.com wrote: I have a

Re: [postgis-users] Questions related to some tests I did in PostGIS

So, my questions are: Why counting pixels was not faster in the second subset with pixels of 5x5 meters? I cannot tell based upon your queries. I can't distinguish which query times are for the 5x5 vs 1x1. Have you tried doing outdb? It may be more performant for a source raster of that

Re: [postgis-users] FileGDB curves

If I remember correctly, curve geometries are not currently supported in GDAL/OGR. There is a GDAL RFC making the rounds for adding curve support... http://trac.osgeo.org/gdal/wiki/rfc49_curve_geometries -bborie On Wed, Nov 12, 2014 at 7:44 AM, Andy Colson a...@squeakycode.net wrote: Shoot.

Re: [postgis-users] [Raster] Finding pixels intersecting an extent (polygon)

ST_Intersection(rast, geom) does vectorize the raster before intersecting with the polygon. ST_Clip(rast, geom) rasterizes the polygon before intersecting with the raster. Can you provide more information? Such as the query and the version of PostGIS? -bborie On Thu, Feb 5, 2015 at 2:05 PM,

Re: [postgis-users] [Raster] Finding pixels intersecting an extent (polygon)

Try something like: WITH foo AS ( SELECT ST_AsRaster( ST_GeomFromText('POLYGON ((-52.54178994517749 46.99199259385565, -52.54178994517749 46.996897959881, -52.53436080387823 46.996897959881, -52.53436080387823 46.99199259385565, -52.54178994517749 46.99199259385565))', 4269), rast, '8BUI',

Re: [postgis-users] ST_BandPath() returns null or ô on out-db raster

I'm not aware that loading out-db rasters using Windows network path names will work. What happens if you add that network path as a network drive? Can you try something like the following? All I've done is replace the backslash with a forward slash... raster2pgsql -R -a -F

Re: [postgis-users] Can I change the path of an out-of-db raster?

Hey Guido, ST_SetBandPath doesn't exist but sounds like a worthwhile addition. Can you file a ticket for that? http://trac.osgeo.org/postgis/ In the meantime, a workaround is to use symbolic links or mount points. -bborie On Tue, Feb 10, 2015 at 2:34 AM, guido lemoine

Re: [postgis-users] raster2pgsql: -t TILE_SIZE

Ramon, It really depends on whether the rasters are stored in the database (in-db) or out of the database (out-db) If out-db, I recommend using the block size returned when running gdalinfo on the raster... # gdalinfo raster/test/regress/loader/testraster.tif Driver: GTiff/GeoTIFF Files:

Re: [postgis-users] POSTGIS_ENABLE_OUTDB_RASTERS=1: PostGIS won't start (RHEL 6.5)

** Bborie Park dustym...@gmail.com Wed Feb 25 10:46:59 PST 2015 Philip, POSTGIS_ENABLE_OUTDB_RASTERS=1 is an environment variable not to be in postgresql.conf. The same is true for POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL https

Re: [postgis-users] POSTGIS_ENABLE_OUTDB_RASTERS=1: PostGIS won't start (RHEL 6.5)

Philip, POSTGIS_ENABLE_OUTDB_RASTERS=1 is an environment variable not to be in postgresql.conf. The same is true for POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL https://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux Based upon the above, it looks like you should add

Re: [postgis-users] POSTGIS_ENABLE_OUTDB_RASTERS=1: PostGIS won't start (RHEL 6.5)

is invisible to the eye. -de Saint-Exupéry ** On 2/25/2015 11:45, Bborie Park wrote: The env variables need to be within the environment of the postgres process. How are you starting postgres? Shell script? Then you should be able

Re: [postgis-users] ST_Clip on a raster without band crashes the server

File a bug. It shouldn't work for an empty raster. On Tue, Feb 24, 2015 at 6:50 AM, Pierre Racine pierre.rac...@sbf.ulaval.ca wrote: Hi, I have: POSTGIS=2.1.5 r13152 GEOS=3.4.2-CAPI-1.8.2 r0 PROJ=Rel. 4.8.0, 6 March 2012 GDAL=GDAL 1.11.1, released 2014/09/24 LIBXML=2.7.8 LIBJSON=UNKNOWN

Re: [postgis-users] memory usage of st_clip/st_intersection in a session

Based upon your description, I can't guess as to the cause of the memory leak(?). Can you post the query and provide some information (spatial extent, # of features) about the rasters (tile size, # of bands, in-db or out-db) and the geometries (same SRID of raster, maximum # of vertices per

Re: [postgis-users] raster2pgsql problem - SSL SYSCALL error EOF detected

there is no transaction and each insert proceeds separately). So far it's been running for 15 minutes, I'm up to about 800k records in the table, and there are no complaints in the log. On Tue, Jun 2, 2015 at 3:17 PM, Bborie Park dustym...@gmail.com wrote: Are you tailing the postgresql server logs

Re: [postgis-users] raster2pgsql problem - SSL SYSCALL error EOF detected

the transaction that it croaks. On Tue, Jun 2, 2015 at 2:58 PM, Bborie Park dustym...@gmail.com wrote: As you indicated, the problem has to do with psql or more specifically your database. You'll need to provide more info, such as your postgres configuration and hardware specs, for anyone

Re: [postgis-users] Slow ST_Intersects and Materialized Views

Can you redo that EXPLAIN with EXPLAIN ANALYZE VERBOSE? That'll give use what the database actually does... On Thu, May 28, 2015 at 8:09 AM, Alexander W. Rolek a.ro...@gmail.com wrote: I appreciate the quick responses. Here's the EXPLAIN for the following query: EXPLAIN SELECT DISTINCT

Re: [postgis-users] HSR Benchmark - 2015

+1. I'll take a look when I can. I'm all for systematic and longitudinal benchmarks... -bborie On Wed, Jul 29, 2015 at 6:13 PM, Brian M Hamlin mapl...@light42.com wrote: Hi All - last year, I updated and ran a benchmark for spatial search across several geo platforms [1] This year, I am

Re: [postgis-users] restore problem

This problem arises because PostgreSQL sets the search path during the restore process. Unfortunately, the search path is quite restrictive. You should be able to do your restore in three sections using pg_restore's --section flag. The error looks like it has to be the post-data section, which

Re: [postgis-users] restore problem

g PgAdmin I have no idea how to follow your instructions L > > > > Anyone care to give me an idiots guide? > > > > Sorry > > > > Darrel > > > > > > *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On > Behalf Of *Bborie Park

Re: [postgis-users] restore problem

checked, I get the same error > and the raster table (dems) is empty. > > > > Darrel > > > > *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On > Behalf Of *Bborie Park > *Sent:* 10 November 2015 21:57 > > *To:* PostGIS Users Discussion <

Re: [postgis-users] Queries on partitioned table not behaving as expected

That check constraint is not going to help you as it is too complicated for the partitioning task. I don't believe the partitioning constraint can be functional but needs to be simpler and built upon a basic data type... Something like... CREATE TABLE max_extent AS ( id integer PRIMARY KEY,

Re: [postgis-users] add raster constraint exceeds array size limit

Wow... that's new. I'm guessing that the array that collects the individual tiles' extents is getting too big. Can you file a ticket? On Fri, Mar 11, 2016 at 12:08 AM, Caitríona Smith wrote: > Hi All > > I’ve a number of largish rasters that I’m wanting to tile to

Re: [postgis-users] [EXTERNAL] Re: ST_Resample function question.

I think the problem here is that the code treats a raster with no SRS differently than a raster with SRS where reprojection will NOT take place (essentially, same Cartesian plane for source raster and destination raster). The key offending(?) line is