19855efacc
Some checks failed
Tests / Go Tests (push) Has been cancelled
Tests / Python Tests (push) Has been cancelled
Tests / Integration Tests (push) Has been cancelled
Tests / Go Lint (push) Has been cancelled
Tests / Python Lint (push) Has been cancelled
Tests / Security Scan (push) Has been cancelled
Tests / All Checks Passed (push) Has been cancelled
Security Scanning / Secret Scanning (push) Has been cancelled
Security Scanning / Dependency Vulnerability Scan (push) Has been cancelled
Security Scanning / Go Security Scan (push) Has been cancelled
Security Scanning / Python Security Scan (push) Has been cancelled
Security Scanning / Node.js Security Scan (push) Has been cancelled
Security Scanning / Docker Image Security (push) Has been cancelled
Security Scanning / Security Summary (push) Has been cancelled
CI/CD Pipeline / Go Tests (push) Has been cancelled
CI/CD Pipeline / Python Tests (push) Has been cancelled
CI/CD Pipeline / Website Tests (push) Has been cancelled
CI/CD Pipeline / Linting (push) Has been cancelled
CI/CD Pipeline / Security Scan (push) Has been cancelled
CI/CD Pipeline / Docker Build & Push (push) Has been cancelled
CI/CD Pipeline / Integration Tests (push) Has been cancelled
CI/CD Pipeline / Deploy to Staging (push) Has been cancelled
CI/CD Pipeline / Deploy to Production (push) Has been cancelled
CI/CD Pipeline / CI Summary (push) Has been cancelled
ci/woodpecker/manual/build-ci-image Pipeline was successful
ci/woodpecker/manual/main Pipeline failed
All services: admin-v2, studio-v2, website, ai-compliance-sdk, consent-service, klausur-service, voice-service, and infrastructure. Large PDFs and compiled binaries excluded via .gitignore.
118 lines
2.9 KiB
Markdown
118 lines
2.9 KiB
Markdown
# Session Status - 25. Januar 2026 (Aktualisiert)
|
|
|
|
## Zusammenfassung
|
|
|
|
Open Data School Import erfolgreich implementiert. Schulbestand von 17,610 auf 30,355 erhoeht.
|
|
|
|
---
|
|
|
|
## Erledigte Aufgaben
|
|
|
|
### 1. Studio-v2 Build-Fehler (Vorherige Session)
|
|
- **Status:** Erledigt
|
|
- **Problem:** `Module not found: Can't resolve 'pdf-lib'`
|
|
- **Loesung:** Falsches package.json auf macmini ersetzt, rsync mit --delete
|
|
|
|
### 2. Open Data School Importer
|
|
- **Status:** Erledigt
|
|
- **Datei:** `/edu-search-service/scripts/import_open_data.py`
|
|
- **Erfolgreich importiert:**
|
|
- **NRW:** 5,637 Schulen (CSV von schulministerium.nrw.de)
|
|
- **Berlin:** 930 Schulen (WFS/GeoJSON von gdi.berlin.de)
|
|
- **Hamburg:** 543 Schulen (WFS/GML von geodienste.hamburg.de)
|
|
|
|
---
|
|
|
|
## Aktuelle Schulstatistiken
|
|
|
|
```
|
|
Total: 30,355 Schulen
|
|
|
|
Nach Bundesland:
|
|
NW: 14,962 (inkl. Open Data Import)
|
|
BY: 2,803
|
|
NI: 2,192
|
|
BE: 1,475 (inkl. WFS Import)
|
|
SN: 1,425
|
|
SH: 1,329
|
|
HE: 1,290
|
|
RP: 1,066
|
|
HH: 902 (inkl. WFS Import)
|
|
TH: 799
|
|
BB: 562
|
|
SL: 533
|
|
MV: 367
|
|
ST: 250
|
|
BW: 200 (nur JedeSchule.de - BW Daten kostenpflichtig!)
|
|
HB: 200
|
|
```
|
|
|
|
---
|
|
|
|
## Open Data Importer - Verfuegbare Quellen
|
|
|
|
| Bundesland | Status | Quelle | Format |
|
|
|------------|--------|--------|--------|
|
|
| NW | Funktioniert | schulministerium.nrw.de | CSV |
|
|
| BE | Funktioniert | gdi.berlin.de | WFS/GeoJSON |
|
|
| HH | Funktioniert | geodienste.hamburg.de | WFS/GML |
|
|
| SN | 404 Error | schuldatenbank.sachsen.de | API |
|
|
| BW | Kostenpflichtig | LOBW | - |
|
|
| BY | Kein Open Data | - | - |
|
|
|
|
---
|
|
|
|
## Importer-Nutzung
|
|
|
|
```bash
|
|
# Alle verfuegbaren Quellen importieren
|
|
cd /Users/benjaminadmin/Projekte/breakpilot-pwa/edu-search-service/scripts
|
|
python3 import_open_data.py --all --url http://macmini:8088
|
|
|
|
# Einzelnes Bundesland (Dry-Run)
|
|
python3 import_open_data.py --state NW --dry-run
|
|
|
|
# Mit Server-URL
|
|
python3 import_open_data.py --state HH --url http://macmini:8088
|
|
```
|
|
|
|
---
|
|
|
|
## Offene Punkte
|
|
|
|
### Bundeslaender ohne Open Data
|
|
- **BW:** Schuldaten muessen GEKAUFT werden (LOBW)
|
|
- **BY:** Keine Open Data API gefunden
|
|
- **NI, HE, RP, etc.:** Keine zentralen Open Data Quellen bekannt
|
|
|
|
### Moegliche weitere Quellen
|
|
- OSM (OpenStreetMap) - amenity=school
|
|
- Statistisches Bundesamt
|
|
- Lokale Schultraeger-Verzeichnisse
|
|
|
|
---
|
|
|
|
## Container-Status auf macmini
|
|
|
|
| Container | Port | Status |
|
|
|-----------|------|--------|
|
|
| website | 3000 | Laeuft |
|
|
| studio-v2 | 3001 | Laeuft |
|
|
| edu-search-service | 8088 | Laeuft |
|
|
|
|
---
|
|
|
|
## Wichtige URLs
|
|
|
|
- School Directory: http://macmini:3000/admin/school-directory
|
|
- School Stats API: http://macmini:8088/api/v1/schools/stats
|
|
- School Search API: http://macmini:8088/api/v1/schools?q=NAME
|
|
|
|
---
|
|
|
|
## Naechste moegliche Schritte
|
|
|
|
1. **OSM Import testen** - OpenStreetMap hat Schuldaten (amenity=school)
|
|
2. **Weitere WFS-Quellen suchen** - Andere Bundeslaender koennten Geo-Portale haben
|
|
3. **Deduplizierung** - Pruefen ob durch multiple Imports Duplikate entstanden sind
|