Re: [postgis-users] 3D spatial index and && 2d operator

2011-12-29 Thread Paul Ramsey
Jose, The &&& operator deals with mismatch dimensionality by projecting the lower dimension into the zero plane. I'm thinking it would be more effective if we instead stripped the higher dimensions and did comparisons in the lower space in the case of mis-matched dimensionality. I will look and see

[postgis-users] 3D spatial index and && 2d operator

2011-12-29 Thread Jose Carlos Martinez Llario
Dear list, Im using PostGIS 2.0 trunk r 8612 In order to use 3d spatial index Im using the &&& operator and its working well (thanks Paul) with the following 3d spatial index: create index p3d_geom_gist on p3d using gist(geom gist_geometry_ops_nd); but then I noticed that the 2d && operator

Re: [postgis-users] Problem with Raster (2nd attempt)

2011-12-29 Thread Paragon Corporation
> What version of GDAL are you using? You'll want to be using > what will be 1.9 (currently beta 2). > But there is an additional question about whether or not GDAL's PostGIS > Raster driver has been updated to the PostGIS Raster's > current (and probably final) format for the raster_column

Re: [postgis-users] postgis removed from latest postgres' stack builder?

2011-12-29 Thread Aren Cambre
Oops, yes, I was talking about the Windows version. Aren On Thu, Dec 29, 2011 at 1:30 AM, Andreas Neumann wrote: > Postgis is not limited to 32bit - however, on Windows, the existing 1.5x > installers only work properly in the 32bit version of PostgreSQL. I guess > there are no technical reasons

Re: [postgis-users] Problem with Raster (2nd attempt)

2011-12-29 Thread Bborie Park
> This writes the table (blockedtif) into the public schema of Testing and > there is a rast column (although it appears empty, but the table size says > otherwise – so I am assuming is normal?). > Unlikely that is empty. Binary data typically looks odd through pgadmin. > > > When I issue the co

[postgis-users] Problem with Raster (2nd attempt)

2011-12-29 Thread Darrel Maddy
Dear all, Apologies if this has been covered elsewhere but I am new to PostGIS and need to resolve this, hopefully simple issue. I am trying to get raster images into PostGIS (this is version 2 sitting on top of Postgres 9.1 under windows). I run the command: C:\tmp>raster2pgsql -I -C -r *.t

Re: [postgis-users] How to configure Postgis/Postgresql to use with QGIS

2011-12-29 Thread pcreso
Hi Daniel, There are two common ways to do this, using ogr2ogr or shp2pgsql. I suggest you try shp2pgsql as it has a simpler command line. It is a utility bundled with Postgis. If you run it with no arguments it provides help with the syntax. The default ouput goes to stdout, and comprises a s

Re: [postgis-users] postgis removed from latest postgres' stack builder?

2011-12-29 Thread Sandro Santilli
On Wed, Dec 28, 2011 at 10:46:10PM -0800, pcr...@pcreso.com wrote: > I believe Ubuntu, Debian, OpenSuse, Fedora, etc all have Postgis in 32 & > 64bit prepackaged & ready to install. > https://wiki.ubuntu.com/UbuntuGIS > http://wiki.debian.org/DebianGis/PackageList > http://fedoraproject.org/wiki/

Re: [postgis-users] How to configure Postgis/Postgresql to use with QGIS

2011-12-29 Thread Puneet Kishor
On Dec 29, 2011, at 9:54 AM, Daniel Montenegro wrote: > Thanks Sindile and Brent, > > Actually, I've unnistalled Postgres (the latest version - 9.xx) and > downloaded an older one (8.1.4 - I guess). Then I used STACK BUILDER to > install PostGIS on Postgres. > > Now let me ask you something els

Re: [postgis-users] How to configure Postgis/Postgresql to use with QGIS

2011-12-29 Thread Daniel Montenegro
Thanks Sindile and Brent, Actually, I've unnistalled Postgres (the latest version - 9.xx) and downloaded an older one (8.1.4 - I guess). Then I used STACK BUILDER to install PostGIS on Postgres. Now let me ask you something else: Supose that I have a polygon shape - like "MyCyty.shp", how can I

Re: [postgis-users] postgis removed from latest postgres' stack builder?

2011-12-29 Thread Bborie Park
For Windows, only 32-bit PostGIS builds have been built successfully (mingw). There are a variety of issues preventing a successful build of 64-bit (dependencies and other strange errors). Personally, I've yet to be able to successfully compile 32-bit PostGIS 2.0 (currently trunk) and haven't had