Message: 2
Date: Sun, 7 Jul 2013 21:48:29 -0400
From: "Paragon Corporation" <l...@pcorp.us>
To: "'PostGIS Users Discussion'" <postgis-users@lists.osgeo.org>
Cc: 'PostGIS Development Discussion' <postgis-de...@lists.osgeo.org>
Subject: [postgis-users] Windows support for 9.1 and lower on PostGIS
2.1+
Message-ID: <805F41D90B5B43208B2BE627079D3D37@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 <m...@dimensionaledge.com>
To: postgis-users@lists.osgeo.org
Subject: [postgis-users] Creating a multiband raster from 3 single
band rasters
Message-ID: <14356bae-ab02-4257-9a63-71e0a23e5...@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 <dustym...@gmail.com>
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] Creating a multiband raster from 3 single
band rasters
Message-ID:
<CAKVfRvHkNUpHKkauhnS5278hZJP-QWtCtROSUrUz_vJ1go8=8...@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 <m...@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@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" <l...@pcorp.us>
To: "'PostGIS Users Discussion'" <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] Creating a multiband raster from 3 single
bandrasters
Message-ID: <7F644E6CD29848DDBE15AD66197D10DE@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-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@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 <m...@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@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.ri...@gmail.com>
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] Calculation of Radius in PostGIS
Message-ID:
<CAGAwT=10-bvc8uogf-kqcunl-831-m7psvqssxfdc3kymyo...@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 <diegorrbor...@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@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 ----------------" <flan...@gmx.de>
To: "PostGIS Users Discussion" <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] Tricks to find polygon/line intersection
faster
Message-ID:
<trinity-8dcff945-0b4b-42b2-a5f8-fe3721b0517f-1373281984811@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 <ahmettemi...@gmail.com>
To: PostGIS Users Discussion <postgis-us...@postgis.refractions.net>
Subject: [postgis-users] (no subject)
Message-ID:
<cajko1ysgvptfostkysyzqsbi1tmhaif5t1ctcs2unhuj0h3...@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
