This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| set -e | |
| set -u | |
| duckdb -c " | |
| LOAD spatial; | |
| SET s3_region='us-west-2'; | |
| COPY ( | |
| SELECT |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # File copied from https://github.com/MeteoSwiss/meteodata-lab | |
| # | |
| # Copyright (c) 2023 Federal Office of Meteorlogy and Climatology MeteoSwiss | |
| # | |
| # Permission is hereby granted, free of charge, to any person obtaining a copy | |
| # of this software and associated documentation files (the "Software"), to deal | |
| # in the Software without restriction, including without limitation the rights | |
| # to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
| # copies of the Software, and to permit persons to whom the Software is | |
| # furnished to do so, subject to the following conditions: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import llm | |
| prompt = f'''Extract an OpenStreetMap opening_hours string from the following website. | |
| Your response must contain only the opening hours string. | |
| Your response should contain temporary closures. | |
| The corresponding OpenStreetMap entry has these tags: | |
| access = yes | |
| addr:city = Zürich |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://www.digitec.ch/de/s1/product/seagate-exos-x24-24-tb-35-cmr-festplatte-39559469 | |
| Write one 80 GiB file (85135469091 bytes): 4min 36s -> 294 MiB / sec | |
| Read one 80 GiB file (85135469091 bytes): 5min 31s -> 245 MiB / sec |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| x | y | z | source | maxzoom | |
|---|---|---|---|---|---|
| 22 | 53 | 6 | glo30 | 12 | |
| 22 | 52 | 6 | glo30 | 12 | |
| 23 | 53 | 6 | glo30 | 12 | |
| 17 | 8 | 5 | glo30 | 12 | |
| 17 | 9 | 5 | glo30 | 12 | |
| 16 | 8 | 5 | glo30 | 12 | |
| 17 | 11 | 5 | glo30 | 12 | |
| 17 | 10 | 5 | glo30 | 12 | |
| 67 | 41 | 7 | glo30 | 12 |
OlderNewer