[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

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, Mathi

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 ev

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,

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 a

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 re

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:

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

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 San

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]

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. Pi

[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

[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

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 defin

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: > Ca

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 > >

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

[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

[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 ht

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

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 Teodo

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

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

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 acces

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 k