Skip to content

Instantly share code, notes, and snippets.

View sorny's full-sized avatar
:shipit:
Dies Das 🍍

Gerald Reisinger sorny

:shipit:
Dies Das 🍍
View GitHub Profile
@ewheeler
ewheeler / overpass-turbo-admin-boundaries-query.js
Last active October 4, 2023 01:27
Overpass-Turbo query for viewing administrative boundaries
/*
This is an example Overpass query to view administrative boundaries.
1. Visit the OpenStreetMaps wiki (http://wiki.openstreetmap.org/wiki/Tag:boundary%3Dadministrative) and see which levels are present for your country. If admin_level = N/A, that level is missing.
2. Go to http://overpass-turbo.eu and centre the map on the country of interest.
3. Delete the text on the left side of the overpass-turbo page and replace with the contents of this file
4. Edit the admin_level to the level you want to check - in the example above, the "admin_level" = "8". Press 'Run' to highlight and outline all boundaries for that level.
@ajlai
ajlai / date_series_redshift.sql
Created February 9, 2015 20:09
Date series on redshift
WITH date_series_bounds AS (
SELECT date('2012-12-21') as start, date('2013-08-23') as end
), date_series AS (
select date(days.start + days.interval)
from (
select bounds.start, generate_series(0, bounds.end - bounds.start) AS interval from date_series_bounds bounds
) as days
)
select * from date_series
-- 2012-12-21
@nitaku
nitaku / README.md
Last active August 4, 2025 01:28
Minimal JSON HTTP server in python

A minimal HTTP server in python. It sends a JSON Hello World for GET requests, and echoes back JSON for POST requests.

python server.py 8009
Starting httpd on port 8009...
curl http://localhost:8009
{"received": "ok", "hello": "world"}
@Azuritul
Azuritul / .gitignore
Last active August 2, 2025 14:09
General .gitignore file sample
# IDEA Ignores #
################
*.iml
*.ipr
*.iws
.idea/
out/
local.properties
# Generic Android ignores #