Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes

2011-06-09 Thread Paragon Corporation
Paul,
Multi-million dollar companies are sadly very illogical and dysfunctional I
wouldn't even waste my breath on them.   The only way to get money from them
is the promise of embarassment if they don't comply.

Come up with a  fail-proof embarassment strategy and you'll have more money
than you know what to do with :).

-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Thursday, June 09, 2011 4:56 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes

Our problem isn't our ability to milk $50 donations from our impoverished
user community, it's multi-million dollar companies for whom a $10K contract
is almost two small to draft free-riding on on the community. Honestly, this
is not a crowd-sourcing problem.

I'm asking folks who might have access to said larger chunks of money to
contact me, no strings attached, and if there's an appetite I will send add
them to the distribution list for the statement of work and they can decide
if they want to shop the project up to their superiors. Yes, it's a long
ways away, but waiting a year won't make it any closer. It'll always take
12-18 months from inception to deliver of numbered release.

P.

On Thu, Jun 9, 2011 at 4:51 PM, Paragon Corporation  wrote:
> Eli,
>
> Yes we've made a lot of progress.  We are in the code provenance phase 
> and then I think we are pretty much done.
>
> Paul,
> I think part of the problem like I mentioned is we really got to make 
> it easier for people to give money to the PostGIS project.
>
> To me that means:
>
> Being able to support micro-donations
> Getting our incubation act together so our funding can fall under the 
> OSGEO umbrella and people that need a non-profit  tax umbrella of some 
> sort can use that .
> As strk suggested better outlining of these tasks and realistic effort 
> invovled to execute.
>
> For this particular case -- I think the gains are just too far down 
> the horizon to really appreciate -- I know a year or a half doesn't 
> seem like much but it seems like eons to many.
> Of course for this particular case -- this could be funneled thru the 
> PostgreSQL non-profits since its not a PostGIS only benefit.
>
> Just some guesses.
>
> Thanks,
> Regina
> http://www.postgis.us
>
>
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net
> [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of 
> Eli Adam
> Sent: Thursday, June 09, 2011 4:46 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Seeking Funding for Faster PostGIS 
> Indexes
>
> Any progress since the end of last year when I asked about the option 
> to contribute to PostGIS through OSGeo?
>
> Thanks, Eli
>
 On 6/9/2011 at 1:20 PM, in message
> , Paul Ramsey 
>  wrote:
>> This is a once-in-a-blue-moon opportunity to make your PostGIS an 
>> order of magnitude faster... I'm surprised there has been so little 
>> response!
>>
>> On Fri, May 27, 2011 at 1:45 PM, Paul Ramsey  wrote:
>>> One of the eye-opening talks of PgCon last week was the presentation 
>>> from Oleg Bartunov and Teodor Sigaev on their work on spatial 
>>> partitioning indexes in PostgreSQL. Oleg and Teodor are the 
>>> maintainers of the GiST framework we use for our r-tree, and are 
>>> proposing a new framework to allow quad-tree and kd-tree 
>>> implementations in PostgreSQL.
>>>
>>> http://www.pgcon.org/2011/schedule/events/309.en.html
>>>
>>> The upshot is, this new approach is as much as 6-times faster than 
>>> the r-tree (at least for points). If you're interested in seeing 
>>> PostGIS indexes get vastly faster, consider funding this project. 
>>> Get in touch with me directly for details.
>>>
>>> http://blog.opengeo.org/2011/05/27/pgcon-notes-3/
>>>
>>> P.
>>>
>> ___
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes

2011-06-09 Thread Paul Ramsey
Our problem isn't our ability to milk $50 donations from our
impoverished user community, it's multi-million dollar companies for
whom a $10K contract is almost two small to draft free-riding on on
the community. Honestly, this is not a crowd-sourcing problem.

I'm asking folks who might have access to said larger chunks of money
to contact me, no strings attached, and if there's an appetite I will
send add them to the distribution list for the statement of work and
they can decide if they want to shop the project up to their
superiors. Yes, it's a long ways away, but waiting a year won't make
it any closer. It'll always take 12-18 months from inception to
deliver of numbered release.

P.

On Thu, Jun 9, 2011 at 4:51 PM, Paragon Corporation  wrote:
> Eli,
>
> Yes we've made a lot of progress.  We are in the code provenance phase and
> then I think we are pretty much done.
>
> Paul,
> I think part of the problem like I mentioned is we really got to make it
> easier for people to give money to the PostGIS project.
>
> To me that means:
>
> Being able to support micro-donations
> Getting our incubation act together so our funding can fall under the OSGEO
> umbrella and people that need a non-profit  tax umbrella of some sort can
> use that .
> As strk suggested better outlining of these tasks and realistic effort
> invovled to execute.
>
> For this particular case -- I think the gains are just too far down the
> horizon to really appreciate -- I know a year or a half doesn't seem like
> much but it seems like eons to many.
> Of course for this particular case -- this could be funneled thru the
> PostgreSQL non-profits since its not a PostGIS only benefit.
>
> Just some guesses.
>
> Thanks,
> Regina
> http://www.postgis.us
>
>
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net
> [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Eli Adam
> Sent: Thursday, June 09, 2011 4:46 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes
>
> Any progress since the end of last year when I asked about the option to
> contribute to PostGIS through OSGeo?
>
> Thanks, Eli
>
 On 6/9/2011 at 1:20 PM, in message
> , Paul Ramsey
>  wrote:
>> This is a once-in-a-blue-moon opportunity to make your PostGIS an
>> order of magnitude faster... I'm surprised there has been so little
>> response!
>>
>> On Fri, May 27, 2011 at 1:45 PM, Paul Ramsey  wrote:
>>> One of the eye-opening talks of PgCon last week was the presentation
>>> from Oleg Bartunov and Teodor Sigaev on their work on spatial
>>> partitioning indexes in PostgreSQL. Oleg and Teodor are the
>>> maintainers of the GiST framework we use for our r-tree, and are
>>> proposing a new framework to allow quad-tree and kd-tree
>>> implementations in PostgreSQL.
>>>
>>> http://www.pgcon.org/2011/schedule/events/309.en.html
>>>
>>> The upshot is, this new approach is as much as 6-times faster than
>>> the r-tree (at least for points). If you're interested in seeing
>>> PostGIS indexes get vastly faster, consider funding this project. Get
>>> in touch with me directly for details.
>>>
>>> http://blog.opengeo.org/2011/05/27/pgcon-notes-3/
>>>
>>> P.
>>>
>> ___
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes

2011-06-09 Thread Paragon Corporation
Eli,

Yes we've made a lot of progress.  We are in the code provenance phase and
then I think we are pretty much done.  

Paul,
I think part of the problem like I mentioned is we really got to make it
easier for people to give money to the PostGIS project.

To me that means:

Being able to support micro-donations
Getting our incubation act together so our funding can fall under the OSGEO
umbrella and people that need a non-profit  tax umbrella of some sort can
use that .
As strk suggested better outlining of these tasks and realistic effort
invovled to execute.

For this particular case -- I think the gains are just too far down the
horizon to really appreciate -- I know a year or a half doesn't seem like
much but it seems like eons to many.
Of course for this particular case -- this could be funneled thru the
PostgreSQL non-profits since its not a PostGIS only benefit.

Just some guesses.

Thanks,
Regina 
http://www.postgis.us


-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Eli Adam
Sent: Thursday, June 09, 2011 4:46 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes

Any progress since the end of last year when I asked about the option to
contribute to PostGIS through OSGeo?

Thanks, Eli

>>> On 6/9/2011 at 1:20 PM, in message
, Paul Ramsey
 wrote:
> This is a once-in-a-blue-moon opportunity to make your PostGIS an 
> order of magnitude faster... I'm surprised there has been so little 
> response!
> 
> On Fri, May 27, 2011 at 1:45 PM, Paul Ramsey  wrote:
>> One of the eye-opening talks of PgCon last week was the presentation 
>> from Oleg Bartunov and Teodor Sigaev on their work on spatial 
>> partitioning indexes in PostgreSQL. Oleg and Teodor are the 
>> maintainers of the GiST framework we use for our r-tree, and are 
>> proposing a new framework to allow quad-tree and kd-tree 
>> implementations in PostgreSQL.
>>
>> http://www.pgcon.org/2011/schedule/events/309.en.html
>>
>> The upshot is, this new approach is as much as 6-times faster than 
>> the r-tree (at least for points). If you're interested in seeing 
>> PostGIS indexes get vastly faster, consider funding this project. Get 
>> in touch with me directly for details.
>>
>> http://blog.opengeo.org/2011/05/27/pgcon-notes-3/
>>
>> P.
>>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes

2011-06-09 Thread Eli Adam
Any progress since the end of last year when I asked about the option to 
contribute to PostGIS through OSGeo?

Thanks, Eli

>>> On 6/9/2011 at 1:20 PM, in message
, Paul Ramsey
 wrote:
> This is a once-in-a-blue-moon opportunity to make your PostGIS an
> order of magnitude faster... I'm surprised there has been so little
> response!
> 
> On Fri, May 27, 2011 at 1:45 PM, Paul Ramsey  wrote:
>> One of the eye-opening talks of PgCon last week was the presentation
>> from Oleg Bartunov and Teodor Sigaev on their work on spatial
>> partitioning indexes in PostgreSQL. Oleg and Teodor are the
>> maintainers of the GiST framework we use for our r-tree, and are
>> proposing a new framework to allow quad-tree and kd-tree
>> implementations in PostgreSQL.
>>
>> http://www.pgcon.org/2011/schedule/events/309.en.html 
>>
>> The upshot is, this new approach is as much as 6-times faster than the
>> r-tree (at least for points). If you're interested in seeing PostGIS
>> indexes get vastly faster, consider funding this project. Get in touch
>> with me directly for details.
>>
>> http://blog.opengeo.org/2011/05/27/pgcon-notes-3/ 
>>
>> P.
>>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net 
> http://postgis.refractions.net/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Seeking Funding for Faster PostGIS Indexes

2011-06-09 Thread Paul Ramsey
This is a once-in-a-blue-moon opportunity to make your PostGIS an
order of magnitude faster... I'm surprised there has been so little
response!

On Fri, May 27, 2011 at 1:45 PM, Paul Ramsey  wrote:
> One of the eye-opening talks of PgCon last week was the presentation
> from Oleg Bartunov and Teodor Sigaev on their work on spatial
> partitioning indexes in PostgreSQL. Oleg and Teodor are the
> maintainers of the GiST framework we use for our r-tree, and are
> proposing a new framework to allow quad-tree and kd-tree
> implementations in PostgreSQL.
>
> http://www.pgcon.org/2011/schedule/events/309.en.html
>
> The upshot is, this new approach is as much as 6-times faster than the
> r-tree (at least for points). If you're interested in seeing PostGIS
> indexes get vastly faster, consider funding this project. Get in touch
> with me directly for details.
>
> http://blog.opengeo.org/2011/05/27/pgcon-notes-3/
>
> P.
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Etienne Bellemare
Pierre,

I'm using postgis raster to perform intersection between rasters and vector
features which are mainly derived from lidar data (which yields lots of
data). It's a scientific environment rather than a production environment.

Etienne

On Thu, Jun 9, 2011 at 12:48 PM, Javier de la Torre
wrote:

> Now we are using an open source software called starspan. It actually works
> pretty well.
>
> What we do is have a server with the raster and a web server exposing an
> API. It accepts a polygon as geojson and in command line calculate the vsum
> of the carbon value using starspan.
>
> In PostGIS we could do many more things like intersections and stuff like
> this before calculating the sum of the raster value. We could stored
> polygons and with simple sql statements calculate their values... well lot
> more flexibility in general.
>
> Best,
>
>
> On Jun 9, 2011, at 9:29 AM, Pierre Racine wrote:
>
> > Thanks Javier,
> >
> > Nice application. What do you use now and why do you plan on using
> PostGIS? Is it possible to upload a shapefile and get the carbon
> sequestrated for the area covered by the shapefile?
> >
> > Pierre
> >
> >> -Original Message-
> >> From: Javier de la Torre [mailto:jato...@vizzuality.com]
> >> Sent: Thursday, June 09, 2011 3:42 AM
> >> To: PostGIS Users Discussion
> >> Cc: marie-...@lists.refractions.net; Pierre Racine; ude Labbé
> >> Subject: Re: [postgis-users] How do you use PostGIS Raster?
> >>
> >> Hi,
> >>
> >> We are planning on using it to calculate carbon sequestration on
> protected
> >> areas. This is a project by the Convention on Biological Diversity
> >>
> >> http://www.cbd.int/lifeweb/carbon/
> >>
> >> It basically is an intersection of a raster with bit vectors.
> >>
> >> Best,
> >>
> >> Javier.
> >>
> >>
> >> On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote:
> >>
> >>
> >>  Dear Pierre,
> >>
> >>  Here, we are using PostGIS to analyze large datasets combining
> rasters
> >> and vectors. Basically, we are looking at movement and habitat selection
> in a
> >> predator-prey system, using GPS-collar data over large areas. The major
> use of
> >> PostGIS Raster is for the intersection of prey steps (line segments or
> buffers
> >> around these segments) with different raster: Landsat (landcover type),
> slope,
> >> road density, relative probability of occurrence of the predator, etc.
> Note that
> >> we first tried to use ArcGIS for this step, without success, due to many
> bugs and
> >> the need to correct them by hand (which was largely too time-consuming).
> We
> >> also used PostGIS Raster to intersect predator locations with the
> Landsat map to
> >> estimate Resource Selection Functions (RSF) in order to build maps of
> relative
> >> probability of occurrence. In the end, information of the intersections
> were used
> >> in R to characterize movements of the preys on the landscape.
> >>
> >>  Best,
> >>  Mathieu Basille.
> >>
> >>
> >>  Le 03/06/2011 08:28, Pierre Racine a écrit :
> >>
> >>
> >>  Hi all,
> >>
> >>
> >>
> >>  I'm preparing a presentation and I need some use cases for
> >> PostGIS Raster. I would be grateful if people already using the raster
> side of
> >> PostGIS would describe what they already do it. Bborie, Jorge, Regina,
> others?
> >> These uses cases are vital for the project.
> >>
> >>
> >>
> >>  On my side we are using PostGIS raster to do raster/vector
> >> analysis over large datasets. Basically determining mean values for
> temperature
> >> (raster), elevation (raster) for fauna observations (point buffers).
> Converting
> >> everything to vector and using desktop solutions proved impracticable
> for
> >> datasets covering the extent of Canada.
> >>
> >>
> >>
> >>  For those who did not try the raster extension yet, don't
> be shy
> >> to express your planned experiments or your expectations.
> >>
> >>
> >>
> >>  Thanks all for your contribution to the project,
> >>
> >>
> >>
> >>  Pierre
> >>
> >>
> >>  ___
> >>
> >>
> >>  postgis-users mailing list
> >>
> >>
> >>  postgis-users@postgis.refractions.net
> >>
> >>
> >>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >>
> >>  --
> >>
> >>  ~$ whoami
> >>  Mathieu Basille, Post-Doc
> >>
> >>  ~$ locate
> >>  Laboratoire d'Écologie Comportementale et de Conservation de la
> >> Faune
> >>  + Centre d'Étude de la Forêt
> >>  Département de Biologie
> >>  Université Laval, Québec
> >>
> >>  ~$ info
> >>  http://ase-research.org/basille
> >>
> >>  ~$ fortune
> >>  ``If you can't win by reason, go for volume.''
> >>  Calvin, by Bill Watterson.
> >>  ___
> >>  postgis-users mailing list
> >>  postgis-users@postgis.refractions.net
> >>  http://postgis.refractions.net/mailman/listin

[postgis-users] statistics on a spatial index

2011-06-09 Thread Oleksiy Karpenko
Hi,

How can I obtain various statistics on an existing index in the
database? For example, number of levels, average MBR size by each
dimension, and so on?

Regards,
Oleksiy Karpenko
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[postgis-users] TopologyException in GEOS ST_Union function

2011-06-09 Thread fsalas


TopologyException in GEOS ST_Union function

I'm writting a function using the plpgsql language in PostgreSQL.
This function operate with geometries and I do something like this:

-- Open a cursor for a table

OPEN veget_cursor FOR
SELECT gid, wkb_geometry as the_geom
FROM table_v;
LOOP
FETCH veget_cursor INTO _gid, veget_geom;

-- Validate the geometry of the table table_v

IF ST_isvalid(veget_geom) THEN

		-- Open a cursor for a selection. The selection only contains the  
geometries that intersects

-- with the current geometry of the cursor veget_cursor.

OPEN floor_cursor FOR
SELECT gid, wkb_geometry as the_geom
FROM table_f
WHERE ST_Intersects(wkb_geometry, veget_geom);
LOOP
FETCH floor_cursor INTO f3, floor_geom;

-- Validate the geometry of the other table 
(table_f)

IF ST_isvalid(floor_geom) THEN

-- Intersects the geometries of the two 
cursors

geom := ST_Intersection(floor_geom, 
veget_geom);

-- Validate the resultant geometry of 
the intersection operation

IF (ST_Isvalid(geom)) THEN

-- Here join the geometry of geom into 
union_geom

IF union_geom IS NULL 
THEN
union_geom := 
geom;
ELSE
union_geom := 
st_union(union_geom, geom);
END IF;
END IF;

END IF;
END LOOP;
CLOSE floor_cursor;
END LOOP;
CLOSE veget_cursor;

This code throw a topology exception:
TopologyException: found non-noded intersection between -83.5325  
22.7268, -83.5327 22.7271 and -83.5327 22.7269, -83.5325 22.7268  
-83.5325 22.7268

ERROR:  GEOS union() threw an error!

The questions are:
- Why does it throw an exception if I'm validating all geometries?
- What does the exception mean?
- What can I do?

Best regards, Salas

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Javier de la Torre
Now we are using an open source software called starspan. It actually works 
pretty well.

What we do is have a server with the raster and a web server exposing an API. 
It accepts a polygon as geojson and in command line calculate the vsum of the 
carbon value using starspan.

In PostGIS we could do many more things like intersections and stuff like this 
before calculating the sum of the raster value. We could stored polygons and 
with simple sql statements calculate their values... well lot more flexibility 
in general.

Best,


On Jun 9, 2011, at 9:29 AM, Pierre Racine wrote:

> Thanks Javier,
> 
> Nice application. What do you use now and why do you plan on using PostGIS? 
> Is it possible to upload a shapefile and get the carbon sequestrated for the 
> area covered by the shapefile?
> 
> Pierre
> 
>> -Original Message-
>> From: Javier de la Torre [mailto:jato...@vizzuality.com]
>> Sent: Thursday, June 09, 2011 3:42 AM
>> To: PostGIS Users Discussion
>> Cc: marie-...@lists.refractions.net; Pierre Racine; ude Labbé
>> Subject: Re: [postgis-users] How do you use PostGIS Raster?
>> 
>> Hi,
>> 
>> We are planning on using it to calculate carbon sequestration on protected
>> areas. This is a project by the Convention on Biological Diversity
>> 
>> http://www.cbd.int/lifeweb/carbon/
>> 
>> It basically is an intersection of a raster with bit vectors.
>> 
>> Best,
>> 
>> Javier.
>> 
>> 
>> On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote:
>> 
>> 
>>  Dear Pierre,
>> 
>>  Here, we are using PostGIS to analyze large datasets combining rasters
>> and vectors. Basically, we are looking at movement and habitat selection in a
>> predator-prey system, using GPS-collar data over large areas. The major use 
>> of
>> PostGIS Raster is for the intersection of prey steps (line segments or 
>> buffers
>> around these segments) with different raster: Landsat (landcover type), 
>> slope,
>> road density, relative probability of occurrence of the predator, etc. Note 
>> that
>> we first tried to use ArcGIS for this step, without success, due to many 
>> bugs and
>> the need to correct them by hand (which was largely too time-consuming). We
>> also used PostGIS Raster to intersect predator locations with the Landsat 
>> map to
>> estimate Resource Selection Functions (RSF) in order to build maps of 
>> relative
>> probability of occurrence. In the end, information of the intersections were 
>> used
>> in R to characterize movements of the preys on the landscape.
>> 
>>  Best,
>>  Mathieu Basille.
>> 
>> 
>>  Le 03/06/2011 08:28, Pierre Racine a écrit :
>> 
>> 
>>  Hi all,
>> 
>> 
>> 
>>  I'm preparing a presentation and I need some use cases for
>> PostGIS Raster. I would be grateful if people already using the raster side 
>> of
>> PostGIS would describe what they already do it. Bborie, Jorge, Regina, 
>> others?
>> These uses cases are vital for the project.
>> 
>> 
>> 
>>  On my side we are using PostGIS raster to do raster/vector
>> analysis over large datasets. Basically determining mean values for 
>> temperature
>> (raster), elevation (raster) for fauna observations (point buffers). 
>> Converting
>> everything to vector and using desktop solutions proved impracticable for
>> datasets covering the extent of Canada.
>> 
>> 
>> 
>>  For those who did not try the raster extension yet, don't be shy
>> to express your planned experiments or your expectations.
>> 
>> 
>> 
>>  Thanks all for your contribution to the project,
>> 
>> 
>> 
>>  Pierre
>> 
>> 
>>  ___
>> 
>> 
>>  postgis-users mailing list
>> 
>> 
>>  postgis-users@postgis.refractions.net
>> 
>> 
>>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 
>> 
>> 
>>  --
>> 
>>  ~$ whoami
>>  Mathieu Basille, Post-Doc
>> 
>>  ~$ locate
>>  Laboratoire d'Écologie Comportementale et de Conservation de la
>> Faune
>>  + Centre d'Étude de la Forêt
>>  Département de Biologie
>>  Université Laval, Québec
>> 
>>  ~$ info
>>  http://ase-research.org/basille
>> 
>>  ~$ fortune
>>  ``If you can't win by reason, go for volume.''
>>  Calvin, by Bill Watterson.
>>  ___
>>  postgis-users mailing list
>>  postgis-users@postgis.refractions.net
>>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 
>> 
> 

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] PostGIS websites in PHP without a map server?

2011-06-09 Thread John Patterson
Looks very useful, thanks!

On Wed, Jun 8, 2011 at 4:46 PM, Thomas Gratier
 wrote:
> Hello,
>
> Maybe http://code.google.com/p/postgis-restful-web-service-framework/
> project can help you a bit. Only based on PHP and PostGIS
>
> Regards
>
> ThomasG
> GIS specialist
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] (no subject)

