>I prepared a PowerPoint presentation with a complete specification of
>raster in PostGIS and an analysis of what should be the result of
>overlay operation between raster and vector layers. You can download
>this PPT at: http://www.cef-cfr.ca/uploads/Membres/WKTRasterPostGIS.ppt
>Please have a lo
Hi,
I like to accomplish the task of finding polygons with holes inside
(the table is a MULTIPOLYGON).
I tried to use ST_nrings, but I am not sure it this always only finds
polygons with wholes inside or also islands, which should be also rings
by definition.
So a
SELECT gid, name FROM table W
Stephan,
Well since you have a multipolygon, I think you have to do something
like this
SELECT gid, name
FROM (SELECT gid, name, (ST_Dump(the_geom)).geom As the_geom
FROM table ) As thetable
WHERE ST_NumInteriorRings(the_geom) > 0;
I would have suggested just running ST_NumInteriorRings instead
I import / synchronize data from ARC/INFO coverage files frequently. I
use the following command to pull in the data for our intranet mapping
server, but it does not seem to honor the SRID arguments and places all
geometries with SRID = 32767. I have tried every combination of -*_srs
args to no av
Thanks for your comments Regina,
>if you look at Dane's posed problem in
>previous postgis post, it is a common scenario where I have really
>wanted RASTER in the database and where your proposed
>ST_Intersection(RASTER, VECTOR), ST_Interects(RASTER,VECTOR) would have
>worked nicely (e.g. steps f
Sufficool, Stanley wrote:
I import / synchronize data from ARC/INFO coverage files frequently. I
use the following command to pull in the data for our intranet mapping
server, but it does not seem to honor the SRID arguments and places all
geometries with SRID = 32767. I have tried every combin
Regina and Brent:
Wow. Thanks so much for the pointers.
I've now got a single query that is working excellently so far.
Without indexes it runs on the entire dataset in about 5 minutes when
splitting lines to ~ 150 m, which is just fine.
I was able to use the ST_Reverse function to make su
Sufficool, Stanley pisze:
I import / synchronize data from ARC/INFO coverage files frequently.
I use the following command to pull in the data for our intranet
mapping server, but it does not seem to honor the SRID arguments and
places all geometries with SRID = 32767. I have tried every
comb
Hi
TSP is now available on win32 for PostgreSQL 8.3.3 with PostGIS 1.3.3
Link is http://www.davidgis.fr/download/pgRouting-1.02_pg-8.3.3.zip
I've made a little tutorial for A* and shooting available on my web site at
http://www.davidgis.fr/documentation/pgrouting-1.02/
A tutorial for tsp and
Per OGR2OGR docs:
... or a well known definition (ie. EPSG:4326)
Per http://spatialreference.org/ref/epsg/?search=NAD83
EPSG:2229: NAD83 / California zone 5 (ftUS)
I'm assuming that the fix to GDAL that was previously posted allows this
notation now.
> -Original M
10 matches
Mail list logo