Re: [postgis-users] Perplexed: ST_Intersects with Geography, odd results

2013-02-19 Thread Stephen V. Mather
I've just been following this board long enough to have seen others ask the same. Ah, spherical trig... . Best, Steve On Feb 19, 2013, at 12:07 PM, "Jensen, Layne K CIV SPAWARSYSCEN-PACIFIC, 56210" mailto:layne.jen...@navy.mil>> wrote: Steve, Of course, you're absolutely correct. I knew t

Re: [postgis-users] error running St_MapAlgebraExpr 2 raster version

2013-02-19 Thread Silver Ashen
Thank you very much for the explanations. Indeed, with a St_Value, I can assess that the request worked, but without opening the result in ArcGIS (its plant), this notice message make me doubt. Samy 2013/2/20 dustymugs > The only problem you have in your query is the expression being provided >

Re: [postgis-users] error running St_MapAlgebraExpr 2 raster version

2013-02-19 Thread dustymugs
The only problem you have in your query is the expression being provided to ST_MapAlgebraExpr(). That expression should be: [rast1.val]*[rast2.val] The notice itself can safely be ignored. In the normal use case, your source rasters are tiled into smaller chucks. And between these smaller chuc

[postgis-users] error running St_MapAlgebraExpr 2 raster version

2013-02-19 Thread Silver Ashen
Hello everybody, I'm trying to test the St_MapAlgebraExpr 2 raster version in order to multiply the values of a raster by the values of an other one. Here is the request : SELECT St_MapAlgebraExpr(a.rast,b.rast,'(a.rast*b.rast)::double precision','32BF','INTERSECTION','NULL','NULL',-1) As rast F

Re: [postgis-users] trace back

2013-02-19 Thread Andy Colson
On 2/19/2013 12:35 PM, Jonatan Malaver wrote: Hello, Let's say I have 3 parcel centroids with one feature in common. How would I do a trace back to the common feature between those points? Also, how can I do a flood analysis? Thanks, Jonatan Malaver Assistant Engineer of Electrical and Ca

Re: [postgis-users] trace back

2013-02-19 Thread Jonatan Malaver
Let me give you more info. I'm trying to sync my GIS with our outage management system (small electric utility). I would like to trace back an outage call (customer points) to a common transformer (point), fuse (point), or station (point). All the points are in different tables, and they are all

Re: [postgis-users] trace back

2013-02-19 Thread Andy Colson
On 2/19/2013 12:35 PM, Jonatan Malaver wrote: Hello, Let’s say I have 3 parcel centroids with one feature in common. How would I do a trace back to the common feature between those points? Also, how can I do a flood analysis? Thanks, Jonatan Malaver Assistant Engineer of Electrical and Cab

[postgis-users] trace back

2013-02-19 Thread Jonatan Malaver
Hello, Let's say I have 3 parcel centroids with one feature in common. How would I do a trace back to the common feature between those points? Also, how can I do a flood analysis? Thanks, Jonatan Malaver Assistant Engineer of Electrical and Cable Operations Shrewsbury Electric & Cable Operat

Re: [postgis-users] Perplexed: ST_Intersects with Geography, odd results

2013-02-19 Thread Jensen, Layne K CIV SPAWARSYSCEN-PACIFIC, 56210
Steve, Of course, you're absolutely correct. I knew there had to be a great big "Duh!" in there somewhere, and was prepared to be embarrassed. I hadn't visualized the polygon as a series of great circles. Thank you for bringing me back to reality. Layne From: Stephen V. Mather Sent: Tue

Re: [postgis-users] Perplexed: ST_Intersects with Geography, odd results

2013-02-19 Thread Stephen V. Mather
Having not looked at your particular use case in detail, my guess is it's related to the world not being flat, see e.g.: http://blog.opengeo.org/2012/04/30/the-earth-is-not-flat-volume-2/ Best, Steve [http://sig.cmparks.net/cmp-ms-90x122.png] Stephen V. Mather GIS Manager (216) 635-3243 (Work)

[postgis-users] Perplexed: ST_Intersects with Geography, odd results

2013-02-19 Thread Jensen, Layne K CIV SPAWARSYSCEN-PACIFIC, 56210
We are using PostgreSQL version 9.2.2 with PostGIS 2.0,and need to do simple queries to find points that are within or intersect with a polygon. The following test case returns only partial results for an unknown reason. If the minimum longitude value of the polygon is changed from 0 to 1 to 2 t

[postgis-users] ptarray_area_spheroid: cannot handle ptarray that crosses equator

2013-02-19 Thread Andreas Forø Tollefsen
Hi, I have a problem with my geography type query. The query is set up to calculate the area of every intersection between a regular grid (.5x.5 decimal degrees) and a polygon shapefile for Africa. However, I run into problems. I have checked both the grid geometry and the polygon geometry, and bo

[postgis-users] ST_PointN(multilinestring) behavior in 2.0

2013-02-19 Thread Nicolas Gillet
Hello list, While executing old scripts today I noticed that the behavior of the function ST_PointN has changed between postgis 1.5 and 2.0 When the function is used on a MULTILINESTRING the behavior is not the same and it looks like a bug in 2.0 I think. The doc says : ""ST_PointN - Return th