2011-06-09 Thread Pierre Racine
Hi Muhammad,

Please put a subject when you write to the group...

> I am trying to import *.tif files into PG. These tif images are basically the 
> MODIS
> data (three images covering the whole study area, pixel size 500m). But, when 
> I
> try to load them I got the following error
> Error:
> Cannot load raster with different pixel size in the same raster table

Right maybe this too strict. We should just warn in this case. I will reopen 
the ticket:

http://trac.osgeo.org/postgis/ticket/153

> (However, individually the images can be loaded into three different raster
> tables)

Probably you can load them in the same table if you run a new raster2pgsql 
command for each. 

> Secondly, does the tiling (with -k 100X100) physically merges these pixels 
> into on
> big pixel of the size of 100X100 pixels or it is just logical merging and the 
> pixel
> size remain 500m.

It is not a merging. It is tiling the big raster many raster tiles. The pixel 
size remain unchanged and will be the same for each tile.

http://edndoc.esri.com/arcsde/9.2/concepts/rasters/entities/rastertiles.htm

Pierre
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

2011-06-09 Thread Mark Cave-Ayland

On 09/06/11 12:53, Sandro Santilli wrote:


Every new release in the 3.x.x series is backward compatible at the C-API
level. PostGIS uses the C-API.


True. Plus new GEOS releases are invariably better (read as: more 
robust) than their predecessors, so if you can go for this option I 
would definitely recommend it.



