[postgis-users] Line of sight (LOS) Calculation

2015-03-07 Thread Ofer Zilberstein
experience with such task and what will be the execution time for a single query Thanks... *Ofer Zilberstein* ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] Topology & Attributes

2015-02-10 Thread Ofer Zilberstein
er where schema_name = 'pe' and > table_name = 'parcelle; > > So, in your case, check the layer_id of the department table and use this > value. > > Nicolas > > > On 9 February 2015 at 21:18, Ofer Zilberstein > wrote: > >> Hi, >> >&

Re: [postgis-users] Topology & Attributes

2015-02-09 Thread Ofer Zilberstein
7;topogeom' it would look like department d1 on (1,(d1.topogeom).id) = (r1.layer_id, r1.topogeo_id) ? Ofer On Mon, Feb 9, 2015 at 3:52 PM, Ofer Zilberstein wrote: > Hi Nicolas, > > 1. I used ST_CreateTopoGeo() to build the topology (not the > topology.toTopoGeom() &

Re: [postgis-users] Topology & Attributes

2015-02-09 Thread Ofer Zilberstein
iew stores 2 faces id per row (left and right), I duplicated > the joins to join both left_face and right face against the original > polygon table (p1 and p2 aliases) > > Nicolas > > On 8 February 2015 at 21:57, Ofer Zilberstein > wrote: > >> Much Thanks, >> >&

Re: [postgis-users] Topology & Attributes

2015-02-08 Thread Ofer Zilberstein
er_id, r1.topogeo_id) > join topo_grass.relation r2 on r2.element_id = e.right_face > join pe.parcelle p2 on (1, (p2.topo).id) = (r2.layer_id, r2.topogeo_id); > > Nicolas > > > > On 8 February 2015 at 10:29, Ofer Zilberstein > wrote: > >> >> Hi, >

Re: [postgis-users] Topology & Attributes

2015-02-08 Thread Ofer Zilberstein
of a > presentation I did a while ago. Starting on page 14 I am trying to > illustrate how attributes from a simple polygon source can be joined to > edges in PostGIS topology . > > Rich > > On Sun, Feb 8, 2015 at 2:29 AM, Ofer Zilberstein < > zilberstein.o...@gmail.com

[postgis-users] Topology & Attributes

2015-02-08 Thread Ofer Zilberstein
left original polygons ? -- *Ofer Zilberstein* Mobile: 972-544886873 Skype: ofer.zilberstein Mail: zilberstein.o...@gmail.com ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users