Category Mapping Table (Normalized)

This file is the canonical category map used across adapters.

Rules

• dim_code is fixed:
  • 1 = Årsak (Primary Causal Factor)
  • 2 = Tennkilde (Heat Source)
  • 3 = Objekt (Item First Ignited)
  • 4 = Arnested (Area of Origin)
  • 5 = Bygningstype (Building Type) — populated by SSB; carried as metadata rows for BRASK and Police so cross-source rollups can resolve. See §6.
  • 6 = Bygningsalder (Building Age) — BRASK only; the same buckets are also exposed via the building_age filter axis. See §7.
• cat_code is always 3 digits and scoped per dimension:
  • x00 = synthetic aggregate row for the full dimension (not a native API category)
  • x01..x97 = native category rows in sequence for that dimension
  • x98, x99 reserved for Ikke besvart (BRIS -1 missing-answer bucket); standard_code = UNKNOWN. See §5.
• For BRASK, native_api_code is the documented numeric option id.
• For BRIS (Police/DSB/Fire Brigade), native_api_code is the schema answer alternative id (for example 407_1, 264_2, 229_10).
• BRIS question ids are numeric string ids (for example 227, 229, 264, 403, 405, 407, 269) and are not human labels with spaces.
• For SSB, native_api_code is the PxWebApi ContentsCode (for example KOSboligbranner0000).
• Category resolution at ingest: Adapters map each upstream bucket to cat_code via native_name and registry.catByNativeName (lib/data-model/adapters/_registry.ts). BRASK uses HTML row labels; BRIS uses bucket keys.
• native_api_code in the tables below is reference metadata for each source's internal numbering — not stored in categories, not used for matching.
• Request-time native codes are dimension/question ids (BRIS question ids like 407, SSB ContentsCode, BRASK query params) and filter-axis values (filters.native_code).

BRIS Source-Of-Truth Question IDs

• Årsak: Police 407 and Fire Brigade 269
• Tennkilde: DSB 264
• Objekt: Police 405 and DSB 229
• Arnested: Police 403 and DSB 227
• Strømkilde (utstyr): DSB 625 — native-only live read, never ingested (see §9)

1) Årsak (Primary Causal Factor)

dim_code = 1

2) Tennkilde (Heat Source)

dim_code = 2

3) Objekt (Item First Ignited)

dim_code = 3

4) Arnested (Area of Origin)

dim_code = 4

5) Ikke besvart (Missing-answer bucket)

BRIS aggregate responses include a -1 bucket for missions where the relevant question was not answered. It is often the largest bucket in a slice.

Ingest contract: upstream bucket key '-1' → catalog row with native_name = 'Ikke besvart' for that (source_id, dim_code) (via resolveCatCodeFromBrisBucket). The row’s standard_code is UNKNOWN — the cross-source semantic for “not answered / not reported” on that reserved slot. Other rows (e.g. Ukjent) will also carry UNKNOWN; they are distinct categories with their own cat_code and upstream labels, but the standard_code makes them equivalent.

Reserved slot: x99 (or x98 when x99 is taken — e.g. Fire Brigade Årsak uses 198).

native_api_code = -1 in this table is reference metadata for the upstream sentinel; matching at ingest uses the bucket key "-1" → native_name bridge above. See pipeline-slices-idempotency-and-triggers.md §4.1.

6) Bygningstype (Building Type)

dim_code = 5

Building Type is the only analytical dimension SSB exposes for fire counts — the dataset choice (KOSboligbranner0000 vs KOSbygningsbrann0000) IS the breakdown. BRASK and Police carry parallel rows so the same dim_code = 5 key resolves consistently across sources for cross-source rollups. The matching building_type filter rows in fire_data.filters (axis = building_type) carry the request-side identity; this section covers the category-side identity.

Allocation:

• 501 — SSB Boligbranner (RESIDENTIAL)
• 502 — SSB Bygningsbranner (ALL_BUILDINGS)
• 503, 504 — BRASK metadata rows
• 505, 506 — Police metadata rows

These are the category-side (dim 5 cross-tab) building_type rows. RESIDENTIAL mirrors the building_type filter code; ALL_BUILDINGS is the dimension-total category for cross-tab matrices — it has no filter-axis equivalent (on the filter axis, "all buildings" is a NULL FK, not a code — see filter-axes-native-to-filter-id.md §2).

Notes:

• The BRASK and Police rows here exist for cross-source identity only — the request-side selection happens via the building_type filter axis (lbNæring for BRASK, buildingTypes.ids for BRIS), not via a per-cat_code request. The 30 BRIS Bolig leaf IDs are documented in filter-axes-native-to-filter-id.md §2.
• SSB writes one fact row per slice with dim_code = 5 and cat_code = 501 or 502, plus the matching building_type_code filter id (per pipeline-slices-idempotency-and-triggers.md §4.3). PxWeb ContentsCode labels and the full table-12058 variable set: ssb-pxwebapi-tables.md. BRASK and Police keep dim_code = 5 writes off the fact path — their building_type is on the filter axis instead.

7) Bygningsalder (Building Age) — BRASK only

dim_code = 6

BRASK Utforsk axis index: BRASK_AXIS.bygningsalder / braskExplorerAxisId('bygningsalder') is 12 (ASP.NET explorer dropdown) — not analytical dim_code 6 in this section.

BRASK is the only source exposing building age. The 13 native ASP.NET option ids collapse into 7 normalized buckets (matching building_age filter axis, filter-axes-native-to-filter-id.md §3). HeatWaves keeps one category row per native option to preserve fidelity, plus the synthetic 600 aggregate.

cat_code = 600 is the synthetic "Alle" row for registry lookup only — not written to fact_yearly.

Same notes as §6: the BRASK building_age filter axis carries the same mapping at the filter table layer; this section is the category-side identity. The two share standard_code values so the registry can resolve either lookup direction. Two BRASK native values (1 and 2) collapse to the 0-5 standard bucket — when querying by normalized bucket the adapter must send both native ids.

8) SSB Nøkkeltall (Key metrics) — native-only live read

dim_code = 7, source_id = 5 (SSB table 12058)

All 34 PxWeb ContentsCode variables are catalog rows with is_native_only = true. They are not written to fact_yearly; Explore reads them live via lib/data-model/native/providers/source-5-table-12058.ts.

Group standard_code values (migration 20260608170415_ssb_dim7_standard_codes_by_group.sql):

Explore URL: cat_standard (single token). Default FIRE_AND_COMPENSATION. Legacy nokkelgruppe=brann bookmarks map to the same codes. Grouping logic: lib/data-model/ssb-nokkelgrupper.ts. Full variable list: ssb-pxwebapi-tables.md.

9) Strømkilde (utstyr) — BRIS native-only live read

dim_code = 8, source_id = 4 (DSB), BRIS question 625 («Hvilken strømkilde hadde utstyret da brannen/branntilløpet startet?»)

All rows are is_native_only = true — never written to fact_*. Explore reads them live via lib/data-model/native/providers/source-bris-restricted.ts (POST /restrictedaggregation, yearly only; same request body and bucket→cat_code resolution as the DSB ingest path). Seed migration 20260609223017_bris_native_stromkilde_catalog.sql.

Answered counts are small (low hundreds per year from 2022); the -1 bucket dominates and stays visible as its own Ikke besvart category, same as the ingested BRIS dims. New BRIS native datasets are scaffolded with node scripts/bris-native-catalog-scaffold.mjs <questionId> (probe + migration SQL + constants output; no DB writes).