Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread Doug_Newcomb
>Thanks for the reference Doug. What you suggest does sound like it could >work, the only thing is that >I would need to have this output as a Raster as I am then looking to use it >with two other rasters >to do a weighted combination of them e.g. [rast1 * 0.2] + [rast2 * 0.5] + ?[rast3 * 0.3].

Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread Doug_Newcomb
James, Looking at - http://webhelp.esri.com/arcgiSDEsktop/9.3/index.cfm?TopicName=How%20Point%20Density%20works . Why not convert the raster cell centers to points , do a query on the point layer for a square centered on the raster derived point whose dimensions are given by the numbe

Re: [postgis-users] Rv: Postgis for Postgres 64 bits

2012-02-24 Thread Doug_Newcomb
Discussions on 32 bit vs 64 bit Postgresql: http://archives.postgresql.org/pgsql-performance/2004-11/msg00201.php http://postgresql.1045698.n5.nabble.com/64-bit-vs-32-bit-performance-backwards-td2057238.html See document on 5 steps to postgresql performance by Josh Berkus: http://www.pgexperts.

Re: [postgis-users] When will the PostGIS 2.0 be released?

2011-10-25 Thread Doug_Newcomb
When you use the windows installer for 9.1, it gives you the option of installing 1.5.3 in the stackbuilder followup. I'n theory, that's what I just did on my winxp box :-). Doug Doug Newcomb USFWS Raleigh, NC 919-856-4520 ext. 14 doug_newc...@fws.gov

Re: [postgis-users] FOSS4G meeting

2011-09-12 Thread Doug_Newcomb
Apologies to the list. Please disregard. Doug Doug Newcomb USFWS Raleigh, NC 919-856-4520 ext. 14 doug_newc...@fws.gov - The opinions I express are my own and are not representative of the

[postgis-users] FOSS4G meeting

2011-09-12 Thread Doug_Newcomb
Paul, Just a question about the meeting at 2:30 on Wed. Do you have a location yet? Doug Doug Newcomb USFWS Raleigh, NC 919-856-4520 ext. 14 doug_newc...@fws.gov - The opinions I e

Re: [postgis-users] Centroid 'Within'

2011-06-22 Thread Doug_Newcomb
Sheara, That would depend on the shape of the polygon. A polygon in the shape of a "C" would have a centroid point inside the curve of the "C", but not inside the polygon. Perhaps you want to find the centroid first and then find the closest point on the polygon boundary to that point

Re: [postgis-users] Coordinates and SRID - bound overflow, ST_Equals

2011-01-20 Thread Doug_Newcomb
>Doug, >There are cases where we need to use a difference branch of longitude values, e.g. 0 to 360, rather than -180 to 180. For example, if one has a polygon that spans the international dateline, >and one uses longitude from -180 to 180, some vertices of the polygon will have longitudes ne

Re: [postgis-users] Coordinates and SRID - bound overflow, ST_Equals

2011-01-20 Thread Doug_Newcomb
Radu, I am somewhat confused. From my somewhat limited understanding of EPSG:4326 it's limited to values between 180, -180 for longitude and 90,-90 for latitude. If your source geometry is epsg:4326, there should not be values outside of those limits. Are you wrapping around those li

Re: [postgis-users] Coordinates and SRID - bound overflow, ST_Equals

2011-01-20 Thread Doug_Newcomb
Balint Would using the geography data type be more suitable to what you are trying to accomplish? http://postgis.refractions.net/docs/ch04.html#PostGIS_GeographyVSGeometry Doug Newcomb USFWS Raleigh, NC 919-856-4520 ext. 14 doug_newc...@fws.gov ---

Re: [postgis-users] db documentation software

2010-07-02 Thread Doug_Newcomb
>> Hi, >> I'm working on a complex PostgreSQL / Postgis-Database with > 200 tables. >> At this time there is no good documentation for the database so I'm >> searching for a OpenSource / cheap database-documentation software that >> creates the table/field structure and relations/ERdiagram to a op

Re: [postgis-users] transformation discrepancy with postgis v. cs2cs

2010-03-26 Thread Doug_Newcomb
aptitude search "string" Doug Newcomb USFWS Raleigh, NC 919-856-4520 ext. 14 doug_newc...@fws.gov - The opinions I express are my own and are not representative of the official policy of the U

Re: [postgis-users] PostGIS-PostgreSQL

2009-07-13 Thread Doug_Newcomb
I have a postgis dataset that is a series of fish collection trawls with the geometry fields for the endpoints and for the line between the endpoints. It seemed like the easiest way to do analysis on the endpoints separately of the line the endpoints create at the time. Two geometry colums wit

Re: [postgis-users] The Old Who is using PostGIS survey again?

2009-01-02 Thread Doug_Newcomb
Regina, 1) How you use PostGIS? Storage and analysis of fisheries and endangered species data. 2) What you find useful about it over anything else? Fast, Standards Compliant, straightforward 3) Why you think there should be any book written focused on its use and of course if such a thing were t

Re: [postgis-users] What coordinate system should I use?

2008-10-02 Thread Doug_Newcomb
Stephen, Australia encompasses UTM zones 49 to 56, http://www.dmap.co.uk/utmworld.htm . If you tried to use UTM zone 53 for everything you would have EXTREME distortion at the edges. You get noticable distortion when you overlap significantly even into adjoining UTM zones. For an are

Re: [postgis-users] PostGIS / PostgreSQL binaries for RedHat/Itanium II?

2008-01-22 Thread Doug_Newcomb
Dana, From what I recall of the Itanium family of processors, it is a "pure" 64 bit processor which does software emulation of a 32 bit x86 environment for 32 bit x86 binaries. I also remember that the performance of this 32 bit x86 emulation method was somewhat lacking. AMD came out with

Re: [postgis-users] Problem with loading postgis libs

2007-10-11 Thread Doug_Newcomb
Patrick, On Centos, I usually create a local.conf and a pgsql.conf file with a single line for /usr/local/lib and /usr/local/pgsql/lib, respectively. That will take care of most of the gdal/geos/proj/ and associated libraries for the applications that I'm compiling from source. It also allow

Re: [postgis-users] Compile postgis in Ubuntu Feisty

2007-07-12 Thread Doug_Newcomb
Postgresql 8.2.4 + postgis 1.2.1 + geos 3.0 RC4 is working fine on Centos 5 64 bit so far. Doug Doug Newcomb USFWS Raleigh, NC 919-856-4520 ext. 14 [EMAIL PROTECTED] - The opinions I express