API-Dokumentation

curl "https://umwelt-score.com/api/export/gemeinden" \
  -H "Authorization: Bearer usk_live_YOUR_KEY" \
  -o gemeinden-zh.json

curl "https://umwelt-score.com/api/export/gemeinden?format=csv&min_score=70&sort=total" \
  -H "Authorization: Bearer usk_live_YOUR_KEY" \
  -o top-gemeinden.csv

import requests
import pandas as pd

API_KEY = "usk_live_YOUR_KEY"
HEADERS = {"Authorization": f"Bearer {API_KEY}"}

r = requests.get("https://umwelt-score.com/api/export/gemeinden", headers=HEADERS)
if r.status_code != 200:
    raise SystemExit(f"Fehler {r.status_code}: {r.json().get('message', r.text)}")

data = r.json()
df = pd.DataFrame(data["gemeinden"])

# Scores und Rohdaten als eigene Spalten
scores = pd.json_normalize(df["scores"]).add_prefix("score_")
raw    = pd.json_normalize(df["raw"]).add_prefix("raw_")
df = pd.concat([df[["bfs","name","bezirk","pop","fläche","total"]], scores, raw], axis=1)

print(df.sort_values("total", ascending=False).head(10))

# Hitzetage & Strompreis
print(df[["name","raw_hitzetage","raw_strompreis_rp_kwh","total"]].sort_values("raw_hitzetage", ascending=False).head(10))

library(httr)
library(jsonlite)

API_KEY <- "usk_live_YOUR_KEY"

res <- GET("https://umwelt-score.com/api/export/gemeinden",
           add_headers(Authorization = paste("Bearer", API_KEY)))
data <- fromJSON(content(res, "text", encoding = "UTF-8"))
df <- data$gemeinden

# Scores und Rohdaten extrahieren
scores <- as.data.frame(df$scores)
names(scores) <- paste0("score_", names(scores))
raw <- as.data.frame(df$raw)
df <- cbind(df[c("bfs","name","bezirk","pop","total")], scores, raw)

# Korrelation Hitzetage vs. Boden-Score
cor(df$hitzetage, df$score_boden, use = "complete.obs")

# Günstigste Gemeinden nach Strompreis
head(df[order(df$strompreis_rp_kwh), c("name","strompreis_rp_kwh","score_energie")], 10)

const API_KEY = 'usk_live_YOUR_KEY'
const res = await fetch('https://umwelt-score.com/api/export/gemeinden?min_score=60', {
  headers: { Authorization: `Bearer ${API_KEY}` }
})
if (!res.ok) throw new Error(`Fehler ${res.status}: ${(await res.json()).message}`)
const { gemeinden, metadata } = await res.json()

console.log(`${gemeinden.length} Gemeinden geladen (Stand: ${metadata.pipeline_meta?.generated_at})`)

// Bezirks-Durchschnitt Score + Ø Hitzetage
const byBezirk = {}
for (const g of gemeinden) {
  if (!byBezirk[g.bezirk]) byBezirk[g.bezirk] = { scores: [], hitzetage: [] }
  byBezirk[g.bezirk].scores.push(g.total)
  if (g.raw?.hitzetage != null) byBezirk[g.bezirk].hitzetage.push(g.raw.hitzetage)
}
const avg = Object.fromEntries(
  Object.entries(byBezirk).map(([b, d]) => [b, {
    score: (d.scores.reduce((a,v) => a+v) / d.scores.length).toFixed(1),
    hitzetage: d.hitzetage.length ? (d.hitzetage.reduce((a,v) => a+v) / d.hitzetage.length).toFixed(1) : '–',
  }])
)
console.table(avg)