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

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]. Do

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:

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

[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

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

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
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] 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

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 near

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 open format

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

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

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] 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