source: subversion/sites/www.openstreetbrowser.org/src/sql/01_simplyfy_db.sql @ 29773

Last change on this file since 29773 was 16408, checked in by skunk, 11 years ago

Files missing (please don't ask me why)

File size: 397 bytes
Line 
1update planet_osm_point set "highway"='mountain_pass' from node_tags where osm_id=node_id and k='mountain_pass' and v='yes';
2update planet_osm_line set "tunnel"='yes' from way_tags where "man_made"='pipeline' and osm_id=way_id and k='location' and v in ('underground', 'underwater');
3update planet_osm_line set "voltage"=v from way_tags where "man_made"='pipeline' and osm_id=way_id and k='type';
Note: See TracBrowser for help on using the repository browser.