xD,
You might just want to go the Yum Install route.
Here are a couple of articles we have written that may help.
Here is a newer article -- but installing PostGIS via Yum on 9.0
I haven't tried on 8.4, but should be pretty much the same instructions:
http://www.postgresonline.com/journal/archive
I was thinking about incorporating trigrams as well. I have been impressed
with their speed and accuracy for some types of checks. Look at our write-up
http://www.postgresonline.com/journal/archives/169-Fuzzy-string-matching-wit
h-Trigram-and-Trigraphs.html
Also improvements are supposed to have
* Johnathan Leppert (johnathan.lepp...@gmail.com) wrote:
> Ok, I have it working, but it's very very slow. It takes about two seconds
> to geocode a single record. This isn't very realistic for large datasets.
> Anyone have any ideas on possible optimization? It appears to have created
> proper ind
Hi.
I can't find URL,WEB,PAGE where to install PROJ4 steap to steap
Any help please?
I am in Centos 5 with PgSQL 8.4
In http://postgis.refractions.net/documentation/ I read:
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Installation
You will want to install the PROJ4 4.6 (reproj
Thanks. I started using GIST.
It works.
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
On Thu, May 5, 2011 at 8:39 PM, Ben Madin wrote:
> Sairam,
>
> On 06/05/2011, at 5:50 AM, Sairam Krishnamurthy wrote:
>
> > Table structure: lat AS double, lon AS double, spatialPoint AS point.
> >
> > I have
Hi,
I am trying to build 64 bit binaries for postgis-1.5.2 on HP-UX B.11.31 (ia64
hp Integrity rx2800 i2). HP compiler was giving the following error message i.e.
make -C postgismake[1]: Entering directory
`/home/edb/AS90/postgis/postgis-1.5.2/postgis'cc +DD64 -Ae -E -traditional-cpp
postgis.s
Ok, I have it working, but it's very very slow. It takes about two seconds
to geocode a single record. This isn't very realistic for large datasets.
Anyone have any ideas on possible optimization? It appears to have created
proper indexes on all the tables.
Johnathan
On Fri, Apr 29, 2011 at 11:45
On 06/05/2011 15:04, Jaime Lop wrote:
And can I add this srid to postgis or do I need to make the
transformation elsewhere?
Just update the table, the spatial ref sys table defines how a mapping
should be done. The link I provide gives a def for this projection.
On Fri, May 6, 2011 at 3:45 PM,
And can I add this srid to postgis or do I need to make the transformation
elsewhere?
On Fri, May 6, 2011 at 3:45 PM, Dave wrote:
> On 06/05/2011 14:13, Jaime Lop wrote:
> Postgis is telling you that it does not have an entry in the
> spatial_ref_sys table for the srid 8307
>
> See http://forum
On 06/05/2011 14:13, Jaime Lop wrote:
Postgis is telling you that it does not have an entry in the
spatial_ref_sys table for the srid 8307
See http://forums.esri.com/Thread.asp?c=2&f=1720&t=136889 for some
comments about 8307
Hello everyone,
I have some data with srid 8307 on a postgis colum
Hello everyone,
I have some data with srid 8307 on a postgis column and I would like to
transform it to 4326. Is that possible?
When I try
UPDATE my_table SET the_geom=transform(the_geom,4326);
I get this error message:
ERROR: GetProj4StringSPI: Cannot find SRID (8307) in spatial_ref_sys
SQL stat
11 matches
Mail list logo
