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

Mon Jul 8 13:08:25 PDT 2013

We have a Windows system with PostgreSQL 9.1, PostGIS, and an ESRI 
spatial database. ESRI 10.1 software only officially supports PostgreSQL 
9.1, and only on Windows Server, and there's no telling when anything 
newer will be supported, so we're stuck with 9.1.

-Greg
Traffic Safety & Operations Laboratory
University of Maryland, College Park

On 07/08/2013 03:00 PM, postgis-users-request at lists.osgeo.org wrote:
> Message: 2
> Date: Sun, 7 Jul 2013 21:48:29 -0400
> From: "Paragon Corporation" <lr at pcorp.us>
> To: "'PostGIS Users Discussion'" <postgis-users at lists.osgeo.org>
> Cc: 'PostGIS Development Discussion' <postgis-devel at lists.osgeo.org>
> Subject: [postgis-users] Windows support for 9.1 and lower on PostGIS
> 	2.1+
> Message-ID: <805F41D90B5B43208B2BE627079D3D37 at O>
> Content-Type: text/plain;	charset="us-ascii"
>
> We want a show of hands how many windows users plan to be using
>
> PostgreSQL 9.1 and lower with PostGIS 2.1+? Keep in mind that PostGIS 2.1+
> requires PostgreSQL 9.0 or above so if you are running
> 8.4 don't bother raising your hands.
>
> The reason we ask is with PostGIS 2.1+ we are planning to drop installer
> packaging of PostgreSQL 9.1 and PostgreSQL 9.0.
> We'll still be providing the 64-bit binaries for PostgreSQL 9.1,9.0 however
> but plan to retire our old build chain for 32-bit (that supported 32-bit
> 8.4,9.0,9.1)
>
>
> We are dropping installer packaging for prior versions in PostGIS 2.1
> because we'll be shipping pgRouting with 2.1
>   and PostGIS 2.2 will include
>   pointcloud + pgRouting support for sure and most likely SFCGAL as well.
>
> That said -- PostGIS has gotten bigger and the biggest time sink for us is
> testing installers and versions, especially ones our clients don't use since
> we can't offset the cost.
>
>
> Keep in mind THIS IS NOT ABOUT PostGIS 2.0.  PostGIS 2.0 we'll still be
> providing installers and micro version upgrades for all PostgreSQL versions
> we started supporting in those PostGIS minors (e.g. PostGIS 2.0
> 8.4,9.0,9.1,9.2 users will still get micro releases for 2.0 via stack
> builder)
>
> Thanks,
> Regina and Leo
> http://www.postgis.us
> http://postgis.net
> http://www.paragoncorporation.com
>
>
>
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 8 Jul 2013 13:43:49 +1000
> From: Mark Wynter <mark at dimensionaledge.com>
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] Creating a multiband raster from 3 single
> 	band	rasters
> Message-ID: <14356BAE-AB02-4257-9A63-71E0A23E5A6A at dimensionaledge.com>
> Content-Type: text/plain; charset=us-ascii
>
> I'm hoping someone can suggest a way of efficiently combining 3 individual (but concordant) single band rasters into single raster having 3 bands?  We're working with PostgreSQL9.1, PostGIS2.1Beta.
>
> The starting point is a single tiled raster with 3 bands representing RGB values.
>
> Let's say we perform some color smoothing on each of the RGB bands using mapalgebra.
>
> CREATE TABLE resample_myrastertable_b1 AS
> SELECT rid, st_mapalgebrafctngb(rast, 1, '8BUI', 5, 5, 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast FROM original_rastertable;
>
> CREATE TABLE resample_myrastertable_b2 AS
> SELECT rid, st_mapalgebrafctngb(rast, 2, '8BUI', 5, 5, 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast FROM original_rastertable;
>
> CREATE TABLE resample_myrastertable_b3 AS
> SELECT rid, st_mapalgebrafctngb(rast, 3, '8BUI', 5, 5, 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast FROM original_rastertable;
>
> This gives us 3 single-band results rasters.
>
> How do we now join the individual smoothed RGB "results" rasters into a single multiband "results" raster?   We'd also like to add a 4th band to the "results" raster based on say a calculation which references the smoothed values in bands 1-3.
>
> I'm getting reasonably comfortable writing MapAlgebra callback expressions.   Its more a case of how do we efficiently handle table operations (e.g. appending single band raster outputs) each time we perform some MapAlgebra?
>
> Any suggestions and or a simple worked example would be most appreciated.
>
> Many thanks
>
> Mark
>
>
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sun, 7 Jul 2013 21:38:13 -0700
> From: Bborie Park <dustymugs at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] Creating a multiband raster from 3 single
> 	band	rasters
> Message-ID:
> 	<CAKVfRvHkNUpHKkauhnS5278hZJP-QWtCtROSUrUz_vJ1go8=8w at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Check out the last example (Multi-band versions) of ST_AddBand().
>
> http://postgis.refractions.net/documentation/manual-svn/RT_ST_AddBand.html
>
> -bborie
>
>
> On Sun, Jul 7, 2013 at 8:43 PM, Mark Wynter <mark at dimensionaledge.com>wrote:
>
>> I'm hoping someone can suggest a way of efficiently combining 3 individual
>> (but concordant) single band rasters into single raster having 3 bands?
>>   We're working with PostgreSQL9.1, PostGIS2.1Beta.
>>
>> The starting point is a single tiled raster with 3 bands representing RGB
>> values.
>>
>> Let's say we perform some color smoothing on each of the RGB bands using
>> mapalgebra.
>>
>> CREATE TABLE resample_myrastertable_b1 AS
>> SELECT rid, st_mapalgebrafctngb(rast, 1, '8BUI', 5, 5,
>> 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast
>> FROM original_rastertable;
>>
>> CREATE TABLE resample_myrastertable_b2 AS
>> SELECT rid, st_mapalgebrafctngb(rast, 2, '8BUI', 5, 5,
>> 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast
>> FROM original_rastertable;
>>
>> CREATE TABLE resample_myrastertable_b3 AS
>> SELECT rid, st_mapalgebrafctngb(rast, 3, '8BUI', 5, 5,
>> 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast
>> FROM original_rastertable;
>>
>> This gives us 3 single-band results rasters.
>>
>> How do we now join the individual smoothed RGB "results" rasters into a
>> single multiband "results" raster?   We'd also like to add a 4th band to
>> the "results" raster based on say a calculation which references the
>> smoothed values in bands 1-3.
>>
>> I'm getting reasonably comfortable writing MapAlgebra callback
>> expressions.   Its more a case of how do we efficiently handle table
>> operations (e.g. appending single band raster outputs) each time we perform
>> some MapAlgebra?
>>
>> Any suggestions and or a simple worked example would be most appreciated.
>>
>> Many thanks
>>
>> Mark
>>
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://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/20130707/e586c7c3/attachment-0001.html>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 8 Jul 2013 01:50:59 -0400
> From: "Paragon Corporation" <lr at pcorp.us>
> To: "'PostGIS Users Discussion'" <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] Creating a multiband raster from 3 single
> 	bandrasters
> Message-ID: <7F644E6CD29848DDBE15AD66197D10DE at O>
> Content-Type: text/plain; charset="us-ascii"
>
> cough cough: New docs
>   
> http://postgis.net/docs/manual-dev/RT_ST_AddBand.html
>   
> -Regina
>   
>
>    _____
>
> From: postgis-users-bounces at lists.osgeo.org
> [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Bborie Park
> Sent: Monday, July 08, 2013 12:38 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Creating a multiband raster from 3 single
> bandrasters
>
>
> Check out the last example (Multi-band versions) of ST_AddBand().
>
> http://postgis.refractions.net/documentation/manual-svn/RT_ST_AddBand.html
>
>
> -bborie
>
>
> On Sun, Jul 7, 2013 at 8:43 PM, Mark Wynter <mark at dimensionaledge.com>
> wrote:
>
>
> I'm hoping someone can suggest a way of efficiently combining 3 individual
> (but concordant) single band rasters into single raster having 3 bands?
> We're working with PostgreSQL9.1, PostGIS2.1Beta.
>
> The starting point is a single tiled raster with 3 bands representing RGB
> values.
>
> Let's say we perform some color smoothing on each of the RGB bands using
> mapalgebra.
>
> CREATE TABLE resample_myrastertable_b1 AS
> SELECT rid, st_mapalgebrafctngb(rast, 1, '8BUI', 5, 5,
> 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast
> FROM original_rastertable;
>
> CREATE TABLE resample_myrastertable_b2 AS
> SELECT rid, st_mapalgebrafctngb(rast, 2, '8BUI', 5, 5,
> 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast
> FROM original_rastertable;
>
> CREATE TABLE resample_myrastertable_b3 AS
> SELECT rid, st_mapalgebrafctngb(rast, 3, '8BUI', 5, 5,
> 'st_mean4ma(float[][],text,text[])'::regprocedure, 'ignore', NULL) as rast
> FROM original_rastertable;
>
> This gives us 3 single-band results rasters.
>
> How do we now join the individual smoothed RGB "results" rasters into a
> single multiband "results" raster?   We'd also like to add a 4th band to the
> "results" raster based on say a calculation which references the smoothed
> values in bands 1-3.
>
> I'm getting reasonably comfortable writing MapAlgebra callback expressions.
> Its more a case of how do we efficiently handle table operations (e.g.
> appending single band raster outputs) each time we perform some MapAlgebra?
>
> Any suggestions and or a simple worked example would be most appreciated.
>
> Many thanks
>
> Mark
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://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 2013 11:55:22 +0200
> From: Nicolas Ribot <nicolas.ribot at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] Calculation of Radius in PostGIS
> Message-ID:
> 	<CAGAwT=10-BVc8uOGf-KQcunL-831-m7PSvqsSXfdC3kymYoFBg at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> st_buffer does work with GEOGRAPHY type
> (http://postgis.net/docs/manual-2.0/ST_Buffer.html).
> To check if objects lie in a certain distance to a point, you should
> use st_dwithin on geography type directly. It prevents you from
> reprojecting data
> (http://postgis.net/docs/manual-2.0/ST_DWithin.html):
>
> SELECT i.id_impediments
> FROM THE impediments i
> WHERE st_dwithin (i.geometry_data::geography, GeogFromText ('POINT
> (-16.675297 -49.260196)', 4326), 100)
>
> Nicolas
>
> On 5 July 2013 19:06, Diego Roberto <diegorrborges at gmail.com> wrote:
>> Hello,
>>
>> I need to generate a calculation of lightning and I'm not getting. I have
>> the following situation. I have a point with the coordinates -16.675297,
>> -49.260196 and was stored in the database in spatial format with SRID 4326.
>> Need to generate a buffer of 100 meters from this point and check which
>> other points are within this buffer to return to the user.
>> Realize the following conversion to make this calculation:
>> http://spatialreference.org/ref/epsg/2163/
>>
>> SELECT i.id_impediments
>> FROM THE impediments i
>> WHERE st_dwithin (transform (i.geometry_data, 2163),
>> transform (GeomFromText ('POINT (-16.675297 -49.260196)', 4326), 2163),
>> 100)
>>
>> My questions are:
>> This is the best way to calculate a buffer and from the moment I work with
>> the conversion to SRID 2163 SELECT can do this only for the range of
>> coordinates described in this link:
>> I believe that this conversion also realize that is not the correct way.
>> Could help me transferring any material or link so I can study?
>>
>> I know there's no way I generate a buffer with WGS84 (4326) so I convert to
>> 2163. Working with this?
>>
>> Thank you.
>> And I appreciate the attention.
>>
>> --
>> ________________________________________________
>> Diego Roberto
>>
>> ________________________________________________
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 8 Jul 2013 13:13:04 +0200 (CEST)
> From: "Simon ----------------" <fLaNsch at gmx.de>
> To: "PostGIS Users Discussion" <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] Tricks to find polygon/line intersection
> 	faster
> Message-ID:
> 	<trinity-8dcff945-0b4b-42b2-a5f8-fe3721b0517f-1373281984811 at 3capp-gmx-bs21>
> 	
> Content-Type: text/plain; charset="us-ascii"
>
> An HTML attachment was scrubbed...
> URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130708/d1136261/attachment-0001.html>
>
> ------------------------------
>
> Message: 8
> Date: Mon, 8 Jul 2013 16:18:07 +0300
> From: Ahmet Temiz <ahmettemiz88 at gmail.com>
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Subject: [postgis-users] (no subject)
> Message-ID:
> 	<CAJKO1YsgVPtFosTkYsyzQsbi1TMhAif5t1CTcS2uNhuj0H3jbg at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-9"
>
> 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
>
>