Pardon my lack of specificity. I'm familiar with spatial indexes and at
least somewhat familiar with ST_Contains and its internal bounding box
check. Maybe it would help to clarify why I found this point_ops operator
class so interesting. Currently, my queries are often getting bad estimates
for th
Create the gist index on table containing points using the following syntax:
CREATE INDEX ON USING GIST ();
After the index is created use the criteria st_contains(polygon,point) in the
where clause of select statement:
Select * from where st_contains(polygon, point) ;
Regards,
Kedar Tamb
On 12/01/13 06:45, Bosco Rama wrote:
On 01/11/13 09:31, Gavin Flower wrote:
-- theta in radians
-- for radius = 100
INSERT INTO ranpoint
(id, theta, r)
VALUES
(generate_series(1, 10), pi() * random(), 100 * random());
Shouldn't the value for theta be:
2 * pi() * random()
Bos
On 01/11/13 09:31, Gavin Flower wrote:
> -- theta in radians
> -- for radius = 100
>
> INSERT INTO ranpoint
> (id, theta, r)
> VALUES
> (generate_series(1, 10), pi() * random(), 100 * random());
Shouldn't the value for theta be:
2 * pi() * random()
Bosco.
--
Sent via pgsql-gene
Stefan Keller wrote:
> "... ORDER BY random() LIMIT 10;" works ok.
>
> But with the following option it gets more tricky assume:
>> And as an option the (limited) resultset should be spatially
>> distributed (not clustered).
>
> I'm thinking about some radial spatial distribution function.
So,
Hi,
Thanks a lot to Adrian, Nicolas and Brooks.
"... ORDER BY random() LIMIT 10;" works ok.
But with the following option it gets more tricky assume:
> And as an option the (limited) resultset should be spatially
> distributed (not clustered).
I'm thinking about some radial spatial distribution
On 08/30/2012 04:40 PM, Willy-Bas Loos wrote:
(why not a separate catalog with all the functions and types etc? hmz
maybe because you'd need to change the search_path, which is in
postgresql.conf)
You can choose which schema an extension goes into when you CREATE
EXTENSION. See the documentat
On Wed, Aug 29, 2012 at 5:46 PM, Andres Freund wrote:
>
> Two things:
> * the geometry_columns table is not a table anymore but a view of the
> postgres
> catalogs
>
Great! I didn't know that yet. It must derive the info from the constraints
then.
So that means you can just create the column with
On Wednesday, August 29, 2012 06:02:24 PM Tom Lane wrote:
> Andres Freund writes:
> > On Wednesday, August 29, 2012 04:44:14 PM Willy-Bas Loos wrote:
> >> pg_dump -s should use add_geometrycolumn(...) instead of creating a
> >> column+constraints with normal DDL
> >> Because, when you don't dump t
Andres Freund writes:
> On Wednesday, August 29, 2012 04:44:14 PM Willy-Bas Loos wrote:
>> pg_dump -s should use add_geometrycolumn(...) instead of creating a
>> column+constraints with normal DDL
>> Because, when you don't dump the data, then the record in geometry_columns
>> is lost.
> That sho
On Wednesday, August 29, 2012 05:41:07 PM Willy-Bas Loos wrote:
> On Wed, Aug 29, 2012 at 5:23 PM, Andres Freund
wrote:
> > That shouldn't be a problem with postgres 2 anymore as far as I
> > understand things?
Argh, postgis 2.
Two things:
* the geometry_columns table is not a table anymore but a
On Wed, Aug 29, 2012 at 5:23 PM, Andres Freund wrote:
> That shouldn't be a problem with postgres 2 anymore as far as I understand
> things?
>
Why?
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
On Wednesday, August 29, 2012 04:44:14 PM Willy-Bas Loos wrote:
> Hi,
>
> pg_dump -s should use add_geometrycolumn(...) instead of creating a
> column+constraints with normal DDL
> Because, when you don't dump the data, then the record in geometry_columns
> is lost.
That shouldn't be a problem wit
Hello,
What PostGIS functions that modify data are you guys talking about? I'm new
to PostGIS, and looking for advice when using it with PgPool for
replication. I wonder if you know of any documentation about it.
Thanks in advance,
Gabriel
Szymon Guz-2 wrote
>
> On 19 September 2011 16:17, Tats
2012/2/16 Sandro Santilli :
> I don't think there's much to discuss.
> I'm sure a patch to psql would be welcome.
Sorry, I did not realize that the solution is straight forward :->
--Stefan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
On Wed, Feb 15, 2012 at 10:37:08PM +0100, Stefan Keller wrote:
> Hi Regina
>
> 2012/2/14 Paragon Corporation wrote:
> > Here it is in the docs now:
> >
> > http://postgis.refractions.net/documentation/manual-svn/using_raster.xml.html#RasterOutput_PSQL
>
> Citation from there: "Sadly PSQL doesn't
Hi Regina
2012/2/14 Paragon Corporation wrote:
> Here it is in the docs now:
>
> http://postgis.refractions.net/documentation/manual-svn/using_raster.xml.html#RasterOutput_PSQL
Citation from there: "Sadly PSQL doesn't have easy to use built-in
functionality for outputting binaries..."
Did anyon
On 10/27/2011 04:24 PM, Chris Travers wrote:
On Thu, Oct 27, 2011 at 9:44 AM, Martijn van Oosterhout
wrote:
I note in the OPs case they are relying on the customer to install
PostGIS. The GPL only applies to *redistribution* not usage. So if
you're not supplying your customers with PostGI
On Thu, Oct 27, 2011 at 9:44 AM, Martijn van Oosterhout
wrote:
> I note in the OPs case they are relying on the customer to install
> PostGIS. The GPL only applies to *redistribution* not usage. So if
> you're not supplying your customers with PostGIS then the fact that
> it's GPL seems complet
On Tue, Oct 25, 2011 at 01:41:17PM +0200, Thomas Kellerer wrote:
> Thank you very much for the detailed explanation.
>
> I always have a hard time to understand the GPL especially the
> dividing line between "using", "linkin" and creating a derived work.
That because the GPL does not get to defin
Mark Cave-Ayland, 25.10.2011 12:51:
As Robert has suggested, you have misunderstood the GPL license - if
you make changes to the *PostGIS* source code AND you distribute the
modified code to your customer (rather than offering a managed
service), you would need to make the changes available to yo
On 10/25/11 3:51 AM, Mark Cave-Ayland wrote:
As Robert has suggested, you have misunderstood the GPL license - if
you make changes to the *PostGIS* source code AND you distribute the
modified code to your customer (rather than offering a managed
service), you would need to make the changes avai
On -10/01/37 20:59, Thomas Kellerer wrote:
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) project then. The source code
will not be made open source, but of course the customer will get
the source code.
Is it still OK to use the GPL licen
On 22/10/11 02:53, Eduardo Morras wrote:
> At 09:26 21/10/2011, Thomas Kellerer wrote:
>> Hello,
>>
>> we are using PostgreSQL in our projects and would like to integrate
>> PostGIS as well.
>>
>> Now PostGIS is licensed under the GPL and I wonder if we can use it in
>> a commercial (customer speci
Tomas Vondra wrote on 24.10.2011 20:11:
On 24 Říjen 2011, 19:44, Thomas Kellerer wrote:
Pavel Stehule wrote on 24.10.2011 12:19:
there is not clean who is customer and what is one unit. If you
distribute PostGIS inside your application as one unit to customer,
then your application should to us
On 24 Říjen 2011, 19:44, Thomas Kellerer wrote:
> Pavel Stehule wrote on 24.10.2011 12:19:
>> there is not clean who is customer and what is one unit. If you
>> distribute PostGIS inside your application as one unit to customer,
>> then your application should to use GPL.
>
> So if we only distribu
2011/10/24 Thomas Kellerer :
> Pavel Stehule wrote on 24.10.2011 12:19:
>>
>> there is not clean who is customer and what is one unit. If you
>> distribute PostGIS inside your application as one unit to customer,
>> then your application should to use GPL.
>
> So if we only distribute our applicati
Pavel Stehule wrote on 24.10.2011 12:19:
there is not clean who is customer and what is one unit. If you
distribute PostGIS inside your application as one unit to customer,
then your application should to use GPL.
So if we only distribute our application and require the customer to install
Pos
2011/10/24 Edoardo Panfili :
> Il 24/10/11 10:03, Pavel Stehule ha scritto:
>>
>> 2011/10/24 Thomas Kellerer:
>>>
>>> Eduardo Morras, 21.10.2011 20:53:
>
> Now PostGIS is licensed under the GPL and I wonder if we can use it
> in a commercial (customer specific) project then. The source
Il 24/10/11 12:19, Pavel Stehule ha scritto:
2011/10/24 Edoardo Panfili:
Il 24/10/11 10:03, Pavel Stehule ha scritto:
2011/10/24 Thomas Kellerer:
Eduardo Morras, 21.10.2011 20:53:
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) projec
On Monday, October 24, 2011 12:31:16 am Thomas Kellerer wrote:
> Eduardo Morras, 21.10.2011 20:53:
> >> Now PostGIS is licensed under the GPL and I wonder if we can use it
> >> in a commercial (customer specific) project then. The source code
> >> will not be made open source, but of course the cus
Il 24/10/11 10:03, Pavel Stehule ha scritto:
2011/10/24 Thomas Kellerer:
Eduardo Morras, 21.10.2011 20:53:
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) project then. The source code
will not be made open source, but of course the custo
2011/10/24 Thomas Kellerer :
> Eduardo Morras, 21.10.2011 20:53:
>>>
>>> Now PostGIS is licensed under the GPL and I wonder if we can use it
>>> in a commercial (customer specific) project then. The source code
>>> will not be made open source, but of course the customer will get
>>> the source cod
Am 24/10/11 09:31, schrieb Thomas Kellerer:
Eduardo Morras, 21.10.2011 20:53:
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) project then. The source code
will not be made open source, but of course the customer will get
the source code.
Eduardo Morras, 21.10.2011 20:53:
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) project then. The source code
will not be made open source, but of course the customer will get
the source code.
Is it still OK to use the GPL licensed PostGI
At 09:26 21/10/2011, Thomas Kellerer wrote:
Hello,
we are using PostgreSQL in our projects and would like to integrate
PostGIS as well.
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) project then.
The source code will not be made open
I'm not a lawyer, cockroach, or hobbyist license enthusiast. Here's my
impression.
First, I'm sure this must come IP a lot. Have you looked for a PostGIS
licensing faq? Checked their mailing lists?
The issues with bundling MySQL were mostly around the GPL-licensed client
library, something that d
On 2011-10-12, at 6:31 PM, Andy Colson wrote:
On 10/12/2011 06:38 PM, Andy Colson wrote:
On 10/12/2011 06:29 PM, Andy Colson wrote:
On 10/12/2011 01:01 PM, René Fournier wrote:
Hi,
I'm developing a reverse-geocoder for Canada. So far, given a
lat/lng, I can find the nearest street (line segm
Thanks Andy for thinking about this for me.
I tried using that function, but get this error:
gc3=# SELECT
gc3-# ST_AsText(the_geom) as street, strunamefr, l_adddirfg, l_hnumf, l_hnuml,
l_stname_c, l_placenam, r_adddirfg, r_hnumf, r_hnuml, r_stname_c, r_placenam,
gc3-# ST_Distance(ST_GeomFromText
On 10/12/2011 06:38 PM, Andy Colson wrote:
On 10/12/2011 06:29 PM, Andy Colson wrote:
On 10/12/2011 01:01 PM, René Fournier wrote:
Hi,
I'm developing a reverse-geocoder for Canada. So far, given a lat/lng, I can
find the nearest street (line segment), which includes line segment direction
an
On 10/12/2011 06:29 PM, Andy Colson wrote:
On 10/12/2011 01:01 PM, René Fournier wrote:
Hi,
I'm developing a reverse-geocoder for Canada. So far, given a lat/lng, I can
find the nearest street (line segment), which includes line segment direction
and address ranges for both sides of the stree
On 10/12/2011 06:29 PM, Andy Colson wrote:
On 10/12/2011 01:01 PM, René Fournier wrote:
Hi,
I'm developing a reverse-geocoder for Canada. So far, given a lat/lng, I can
find the nearest street (line segment), which includes line segment direction
and address ranges for both sides of the stree
On 10/12/2011 01:01 PM, René Fournier wrote:
Hi,
I'm developing a reverse-geocoder for Canada. So far, given a lat/lng, I can
find the nearest street (line segment), which includes line segment direction
and address ranges for both sides of the street. I'm now trying to figure out
the best wa
Yes, I did a version of the query where i terminated the connection in the
loop after one year, and then reconnected to the server for each year in the
query.
This did not change anything, and the query still halted on the same year.
Like this:
# For each year calculate the distance to border and i
On Tue, Oct 11, 2011 at 05:12:24PM +0200, Andreas Forø Tollefsen wrote:
> Hi Sandro,
>
> What i find strange is that it stops processing at different years on my
> desktop and my laptop. While my desktop stops processing at 1980, my slower
> laptop goes on to 1991 before halting.
> I also tried wi
Hi Sandro,
What i find strange is that it stops processing at different years on my
desktop and my laptop. While my desktop stops processing at 1980, my slower
laptop goes on to 1991 before halting.
I also tried with different postgresql.conf shared_buffers settings without
making any difference.
On Tue, Oct 11, 2011 at 02:25:20PM +0200, Andreas Forø Tollefsen wrote:
> I also tried to close the db1 connection for each year in the loop, and
> reopen the connection for the next year in the loop. Same problem.
> I have tried both with insert into ... select .. and select into annual
> tables
On 19 September 2011 16:17, Tatsuo Ishii wrote:
> > Hi,
> > do you know about any problems with using pgpool and postgis together?
>
> I personaly don't know any case study of pgpool and posgis but I
> guess:
>
> 1) You are using pgpool-II native replication mode
> 2) Some of postgis functions ar
> Hi,
> do you know about any problems with using pgpool and postgis together?
I personaly don't know any case study of pgpool and posgis but I
guess:
1) You are using pgpool-II native replication mode
2) Some of postgis functions are doing updates/inserts/deletes
then you may have problem becau
On 2011-02-07, at 11:27 AM, Edoardo Panfili wrote:
> On 07/02/11 18.55, Paul Ramsey wrote:
>> Well, maybe you could in-place upgrade if you left your PostGIS version
>> at the original and only upgraded the PostgreSQL part, but you aren't
>> doing that, you're also upgrading your PostGIS version.
On 07/02/11 18.55, Paul Ramsey wrote:
Well, maybe you could in-place upgrade if you left your PostGIS version
at the original and only upgraded the PostgreSQL part, but you aren't
doing that, you're also upgrading your PostGIS version.
pg_dump the database
create a new database on the new server
I'm not sure you can in-place upgrade a postgis database...
On 2011-02-07, at 9:49 AM, akp geek wrote:
>
> Please pardon my ignorance. The reason I am worried about it is, when I tried
> to use pg_upgrade to migrate from 8.3 to 9.0.2. I am getting an error
>
> Failed to load library: $libdir/l
Well, maybe you could in-place upgrade if you left your PostGIS version at the
original and only upgraded the PostgreSQL part, but you aren't doing that,
you're also upgrading your PostGIS version.
pg_dump the database
create a new database on the new server, install postgis in it
pg_restore the
Please pardon my ignorance. The reason I am worried about it is, when I
tried to use pg_upgrade to migrate from 8.3 to 9.0.2. I am getting an error
Failed to load library: $libdir/liblwgeom
ERROR: could not access file "$libdir/liblwgeom": No such file or directory
I am using pg_upgrade for upgr
installation was successful. But it did not install the liblwgeom.so
Regards
On Mon, Feb 7, 2011 at 12:29 PM, Paul Ramsey wrote:
> It's just a warning, continue happily onwards. Just means a few unit tests
> won't be run.
>
> P.
>
>
> On 2011-02-07, at 9:27 AM, akp geek wrote:
>
> Hi All -
>
>
It's just a warning, continue happily onwards. Just means a few unit tests
won't be run.
P.
On 2011-02-07, at 9:27 AM, akp geek wrote:
> Hi All -
>
> I am trying to install postgis 1.5.2 on solaris10. When I run the
> configure I get the following.
>
> configure: WAR
Hi,
for adding a geometry-column to an existing table use one of the
postgis-functions "select AddGeometryColumn(...);" described in:
http://postgis.refractions.net/documentation/manual-1.5/AddGeometryColumn.html
Ludwig
Am 17.01.2011 18:35, schrieb "Plata Martínez, Álvaro (KNMI)":
Hi,
Using
=?ISO-8859-1?Q?=22Plata_Mart=EDnez=2C_=C1lvaro_=28KNMI=29=22?=
writes:
> Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server, when
> trying to create a table:
> CREATE TABLE observation (
> (...)
> spatial_value geometry,
> );
> I get this error message:
> ERROR: type "geometry" does
Op 17 jan 2011, om 18:35 heeft Plata Martínez, Álvaro (KNMI) het
volgende geschreven:
Hi,
Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server,
Did also install the PostGIS-functions, types, etc. in your database?
Installing PostGIS is a combination of installing the package a
On 28 October 2010 10:00, trevor1940 wrote:
>
> Hi
>
> I have a PostGIS table and I wish to get the location/name of multiple
> points at once the command for selecting one point is
>
> select PolyName from MyPolygones where st_Contains(the_geom,
> GeomFromText('point($LAT $LONG)4326');
>
> where
Just some thoughts:
- create a multipoint with 100 vertices instead of a single point and query
once with st_Intersect
- prepare the single-point-query and execute the prepared query 100 times with
the changing coordinates
Ludwig
- Ursprüngliche Nachricht -
Von: trevor1940
Gesendet:
hey,
I haven't used postgis yet, however,
assuming the normal rules still apply and st_Contains returns
true/false:
SELECT ... WHERE st_Contains(point1) OR st_Contains(point2) OR ...
or using the IN statement:
SELECT ... WHERE true IN (st_Contains(point1),st_Contains(point2),...)
That should g
Does that last query (invoking the upper() function) actually run well when
executed in pgsql console?
Rob
2009/10/16 Arnaud Lesauvage
> Hi all!
>
> I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
> database. I want my shapefile to be encoded in WIN1252, and a particular
>
On Fri, Mar 21, 2008 at 4:24 PM, Andrej Ricnik-Bay
<[EMAIL PROTECTED]> wrote:
> On 22/03/2008, John Smith <[EMAIL PROTECTED]> wrote:
> > > > please don't cross-post my cross-post. if i wanted to post it to the
> > > > postgresql list, i would have ;)
>
> > > That seems to be quite a silly reques
On 22/03/2008, John Smith <[EMAIL PROTECTED]> wrote:
> > > please don't cross-post my cross-post. if i wanted to post it to the
> > > postgresql list, i would have ;)
> > That seems to be quite a silly request, considering you were asking for
> > assistance on public lists.
> no seriously! if
On Fri, Mar 21, 2008 at 10:17 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
> John Smith wrote:
> > On Thu, Mar 20, 2008 at 2:16 PM, Colin Wetherbee
> > <[EMAIL PROTECTED]> wrote:
> >> Please don't cross-post, especially since nobody on the PostGIS
> >> mailing list answered your previous question
John Smith wrote:
On Thu, Mar 20, 2008 at 2:16 PM, Colin Wetherbee
<[EMAIL PROTECTED]> wrote:
Please don't cross-post, especially since nobody on the PostGIS
mailing list answered your previous question.
please don't cross-post my cross-post. if i wanted to post it to the
postgresql list, i w
On Thu, Mar 20, 2008 at 2:16 PM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
> John Smith wrote:
> > guys,
>
> Please don't cross-post, especially since nobody on the PostGIS mailing
> list answered your previous question.
On Thu, Mar 20, 2008 at 6:45 PM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
On 21/03/2008, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
> Dunno about that. On the PostGIS list, he said:
>
> "i got an old box supporting only 1 floating-point"
>
> Maybe he means an FPU? *boggle*
Maybe floating-point registers on the FPU?
So many options!
Cheers,
Andrej
--
Please don't
Sam Mason wrote:
On Thu, Mar 20, 2008 at 02:02:12PM -0400, John Smith wrote:
how many min. floating-points must a server hardware support for
postgresql+postgis? does postgresql+postgis do much floating-point
math to make a difference? can someone give postgresql+postgis
application examples tha
On Thu, Mar 20, 2008 at 02:02:12PM -0400, John Smith wrote:
> how many min. floating-points must a server hardware support for
> postgresql+postgis? does postgresql+postgis do much floating-point
> math to make a difference? can someone give postgresql+postgis
> application examples that will requi
John Smith wrote:
guys,
how many min. floating-points must a server hardware support for
postgresql+postgis? does postgresql+postgis do much floating-point
math to make a difference? can someone give postgresql+postgis
application examples that will require high floating-points?
thks, jzs
I do
John Smith wrote:
guys,
Please don't cross-post, especially since nobody on the PostGIS mailing
list answered your previous question.
how many min. floating-points must a server hardware support for
postgresql+postgis? does postgresql+postgis do much floating-point
math to make a difference
Dev--> The site which u sent has postgis rpm which need
postgres-8.1.3 ... and i cant find RPMS for postgres-8.1.3 ...anywhere
??
what version of Postgis should i install for Postgres-8.1.5 ??
And where can i find its RPM for RHEL 4 -AS ...???
Thanks in advance
-
sandeep
On 11/7/06, Paul Ra
Any one you want. Using the latest won't hurt.On 6-Nov-06, at 11:36 AM, Sandeep Kumar Jakkaraju wrote:What version of Postgis should i install for postgres 8.1.5 ??On 11/7/06, Paul Ramsey <[EMAIL PROTECTED] > wrote:PgSQL 7.4 is still supported by the latest PostGIS versions.As is PgSQL 8.1 and (wh
What version of Postgis should i install for postgres 8.1.5 ??On 11/7/06, Paul Ramsey <[EMAIL PROTECTED]
> wrote:PgSQL 7.4 is still supported by the latest PostGIS versions.As is PgSQL
8.1 and (when it comes) 8.2.POn 6-Nov-06, at 8:07 AM, Joshua D. Drake wrote:> Kumar Jakkaraju wrote:>> Ya...
PgSQL 7.4 is still supported by the latest PostGIS versions.
As is PgSQL 8.1 and (when it comes) 8.2.
P
On 6-Nov-06, at 8:07 AM, Joshua D. Drake wrote:
Sandeep Kumar Jakkaraju wrote:
Ya...
That was my next question ...
if i build the source (the tar.gz) on the postgis.org site ..
will it be
Sandeep Kumar Jakkaraju wrote:
> Ya...
>
> That was my next question ...
> if i build the source (the tar.gz) on the postgis.org site ..
> will it be compatible with... postgres-8.1.5
Probably not. You will need a postgis version for 7.4.
Joshua D. Drake
>
> Thanks
> Regards
> Sandeep
>
>
>
Ya...That was my next question ... if i build the source (the tar.gz) on the postgis.org site ..will it be compatible with... postgres-8.1.5ThanksRegardsSandeep
On 11/6/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Hi,On Mon, 2006-11-06 at 21:04 +0530, Sandeep Kumar Jakkaraju wrote:> The site u gave
Hi,
On Mon, 2006-11-06 at 21:04 +0530, Sandeep Kumar Jakkaraju wrote:
> The site u gave me has ..
> has postgis rpm ..but it needs postgres-7.4 !! i need
> postgis rpm for postgres-8.1.5
So use the SRPMs to build RPMs for you. I don't have 7.4+RHEL4 around to
build you an RPM for that. :(
Hi Dev,The site u gave me has ..has postgis rpm ..but it needs postgres-7.4 !! i need postgis rpm for postgres-8.1.5ThankssandeepOn 11/4/06,
Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Hello,On Sat, 2006-11-04 at 13:21 +0530, Sandeep Kumar Jakkaraju wrote:> I am unable to find PostGIS Binary RPM
Hello,
On Sat, 2006-11-04 at 13:21 +0530, Sandeep Kumar Jakkaraju wrote:
> I am unable to find PostGIS Binary RPM for Red Hat Linux ...on the
> postgis.org website ... Can somebody point me to the url from where
> i can download ...this ??
I am assuming that you want RPMs for RHEL, not RHL.
h
On Thu, Nov 02, 2006 at 09:11:58PM +0530, Sandeep Kumar Jakkaraju wrote:
> Like We have used the Haversine formula ...given on most of the websites ...
> to calculate the distance between to lat/lon points ..
You can examine the PostGIS source code to see how distance_sphere()
works; the underlyin
On Nov 2, 2006, at 10:41 AM, Sandeep Kumar Jakkaraju wrote:After all it is open source ...so how can one trust it fully If you have a question about how something is working, and you find the end-user documentation to be lacking, you can look at the software's source. -James Cradock, [EMAI
Hi All .. Please forgive my ignorance After all it is open source ...so how can one trust it fully I am GIS guy (i think ..) Like We have used the Haversine formula ...given on most of the websites ... to calculate the distance between to lat/lon points ..
which doesnt match with the dista
Sandeep Kumar Jakkaraju wrote:
I use postgis to wipe my ASS ...
no good documentation ...
The docs are a bit technical, but the product is excellent, I use it to
manage a variety of spatial datasets, with up to hundreds of millions of
features, on half a dozen systems. I'd highly recommend i
On Thu, Oct 19, 2006 at 09:31:40PM +0530, Sandeep Kumar Jakkaraju wrote:
> I use postgis to wipe my ASS ...
> no good documentation ...
If you find the documentation lacking then please consider posting
to postgis-users with suggestions for improving it. Even better,
submit a patch :-)
> in what
Thanks Woody
Bob
- Original Message -
From:
Woody Woodring
To: 'Bob Pawley' ; 'Postgresql'
Sent: Thursday, October 19, 2006 8:18
AM
Subject: Re: [GENERAL] PostGIS
Here is their web page:
http://postgis.refractions.net/
I am prob
Thanks Jim
Bob
- Original Message -
From:
James Cradock
To: Postgresql
Cc: Bob Pawley
Sent: Thursday, October 19, 2006 8:35
AM
Subject: Re: [GENERAL] PostGIS
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:
Can anyone point me to an overview of
I use postgis to wipe my ASS ...no good documentation ...in what units is the result of distance(geometry,geometry)..what is distance_sphere(geometry,geometry).. when u give same geometry as both parameters it gives a non-zero value
On 10/19/06, James Cradock <[EMAIL PROTECTED]> wrote:
On Oct
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:Can anyone point me to an overview of PostGIS and how it is being used??? Bob, PostGIS provides extensions to PostgreSQL's procedural language and geometric data types so that it can store geo-referenced data, and so that you can query this data using
Here is their web page:
http://postgis.refractions.net/
I am probably not the best to answer how it is used because
we use it just to allow index on spatial data (coordinates). You may ask
on the postgis mailing list.
Woody
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
On Wed, Feb 16, 2005 at 06:16:36PM -0700, Pritesh Shah wrote:
> hi,
>
> I would like to thank everybody for their responses to my question. I
> tried a couple of things and the best thing for me was to use
> utils/postgis_restore.pl script.
>
> I ran this script on some sample databases and they
Hi, Pitesh,
[EMAIL PROTECTED] schrieb:
> You can't simply restore a dump to upgrade postgis
> for two reasons:
>
> 1) postgis library name might have changed (this is the case).
> 2) postgis procedural language function might be changed
> and you'd get the old ones.
>
> You
You can't simply restore a dump to upgrade postgis
for two reasons:
1) postgis library name might have changed (this is the case).
2) postgis procedural language function might be changed
and you'd get the old ones.
You can find an utility script in the utils/ directory
The short answer is that you leave out all the postgis function calls in
your dump, create a new database and load the postgis functions using the
new scripts. Then you just load the data.
I didn't find an easy way to selectively load tables and views using the
.sql format (and I actually didn't
tgl wrote:
> strk <[EMAIL PROTECTED]> writes:
> > If I run that again, *exactly the same query*:
> > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
> > 566 pgsql 14 0 126M 126M 3396 S 0.0 16.8 7:13 postmaster
>
> > It looks like someone is leaking memory, eit
strk <[EMAIL PROTECTED]> writes:
> dblasby wrote:
>> Hum - this shouldnt do anything.
>> The aggregate should have "null" as its initial value.
>> GeomUnion(null,) --> null.
>> So, you'll end up with null *very* quickly because
>> GeomUnion(null,) returns null without any actual execution.
> It l
dblasby wrote:
> strk wrote:
> > Dave, I made no special 'unite' code, just sql create command:
> > CREATE AGGREGATE unite (
> > sfunc = GeomUnion,
> > basetype = geometry,
> > stype = geometry
> > );
>
> Hum - this shouldnt do anything.
>
> The aggregate should have "null" as its ini
99 matches
Mail list logo