ATB,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[postgis-users] Pixel size verses tile size

2011-06-09 Thread muhammad imran
hi People,

I am trying to import *.tif files into PG. These tif images
are basically the MODIS data (three images covering the
whole study area, pixel size 500m). But, when I try to load
them I got the following error 
Error: > Cannot load raster with different pixel size in the same
raster table
(However, individually the images can be loaded into three
different raster tables)
 
Secondly, does the tiling (with -k 100X100) physically
merges these pixels into on big pixel of the size of 100X100
pixels or it is just logical merging and the pixel size
remain 500m.

Regards,
Imran
 
 
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[postgis-users] (no subject)

2011-06-09 Thread muhammad imran
hi People,

I am trying to import *.tif files into PG. These tif images are basically the 
MODIS data (three images covering the whole study area, pixel size 500m). But, 
when I try to load them I got the following error 
Error: 
Cannot load raster with different pixel size in the same raster table

(However, individually the images can be loaded into three different raster 
tables)

Secondly, does the tiling (with -k 100X100) physically merges these pixels into 
on big pixel of the size of 100X100 pixels or it is just logical merging and 
the pixel size remain 500m.

Regards,
Imran

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Pierre Racine
Thanks Mathieu,

Could you provide us with some numbers? How many geometries do you intersect? 
What is the total area/length covered by those geometries? With what raster 
size? How long it takes? Which kind of machine are you using? I would really 
like to use your numbers in my presentation.

