Re: [postgis-users] Can anyone interpret this error? ERROR: current transaction
Robert, it will work, you'll just have to get it a different way. The GeoServer and other components of the Suite will be happy to talk to an independently installed PostGIS. Perhaps using the DebianGIS packages you can get something that installs on the provider machines? (I admit to relatively little Ubuntu knowledge) Meanwhile, as we transition to providing the Linux Suite in packages, I will file away that we need to build out earlier Ubuntu variants as well. Paul On Sun, Dec 12, 2010 at 11:49 AM, Robert Buckley wrote: > Hi, > > Thanks for the bad news. My server provider can´t for some reason install > anything above 8.04!! > > I`ll ask him again tomorrow if there is a workaround to get 10.04 on the > server partition, but if not, will that mean postgis will not work with > opengeosuite on 8.04? > > That´ll be quite a let down! > > I quess I´ll have to do it the long way with geoserver postgresql and > postgis separate install and 2 months of scratching my head. > > Thanks for the reply, > > Yours, > Robert > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Kyng chaos Postgis -- "PostGIS requires PostgreSQL 9.0."
Hi all, Not sure where else to ask -- I just installed Postgresql 9.0.1 from the Kyngesbury site, now trying to install postgis, and I get this error: "PostGIS requires PostgreSQL 9.0." Anyone have any ideas? Does this mean "I can't find any postgres"? or "I can't find the right version" or ??? Thanks! -- Asking a question on a newsgroup? Read this first: http://www.catb.org/~esr/faqs/smart-questions.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to handle tiled rasters (ST_Value, grid_pt=>coord, coord=>grid_pt etc)?
Stefan, > The main characteristics to me have been, 1. if a coverage overlaps or not, and 2. if it is a tiled image. The fact (1) of non-overlapping can significantly speed up queries and the second would help to "reconstruct" the original file. Both consequently > could to be stored in metadata. I don't know enough about how the processing works to know if keeping track of overlapping vs. non-overlapping would speed up queries. Logically I can see how it would help outputting the data into images, but I don't see how it would Speed up queries. Well at least not the analytical queries I'm thinking of where I would be selecting records with geometric intersect queries or by attribute relationships. I probably wouldn't be keeping overlapping rasters in the same table unless I was relating each specifically to some specific feature like the thermal pictures I took of the racks in my network lab. > In other words, if it's a tiled image, would'nt it be good practice to store that in a single table (without any other images)? > I say this because I realize that it's possible to load many raster filed into the same raster table even with different blocksize_x and blocksize_y (in which case I wonder what get's stored in raster_columns). The concept of an image file when you start talking about raster in the database is amorphous and menaningless to me. For example I've got gigabytes of Massachusetts aerials I'd like to bring into my database. For convenience they have these distributed as even sized tiles of say 5 mb in size each. Once I bring it in, do I care how they had it stored. NOT REALLY except to reference back. Most likely when I output it, I won't even be outputting it in the same sizes they chose to. Mine would be based on some query where the user says -- give me the imagery for my building block. If I really cared, I would use the raster2pgsql switch that includes the originating file name as a column in my raster table. Then I could reconstitute with a command line something like gdal_translate -of GTiff PG:"host='localhost' port='5432' dbname='mygisdb' user='postgres' password='whatever' schema='ch13' table='vietelev' where="filename='relief.jpg'" My syntax I haven't tested but you get the basic idea. I most likely will chop it up much smaller than the 5 MB size because 5 MB is too big for me to do the analysisi I want to do with it. E.g. figuring out how much grassy land is in Boston or extruding building footprints etc. There choice of How they decided to define what an image file is is pretty irrelevant to me and I think to most people. I could be wrong. Will I keep all the files in the same table or separate tables? I'd keep it in the same table but bring them all in with the same block size etc which the raster_columns does keep track of. In fact I may bring them in at different times. An even crazier idea -- I may load different years in the same table -- but I'd probably keep the block size the same if I were to keep them in the same table. > As you assumed below, my other example 'relief_jpg' is a single raster (originally only 158K). How can I speed up the following query? It's a query on one row and it takes indefinitely long: > SELECT ST_Value(ST_Reclass(rast, 1, '1:2'), 1, 1) FROM relief_jpg; Are you using the ST_Reclass currently in the scripts folder of raster? I think that is currently much slower than in needs to be. Its especially slow if you have your rast as a single record, because each change requires a memcopy. You would really need to chop it up. > The subclause uses "... FROM relief_jpg) dummy" whereas in the where clause there's "WHERE r_table_name = 'relief_jpg';". > I simply thought this is an indication that there's some more information that could be stored in the metadata, like the fact that the 240 tiles form a single raster coverage and are non-overlapping. > But I probably still have to think about all this. I think there is still discussion going on about what and what shouldn't be in raster_columns so I suspect the number of columns in that table will grow before PostGIS 2.0 is out. Good to think about these things now :) Hope that helps, Regina http://www.postgis.us ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Can anyone interpret this error? ERROR: current transaction
Hi, Thanks for the bad news. My server provider can´t for some reason install anything above 8.04!! I`ll ask him again tomorrow if there is a workaround to get 10.04 on the server partition, but if not, will that mean postgis will not work with opengeosuite on 8.04? That´ll be quite a let down! I quess I´ll have to do it the long way with geoserver postgresql and postgis separate install and 2 months of scratching my head. Thanks for the reply, Yours, Robert ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How detect an empty geometry in a Collection.
>I don't know how to detect if the first or the second element are "geometry >empty". Resolved. I can use the ST_IsEmpty(ST_GeometryN(geom, 1)) ST_IsEmpty(ST_GeometryN(geom, 2)) to test the first and the second element of geom-collection. - - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Can anyone interpret this error? ERROR: current transactio
Robert, I just happened to remember what you're talking about :) but in future you'll want to include a little more context. So that explains it, since our build is happening on 10.4, we're building binaries that expect a higher version of C++ than you have installed. P. On Sun, Dec 12, 2010 at 1:04 AM, Robert Buckley wrote: > Hi, > > Ubuntu 8.04 Hardy > > yours, > > Robert > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Bandwidth
I have an interface accessing a Postgis database on my computer. Is there some method of measuring the bandwidth of the communication between them?? Alternately, is there a rule of thumb that can be used to estimate bandwidth?? Bob___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] How detect an empty geometry in a Collection.
Hi, I have some geometries where every element is a GeometryCollection like this three examples: GeometryCollection(MultiLinestring empty, MultiLinestring(( x1 y1, ... , xn yn))) ; GeometryCollection(MultiLinestring(( x1 y1, ... , xn yn)), MultiLinestring(( x1 y1, ... , xn yn))) ; GeometryCollection(MultiLinestring(( x1 y1, ... , xn yn)), MultiLinestring empty) ; These are all geometry-collection where every collection is composed of two element and the first or the second could be a "geometry empty". I don't know how to detect if the first or the second element are "geometry empty". I try with to apply the ST_Dump, but it seem to ignore the "geometry empty" so it return only one record. Thx, Andrea. -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Can anyone interpret this error? ERROR: current transactio
Hi, Ubuntu 8.04 Hardy yours, Robert ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
