[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] postgis-users Digest, Vol 122, Issue 30
From: Brian Sanjeewa Rupasinghe <jinkabs () gmail ! com>
Date: 2012-04-30 20:04:18
Message-ID: CAEMA-4gtAXjOph-k-dy5tdJ7DaembCszWepigDYdoxbd27LqUQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
How to build PostGIS 2.0 jar file from SVN. Any instructions?
On Mon, Apr 30, 2012 at 8:00 PM, <
postgis-users-request@postgis.refractions.net> wrote:
> Send postgis-users mailing list submissions to
> postgis-users@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@postgis.refractions.net
>
> You can reach the person managing the list at
> postgis-users-owner@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@onetrackmind.co.nz>
> Subject: Re: [postgis-users] options to scaleout POSTGIS DATABASE
> To: Greg Williamson <gwilliamson39@yahoo.com>, PostGIS Users
> Discussion <postgis-users@postgis.refractions.net>
> Message-ID:
> <CAFLLRp+KuB3zf-VPfZUg4KnMaszy9vP12hJvL34dQ+vqpjgJWg@mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Mon, Apr 30, 2012 at 5:00 AM, Greg Williamson <gwilliamson39@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@keybit.net>
> Subject: Re: [postgis-users] Topology GetRingEdges
> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net>
> Message-ID: <20120430095112.GB4927@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@hotmail.com>
> Subject: [postgis-users] Changing band pixel type
> To: <postgis-users@postgis.refractions.net>
> Message-ID: <COL116-W52A0945287A4104E0F512494280@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@sbf.ulaval.ca>
> Subject: Re: [postgis-users] Changing band pixel type
> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net>
> Message-ID:
> <87A96661E65C5541AB4D20721C2DD7F8CFBB49DD56@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@postgis.refractions.net [mailto:
> postgis-users-
> > bounces@postgis.refractions.net] On Behalf Of George Washington
> > Sent: Monday, April 30, 2012 7:33 AM
> > To: postgis-users@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@gmail.com>
> Subject: [postgis-users] PostGIS 2.0 connection to Java
> To: postgis-users@postgis.refractions.net
> Message-ID:
> <CAEMA-4guTkR43en_pnVu9PBBMNvx6F0qjtRMLJnkGPqTdcDNOg@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@gmail.com>
> Subject: Re: [postgis-users] PostGIS 2.0 connection to Java
> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net>
> Message-ID:
> <CAA2EaMqmcFABkLdomXpDrdbfEOMenoO6GQx8i8K7MkWw5SNfbw@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@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@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@shaw.ca>
> Subject: Re: [postgis-users] Topology GetRingEdges
> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net>
> Message-ID: <88A01C8872BB49C3A97B7403B7DB59F3@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@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@gmail.com>
> Subject: [postgis-users] Nearest Neighbor problem using GIST Index
> (<-> function)
> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net>
> Message-ID:
> <CA+H0G_Gkkf4B4N-w9PdZysLJAAW3C+0pO_nKeQe+_Tg6py58AQ@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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> End of postgis-users Digest, Vol 122, Issue 30
> **********************************************
>
[Attachment #5 (text/html)]
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@ma \
il.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.ulav \
al.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.g \
mail.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.g \
mail.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>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic