# Expressway.ph — EV Charging Dataset (schema + lineage)

Re-modelled from an aggregated public charging-point listing into Expressway.ph's own schema. PlugShare's proprietary fields (internal IDs, map-pin codes, their rating, their asset/API URLs) are **dropped or translated into plain facts**.

## Files
- `expressway-ph-ev-charging.csv` — **1,434** sites (de-duped), internal model. Keeps `source_ref` for lineage.
- `expressway-ph-ev-charging-public.csv` — **984** public sites only, `source_ref` removed.

## Field mapping (their internal → Expressway model)

| Expressway field | Source field | How it's derived |
|---|---|---|
| `station_ref` | — | Expressway's own ID, `EVPH-00001` (sequential by province/name) |
| `site_name` | `name` | as-is; blank private chargers → "Unnamed charging point" |
| `operator` | `network_id` + `name` | Tesla resolved from network code; others matched from brand in the name (best-effort; blank if unknown) |
| `access_type` | `access` (1/2/3) | 1→Public, 2→Restricted, 3→Private |
| `charger_class` | `is_fast_charger` | true→"DC Fast Charging", false→"AC Standard" |
| `connector_standards` | `connector_types` | re-worded to industry names (see below) |
| `max_power_kw` | outlet `kilowatts` | max non-null across the site (often blank — not in list feed) |
| `charge_points` | `station_count` | number of charging units |
| `total_connectors` | nested `outlets` | counted |
| `current_status` | `coming_soon`/`under_repair` | → Operational / Coming Soon / Under Repair |
| `province` | parsed from `address` | best-effort province match |
| `full_address` | `address` | as-is |
| `latitude`/`longitude` | `latitude`/`longitude` | as-is |
| `last_verified` | — | data pull date (2026-06-22) |
| `source_ref` | `id` | `PS-<id>` — **internal lineage only**, removed from the public file |

## Dropped (PlugShare-proprietary, not carried over)
- `id` → replaced by `station_ref` (kept only as internal `source_ref`)
- `url` (`api.plugshare.com/...`) and `icon` (`assets.plugshare.com/...`) — their domains
- `icon_type` — their map-pin taxonomy (decoded below, then discarded)
- `score` — their proprietary community rating
- raw `network_id` — replaced by `operator` name where resolvable

## Decoded PlugShare internal codes (for reference)
- **icon_type**: `G`=standard, `Y`=high-power/fast, `H`=home/private, `B`=other; suffix `R`=planned/coming-soon. (Confirmed: all 280 `H` rows = the private set.)
- **network_id**: only Tesla is named in the public config (8=Supercharger, 35=Tesla Destination); PH local networks (1831, 1610, 1850, …) are unnamed there.
- **access**: 1=Public, 2=Restricted, 3=Private/Home.

## Connector wording
CCS2→CCS Combo 2 (DC) · CHAdeMO→CHAdeMO (DC) · GB/T (Fast)→GB/T (DC) · GB/T→GB/T (AC) · Type 2→Type 2 / Mennekes (AC) · J-1772→Type 1 / J1772 (AC) · Three Phase→Three-Phase (AC) · NEMA 14-50→NEMA 14-50 (AC) · Wall/Wall (BS1363)/Wall (Euro)→Domestic Socket.

## Provenance & usage note (important)
Renaming fields makes this **Expressway.ph's schema**, but the *compilation* was sourced from PlugShare. The underlying facts (locations, addresses, connectors) are public; PlugShare's compilation and Terms of Use still apply. Safe for **internal** analysis/planning. Before **publishing** (e.g. on the `/ev-charging` page), confirm sourcing approach — ideally cross-verify/refresh against an open or first-party source so the published asset stands on its own. `source_ref` is retained internally so lineage is never lost.