3DCityDB v4 - Database Schema - Tunnel
Generated using DbSchema
HTML Mode
Click Here to View same Document in Interactive HTML Mode
Tunnel Layout
Tables
- citydb.cityobject 2. citydb.implicit_geometry 3. citydb.surface_geometry 4. citydb.tunnel 5. citydb.tunnel_furniture 6. citydb.tunnel_hollow_space 7. citydb.tunnel_installation 8. citydb.tunnel_open_to_them_srf 9. citydb.tunnel_opening 10. citydb.tunnel_thematic_surface
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 |
Table implicit_geometry
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('implicit_geometry_seq'::regclass) |
| mime_type | varchar(256) | |
| 🔎 | reference_to_library | varchar(4000) |
| library_object | bytea | |
| 🔎 ⬈ | relative_brep_id | bigint |
| relative_other_geom | geometry | |
| Indexes | ||
| 🔑 | implicit_geometry_pk | |
| 🔎 | implicit_geom_ref2lib_inx | |
| 🔎 | implicit_geom_brep_fkx | |
| Foreign Keys | ||
| implicit_geom_brep_fk | ( relative_brep_id ) ref citydb.surface_geometry (id) |
Table surface_geometry
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('surface_geometry_seq'::regclass) |
| 🔎 | gmlid | varchar(256) |
| 🔎 | gmlid_codespace | varchar(1000) |
| 🔎 ⬈ | parent_id | bigint |
| 🔎 ⬈ | root_id | bigint |
| is_solid | numeric | |
| is_composite | numeric | |
| is_triangulated | numeric | |
| is_xlink | numeric | |
| is_reverse | numeric | |
| 🔎 | solid_geometry | geometry |
| 🔎 | geometry | geometry |
| implicit_geometry | geometry | |
| 🔎 ⬈ | cityobject_id | bigint |
| Indexes | ||
| 🔑 | surface_geometry_pk | |
| 🔎 | surface_geom_inx | |
| 🔎 | surface_geom_parent_fkx | |
| 🔎 | surface_geom_root_fkx | |
| 🔎 | surface_geom_cityobj_fkx | |
| 🔎 | surface_geom_solid_spx | |
| 🔎 | surface_geom_spx | |
| Foreign Keys | ||
| surface_geom_cityobj_fk | ( cityobject_id ) ref citydb.cityobject (id) | |
| surface_geom_parent_fk | ( parent_id ) ref citydb.surface_geometry (id) | |
| surface_geom_root_fk | ( root_id ) ref citydb.surface_geometry (id) |
Table tunnel
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | tunnel_parent_id | bigint |
| 🔎 ⬈ | tunnel_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 | |
| 🔎 | 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 | ||
| 🔑 | tunnel_pk | |
| 🔎 | tunnel_parent_fkx | |
| 🔎 | tunnel_root_fkx | |
| 🔎 | tunnel_lod1msrf_fkx | |
| 🔎 | tunnel_lod2msrf_fkx | |
| 🔎 | tunnel_lod3msrf_fkx | |
| 🔎 | tunnel_lod4msrf_fkx | |
| 🔎 | tunnel_lod1solid_fkx | |
| 🔎 | tunnel_lod2solid_fkx | |
| 🔎 | tunnel_lod3solid_fkx | |
| 🔎 | tunnel_lod4solid_fkx | |
| 🔎 | tunnel_objectclass_fkx | |
| 🔎 | tunnel_lod1terr_spx | |
| 🔎 | tunnel_lod2terr_spx | |
| 🔎 | tunnel_lod3terr_spx | |
| 🔎 | tunnel_lod4terr_spx | |
| 🔎 | tunnel_lod2curve_spx | |
| 🔎 | tunnel_lod3curve_spx | |
| 🔎 | tunnel_lod4curve_spx | |
| Foreign Keys | ||
| tunnel_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod1solid_fk | ( lod1_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod2solid_fk | ( lod2_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod3solid_fk | ( lod3_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_parent_fk | ( tunnel_parent_id ) ref citydb.tunnel (id) | |
| tunnel_root_fk | ( tunnel_root_id ) ref citydb.tunnel (id) |
Table tunnel_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) | |
| 🔎 ⬈ | tunnel_hollow_space_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 | ||
| 🔑 | tunnel_furniture_pk | |
| 🔎 | tunnel_furn_hspace_fkx | |
| 🔎 | tunnel_furn_lod4brep_fkx | |
| 🔎 | tunnel_furn_lod4impl_fkx | |
| 🔎 | tunnel_furn_objclass_fkx | |
| 🔎 | tunnel_furn_lod4xgeom_spx | |
| 🔎 | tunnel_furn_lod4refpt_spx | |
| Foreign Keys | ||
| tunnel_furn_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_furn_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_furn_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_furn_hspace_fk | ( tunnel_hollow_space_id ) ref citydb.tunnel_hollow_space (id) |
Table tunnel_hollow_space
| 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) | |
| 🔎 ⬈ | tunnel_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | tunnel_hollow_space_pk | |
| 🔎 | tun_hspace_tunnel_fkx | |
| 🔎 | tun_hspace_lod4msrf_fkx | |
| 🔎 | tun_hspace_lod4solid_fkx | |
| 🔎 | tun_hspace_objclass_fkx | |
| Foreign Keys | ||
| tun_hspace_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| tun_hspace_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_hspace_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) | |
| tun_hspace_tunnel_fk | ( tunnel_id ) ref citydb.tunnel (id) |
Table tunnel_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) | |
| 🔎 ⬈ | tunnel_id | bigint |
| 🔎 ⬈ | tunnel_hollow_space_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 | ||
| 🔑 | tunnel_installation_pk | |
| 🔎 | tunnel_inst_objclass_fkx | |
| 🔎 | tunnel_inst_tunnel_fkx | |
| 🔎 | tunnel_inst_hspace_fkx | |
| 🔎 | tunnel_inst_lod2brep_fkx | |
| 🔎 | tunnel_inst_lod3brep_fkx | |
| 🔎 | tunnel_inst_lod4brep_fkx | |
| 🔎 | tunnel_inst_lod2impl_fkx | |
| 🔎 | tunnel_inst_lod3impl_fkx | |
| 🔎 | tunnel_inst_lod4impl_fkx | |
| 🔎 | tunnel_inst_lod2xgeom_spx | |
| 🔎 | tunnel_inst_lod3xgeom_spx | |
| 🔎 | tunnel_inst_lod4xgeom_spx | |
| 🔎 | tunnel_inst_lod2refpt_spx | |
| 🔎 | tunnel_inst_lod3refpt_spx | |
| 🔎 | tunnel_inst_lod4refpt_spx | |
| Foreign Keys | ||
| tunnel_inst_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_inst_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_inst_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_inst_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_inst_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_inst_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_inst_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_inst_tunnel_fk | ( tunnel_id ) ref citydb.tunnel (id) | |
| tunnel_inst_hspace_fk | ( tunnel_hollow_space_id ) ref citydb.tunnel_hollow_space (id) |
Table tunnel_open_to_them_srf
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | tunnel_opening_id | bigint |
| *🔑 ⬈ | tunnel_thematic_surface_id | bigint |
| Indexes | ||
| 🔑 | tunnel_open_to_them_srf_pk | |
| 🔎 | tun_open_to_them_srf_fkx | |
| 🔎 | tun_open_to_them_srf_fkx1 | |
| Foreign Keys | ||
| tun_open_to_them_srf_fk | ( tunnel_opening_id ) ref citydb.tunnel_opening (id) | |
| tun_open_to_them_srf_fk1 | ( tunnel_thematic_surface_id ) ref citydb.tunnel_thematic_surface (id) |
Table tunnel_opening
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | 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 | ||
| 🔑 | tunnel_opening_pk | |
| 🔎 | tunnel_open_objclass_fkx | |
| 🔎 | tunnel_open_lod3msrf_fkx | |
| 🔎 | tunnel_open_lod4msrf_fkx | |
| 🔎 | tunnel_open_lod3impl_fkx | |
| 🔎 | tunnel_open_lod4impl_fkx | |
| 🔎 | tunnel_open_lod3refpt_spx | |
| 🔎 | tunnel_open_lod4refpt_spx | |
| Foreign Keys | ||
| tunnel_open_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_open_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_open_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_open_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_open_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table tunnel_thematic_surface
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | tunnel_id | bigint |
| 🔎 ⬈ | tunnel_hollow_space_id | bigint |
| 🔎 ⬈ | tunnel_installation_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| Indexes | ||
| 🔑 | tunnel_thematic_surface_pk | |
| 🔎 | tun_them_srf_objclass_fkx | |
| 🔎 | tun_them_srf_tunnel_fkx | |
| 🔎 | tun_them_srf_hspace_fkx | |
| 🔎 | tun_them_srf_tun_inst_fkx | |
| 🔎 | tun_them_srf_lod2msrf_fkx | |
| 🔎 | tun_them_srf_lod3msrf_fkx | |
| 🔎 | tun_them_srf_lod4msrf_fkx | |
| Foreign Keys | ||
| tun_them_srf_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| tun_them_srf_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_them_srf_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_them_srf_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_them_srf_tunnel_fk | ( tunnel_id ) ref citydb.tunnel (id) | |
| tun_them_srf_hspace_fk | ( tunnel_hollow_space_id ) ref citydb.tunnel_hollow_space (id) | |
| tun_them_srf_tun_inst_fk | ( tunnel_installation_id ) ref citydb.tunnel_installation (id) |