Re: [postgis-users] Tricks to find polygon/line intersection faster

Try something like this. CREATE TABLE interlines(geom geometry,id numeric) WITH (OIDS=FALSE); ALTER TABLE interlines OWNER TO postgres; CREATE OR REPLACE FUNCTION interprob() RETURNS SETOF your_polygon_table AS BODY DECLARE r your_polygon_table%rowtype; BEGIN FOR r IN SELECT * FROM

[postgis-users] (no subject)

hello, I am going to display my postgis raster table using mapserver. I run into this problem: the table public.slp4 contains tiles with different size, and irregular blocking is not supported yet how can I bring a solution to this problem ? regards -- Ahmet Temiz Jeoloji Müh. Afet ve Acil

[postgis-users] Upgrading PostGIS

Hi all, Could someone point me towards some instructions for upgrading my PostGIS version please? I interact with it using PSQL. My current versions are below: PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit POSTGIS=1.5.5SVN

Re: [postgis-users] Upgrading PostGIS

On Mon, Jul 08, 2013 at 02:27:55PM +0100, James David Smith wrote: Hi all, Could someone point me towards some instructions for upgrading my PostGIS version please? I interact with it using PSQL. My current versions are below: PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC

Re: [postgis-users] Creating a multiband raster from 3 single bandrasters

Oops! Use Regina's link instead. I need to flush out my browser's history... -bborie On Sun, Jul 7, 2013 at 10:50 PM, Paragon Corporation l...@pcorp.us wrote: ** cough cough: New docs http://postgis.net/docs/manual-dev/RT_ST_AddBand.html -Regina --

Re: [postgis-users] postgres and postgis upgrade

Sorry for the delay. It was the week end. So I closed the computer. To disable psql command for 8.3.2 version, you have to remove the whole path of your old PostgreSQL installation from you PATH variable and replace it by the new one. Depending of the type of OS you use, ex. on Linux, type

Re: [postgis-users] Tricks to find polygon/line intersection faster

Evan, I don't work with geography types that much but I'm guessing the error is a result of the fact that your 1 degree edges are straight lines in geographic projection (ie: unprojected lat/lon) but when you use a geographic they really should be curved lines but the edge has only the end

[postgis-users] Problem : tiles with different size

hello, I am going to display my postgis raster table using mapserver. I run into this problem: the table public.slp4 contains tiles with different size, and irregular blocking is not supported yet how can I bring a solution to this problem ? regards -- Ahmet Temiz Jeoloji Müh. Afet ve Acil

Re: [postgis-users] Windows support for 9.1 and lower on PostGIS 2.1+

://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- next part -- An HTML attachment was scrubbed... URL: http://lists.osgeo.org/pipermail/postgis-users/attachments/20130708/0049dbc9/attachment-0001.html -- Message: 6 Date: Mon, 8 Jul

Re: [postgis-users] Creating a multiband raster from 3 single bandrasters

Thanks Regina and bborie. Perfect - works a treat! cough cough: New docs http://postgis.net/docs/manual-dev/RT_ST_AddBand.html -Regina Check out the last example (Multi-band versions) of ST_AddBand(). -bborie ___ postgis-users mailing