[postgis-users] Windows support for 9.1 and lower on PostGIS2.1+
Paragon Corporation
lr at pcorp.us
Tue Jul 9 04:18:59 PDT 2013
I've been able to load PostGIS layers on PostgreSQL 9.2 in ArcMap 10.1.
That said I guess it depends what part of it you are using it for.
I guess if you use the st_geometry for some things you are stuck on 9.1.
Are you running 32-bit or 64-bit and do you plan to upgrade to 2.1. The 9.1
64-bits We'll still be providing binaries for 2.1 though we don't plan to be
pushing them to stackbuilder. It's the 32-bit 9.1 that is a real pain since
those we need to manually build.
I'm thinking that ESRI probably doesn't officially support PostGIS 2.1
either though I haven't had issue using it with PostGIS 2.1. Then again my
idea iof issue is
Yeh I can see my PostGIS parcels in ArcMap -- test complete, promptly close
said tool :)
Thanks,
Regina
-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Gregory Kramida
Sent: Monday, July 08, 2013 4:08 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] Windows support for 9.1 and lower on
PostGIS2.1+
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/e
> 586c7c3/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/0
> 049dbc9/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/d
> 1136261/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
>
>
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list