Re: [postgis-users] compiling documentation

On Tue, Apr 24, 2012 at 08:56:15AM +0200, Pasquale Di Donato wrote: > > > > By using the ./make_dist.sh call and working inside the created > > folder it won't be easy to contribute patches back, instead > > you can take out the 2nd step: > > > >  -> svn checkout http://svn.osgeo.org/postgiss/trunk

Re: [postgis-users] Raster import is causing Postgres to close

Thanks to both - definitely the error was caused by the Raster file I was trying to load was too large - PgAdmin could not handle the SQL file. I have cut the Raster down to a smaller area and am using that instead. Kind Regards, James - GIS Undergraduate -- View this message in context:

[postgis-users] Geom/Rast Intersection St9bad_alloc

Hi all, I am attempting to intersect a thermal raster TIFF with a MasterMap shapefile. Both sets of data are stored in my database successfully and the query I am running is: SELECT gid, ST_Intersection(geom, rast, 1) FROM clip_build, nclheat WHERE ST_Intersects(rast, geom) The raster file is qu

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

On Tue, Apr 24, 2012 at 02:50:37AM -0700, JamesH wrote: > Hi all, > > I am attempting to intersect a thermal raster TIFF with a MasterMap > shapefile. > > Both sets of data are stored in my database successfully and the query I am > running is: > SELECT gid, ST_Intersection(geom, rast, 1) > FROM

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

"St9Bad_alloc means the process run out of memory. There may be a memory leak or uncareful use in ST_Intersection(raster,geometry)." Thought it could be something like that. "Try restricting the scope of your queries, using subsets from clip_build and nclheat and storing the results in a temporar

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

On Tue, Apr 24, 2012 at 03:06:15AM -0700, JamesH wrote: > I've checked and seen that my raster is actually three bands when I thought > it was just single band. > Is there a way to alter the query to account for this? ST_Band ? http://www.postgis.org/documentation/manual-svn/RT_ST_Band.html --s

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

"ST_Band ?" Thank you. Have tried ST_Intersection(geom, rast, ST_Band(rast, ARRAY[1,2,3])) in query above Returns: function st_intersection(geometry, raster, raster) does not exist. Have also attempted ST_Intersection(geom, rast, ST_Band(rast, '1,2,3')) but this returns the same error. Basic sy

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

On Tue, Apr 24, 2012 at 03:51:27AM -0700, JamesH wrote: > Have tried ST_Intersection(geom, rast, ST_Band(rast, ARRAY[1,2,3])) in query What were you trying to achieve ? Did you read the reference manual ? --strk; ,--o-. | __/ |Delivering high quality PostGIS 2.0 ! | / 2.0 |

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

I am attempting to intersect a vector dataset of building polygons with a 3-Band Thermal tiff to produce a dataset that shows the thermal readings for each polygon. "What were you trying to achieve ? Did you read the reference manual ?" I hoped from the example in the reference "-- Return bands 2

Re: [postgis-users] Euclidean Distance Raster

"> I am wanting to create a Raster in PostGIS that displays the Euclidean > Distance between Points that I have in a table. > It can be done in ArcGIS, using the Euclidean Distance tool but I'm aiming > to create it through PostGIS. There is no easy tool to do that right now. You will have to use

Re: [postgis-users] Postgis2.0 documentation for Windows

"Is there any online or at least any useful articles and tips? I guess some things must be the same with the linux documentation but some others, like uploading a raster file, cannot be the same." Is there a specific task you're trying to acheive? I use Postgis 2.0 on Windows and although the sy

[postgis-users] type "public.geometry" is only a shell

I recently dumped a database and attempted to rebuild postgis and my database on an alternate server. I am receiving a message: ERROR: type "public.geometry" is only a shell SQL state 42704 I'm pretty sure I put everything in correctly when rebuilding. Is anyone aware of what this message is

Re: [postgis-users] type "public.geometry" is only a shell

On Tue, Apr 24, 2012 at 08:46:19AM -0400, Gold, Jack L (US SSA) wrote: > I recently dumped a database and attempted to rebuild postgis and my database > on an alternate server. I am receiving a message: > > ERROR: type "public.geometry" is only a shell > SQL state 42704 > > I'm pretty sure I p

Re: [postgis-users] type "public.geometry" is only a shell

