Re: [postgis-users] st_intersection polygons only

Hello, Maybe I don't understand your problem but in my mind you can select only polygons with a single query using st_dump, like this one : WITH foo AS ( SELECT a.gid, b.gid, (st_dump(st_intersection(a.geom, b.geom))).geom from a, b WHERE st_intersects(a.geom, b.geom) ) SELECT

Re: [postgis-users] st_intersection polygons only

It's not so slow, my coleage changed the testdata. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS user interface

The question of user interface should be driven by functional requirements. QGIS is a great all-around open source and free solution. gvSIG is another free open source software that can handle analysis and cartography. ArcGIS probably has the most advanced combinati

Re: [postgis-users] xkcd

Yestterdays (??) is cool!! http://xkcd.com/1335/ bobb From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Josh Jordan Sent: Thursday, February 27, 2014 11:49 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] xkcd This looks like i

Re: [postgis-users] st_intersection polygons only

so this kinda works, but: * it now returns NULL as a geometry where it should return no record at all * it is about a factor 20 (!) slower than st_intersection Besides that it can only be used for multipolygons. And i would need a better name for it :) Here's the code, i would really appreciate an

[postgis-users] raster2pgsql, netcdf, and windows

Hi all, I'm new to PostGIS, so I apologize in advance if this has been asked and answered, or if this the wrong place. I've just installed Postgres 9.3 on Windows 8.1 from pre-built binaries, and had installed PostGIS 2.1.1 via Stack Builder . I'm trying to use raster2pgsql on a netcdf file

Re: [postgis-users] xkcd

And you should always remember to read the mouse-over text on xkcd... ;-) M. Basques, Bob (CI-StPaul) skrev: > I had to read it more than once if that helps any . . . :c) (I think > it's more in the sarcastic vein as well. I know I've gone over some of > those numbers in the name of efficiency

Re: [postgis-users] xkcd

I had to read it more than once if that helps any . . . :c) (I think it's more in the sarcastic vein as well. I know I've gone over some of those numbers in the name of efficiency!!) bobb From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of

Re: [postgis-users] xkcd

This looks like it could be a page out of a project management textbook. I'm missing the joke! On Thu, Feb 27, 2014 at 12:29 PM, Basques, Bob (CI-StPaul) < bob.basq...@ci.stpaul.mn.us> wrote: > Nothing particularly Spatial about this one, but I think it's worth > mentioning (and I like it) . .

Re: [postgis-users] xkcd

Nothing particularly Spatial about this one, but I think it's worth mentioning (and I like it) . . . http://xkcd.com/1205/ bobb From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Gerry Creager - NOAA Affiliate Sent: Thursday, February 27,

Re: [postgis-users] xkcd

I'd missed that one Brent! Thanks! On Tue, Feb 25, 2014 at 10:40 PM, Brent Wood wrote: > Apologies - that was less than useful!! > > http://xkcd.com/977/ > > Brent Wood. > > -- > *From:* Gerry Creager - NOAA Affiliate > *To:* PostGIS Users Discussion > *Sent:*

Re: [postgis-users] import raster

When using raster2pgsql, you wouldn't pass the -C flag. If you're going to use the generated SQL file, remove the SELECT AddRasterConstraints... line. You can add the raster constraints that you want added later with the AddRasterConstraints() function. -bborie On Thu, Feb 27, 2014 at 8:31 AM,

Re: [postgis-users] import raster

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 wrote: >Do you need the maximum extent constraint? Generally, it is safe to >disable >the maximum extent constraint. > >-bborie > > >On Thu,

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 wrote: > On 2014-02-27 11:19, Rémi Cura wrote: >> >>> Maybe you can try to separate raster2pgsql and psql . >>> >>> First use raster2

[postgis-users] st_intersection polygons only

Hi, When overlaying 2 tables that have polygons with st_intersection, i sometimes get linestrings or points back, or a geometrycollection with a combination of types. What i actually want, is that i only get the overlapping parts (that is, overlapping interiors in DE9IM speak) in the geometrytype

Re: [postgis-users] import raster

On 2014-02-27 11:19, Rémi Cura wrote: Maybe you can try to separate raster2pgsql and psql . First use raster2pgsqland output it to a file on you filesystem. Then use psql to execute this file. You could see how much time each step takes, and how much space the sql temp file is. The sql file

[postgis-users] ELOGeo Repository

Hello, My name is Adam Rousell and I am a researcher at the University of Nottingham working on the ELOGeo repository project. The ELOGeo repository is an OSGeo recognised store for digital material about open geospatial data, software and standards and aims at collecting, preserving and distri

Re: [postgis-users] import raster

On 2014-02-27 11:19, Rémi Cura wrote: Maybe you can try to separate raster2pgsql and psql . First use raster2pgsqland output it to a file on you filesystem. Then use psql to execute this file. You could see how much time each step takes, and how much space the sql temp file is. Maybe you coul

Re: [postgis-users] import raster

Maybe you can try to separate raster2pgsql and psql . First use raster2pgsqland output it to a file on you filesystem. Then use psql to execute this file. You could see how much time each step takes, and how much space the sql temp file is. Maybe you could use the "-Y" flag to make it faster?

[postgis-users] import raster

Hi all, My SELECT PostGIS_Full_Version() is: "POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.9.0" LIBJSON="UNKNOWN" RASTER" I am importing a GeoTIFF (1 band, Type = Byte, Not Compressed file size = 933.5 MB, c