[postgis-users] postgis-users Digest, Vol 122, Issue 30
Nicolas Ribot
nicolas.ribot at gmail.com
Tue May 1 05:21:58 PDT 2012
Go to postgis sources/java
make
Jar file will be generated at java/jdbc/target/
Nicolas
On 30 April 2012 22:04, Brian Sanjeewa Rupasinghe <jinkabs at gmail.com> wrote:
> How to build PostGIS 2.0 jar file from SVN. Any instructions?
> On Mon, Apr 30, 2012 at 8:00 PM,
> <postgis-users-request at postgis.refractions.net> wrote:
>>
>> Send postgis-users mailing list submissions to
>> postgis-users at postgis.refractions.net
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> or, via email, send a message with subject or body 'help' to
>> postgis-users-request at postgis.refractions.net
>>
>> You can reach the person managing the list at
>> postgis-users-owner at postgis.refractions.net
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of postgis-users digest..."
>>
>>
>> Today's Topics:
>>
>> 1. Re: options to scaleout POSTGIS DATABASE (Robert Coup)
>> 2. Re: Topology GetRingEdges (Sandro Santilli)
>> 3. Changing band pixel type (George Washington)
>> 4. Re: Changing band pixel type (Pierre Racine)
>> 5. PostGIS 2.0 connection to Java (Brian Sanjeewa Rupasinghe)
>> 6. Re: PostGIS 2.0 connection to Java (Skye Book)
>> 7. Re: Topology GetRingEdges (Bob Pawley)
>> 8. Nearest Neighbor problem using GIST Index (<-> function)
>> (Alexandre Neto)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Mon, 30 Apr 2012 11:40:03 +1200
>> From: Robert Coup <robert.coup at onetrackmind.co.nz>
>> Subject: Re: [postgis-users] options to scaleout POSTGIS DATABASE
>> To: Greg Williamson <gwilliamson39 at yahoo.com>, PostGIS Users
>> Discussion <postgis-users at postgis.refractions.net>
>> Message-ID:
>>
>> <CAFLLRp+KuB3zf-VPfZUg4KnMaszy9vP12hJvL34dQ+vqpjgJWg at mail.gmail.com>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> On Mon, Apr 30, 2012 at 5:00 AM, Greg Williamson
>> <gwilliamson39 at yahoo.com>wrote:
>>
>> >
>> > There is no automatic switchover as far as I know in the streaming
>> > replication -- you have to have identify that there is a failure and
>> > intervene; the switch of a server from standby mode to active is quite
>> > fast
>> > in and of itself. Making outside systems award of the new server is
>> > trickier -- perhaps having a VIP which is the connection point to the
>> > outside world, then swap what the VIP points to when you failover to the
>> > backup server.
>> >
>>
>> A shared-IP & Pacemaker/etc is one option.
>>
>> PgBouncer provides a connection pool across a set of replicas and deals
>> with simple health checks - it's straightforward to setup
>>
>> Rob :)
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120430/634dbeb7/attachment-0001.html>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Mon, 30 Apr 2012 11:51:12 +0200
>> From: Sandro Santilli <strk at keybit.net>
>> Subject: Re: [postgis-users] Topology GetRingEdges
>> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>> Message-ID: <20120430095112.GB4927 at gnash>
>> Content-Type: text/plain; charset=us-ascii
>>
>> On Fri, Apr 27, 2012 at 01:11:27PM -0700, Bob Pawley wrote:
>> > Hi
>> >
>> > I have established the schema and tables as outlined in the
>> > documentation example 11.8 TopoGeometry Constructors.
>> >
>> > However, I am still missing something.
>> >
>> > When I run GetRingEdges -
>> >
>> > select topology.GetRingEdges('TEST', 1), entities.wkb_geometry
>> > from entities, num_search
>> > where st_intersects(entities.wkb_geometry, num_search.the_geom2);
>> >
>> > The return are only the geometries which are actually intersected by
>> > st_intersects.(In this particular case only four of the eight lines that
>> > make up the polygon).
>> >
>> > I was hoping the whole closed geometry to be returned.
>> >
>> > What am I missing??
>>
>> I don't understand what your query above is trying to select.
>> You are calling GetRingEdges with a constant edge id, why so ?
>>
>> --strk;
>>
>> ,------o-.
>> | __/ | Delivering high quality PostGIS 2.0 !
>> | / 2.0 | http://strk.keybit.net - http://vizzuality.com
>> `-o------'
>>
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Mon, 30 Apr 2012 11:33:00 +0000
>> From: George Washington <gws293 at hotmail.com>
>> Subject: [postgis-users] Changing band pixel type
>> To: <postgis-users at postgis.refractions.net>
>> Message-ID: <COL116-W52A0945287A4104E0F512494280 at phx.gbl>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>>
>> Hi, I imported a raster image in postgis 2.0 (Win 7) and it shows a pixel
>> type of 32BF, an overkill for my needs.Is there a way of changing the pixel
>> type to, say, 8BUI or 16BUI? I found st_bandpixeltype to access the type,
>> but not yet a way to set it.Many thanks
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120430/0b2b5d8e/attachment-0001.html>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Mon, 30 Apr 2012 09:33:56 -0400
>> From: Pierre Racine <Pierre.Racine at sbf.ulaval.ca>
>> Subject: Re: [postgis-users] Changing band pixel type
>> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>> Message-ID:
>> <87A96661E65C5541AB4D20721C2DD7F8CFBB49DD56 at EXCH-MBX-A.ulaval.ca>
>> Content-Type: text/plain; charset="us-ascii"
>>
>> CREATE TABLE newrasttable AS
>> SELECT ST_MapAlgebraExpr(rast, '8BUI', '[rast]') rast
>> FROM oldrasttable
>>
>> Pierre
>>
>> > -----Original Message-----
>> > From: postgis-users-bounces at postgis.refractions.net
>> > [mailto:postgis-users-
>> > bounces at postgis.refractions.net] On Behalf Of George Washington
>> > Sent: Monday, April 30, 2012 7:33 AM
>> > To: postgis-users at postgis.refractions.net
>> > Subject: [postgis-users] Changing band pixel type
>> >
>> > Hi, I imported a raster image in postgis 2.0 (Win 7) and it shows a
>> > pixel type of
>> > 32BF, an overkill for my needs.
>> > Is there a way of changing the pixel type to, say, 8BUI or 16BUI? I
>> > found
>> > st_bandpixeltype to access the type, but not yet a way to set it.
>> > Many thanks
>> >
>>
>>
>>
>> ------------------------------
>>
>> Message: 5
>> Date: Mon, 30 Apr 2012 16:10:37 +0100
>> From: Brian Sanjeewa Rupasinghe <jinkabs at gmail.com>
>> Subject: [postgis-users] PostGIS 2.0 connection to Java
>> To: postgis-users at postgis.refractions.net
>> Message-ID:
>>
>> <CAEMA-4guTkR43en_pnVu9PBBMNvx6F0qjtRMLJnkGPqTdcDNOg at mail.gmail.com>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> Hi,
>>
>> Where can i find postgis 2.0.jar file to connect postGIS with Java. Link
>> in
>> the PostGIS site is broken.
>>
>> Brian.
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120430/76ed821f/attachment-0001.html>
>>
>> ------------------------------
>>
>> Message: 6
>> Date: Mon, 30 Apr 2012 11:25:59 -0400
>> From: Skye Book <skye.book at gmail.com>
>> Subject: Re: [postgis-users] PostGIS 2.0 connection to Java
>> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>> Message-ID:
>>
>> <CAA2EaMqmcFABkLdomXpDrdbfEOMenoO6GQx8i8K7MkWw5SNfbw at mail.gmail.com>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> I've been building the driver from SVN, it's worked out fine for me.
>> On Apr 30, 2012 11:10 AM, "Brian Sanjeewa Rupasinghe" <jinkabs at gmail.com>
>> wrote:
>>
>> > Hi,
>> >
>> > Where can i find postgis 2.0.jar file to connect postGIS with Java. Link
>> > in the PostGIS site is broken.
>> >
>> > Brian.
>> >
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users at postgis.refractions.net
>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120430/f2c22ed1/attachment-0001.html>
>>
>> ------------------------------
>>
>> Message: 7
>> Date: Mon, 30 Apr 2012 08:30:56 -0700
>> From: "Bob Pawley" <rjpawley at shaw.ca>
>> Subject: Re: [postgis-users] Topology GetRingEdges
>> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
>> Message-ID: <88A01C8872BB49C3A97B7403B7DB59F3 at BobPC>
>> Content-Type: text/plain; format=flowed; charset="iso-8859-1";
>> reply-type=original
>>
>> Well, it would seem to me that I need to identify the geometry at some
>> point
>> as a start (and end) for "walking" the geom, hence, the ST_Intersects.
>>
>> I've attempted to use the geom column in the edge_data table but so far
>> haven't been able to make this work (errors returned) -
>>
>> select topology.getringedges(edge_data, 1), entities.wkb_geometry
>> from "TEST".edge_data, entities
>> where "TEST".edge_data.edge_id = 1
>>
>> So far, this is the only combination that I can make work.
>>
>> My problem may be that I am confused on the atopology varchar for which
>> the
>> GetRingEdge is looking, if it isn't the geom of table edge_data.
>>
>> And I am also wondering why the TEST schema produced by toTopoGeom
>> requires
>> double quotes in order to be recognized?
>>
>> Or am I entirely missing the point?
>>
>> Bob
>>
>> -----Original Message-----
>> From: Sandro Santilli
>> Sent: Monday, April 30, 2012 2:51 AM
>> To: PostGIS Users Discussion
>> Subject: Re: [postgis-users] Topology GetRingEdges
>>
>> On Fri, Apr 27, 2012 at 01:11:27PM -0700, Bob Pawley wrote:
>> > Hi
>> >
>> > I have established the schema and tables as outlined in the
>> > documentation
>> > example 11.8 TopoGeometry Constructors.
>> >
>> > However, I am still missing something.
>> >
>> > When I run GetRingEdges -
>> >
>> > select topology.GetRingEdges('TEST', 1), entities.wkb_geometry
>> > from entities, num_search
>> > where st_intersects(entities.wkb_geometry, num_search.the_geom2);
>> >
>> > The return are only the geometries which are actually intersected by
>> > st_intersects.(In this particular case only four of the eight lines that
>> > make up the polygon).
>> >
>> > I was hoping the whole closed geometry to be returned.
>> >
>> > What am I missing??
>>
>> I don't understand what your query above is trying to select.
>> You are calling GetRingEdges with a constant edge id, why so ?
>>
>> --strk;
>>
>> ,------o-.
>> | __/ | Delivering high quality PostGIS 2.0 !
>> | / 2.0 | http://strk.keybit.net - http://vizzuality.com
>> `-o------'
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>> ------------------------------
>>
>> Message: 8
>> Date: Mon, 30 Apr 2012 16:49:47 +0100
>> From: Alexandre Neto <senhor.neto at gmail.com>
>> Subject: [postgis-users] Nearest Neighbor problem using GIST Index
>> (<-> function)
>> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>> Message-ID:
>>
>> <CA+H0G_Gkkf4B4N-w9PdZysLJAAW3C+0pO_nKeQe+_Tg6py58AQ at mail.gmail.com>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> I'm trying to use Postgis 2.0 new function <-> (Geometry Distance
>>
>> Centroid<http://postgis.refractions.net/docs/geometry_distance_centroid.html>)
>> in order to calculate, for each row of my table (cosn1), the distance to
>> the nearest polygon of the same class.
>>
>> I was trying to use the following code:
>>
>> WITH index_query AS (
>> SELECT g1.gid As ref_gid, ST_Distance(g1.the_geom,g2.the_geom) As ENN
>> FROM "cosn1" As g1, "cosn1" As g2
>> WHERE g1.gid <> g2.gid AND g1.class = g2.class
>> ORDER BY g1.gid, g1.the_geom <-> g2.the_geom)
>> SELECT DISTINCT ON (ref_gid) ref_gid, ENN
>> FROM index_query
>> ORDER BY ref_gid, ENN;
>>
>> But then I realize the warning:
>>
>>
>> Note: Index only kicks in if one of the geometries is a constant (not in a
>> subquery/cte). e.g. 'SRID=3005;POINT(1011102 450541)'::geometry instead of
>> a.geom
>>
>> Meaning that the Index wont be used at all, and the query will take almost
>> the same time as before using:
>>
>> SELECT DISTINCT ON(g1.gid) g1.gid As ref_gid,
>> ST_Distance(g1.the_geom,g2.the_geom) As ENN
>> FROM "cosn1" As g1, "cosn1" As g2
>> WHERE g1.gid <> g2.gid AND g1.class = g2.class
>> ORDER BY g1.gid, ST_Distance(g1.the_geom,g2.the_geom)
>>
>> Can anyone point me a workaround that allows me to improve performance of
>> my query?
>>
>> Thank you very much.
>>
>> Alexandre Neto
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120430/a950e2ed/attachment-0001.html>
>>
>> ------------------------------
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>> End of postgis-users Digest, Vol 122, Issue 30
>> **********************************************
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
More information about the postgis-users
mailing list