Skip to content
Permalink
Branch: master
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
367 lines (350 sloc) 66.7 KB
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('1000','1099','place','osm_id, name, place, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('1100','1199','boundary','osm_id, name, admin_level, boundary, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('1200','1299','admin_area','osm_id, name, admin_level, boundary, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('1500','1599','building','osm_id, "addr:housename" AS housename, "addr:housenumber" AS housenumber, building, name, place, COALESCE(tags -> ''building:levels'', ''1'') AS levels, COALESCE(tags -> ''building:height'', ''4'') AS height, tags, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2000','2099','public','osm_id, name, amenity, landuse, way','govn''t offices, post office, police, etc.');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2100','2199','health','osm_id, name, amenity, landuse, way','Hospitals, pharmacies');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2200','2299','leisure','osm_id, name, amenity, landuse, leisure, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2300','2399','food','osm_id, name, amenity, landuse, leisure, tourism, way','Restaurants, pubs, cafes');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2400','2499','accomodation','osm_id, name, landuse, leisure, tourism, way','Hotel, motel, etc.');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2500','2599','shopping','osm_id, name, shop, amenity, tags -> ''vending'' AS vending, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2600','2899','tourism','osm_id, name, tourism, amenity, tags -> ''information'' AS information, way','I''m not so sure about this range….');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('2900','2999','miscpoi','osm_id, name, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('3000','3999','pofw','osm_id, name, religion, way','Place of Worship');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('4100','4199','natural','osm_id, name, "natural", tags -> ''ele'' AS elevation, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('5000','5099','transport','osm_id, name, tags -> ''traffic'' AS traffic, highway, ref way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('5100','5199','road','osm_id, name, tags -> ''traffic'' AS traffic, highway, ref, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('5200','5299','traffic','osm_id, name, tags -> ''traffic'' AS traffic, highway, ref, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('6100','6199','railway','osm_id, name, tags -> ''traffic'' AS traffic, highway, ref, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('6400','6499','power','osm_id, name, power, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('6500','6599','powerline','osm_id, name, power, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('7200','7299','landuse','osm_id, name, landuse, "natural", leisure,boundary, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('8100','8199','waterway','osm_id, name, waterway, "natural", landuse, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('8200','8299','water','osm_id, name, waterway, "natural", landuse, way','');
INSERT INTO pgosm.layer_group (code_start, code_end, class, osm_columns, description) VALUES ('8300','8399','coastline','','');
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1001','city','TRUE','FALSE','TRUE','place=''city''','see also 1005');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1002','town','TRUE','FALSE','TRUE','place=''town''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1003','village','TRUE','FALSE','TRUE','place=''village''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1004','hamlet','TRUE','FALSE','TRUE','place=''hamlet''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1005','national_capital','TRUE','FALSE','TRUE','place=''city'' AND (tags -> ''is_capital''=''country'' OR admin_level=''2'' OR (tags -> ''capital''=''yes'' and admin_level IS NULL))','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1010','suburb','TRUE','FALSE','TRUE','place=''suburb''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1020','island','TRUE','FALSE','TRUE','place=''island''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1030','farm','TRUE','FALSE','TRUE','place=''farm''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1031','dwelling','TRUE','FALSE','TRUE','place=''isolated_dwelling''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1040','region','TRUE','FALSE','TRUE','place=''region''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1041','county','TRUE','FALSE','TRUE','place=''county''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1050','locality','TRUE','FALSE','TRUE','place=''locality''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1099','named_place','TRUE','FALSE','TRUE','name IS NOT NULL','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1101','admin_level1','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''1''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1102','admin_level2','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''2''','National Border');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1103','admin_level3','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''3''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1104','admin_level4','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''4''','State???');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1105','admin_level5','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''5''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1106','admin_level6','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''6''','Maybe county??');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1107','admin_level7','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''7''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1108','admin_level8','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''8''','City or borough');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1109','admin_level9','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''9''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1110','admin_level10','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''10''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1111','admin_level11','FALSE','TRUE','TRUE','boundary=''administrative'' AND admin_level=''11''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1500','building','FALSE','FALSE','TRUE','building IS NOT NULL','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1551','entrance','TRUE','FALSE','FALSE','building = ''entrance'' OR (tags -> ''entrance'' IN (''main'',''yes'' ))','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1552','exit','TRUE','FALSE','FALSE','building = ''exit''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('1553','emergency_exit','TRUE','FALSE','FALSE','tags -> ''entrance'' = ''emergency''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2001','police','TRUE','FALSE','TRUE','amenity=''police''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2002','fire_station','TRUE','FALSE','TRUE','amenity=''fire_station''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2004','post_box','TRUE','FALSE','TRUE','amenity=''post_box''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2005','post_office','TRUE','FALSE','TRUE','amenity=''post_office''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2006','telephone','TRUE','FALSE','TRUE','amenity=''telephone''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2007','library','TRUE','FALSE','TRUE','amenity=''library''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2008','town_hall','TRUE','FALSE','TRUE','amenity=''townhall''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2009','courthouse','TRUE','FALSE','TRUE','amenity=''courthouse''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2010','prison','TRUE','FALSE','TRUE','amenity=''prison''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2011','embassy','TRUE','FALSE','TRUE','amenity=''embassy''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2012','community_centre','TRUE','FALSE','TRUE','amenity=''community_centre''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2013','nursing_home','TRUE','FALSE','TRUE','amenity=''nursing_home''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2014','arts_centre','TRUE','FALSE','TRUE','amenity=''arts_centre''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2015','graveyard','TRUE','FALSE','TRUE','amenity=''grave_yard'' OR landuse=''cemetery''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2016','market_place','TRUE','FALSE','TRUE','amenity=''market_place''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2030','recycling','TRUE','FALSE','TRUE','amenity=''recycling'' AND tags -> ''recycling:glass'' <> ''yes'' AND tags -> ''recycling:paper'' <> ''yes'' AND tags -> ''recycling:clothes'' <> ''yes''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2031','recycling_glass','TRUE','FALSE','TRUE','tags -> ''recycling:glass''=''yes''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2032','recycling_paper','TRUE','FALSE','TRUE','tags -> ''recycling:paper''=''yes''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2033','recycling_clothes','TRUE','FALSE','TRUE','tags -> ''recycling:clothes''=''yes''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2081','university','TRUE','FALSE','TRUE','amenity=''university''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2082','school','TRUE','FALSE','TRUE','amenity=''school''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2083','kindergarten','TRUE','FALSE','TRUE','amenity=''kindergarten''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2084','college','TRUE','FALSE','TRUE','amenity=''college''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2099','public_building','TRUE','FALSE','TRUE','amenity=''public_building''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2101','pharmacy','TRUE','FALSE','TRUE','amenity=''pharmacy''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2110','hospital','TRUE','FALSE','TRUE','amenity=''hospital''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2120','doctors','TRUE','FALSE','TRUE','amenity=''doctors''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2121','dentist','TRUE','FALSE','TRUE','amenity=''dentist''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2129','veterinary','TRUE','FALSE','TRUE','amenity=''veterinary''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2201','theatre','TRUE','FALSE','TRUE','amenity=''theatre''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2202','nightclub','TRUE','FALSE','TRUE','amenity=''nightclub''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2203','cinema','TRUE','FALSE','TRUE','amenity=''cinema''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2204','park','TRUE','FALSE','TRUE','leisure=''park''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2205','playground','TRUE','FALSE','TRUE','leisure=''playground''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2206','dog_park','TRUE','FALSE','TRUE','leisure=''dog_park''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2251','sports_centre','TRUE','FALSE','TRUE','leisure=''sports_centre''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2252','pitch','TRUE','FALSE','TRUE','leisure=''pitch''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2253','swimming_pool','TRUE','FALSE','TRUE','amenity=''swimming_pool'' OR leisure=''swimming_pool'' OR leisure=''water_park''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2255','golf_course','TRUE','FALSE','TRUE','leisure=''golf_course''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2256','stadium','TRUE','FALSE','TRUE','leisure=''stadium''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2257','ice_rink','TRUE','FALSE','TRUE','leisure=''ice_rink''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2301','restaurant','TRUE','FALSE','TRUE','amenity=''restaurant''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2302','fast_food','TRUE','FALSE','TRUE','amenity=''fast_food''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2303','café','TRUE','FALSE','TRUE','amenity=''cafe''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2304','pub','TRUE','FALSE','TRUE','amenity=''pub''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2305','bar','TRUE','FALSE','TRUE','amenity=''bar''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2306','food_court','TRUE','FALSE','TRUE','amenity=''food_court''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2307','biergarten','TRUE','FALSE','TRUE','amenity=''biergarten''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2401','hotel','TRUE','FALSE','TRUE','tourism=''hotel''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2402','motel','TRUE','FALSE','TRUE','tourism=''motel''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2403','bed_and_breakfast','TRUE','FALSE','TRUE','tourism=''bed_and_breakfast''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2404','guesthouse','TRUE','FALSE','TRUE','tourism=''guest_house''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2405','hostel','TRUE','FALSE','TRUE','tourism=''hostel''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2406','chalet','TRUE','FALSE','TRUE','tourism=''chalet''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2421','shelter','TRUE','FALSE','TRUE','amenity=''shelter''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2422','camp_site','TRUE','FALSE','TRUE','tourism=''camp_site''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2423','alpine_hut','TRUE','FALSE','TRUE','tourism=''alpine_hut''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2424','caravan_site','TRUE','FALSE','TRUE','tourism=''caravan_site''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2501','supermarket','TRUE','FALSE','TRUE','shop=''supermarket''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2502','bakery','TRUE','FALSE','TRUE','shop=''bakery''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2503','kiosk','TRUE','FALSE','TRUE','shop=''kiosk''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2504','mall','TRUE','FALSE','TRUE','shop=''mall''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2505','department_store','TRUE','FALSE','TRUE','shop=''department_store''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2511','convenience','TRUE','FALSE','TRUE','shop=''convenience''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2512','clothes','TRUE','FALSE','TRUE','shop=''clothes''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2513','florist','TRUE','FALSE','TRUE','shop=''florist''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2514','chemist','TRUE','FALSE','TRUE','shop=''chemist''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2515','bookshop','TRUE','FALSE','TRUE','shop=''books''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2516','butcher','TRUE','FALSE','TRUE','shop=''butcher''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2517','shoe_shop','TRUE','FALSE','TRUE','shop=''shoes''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2518','beverages','TRUE','FALSE','TRUE','shop=''alcohol'' OR shop=''beverages''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2519','optician','TRUE','FALSE','TRUE','shop=''optician''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2520','jeweller','TRUE','FALSE','TRUE','shop=''jewelry''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2521','gift_shop','TRUE','FALSE','TRUE','shop=''gift''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2522','sports_shop','TRUE','FALSE','TRUE','shop=''sports''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2523','stationery','TRUE','FALSE','TRUE','shop=''stationery''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2524','outdoor_shop','TRUE','FALSE','TRUE','shop=''outdoor''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2525','mobile_phone_shop','TRUE','FALSE','TRUE','shop=''mobile_phone''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2526','toy_shop','TRUE','FALSE','TRUE','shop=''toys''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2527','newsagent','TRUE','FALSE','TRUE','shop=''newsagent''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2528','greengrocer','TRUE','FALSE','TRUE','shop=''greengrocer''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2529','beauty_shop','TRUE','FALSE','TRUE','shop=''beauty''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2530','video_shop','TRUE','FALSE','TRUE','shop=''video''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2541','car_dealership','TRUE','FALSE','TRUE','shop=''car''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2542','bicycle_shop','TRUE','FALSE','TRUE','shop=''bicycle''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2543','doityourself','TRUE','FALSE','TRUE','shop=''doityourself'' AND shop=''hardware''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2544','furniture_shop','TRUE','FALSE','TRUE','shop=''furniture''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2546','computer_shop','TRUE','FALSE','TRUE','shop=''computer''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2547','garden_centre','TRUE','FALSE','TRUE','shop=''garden_centre''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2561','hairdresser','TRUE','FALSE','TRUE','shop=''hairdresser''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2562','car_repair','TRUE','FALSE','TRUE','shop=''car_repair''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2563','car_rental','TRUE','FALSE','TRUE','amenity=''car_rental''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2564','car_wash','TRUE','FALSE','TRUE','amenity=''car_wash''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2565','car_sharing','TRUE','FALSE','TRUE','amenity=''car_sharing''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2566','bicycle_rental','TRUE','FALSE','TRUE','amenity=''bicycle_rental''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2567','travel_agent','TRUE','FALSE','TRUE','shop=''travel_agent''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2568','laundry','TRUE','FALSE','TRUE','shop=''laundry'' OR shop=''dry_cleaning''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2590','vending_machine','TRUE','FALSE','TRUE','amenity=''vending_machine'' AND tags -> ''vending'' <> ''''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2591','vending_cigarette','TRUE','FALSE','TRUE','tags -> ''vending'' =''cigarettes''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2592','vending_parking','TRUE','FALSE','TRUE','tags -> ''vending'' =''parking_tickets''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2601','bank','TRUE','FALSE','TRUE','amenity=''bank''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2602','atm','TRUE','FALSE','TRUE','amenity=''atm''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2701','tourist_info','TRUE','FALSE','TRUE','tourism=''information'' AND tags -> ''information'' <> ''''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2704','tourist_map','TRUE','FALSE','TRUE','tourism=''information'' AND tags -> ''information'' = ''map''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2705','tourist_board','TRUE','FALSE','TRUE','tourism=''information'' AND tags -> ''information'' = ''board''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2706','tourist_guidepost','TRUE','FALSE','TRUE','tourism=''information'' AND tags -> ''information'' =''guidepost''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2721','attraction','TRUE','FALSE','TRUE','tourism=''attraction''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2722','mueseum','TRUE','FALSE','TRUE','tourism=''museum''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2723','monument','TRUE','FALSE','TRUE','historic=''monument''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2724','memorial','TRUE','FALSE','TRUE','historic=''memorial''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2725','art','TRUE','FALSE','TRUE','tourism=''artwork''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2731','castle','TRUE','FALSE','TRUE','historic=''castle''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2732','ruins','TRUE','FALSE','TRUE','historic=''ruins''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2733','archaeological','TRUE','FALSE','TRUE','historic=''archaeological_site''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2734','wayside_cross','TRUE','FALSE','TRUE','historic=''wayside_cross''','Geofabrik docs said "historic=wayside_criss" but I assume that''s a typo');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2735','wayside_shrine','TRUE','FALSE','TRUE','historic=''wayside_shrine''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2736','battlefield','TRUE','FALSE','TRUE','historic=''battlefield''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2737','fort','TRUE','FALSE','TRUE','historic=''fort''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2741','picnic_site','TRUE','FALSE','TRUE','tourism=''picnic_site''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2742','viewpoint','TRUE','FALSE','TRUE','tourism=''viewpoint''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2743','zoo','TRUE','FALSE','TRUE','tourism=''zoo''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2744','theme_park','TRUE','FALSE','TRUE','tourism=''theme_park''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2901','toilet','TRUE','FALSE','TRUE','amenity=''toilets''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2902','bench','TRUE','FALSE','TRUE','amenity=''bench''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2903','drinking_water','TRUE','FALSE','TRUE','amenity=''drinking_water''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2904','fountain','TRUE','FALSE','TRUE','amenity=''fountain''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2905','hunting_stand','TRUE','FALSE','TRUE','amenity=''hunting_stand''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2906','waste_basket','TRUE','FALSE','TRUE','amenity=''waste_basket''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2907','camera_surveillance','TRUE','FALSE','TRUE','man_made=''surveillance''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2921','emergency_phone','TRUE','FALSE','TRUE','amenity=''emergency_phone'' OR tags -> ''emergency''=''phone''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2922','fire_hydrant','TRUE','FALSE','TRUE','amenity=''fire_hydrant'' OR tags -> ''emergency''=''fire_hydrant''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2923','emergency_access','TRUE','FALSE','TRUE','highway=''emergency_access_point''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2950','tower','TRUE','FALSE','TRUE','man_made=''tower'' ','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2952','water_tower','TRUE','FALSE','TRUE','man_made=''water_tower''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2954','windmill','TRUE','FALSE','TRUE','man_made=''windmill''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2955','lighthouse','TRUE','FALSE','TRUE','man_made=''lighthouse''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2961','wasewater_plant','TRUE','FALSE','TRUE','man_made=''wasewater_plant''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2962','water_well','TRUE','FALSE','TRUE','man_made=''water_well''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2963','water_mill','TRUE','FALSE','TRUE','man_made=''watermill''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('2964','water_works','TRUE','FALSE','TRUE','man_made=''water_works''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('3100','christian','TRUE','FALSE','TRUE','religion=''christian''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('3200','jewish','TRUE','FALSE','TRUE','religion=''jewish''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('3300','muslim','TRUE','FALSE','TRUE','religion=''muslim'' ','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4101','spring','TRUE','FALSE','TRUE','"natural"=''spring''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4103','glacier','TRUE','FALSE','TRUE','"natural"=''glacier''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4111','peak','TRUE','FALSE','TRUE','"natural"=''peak''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4112','cliff','TRUE','TRUE','TRUE','"natural"=''cliff''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4113','volcano','TRUE','FALSE','TRUE','"natural"=''volcano''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4121','tree','TRUE','FALSE','TRUE','"natural"=''tree''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4131','mine','TRUE','FALSE','TRUE','"natural"=''mine''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4132','cave_entrance','TRUE','FALSE','TRUE','"natural"=''cave_entrance''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('4141','beach','TRUE','FALSE','TRUE','"natural"=''beach''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5111','motorway','FALSE','TRUE','FALSE','highway=''motorway''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5112','trunk','FALSE','TRUE','FALSE','highway=''trunk''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5113','primary','FALSE','TRUE','FALSE','highway=''primary''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5114','secondary','FALSE','TRUE','FALSE','highway=''secondary''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5115','tertiary','FALSE','TRUE','FALSE','highway=''tertiary''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5121','unsubclassified','FALSE','TRUE','FALSE','highway=''unsubclassified''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5122','residential','FALSE','TRUE','FALSE','highway=''residential''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5123','living_street','FALSE','TRUE','FALSE','highway=''living_street''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5124','pedestrian','FALSE','TRUE','FALSE','highway=''pedestrian''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5131','motorway_link','FALSE','TRUE','FALSE','highway=''motorway_link''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5132','trunk_link','FALSE','TRUE','FALSE','highway=''trunk_link''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5133','primary_link','FALSE','TRUE','FALSE','highway=''primary_link''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5134','secondary_link','FALSE','TRUE','FALSE','highway=''secondary_link''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5141','service','FALSE','TRUE','FALSE','highway=''service''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5142','track','FALSE','TRUE','FALSE','highway=''track'' AND tracktype IS NULL','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5143','track_grade1','FALSE','TRUE','FALSE','highway=''track'' AND tracktype=''grade1''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5144','track_grade2','FALSE','TRUE','FALSE','highway=''track'' AND tracktype=''grade2''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5145','track_grade3','FALSE','TRUE','FALSE','highway=''track'' AND tracktype=''grade3''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5146','track_grade4','FALSE','TRUE','FALSE','highway=''track'' AND tracktype=''grade4''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5147','track_grade5','FALSE','TRUE','FALSE','highway=''track'' AND tracktype=''grade5''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5151','bridleway','FALSE','TRUE','FALSE','highway=''bridleway'' OR (highway=''path'' AND horse=''designated'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5152','cycleway','FALSE','TRUE','FALSE','highway=''cycleway'' OR (highway IS NOT NULL AND tags -> ''cycle''=''designated'')','I modified the second half from Geofabrik to not require highway=path when cycle=designated');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5153','footway','FALSE','TRUE','FALSE','highway=''footway'' OR foot=''designated''','I modified the second half from Geofabrik to not require highway=path when foot=designated');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5154','path','FALSE','TRUE','FALSE','highway=''path''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5155','steps','FALSE','TRUE','FALSE','highway=''steps''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5199','unknown','FALSE','TRUE','FALSE','highway=''road''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5201','traffic_signals','TRUE','FALSE','TRUE','highway=''traffic_signals''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5202','mini_roundabout','TRUE','FALSE','TRUE','highway=''mini_roundabout''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5203','stop','TRUE','FALSE','TRUE','highway=''stop''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5204','crossing','TRUE','FALSE','TRUE','highway=''crossing'' OR railway=''level_crossing''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5205','speed_camera','TRUE','FALSE','TRUE','highway=''speed_camera''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5206','motoway_junction','TRUE','FALSE','TRUE','highway=''motorway_junction''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5207','turning_circle','TRUE','FALSE','TRUE','highway=''turning_circle''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5208','ford','TRUE','FALSE','TRUE','highway=''ford''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5209','street_lamp','TRUE','FALSE','TRUE','highway=''street_lamp''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5210','barrier','TRUE','FALSE','TRUE','barrier IS NOT NULL AND barrier NOT IN(''gate'',''bollard'',''lift_gate'',''stile'',''cycle_barrier'',''fence'',''toll_booth'',''block'',''kissing_gate'',''cattle_grid'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5211','barrier_gate','TRUE','FALSE','TRUE','barrier=''gate''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5212','barrier_bollard','TRUE','FALSE','TRUE','barrier=''bollard''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5213','barrier_lift_gate','TRUE','FALSE','TRUE','barrier=''lift_gate''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5214','barrier_stile','TRUE','FALSE','TRUE','barrier=''stile'' OR highway=''stile''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5215','barrier_cycle','TRUE','FALSE','TRUE','barrier=''cycle_barrier''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5216','barrier_fence','TRUE','TRUE','TRUE','barrier=''fence''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5217','barrier_toll','TRUE','FALSE','TRUE','barrier=''toll_booth''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5218','barrier_block','TRUE','FALSE','TRUE','barrier=''block''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5219','barrier_kissing_gate','TRUE','FALSE','TRUE','barrier=''kissing_gate''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5220','barrier_cattle_grid','TRUE','FALSE','TRUE','barrier=''cattle_grid''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5231','calming_hump','TRUE','FALSE','TRUE','tags -> ''traffic_calming'' =''hump''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5232','calming_bump','TRUE','FALSE','TRUE','tags -> ''traffic_calming''=''bump''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5233','calming_table','TRUE','FALSE','TRUE','tags -> ''traffic_calming''=''table''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5234','calming_chicane','TRUE','FALSE','TRUE','tags -> ''traffic_calming''=''chicane''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5235','calming_cushion','TRUE','FALSE','TRUE','tags -> ''traffic_calming''=''cushion''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5250','fuel','TRUE','FALSE','TRUE','amenity=''fuel''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5251','service','TRUE','FALSE','TRUE','highway=''services''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5260','parking','TRUE','FALSE','TRUE','amenity=''parking'' ','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5261','parking_site','TRUE','FALSE','TRUE','amenity=''parking'' AND tags -> ''parking''=''site''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5262','parking_multistorey','TRUE','FALSE','TRUE','amenity=''parking'' AND tags -> ''parking''=''multi-storey''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5263','parking_underground','TRUE','FALSE','TRUE','amenity=''parking'' AND tags -> ''parking''=''underground''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5270','parking_bicycle','TRUE','FALSE','TRUE','amenity=''bicycle_parking''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5301','slipway','FALSE','FALSE','FALSE','leisure=''slipway''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5302','marina','FALSE','FALSE','FALSE','leisure=''marina''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5303','pier','FALSE','FALSE','FALSE','man_made=''pier''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5311','dam','FALSE','FALSE','FALSE','waterway=''dam''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5321','waterfall','FALSE','FALSE','FALSE','waterway=''waterfall''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5331','lock_gate','FALSE','FALSE','FALSE','waterway=''lock_gate''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5332','weir','FALSE','FALSE','FALSE','waterway=''weir''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5501','fence','FALSE','FALSE','FALSE','barrier=''fence'' OR barrier=''wood_fence'' OR barrier=''wire_fence''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5511','hedge','FALSE','FALSE','FALSE','barrier=''hedge''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5512','tree_row','FALSE','FALSE','FALSE','barrier=''tree_row''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5521','wall','FALSE','FALSE','FALSE','barrier=''wall''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5531','dyke','FALSE','FALSE','FALSE','man_made=''dyke''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5601','railway_station','FALSE','FALSE','FALSE','railway=''station''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5602','railway_halt','FALSE','FALSE','FALSE','railway=''halt'' OR (public_transport=''stop_position'' AND train=''yes'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5603','tram_stop','FALSE','FALSE','FALSE','railway=''tram_stop'' OR (public_transport=''stop_position'' AND tram=''yes'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5621','bus_stop','FALSE','FALSE','FALSE','highway=''bus_stop'' OR (public_transport=''stop_position'' AND bus=''yes'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5622','bus_station','FALSE','FALSE','FALSE','amenity=''bus_station''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5641','taxi_rank','FALSE','FALSE','FALSE','amenity=''taxi_rank''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5651','airport','FALSE','FALSE','FALSE','amenity=''airport'' OR (aeroway=''aerodome'' AND type <> ''airstrip'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5652','airfield','FALSE','FALSE','FALSE','aeroway=''airfield'' OR military=''airfield'' OR (aeroway=''aeroway'' AND type=''airstrip'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5655','helipad','FALSE','FALSE','FALSE','aeroway=''helipad''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5661','ferry_terminal','FALSE','FALSE','FALSE','amenity=''ferry_terminal''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('5671','aerialway_station','FALSE','FALSE','FALSE','aerialway=''station''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6101','rail','FALSE','TRUE','FALSE','railway=''rail'' AND tags -> ''propulsion'' <> ''''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6102','light_rail','FALSE','TRUE','FALSE','railway=''light_rail''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6103','subway','FALSE','TRUE','FALSE','railway=''subway''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6104','tram','FALSE','TRUE','FALSE','railway=''tram''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6105','monorail','FALSE','TRUE','FALSE','railway=''monorail''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6106','narrow_gauge','FALSE','TRUE','FALSE','railway=''narrow_gauge''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6107','miniature','FALSE','TRUE','FALSE','railway=''miniature''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6108','funicular','FALSE','TRUE','FALSE','railway=''funicular'' OR (railway=''rail'' AND tags -> ''propulsion''=''funicular'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6109','rack','FALSE','TRUE','FALSE','railway=''rack'' OR (railway=''rail'' AND tags -> ''propulsion''=''rack'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6111','drag_lift','FALSE','TRUE','FALSE','aerialway=''drag_lift''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6112','chair_lift','FALSE','TRUE','FALSE','aerialway=''chair_lift'' OR aerialway=''high_speed_chair_lift''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6113','cable_car','FALSE','TRUE','FALSE','aerialway=''cable_car''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6114','gondola','FALSE','TRUE','FALSE','aerialway=''gondola''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6115','goods','FALSE','TRUE','FALSE','aerialway=''goods''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6119','other_lift','FALSE','TRUE','FALSE','aerialway IS NOT NULL AND aerialway NOT IN (''drag_lift'',''chair_lift'',''high_speed_chair_lift'',''cable_car'',''gondola'',''goods'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6204','pole','TRUE','FALSE','TRUE','power=''pole''','Should this code be 6404??');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6401','tower','TRUE','FALSE','TRUE','power=''tower''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6410','station','TRUE','FALSE','TRUE','power=''generator'' ','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6422','substation','TRUE','FALSE','TRUE','power=''sub_station''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6423','transformer','TRUE','FALSE','TRUE','power=''transformer''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6500','line','FALSE','TRUE','FALSE','power=''line''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6501','minor_line','FALSE','TRUE','FALSE','power=''minor_line''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6511','cable','FALSE','TRUE','FALSE','power=''cable''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('6512','minor_cable','FALSE','TRUE','FALSE','power=''minor_cable''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7201','forest','FALSE','FALSE','TRUE','landuse=''forest'' OR "natural"=''wood''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7202','park','FALSE','FALSE','TRUE','leisure=''park''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7203','residential','FALSE','FALSE','TRUE','landuse=''residential''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7204','industrial','FALSE','FALSE','TRUE','landuse=''industrial''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7205','farm','FALSE','FALSE','TRUE','landuse IN (''farm'',''farmland'',''farm yard'')','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7206','cemetery','FALSE','FALSE','TRUE','landuse=''cemetery''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7207','allotments','FALSE','FALSE','TRUE','landuse=''allotments''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7208','meadow','FALSE','FALSE','TRUE','landuse=''meadow''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7209','commercial','FALSE','FALSE','TRUE','landuse=''commercial''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7210','nature_reserve','FALSE','FALSE','TRUE','leisure=''recreation_ground'' OR landuse=''recreation_ground''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7211','recreation_ground','FALSE','FALSE','TRUE','leisure=''recreation_ground'' OR landuse=''recreation_ground''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7212','retail','FALSE','FALSE','TRUE','landuse=''retail''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7213','military','FALSE','FALSE','TRUE','landuse=''military''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7214','quarry','FALSE','FALSE','TRUE','landuse=''quarry''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7215','orchard','FALSE','FALSE','TRUE','landuse=''orchard''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7216','vineyard','FALSE','FALSE','TRUE','landuse=''vineyard''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7217','scrub','FALSE','FALSE','TRUE','landuse=''scrub'' or "natural"=''scrub''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7218','grass','FALSE','FALSE','TRUE','landuse=''grass''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7219','heath','FALSE','FALSE','TRUE','"natural"=''heath''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('7220','national_park','FALSE','FALSE','TRUE','boundary=''national_park''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8101','river','FALSE','TRUE','FALSE','waterway=''river''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8102','stream','FALSE','TRUE','FALSE','waterway=''stream''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8103','canal','FALSE','TRUE','FALSE','waterway=''canal''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8104','drain','FALSE','TRUE','FALSE','waterway=''drain''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8200','water','FALSE','FALSE','TRUE','"natural"=''water''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8201','reservoir','FALSE','FALSE','TRUE','landuse=''reservoir''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8202','river','FALSE','FALSE','TRUE','waterway=''riverbank''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8211','glacier','FALSE','FALSE','TRUE','"natural"=''glacier''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8221','wetland','FALSE','FALSE','TRUE','"natural"=''wetland''','');
INSERT INTO pgosm.layer_detail (code, subclass, geom_point, geom_line, geom_polygon, osm_tag_filter, description) VALUES ('8300','coastline','FALSE','FALSE','FALSE','???','');
UPDATE pgosm.layer_detail ld
SET layer_group_id = l.layer_group_id
FROM pgosm.layer_group l
WHERE ld.code BETWEEN l.code_start AND l.code_end
;
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
You can’t perform that action at this time.