[GENERAL] PostGIS ST_CreateOverview Function For Non-Public Schema

2017-06-02 Thread Osahon Oduware
Hi All, I am trying to utilize the ST_CreateOverview function as described in the following link: https://postgis.net/docs/RT_CreateOverview.html I need to know how to include the schema name for the raster table in the function. It appears the default is the public schema. Please, I need help

[GENERAL] PostGIS Raster - Loading MrSID format

2017-04-10 Thread Osahon Oduware
Hi, I am trying to use the raster2pgsql tool to import raster images in MrSID format to PostGIS database on a Windows system. However, I get an error indicating that the format is not supported which I could confirm by running: raster2pgsql -G Please, could someone help with the basic steps to fo

[GENERAL] PostGIS Out-DB Raster Not Behaving As Expected

2017-04-10 Thread Osahon Oduware
Hi All, I created an out-db raster using the following syntax: raster2pgsql -s {srid} -c -R -I -C -F -t auto {absolute_file_path} public.{table} | psql -h {host} -p {port} -d {database} -U {user} The table was created successfully. I wanted to confirm that the actual file is being read from the

[GENERAL] PostGIS 2.2.0 Released

2015-10-07 Thread Paul Ramsey
http://postgis.net/2015/10/07/postgis-2.2.0 PostGIS 2.2.0 is released! Over the last two years a number of interesting new features have been added, such as: * True nearest-neighbor searching for all geometry and geography types * New volumetric geometry support, including ST_3DDifference, ST_3D

Re: [postgis-users] [GENERAL] postgis in postgresql apt and upgrades

2014-02-20 Thread Rémi Cura
So cool ^^ Going to simplify a lot install and upgrades ! Cheers, Rémi-C 2014-02-20 17:47 GMT+01:00 Willy-Bas Loos : > On Thu, Feb 20, 2014 at 4:45 PM, Willy-Bas Loos wrote: > >> Since the package names are equal to those in debian and ubuntu >> (postgresql-x.x-postgis), how will new versions

Re: [postgis-users][GENERAL] postgis in postgresql apt and upgrades

2014-02-20 Thread Willy-Bas Loos
On Thu, Feb 20, 2014 at 4:45 PM, Willy-Bas Loos wrote: > Since the package names are equal to those in debian and ubuntu > (postgresql-x.x-postgis), how will new versions of postgis and upgrades be > handled? > please excuse me, i was being silly. the package names are actually: postgresql-x.x-p

Re: [postgis-users] [GENERAL] postgis in postgresql apt and upgrades

2014-02-20 Thread Willy-Bas Loos
On Thu, Feb 20, 2014 at 4:57 PM, Rémi Cura wrote: > could you please explain what you mean by "Congrats on the availability of > postgis in de postgresql apt reporsitory"? > It would be very great, > but I can't find postgis package in > http://apt.postgresql.org/pub/repos/apt/dists/ > Is this w

[postgis-users][GENERAL] postgis in postgresql apt and upgrades

2014-02-20 Thread Willy-Bas Loos
Hi, Congrats on the availability of postgis in de postgresql apt reporsitory, this is great work! I have one question about versions and upgrade sof postgis. Since the package names are equal to those in debian and ubuntu (postgresql-x.x-postgis), how will new versions of postgis and upgrades be

Re: [postgis-users] [GENERAL] postgis in postgresql apt and upgrades

2014-02-20 Thread Rémi Cura
Hey, could you please explain what you mean by "Congrats on the availability of postgis in de postgresql apt reporsitory"? It would be very great, but I can't find postgis package in http://apt.postgresql.org/pub/repos/apt/dists/ Thanks, Rémi-C 2014-02-20 16:45 GMT+01:00 Willy-Bas Loos : > Hi,

Re: [GENERAL] [postgis-users] point_ops with GiST PostGIS Spatial Index

2013-06-05 Thread BladeOfLight16
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

Re: [GENERAL] [postgis-users] point_ops with GiST PostGIS Spatial Index

