Re: [postgis-users] Size of a multipolygon

[pcreso]

Hey Ben,

How goes it?

Does 
http://postgis.refractions.net/documentation/manual-1.5/ST_NumGeometries.html
do what you want?

& FYI, I was interested in this post, as a PL/R user it may interest you as 
well?

http://www.spatialdbadvisor.com/postgis_tips_tricks/290/r-based-delaunay-triangulation-function-for-postgis-using-the-deldir-package
 

Cheers,

  Brent


--- On Wed, 5/2/12, Ben Madin  wrote:

From: Ben Madin 
Subject: [postgis-users] Size of a multipolygon
To: "PostGIS Users Discussion" 
Date: Wednesday, May 2, 2012, 3:26 PM

Hello all,

I'm sure the answer is simple, but I'm lost on what to search on - I need to 
quickly search through several thousand multi polygons for any which have more 
than one part making them up. 

What is the best way to do this…? (I've tried array_length(), but don't seem to 
be able to feed it the right part. I can't believe I can't find a function that 
does it… or am I looking at dumping the multi polygons into a new table and 
counting the number of lines for each one...

cheers

Ben


___
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

Re: [postgis-users] Size of a multipolygon

[Stephen Woodbridge]

http://www.postgis.org/documentation/manual-1.5/ST_NumGeometries.html

On 5/1/2012 11:26 PM, Ben Madin wrote:

Hello all,

I'm sure the answer is simple, but I'm lost on what to search on - I
need to quickly search through several thousand multi polygons for
any which have more than one part making them up.

What is the best way to do this…? (I've tried array_length(), but
don't seem to be able to feed it the right part. I can't believe I
can't find a function that does it… or am I looking at dumping the
multi polygons into a new table and counting the number of lines for
each one...

cheers

Ben


___ 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

[postgis-users] Size of a multipolygon

[Ben Madin]

Hello all,

I'm sure the answer is simple, but I'm lost on what to search on - I need to 
quickly search through several thousand multi polygons for any which have more 
than one part making them up. 

What is the best way to do this…? (I've tried array_length(), but don't seem to 
be able to feed it the right part. I can't believe I can't find a function that 
does it… or am I looking at dumping the multi polygons into a new table and 
counting the number of lines for each one...

cheers

Ben


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2.0 instalation problem

[wobo]

Hi all,

I'm a newbie student, just finished reading 'Postgis in action' and now
trying to get PostGIS2.0 up and running for the first time. Now I'm
suffering a similar problem in setup like the one mentioned earlier in this
thread.

Using Windows XP SP3 I was able to install the latest PostgreSQl 9.1.3
stable version. Trying to install PostGIS 2.0 with the one-click installer
fails during makepostgisdb.bat (CREATE EXTENSION postgis;): 
ERROR:  could not load library "C:/Program
Files/PostgreSQL/9.1/lib/postgis-2.0.dll": unknown error 998

I tried several approaches (restarting, copying by hand, renaming, etc) as
mentioned in similar other threads but nothing succeeded so far. All the
important files seem to be in the right place. It seemed some needed
dependencies first were missing (LIBGEOS, LIBXML2-2, POSTGRES, LIBPROJ-0) so
I added the PGBIN to the environment variable. 

After restart Dependency Walker now finds these mentioned files but there
are still dependency errors on IESHIMS.dll and WER.dll. I read that these
are unnecessary/unused in Windows Xp. Does this imply that it is impossible
to install PostGIS2.0 on Windows XP? Before there were a lot of errors but
now the pg_log file only throws the "could not load library postgis-2.0"
error line like:

2012-05-02 00:25:05 CEST LOG:  database system was shut down at 2012-05-01
23:26:44 CEST
2012-05-02 00:25:06 CEST LOG:  database system is ready to accept
connections
2012-05-02 00:25:06 CEST LOG:  autovacuum launcher started
2012-05-02 00:25:30 CEST ERROR:  could not load library "C:/Program
Files/PostgreSQL/9.1/lib/postgis-2.0.dll": unknown error 998
2012-05-02 00:25:30 CEST STATEMENT:  CREATE EXTENSION postgis;
2012-05-02 00:25:30 CEST ERROR:  required extension "postgis" is not
installed
2012-05-02 00:25:30 CEST STATEMENT:  CREATE EXTENSION postgis_topology;

I have no clue how to proceed from here... Any suggestions? 

Thanks in advance,
Wouter

--
View this message in context: 
http://postgis.17.n6.nabble.com/PostGIS-2-0-instalation-problem-tp4624902p4944746.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] postgis-users Digest, Vol 122, Issue 30

[Nicolas Ribot]

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  wrote:
> How to build PostGIS 2.0 jar file from SVN. Any instructions?
> On Mon, Apr 30, 2012 at 8:00 PM,
>  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 
>> Subject: Re: [postgis-users] options to scaleout POSTGIS DATABASE
>> To: Greg Williamson ,  PostGIS Users
>>        Discussion 
>> Message-ID:
>>
>>  
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> On Mon, Apr 30, 2012 at 5:00 AM, Greg Williamson
>> 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:
>> 
>>
>> --
>>
>> Message: 2
>> Date: Mon, 30 Apr 2012 11:51:12 +0200
>> From: Sandro Santilli 
>> Subject: Re: [postgis-users] Topology GetRingEdges
>> To: PostGIS Users Discussion 
>> 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 +
>> From: George Washington 
>> Subject: [postgis-users] Changing band pixel type
>> To: 
>> Message-ID: 
>> 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:
>> 
>>
>> --
>>
>> Message: 4
>> Date: Mon, 30 Apr 2012 09:33:56 -0400
>> From: Pierre Racine 
>> Subject: Re: [postgis-users] Changing band pixel type
>> To: PostGIS Users Discussion 
>> Message-ID:
>> 

Re: [postgis-users] PostGIS 2.0 connection to Java

[Nicolas Ribot]

You can find a cached copy here:

http://www.java2s.com/Code/Jar/p/Downloadpostgis200SVNjar.htm

Nicolas

On 30 April 2012 17:10, Brian Sanjeewa Rupasinghe  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
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users