Re: [postgis-users] Presentation

2007-10-21 Thread Paul Scott
On Sat, 2007-10-20 at 16:59 -0700, Webb Sprague wrote: > I just gave this presentation on PostGIS at the Portland Postgres > conference. I won't vouch for, well, anything... But it might be > useful to someone. Gives a useful overview! If you would like to share this presentation (and others

Re: [postgis-users] Repost: Intersection not working properly

2007-10-21 Thread Webb Sprague
Can you post astext() version of your geometries and srids so the list members can try to reproduce? (Disregard if you already did in your last email). -W On 10/21/07, Craig Feuerherdt <[EMAIL PROTECTED]> wrote: > This is a re-post of a message from last week. I still have not resolved the > iss

[postgis-users] Repost: Intersection not working properly

2007-10-21 Thread Craig Feuerherdt
This is a re-post of a message from last week. I still have not resolved the issue. I am trying to clip one table using the features in another. My query is as follows; drop table bio.bnd_evc; create table bio.bnd_evc as select a.buf_dist, b.bio_no, b.bio_code, b.evc, b.constcde, b.consstat, b.de

Re: [postgis-users] Re: PROJ Projection Issues

2007-10-21 Thread mchapman
Brian, You can get those files from gdal.org as well. Martin Sent via BlackBerry by AT&T -Original Message- From: Brian Timoney <[EMAIL PROTECTED]> Date: Sun, 21 Oct 2007 17:57:01 To:postgis-users@postgis.refractions.net Subject: [postgis-users] Re: PROJ Projection Issues Paul:

[postgis-users] Re: PROJ Projection Issues

2007-10-21 Thread Brian Timoney
Paul: In the Windows install, there is the "libproj.dll" in the BIN directory but no other files with which have names that imply 'grid' or 'nad'. Unfortunately, we don't have an older Windows install in the office to compare to... Thanks, Brian Are there grid files in the proj directo

Re: [postgis-users] Bounding Box to Speed up Queries on Index

2007-10-21 Thread Brent Wood
--- [EMAIL PROTECTED] wrote: - I have 1.5 million data points and I need to find all the data points within 300 meters of a specific location. I have a GiST index set on my "location" (geom) column and it is Vacummed and Analyzed. I'm trying to make my query bu

RE: [postgis-users] ESRI Shapes from database

2007-10-21 Thread Obe, Regina
Brent, I know that SharpMap.NET piggy backs on GDAL for its support of OGR datasources such as MapInfo etc so I think the compiled bindings ready to use for .NET 2.0 is available as part of that project. Not quite sure how that would help Lee though. http://www.codeplex.com/SharpMap/Wiki/Vi

Re: [postgis-users] St_Simplify usage with adjacent polygons

2007-10-21 Thread Andreas Neumann
Hi, yes, the Simplify() command is an implementation of the Douglas-Poiker algorithm. This algorithm is direction dependent, which is a problem in Postgis, which stores edges in polygon mosaics twice. I've just recently discussed this issue with a colleague, who is currently looking into imp