Pierre

> -Original Message-
> From: Mathieu Basille [mailto:basi...@ase-research.org]
> Sent: Wednesday, June 08, 2011 10:09 PM
> To: PostGIS Users Discussion
> Cc: Pierre Racine; Marie-Claude Labbé
> Subject: Re: [postgis-users] How do you use PostGIS Raster?
> 
> Dear Pierre,
> 
> Here, we are using PostGIS to analyze large datasets combining rasters and
> vectors. Basically, we are looking at movement and habitat selection in a
> predator-prey system, using GPS-collar data over large areas. The major use of
> PostGIS Raster is for the intersection of prey steps (line segments or buffers
> around these segments) with different raster:
> Landsat (landcover type), slope, road density, relative probability of 
> occurrence
> of the predator, etc. Note that we first tried to use ArcGIS for this step, 
> without
> success, due to many bugs and the need to correct them by hand (which was
> largely too time-consuming). We also used PostGIS Raster to intersect predator
> locations with the Landsat map to estimate Resource Selection Functions (RSF)
> in order to build maps of relative probability of occurrence. In the end,
> information of the intersections were used in R to characterize movements of
> the preys on the landscape.
> 
> Best,
> Mathieu Basille.
> 
> 
> Le 03/06/2011 08:28, Pierre Racine a écrit :
> > Hi all,
> >
> > I'm preparing a presentation and I need some use cases for PostGIS Raster. I
> would be grateful if people already using the raster side of PostGIS would
> describe what they already do it. Bborie, Jorge, Regina, others? These uses
> cases are vital for the project.
> >
> > On my side we are using PostGIS raster to do raster/vector analysis over 
> > large
> datasets. Basically determining mean values for temperature (raster), 
> elevation
> (raster) for fauna observations (point buffers). Converting everything to 
> vector
> and using desktop solutions proved impracticable for datasets covering the
> extent of Canada.
> >
> > For those who did not try the raster extension yet, don't be shy to express 
> > your
> planned experiments or your expectations.
> >
> > Thanks all for your contribution to the project,
> >
> > Pierre
> > ___
> > postgis-users mailing list
> > postgis-users@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> --
> 
> ~$ whoami
> Mathieu Basille, Post-Doc
> 
> ~$ locate
> Laboratoire d'Écologie Comportementale et de Conservation de la Faune
> + Centre d'Étude de la Forêt
> Département de Biologie
> Université Laval, Québec
> 
> ~$ info
> http://ase-research.org/basille
> 
> ~$ fortune
> ``If you can't win by reason, go for volume.''
> Calvin, by Bill Watterson.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Pierre Racine
Thanks Javier,

