project_geography

0 rows


Description

The project_geography view merges project-specific data with the unified geographical features from the uniform_features view. It links projects with their respective geographical components, including type, attributes, and location.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_id int4 10 null
feature_id int4 10 null
component_archtype_id int4 10 null
line_representation bool 1 null
component_id int4 10 null
is_deleted bool 1 null
project_name text 2147483647 null
table varchar 2147483647 null
original_fk varchar 2147483647 null
component_name text 2147483647 null
attributes json 2147483647 null
geography geography 2147483647 null
council_districts _int4 10 null
length_feet int4 10 null
feature_created_at timestamptz 35,6 null
feature_updated_at timestamptz 35,6 null
feature_created_by_user_id int4 10 null
feature_updated_by_user_id int4 10 null

View Definition