Re: [postgis-users] Incorrect Result for ST_CountAgg with nodata pixels?

2016-07-13 Thread Michael Treglia
Hi All, Just to follow-up - looks like I've figured out the issue: In the count of total number of pixels per building, it seems I was calculating the total number of pixels per tile that intersected with the polygons, not the total number of pixels that actually intersected the polygon. For no

Re: [postgis-users] number all houses on branch roads first

2016-07-13 Thread RĂ©mi Cura
Would be much easier to send your graph to python networkx If you have plpython, this is immediate (line 368) I found it painful to work

Re: [postgis-users] Question on topology

2016-07-13 Thread Sandro Santilli
On Wed, Jul 13, 2016 at 01:05:41PM +0200, Neumann, Andreas wrote: > Yes - I will try that next - loading it in chunks. But wouldn't it miss > out on some of the neighbourpolygons then if I use such subsets based on > pkey? The final goal is importing all of your geometries, so eventually neighbo

Re: [postgis-users] Question on topology

2016-07-13 Thread Neumann, Andreas
Hi Strk, Yes - I will try that next - loading it in chunks. But wouldn't it miss out on some of the neighbourpolygons then if I use such subsets based on pkey? Thanks, Andreas On 2016-07-13 12:55, Sandro Santilli wrote: > On Tue, Jul 12, 2016 at 01:15:41PM +0200, Neumann, Andreas wrote: >

Re: [postgis-users] Question on topology

2016-07-13 Thread Sandro Santilli
On Tue, Jul 12, 2016 at 01:15:41PM +0200, Neumann, Andreas wrote: > Hi Sandro, > > I let this function run during the night and after 7.5h I got an error > message: Eh, that's why I suggested loading the topology in batches. Use constructs like: SELECT TopoGeo_addPolygon(...) FROM input_t