3DCityDB v4 - Database Schema - Building
Generated using DbSchema
HTML Mode
Click Here to View same Document in Interactive HTML Mode
Building Layout
Tables
- citydb.address_to_building 2. citydb.building 3. citydb.building_furniture 4. citydb.building_installation 5. citydb.cityobject 6. citydb.opening 7. citydb.opening_to_them_surface 8. citydb.room 9. citydb.thematic_surface
Table address_to_building
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | building_id | bigint |
| *🔑 ⬈ | address_id | bigint |
| Indexes | ||
| 🔑 | address_to_building_pk | |
| 🔎 | address_to_building_fkx | |
| 🔎 | address_to_building_fkx1 | |
| Foreign Keys | ||
| address_to_building_fk | ( address_id ) ref citydb.address (id) | |
| address_to_building_fk1 | ( building_id ) ref citydb.building (id) |
Table building
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | building_parent_id | bigint |
| 🔎 ⬈ | building_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 | |
| roof_type | varchar(256) | |
| roof_type_codespace | varchar(4000) | |
| measured_height | double precision | |
| measured_height_unit | varchar(4000) | |
| storeys_above_ground | numeric(8,0) | |
| storeys_below_ground | numeric(8,0) | |
| storey_heights_above_ground | varchar(4000) | |
| storey_heights_ag_unit | varchar(4000) | |
| storey_heights_below_ground | varchar(4000) | |
| storey_heights_bg_unit | varchar(4000) | |
| 🔎 | 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 |
| 🔎 ⬈ | lod0_footprint_id | bigint |
| 🔎 ⬈ | lod0_roofprint_id | bigint |
| 🔎 ⬈ | 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 | ||
| 🔑 | building_pk | |
| 🔎 | building_parent_fkx | |
| 🔎 | building_root_fkx | |
| 🔎 | building_lod0footprint_fkx | |
| 🔎 | building_lod0roofprint_fkx | |
| 🔎 | building_lod1msrf_fkx | |
| 🔎 | building_lod2msrf_fkx | |
| 🔎 | building_lod3msrf_fkx | |
| 🔎 | building_lod4msrf_fkx | |
| 🔎 | building_lod1solid_fkx | |
| 🔎 | building_lod2solid_fkx | |
| 🔎 | building_lod3solid_fkx | |
| 🔎 | building_lod4solid_fkx | |
| 🔎 | building_objectclass_fkx | |
| 🔎 | building_lod1terr_spx | |
| 🔎 | building_lod2terr_spx | |
| 🔎 | building_lod3terr_spx | |
| 🔎 | building_lod4terr_spx | |
| 🔎 | building_lod2curve_spx | |
| 🔎 | building_lod3curve_spx | |
| 🔎 | building_lod4curve_spx | |
| Foreign Keys | ||
| building_parent_fk | ( building_parent_id ) ref citydb.building (id) | |
| building_root_fk | ( building_root_id ) ref citydb.building (id) | |
| building_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| building_lod0footprint_fk | ( lod0_footprint_id ) ref citydb.surface_geometry (id) | |
| building_lod0roofprint_fk | ( lod0_roofprint_id ) ref citydb.surface_geometry (id) | |
| building_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod1solid_fk | ( lod1_solid_id ) ref citydb.surface_geometry (id) | |
| building_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod2solid_fk | ( lod2_solid_id ) ref citydb.surface_geometry (id) | |
| building_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod3solid_fk | ( lod3_solid_id ) ref citydb.surface_geometry (id) | |
| building_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table building_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) | |
| 🔎 ⬈ | 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 | ||
| 🔑 | building_furniture_pk | |
| 🔎 | bldg_furn_room_fkx | |
| 🔎 | bldg_furn_lod4brep_fkx | |
| 🔎 | bldg_furn_lod4impl_fkx | |
| 🔎 | bldg_furn_objclass_fkx | |
| 🔎 | bldg_furn_lod4xgeom_spx | |
| 🔎 | bldg_furn_lod4refpt_spx | |
| Foreign Keys | ||
| bldg_furn_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bldg_furn_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_furn_room_fk | ( room_id ) ref citydb.room (id) | |
| bldg_furn_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table building_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) | |
| 🔎 ⬈ | building_id | bigint |
| 🔎 ⬈ | 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 | ||
| 🔑 | building_installation_pk | |
| 🔎 | bldg_inst_objclass_fkx | |
| 🔎 | bldg_inst_building_fkx | |
| 🔎 | bldg_inst_room_fkx | |
| 🔎 | bldg_inst_lod2brep_fkx | |
| 🔎 | bldg_inst_lod3brep_fkx | |
| 🔎 | bldg_inst_lod4brep_fkx | |
| 🔎 | bldg_inst_lod2impl_fkx | |
| 🔎 | bldg_inst_lod3impl_fkx | |
| 🔎 | bldg_inst_lod4impl_fkx | |
| 🔎 | bldg_inst_lod2xgeom_spx | |
| 🔎 | bldg_inst_lod3xgeom_spx | |
| 🔎 | bldg_inst_lod4xgeom_spx | |
| 🔎 | bldg_inst_lod2refpt_spx | |
| 🔎 | bldg_inst_lod3refpt_spx | |
| 🔎 | bldg_inst_lod4refpt_spx | |
| Foreign Keys | ||
| bldg_inst_building_fk | ( building_id ) ref citydb.building (id) | |
| bldg_inst_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bldg_inst_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_inst_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_inst_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_inst_room_fk | ( room_id ) ref citydb.room (id) | |
| bldg_inst_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| bldg_inst_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| bldg_inst_lod4brep_fk | ( lod4_brep_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 |
Table 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 | ||
| 🔑 | opening_pk | |
| 🔎 | opening_objectclass_fkx | |
| 🔎 | opening_address_fkx | |
| 🔎 | opening_lod3msrf_fkx | |
| 🔎 | opening_lod4msrf_fkx | |
| 🔎 | opening_lod3impl_fkx | |
| 🔎 | opening_lod4impl_fkx | |
| 🔎 | opening_lod3refpt_spx | |
| 🔎 | opening_lod4refpt_spx | |
| Foreign Keys | ||
| opening_address_fk | ( address_id ) ref citydb.address (id) | |
| opening_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| opening_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| opening_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| opening_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| opening_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table opening_to_them_surface
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | opening_id | bigint |
| *🔑 ⬈ | thematic_surface_id | bigint |
| Indexes | ||
| 🔑 | opening_to_them_surface_pk | |
| 🔎 | open_to_them_surface_fkx | |
| 🔎 | open_to_them_surface_fkx1 | |
| Foreign Keys | ||
| open_to_them_surface_fk | ( opening_id ) ref citydb.opening (id) | |
| open_to_them_surface_fk1 | ( thematic_surface_id ) ref citydb.thematic_surface (id) |
Table 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) | |
| 🔎 ⬈ | building_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | room_pk | |
| 🔎 | room_building_fkx | |
| 🔎 | room_lod4msrf_fkx | |
| 🔎 | room_lod4solid_fkx | |
| 🔎 | room_objectclass_fkx | |
| Foreign Keys | ||
| room_building_fk | ( building_id ) ref citydb.building (id) | |
| room_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| room_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| room_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table thematic_surface
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | building_id | bigint |
| 🔎 ⬈ | room_id | bigint |
| 🔎 ⬈ | building_installation_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| Indexes | ||
| 🔑 | thematic_surface_pk | |
| 🔎 | them_surface_objclass_fkx | |
| 🔎 | them_surface_building_fkx | |
| 🔎 | them_surface_room_fkx | |
| 🔎 | them_surface_bldg_inst_fkx | |
| 🔎 | them_surface_lod2msrf_fkx | |
| 🔎 | them_surface_lod3msrf_fkx | |
| 🔎 | them_surface_lod4msrf_fkx | |
| Foreign Keys | ||
| them_surface_building_fk | ( building_id ) ref citydb.building (id) | |
| them_surface_bldg_inst_fk | ( building_installation_id ) ref citydb.building_installation (id) | |
| them_surface_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| them_surface_room_fk | ( room_id ) ref citydb.room (id) | |
| them_surface_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| them_surface_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| them_surface_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |