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