Recent content on Mete Blog
I’m excited to share my new project I’ve been working on: GeoDownloader.com , a tool I built to make downloading OpenStreetMap (OSM) data easier and more intuitive than other website I have been used so far. If you’ve ever struggled with getting the right geospatial data in the right format for your project, I think you’ll find this project useful too. Why I Created GeoDownloader.com Working with…
When you need to import a GeoJSON file into your QGIS project, you just need to drag & drop the GeoJSON file from File Browser. Adding a GeoJSON file as a layer is easy as drag & drop action However, if the GeoJSON content you want to import is not in a file already, then you need to first create a file with this content and import it as shown above. This workaround could be time-consuming…
I recently bought a Xiaomi Poco F3 (128GB) at £234 from Xiaomi UK website . I think it is great hardware at this price. I have been using iPhone for the last three years (XR->11->12). Once I saw this deal on hotukdeals website, I thought I should give it a try to Android after three years. I knew it will come with a lot of bloatware and I cannot uninstall them in a normal way, but I was ready to…
In this guide, I will explain how to receive SMS messages and forward them to your Telegram account using Raspberry PI Zero W and Wireshare GSM hat . Python will be used to read SMS messages and forward them to Telegram Bot API . Messages will be listened to by Gammu SMS service and it will trigger the Python script when an SMS message received.
If you are looking for a command to delete Azure blob files in a folder with one command, here is the solution;
GeoDownloader 🌎 https://geodownloader.com 📃 A website that simplifies OpenStreetMap data downloads 🛠 JavaScript | Node.js | Python | GeoPanda | AWS SQS | AWS S3 | Vue | OpenLayers GeOrchestrator 📃 This project was developed as a part of PhD study. This project allows running geospatial workflows on serverless services provided by a cloud provider. It supports sequential, parallel, and loop…
About the Blog: I’m willing to share the following topics on this blog: Solutions for challenges I encounter New technologies that I have recently discovered My reviews and comments about other blog posts/articles About the Author: My name is Mete. I can identify myself as an enthusiast of geospatial and cloud technologies. I have been a software developer for a long time. I have been…
PowerBI REST APIs are very limited with restrictions for specific usages. One of the restriction is that you cannot update parameters on your PowerBI dataset via APIs if you’re using Direct Query. It is a problem if you want to have a master template PowerBI report and create reports based on the master for each different project with different parameters.
Six months ago, I applied to UK visa together with a solicitor. My solicitor asked me to provide daily bank statements for the last three months to prove that my account balance never down below asked level by Home Office. At that time, I was using Bunq and had a chat with Bunq support, and I was told that it is not possible via application unless I export statements day by day. That means I had…
The following code exports MS SQL tables to Parquet files via PySpark. It can be used in tables that do not have an indexed column with the numerical type (int, float, etc.).
The pyspark script below can split one single big parquet file into small parquet files based on date column.