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,
Hi,
try this http://www.postgis.org/docs/ST_GeomFromText.html
Marco
Am 03.02.2015 um 05:11 schrieb KhunSanAung:
Hi All,
I have one table (Town info) in postgres without Geometry field.
I have Latitude and Longitude information for those points data
separately (collecting filling).
I
Hello,
Le jeudi 29 janvier 2015, 15:22:15 Tahir Tamba a écrit :
[...]
Otherwise, are there another ways to load tables from Oracle Spatial
database to PostGIS ?
As Brent suggested, you can use Oracle Foreign Data Wrapper. There is now full
support for Oracle spatial included in Oracle_fdw
Hi list,
I am trying to return all the pixels in a raster that intersect (not just
touch) an extent (say a rectangle). I tried ST_Clip and
ST_Intersection(raster, geom) but they don't return all the pixels that
intersect my extent polygon. Do I have to vectorize the raster first using
select ST_Clip(r.rast,p.geom) as rast
from polygon p inner join raster r on ST_intersects(r.rast, p.geom)
This returns a raster which has all pixels inside the polygon
On Thu, Feb 5, 2015 at 4:05 PM, Jean Marchal jean.d.marc...@gmail.com
wrote:
Hi list,
I am trying to return all the pixels
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',
It worked! Thanks a lot!
Jean
2015-02-05 15:18 GMT-08:00 Bborie Park dustym...@gmail.com:
Try something like:
WITH foo AS (
SELECT
ST_AsRaster(
ST_GeomFromText('POLYGON ((-52.54178994517749 46.99199259385565,
-52.54178994517749 46.996897959881, -52.53436080387823 46.996897959881,
Thanks to all of you very much for your insightful replies!
The circles are computer-generated with 15-20 points (I should've mentioned
that from the beginning).
I very much like the compactness-approach as well as the LineToCurve.
I will try out these approaches and let you know about my
Hey,
your question is a little bit un-precise.
If you try to find circle that have been drawn by a CAD program for
instance (perfect circle),
you can use ST_LineToCurve().
If you are trying to detect polygons that look like circle (maybe the
border is very close to a circle, but overall it is
Hi Paolo,
I bumped into this as well, but it is by design and the solution is
fairly easy.
Read this:
http://postgis.net/docs/postgis_installation.html#install_short_version
Bottom line:
```
As of PostGIS 2.1.3, out-of-db rasters and all raster drivers are
disabled by default. In order to
I have many different polygons in my database and would like to know if
there's any way to find out if a polygon has the shape of a circle. I
searched both on Google and in the Postgis documentation but couldn't find
someone with the same question.
The lines joining the vertices of a
Il 05/02/2015 10:24, Tom van Tilburg ha scritto:
Hi Paolo,
I bumped into this as well, but it is by design and the solution is
fairly easy.
Read this:
http://postgis.net/docs/postgis_installation.html#install_short_version
OK, clear, thanks.
--
Paolo Cavallini - www.faunalia.eu
QGIS
12 matches
Mail list logo