Nice application. What do you use now and why do you plan on using PostGIS? Is 
it possible to upload a shapefile and get the carbon sequestrated for the area 
covered by the shapefile?

Pierre

> -Original Message-
> From: Javier de la Torre [mailto:jato...@vizzuality.com]
> Sent: Thursday, June 09, 2011 3:42 AM
> To: PostGIS Users Discussion
> Cc: marie-...@lists.refractions.net; Pierre Racine; ude Labbé
> Subject: Re: [postgis-users] How do you use PostGIS Raster?
> 
> Hi,
> 
> We are planning on using it to calculate carbon sequestration on protected
> areas. This is a project by the Convention on Biological Diversity
> 
> http://www.cbd.int/lifeweb/carbon/
> 
> It basically is an intersection of a raster with bit vectors.
> 
> Best,
> 
> Javier.
> 
> 
> On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote:
> 
> 
>   Dear Pierre,
> 
>   Here, we are using PostGIS to analyze large datasets combining rasters
> and vectors. Basically, we are looking at movement and habitat selection in a
> predator-prey system, using GPS-collar data over large areas. The major use of
> PostGIS Raster is for the intersection of prey steps (line segments or buffers
> around these segments) with different raster: Landsat (landcover type), slope,
> road density, relative probability of occurrence of the predator, etc. Note 
> that
> we first tried to use ArcGIS for this step, without success, due to many bugs 
> and
> the need to correct them by hand (which was largely too time-consuming). We
> also used PostGIS Raster to intersect predator locations with the Landsat map 
> to
> estimate Resource Selection Functions (RSF) in order to build maps of relative
> probability of occurrence. In the end, information of the intersections were 
> used
> in R to characterize movements of the preys on the landscape.
> 
>   Best,
>   Mathieu Basille.
> 
> 
>   Le 03/06/2011 08:28, Pierre Racine a écrit :
> 
> 
>   Hi all,
> 
> 
> 
>   I'm preparing a presentation and I need some use cases for
> PostGIS Raster. I would be grateful if people already using the raster side of
> PostGIS would describe what they already do it. Bborie, Jorge, Regina, others?
> These uses cases are vital for the project.
> 
> 
> 
>   On my side we are using PostGIS raster to do raster/vector
> analysis over large datasets. Basically determining mean values for 
> temperature
> (raster), elevation (raster) for fauna observations (point buffers). 
> Converting
> everything to vector and using desktop solutions proved impracticable for
> datasets covering the extent of Canada.
> 
> 
> 
>   For those who did not try the raster extension yet, don't be shy
> to express your planned experiments or your expectations.
> 
> 
> 
>   Thanks all for your contribution to the project,
> 
> 
> 
>   Pierre
> 
> 
>   ___
> 
> 
>   postgis-users mailing list
> 
> 
>   postgis-users@postgis.refractions.net
> 
> 
>   http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
>   --
> 
>   ~$ whoami
>   Mathieu Basille, Post-Doc
> 
>   ~$ locate
>   Laboratoire d'Écologie Comportementale et de Conservation de la
> Faune
>   + Centre d'Étude de la Forêt
>   Département de Biologie
>   Université Laval, Québec
> 
>   ~$ info
>   http://ase-research.org/basille
> 
>   ~$ fortune
>   ``If you can't win by reason, go for volume.''
>   Calvin, by Bill Watterson.
>   ___
>   postgis-users mailing list
>   postgis-users@postgis.refractions.net
>   http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Pierre Racine
Thanks Santosh,

