3DCityDB v4 - Database Schema - Bridge
Generated using DbSchema
HTML Mode
Click Here to View same Document in Interactive HTML Mode
Bridge Layout
Tables
- citydb.address_to_bridge 2. citydb.bridge 3. citydb.bridge_constr_element 4. citydb.bridge_furniture 5. citydb.bridge_installation 6. citydb.bridge_open_to_them_srf 7. citydb.bridge_opening 8. citydb.bridge_room 9. citydb.bridge_thematic_surface 10. citydb.cityobject
Table address_to_bridge
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | bridge_id | bigint |
| *🔑 ⬈ | address_id | bigint |
| Indexes | ||
| 🔑 | address_to_bridge_pk | |
| 🔎 | address_to_bridge_fkx | |
| 🔎 | address_to_bridge_fkx1 | |
| Foreign Keys | ||
| address_to_bridge_fk | ( address_id ) ref citydb.address (id) | |
| address_to_bridge_fk1 | ( bridge_id ) ref citydb.bridge (id) |
Table bridge
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | bridge_parent_id | bigint |
| 🔎 ⬈ | bridge_root_id | bigint |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| year_of_construction | date | |
| year_of_demolition | date | |
| is_movable | numeric | |
| 🔎 | lod1_terrain_intersection | geometry |
| 🔎 | lod2_terrain_intersection | geometry |
| 🔎 | lod3_terrain_intersection | geometry |
| 🔎 | lod4_terrain_intersection | geometry |
| 🔎 | lod2_multi_curve | geometry |
| 🔎 | lod3_multi_curve | geometry |
| 🔎 | lod4_multi_curve | geometry |
| 🔎 ⬈ | lod1_multi_surface_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod1_solid_id | bigint |
| 🔎 ⬈ | lod2_solid_id | bigint |
| 🔎 ⬈ | lod3_solid_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | bridge_pk | |
| 🔎 | bridge_parent_fkx | |
| 🔎 | bridge_root_fkx | |
| 🔎 | bridge_lod1msrf_fkx | |
| 🔎 | bridge_lod2msrf_fkx | |
| 🔎 | bridge_lod3msrf_fkx | |
| 🔎 | bridge_lod4msrf_fkx | |
| 🔎 | bridge_lod1solid_fkx | |
| 🔎 | bridge_lod2solid_fkx | |
| 🔎 | bridge_lod3solid_fkx | |
| 🔎 | bridge_lod4solid_fkx | |
| 🔎 | bridge_objectclass_fkx | |
| 🔎 | bridge_lod1terr_spx | |
| 🔎 | bridge_lod2terr_spx | |
| 🔎 | bridge_lod3terr_spx | |
| 🔎 | bridge_lod4terr_spx | |
| 🔎 | bridge_lod2curve_spx | |
| 🔎 | bridge_lod3curve_spx | |
| 🔎 | bridge_lod4curve_spx | |
| Foreign Keys | ||
| bridge_parent_fk | ( bridge_parent_id ) ref citydb.bridge (id) | |
| bridge_root_fk | ( bridge_root_id ) ref citydb.bridge (id) | |
| bridge_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod1solid_fk | ( lod1_solid_id ) ref citydb.surface_geometry (id) | |
| bridge_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod2solid_fk | ( lod2_solid_id ) ref citydb.surface_geometry (id) | |
| bridge_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod3solid_fk | ( lod3_solid_id ) ref citydb.surface_geometry (id) | |
| bridge_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table bridge_constr_element
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | bridge_id | bigint |
| 🔎 | lod1_terrain_intersection | geometry |
| 🔎 | lod2_terrain_intersection | geometry |
| 🔎 | lod3_terrain_intersection | geometry |
| 🔎 | lod4_terrain_intersection | geometry |
| 🔎 ⬈ | lod1_brep_id | bigint |
| 🔎 ⬈ | lod2_brep_id | bigint |
| 🔎 ⬈ | lod3_brep_id | bigint |
| 🔎 ⬈ | lod4_brep_id | bigint |
| 🔎 | lod1_other_geom | geometry |
| 🔎 | lod2_other_geom | geometry |
| 🔎 | lod3_other_geom | geometry |
| 🔎 | lod4_other_geom | geometry |
| 🔎 ⬈ | lod1_implicit_rep_id | bigint |
| 🔎 ⬈ | lod2_implicit_rep_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod1_implicit_ref_point | geometry |
| 🔎 | lod2_implicit_ref_point | geometry |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod1_implicit_transformation | varchar(1000) | |
| lod2_implicit_transformation | varchar(1000) | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | bridge_constr_element_pk | |
| 🔎 | bridge_constr_bridge_fkx | |
| 🔎 | bridge_constr_lod1brep_fkx | |
| 🔎 | bridge_constr_lod2brep_fkx | |
| 🔎 | bridge_constr_lod3brep_fkx | |
| 🔎 | bridge_constr_lod4brep_fkx | |
| 🔎 | bridge_constr_lod1impl_fkx | |
| 🔎 | bridge_constr_lod2impl_fkx | |
| 🔎 | bridge_constr_lod3impl_fkx | |
| 🔎 | bridge_constr_lod4impl_fkx | |
| 🔎 | bridge_constr_objclass_fkx | |
| 🔎 | bridge_constr_lod1terr_spx | |
| 🔎 | bridge_constr_lod2terr_spx | |
| 🔎 | bridge_constr_lod3terr_spx | |
| 🔎 | bridge_constr_lod4terr_spx | |
| 🔎 | bridge_const_lod1xgeom_spx | |
| 🔎 | bridge_const_lod2xgeom_spx | |
| 🔎 | bridge_const_lod3xgeom_spx | |
| 🔎 | bridge_const_lod4xgeom_spx | |
| 🔎 | bridge_const_lod1refpt_spx | |
| 🔎 | bridge_const_lod2refpt_spx | |
| 🔎 | bridge_const_lod3refpt_spx | |
| 🔎 | bridge_const_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_constr_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| bridge_constr_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_constr_lod1impl_fk | ( lod1_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod1brep_fk | ( lod1_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_constr_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_constr_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_constr_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table bridge_furniture
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | bridge_room_id | bigint |
| 🔎 ⬈ | lod4_brep_id | bigint |
| 🔎 | lod4_other_geom | geometry |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | bridge_furniture_pk | |
| 🔎 | bridge_furn_brd_room_fkx | |
| 🔎 | bridge_furn_lod4brep_fkx | |
| 🔎 | bridge_furn_lod4impl_fkx | |
| 🔎 | bridge_furn_objclass_fkx | |
| 🔎 | bridge_furn_lod4xgeom_spx | |
| 🔎 | bridge_furn_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_furn_brd_room_fk | ( bridge_room_id ) ref citydb.bridge_room (id) | |
| bridge_furn_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_furn_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_furn_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table bridge_installation
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | bridge_id | bigint |
| 🔎 ⬈ | bridge_room_id | bigint |
| 🔎 ⬈ | lod2_brep_id | bigint |
| 🔎 ⬈ | lod3_brep_id | bigint |
| 🔎 ⬈ | lod4_brep_id | bigint |
| 🔎 | lod2_other_geom | geometry |
| 🔎 | lod3_other_geom | geometry |
| 🔎 | lod4_other_geom | geometry |
| 🔎 ⬈ | lod2_implicit_rep_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod2_implicit_ref_point | geometry |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod2_implicit_transformation | varchar(1000) | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | bridge_installation_pk | |
| 🔎 | bridge_inst_objclass_fkx | |
| 🔎 | bridge_inst_bridge_fkx | |
| 🔎 | bridge_inst_brd_room_fkx | |
| 🔎 | bridge_inst_lod2brep_fkx | |
| 🔎 | bridge_inst_lod3brep_fkx | |
| 🔎 | bridge_inst_lod4brep_fkx | |
| 🔎 | bridge_inst_lod2impl_fkx | |
| 🔎 | bridge_inst_lod3impl_fkx | |
| 🔎 | bridge_inst_lod4impl_fkx | |
| 🔎 | bridge_inst_lod2xgeom_spx | |
| 🔎 | bridge_inst_lod3xgeom_spx | |
| 🔎 | bridge_inst_lod4xgeom_spx | |
| 🔎 | bridge_inst_lod2refpt_spx | |
| 🔎 | bridge_inst_lod3refpt_spx | |
| 🔎 | bridge_inst_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_inst_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| bridge_inst_brd_room_fk | ( bridge_room_id ) ref citydb.bridge_room (id) | |
| bridge_inst_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_inst_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_inst_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_inst_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_inst_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_inst_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_inst_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table bridge_open_to_them_srf
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | bridge_opening_id | bigint |
| *🔑 ⬈ | bridge_thematic_surface_id | bigint |
| Indexes | ||
| 🔑 | bridge_open_to_them_srf_pk | |
| 🔎 | brd_open_to_them_srf_fkx | |
| 🔎 | brd_open_to_them_srf_fkx1 | |
| Foreign Keys | ||
| brd_open_to_them_srf_fk | ( bridge_opening_id ) ref citydb.bridge_opening (id) | |
| brd_open_to_them_srf_fk1 | ( bridge_thematic_surface_id ) ref citydb.bridge_thematic_surface (id) |
Table bridge_opening
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | address_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | bridge_opening_pk | |
| 🔎 | bridge_open_objclass_fkx | |
| 🔎 | bridge_open_address_fkx | |
| 🔎 | bridge_open_lod3msrf_fkx | |
| 🔎 | bridge_open_lod4msrf_fkx | |
| 🔎 | bridge_open_lod3impl_fkx | |
| 🔎 | bridge_open_lod4impl_fkx | |
| 🔎 | bridge_open_lod3refpt_spx | |
| 🔎 | bridge_open_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_open_address_fk | ( address_id ) ref citydb.address (id) | |
| bridge_open_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_open_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_open_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_open_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_open_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table bridge_room
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | bridge_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | bridge_room_pk | |
| 🔎 | bridge_room_bridge_fkx | |
| 🔎 | bridge_room_lod4msrf_fkx | |
| 🔎 | bridge_room_lod4solid_fkx | |
| 🔎 | bridge_room_objclass_fkx | |
| Foreign Keys | ||
| bridge_room_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| bridge_room_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_room_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_room_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table bridge_thematic_surface
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | bridge_id | bigint |
| 🔎 ⬈ | bridge_room_id | bigint |
| 🔎 ⬈ | bridge_installation_id | bigint |
| 🔎 ⬈ | bridge_constr_element_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| Indexes | ||
| 🔑 | bridge_thematic_surface_pk | |
| 🔎 | brd_them_srf_objclass_fkx | |
| 🔎 | brd_them_srf_bridge_fkx | |
| 🔎 | brd_them_srf_brd_room_fkx | |
| 🔎 | brd_them_srf_brd_inst_fkx | |
| 🔎 | brd_them_srf_brd_const_fkx | |
| 🔎 | brd_them_srf_lod2msrf_fkx | |
| 🔎 | brd_them_srf_lod3msrf_fkx | |
| 🔎 | brd_them_srf_lod4msrf_fkx | |
| Foreign Keys | ||
| brd_them_srf_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| brd_them_srf_brd_const_fk | ( bridge_constr_element_id ) ref citydb.bridge_constr_element (id) | |
| brd_them_srf_brd_inst_fk | ( bridge_installation_id ) ref citydb.bridge_installation (id) | |
| brd_them_srf_brd_room_fk | ( bridge_room_id ) ref citydb.bridge_room (id) | |
| brd_them_srf_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| brd_them_srf_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| brd_them_srf_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| brd_them_srf_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table cityobject
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('cityobject_seq'::regclass) |
| *🔎 | objectclass_id | integer |
| 🔎 | gmlid | varchar(256) |
| 🔎 | gmlid_codespace | varchar(1000) |
| name | varchar(1000) | |
| name_codespace | varchar(4000) | |
| description | varchar(4000) | |
| 🔎 | envelope | geometry |
| 🔎 | creation_date | timestamptz |
| 🔎 | termination_date | timestamptz |
| relative_to_terrain | varchar(256) | |
| relative_to_water | varchar(256) | |
| 🔎 | last_modification_date | timestamptz |
| updating_person | varchar(256) | |
| reason_for_update | varchar(4000) | |
| 🔎 | lineage | varchar(256) |
| xml_source | text | |
| Indexes | ||
| 🔑 | cityobject_pk | |
| 🔎 | cityobject_inx | |
| 🔎 | cityobject_objectclass_fkx | |
| 🔎 | cityobject_lineage_inx | |
| 🔎 | cityobj_creation_date_inx | |
| 🔎 | cityobj_term_date_inx | |
| 🔎 | cityobj_last_mod_date_inx | |
| 🔎 | cityobject_envelope_spx |