2013-06-05 Thread Tambade, Kedar
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

Re: [GENERAL] [postgis-users] Query with LIMIT but as random result set?

2013-01-11 Thread Gavin Flower
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

Re: [GENERAL] [postgis-users] Query with LIMIT but as random result set?

2013-01-11 Thread Bosco Rama
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

Re: [GENERAL] [postgis-users] Query with LIMIT but as random result set?

2013-01-10 Thread Kevin Grittner
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,

Re: [GENERAL] [postgis-users] Query with LIMIT but as random result set?

2013-01-08 Thread Stefan Keller
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

Re: [GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-30 Thread Craig Ringer
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

Re: [GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-30 Thread Willy-Bas Loos
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

Re: [GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-29 Thread Andres Freund
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

Re: [GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-29 Thread Tom Lane
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

Re: [GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-29 Thread Andres Freund
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

Re: [GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-29 Thread Willy-Bas Loos
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

Re: [GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-29 Thread Andres Freund
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

[GENERAL][postgis-users] pg_dump -s should use add_geometrycolumn(...)

2012-08-29 Thread Willy-Bas Loos
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. Cheers, WBL -- "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

Re: [GENERAL] postgis and pgpool

2012-08-08 Thread gwainer
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

Re: [GENERAL] [postgis-users] ST_AsJpeg

2012-02-16 Thread Stefan Keller
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

Re: [GENERAL] [postgis-users] ST_AsJpeg

2012-02-15 Thread Sandro Santilli
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

Re: [GENERAL] [postgis-users] ST_AsJpeg

2012-02-15 Thread Stefan Keller
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-27 Thread Joshua D. Drake
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-27 Thread Chris Travers
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-27 Thread Martijn van Oosterhout
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-25 Thread Thomas Kellerer
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-25 Thread John R Pierce
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-25 Thread Mark Cave-Ayland
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Craig Ringer
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Thomas Kellerer
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Tomas Vondra
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Pavel Stehule
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread 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 application and require the customer to install Pos

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Pavel Stehule
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Edoardo Panfili
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Adrian Klaver
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread 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 code will not be made open source, but of course the custo

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread Pavel Stehule
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread robert rottermann
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.

Re: [GENERAL] PostGIS in a commercial project

2011-10-24 Thread 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. Is it still OK to use the GPL licensed PostGI

Re: [GENERAL] PostGIS in a commercial project

2011-10-21 Thread Eduardo Morras
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

Re: [GENERAL] PostGIS in a commercial project

2011-10-21 Thread Craig Ringer
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

[GENERAL] PostGIS in a commercial project

2011-10-21 Thread Thomas Kellerer
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 source, but of course the customer will get t

Re: [GENERAL] PostGIS: Approximating a house number from street address range

2011-10-14 Thread Andy Colson
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

Re: [GENERAL] PostGIS: Approximating a house number from street address range

2011-10-13 Thread René Fournier
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

Re: [GENERAL] PostGIS: Approximating a house number from street address range

2011-10-12 Thread Andy Colson
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

Re: [GENERAL] PostGIS: Approximating a house number from street address range

2011-10-12 Thread Andy Colson
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

Re: [GENERAL] PostGIS: Approximating a house number from street address range

2011-10-12 Thread Andy Colson
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

Re: [GENERAL] PostGIS: Approximating a house number from street address range

2011-10-12 Thread Andy Colson
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

[GENERAL] PostGIS: Approximating a house number from street address range

2011-10-12 Thread René Fournier
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 way to programmatically approximate the nearest h

Re: [GENERAL] [postgis-users] Query slow down, never completes

2011-10-12 Thread Andreas Forø Tollefsen
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

Re: [GENERAL] [postgis-users] Query slow down, never completes

2011-10-11 Thread Sandro Santilli
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

Re: [GENERAL] [postgis-users] Query slow down, never completes

2011-10-11 Thread Andreas Forø Tollefsen
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.

Re: [GENERAL] [postgis-users] Query slow down, never completes

2011-10-11 Thread Sandro Santilli
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

Re: [GENERAL] postgis and pgpool

2011-09-19 Thread Szymon Guz
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

Re: [GENERAL] postgis and pgpool

2011-09-19 Thread Tatsuo Ishii
> 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

[GENERAL] postgis and pgpool

2011-09-19 Thread Szymon Guz
Hi, do you know about any problems with using pgpool and postgis together? regards Szymon

Re: [GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-08 Thread Paul Ramsey
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.

Re: [GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-07 Thread Edoardo Panfili
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

Re: [GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-07 Thread Paul Ramsey
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

Re: [GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-07 Thread Paul Ramsey
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

Re: [GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-07 Thread akp geek
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

Re: [GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-07 Thread akp geek
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 - > >

Re: [GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-07 Thread Paul Ramsey
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

[GENERAL] postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests

2011-02-07 Thread akp geek
Hi All - I am trying to install postgis 1.5.2 on solaris10. When I run the configure I get the following. *configure: WARNING: could not locate CUnit required for liblwgeom unit tests* is there some setting I need to do to make it work? $./configure --prefix=/opt/postgr

Re: [GENERAL] Postgis error

2011-01-17 Thread Ludwig Kniprath
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

Re: [GENERAL] Postgis error

2011-01-17 Thread Tom Lane
=?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

Re: [GENERAL] Postgis error

2011-01-17 Thread Frank Heikens
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

[GENERAL] Postgis error

2011-01-17 Thread Plata Martínez, Álvaro (KNMI)
Hi, 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 not exist I supposed that installing postgis I would get the geographical object

Re: [GENERAL] PostGIS return multiple points

2010-10-28 Thread Szymon Guz
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

Re: [GENERAL] PostGIS return multiple points

2010-10-28 Thread ludwig
: 28.10.10 10:00 Uhr An: pgsql-general@postgresql.org Betreff: [GENERAL] PostGIS return multiple points 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

Re: [GENERAL] PostGIS return multiple points

2010-10-28 Thread maarten
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

[GENERAL] PostGIS return multiple points

2010-10-28 Thread trevor1940
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 $LAT $LONG are perl varables So how can i do this if iI have

[GENERAL] Postgis Availability on Website or Cloud?

2010-04-17 Thread Bob Pawley
Hi I am developing a PostgreSQL/PostGIS application (Geometric not Geographic). I want to have the database on the web with a desktop user interface and viewer. The usual method is to install a PostgreSQL server on a website and go from there. However, seeking a more flexible approach, I woul

Re: [GENERAL] [postgis-users] pgsql2shp : Encoding headache

2009-10-16 Thread InterRob
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 >

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-21 Thread John Smith
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

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-21 Thread Andrej Ricnik-Bay
-8<8<8<SNIP8<8<8<8< Message-ID: <[EMAIL PROTECTED]> Date: Thu, 20 Mar 2008 14:02:12 -0400 From: "John Smith" <[EMAIL PROTECTED]> To: "PostgreSQL General" Subject: [GENERAL] [postgis-users]

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-21 Thread John Smith
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

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-21 Thread Colin Wetherbee
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

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-21 Thread John Smith
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:

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-20 Thread Andrej Ricnik-Bay
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

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-20 Thread Colin Wetherbee
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

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-20 Thread Sam Mason
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

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-20 Thread Stephen Woodbridge
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

Re: [GENERAL] [postgis-users] how many min. floating-points?

2008-03-20 Thread Colin Wetherbee
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

[GENERAL] [postgis-users] how many min. floating-points?

2008-03-20 Thread John Smith
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 -- Sent via pgsql-general

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Sandeep Kumar Jakkaraju
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

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Paul Ramsey
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

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Sandeep Kumar Jakkaraju
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...

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Paul Ramsey
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

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Joshua D. Drake
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 > > >

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Sandeep Kumar Jakkaraju
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

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Devrim GUNDUZ
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. :(

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Sandeep Kumar Jakkaraju
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

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-04 Thread Devrim GUNDUZ
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

  1   2   >