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 2013
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.3370&rep=rep1&;
type=pdf
is the simplest algorithm for solving this problem in general terms.
An interesting problem, though. Would be usef
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
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 creat
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
polygon
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
WHERE
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
The
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 O
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-
> boun...@lis
Hello, I need to calculate the biggest rectangle which is contained
within another polygon. A sort of inner envelope or inner bounding box.
I found this interesting article:
http://cgm.cs.mcgill.ca/~athens/cs507/Projects/2003/DanielSud/
Is it possible in Postgis?
I have attached a picture with
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
> 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
>> wrote:
>>
>>> On Tue, Dec 3,
11 matches
Mail list logo