Could you tell us more on what you do on the server side? "PGRaster" you mean 
PostGIS Raster? Or the old pgraster?

Pierre

> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
> boun...@postgis.refractions.net] On Behalf Of Santosh Gaikwad
> Sent: Thursday, June 09, 2011 4:54 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] How do you use PostGIS Raster?
> 
> HI,
> 
> Look at the following application of Ecological Sensitive Area (ESA) of 
> western
> ghats (one of the biodiversity hotspot) of India. We have used PGRaster in 
> this
> case.
> 
> http://www.wetlandsofindia.org/geoserver/www/esa/esa.html (It works well in
> Firefox)
> 
> Thanks,
> 
> Santosh Gaikwad
> 
> 
> On Thu, Jun 9, 2011 at 1:12 PM, Javier de la Torre 
> wrote:
> 
> 
>   Hi,
> 
>   We are planning on using it to calculate carbon sequestration on
> protected areas. This is a project by the Convention on Biological Diversity
> 
>   http://www.cbd.int/lifeweb/carbon/
> 
>   It basically is an intersection of a raster with bit vectors.
> 
>   Best,
> 
> 
>   Javier.
> 
> 
>   On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote:
> 
> 
>   Dear Pierre,
> 
>   Here, we are using PostGIS to analyze large datasets combining
> rasters and vectors. Basically, we are looking at movement and habitat 
> selection
> in a predator-prey system, using GPS-collar data over large areas. The major 
> use
> of PostGIS Raster is for the intersection of prey steps (line segments or 
> buffers
> around these segments) with different raster: Landsat (landcover type), slope,
> road density, relative probability of occurrence of the predator, etc. Note 
> that
> we first tried to use ArcGIS for this step, without success, due to many bugs 
> and
> the need to correct them by hand (which was largely too time-consuming). We
> also used PostGIS Raster to intersect predator locations with the Landsat map 
> to
> estimate Resource Selection Functions (RSF) in order to build maps of relative
> probability of occurrence. In the end, information of the intersections were 
> used
> in R to characterize movements of the preys on the landscape.
> 
>   Best,
>   Mathieu Basille.
> 
> 
>   Le 03/06/2011 08:28, Pierre Racine a écrit :
> 
> 
>   Hi all,
> 
> 
> 
>   I'm preparing a presentation and I need some use cases
> for PostGIS Raster. I would be grateful if people already using the raster 
> side of
> PostGIS would describe what they already do it. Bborie, Jorge, Regina, others?
> These uses cases are vital for the project.
> 
> 
> 
>   On my side we are using PostGIS raster to do
> raster/vector analysis over large datasets. Basically determining mean values 
> for
> temperature (raster), elevation (raster) for fauna observations (point 
> buffers).
> Converting everything to vector and using desktop solutions proved
> impracticable for datasets covering the extent of Canada.
> 
> 
> 
>   For those who did not try the raster extension yet, 
> don't
> be shy to express your planned experiments or your expectations.
> 
> 
> 
>   Thanks all for your contribution to the project,
> 
> 
> 
>   Pierre
> 
> 
> 
>   ___
> 
> 
>   postgis-users mailing list
> 
> 
>   postgis-users@postgis.refractions.net
> 
> 
>   http://postgis.refractions.net/mailman/listinfo/postgis-
> users
> 
> 
> 
>   --
> 
>   ~$ whoami
>   Mathieu Basille, Post-Doc
> 
>   ~$ locate
>   Laboratoire d'Écologie Comportementale et de Conservation de
> la Faune
>   + Centre d'Étude de la Forêt
>   Département de Biologie
>   Université Laval, Québec
> 
>   ~$ info
>   http://ase-research.org/basille
> 
>   ~$ fortune
>   ``If you can't win by reason, go for volume.''
>   Calvin, by Bill Watterson.
>   ___
>   postgis-users mailing list
>   postgis-users@postgis.refractions.net
>   http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> 
>   ___
>   postgis-users mailing list
>   postgis-users@postgis.refractions.net
>   http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> 
> 
> 
> --
> Santosh S. Gaikwad,
> 
> Geo-Informatics Officer,
> Salim Ali Centre For Ornithology
> & Natural History (SACON),
> 12-13-588/B, Nagarjunanagar Colony,
> Tarnaka,Hyderabad- 500017,
> Andhra Pradesh,India.
> http://www.wetlandsofindia.org http://sacon.org Mobile :  91-8106736257
> Homepage: http:

Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

2011-06-09 Thread Sandro Santilli
On Thu, Jun 09, 2011 at 12:55:56PM +0200, Magnus Hagander wrote:
> On Thu, Jun 9, 2011 at 12:35, Sandro Santilli  wrote:

