[postgis-users] is it possible to view postgis raster data using geoserver and openlayer?

i know it is given in your frequently asked questions that postgis raster data can be viewed with Mapserver and Qgis. is it possible to view postgis raster data using geoserver and openlayer? -- View this message in context:

[postgis-users] does postgis create indexes for each tile or each band in a raster table?

-- View this message in context: http://postgis.17.n6.nabble.com/does-postgis-create-indexes-for-each-tile-or-each-band-in-a-raster-table-tp4475322p4475322.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing

[postgis-users] what is constraint enforce_out_db_rast?

UPDATE image2tiff set rast = ST_AddBand(ST_Band(rast, 2), rast ,1) where rid=5; ERROR: new row for relation image2tiff violates check constraint enforce_out_db_rast ** Error ** ERROR: new row for relation image2tiff violates check constraint enforce_out_db_rast SQL state:

[postgis-users] what is the query to build a multi band raster table from existing raster table of bands?

what is the query to build a multi band raster table from existing raster table of bands? -- View this message in context: http://postgis.17.n6.nabble.com/what-is-the-query-to-build-a-multi-band-raster-table-from-existing-raster-table-of-bands-tp4475646p4475646.html Sent from the PostGIS - User

[postgis-users] qgis pgrouting plugin error

Dear All I am having a problem in installing the pgrouting plugin of QGis on Windows. I am new to this, thus need some step wise guide to figure it out.. Thnx   Warm Regards Ali Kha-mis GIS Developer AA Associates Karachi. +92334-3584003___

Re: [postgis-users] what is the query to build a multi band raster table from existing raster table of bands?

www.google.com www.postgis.org/documentation HTH On Thu, Feb 16, 2012 at 11:35 AM, Zelio Fernandes zelio.f...@gmail.comwrote: what is the query to build a multi band raster table from existing raster table of bands? -- View this message in context:

Re: [postgis-users] ST_AsJpeg

2012/2/16 Sandro Santilli s...@keybit.net: I don't think there's much to discuss. I'm sure a patch to psql would be welcome. Sorry, I did not realize that the solution is straight forward :- --Stefan ___ postgis-users mailing list

Re: [postgis-users] How can i interchange(swap) the values of a band in postgis raster

Try like this: SELECT ST_Band(rast, ARRAY[2,1]) FROM image2tiff; -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- boun...@postgis.refractions.net] On Behalf Of Zelio Fernandes Sent: Thursday, February 16, 2012 12:45 AM To:

Re: [postgis-users] is it possible to view postgis raster data using geoserver and openlayer?

Yes -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- boun...@postgis.refractions.net] On Behalf Of Zelio Fernandes Sent: Thursday, February 16, 2012 4:43 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] is it possible

Re: [postgis-users] does postgis create indexes for each tile or each band in a raster table?

raster2pgsql optionally creates one index per table. You can create index yourself with the CREATE INDEX statement. Read the doc. -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- boun...@postgis.refractions.net] On Behalf Of Zelio Fernandes

Re: [postgis-users] what is the query to build a multi band raster table from existing raster table of bands?

I feel like I'm responding to a question generator bot :-( Try something like: CREATE newtable AS SELECT ST_AddBand(ST_Band(table1.rast, 1), ST_Band(table2.rast, 1)) rast FROM table1, table2 WHERE table1.rid = table2.rid Pierre -Original Message- From:

Re: [postgis-users] what is constraint enforce_out_db_rast?

Search for enforce_out_db in: http://trac.osgeo.org/postgis/wiki/WKTRaster/SpecificationWorking03 Did you load your raster using the -R raster2plpgsql option? -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-

Re: [postgis-users] How to get all the attribute values of a classified image into postgis 2.0?

Where are those attributes stored? In the raster file itself? In a sister file? Which format? Could you send a sample? Pierre -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- boun...@postgis.refractions.net] On Behalf Of Zelio Fernandes

Re: [postgis-users] setting up or accessing a host

Thanks Ben, I tried setting the pg_hba as you specified, and that seems to work. I'm only working with a development machine now, no sensitive data and can't be accessed outside the WAN, but these issues will become more important later. From:

[postgis-users] Point to Polygon edge ST_DWithin

Hi, I need to create a WHERE statement which is true if a point is within 1 metres of the closest edge of a polygon (EPSG:27700). I have this working fine for point to point queries, but I am struggling with point to polygon. I also need to perform ST_Azimuth on the resulting data to

[postgis-users] PostGIS Types Across Schemas

