Re: [postgis-users] Dot Density idea

2011-05-27 Thread John Abraham
Just to follow up on this, here is the code we (Abdel-Rahman M. Muhsen and I) finally got around to writing. We found a function called randompoint which just creates random points within the bounding box of the geometry from Alexandre Sorokine.

Re: [postgis-users] Dot Density idea

2011-05-27 Thread strk
On Fri, May 27, 2011 at 10:53:58AM -0600, John Abraham wrote: create or replace view dot_cnt as select the_geom, polygon_id, (quantity_column/100)::integer as numpoints from original_data; select dot_density('dot_cnt', 'the_geom', 'polygon_id', 'numpoints'); alter table dp

Re: [postgis-users] Dot Density idea

2010-06-15 Thread Martin Davis
AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job

Re: [postgis-users] Dot Density idea

2010-06-14 Thread Francis Markham
- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Martin Davis Sent: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I

Re: [postgis-users] Dot Density idea

2010-05-09 Thread Andrew Sheedy
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Martin Davis Sent: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote

Re: [postgis-users] Dot Density idea

2010-05-08 Thread Jan Hartmann
Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk

Re: [postgis-users] Dot Density idea

2010-05-07 Thread Ben Madin
: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Martin Davis Sent: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking

Re: [postgis-users] Dot Density idea

2010-05-06 Thread strk
On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote: One of the things I miss about using ESRI's GIS is the ability to do dot-density maps. Within a polygon, the number of dots is proportional to a value, and the dots are randomly placed. I find it useful to be able to present

Re: [postgis-users] Dot Density idea

2010-05-06 Thread strk
ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote: One of the things I miss about using ESRI's GIS is the ability to do dot-density maps. Within a

Re: [postgis-users] Dot Density idea

2010-05-06 Thread David Fawcett
Not quite the same, but Carson Farmer's fTools plugins for QGIS include the functionality to create random points (by count or density) inside of a polygon. http://www.ftools.ca/plugins.html Nothing specific about this functionality on this page, you need to look at the actual plugins in QGIS.

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Ben Madin
I have used an R function before (using maptools package) to do something similar, but I can't remember the details, so I would be considering looking at PL/R. cheers Ben On 06/05/2010, at 15:40 , strk wrote: On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote: One of the things

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Martin Davis
I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote: One of the things I miss about using ESRI's GIS is the

Re: [postgis-users] Dot Density idea

2010-05-06 Thread George Silva
Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Martin Davis
-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Martin Davis Sent: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing

Re: [postgis-users] Dot Density idea

2010-05-06 Thread George Silva
: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Paul Ramsey
; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Jan Hartmann
: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Martin Davis
: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Martin Davis
06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good

Re: [postgis-users] Dot Density idea

2010-05-06 Thread David William Bitner
: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Martin Davis Sent: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Jan Hartmann
Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting

Re: [postgis-users] Dot Density idea

2010-05-06 Thread David Fawcett
Doesn't OpenSource suck!!! On Mon, May 3, 2010 at 11:49 PM, John Abraham jabra...@ucalgary.ca wrote: One of the things I miss about using ESRI's GIS is the ability to do dot-density maps.  Within a polygon, the number of dots is An then an hour later...

Re: [postgis-users] Dot Density idea

2010-05-06 Thread George Silva
Yea, this is very cool indeed. George On Thu, May 6, 2010 at 3:33 PM, David Fawcett david.fawc...@gmail.comwrote: Doesn't OpenSource suck!!! On Mon, May 3, 2010 at 11:49 PM, John Abraham jabra...@ucalgary.ca wrote: One of the things I miss about using ESRI's GIS is the ability to do

Re: [postgis-users] Dot Density idea

2010-05-06 Thread pcreso
Davis mbda...@refractions.net wrote: From: Martin Davis mbda...@refractions.net Subject: Re: [postgis-users] Dot Density idea To: PostGIS Users Discussion postgis-users@postgis.refractions.net Date: Friday, May 7, 2010, 5:50 AM Did your algorithm work with irregular polgon extents? Jan

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Norman Vine
...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Martin Davis Sent: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Martin Davis
@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote: ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Martin Davis
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Martin Davis Sent: Thursday, May 06, 2010 8:56 AM To: John Abraham; postgis-users@postgis.refractions.net; Martin Davis Subject: Re: [postgis-users] Dot Density idea I was thinking the same thing! strk wrote

[postgis-users] Dot Density idea

2010-05-03 Thread John Abraham
One of the things I miss about using ESRI's GIS is the ability to do dot-density maps. Within a polygon, the number of dots is proportional to a value, and the dots are randomly placed. I find it useful to be able to present several data values at once (e.g. blue dots for population, red dots