> > The fix is in upgrading GEOS (3.3.0 is out).
> > If you can upgrade PostGIS you can also upgrade GEOS, right ?
> 
> Uh, that sounds like a major version rather than a patch version? Or
> do I not know how GEOS versions works?

It's a minor version. But yes, not a patch level.

> Applying a patch version is pretty trivial and makes no difference if
> it's GEOS or PostGIS. But if it's a new major version, that would
> require a whole new RPM-set to be released etc, and IIRC the version
> of geos is more or less "locked" to the version of postgis at release
> time? Not entirely sure though - Devrim, can you comment on that? GEOS
> 3.3.0 for older versions of postgis in the rpm repo, since it has an
> important bugfix?

Every new release in the 3.x.x series is backward compatible at the C-API
level. PostGIS uses the C-API.

Anyway, I'll consider backporting the fix to the 3.2 branch if packagers
think it'll help.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

2011-06-09 Thread Magnus Hagander
On Thu, Jun 9, 2011 at 12:35, Sandro Santilli  wrote:
> On Wed, Jun 8, 2011 at 8:58 PM, Magnus Hagander  wrote:
>> On Tue, May 31, 2011 at 14:06, Magnus Hagander  wrote:
>>> On Fri, May 27, 2011 at 21:07, Sandro Santilli  wrote:
 On Fri, May 27, 2011 at 09:28:57AM -0700, Paul Ramsey wrote:
> I'm finding it difficult to have the regression test and also the
> NOTICE in isvalid and also have the differential behaviour for
> different versions of GEOS. One is going to have to go.  I can't
> ensure the "reason" I provide in my short circuit to match the reason
> GEOS is going to give.

 What you can do is _not_ using tickets.sql but a dedicated file, maybe
 bugXXX.sql and bugXXX_pre_geos33.sql, and switch between the two from
 the Makefile.
>>>
>>> So to be clear on this for someone who's not following the svn repo -
>>> has a fix for this been applied now?
>>
>> Hrrm... Ping?
>
> The fix is in upgrading GEOS (3.3.0 is out).
> If you can upgrade PostGIS you can also upgrade GEOS, right ?

Uh, that sounds like a major version rather than a patch version? Or
do I not know how GEOS versions works?

Applying a patch version is pretty trivial and makes no difference if
it's GEOS or PostGIS. But if it's a new major version, that would
require a whole new RPM-set to be released etc, and IIRC the version
of geos is more or less "locked" to the version of postgis at release
time? Not entirely sure though - Devrim, can you comment on that? GEOS
3.3.0 for older versions of postgis in the rpm repo, since it has an
important bugfix?


-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] terminated server connection during st_isvalid()

2011-06-09 Thread Sandro Santilli
On Wed, Jun 8, 2011 at 3:24 PM, Birgit Laggner
 wrote:

> I did file a ticket and hopefully did right... Maybe someone more capable
> could check my specifications (I don't want to decide about priority or
> milestone...).

Thank you.
The bug is in GEOS (and also JTS).
I'm on it.
You should have received notifications by the bug tracker (did you?)

--strk;

Free GIS & Flash consultant/developer
http://strk.keybit.net/services.html
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

2011-06-09 Thread Sandro Santilli
On Wed, Jun 8, 2011 at 8:58 PM, Magnus Hagander  wrote:
> On Tue, May 31, 2011 at 14:06, Magnus Hagander  wrote:
>> On Fri, May 27, 2011 at 21:07, Sandro Santilli  wrote:
>>> On Fri, May 27, 2011 at 09:28:57AM -0700, Paul Ramsey wrote:
 I'm finding it difficult to have the regression test and also the
 NOTICE in isvalid and also have the differential behaviour for
 different versions of GEOS. One is going to have to go.  I can't
 ensure the "reason" I provide in my short circuit to match the reason
 GEOS is going to give.
>>>
>>> What you can do is _not_ using tickets.sql but a dedicated file, maybe
>>> bugXXX.sql and bugXXX_pre_geos33.sql, and switch between the two from
>>> the Makefile.
>>
>> So to be clear on this for someone who's not following the svn repo -
>> has a fix for this been applied now?
>
> Hrrm... Ping?

The fix is in upgrading GEOS (3.3.0 is out).
If you can upgrade PostGIS you can also upgrade GEOS, right ?

--strk;

Free GIS & Flash consultant/developer
http://strk.keybit.net/services.html
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Santosh Gaikwad
HI,

Look at the following application of Ecological Sensitive Area (ESA) of
western ghats (one of the biodiversity hotspot) of India. We have used
PGRaster in this case.

http://www.wetlandsofindia.org/geoserver/www/esa/esa.html (It works well in
Firefox)

Thanks,

Santosh Gaikwad

On Thu, Jun 9, 2011 at 1:12 PM, Javier de la Torre
wrote:

> Hi,
>
> We are planning on using it to calculate carbon sequestration on protected
> areas. This is a project by the Convention on Biological Diversity
>
> http://www.cbd.int/lifeweb/carbon/
>
> It basically is an intersection of a raster with bit vectors.
>
> Best,
>
> Javier.
>
>
> On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote:
>
> Dear Pierre,
>
> Here, we are using PostGIS to analyze large datasets combining rasters and
> vectors. Basically, we are looking at movement and habitat selection in a
> predator-prey system, using GPS-collar data over large areas. The major use
> of PostGIS Raster is for the intersection of prey steps (line segments or
> buffers around these segments) with different raster: Landsat (landcover
> type), slope, road density, relative probability of occurrence of the
> predator, etc. Note that we first tried to use ArcGIS for this step, without
> success, due to many bugs and the need to correct them by hand (which was
> largely too time-consuming). We also used PostGIS Raster to intersect
> predator locations with the Landsat map to estimate Resource Selection
> Functions (RSF) in order to build maps of relative probability of
> occurrence. In the end, information of the intersections were used in R to
> characterize movements of the preys on the landscape.
>
> Best,
> Mathieu Basille.
>
>
> Le 03/06/2011 08:28, Pierre Racine a écrit :
>
> Hi all,
>
>
> I'm preparing a presentation and I need some use cases for PostGIS Raster.
> I would be grateful if people already using the raster side of PostGIS would
> describe what they already do it. Bborie, Jorge, Regina, others? These uses
> cases are vital for the project.
>
>
> On my side we are using PostGIS raster to do raster/vector analysis over
> large datasets. Basically determining mean values for temperature (raster),
> elevation (raster) for fauna observations (point buffers). Converting
> everything to vector and using desktop solutions proved impracticable for
> datasets covering the extent of Canada.
>
>
> For those who did not try the raster extension yet, don't be shy to express
> your planned experiments or your expectations.
>
>
> Thanks all for your contribution to the project,
>
>
> Pierre
>
> ___
>
> postgis-users mailing list
>
> postgis-users@postgis.refractions.net
>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> --
>
> ~$ whoami
> Mathieu Basille, Post-Doc
>
> ~$ locate
> Laboratoire d'Écologie Comportementale et de Conservation de la Faune
> + Centre d'Étude de la Forêt
> Département de Biologie
> Université Laval, Québec
>
> ~$ info
> http://ase-research.org/basille
>
> ~$ fortune
> ``If you can't win by reason, go for volume.''
> Calvin, by Bill Watterson.
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
Santosh S. Gaikwad,

