| # Basic Config | |
| #--- | |
| #substitutions: | |
| # # https://esphome.io/guides/configuration-types.html#substitutions | |
| # device_name: esp-br3 # hostname & entity_id | |
| # transition_length: 0s # transition when turning on/off | |
| ## Uses a JST24A triac and a second MCU for dimming | |
| esphome: |
| WITH potential_addresses AS ( | |
| SELECT * | |
| FROM addresses | |
| WHERE ST_Contains((SELECT ST_SetSRID(ST_Buffer(ST_Extent(geom), 5), 4326) | |
| FROM bad_buildings_in_osm), geom) | |
| ), potential_matches AS ( | |
| SELECT osm.id, | |
| osm.geom, | |
| osm."addr:housenumber", | |
| string_agg(numero, ',' ORDER BY numero ASC) AS caclr_potential_match, |
| #cd /path-to-dir/LUREF_NGL/; find . -type f -iname '*.tif' >input-files.txt | |
| #docker run -it --rm -v /path-to-dir/LUREF_NGL:/data osgeo/gdal:alpine-normal-v2.4.1 sh -l | |
| #(in docker) gdalbuildvrt -resolution highest -r nearest -a_srs "EPSG:2169" ANA_LUREF_NGL_DTM.vrt -input_file_list input-files.txt | |
| # Rest not in docker... | |
| gdaladdo -ro --config COMPRESS DEFLATE --config COMPRESS_OVERVIEW DEFLATE --config ZLEVEL 9 --config BIGTIFF_OVERVIEW IF_SAFER --config GDAL_TIFF_OVR_BLOCKSIZE 512 -r nearest ANA_LUREF_NGL_DTM.vrt 4 16 64 256 1024 4096 | |
| #Hillshade | |
| gdaldem hillshade ANA_LUREF_NGL_DTM.vrt lu_hillshade_2017.tif -co BIGTIFF=YES -co TILED=YES -co COMPRESS=DEFLATE -co GDAL_NUM_THREADS=ALL_CPUS -of GTiff -b 1 -z 1.0 -s 0.5 -az 315.0 -alt 45.0 | |
| gdalwarp -t_srs epsg:3857 -r lanczos -multi -wo NUM_THREADS=ALL_CPUS lu_hillshade_2017.tif lu_hillshade_2017-epsg-3857.tif |
| #!python3 | |
| ''' | |
| Directions: | |
| - install yt-dlp via Pip (e.g. using (StaSh)[https://github.com/ywangd/stash] - `pip install yt-dlp`) | |
| - add this script as a Share extension through Settings -> Share Extension Shortcuts | |
| - while watching a video in the YouTube site or app, just share the video to Pythonista and select this script | |
| - the video will download, and when it's done you can share the video file itself with any app (e.g. VLC) | |
| Advanced usage: |
| APT::Periodic::Update-Package-Lists "1"; | |
| APT::Periodic::Download-Upgradeable-Packages "1"; | |
| APT::Periodic::AutocleanInterval "3"; | |
| APT::Periodic::Verbose "1"; | |
| APT::Periodic::Unattended-Upgrade "1"; |
| [Sources] | |
| AmtUrl = http://www.stadtplan.hagen.de/StrVz/Hauskoordinaten.csv | |
| AmtSep = ; | |
| AmtEnc = cp1252 | |
| AmtCRS = EPSG:4647 | |
| OsmUrl = http://overpass-api.de/api/interpreter?data=%5Bout%3Acsv%28%3A%3Alat%2C%3A%3Alon%2C%3A%3Aid%2C%3A%3Atype%2C%22addr%3Apostcode%22%2C%22addr%3Astreet%22%2C%22addr%3Ahousenumber%22%2C%22addr%3Aplace%22%3Btrue%3B%22%3B%22%29%5D%5Btimeout%3A200%5D%3B%0Aarea%283601800297%29-%3E.searchArea%3B%0A%28%0A%20%20node%5B%22addr%3Ahousenumber%22%5D%28area.searchArea%29%3B%0A%20%20way%5B%22addr%3Ahousenumber%22%5D%28area.searchArea%29%3B%0A%29%3B%0Aout%20center%3B | |
| ;OsmPlace = Hagen | |
| OsmSep = ; | |
| OsmEnc = utf-8 |
| After automatically updating Postgres to 10.0 via Homebrew, the pg_ctl start command didn't work. | |
| The error was "The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.0." | |
| Database files have to be updated before starting the server, here are the steps that had to be followed: | |
| # need to have both 9.6.x and latest 10.0 installed, and keep 10.0 as default | |
| brew unlink postgresql | |
| brew install postgresql@9.6 | |
| brew unlink postgresql@9.6 | |
| brew link postgresql |
| #!/bin/bash | |
| ## this little Gist is for Copy the Letsencrypt Cert from an Linux machine (e.g. Raspberry PI or Synology NAS) | |
| ## to the router (Fritzbox). | |
| ## It is usefull to be able to speak to the Router over DDNS without any Cert issue in the Browser. | |
| ## thanks to https://gist.github.com/mahowi for the perfect Idea | |
| ## put it in /etc/letsencrypt/renewal-hooks/post so it gets run after every renewal. | |
| ## since Fritz OS 7.25 it is needed to select a Username, from a security point of view | |
| ## it is always a good idea to have a non default user name. And as normaly a Fritz Box | |
| ## is connected to the Internet, the prefered method should be WITH Username. |
| The original imagery has 4 bands (RGB and NIR) and 16bit values | |
| Build the virtual image using the RGB bands | |
| gdalbuildvrt -a_srs EPSG:21781 -allow_projection_difference -b 1 -b 2 -b 3 -input_file_list tifs16.list 2016rgb.vrt | |
| Translate from 16 bit to 8 bit values (note this is fairly slow) | |
| gdal_translate -scale -of VRT -ot Byte 2016rgb.vrt 2016rgb8.vrt |
