Re: [postgis-users] clip a polygon layer with another polygon later

2012-06-08 Thread Puneet Kishor
On Jun 8, 2012, at 10:30 PM, Brent Wood wrote: > Without looking too much into it, I figure you can do this using a case when > statement to identify & return the appropriate geometry for the different > cases, with perhaps a coalesce to handle nulls?? I realized that my query was goofy. So,

[postgis-users] clip a polygon layer with another polygon later

2012-06-08 Thread Puneet Kishor
Given CREATE TABLE outline ( id, the_geom ); and CREATE TABLE polys ( id, the_geom ); I want to update polys.the_geom with only those that are clipped by "outline". That is, all the "polys" that are

[postgis-users] Need sme help to debug a code

2012-06-08 Thread gautam kumar
hi, While using postgis with mapserver ... i am getting black image in place of raster image... please help ... LAYER NAME coolwktraster TYPE raster STATUS DEFAULT #CONNECTIONTYPE ogr DATA "PG:host=localhost port=5433 dbname='postgis' user='postgres' password='asdf' schema='public' table='test'

Re: [postgis-users] Topology: Simplifying Coastlines with Islands

2012-06-08 Thread Michiel J. van Heek
Quoting Sandro Santilli : On Tue, May 29, 2012 at 03:23:06PM +0200, Sandro Santilli wrote: I recon that for long island, splitting the unsimplified edge on the closest point to the island might make it simplifiable. Probably a single point is not enough for the Brazil case, but a recursive app

Re: [postgis-users] ST_Intersects not finding everythng?

2012-06-08 Thread DrYSG
Sorry for the false warning. I was doing some direct testing with PgAdmin today, and I can confirm that it is not a PostGIS 2.0 issue. (I was being completely misled by my toolware chain which was reporting that all the 1545 records were being found, but was actually hiding some of them! so I thoug

Re: [postgis-users] gdalinfo gives no georeferencing information for a PostGIS raster

2012-06-08 Thread Bborie Park
Robin, The output you're seeing is as expected. When calling gdalinfo with no "mode" setting, I believe the mode is defaulted to "mode=1". According to the docs... "mode = 1. Also called ONE_RASTER_PER_ROW mode. In this case, a raster table is considered as a bunch of different raster files. Thi

Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install

2012-06-08 Thread Donald Kerr
Ok, Mark, thanks for the confirmation. I suppose then that I would have to dump the contents of the 32 bit setup then import to the 64 bit setup which I'm assuming is possible. Offhand, do you, or does anyone else, know if replication from 32 bit to 64 bit works? What I'm trying to do is maintain

Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install

2012-06-08 Thread Mark Cave-Ayland
On 07/06/12 14:00, Donald Kerr wrote: Thanks, Regina. After uninstalling, I tried a fresh install of PostgreSQL followed by a fresh install of PostGIS. The difference this time is that I did not use the existing data structure and started with a new one. The installation went well and without e

[postgis-users] gdalinfo gives no georeferencing information for a PostGIS raster

2012-06-08 Thread Robin Wilson
Hi, I'm fairly new to PostGIS (version 2) and I'm struggling with a problem where gdalinfo doesn't seem to give the correct georeferencing information for a raster in PostGIS. I've asked a StackOverflow question about it, and I wondered if anyone here may be able to help - either on this mailin

Re: [postgis-users] Error adding raster support

2012-06-08 Thread Luis
Hi Bborie, I compiled PostGIS 2 from the source. It is not available in the repos for Ubuntu 10.04. Thank you. -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998112.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___

[postgis-users] Installation error: database "template_postgis_20" does not exist

2012-06-08 Thread Kidd, David
Hi When I try and install PostGIS 2.0 using Stack Builder on Windows 7 64-bit I get a warning: WARNING: The installer has detected that the PostGIS template database 'template_postgis_20' already exists. The message then informs me that the installer will create a new 'template_postgis_20' an