Geo-Informatics Officer,
Salim Ali Centre For Ornithology
& Natural History (SACON),
12-13-588/B, Nagarjunanagar Colony,
Tarnaka,Hyderabad- 500017,
Andhra Pradesh,India.
http://www.wetlandsofindia.org http://sacon.org
Mobile :  91-8106736257
Homepage: http://www.wetlandsofindia.org/santosh/index.html
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] about postgis 2.0

2011-06-09 Thread Paragon Corporation
Jose,
 
You mean windows build or just the tar ball.  That page is jsut for windows
build and there are download links futher down on the page for 2.0.  I guess
it does look a bit cluttered now that I'm looking at it.
 
Please note these are all 32-bit builds so require you use 32-bit PostgreSQL
even if you are on a 64-bit Windows (they should work fine for Windows XP,
Windows Vista, Windows 2003-2008 including R2)
 
PostGIS 2.0 for 8.4 windows --
http://www.postgis.org/download/windows/pg84/experimental/postgis/postgis-pg
84-binaries-2.0.0svn.zip
 
PostGIS 2.0 for 9.0 windows -
http://www.postgis.org/download/windows/pg90/experimental/postgis/postgis-pg
90-binaries-2.0.0svn.zip
 
PostGIS 2.0 SVN for 9.1 beta 1
http://www.postgis.org/download/windows/pg91/experimental/postgis/postgis-pg
91-binaries-2.0.0svn.zip
 
Hope that clarifies things;
 
If you are looking for just the source tar ball to compile yourself for any
OS, the link is on this page:
 
http://www.postgis.org/download/
 
Regina
http://www.postgis.us
 
 

  _  

From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Jose
Luis Racero Luque-Romero
Sent: Thursday, June 09, 2011 3:41 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] about postgis 2.0



Hello, I'm trying to download the "postgis-2.0.0SVN" from here
"http://www.postgis.org/download/windows/experimental.php"; - PostGIS
Experimental Binaries. But there is no link available. Could you please tell
me were could I get it.

 

Thank

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Javier de la Torre
Hi,

We are planning on using it to calculate carbon sequestration on protected 
areas. This is a project by the Convention on Biological Diversity

http://www.cbd.int/lifeweb/carbon/

It basically is an intersection of a raster with bit vectors.

Best,

Javier.


On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote:

> Dear Pierre,
> 
> Here, we are using PostGIS to analyze large datasets combining rasters and 
> vectors. Basically, we are looking at movement and habitat selection in a 
> predator-prey system, using GPS-collar data over large areas. The major use 
> of PostGIS Raster is for the intersection of prey steps (line segments or 
> buffers around these segments) with different raster: Landsat (landcover 
> type), slope, road density, relative probability of occurrence of the 
> predator, etc. Note that we first tried to use ArcGIS for this step, without 
> success, due to many bugs and the need to correct them by hand (which was 
> largely too time-consuming). We also used PostGIS Raster to intersect 
> predator locations with the Landsat map to estimate Resource Selection 
> Functions (RSF) in order to build maps of relative probability of occurrence. 
> In the end, information of the intersections were used in R to characterize 
> movements of the preys on the landscape.
> 
> Best,
> Mathieu Basille.
> 
> 
> Le 03/06/2011 08:28, Pierre Racine a écrit :
>> Hi all,
>> 
>> I'm preparing a presentation and I need some use cases for PostGIS Raster. I 
>> would be grateful if people already using the raster side of PostGIS would 
>> describe what they already do it. Bborie, Jorge, Regina, others? These uses 
>> cases are vital for the project.
>> 
>> On my side we are using PostGIS raster to do raster/vector analysis over 
>> large datasets. Basically determining mean values for temperature (raster), 
>> elevation (raster) for fauna observations (point buffers). Converting 
>> everything to vector and using desktop solutions proved impracticable for 
>> datasets covering the extent of Canada.
>> 
>> For those who did not try the raster extension yet, don't be shy to express 
>> your planned experiments or your expectations.
>> 
>> Thanks all for your contribution to the project,
>> 
>> Pierre
>> ___
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> -- 
> 
> ~$ whoami
> Mathieu Basille, Post-Doc
> 
> ~$ locate
> Laboratoire d'Écologie Comportementale et de Conservation de la Faune
> + Centre d'Étude de la Forêt
> Département de Biologie
> Université Laval, Québec
> 
> ~$ info
> http://ase-research.org/basille
> 
> ~$ fortune
> ``If you can't win by reason, go for volume.''
> Calvin, by Bill Watterson.
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[postgis-users] about postgis 2.0

2011-06-09 Thread Jose Luis Racero Luque-Romero
Hello, I'm trying to download the "postgis-2.0.0SVN" from here "
http://www.postgis.org/download/windows/experimental.php"; - PostGIS
Experimental Binaries. But there is no link available. Could you please tell
me were could I get it.



Thank
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users