Hello,
I have a postgres query, which takes about 0,1sek and resultset is one line On
my page, there is a link, which uses same sql tuo print koordinates to map.
When plotting to the maps, it's never ends.
I killed query from active task and pick sql from postgres log. It seems like
following:
Hello,
I have two tables.
1. House-table with 15 columns. No any postgis-columns. There is about 8 000
000 rows in table. Unique primary key is house_id.
2. Name-table with 4 columns. one geometry clolumn as:
public name location 2 3067 POINT
There is about 2 000 000 rows in table. Unique primar
4 ellipsoid you have to
> > transform twice: ST_Transform( ST_Transform( POINT_FROM_3067, 4326),
> > 2393)
> >
> > Gr
> > Ralf
> >
> > Am Freitag 04 März 2011, 11:53:44 schrieb Pena Kupen:
> > > Hello all,
> > >
> > > I
ct towgs84 parameters in
spatial_ref_sys (http://spatialreference.org/ref/epsg/2393/proj4/).
Because the destination EPSG is not based on WGS84 ellipsoid you have to
transform twice: ST_Transform( ST_Transform( POINT_FROM_3067, 4326), 2393)
Gr
Ralf
Am Freitag 04 März 2011, 11:53:44 schrieb
Hello all,
I try to do some conversion between different coordinates (3067 to 2393 )
without saving them to database.
My sql is following:
select x(ST_Transform(tbl.p,2393)), y(ST_Transform(tbl.p,2393)) from (select
GeomFromText('POINT(108043 6683685)',3067) as p) as tbl
result:
3107866.533 66
age-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Pena
Kupen
Sent: Monday, August 24, 2009 4:14 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] functions st_covers, st_coveredby,
st_simplifypreservetopology does not exist
tarting 'apache':
Same errors as before.
So there must be some difference between ubuntu and centos
--
pk
Normand Savard kirjoitti:
Pena Kupen wrote:
> Hello Norm,
>
> On CentOs 5.3?
> Can you post your commands to me, so that I can test with same?
> What is yourr root&
Hi all,
My environment seems now be correct with Postgres 8.4, postgis 1.3.6 and geos
2.2.3.
All script, except this postgis_comments.sql are loaded ok. I still got errors:
psql -f postgis_comments.sql -Upostgres -d mydb
psql:postgis_comments.sql:291: ERROR: function st_covers(geometry, geome
Yeps. when adding /usr/local/bin to path, I can run as geos-config --version
and it shows 3.1.1.
I must exam little more about my current versions first.
--
pk
Mark Cave-Ayland kirjoitti:
Pena Kupen wrote:
> I cannot find it from my current path - should it be? it is located on
>
Regina,
So is there anything I should do with these missing functions?
--
pk
Paragon Corporation kirjoitti:
Mark,
> Hmmm maybe the postgis_comments.sql generation script doesn't take into
account that you are using an older version of GEOS (pre 3.1)? Regina?
The comments isn't filtering ba
I cannot find it from my current path - should it be?
it is located on /usr/local/bin/
and when runnig it as
/usr/local/bin/geos-config --version
I got 3.1.1
--
pk
Mark Cave-Ayland kirjoitti:
Pena Kupen wrote:
> Hi,
>
> I install geos 3.1.1 from source and try the same.
> Th
Hi,
I install geos 3.1.1 from source and try the same.
There where no difference - same errors occurred again.
How to find out, which version of geos my scripts are using?
ideas?
--
pk
Pena Kupen kirjoitti:
I'm using 2.2.3-3.rhel5 from CentOs5.3 yum catalog.
Maybe I should reload s
I'm using 2.2.3-3.rhel5 from CentOs5.3 yum catalog.
Maybe I should reload source and install it from there?
--
pk
Mark Cave-Ayland kirjoitti:
Pena Kupen wrote:
> Hi,
>
> I'm creating database on Postgres 8.4 and when running postgis
> (installed with yum - 1.3.6-1.
Mark,
Yeps manual seems to be ok!
--
pk
Mark Cave-Ayland kirjoitti:
Pena Kupen wrote:
> Hello all,
>
> I'm runnig postgres 8.4.0 on centos 5
> and postgis installed from latest fgs package.
> It seems that fgs libraries are old one's.
> I got error bel
oun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] Im Auftrag von Pena Kupen
Gesendet: Freitag, 14. August 2009 10:51
An: postgis-users@postgis.refractions.net
Betreff: [postgis-users] Version mismatch
Sorry for doubleposting!
--
pk
>Which version of PostGIS is
ourself or maybe this is left over from your
PostgreSQL 8.3 install and postgis really wasn't installed.
Leo
-Original Message-
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Pena
Kupen
Sent: Thursday, August
Hi,
I'm creating database on Postgres 8.4 and when running postgis (installed with
yum - 1.3.6-1.rhel5) 1.3.6-1.rhel5 I got following errors.
-bash-3.2$ psql -f lwpostgis.sql -Upostgres -d mydb
--just a few notices - no errors
-bash-3.2$ psql -f postgis_comments.sql -d mydb
psql:postgis_comm
over from your
PostgreSQL 8.3 install and postgis really wasn't installed.
Leo
-Original Message-
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Pena
Kupen
Sent: Thursday, August 13, 2009 10:57 AM
To: p
Hello all,
I'm runnig postgres 8.4.0 on centos 5
and postgis installed from latest fgs package.
It seems that fgs libraries are old one's.
I got error below, when try to rung
psql -d mydatabase -f lwpostgis.sql
BEGIN
psql:lwpostgis.sql:44: NOTICE: type "histogram2d" is not yet defined
DE
19 matches
Mail list logo