We are preparing our data for production, and have a few import procedures to do so. To keep the database organized, we are creating 2 schemas: public, and import. CREATE TABLE import.geo_shapes ( geo_shape_id serial NOT NULL, geocode character varying(9), geography

[postgis-users] [Building PostGIS2.0] undefined reference to `libintl_printf'

Hi everyone, I got the following error while building (making) PostGIS 2.0: *** Making all in loader make[1]: Entering directory `/c/projects/postgis/postgis-2.0.0alpha5SVN/loader' /bin/sh ..//libtool --mode=link gcc -g -O2 -DDLL_EXPORT -DPIC

Re: [postgis-users] [Building PostGIS2.0] undefined reference to `libintl_printf'

I feel like in the link step the mingw is happier when you put static libraries at the end of the link line. Just a feeling though. P. On Thu, Feb 16, 2012 at 10:19 AM, GeoFox edison@ngc.com wrote: Hi everyone, I got the following error while building (making) PostGIS 2.0:

[postgis-users] distance between 2 polygons

Hi For each polygon I need to find the nearest polygon. I used ST_Distance(geometry, geometry) I succesfully did it but I want to make sure to interpret the result correctly Does A distance of 0 mean that the polygons touch each other or it means that their bounding box touch each other? What

Re: [postgis-users] PostGIS Types Across Schemas

You can run Probe_Geometry_Columns() after altering the schema of your imported table. Another option is to update the geometry columns table manually with something like: UPDATE geometry_columns SET f_schema_name = 'public' WHERE f_table_name = 'geo_shapes'; -Rob

[postgis-users] Mapserver/Postgis connection and WMS query

Hi List, (I did send a very similar question to the mapserver list two days ago but I didn't hear any comments or suggestions. This is a problem between mapserver and postgis). I'm using mapserver to display some rasters as WMS layers using Openlayers. At the moment I have all my rasters in a

Re: [postgis-users] Mapserver/Postgis connection and WMS query

From what I know there is no way this should work. You have to read the raster layer as a GDAL layer. This is what is done in PostGIS in Action. Pierre -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- boun...@postgis.refractions.net] On

Re: [postgis-users] Mapserver/Postgis connection and WMS query

Pierre, What do you mean by reading the raster layer as a GDAL layer? In the PostGIS in Action raster example it seemed to just connect to the database, with no query using : Data PG:host=localhost . I tried removing CONNECTION and DATA and using the following: DATA PG:host=18.00.00.00

Re: [postgis-users] Mapserver/Postgis connection and WMS query

This is a GDAL PostGIS connection string, not a direct PostGIS connection sting. Check: http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html Make sure gdal_translate is able to export your raster to a tiff before trying the same connection string with MapServer. Pierre -Original

Re: [postgis-users] When to use Vacuum Analyze

Thanks, Stephen. Sheara Cohen Planner C A L T H O R P E A S S O C I A T E S 2095 ROSE STREET, SUITE 201, BERKELEY, CALIFORNIA, 94709 USA 510 809-1165 (direct) | 510-548-6800 x35 (main) | 510 548-6848 (fax) she...@calthorpe.commailto:she...@calthorpe.com | www.calthorpe.com

Re: [postgis-users] Point to Polygon edge ST_DWithin

Hallo What you do is htat you use the linestrings defining the polygons instead of the polygon instead in the ST_Dwithin statement. Then you can also us ST_Closestpoint to find a line between the point and the closest point on the edge. This line can you use in ST_Azimuth. If your polygons

Re: [postgis-users] distance between 2 polygons

Hallo Does A distance of 0 mean that the polygons touch each other or it means that their bounding box touch each other? From ST_Distance distance 0 menas that they are touching or overlapping each other What does a distance of 100 mean?. Is it the shortest distance between the 2 polygons

[postgis-users] ST_Crosses doesn't use index?

Hi ST_Crosses doc says that it uses the spatial index (if available). But I'm afraid it's not. I'm using PostGIS 1.5 on Linux. -- as it should be: SELECT name FROM osm_line a, osm_line b WHERE a.osm_id != b.osm_id AND ST_Crosses(a.way, b.way) -- takes longer than 60 sec, 586 features. -- now

Re: [postgis-users] ST_Crosses doesn't use index?

You might provide a description of the tables (\d at the psql prompt), and perhaps the output of an EXPLAIN ANALYZE for this command. Any non-standard config settings might be of relevance as well. Greg Williamson - Original Message - From: Stefan Keller sfkel...@gmail.com To:

Re: [postgis-users] ST_Crosses doesn't use index?

Stefan, This has to do with your data / configuration, not ST_Crosses, as the function clearly includes an index call. CREATE OR REPLACE FUNCTION ST_Crosses(geometry,geometry) RETURNS boolean AS 'SELECT $1 $2 AND _ST_Crosses($1,$2)' LANGUAGE 'SQL' IMMUTABLE; P. On Thu,

Re: [postgis-users] ST_Crosses doesn't use index?

2012/2/17 Greg Williamson gwilliamso...@yahoo.com: You might provide a description of the tables (\d at the psql prompt), and perhaps the output of an EXPLAIN ANALYZE for this command. Any non-standard config settings might be of relevance as well. Greg Williamson Ok; I realize that my