Skip to content

addresses

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