# addresses

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

Address records for units and buildings in client workspaces. Results are a UNION of unit addresses and building addresses.

| Column | Description |
| --- | --- |
| `id` | Unique identifier for the address record |
| `post_code` | Postal or ZIP code of the address |
| `lat` | Latitude coordinate of the address location |
| `lng` | Longitude coordinate of the address location |
| `country` | Name of the country where the address is located |
| `country_code` | ISO country code for the address location |
| `street1` | Primary street address line |
| `street2` | Secondary street address line |
| `city` | City or town name where the address is located |
| `region` | State, province, or region name |
| `addressable_type` | Type of entity that this address belongs to |
| `addressable_id` | Identifier of the entity that this address belongs to |
| `addressable_scope` | Scope or context of the address relationship |
| `created_at` | Timestamp indicating when the address record was created |
| `updated_at` | Timestamp indicating when the address record was last updated |
| `timezone` | Time zone of the address location |
| `floor` | Floor number or level in the building |
| `timestamp` | Date when the table was last synchronized |