
<?php 
 $db=pg_pconnect('host=localhost port=5432 dbname=osm user=osm password=osm') or die("Keine DB, sonst alles in Ordnung");

 $flaechenhinderniss=array("building is not null",
                           "nature='water' or landuse='basin' or amenity='fountain' or waterway='riverbank'",
                           "historic='memorial' or historic='monument'",
                           "nature='wood' or landuse='forest' or nature='scrub' or landuse='village_green' or landuse='construction' or landuse='brownfield' or leisure='ice_rink' or leisure='playground' or leisure='pitch' or landuse='garden' or landuse='grass'",
                           "man_made is not null",
                           "amenity is not null",
                           "nature='cliff'",
                           "shop is not null",
                           "tourism='artwork'",
                           "barrier is not null",
                           "(access is null and (foot='no' or foot='private'))",
                           "(access='no' or access='private') and not ( foot='yes' or foot='permissive' or foot='designated' or  foot='official')"
                          );
 $punkthinderniss= array("amenity is not null and amenity!='hunting_stand' and amenity!='shelter' and amenity!='drinking_water' and amenity!='watering_place' and (man_made is null or man_made!='water_well')",1,
                         "shop is not null",5,
                         "man_made is not null and man_made!='water_well'",2,
                         "leisure='playground'",4,
                         "tourism='artwork'",2,
                         "tourism='information'",1,
#                         "highway='street_lamp'",1,
#                         "nature='tree'",1,
                         "(historic='memorial' or historic='monument')",2
                        );

 $strichhinderniss= array("railway='rail' or railway='tram' or railway='light_rail' or railway='narrow_gauge'",0.5,
                         "nature='cliff'",0.5,
                         "barrier like '%hedge%'",0.5,
                         "barrier like '%wall%'",0.5,
                         "barrier='fence'",0.5,
                         "barrier='chain'",0.5,
                         "barrier is not null and (((access='no' or access='private') and foot!='yes') or (access is null and (foot='no' or foot='private')))",0.5,
                         "waterway='stream' or waterway='river'",0.5 
                        );
                        
 $punktverbinder= array("railway like '%crossing%'",1,  
                        "tags->'ford'='yes'",1,
                        "barrier is not null  and (access='yes' or access='permissive' or foot='yes' or foot='permissive' or foot='designated' or  foot='official')",1,
                        "barrier like '%gate%'    and (foot!='no' and foot!='private') ",1,
                        "barrier like '%caddle%'  and (foot!='no' and foot!='private') ",1,
                        "barrier like '%bollard%' and (foot!='no' and foot!='private') ",1,
                        "barrier like '%kerb%'    and (foot!='no' and foot!='private') ",1,
                        "barrier like '%block%'   and (foot!='no' and foot!='private') ",1,
                        "barrier like '%cycle%'   and (foot!='no' and foot!='private') ",1,
                        "barrier like '%stile%'   and (foot!='no' and foot!='private') ",1,
                        "barrier like '%debris%'  and (foot!='no' and foot!='private') ",1  
                         );
                                                                                                                            

 $query="select osm_id,st_astext(way) as way from osm_pedestrian;";


 echo "delete and fill osm_pedestrian\n";
 $query2="delete from osm_pedestrian;\n";
 $result2=pg_query($db,$query2);
 $query2="select osm_id,st_astext(ST_ForceRHR(way)) as way from osm_polygon where ((((nature='beach') or (tags->'public_transport'='platform')) and  (access in ('yes','permissive') and foot is null or foot in ('yes','permissive'))) or (highway in ('residential','track','pedestrian','footway','path','living_street','pathless') or man_made='pier' )) and (access is null or access='yes' or access='designated' or foot='yes') and (foot is null or foot !='no') and (layer is null or layer='0') and geometrytype(way)='POLYGON';";
 $result2=pg_query($db,$query2);
 while($r=pg_fetch_array($result2)) {
  $osm_id=$r['osm_id'];
  $way=$r['way'];
  $query3="insert into osm_pedestrian (osm_id,service,way) values ($osm_id,'polycopy',ST_GeomFromText('$way',900913));\n";
  $result3=pg_query($db,$query3);
 }

                           
 for($h=0;$h<count($flaechenhinderniss);$h++){
  $result=pg_query($db,$query);
  while($r=pg_fetch_array($result)) {
   $osm_id=$r['osm_id'];
   $way=$r['way'];
   echo "A: $osm_id (".$flaechenhinderniss[$h].") ...";
   $query2="select osm_id from osm_polygon where (layer is null or layer='0') and way && ST_GeomFromText('$way',900913) and (".$flaechenhinderniss[$h].") and osm_id!='".$osm_id."' and st_intersects(way,ST_GeomFromText('$way',900913)) and not st_within(ST_GeomFromText('$way',900913),way);";
   $result2=pg_query($db,$query2);
   if(pg_fetch_array($result2)){
    echo "hat eins drin \n";
    $query2="update osm_pedestrian as PE set way=st_difference(PE.way,(select st_union(way) from (select (way) as way from osm_polygon where way && PE.way and (".$flaechenhinderniss[$h].") and (layer is null or layer='0') and osm_id!=PE.osm_id and st_intersects(way,ST_GeomFromText('$way',900913))  and not st_within(ST_GeomFromText('$way',900913),way))   as foo )) where osm_id='".$osm_id."';";
    $result2=pg_query($db,$query2);
   }else{
    echo "nix \n";
   }
  }
 } 


 for($h=0;$h<count($punkthinderniss);$h+=2){
  $result=pg_query($db,$query);
  while($r=pg_fetch_array($result)) {
   $osm_id=$r['osm_id'];
   $way=$r['way'];
   echo "P $osm_id (".$punkthinderniss[$h].") ...";
   $query2="select osm_id from osm_point where (layer is null or layer='0') and way && ST_GeomFromText('$way',900913) and (".$punkthinderniss[$h].") and st_within(way,ST_GeomFromText('$way',900913));";
   $result2=pg_query($db,$query2);
   if(pg_fetch_array($result2)){
    echo "hat eins drin \n";
    $query2="update osm_pedestrian as PE set way=st_difference(PE.way,(select st_union(way) from (select expand(way,(".$punkthinderniss[$h+1].")) as way from osm_point where way && PE.way and (".$punkthinderniss[$h].") and (layer is null or layer='0') and st_within(way,ST_GeomFromText('$way',900913))) as foo )) where osm_id='".$osm_id."';";
    $result2=pg_query($db,$query2);
   }else{
    echo "nix \n";
   }
  }
 }


 for($h=0;$h<count($strichhinderniss);$h+=2){
  $result=pg_query($db,$query);
  while($r=pg_fetch_array($result)) {
   $osm_id=$r['osm_id'];
   $way=$r['way'];
   echo "L $osm_id (".$strichhinderniss[$h].") ...";
   $query2="select osm_id from osm_line where (layer is null or layer='0') and way && ST_GeomFromText('$way',900913) and (".$strichhinderniss[$h].") and st_intersects(way,ST_GeomFromText('$way',900913));";
   $result2=pg_query($db,$query2);
   if(pg_fetch_array($result2)){
    echo "hat eins drin \n";
    $query2="update osm_pedestrian as PE set obstacle=(select st_union(way) from (select obstacle as way from osm_pedestrian where osm_id='".$osm_id."' union select st_buffer(way,(".$strichhinderniss[$h+1].")) as way from osm_line where way && PE.way and (".$strichhinderniss[$h].") and (layer is null or layer='0') and st_intersects(way,PE.way)) as foo ) where osm_id='".$osm_id."';";
    $result2=pg_query($db,$query2);
   }else{
    echo "nix \n";
   }
  }
 }


  $result=pg_query($db,$query);
  while($r=pg_fetch_array($result)) {
   $osm_id=$r['osm_id'];
   $way=$r['way'];
   echo "L $osm_id  sonderfall waterway=stream and tunnel is null and layer=-1 ...";
   $query2="select osm_id from osm_line where way && ST_GeomFromText('$way',900913) and waterway='stream' and tunnel is null and st_intersects(way,ST_GeomFromText('$way',900913));";
   $result2=pg_query($db,$query2);
   if(pg_fetch_array($result2)){
    echo "hat eins drin \n";
    $query2="update osm_pedestrian as PE set obstacle=(select st_union(way) from (select obstacle as way from osm_pedestrian where osm_id='".$osm_id."' union select st_buffer(way,0.5) as way from osm_line where way && PE.way and waterway='stream' and tunnel is null and layer='-1' and st_intersects(way,PE.way)) as foo ) where osm_id='".$osm_id."';";
    $result2=pg_query($db,$query2);
   }else{
    echo "nix \n";
   }
  }


 for($h=0;$h<count($punktverbinder);$h+=2){
  $result=pg_query($db,$query);
  while($r=pg_fetch_array($result)) {
   $osm_id=$r['osm_id'];
   $way=$r['way'];
   echo "PV $osm_id (".$punktverbinder[$h].") ...";
   $query2="select osm_id from osm_point where (layer is null or layer='0') and way && ST_GeomFromText('$way',900913) and (".$punktverbinder[$h].") and st_within(way,ST_GeomFromText('$way',900913));";
   $result2=pg_query($db,$query2);
   if(pg_fetch_array($result2)){
    echo "hat eins drin \n";
    $query2="update osm_pedestrian as PE set obstacle=st_difference(PE.obstacle,(select st_union(way) from (select expand(way,(".$punktverbinder[$h+1].")) as way from osm_point where way && PE.obstacle and (".$punktverbinder[$h].") and (layer is null or layer='0') and st_within(way,PE.obstacle)) as foo )) where osm_id='".$osm_id."';";
    $result2=pg_query($db,$query2);
   }else{
    echo "nix \n";
   }
  }
 }

  $result=pg_query($db,$query);
  while($r=pg_fetch_array($result)) {
   $osm_id=$r['osm_id'];
   $way=$r['way'];
   echo "LX $osm_id ...\n";
   $query2="update osm_pedestrian as PE set  way=st_difference(way,obstacle) where obstacle is not null and osm_id='".$osm_id."';";
   $result2=pg_query($db,$query2);
  }

  echo "Rechte Hand Regel\n";
  $query2="update osm_pedestrian set  way=ST_ForceRHR(way)";
  $result2=pg_query($db,$query2);
  $query2="delete from osm_pedestrian where geometrytype(way)!='MULTIPOLYGON' and geometrytype(way)!='POLYGON'";
  $result2=pg_query($db,$query2);

exit;  
?>