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 <jink...@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-requ...@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-requ...@postgis.refractions.net >> >> You can reach the person managing the list at >> postgis-users-ow...@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.c...@onetrackmind.co.nz> >> Subject: Re: [postgis-users] options to scaleout POSTGIS DATABASE >> To: Greg Williamson <gwilliamso...@yahoo.com>, PostGIS Users >> Discussion <postgis-users@postgis.refractions.net> >> Message-ID: >> >> <cafllrp+kub3zf-vpfzug4knmaszy9vp12hjvl34dq+vqpjg...@mail.gmail.com> >> Content-Type: text/plain; charset="iso-8859-1" >> >> On Mon, Apr 30, 2012 at 5:00 AM, Greg Williamson >> <gwilliamso...@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 <s...@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 <gws...@hotmail.com> >> Subject: [postgis-users] Changing band pixel type >> To: <postgis-users@postgis.refractions.net> >> Message-ID: <col116-w52a0945287a4104e0f512494...@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.rac...@sbf.ulaval.ca> >> Subject: Re: [postgis-users] Changing band pixel type >> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net> >> Message-ID: >> <87a96661e65c5541ab4d20721c2dd7f8cfbb49d...@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-boun...@postgis.refractions.net >> > [mailto:postgis-users- >> > boun...@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 <jink...@gmail.com> >> Subject: [postgis-users] PostGIS 2.0 connection to Java >> To: postgis-users@postgis.refractions.net >> Message-ID: >> >> <caema-4gutkr43en_pnvu9pbbmnvx6f0qjtrmljnkgpqtdcd...@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.b...@gmail.com> >> Subject: Re: [postgis-users] PostGIS 2.0 connection to Java >> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net> >> Message-ID: >> >> <caa2eamqmcfabkldomxpdrdbfeomenoo6gqx8i8k7mkww5sn...@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" <jink...@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" <rjpaw...@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.n...@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+_tg6py5...@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 >> ********************************************** > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users