01-vizgyujtok-stats.md

Név	Terület (km²)	Vonalhossz (km)	Százalék a teljesből (vonalhossz alapján)
Éva	78925.82 (26.03%)	21345.28 (25.74%)	25.74%
Csaba	64236.13 (21.19%)	18046.72 (21.76%)	21.76%
Ádám	51179.92 (16.88%)	16205.22 (19.54%)	19.54%
Réka	57773.21 (19.06%)	14624.63 (17.63%)	17.63%
Zsani	51055.20 (16.84%)	12711.79 (15.33%)	15.33%
####Összesen
61/61 vízgyűjtő (terület szerint 100.00%; vonalhossz szerint 100.00%)

02-vizgyujtok.geojson

extents.csv

owners.csv

update.py

#!/usr/bin/python3
import json
import os
import csv
from functools import reduce

OWNERS_PATH = 'owners.csv'
EXTENTS_PATH = 'extents.csv'
STATS_PATH = '01-vizgyujtok-stats.md'
GEOJSON_PATH = '02-vizgyujtok.geojson'

GIT_COMMIT = 'git commit -a -m "Automatic update."'
GIT_PUSH = 'git push origin master'

STYLEDICT = {
        'Éva': '#70b93e',
        'Réka': '#ea71ea',
        'Zsani': '#00ff99',
        'Csaba': '#0066ff',
        'Ádám': '#ffcc00',
        'Minta': '#cccccc',
        '': '#999999'
        }

FILL_OPACITY = .6
STROKE_WIDTH = 2
UNOWNED_STROKE_WIDTH = 1
UNOWNED_FILL_OPACITY = 0

TPL_MARKDOWN_STATS = '{}{}\n####Összesen\n**{}/{}** vízgyűjtő ' +\
        '(terület szerint **{:.2%}**; vonalhossz szerint **{:.2%}**)'
TPL_TABLE_HEADER = \
    '| Név | Terület (km²) | Vonalhossz (km) | Százalék a teljesből (vonalhossz alapján) |\n' + \
    '| --- | --- | --- | --- |\n'
TPL_TABLE_ROW = '| **{}** | {:.2f} **({:.2%})** | {:.2f} **({:.2%})** | **{:.2%}** |'

perf = { k: {'byarea': .0, 'byllen': .0}
        for k in STYLEDICT.keys() if k not in ['Minta', '']
};

with open(OWNERS_PATH) as f_owners, \
    open(EXTENTS_PATH) as f_extents, \
    open(GEOJSON_PATH) as f_geojson:

        owners = {row[0]: row[1]
                for row in csv.reader(f_owners, delimiter=',')}
        extents = {row[0]: {'area': float(row[1]), 'llen': float(row[2])}
                for row in csv.reader(f_extents, delimiter=',')}

        j = json.load(f_geojson)

        for f in j['features']:
            p = f['properties']
            n = p['nev']
            o = owners[n]

            if o not in ['Minta', '']:
                perf[o]['byarea'] += extents[n]['area']
                perf[o]['byllen'] += extents[n]['llen']

            p['owner'] = o
            p['stroke'] = STYLEDICT[o]
            p['stroke-opacity'] = 1.0
            p['fill'] = STYLEDICT[o]

            p['stroke-width'] = STROKE_WIDTH if o else UNOWNED_STROKE_WIDTH
            p['fill-opacity'] = FILL_OPACITY if o else UNOWNED_FILL_OPACITY


with open(GEOJSON_PATH, 'w') as f_geojson:
    json.dump(j, f_geojson)

with open(STATS_PATH, 'w') as f_stats:
    area_sum = reduce(lambda s, i: s + i['byarea'], perf.values(), 0)
    llen_sum = reduce(lambda s, i: s + i['byllen'], perf.values(), 0)
    perf_sorted = sorted(perf.items(), key=lambda x: -x[1]['byllen'])

    owned_extents = {k: v for (k, v) in extents.items()
        if owners[k] not in ['', 'Minta']}
    all_extents =  {k: v for (k, v) in extents.items()
        if owners[k] not in ['Minta']}

    f_stats.write(TPL_MARKDOWN_STATS.format(
        TPL_TABLE_HEADER,
        '\n'.join([TPL_TABLE_ROW.format(
            k,
            v['byarea'], v['byarea'] / area_sum,
            v['byllen'] / 1000, v['byllen'] / llen_sum,
            v['byllen'] / reduce(lambda s, i: s + i['llen'], all_extents.values(), 0)
        ) for (k, v) in perf_sorted]),

        len(owned_extents), len(all_extents),

        reduce(lambda s, i: s + i['area'], owned_extents.values(), 0) /
        reduce(lambda s, i: s + i['area'], all_extents.values(), 0),

        reduce(lambda s, i: s + i['llen'], owned_extents.values(), 0) /
        reduce(lambda s, i: s + i['llen'], all_extents.values(), 0)
    ))

os.system(GIT_COMMIT)
os.system(GIT_PUSH)