Chris,
Did you confirm that your btree index works fine without the spatial query
part?
Run the query without the spatial part at all. If you don't have enough
data distinct categories, its often faster for PostgreSQL not to use the
btree index or at least it thinks so. Its also sometimes som
Bob,
Copy is better. So copy the file as William said, and rename the new copy
libiconv2.dll.
Some programs refer to it by libiconv-2.dll and some as libiconv2.dll. It's
a complicated story, but they are generally interchangeable.
However if you simply rename the existing, you'll break some
> In error.log I find the following:
>
> psql:/usr/share/pgsql/contrib/lwpostgis.sql:2356: ERROR: language
> "plpgsql" does not exist
doh - sorry, right there in the doc above the command I ran -
# createlang plpgsql [yourdatabase]
I feel dumb :-/
-
Michael A. Peters
http://www.shastaher
I'm using CentOS 5.4 up to patch level. Pretty much stock CentOS + EPEL.
Only have updated php which shouldn't effect postgresql and a gnome
library that had a bug (and there I patched the src.rpm, same version as
stock). I usually don't like to replace vendor provided stuff.
postgresql-8.1.11-1.
Hi PostGIS folks,
I'm trying to find a way to read two 3-dimensional polygons and test if they
intersect. It's for a radar-bird-tracking application. I'm hoping that PostGIS
is a solution.
I've been scanning the Mailing list archives, and I gather that at least some
of the spatial operations
Hi Will,
Yes, DBSCAN is a much better choice for what you want to do. However,
how to include the temporal element becomes something of an issue with
DBSCAN or PAM/CLARA. Then there are the issues of selecting an epsilon
radius and min pts for the DBSCAN algorithm. At this point, given the
na
I don't really like those grid or rounding methods pretending to cluster
things. You can totally break all your natural clusters with any of those
methods. We could call them aggregating methods but please not clustering...
Just throwing a stone in the water.
Pierre
>-Original Message-
Thanks Pierre and Dylan for your helpful replies. FYI my dataset is
90K records describing events that occurred over 14 years over an area
of 50^2m.
The suggestion of using R's PAM and CLARA functions for clustering
lead me to the 'dbscan' algorithm which may well be a better choice
for my needs
I'm not sure what you mean by - "copy libiconv-2.dll to
libiconv2.dll."
Do you mean rename??
Bob
--
From: "William Furnass"
Sent: Friday, July 16, 2010 9:00 AM
To: "PostGIS Users Discussion"
Subject: Re: [postgis-users] shp2pgsql
Hi Bob,
I did find in the bin file but it is named libiconv-2 and the error was
looking for libiconv2.
Is there a way around this??
Bob
--
From: "Mark Cave-Ayland"
Sent: Friday, July 16, 2010 8:57 AM
To: "PostGIS Users Discussion"
Subject: Re: [postgis
Greetings,
I have a table with around a million rows with each row containing a *
geography* POINT (I'm covering the entire world). With these rows I need to
perform many nearest neighbor searches to locate other entities within a
range of 0 to 100km. The location field has a GiST index
With 5,
Hi Bob,
On 16 July 2010 16:46, Bob Pawley wrote:
>
> I just attempted to use shp2pgsql and received an error message about
> libiconv2.dll not being installed on my computer.
If you've got PostgreSQL installed then you should already have a copy
of the library. Find the 'bin' directory within
Bob Pawley wrote:
Hi
I just attempted to use shp2pgsql and received an error message about
libiconv2.dll not being installed on my computer.
Can anyone suggest where a clean copy can be found and instructions on
how to install it??
Bob
Hi Bob,
It's included with the PostGIS windows i
Hi
I just attempted to use shp2pgsql and received an error message about
libiconv2.dll not being installed on my computer.
Can anyone suggest where a clean copy can be found and instructions on how to
install it??
Bob___
postgis-users mailing list
On Fri, Jul 16, 2010 at 04:00:22PM +0200, Andrea Peri wrote:
> There is some document to help to install and use topology ?
See topology/README and the wiki:
http://trac.osgeo.org/postgis/wiki/UsersWikiPostgisTopology
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybi
Hi,
I like to test the topology suite for Postgis.
There is some document to help to install and use topology ?
Thx,
--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
postgis-users mailing list
postgis-users@postgis
On 15 July 2010 20:37, Michael A. Peters wrote:
> I'm currently working on a migration of my web site to postgresql so that
> I can use PostGIS.
>
> I'm still working on the devel side but basically -
>
> mysqldump database > dump.sql
> perl mysql2pgsql.perl dump.sql load.sql
> psql database < loa
On Fri, Jul 16, 2010 at 10:28:50AM +0700, nguyen thuy ai vy wrote:
> Hello everybody,
> Is there any problem if I add a geometry by this way?
>
> Firstly, I created table has a column with geometry type. Then, I added
> check constraints for this geometry column like this:
>
> CONSTRAINT con_po
18 matches
Mail list logo