Thanks Sandro. That was exactly it and gives me more insight to what I'm doing. --Jack -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Sandro Santilli Sent: Tuesday, April 24, 2012 8:51 AM To: Pos

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

"I am attempting to intersect a vector dataset of building polygons with a 3-Band Thermal tiff to produce a dataset that shows the thermal readings for each polygon." If I took the 3 band jpeg of this raster and used ST_AsTiff to convert it to a single band tiff would this calculation be valid? Ho

[postgis-users] banging my head on setting up and running geodjango

Hi, I am really fed up in setting up and running GeoDjango. The first step was to setup the Spatial Database in PostGIS which I was really banging my head when it came to OS X. So i shifted to Ubuntu 11.10 and it seemed it was quite easy. Now having completed the post installation process

Re: [postgis-users] banging my head on setting up and running geodjango

Could you post your settings.py please? I think it's a problem with the database section. Le 24 avr. 2012 19:03, "Smaran Harihar" a écrit : > Hi, > > I am really fed up in setting up and running GeoDjango. > > The first step was to setup the Spatial Database in PostGIS which I was > really bangin

[postgis-users] Topology

Hi I’ve set up postgis 2.0 and have run the topology.sql file. Select postgis_full_version() returns the TOPOLOGY label. However, unlike the postgis 1.5 setup, when I run select topology.CreateTopology('TEST', -1); I get the following error which I’m not able to interpret. NOTICE: CREATE TABL

Re: [postgis-users] banging my head on setting up and running geodjango

thanks for replying. I have attached the settings.py file On Tue, Apr 24, 2012 at 10:10 AM, Nabil Servais wrote: > Could you post your settings.py please? I think it's a problem with the > database section. > Le 24 avr. 2012 19:03, "Smaran Harihar" a > écrit : > >> Hi, >> >> I am really fed up

Re: [postgis-users] banging my head on setting up and running geodjango

how do I verify if my database is proper? On Tue, Apr 24, 2012 at 10:14 AM, Smaran Harihar wrote: > thanks for replying. I have attached the settings.py file > > > On Tue, Apr 24, 2012 at 10:10 AM, Nabil Servais > wrote: > >> Could you post your settings.py please? I think it's a problem with th

Re: [postgis-users] Topology

On Tue, Apr 24, 2012 at 10:14:52AM -0700, Bob Pawley wrote: > I’ve set up postgis 2.0 and have run the topology.sql file. > Select postgis_full_version() returns the TOPOLOGY label. > > However, unlike the postgis 1.5 setup, when I run > select topology.CreateTopology('TEST', -1); ... > ERROR:

[postgis-users] Installation Error

Hi, I tried installing GeoDjango on Ubuntu and assumed that GEOS and Proj existed on Linux and directly installed PostGIS. Now I ran the tests as given on the Django site, and this is the output I am receivi

Re: [postgis-users] Topology

pg_proc returns 6 rows. Three rows identical to yours and three rows with column proargnames returning a blank or (null) value. postgresql version returns PostreSQL 9.1.3. Bob -Original Message- From: Sandro Santilli Sent: Tuesday, April 24, 2012 10:28 AM To: PostGIS Users Discussi

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

James, Sorry for this late answer. -What is the type of the geometries you are intersecting with the raster? -If they are polygons, what proportion of your raster does all your geometry layer represent? If this proportion is very high (your polygons cover like 90% of the raster extent and y

Re: [postgis-users] Topology

On Tue, Apr 24, 2012 at 10:56:44AM -0700, Bob Pawley wrote: > pg_proc returns 6 rows. > > Three rows identical to yours and three rows with column > proargnames returning a blank or (null) value. Yeah, so a dirty upgrade (how did you upgrade?). Remove the non-matching ones (or all of them and l

Re: [postgis-users] Geom/Rast Intersection St9bad_alloc

"What is the type of the geometries you are intersecting with the raster?" I am intersecting a shapefile of polygons. -If they are polygons, what proportion of your raster does all your geometry layer represent? They do cover a large proportion of the raster. ST_SummaryStatsAgg is not installed

Re: [postgis-users] Topology

-Original Message- From: Sandro Santilli Sent: Tuesday, April 24, 2012 12:12 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Topology On Tue, Apr 24, 2012 at 10:56:44AM -0700, Bob Pawley wrote: pg_proc returns 6 rows. Three rows identical to yours and three rows wit