[postgis-users] API Specification

2008-02-28 Thread Uwe Dalluege
Hi, where can I find the API Specifications for the JDBC PostGIS driver postgis_1.3.2.jar? -- Regards Uwe Dalluege -- HafenCity Universitaet Hamburg Department Geomatik Rechenzentrum Dipl.-Ing. Uwe Dalluege :-) Hebebran

Re: [postgis-users] performance of intersects(a,b)

2008-02-28 Thread Willy-Bas Loos
that is, i'm not saying GEOS should work in the way that i describe, i just mean it should know that it has a hit when one of the vertices intersects with the other polygon. Probably i'm seeing things too simple, but i guess never asking is the best way to not get things improved, so i just ask stu

Re: [postgis-users] Enormous file geodatabase feature class > PostgreSQL/PostGIS? + attribute column standardization app or process?

2008-02-28 Thread Nicolas Ribot
> Is there a utility for importing an ESRI file > geodatabase into PostgreSQL/PostGIS? I know there's a > tool for importing shapefiles, but that won't help--or > will it? You may have a look at OGR (http://www.gdal.org/ogr/ogr_formats.html), according to the geodatabase format (personnal, SDE,...

Re: [postgis-users] Enormous file geodatabase feature class > PostgreSQL/PostGIS? + attribute column standardization app or process?

2008-02-28 Thread Frank Warmerdam
dnrg wrote: Frank, thanks for the info. You may find it helpful to use ogrinfo on your .mdb file to determine the name of layers as OGR sees them. So you're saying OGR does not support the file geodatabase (*.gdb) today. Dana, That is correct. Paul, you wrote: Tables, they're called ta

Re: [postgis-users] auto GRANT on new table

2008-02-28 Thread Maciej Sieczka
Mark Cave-Ayland pisze: On Friday 22 February 2008 06:58:59 Maciej Sieczka wrote: Hi Mark! My first post here. Hi All! Sorry if the issue was already discussed. I have searched the net and your archives for several hours not finding an answer. There are 2 role groups in my cluster: "editors

Re: [postgis-users] Enormous file geodatabase feature class > PostgreSQL/PostGIS? + attribute column standardization app or process?

2008-02-28 Thread dnrg
Frank, thanks for the info. > You may find it helpful to use ogrinfo on your .mdb > file to determine the name of layers as OGR sees > them. So you're saying OGR does not support the file geodatabase (*.gdb) today. The personal geodatabase (*.mdb) has a limitation, last I checked, of 2G--that's

RE: [postgis-users] auto GRANT on new table

2008-02-28 Thread Obe, Regina
Maciej, I take it that you have no control over how these people are creating tables. e.g they are not creating it via some custom application of yours where the solution would be obvious. Unfortunately you can't put a trigger on pg_tables because that is not a table but a read-only view. The

Re: [postgis-users] Great circle as a linestring

2008-02-28 Thread Colin Wetherbee
Colin Wetherbee wrote: I'm looking for a function to approximate a partial great circle (eg. the route taken when flying from London to Tokyo) as a LINESTRING or something similar. Does such a beast exist? If not, do you have any pointers on how to go about implementing that kind of a functi

[postgis-users] updategeometrySRID error

2008-02-28 Thread orkun
hello why does this error occur ? bzk2=# select updategeometrySRID('shey7','wkb_geometry',32636); ERROR: column not found in geometry_columns table CONTEXT: SQL statement "SELECT UpdateGeometrySRID('','', $1 , $2 , $3 )" PL/pgSQL function "updategeometrysrid" line 4 at SQL statement -- This

[postgis-users] A Windows install of Postgresql 8.3 with PL/R - R Procedural Language

2008-02-28 Thread James Beaudoin
Hi All, Is there a windows installer for PL/R for Postgres 8.3? I can't seemed to find one and have been struggling trying to compile the PL/R source on my own. Any help would be appreciated. Thanks in advance, Jim Beaudoin ___ postgis-users maili

[postgis-users] pgmemcache and postgis?

2008-02-28 Thread Webb Sprague
Anybody used pgmemcache to serve geo data, and can give a link to somethnig about it? Just curious... Tx! ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] postgres 8.3

