Entity site_property

• There are now two site property entities, figure out why and which you want

an entity Roger created 2026-03-03

so that we can have both the RAÄ number and Lämnings number so that both sorts of information can be included as properties of the site

• create entity site_property, with a site_propety_id in the basic tab:
• select the columns lamningsnummer, raanr, and socken in the UNNEST tab:
• Enable Unnest,
• under Value variables choose lamningsnummer, raanr under Columns to unpivot:
• set Variable name Column to property_type
• set Name for the new column containing variable names to property_value
• wait for Roger to figure out how to pull in the full_raa_nu instead of the raanr, then edit this this gives:

name: site_property
type: entity
system_id: system_id
keys: []
columns:
  - lamningsnummer
  - raanr
  - socken
public_id: site_property_id
source: datasheet
unnest:
  id_vars: []
  value_vars:
    - lamningsnummer
    - raanr
  var_name: property_type
  value_name: property_value
```