Or you can use pl-R to use R directly inside DB, which has some pros and
cons
Cheers,
Rémi-C
2013/12/3 Lee Hachadoorian lee.hachadooria...@gmail.com
On Tue, Dec 3, 2013 at 11:50 AM, James David Smith
james.david.sm...@gmail.com wrote:
On 3 December 2013 15:55, Lee Hachadoorian
You will have to define biggest more precisely. Biggest in terms of area?
There might be many inner rectangles having the same biggest area. How to
choose one over the other?
Pierre
-Original Message-
From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-
In the most simple case, take a very long rectangle and rotate it. There can be
an infinity of horizontal rectangles inside it all having the same biggest area.
-Original Message-
From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-
boun...@lists.osgeo.org] On Behalf Of
Hello,
I am having to import Raster (.tiff) into Postgres using the raster2pgsql tool.
The raster used is 12MB in size and the Postgres version is 9.1 on Ubuntu 13.10.
The virtual machine has the following hardware specs.
- 17408 Memory
- 4 Processors
- 16GB HDD
You are getting fast result because you are not operating at the pixel level.
Only at the raster extent level (converted to geometry). A more usual query
would be to intersect a raster with some polygons:
SELECT (ST_Intersection(r.rast, q.geom)).*
FROM ilatlon32x32 as r, geometrytable as q
Hi Pierre,
Thanks for the suggestion.
But how could I get a geometry table in Postgres that is sure to intersect the
raster image?
The reason why I created another raster table is so that I am able to vary the
query size. How can I do it with your suggestions (using polygons) since the
I guess maybe you are only looking at PostGIS for its capacity to deal with
raster in the database. You have to know that rasters and geometries are
located in space (georeferenced) and might very well intersects if they overlap
in space. Geometries are generally loaded from shapefiles. To
Hello, yes, I mean biggest in terms of area. I more than one rectangle
could be found, only one should be returned, not important which one.
Thanks, Tom
On 12/04/2013 03:42 PM, Pierre Racine wrote:
You will have to define biggest more precisely. Biggest in terms of area?
There might be many
Is there an existing function to do this? No.
Is it easy to write such a function? No, not if
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.47.3370rep=rep1;
type=pdf
is the simplest algorithm for solving this problem in general terms.
An interesting problem, though. Would be
Hi Pierre,
Thanks for the explanation. I will look at this direction to understand things
better.
Regards,
Zhi Feng
-Original Message-
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Pierre Racine
Sent: Mittwoch, 4. Dezember
10 matches
Mail list logo