2008-02-28 Thread Devrim GÜNDÜZ
Hi, On Mon, 2008-02-18 at 15:28 -0200, Facundo Garat wrote: > Do you recomend me to use 8.3 instead of 8.2? I'd wait for at least 1-2 minor update releases for 8.3 , if you are planning to deploy it to your production environment. Other than that, if you will deploy to your development environmen

Re: [postgis-users] Projection for Calculating Area

2008-02-28 Thread Dylan Beaudette
On Thursday 21 February 2008 09:33:17 am Travis Kirstine wrote: > All, > We have been developing a web mapping application using google maps as > the front end interface with a postgis backend. Using this > application the user can draw a bounding box in google maps and the > coordinates are then

[postgis-users] Re: [mapserver-users] can an ogr tileindex refer to a PG table?

2008-02-28 Thread Neil Best
Milo van der Linden wrote: Hello Neil, One thing you can do to create some sort of tileindex that can be part of the where clause is create a view in postGIS that contains the boundingboxes of a table based upon an attribute: CREATE VIEW MYBBOX AS SELECT table1.uniqueID, extent(table1.the_ge

[postgis-users] OT: SQLServer2008 Geography type

2008-02-28 Thread Robert Coup
Noticed this today... http://stevekass.com/2007/11/21/the-hemisphere-requirement/ Basically, in SQL Server 2008 Geography values (geography is the ellipsoidal "first-class citizen" type) are limited to a single hemisphere (<180 width and <90 height). Odd. Because I would think it'd be relatively

Re: [postgis-users] performance of intersects(a,b)

2008-02-28 Thread Willy-Bas Loos
Hi Kis, I don't think the GiST index has anything to do with this, i'm only processing one record. thx, WBL On Thu, Feb 21, 2008 at 7:47 AM, Kis János Tamás <[EMAIL PROTECTED]> wrote: > csütörtök 14 február 2008 15.11 dátummal Willy-Bas Loos ezt írta: > > > > select 'yes' as foo > > from table1 a

RE: [postgis-users] GiST Index

2008-02-28 Thread Gregory Williamson
Matthew -- Try running ANALYZE streets_relation; This provides the statistics to the planner ... Use the ST_ functions (or && in older nomenclature) to invoke the spatial index. Typically using an intersection or some such to get things in an area. A GIST index is not a B-tree index and r

Re: [postgis-users] Re: [postgis-devel] Proposal for supporting Extrude, Tessel

2008-02-28 Thread Dane Springmeyer
Guido, Thanks for you thoughts. However, this proposal is not about styling. It is specifically about geometry and its rendering in KML. The elements proposed for addition specify how to interpret XML components WITHIN the geometry elements. If you have, for example, a polygon geometry wi

[postgis-users] problem on srid

2008-02-28 Thread orkun
hello how can I correct this situation: bzk2=# select srid(geom) from shey91 limit 1; srid --- 32767 (1 row) bzk2=# update shey91 set geom=ST_TRANSFORM(setsrid(geom,32767),32636); ERROR: AddToPROJ4SRSCache: Cannot find SRID (32767) in spatial_ref_sys regards -- This message has bee

[postgis-users] need PostGIS binaries for Fedora 8.x

2008-02-28 Thread Paul McCullough
All, I want to run PostgresQL/PostGIS on Fedora 8.3 (or 8.x). I see the PostgresQL binaries here http://www.postgresql.org/ftp/binary/v8.3.0/linux/rpms/fedora/ Do those binaries contain PostGIS? (unable to inspect right now) If not, can I download PostGIS binaries for Fedora? I do not see the