<?php 


 $db=pg_pconnect('host=localhost port=5432 dbname=osm user=osm password=osm') or die("Keine DB, sonst alles in Ordnung");
 $nn=0;
// $query1="select distinct(osm_id) from routing_ways where waysource='kanonade';";
// $query1="select distinct(osm_id) from routing_ways where waysource='kanonade' and st_contains((select st_transform(way,4326) from osm_polygon where osm_id=-62428 order by way_area desc limit 1),the_geom);";
// $query1="select distinct(osm_id) from routing_ways where osm_id in (-152653,3810642) and waysource='virtual_area_way' and st_contains((select st_transform(way,4326) from osm_polygon where osm_id=-62428 order by way_area desc limit 1),the_geom);";
// $query1="select distinct(osm_id) from routing_ways where waysource='virtual_area_way' and osm_id='-1934891'";
// $query1="select distinct(osm_id) from routing_ways where waysource='virtual_area_way' and osm_id='-1951581'";
// $query1="select distinct(osm_id) from routing_ways where waysource='virtual_area_way' and osm_id='227012667'";
// $query1="select distinct(osm_id) from routing_ways where waysource='virtual_area_way'";
// $query1="select distinct(osm_id) from osm_pedestrian where osm_id='33364851';";
   $query1="select distinct(osm_id) from osm_pedestrian;";
 
 $result1=pg_query($db,$query1);
 while($r1=pg_fetch_array($result1)) {
  $osm_id=$r1['osm_id'];
  $nn++;
  $query4="update routing_ways set class_id=0,costfactor=1.1 where  osm_id='".$osm_id."' and waysource='virtual_area_way';";
  $result4=pg_query($db,$query4);
  $query2="select st_astext(st_transform(st_expand((st_union(way)),10),4326)) as bbox from (select way from osm_pedestrian where osm_id='".$osm_id."') as foo;";
  $result2=pg_query($db,$query2);
  $r2=pg_fetch_array($result2);
  $bbox=$r2['bbox'];
  echo "\n $osm_id: $nn \n";
  $query2="select ipoint from osm_pedestrian where osm_id='".$osm_id."';";
  $result2=pg_query($db,$query2);
  $r2=pg_fetch_array($result2);
  $punkt=split(',',$r2['ipoint']);
  for($n=0;$n<count($punkt);$n++){
   for($i=0;$i<$n;$i++){
//    echo "routing $nn tes Polygon $osm_id ".$punkt[$i]." zu ".$punkt[$n]."\n";
    echo ".";
    $query3="SELECT edge_id FROM shortest_path('select gid as id,source::integer,target::integer,(length*costfactor)::double precision as cost from routing_ways where the_geom && ST_GeomFromText(\'$bbox\',4326) and costfactor<2 order by length', ".$punkt[$i].",".$punkt[$n].", false,false);";
    $result3=pg_query($db,$query3);
    while($r3=pg_fetch_array($result3)){
     $edge=$r3['edge_id'];
//     echo "                                                            $edge\n";
     if($edge>0){
      $query4="update routing_ways set class_id=-1,costfactor=1.0 where gid=$edge and waysource='virtual_area_way' and costfactor>1.0;";
      $result4=pg_query($db,$query4);
     }
    }
   }
  }
  $query4="delete from routing_ways where waysource='virtual_area_way' and osm_id=$osm_id and class_id>-1";
  $result4=pg_query($db,$query4);
 }
 exit;  
?>