Skip to content

Instantly share code, notes, and snippets.

@milafrerichs
milafrerichs / vega.json
Last active August 24, 2016 17:28
Vega Highlight
{
"description": "Violations by reporting source",
"data": { "url": "/data/case_by_case_source.csv"},
"transform": {
"calculate": [{"field": "highlight", "expr": "datum.case_source == \"Citizen Complaint\" ? \"true\" : \"false\""}]
},
"mark": "bar",
"encoding": {
"y": {"field": "case_source", "type": "ordinal", "sort": {"op": "sum", "field": "cases"}, "axis": {"title": "Case Source"}},
"x": {"field": "cases", "type": "quantitative", "axis": {"title": "# Cases"}},
@milafrerichs
milafrerichs / README.md
Created November 22, 2015 09:52
swdata

README is empty

<!DOCTYPE html>
<meta charset="utf-8">
<style>
text {
font: 10px sans-serif;
}
</style>
<body>
BL art prozent
1 BW Abfall 0.00503105908927563
2 BY Abfall 0.00766036655211913
3 BE Abfall 0.0142011834319527
4 BB Abfall 0.00791946308724832
5 HB Abfall 0.0571967316153363
6 HH Abfall 0.0179372197309417
7 HE Abfall 0.0150583896742471
8 MV Abfall 0.00325857772666283
9 NI Abfall 0.00326427576601671
@milafrerichs
milafrerichs / Readme.md
Last active August 29, 2015 14:20
Docker setup

This is my current setup. How would I scale this with docker-compose:

dcocker-compose scale app=3
This file has been truncated, but you can view the full file.
Einzelplan,einzelplan_nr,Kapitel,Gruppe,Zählnummer,Funktion,Ansatz 2015 in Euro,Ansatz 2014 in Euro,Ist 2013 in Euro,Verpflichtungsermächtigung in Euro,Zweckbestimmung
Landtag,1.0,10.0,119.0,1.0,11.0,40000.0,40000.0,14816.1,0.0,Vermischte Einnahmen
Landtag,1.0,10.0,119.0,2.0,11.0,10000.0,10000.0,243.0,0.0,Einnahmen aus Veröffentlichungen
Landtag,1.0,10.0,124.0,1.0,11.0,40000.0,50000.0,39578.0,0.0,Mieten und Pachten
Landtag,1.0,10.0,132.0,1.0,11.0,3500.0,3500.0,1358.63,0.0,Erlöse aus der Veräußerung von beweglichen Sachen
Landtag,1.0,10.0,232.0,0.0,11.0,0.0,0.0,0.0,0.0,Erstattung von Verwaltungsausgaben durch das Land Brandenburg
Landtag,1.0,10.0,236.0,0.0,11.0,0.0,0.0,0.0,0.0,Erstattungen von Verwaltungsausgaben von Sozialversicherungsträgern sowie der Bundesagentur für Arbeit
Landtag,1.0,10.0,261.0,0.0,11.0,2000.0,2000.0,2004.0,0.0,Schuldendiensthilfen und Erstattungen von Verwaltungsausgaben aus dem Inland
Landtag,1.0,10.0,232.0,90.0,11.0,97000.0,97000.0,98474.0,0.0,Sonstige Zuweisungen von Ländern
Landtag,
@milafrerichs
milafrerichs / eu.geojson
Last active August 29, 2015 14:16
Simple Map of Europe
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@milafrerichs
milafrerichs / eu.topojson
Last active February 6, 2023 20:36
Simple Map of Europe TopoJSON
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@milafrerichs
milafrerichs / export_data.sql
Last active August 29, 2015 14:12
Export all Data and Headers from CIP MSSQL Database to CSV
USE developmentdataSQL
SELECT 'exec master..xp_cmdshell'
+ ' '''
+ 'bcp'
+ ' "' + TABLE_CATALOG + '.' + TABLE_SCHEMA + '.[' + TABLE_NAME
+ ']" out'
+ ' "C:\cip\'
+ TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME + '.csv"'
+ ' -c'
+ ' -t,'