| Idx | Field Name | Data Type |
|---|---|---|
| * | building_id | bigint |
| * | address_id | bigint |
| Indexes | ||
| address_to_building_pk | ON building_id, address_id | |
| address_to_building_fkx | ON address_id | |
| address_to_building_fkx1 | ON building_id | |
| Foreign Keys | ||
| address_to_building_fk | address_id ↗ ❏ address(id) | |
| address_to_building_fk1 | building_id ↗ ❏ building(id) | |
| 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 | ON id | |
| building_parent_fkx | ON building_parent_id | |
| building_root_fkx | ON building_root_id | |
| building_lod0footprint_fkx | ON lod0_footprint_id | |
| building_lod0roofprint_fkx | ON lod0_roofprint_id | |
| building_lod1msrf_fkx | ON lod1_multi_surface_id | |
| building_lod2msrf_fkx | ON lod2_multi_surface_id | |
| building_lod3msrf_fkx | ON lod3_multi_surface_id | |
| building_lod4msrf_fkx | ON lod4_multi_surface_id | |
| building_lod1solid_fkx | ON lod1_solid_id | |
| building_lod2solid_fkx | ON lod2_solid_id | |
| building_lod3solid_fkx | ON lod3_solid_id | |
| building_lod4solid_fkx | ON lod4_solid_id | |
| building_objectclass_fkx | ON objectclass_id | |
| building_lod1terr_spx | ON lod1_terrain_intersection | |
| building_lod2terr_spx | ON lod2_terrain_intersection | |
| building_lod3terr_spx | ON lod3_terrain_intersection | |
| building_lod4terr_spx | ON lod4_terrain_intersection | |
| building_lod2curve_spx | ON lod2_multi_curve | |
| building_lod3curve_spx | ON lod3_multi_curve | |
| building_lod4curve_spx | ON lod4_multi_curve | |
| Foreign Keys | ||
| building_parent_fk | building_parent_id ↗ ❏ building(id) | |
| building_root_fk | building_root_id ↗ ❏ building(id) | |
| building_cityobject_fk | id ↗ ❏ cityobject | |
| building_lod0footprint_fk | lod0_footprint_id ↗ ❏ surface_geometry(id) | |
| building_lod0roofprint_fk | lod0_roofprint_id ↗ ❏ surface_geometry(id) | |
| building_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| building_lod1solid_fk | lod1_solid_id ↗ ❏ surface_geometry(id) | |
| building_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| building_lod2solid_fk | lod2_solid_id ↗ ❏ surface_geometry(id) | |
| building_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| building_lod3solid_fk | lod3_solid_id ↗ ❏ surface_geometry(id) | |
| building_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| building_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| address_to_building_fk1 | id ↙ ❏ address_to_building(building_id) | |
| bldg_inst_building_fk | id ↙ ❏ building_installation(building_id) | |
| building_parent_fk | id ↙ ❏ building(building_parent_id) | |
| building_root_fk | id ↙ ❏ building(building_root_id) | |
| room_building_fk | id ↙ ❏ room(building_id) | |
| them_surface_building_fk | id ↙ ❏ thematic_surface(building_id) | |
| 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 | ON id | |
| bldg_furn_room_fkx | ON room_id | |
| bldg_furn_lod4brep_fkx | ON lod4_brep_id | |
| bldg_furn_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bldg_furn_objclass_fkx | ON objectclass_id | |
| bldg_furn_lod4xgeom_spx | ON lod4_other_geom | |
| bldg_furn_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bldg_furn_cityobject_fk | id ↗ ❏ cityobject | |
| bldg_furn_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bldg_furn_room_fk | room_id ↗ ❏ room(id) | |
| bldg_furn_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| 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 | ON id | |
| bldg_inst_objclass_fkx | ON objectclass_id | |
| bldg_inst_building_fkx | ON building_id | |
| bldg_inst_room_fkx | ON room_id | |
| bldg_inst_lod2brep_fkx | ON lod2_brep_id | |
| bldg_inst_lod3brep_fkx | ON lod3_brep_id | |
| bldg_inst_lod4brep_fkx | ON lod4_brep_id | |
| bldg_inst_lod2impl_fkx | ON lod2_implicit_rep_id | |
| bldg_inst_lod3impl_fkx | ON lod3_implicit_rep_id | |
| bldg_inst_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bldg_inst_lod2xgeom_spx | ON lod2_other_geom | |
| bldg_inst_lod3xgeom_spx | ON lod3_other_geom | |
| bldg_inst_lod4xgeom_spx | ON lod4_other_geom | |
| bldg_inst_lod2refpt_spx | ON lod2_implicit_ref_point | |
| bldg_inst_lod3refpt_spx | ON lod3_implicit_ref_point | |
| bldg_inst_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bldg_inst_building_fk | building_id ↗ ❏ building(id) | |
| bldg_inst_cityobject_fk | id ↗ ❏ cityobject | |
| bldg_inst_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bldg_inst_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bldg_inst_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bldg_inst_room_fk | room_id ↗ ❏ room(id) | |
| bldg_inst_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| bldg_inst_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| bldg_inst_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| them_surface_bldg_inst_fk | id ↙ ❏ thematic_surface(building_installation_id) | |
| 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 | ON id | |
| cityobject_inx | ON gmlid, gmlid_codespace | |
| cityobject_objectclass_fkx | ON objectclass_id | |
| cityobject_lineage_inx | ON lineage | |
| cityobj_creation_date_inx | ON creation_date | |
| cityobj_term_date_inx | ON termination_date | |
| cityobj_last_mod_date_inx | ON last_modification_date | |
| cityobject_envelope_spx | ON envelope | |
| Referring Foreign Keys | ||
| appearance_cityobject_fk | id ↙ ❏ appearance(cityobject_id) | |
| bldg_furn_cityobject_fk | id ↙ ❏ building_furniture | |
| bldg_inst_cityobject_fk | id ↙ ❏ building_installation | |
| brd_them_srf_cityobj_fk | id ↙ ❏ bridge_thematic_surface | |
| bridge_cityobject_fk | id ↙ ❏ bridge | |
| bridge_constr_cityobj_fk | id ↙ ❏ bridge_constr_element | |
| bridge_furn_cityobject_fk | id ↙ ❏ bridge_furniture | |
| bridge_inst_cityobject_fk | id ↙ ❏ bridge_installation | |
| bridge_open_cityobject_fk | id ↙ ❏ bridge_opening | |
| bridge_room_cityobject_fk | id ↙ ❏ bridge_room | |
| building_cityobject_fk | id ↙ ❏ building | |
| city_furn_cityobject_fk | id ↙ ❏ city_furniture | |
| cityobject_member_fk | id ↙ ❏ cityobject_member(cityobject_id) | |
| ext_ref_cityobject_fk | id ↙ ❏ external_reference(cityobject_id) | |
| gen_object_cityobject_fk | id ↙ ❏ generic_cityobject | |
| general_cityobject_fk | id ↙ ❏ generalization(cityobject_id) | |
| general_generalizes_to_fk | id ↙ ❏ generalization(generalizes_to_id) | |
| genericattrib_cityobj_fk | id ↙ ❏ cityobject_genericattrib(cityobject_id) | |
| group_cityobject_fk | id ↙ ❏ cityobjectgroup | |
| group_parent_cityobj_fk | id ↙ ❏ cityobjectgroup(parent_cityobject_id) | |
| group_to_cityobject_fk | id ↙ ❏ group_to_cityobject(cityobject_id) | |
| land_use_cityobject_fk | id ↙ ❏ land_use | |
| opening_cityobject_fk | id ↙ ❏ opening | |
| plant_cover_cityobject_fk | id ↙ ❏ plant_cover | |
| relief_comp_cityobject_fk | id ↙ ❏ relief_component | |
| relief_feat_cityobject_fk | id ↙ ❏ relief_feature | |
| room_cityobject_fk | id ↙ ❏ room | |
| sol_veg_obj_cityobject_fk | id ↙ ❏ solitary_vegetat_object | |
| surface_geom_cityobj_fk | id ↙ ❏ surface_geometry(cityobject_id) | |
| them_surface_cityobject_fk | id ↙ ❏ thematic_surface | |
| traffic_area_cityobject_fk | id ↙ ❏ traffic_area | |
| tran_complex_cityobject_fk | id ↙ ❏ transportation_complex | |
| tun_hspace_cityobj_fk | id ↙ ❏ tunnel_hollow_space | |
| tun_them_srf_cityobj_fk | id ↙ ❏ tunnel_thematic_surface | |
| tunnel_cityobject_fk | id ↙ ❏ tunnel | |
| tunnel_furn_cityobject_fk | id ↙ ❏ tunnel_furniture | |
| tunnel_inst_cityobject_fk | id ↙ ❏ tunnel_installation | |
| tunnel_open_cityobject_fk | id ↙ ❏ tunnel_opening | |
| waterbnd_srf_cityobject_fk | id ↙ ❏ waterboundary_surface | |
| waterbody_cityobject_fk | id ↙ ❏ waterbody | |
| 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 | ON id | |
| opening_objectclass_fkx | ON objectclass_id | |
| opening_address_fkx | ON address_id | |
| opening_lod3msrf_fkx | ON lod3_multi_surface_id | |
| opening_lod4msrf_fkx | ON lod4_multi_surface_id | |
| opening_lod3impl_fkx | ON lod3_implicit_rep_id | |
| opening_lod4impl_fkx | ON lod4_implicit_rep_id | |
| opening_lod3refpt_spx | ON lod3_implicit_ref_point | |
| opening_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| opening_address_fk | address_id ↗ ❏ address(id) | |
| opening_cityobject_fk | id ↗ ❏ cityobject | |
| opening_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| opening_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| opening_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| opening_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| open_to_them_surface_fk | id ↙ ❏ opening_to_them_surface(opening_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | opening_id | bigint |
| * | thematic_surface_id | bigint |
| Indexes | ||
| opening_to_them_surface_pk | ON opening_id, thematic_surface_id | |
| open_to_them_surface_fkx | ON opening_id | |
| open_to_them_surface_fkx1 | ON thematic_surface_id | |
| Foreign Keys | ||
| open_to_them_surface_fk | opening_id ↗ ❏ opening(id) | |
| open_to_them_surface_fk1 | thematic_surface_id ↗ ❏ thematic_surface(id) | |
| 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 | ON id | |
| room_building_fkx | ON building_id | |
| room_lod4msrf_fkx | ON lod4_multi_surface_id | |
| room_lod4solid_fkx | ON lod4_solid_id | |
| room_objectclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| room_building_fk | building_id ↗ ❏ building(id) | |
| room_cityobject_fk | id ↗ ❏ cityobject | |
| room_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| room_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| bldg_furn_room_fk | id ↙ ❏ building_furniture(room_id) | |
| bldg_inst_room_fk | id ↙ ❏ building_installation(room_id) | |
| them_surface_room_fk | id ↙ ❏ thematic_surface(room_id) | |
| 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 | ON id | |
| them_surface_objclass_fkx | ON objectclass_id | |
| them_surface_building_fkx | ON building_id | |
| them_surface_room_fkx | ON room_id | |
| them_surface_bldg_inst_fkx | ON building_installation_id | |
| them_surface_lod2msrf_fkx | ON lod2_multi_surface_id | |
| them_surface_lod3msrf_fkx | ON lod3_multi_surface_id | |
| them_surface_lod4msrf_fkx | ON lod4_multi_surface_id | |
| Foreign Keys | ||
| them_surface_building_fk | building_id ↗ ❏ building(id) | |
| them_surface_bldg_inst_fk | building_installation_id ↗ ❏ building_installation(id) | |
| them_surface_cityobject_fk | id ↗ ❏ cityobject | |
| them_surface_room_fk | room_id ↗ ❏ room(id) | |
| them_surface_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| them_surface_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| them_surface_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| open_to_them_surface_fk1 | id ↙ ❏ opening_to_them_surface(thematic_surface_id) | |