renderd -f
renderd[6926]: Rendering daemon started
renderd[6926]: Initiating reqyest_queue
renderd[6926]: Parsing section renderd
renderd[6926]: Parsing render section 0
renderd[6926]: Parsing section default
renderd[6926]: Parsing section mapnik
renderd[6926]: config renderd: unix socketname=/var/run/renderd.sock
renderd[6926]: config renderd: num_threads=8
renderd[6926]: config renderd: num_slaves=0
renderd[6926]: config renderd: tile_dir=/var/lib/mod_tile
renderd[6926]: config renderd: stats_file=/var/run/renderd.stats
renderd[6926]: config mapnik: plugins_dir=/usr/lib/mapnik/input
renderd[6926]: config mapnik: font_dir=/opt/osm/local_style/data/fonts
renderd[6926]: config mapnik: font_dir_recurse=1
renderd[6926]: config renderd(0): Active
renderd[6926]: config renderd(0): unix socketname=/var/run/renderd.sock
renderd[6926]: config renderd(0): num_threads=8
renderd[6926]: config renderd(0): tile_dir=/var/lib/mod_tile
renderd[6926]: config renderd(0): stats_file=/var/run/renderd.stats
renderd[6926]: config map 0: name(default) file(/opt/osm/local_style/osm10.xml) uri(/osm/) htcp() host(tile.openstreetmap.org)
renderd[6926]: Initialising unix server socket on /var/run/renderd.sock
renderd[6926]: Created server socket 4
renderd[6926]: Renderd is using mapnik version 3.0.12
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSinhala-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGujarati-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifKhmer-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifArmenian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBalinese-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansInscriptionalPahlavi-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerif-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTagbanwa-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGeorgian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBatak-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSans-BoldItalic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMalayalam-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBuginese-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTifinagh-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOsmanya-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansAvestan-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansEthiopic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansVai-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansThaiUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifGeorgian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKannadaUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansJavanese-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOriya-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGujaratiUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifThai-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansArmenian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKharoshthi-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifGujarati-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGujaratiUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSans-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCarian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMalayalamUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansThai-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGothic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansUI-Italic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifBengali-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSaurashtra-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansUgaritic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSyriacEstrangela-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTamil-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCanadianAboriginal-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifBengali-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKannada-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSyriacEastern-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansHanunoo-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMongolian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBengali-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansDevanagari-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifLao-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOldSouthArabian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifTelugu-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOriya-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGeorgian-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLepcha-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifMalayalam-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerif-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOldTurkic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerif-BoldItalic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifDevanagari-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMyanmar-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoNaskhArabicUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBengali-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLisu-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLao-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoNastaliqUrdu-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTamil-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMalayalamUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansArmenian-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoKufiArabic-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansInscriptionalParthian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKhmer-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansEgyptianHieroglyphs-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansThaana-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBengaliUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifMalayalam-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifKannada-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKayahLi-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifGujarati-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansImperialAramaic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOriyaUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTelugu-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKhmerUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifTamil-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTagalog-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTamilUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoKufiArabic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifLao-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansThai-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansPhoenician-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCham-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKannada-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSinhala-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifDevanagari-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoNaskhArabic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGurmukhi-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMyanmarUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTaiTham-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBengaliUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMandaic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMyanmar-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoNaskhArabicUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansThaiUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSymbols-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoNaskhArabic-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansNewTaiLue-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBamum-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTibetan-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBrahmi-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOldPersian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansDeseret-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLycian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOldItalic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTaiViet-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLaoUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMalayalam-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansRunic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKhmerUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTeluguUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLydian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTamilUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSylotiNagri-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSyriacWestern-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansDevanagari-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCypriot-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTelugu-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSundanese-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansUI-BoldItalic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoEmoji-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTeluguUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansShavian-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSans-Italic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTibetan-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansThaana-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGurmukhi-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLao-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoColorEmoji.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMyanmarUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansPhagsPa-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansRejang-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansHebrew-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansTaiLe-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCoptic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLinearB-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLimbu-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCuneiform-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGujarati-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansYi-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansSamaritan-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKannadaUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifArmenian-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoMono-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifKhmer-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifThai-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOriyaUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGurmukhiUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifTamil-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansHebrew-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansNKo-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCham-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKaithi-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansDevanagariUI-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansMeeteiMayek-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOlChiki-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerif-Italic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansKhmer-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSans-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansOgham-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifGeorgian-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansLaoUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansBuhid-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansCherokee-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifTelugu-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGurmukhiUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansGlagolitic-Regular.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSerifKannada-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansDevanagariUI-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/noto-osm/NotoSansEthiopic-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/unifont/unifont_upper.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/unifont/unifont.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/unifont/unifont_sample.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/unifont/unifont_csur.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerifCondensed.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerifCondensed-BoldItalic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSans-BoldOblique.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansMono-BoldOblique.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSans-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSans.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerif-Italic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansCondensed-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansMono-Oblique.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansCondensed-Oblique.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansMono-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansMono.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerifCondensed-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansCondensed-BoldOblique.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSansCondensed.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerif.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerif-BoldItalic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSans-Oblique.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuMathTeXGyre.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerif-Bold.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSerifCondensed-Italic.ttf
renderd[6926]: DEBUG: Loading font: /opt/osm/local_style/data/fonts/dejavu/DejaVuSans-ExtraLight.ttf
Running in foreground mode...
renderd[6926]: Starting stats thread
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[6926]: Loading parameterization function for
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[6926]: Loading parameterization function for
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[6926]: Loading parameterization function for debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[6926]: Loading parameterization function for
renderd[6926]: Loading parameterization function for
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[6926]: Loading parameterization function for
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[6926]: Loading parameterization function for
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[6926]: Loading parameterization function for
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-0'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-1'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Bold' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'Noto Sans CJK JP Regular' in FontSet 'fontset-2'
Mapnik LOG> 2017-01-26 12:18:31: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
renderd[6926]: Using web mercator projection settings
renderd[6926]: Using web mercator projection settings
renderd[6926]: Using web mercator projection settings
renderd[6926]: Using web mercator projection settings
renderd[6926]: Using web mercator projection settings
renderd[6926]: Using web mercator projection settings
renderd[6926]: Using web mercator projection settings
renderd[6926]: Using web mercator projection settings
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 1
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36729), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 2
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36730), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 9, number 3
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(9) xml(default), z(16), x(36731), y(22255), mime(image/png), options()
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.191 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36729/22255) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Got incoming connection, fd 11, number 4
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36731/22255) with protocol version 2 to fd 9
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 0, fd 7 closed, now 3 left
renderd[6926]: DEBUG: Failed to read cmd on fd 9
renderd[6926]: DEBUG: Connection 1, fd 9 closed, now 2 left
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(11) xml(default), z(16), x(36732), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 3
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36734), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36730/22255) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Got incoming connection, fd 9, number 4
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 0, fd 8 closed, now 3 left
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(9) xml(default), z(16), x(36733), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 4
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36733), y(22254), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 12, number 5
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(12) xml(default), z(16), x(36736), y(22254), mime(image/png), options()
renderd[6926]: DEBUG: START TILE default 16 36736-36743 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36736 22248 -> 2426417.025886|6428048.330674 2431308.995696|6432940.300484 to a 8 x 8 tile
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.062 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36732/22255) with protocol version 2 to fd 11
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36733/22254) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Got incoming connection, fd 13, number 6
renderd[6926]: DEBUG: Failed to read cmd on fd 11
renderd[6926]: DEBUG: Connection 0, fd 11 closed, now 5 left
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 2, fd 8 closed, now 4 left
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 5
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(13) xml(default), z(16), x(36734), y(22254), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36735), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36733/22255) with protocol version 2 to fd 9
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: DEBUG: Failed to read cmd on fd 9
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36734/22255) with protocol version 2 to fd 7
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: Connection 1, fd 9 closed, now 4 left
renderd[6926]: DEBUG: Got incoming connection, fd 9, number 5
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 0, fd 7 closed, now 4 left
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 5
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(9) xml(default), z(16), x(36736), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36729), y(22254), mime(image/png), options()
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.072 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36734/22254) with protocol version 2 to fd 13
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36729/22254) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36735/22255) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Got incoming connection, fd 15, number 6
renderd[6926]: DEBUG: Failed to read cmd on fd 13
renderd[6926]: DEBUG: Connection 1, fd 13 closed, now 5 left
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 3, fd 7 closed, now 4 left
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 5
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 1, fd 8 closed, now 4 left
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(15) xml(default), z(16), x(36735), y(22254), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36732), y(22254), mime(image/png), options()
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 5
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36730), y(22254), mime(image/png), options()
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.064 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36735/22254) with protocol version 2 to fd 15
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36730/22254) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36732/22254) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Failed to read cmd on fd 15
renderd[6926]: DEBUG: Connection 2, fd 15 closed, now 4 left
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 3, fd 8 closed, now 3 left
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 2, fd 7 closed, now 2 left
renderd[6926]: ERROR: failed to render TILE default 16 36736-36743 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2426111.277772796 6427742.582560491,2431614.743809332 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36736-36743 22248-22255 in 0.348 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36736/22254) with protocol version 2 to fd 12
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36736/22255) with protocol version 2 to fd 9
renderd[6926]: DEBUG: Failed to read cmd on fd 12
renderd[6926]: DEBUG: Connection 0, fd 12 closed, now 1 left
renderd[6926]: DEBUG: Failed to read cmd on fd 9
renderd[6926]: DEBUG: Connection 0, fd 9 closed, now 0 left
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 1
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36731), y(22254), mime(image/png), options()
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.063 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36731/22254) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 0, fd 7 closed, now 0 left
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 1
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36729), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 2
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36730), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 9, number 3
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(9) xml(default), z(16), x(36731), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 12, number 4
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(12) xml(default), z(16), x(36732), y(22253), mime(image/png), options()
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.063 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36729/22253) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36732/22253) with protocol version 2 to fd 12
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36731/22253) with protocol version 2 to fd 9
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36730/22253) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 0, fd 7 closed, now 3 left
renderd[6926]: DEBUG: Failed to read cmd on fd 9
renderd[6926]: DEBUG: Connection 1, fd 9 closed, now 2 left
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 0, fd 8 closed, now 1 left
renderd[6926]: DEBUG: Failed to read cmd on fd 12
renderd[6926]: DEBUG: Connection 0, fd 12 closed, now 0 left
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 1
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36733), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 2
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36734), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 9, number 3
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(9) xml(default), z(16), x(36735), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 12, number 4
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(12) xml(default), z(16), x(36736), y(22253), mime(image/png), options()
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.062 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36733/22253) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36735/22253) with protocol version 2 to fd 9
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36734/22253) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 0, fd 7 closed, now 3 left
renderd[6926]: DEBUG: Failed to read cmd on fd 9
renderd[6926]: DEBUG: Connection 1, fd 9 closed, now 2 left
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 0, fd 8 closed, now 1 left
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 2
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 3
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36728), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36728), y(22254), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 9, number 4
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(9) xml(default), z(16), x(36728), y(22255), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 13, number 5
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(13) xml(default), z(16), x(36727), y(22253), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming connection, fd 15, number 6
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(15) xml(default), z(16), x(36727), y(22254), mime(image/png), options()
renderd[6926]: DEBUG: START TILE default 16 36736-36743 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36736 22248 -> 2426417.025886|6428048.330674 2431308.995696|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: START TILE default 16 36728-36735 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36728 22248 -> 2421525.056076|6428048.330674 2426417.025886|6432940.300484 to a 8 x 8 tile
renderd[6926]: ERROR: failed to render TILE default 16 36736-36743 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2426111.277772796 6427742.582560491,2431614.743809332 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36736-36743 22248-22255 in 0.074 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36736/22253) with protocol version 2 to fd 12
renderd[6926]: DEBUG: Failed to read cmd on fd 12
renderd[6926]: DEBUG: Connection 0, fd 12 closed, now 5 left
renderd[6926]: DEBUG: Got incoming connection, fd 12, number 6
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(12) xml(default), z(16), x(36727), y(22255), mime(image/png), options()
renderd[6926]: ERROR: failed to render TILE default 16 36728-36735 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2421219.307962542 6427742.582560491,2426722.773999078 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36728-36735 22248-22255 in 0.060 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36728/22253) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 0, fd 7 closed, now 5 left
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36728/22255) with protocol version 2 to fd 9
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36728/22254) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 0, fd 8 closed, now 4 left
renderd[6926]: DEBUG: Failed to read cmd on fd 9
renderd[6926]: DEBUG: Connection 0, fd 9 closed, now 3 left
renderd[6926]: DEBUG: START TILE default 16 36720-36727 22248-22255, new metatile
renderd[6926]: Rendering projected coordinates 16 36720 22248 -> 2416633.086265|6428048.330674 2421525.056076|6432940.300484 to a 8 x 8 tile
renderd[6926]: DEBUG: Got incoming connection, fd 7, number 4
renderd[6926]: DEBUG: Got incoming connection, fd 8, number 5
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(7) xml(default), z(16), x(36727), y(22256), mime(image/png), options()
renderd[6926]: DEBUG: Got incoming request with protocol version 2
renderd[6926]: DEBUG: Got command RenderPrio fd(8) xml(default), z(16), x(36727), y(22257), mime(image/png), options()
renderd[6926]: ERROR: failed to render TILE default 16 36720-36727 22248-22255
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2416327.338152288 6427742.582560491,2421830.804188824 6433246.048597027)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36720-36727 22248-22255 in 0.059 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36727/22253) with protocol version 2 to fd 13
renderd[6926]: DEBUG: Failed to read cmd on fd 13
renderd[6926]: DEBUG: Connection 0, fd 13 closed, now 4 left
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36727/22255) with protocol version 2 to fd 12
renderd[6926]: DEBUG: Failed to read cmd on fd 12
renderd[6926]: DEBUG: Connection 1, fd 12 closed, now 3 left
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36727/22254) with protocol version 2 to fd 15
renderd[6926]: DEBUG: Failed to read cmd on fd 15
renderd[6926]: DEBUG: Connection 0, fd 15 closed, now 2 left
renderd[6926]: DEBUG: START TILE default 16 36720-36727 22256-22263, new metatile
renderd[6926]: Rendering projected coordinates 16 36720 22256 -> 2416633.086265|6423156.360863 2421525.056076|6428048.330674 to a 8 x 8 tile
renderd[6926]: ERROR: failed to render TILE default 16 36720-36727 22256-22263
renderd[6926]: reason: Postgis Plugin: BŁĄD: kolumna "tower_construction" nie istnieje
LINE 1: ...ure","generator:source","power_source","religion","tower_con...
^
in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"access","denomination","feature","generator:source","power_source","religion","tower_construction","tower_type","way_pixels" FROM (SELECT
way,
COALESCE(
'aeroway_' || CASE WHEN aeroway IN ('helipad', 'aerodrome') THEN aeroway ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house',
'hostel', 'hotel', 'motel', 'information', 'museum', 'picnic_site') THEN tourism ELSE NULL END,
'amenity_' || CASE WHEN amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre', 'fire_station', 'fountain',
'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse', 'townhall', 'parking',
'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors', 'dentist', 'place_of_worship',
'police', 'post_box', 'post_office', 'pub', 'biergarten', 'recycling', 'restaurant', 'food_court',
'fast_food', 'telephone', 'emergency_phone', 'taxi', 'theatre', 'toilets', 'drinking_water',
'prison', 'hunting_stand', 'nightclub', 'veterinary', 'social_facility',
'charging_station') THEN amenity ELSE NULL END,
'shop_' || CASE WHEN shop IN ('supermarket', 'bag', 'bakery', 'beauty', 'books', 'butcher', 'clothes', 'computer',
'confectionery', 'fashion', 'convenience', 'department_store', 'doityourself', 'hardware', 'fishmonger', 'florist',
'garden_centre', 'hairdresser', 'hifi', 'ice_cream', 'car', 'car_repair', 'bicycle', 'mall', 'pet',
'photo', 'photo_studio', 'photography', 'seafood', 'shoes', 'alcohol', 'gift', 'furniture', 'kiosk',
'mobile_phone', 'motorcycle', 'musical_instrument', 'newsagent', 'optician', 'jewelry', 'jewellery',
'electronics', 'chemist', 'toys', 'travel_agency', 'car_parts', 'greengrocer', 'farm', 'stationery',
'laundry', 'dry_cleaning', 'beverages', 'perfumery', 'cosmetics', 'variety_store', 'wine', 'outdoor',
'copyshop', 'sports', 'deli', 'tobacco', 'art', 'tea', 'coffee') THEN shop
WHEN shop IN ('no', 'vacant', 'closed', 'disused', 'empty') OR shop IS NULL THEN NULL ELSE 'other' END,
'leisure_' || CASE WHEN leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table') THEN leisure ELSE NULL END,
'man_made_' || CASE WHEN man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk') THEN man_made ELSE NULL END,
'natural_' || CASE WHEN "natural" IN ('spring') THEN "natural" ELSE NULL END,
'historic_' || CASE WHEN historic IN ('memorial', 'monument', 'archaeological_site') THEN historic ELSE NULL END,
'highway_'|| CASE WHEN highway IN ('bus_stop', 'elevator', 'traffic_signals') THEN highway ELSE NULL END,
'power_' || CASE WHEN power IN ('generator') THEN power ELSE NULL END,
'tourism_' || CASE WHEN tourism IN ('viewpoint') THEN tourism ELSE NULL END
) AS feature,
access,
religion,
denomination,
"generator:source",
power_source,
way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
FROM planet_osm_polygon
-- The upcoming where clause is needed for performance only, as the CASE statements would end up doing the equivalent filtering
WHERE aeroway IN ('helipad', 'aerodrome')
OR tourism IN ('artwork', 'alpine_hut', 'camp_site', 'caravan_site', 'chalet', 'wilderness_hut', 'guest_house', 'hostel',
'hotel', 'motel', 'information', 'museum', 'viewpoint', 'picnic_site')
OR amenity IN ('shelter', 'atm', 'bank', 'bar', 'bicycle_rental', 'bus_station', 'cafe',
'car_rental', 'car_wash', 'cinema', 'clinic', 'community_centre',
'fire_station', 'fountain', 'fuel', 'hospital', 'ice_cream', 'embassy', 'library', 'courthouse',
'townhall', 'parking', 'bicycle_parking', 'motorcycle_parking', 'pharmacy', 'doctors',
'dentist', 'place_of_worship', 'police', 'post_box', 'post_office', 'pub', 'biergarten',
'recycling', 'restaurant', 'food_court', 'fast_food', 'telephone', 'emergency_phone', 'taxi',
'theatre', 'toilets', 'drinking_water', 'prison', 'hunting_stand', 'nightclub', 'veterinary',
'social_facility', 'charging_station')
OR shop IS NOT NULL -- skip checking a huge list and use a null check
OR leisure IN ('water_park', 'playground', 'miniature_golf', 'golf_course', 'picnic_table')
OR man_made IN ('mast', 'tower', 'water_tower', 'lighthouse', 'windmill', 'obelisk')
OR "natural" IN ('spring')
OR historic IN ('memorial', 'monument', 'archaeological_site')
OR highway IN ('bus_stop', 'elevator', 'traffic_signals')
OR (power = 'generator' AND ("generator:source" = 'wind' OR power_source = 'wind'))
ORDER BY way_area desc
) AS amenity_points_poly WHERE "way" && ST_SetSRID('BOX3D(2416327.338152288 6422850.612750238,2421830.804188824 6428354.078786774)'::box3d, 3857)'
renderd[6926]: DEBUG: DONE TILE default 16 36720-36727 22256-22263 in 0.195 seconds
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36727/22256) with protocol version 2 to fd 7
renderd[6926]: DEBUG: Failed to read cmd on fd 7
renderd[6926]: DEBUG: Connection 0, fd 7 closed, now 1 left
renderd[6926]: DEBUG: Sending render cmd(4 default 16/36727/22257) with protocol version 2 to fd 8
renderd[6926]: DEBUG: Failed to read cmd on fd 8
renderd[6926]: DEBUG: Connection 0, fd 8 closed, now 0 left
