| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('address_seq'::regclass) |
| gmlid | varchar(256) | |
| gmlid_codespace | varchar(1000) | |
| street | varchar(1000) | |
| house_number | varchar(256) | |
| po_box | varchar(256) | |
| zip_code | varchar(256) | |
| city | varchar(256) | |
| state | varchar(256) | |
| country | varchar(256) | |
| multi_point | geometry | |
| xal_source | text | |
| Indexes | ||
| address_pk | ON id | |
| address_inx | ON gmlid, gmlid_codespace | |
| address_point_spx | ON multi_point | |
| Referring Foreign Keys | ||
| address_to_bridge_fk | id ↙ ❏ address_to_bridge(address_id) | |
| address_to_building_fk | id ↙ ❏ address_to_building(address_id) | |
| bridge_open_address_fk | id ↙ ❏ bridge_opening(address_id) | |
| opening_address_fk | id ↙ ❏ opening(address_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | bridge_id | bigint |
| * | address_id | bigint |
| Indexes | ||
| address_to_bridge_pk | ON bridge_id, address_id | |
| address_to_bridge_fkx | ON address_id | |
| address_to_bridge_fkx1 | ON bridge_id | |
| Foreign Keys | ||
| address_to_bridge_fk | address_id ↗ ❏ address(id) | |
| address_to_bridge_fk1 | bridge_id ↗ ❏ bridge(id) | |
| 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 | integer DEFAULT nextval('ade_seq'::regclass) |
| * | adeid | varchar(256) |
| * | name | varchar(1000) |
| description | varchar(4000) | |
| version | varchar(50) | |
| * | db_prefix | varchar(10) |
| xml_schemamapping_file | text | |
| drop_db_script | text | |
| creation_date | timestamptz | |
| creation_person | varchar(256) | |
| Indexes | ||
| ade_pk | ON id | |
| Referring Foreign Keys | ||
| schema_ade_fk | id ↙ ❏ schema(ade_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | child_id | integer |
| * | parent_id | integer |
| min_occurs | integer | |
| max_occurs | integer | |
| is_composite | numeric |
| Idx | Field Name | Data Type |
|---|---|---|
| * | surface_data_id | bigint |
| * | appearance_id | bigint |
| Indexes | ||
| appear_to_surface_data_pk | ON surface_data_id, appearance_id | |
| app_to_surf_data_fkx | ON surface_data_id | |
| app_to_surf_data_fkx1 | ON appearance_id | |
| Foreign Keys | ||
| app_to_surf_data_fk1 | appearance_id ↗ ❏ appearance(id) | |
| app_to_surf_data_fk | surface_data_id ↗ ❏ surface_data(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('appearance_seq'::regclass) |
| gmlid | varchar(256) | |
| gmlid_codespace | varchar(1000) | |
| theme | varchar(256) | |
| citymodel_id | bigint | |
| cityobject_id | bigint | |
| Indexes | ||
| appearance_pk | ON id | |
| appearance_inx | ON gmlid, gmlid_codespace | |
| appearance_theme_inx | ON theme | |
| appearance_citymodel_fkx | ON citymodel_id | |
| appearance_cityobject_fkx | ON cityobject_id | |
| Foreign Keys | ||
| appearance_citymodel_fk | citymodel_id ↗ ❏ citymodel(id) | |
| appearance_cityobject_fk | cityobject_id ↗ ❏ cityobject(id) | |
| Referring Foreign Keys | ||
| app_to_surf_data_fk1 | id ↙ ❏ appear_to_surface_data(appearance_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| ridge_or_valley_lines | geometry | |
| break_lines | geometry | |
| Indexes | ||
| breakline_relief_pk | ON id | |
| breakline_rel_objclass_fkx | ON objectclass_id | |
| breakline_ridge_spx | ON ridge_or_valley_lines | |
| breakline_break_spx | ON break_lines | |
| Foreign Keys | ||
| breakline_relief_comp_fk | id ↗ ❏ relief_component | |
| 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 | ON id | |
| bridge_parent_fkx | ON bridge_parent_id | |
| bridge_root_fkx | ON bridge_root_id | |
| bridge_lod1msrf_fkx | ON lod1_multi_surface_id | |
| bridge_lod2msrf_fkx | ON lod2_multi_surface_id | |
| bridge_lod3msrf_fkx | ON lod3_multi_surface_id | |
| bridge_lod4msrf_fkx | ON lod4_multi_surface_id | |
| bridge_lod1solid_fkx | ON lod1_solid_id | |
| bridge_lod2solid_fkx | ON lod2_solid_id | |
| bridge_lod3solid_fkx | ON lod3_solid_id | |
| bridge_lod4solid_fkx | ON lod4_solid_id | |
| bridge_objectclass_fkx | ON objectclass_id | |
| bridge_lod1terr_spx | ON lod1_terrain_intersection | |
| bridge_lod2terr_spx | ON lod2_terrain_intersection | |
| bridge_lod3terr_spx | ON lod3_terrain_intersection | |
| bridge_lod4terr_spx | ON lod4_terrain_intersection | |
| bridge_lod2curve_spx | ON lod2_multi_curve | |
| bridge_lod3curve_spx | ON lod3_multi_curve | |
| bridge_lod4curve_spx | ON lod4_multi_curve | |
| Foreign Keys | ||
| bridge_parent_fk | bridge_parent_id ↗ ❏ bridge(id) | |
| bridge_root_fk | bridge_root_id ↗ ❏ bridge(id) | |
| bridge_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod1solid_fk | lod1_solid_id ↗ ❏ surface_geometry(id) | |
| bridge_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod2solid_fk | lod2_solid_id ↗ ❏ surface_geometry(id) | |
| bridge_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod3solid_fk | lod3_solid_id ↗ ❏ surface_geometry(id) | |
| bridge_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| address_to_bridge_fk1 | id ↙ ❏ address_to_bridge(bridge_id) | |
| brd_them_srf_bridge_fk | id ↙ ❏ bridge_thematic_surface(bridge_id) | |
| bridge_constr_bridge_fk | id ↙ ❏ bridge_constr_element(bridge_id) | |
| bridge_inst_bridge_fk | id ↙ ❏ bridge_installation(bridge_id) | |
| bridge_parent_fk | id ↙ ❏ bridge(bridge_parent_id) | |
| bridge_room_bridge_fk | id ↙ ❏ bridge_room(bridge_id) | |
| bridge_root_fk | id ↙ ❏ bridge(bridge_root_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) | |
| 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 | ON id | |
| bridge_constr_bridge_fkx | ON bridge_id | |
| bridge_constr_lod1brep_fkx | ON lod1_brep_id | |
| bridge_constr_lod2brep_fkx | ON lod2_brep_id | |
| bridge_constr_lod3brep_fkx | ON lod3_brep_id | |
| bridge_constr_lod4brep_fkx | ON lod4_brep_id | |
| bridge_constr_lod1impl_fkx | ON lod1_implicit_rep_id | |
| bridge_constr_lod2impl_fkx | ON lod2_implicit_rep_id | |
| bridge_constr_lod3impl_fkx | ON lod3_implicit_rep_id | |
| bridge_constr_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_constr_objclass_fkx | ON objectclass_id | |
| bridge_constr_lod1terr_spx | ON lod1_terrain_intersection | |
| bridge_constr_lod2terr_spx | ON lod2_terrain_intersection | |
| bridge_constr_lod3terr_spx | ON lod3_terrain_intersection | |
| bridge_constr_lod4terr_spx | ON lod4_terrain_intersection | |
| bridge_const_lod1xgeom_spx | ON lod1_other_geom | |
| bridge_const_lod2xgeom_spx | ON lod2_other_geom | |
| bridge_const_lod3xgeom_spx | ON lod3_other_geom | |
| bridge_const_lod4xgeom_spx | ON lod4_other_geom | |
| bridge_const_lod1refpt_spx | ON lod1_implicit_ref_point | |
| bridge_const_lod2refpt_spx | ON lod2_implicit_ref_point | |
| bridge_const_lod3refpt_spx | ON lod3_implicit_ref_point | |
| bridge_const_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_constr_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| bridge_constr_cityobj_fk | id ↗ ❏ cityobject | |
| bridge_constr_lod1impl_fk | lod1_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod1brep_fk | lod1_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_constr_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_constr_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_constr_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_them_srf_brd_const_fk | id ↙ ❏ bridge_thematic_surface(bridge_constr_element_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) | |
| 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 | ON id | |
| bridge_furn_brd_room_fkx | ON bridge_room_id | |
| bridge_furn_lod4brep_fkx | ON lod4_brep_id | |
| bridge_furn_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_furn_objclass_fkx | ON objectclass_id | |
| bridge_furn_lod4xgeom_spx | ON lod4_other_geom | |
| bridge_furn_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_furn_brd_room_fk | bridge_room_id ↗ ❏ bridge_room(id) | |
| bridge_furn_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_furn_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_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) | |
| 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 | ON id | |
| bridge_inst_objclass_fkx | ON objectclass_id | |
| bridge_inst_bridge_fkx | ON bridge_id | |
| bridge_inst_brd_room_fkx | ON bridge_room_id | |
| bridge_inst_lod2brep_fkx | ON lod2_brep_id | |
| bridge_inst_lod3brep_fkx | ON lod3_brep_id | |
| bridge_inst_lod4brep_fkx | ON lod4_brep_id | |
| bridge_inst_lod2impl_fkx | ON lod2_implicit_rep_id | |
| bridge_inst_lod3impl_fkx | ON lod3_implicit_rep_id | |
| bridge_inst_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_inst_lod2xgeom_spx | ON lod2_other_geom | |
| bridge_inst_lod3xgeom_spx | ON lod3_other_geom | |
| bridge_inst_lod4xgeom_spx | ON lod4_other_geom | |
| bridge_inst_lod2refpt_spx | ON lod2_implicit_ref_point | |
| bridge_inst_lod3refpt_spx | ON lod3_implicit_ref_point | |
| bridge_inst_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_inst_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| bridge_inst_brd_room_fk | bridge_room_id ↗ ❏ bridge_room(id) | |
| bridge_inst_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_inst_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_inst_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_inst_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_inst_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_inst_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_inst_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_them_srf_brd_inst_fk | id ↙ ❏ bridge_thematic_surface(bridge_installation_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | bridge_opening_id | bigint |
| * | bridge_thematic_surface_id | bigint |
| Indexes | ||
| bridge_open_to_them_srf_pk | ON bridge_opening_id, bridge_thematic_surface_id | |
| brd_open_to_them_srf_fkx | ON bridge_opening_id | |
| brd_open_to_them_srf_fkx1 | ON bridge_thematic_surface_id | |
| Foreign Keys | ||
| brd_open_to_them_srf_fk | bridge_opening_id ↗ ❏ bridge_opening(id) | |
| brd_open_to_them_srf_fk1 | bridge_thematic_surface_id ↗ ❏ bridge_thematic_surface(id) | |
| 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 | ON id | |
| bridge_open_objclass_fkx | ON objectclass_id | |
| bridge_open_address_fkx | ON address_id | |
| bridge_open_lod3msrf_fkx | ON lod3_multi_surface_id | |
| bridge_open_lod4msrf_fkx | ON lod4_multi_surface_id | |
| bridge_open_lod3impl_fkx | ON lod3_implicit_rep_id | |
| bridge_open_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_open_lod3refpt_spx | ON lod3_implicit_ref_point | |
| bridge_open_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_open_address_fk | address_id ↗ ❏ address(id) | |
| bridge_open_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_open_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_open_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_open_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_open_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_open_to_them_srf_fk | id ↙ ❏ bridge_open_to_them_srf(bridge_opening_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) | |
| bridge_id | bigint | |
| lod4_multi_surface_id | bigint | |
| lod4_solid_id | bigint | |
| Indexes | ||
| bridge_room_pk | ON id | |
| bridge_room_bridge_fkx | ON bridge_id | |
| bridge_room_lod4msrf_fkx | ON lod4_multi_surface_id | |
| bridge_room_lod4solid_fkx | ON lod4_solid_id | |
| bridge_room_objclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| bridge_room_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| bridge_room_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_room_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_room_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_them_srf_brd_room_fk | id ↙ ❏ bridge_thematic_surface(bridge_room_id) | |
| bridge_furn_brd_room_fk | id ↙ ❏ bridge_furniture(bridge_room_id) | |
| bridge_inst_brd_room_fk | id ↙ ❏ bridge_installation(bridge_room_id) | |
| 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 | ON id | |
| brd_them_srf_objclass_fkx | ON objectclass_id | |
| brd_them_srf_bridge_fkx | ON bridge_id | |
| brd_them_srf_brd_room_fkx | ON bridge_room_id | |
| brd_them_srf_brd_inst_fkx | ON bridge_installation_id | |
| brd_them_srf_brd_const_fkx | ON bridge_constr_element_id | |
| brd_them_srf_lod2msrf_fkx | ON lod2_multi_surface_id | |
| brd_them_srf_lod3msrf_fkx | ON lod3_multi_surface_id | |
| brd_them_srf_lod4msrf_fkx | ON lod4_multi_surface_id | |
| Foreign Keys | ||
| brd_them_srf_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| brd_them_srf_brd_const_fk | bridge_constr_element_id ↗ ❏ bridge_constr_element(id) | |
| brd_them_srf_brd_inst_fk | bridge_installation_id ↗ ❏ bridge_installation(id) | |
| brd_them_srf_brd_room_fk | bridge_room_id ↗ ❏ bridge_room(id) | |
| brd_them_srf_cityobj_fk | id ↗ ❏ cityobject | |
| brd_them_srf_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| brd_them_srf_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| brd_them_srf_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_open_to_them_srf_fk1 | id ↙ ❏ bridge_open_to_them_srf(bridge_thematic_surface_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 |
| * | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 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 | ||
| city_furniture_pk | ON id | |
| city_furn_lod1brep_fkx | ON lod1_brep_id | |
| city_furn_lod2brep_fkx | ON lod2_brep_id | |
| city_furn_lod3brep_fkx | ON lod3_brep_id | |
| city_furn_lod4brep_fkx | ON lod4_brep_id | |
| city_furn_lod1impl_fkx | ON lod1_implicit_rep_id | |
| city_furn_lod2impl_fkx | ON lod2_implicit_rep_id | |
| city_furn_lod3impl_fkx | ON lod3_implicit_rep_id | |
| city_furn_lod4impl_fkx | ON lod4_implicit_rep_id | |
| city_furn_objclass_fkx | ON objectclass_id | |
| city_furn_lod1terr_spx | ON lod1_terrain_intersection | |
| city_furn_lod2terr_spx | ON lod2_terrain_intersection | |
| city_furn_lod3terr_spx | ON lod3_terrain_intersection | |
| city_furn_lod4terr_spx | ON lod4_terrain_intersection | |
| city_furn_lod1xgeom_spx | ON lod1_other_geom | |
| city_furn_lod2xgeom_spx | ON lod2_other_geom | |
| city_furn_lod3xgeom_spx | ON lod3_other_geom | |
| city_furn_lod4xgeom_spx | ON lod4_other_geom | |
| city_furn_lod1refpnt_spx | ON lod1_implicit_ref_point | |
| city_furn_lod2refpnt_spx | ON lod2_implicit_ref_point | |
| city_furn_lod3refpnt_spx | ON lod3_implicit_ref_point | |
| city_furn_lod4refpnt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| city_furn_cityobject_fk | id ↗ ❏ cityobject | |
| city_furn_lod1impl_fk | lod1_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| city_furn_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| city_furn_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| city_furn_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| city_furn_lod1brep_fk | lod1_brep_id ↗ ❏ surface_geometry(id) | |
| city_furn_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| city_furn_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| city_furn_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('citymodel_seq'::regclass) |
| 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 | |
| last_modification_date | timestamptz | |
| updating_person | varchar(256) | |
| reason_for_update | varchar(4000) | |
| lineage | varchar(256) | |
| Indexes | ||
| citymodel_pk | ON id | |
| citymodel_inx | ON gmlid, gmlid_codespace | |
| citymodel_envelope_spx | ON envelope | |
| Referring Foreign Keys | ||
| appearance_citymodel_fk | id ↙ ❏ appearance(citymodel_id) | |
| cityobject_member_fk1 | id ↙ ❏ cityobject_member(citymodel_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 DEFAULT nextval('cityobject_genericatt_seq'::regclass) |
| parent_genattrib_id | bigint | |
| root_genattrib_id | bigint | |
| * | attrname | varchar(256) |
| datatype | integer | |
| strval | varchar(4000) | |
| intval | integer | |
| realval | double precision | |
| urival | varchar(4000) | |
| dateval | timestamptz | |
| unit | varchar(4000) | |
| genattribset_codespace | varchar(4000) | |
| blobval | bytea | |
| geomval | geometry | |
| surface_geometry_id | bigint | |
| cityobject_id | bigint | |
| Indexes | ||
| cityobj_genericattrib_pk | ON id | |
| genericattrib_parent_fkx | ON parent_genattrib_id | |
| genericattrib_root_fkx | ON root_genattrib_id | |
| genericattrib_geom_fkx | ON surface_geometry_id | |
| genericattrib_cityobj_fkx | ON cityobject_id | |
| genericattrib_datatype_btr | ON datatype | |
| Foreign Keys | ||
| genericattrib_cityobj_fk | cityobject_id ↗ ❏ cityobject(id) | |
| genericattrib_parent_fk | parent_genattrib_id ↗ ❏ cityobject_genericattrib(id) | |
| genericattrib_root_fk | root_genattrib_id ↗ ❏ cityobject_genericattrib(id) | |
| genericattrib_geom_fk | surface_geometry_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| genericattrib_parent_fk | id ↙ ❏ cityobject_genericattrib(parent_genattrib_id) | |
| genericattrib_root_fk | id ↙ ❏ cityobject_genericattrib(root_genattrib_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | citymodel_id | bigint |
| * | cityobject_id | bigint |
| Indexes | ||
| cityobject_member_pk | ON citymodel_id, cityobject_id | |
| cityobject_member_fkx | ON cityobject_id | |
| cityobject_member_fkx1 | ON citymodel_id | |
| Foreign Keys | ||
| cityobject_member_fk1 | citymodel_id ↗ ❏ citymodel(id) | |
| cityobject_member_fk | cityobject_id ↗ ❏ cityobject(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) | |
| brep_id | bigint | |
| other_geom | geometry | |
| parent_cityobject_id | bigint | |
| Indexes | ||
| cityobjectgroup_pk | ON id | |
| group_brep_fkx | ON brep_id | |
| group_parent_cityobj_fkx | ON parent_cityobject_id | |
| group_objectclass_fkx | ON objectclass_id | |
| group_xgeom_spx | ON other_geom | |
| Foreign Keys | ||
| group_cityobject_fk | id ↗ ❏ cityobject | |
| group_parent_cityobj_fk | parent_cityobject_id ↗ ❏ cityobject(id) | |
| group_brep_fk | brep_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| group_to_cityobject_fk1 | id ↙ ❏ group_to_cityobject(cityobjectgroup_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | srid | integer |
| gml_srs_name | varchar(1000) | |
| Indexes | ||
| database_srs_pk | ON srid | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('external_ref_seq'::regclass) |
| infosys | varchar(4000) | |
| name | varchar(4000) | |
| uri | varchar(4000) | |
| cityobject_id | bigint | |
| Indexes | ||
| external_reference_pk | ON id | |
| ext_ref_cityobject_fkx | ON cityobject_id | |
| Foreign Keys | ||
| ext_ref_cityobject_fk | cityobject_id ↗ ❏ cityobject(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | cityobject_id | bigint |
| * | generalizes_to_id | bigint |
| Indexes | ||
| generalization_pk | ON cityobject_id, generalizes_to_id | |
| general_cityobject_fkx | ON cityobject_id | |
| general_generalizes_to_fkx | ON generalizes_to_id | |
| Foreign Keys | ||
| general_cityobject_fk | cityobject_id ↗ ❏ cityobject(id) | |
| general_generalizes_to_fk | generalizes_to_id ↗ ❏ cityobject(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) | |
| lod0_terrain_intersection | geometry | |
| lod1_terrain_intersection | geometry | |
| lod2_terrain_intersection | geometry | |
| lod3_terrain_intersection | geometry | |
| lod4_terrain_intersection | geometry | |
| lod0_brep_id | bigint | |
| lod1_brep_id | bigint | |
| lod2_brep_id | bigint | |
| lod3_brep_id | bigint | |
| lod4_brep_id | bigint | |
| lod0_other_geom | geometry | |
| lod1_other_geom | geometry | |
| lod2_other_geom | geometry | |
| lod3_other_geom | geometry | |
| lod4_other_geom | geometry | |
| lod0_implicit_rep_id | bigint | |
| lod1_implicit_rep_id | bigint | |
| lod2_implicit_rep_id | bigint | |
| lod3_implicit_rep_id | bigint | |
| lod4_implicit_rep_id | bigint | |
| lod0_implicit_ref_point | geometry | |
| lod1_implicit_ref_point | geometry | |
| lod2_implicit_ref_point | geometry | |
| lod3_implicit_ref_point | geometry | |
| lod4_implicit_ref_point | geometry | |
| lod0_implicit_transformation | varchar(1000) | |
| lod1_implicit_transformation | varchar(1000) | |
| lod2_implicit_transformation | varchar(1000) | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| generic_cityobject_pk | ON id | |
| gen_object_lod0brep_fkx | ON lod0_brep_id | |
| gen_object_lod1brep_fkx | ON lod1_brep_id | |
| gen_object_lod2brep_fkx | ON lod2_brep_id | |
| gen_object_lod3brep_fkx | ON lod3_brep_id | |
| gen_object_lod4brep_fkx | ON lod4_brep_id | |
| gen_object_lod0impl_fkx | ON lod0_implicit_rep_id | |
| gen_object_lod1impl_fkx | ON lod1_implicit_rep_id | |
| gen_object_lod2impl_fkx | ON lod2_implicit_rep_id | |
| gen_object_lod3impl_fkx | ON lod3_implicit_rep_id | |
| gen_object_lod4impl_fkx | ON lod4_implicit_rep_id | |
| gen_object_objclass_fkx | ON objectclass_id | |
| gen_object_lod0terr_spx | ON lod0_terrain_intersection | |
| gen_object_lod1terr_spx | ON lod1_terrain_intersection | |
| gen_object_lod2terr_spx | ON lod2_terrain_intersection | |
| gen_object_lod3terr_spx | ON lod3_terrain_intersection | |
| gen_object_lod4terr_spx | ON lod4_terrain_intersection | |
| gen_object_lod0xgeom_spx | ON lod0_other_geom | |
| gen_object_lod1xgeom_spx | ON lod1_other_geom | |
| gen_object_lod2xgeom_spx | ON lod2_other_geom | |
| gen_object_lod3xgeom_spx | ON lod3_other_geom | |
| gen_object_lod4xgeom_spx | ON lod4_other_geom | |
| gen_object_lod0refpnt_spx | ON lod0_implicit_ref_point | |
| gen_object_lod1refpnt_spx | ON lod1_implicit_ref_point | |
| gen_object_lod2refpnt_spx | ON lod2_implicit_ref_point | |
| gen_object_lod3refpnt_spx | ON lod3_implicit_ref_point | |
| gen_object_lod4refpnt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| gen_object_cityobject_fk | id ↗ ❏ cityobject | |
| gen_object_lod0impl_fk | lod0_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| gen_object_lod1impl_fk | lod1_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| gen_object_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| gen_object_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| gen_object_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| gen_object_lod0brep_fk | lod0_brep_id ↗ ❏ surface_geometry(id) | |
| gen_object_lod1brep_fk | lod1_brep_id ↗ ❏ surface_geometry(id) | |
| gen_object_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| gen_object_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| gen_object_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('grid_coverage_seq'::regclass) |
| rasterproperty | raster | |
| st_convexhull(rasterproperty) | varchar | |
| Indexes | ||
| grid_coverage_pk | ON id | |
| grid_coverage_raster_spx | ON st_convexhull(rasterproperty) | |
| Referring Foreign Keys | ||
| raster_relief_coverage_fk | id ↙ ❏ raster_relief(coverage_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | cityobject_id | bigint |
| * | cityobjectgroup_id | bigint |
| role | varchar(256) | |
| Indexes | ||
| group_to_cityobject_pk | ON cityobject_id, cityobjectgroup_id | |
| group_to_cityobject_fkx | ON cityobject_id | |
| group_to_cityobject_fkx1 | ON cityobjectgroup_id | |
| Foreign Keys | ||
| group_to_cityobject_fk | cityobject_id ↗ ❏ cityobject(id) | |
| group_to_cityobject_fk1 | cityobjectgroup_id ↗ ❏ cityobjectgroup(id) | |
| 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 | ON id | |
| implicit_geom_ref2lib_inx | ON reference_to_library | |
| implicit_geom_brep_fkx | ON relative_brep_id | |
| Foreign Keys | ||
| implicit_geom_brep_fk | relative_brep_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| bldg_furn_lod4impl_fk | id ↙ ❏ building_furniture(lod4_implicit_rep_id) | |
| bldg_inst_lod2impl_fk | id ↙ ❏ building_installation(lod2_implicit_rep_id) | |
| bldg_inst_lod3impl_fk | id ↙ ❏ building_installation(lod3_implicit_rep_id) | |
| bldg_inst_lod4impl_fk | id ↙ ❏ building_installation(lod4_implicit_rep_id) | |
| bridge_constr_lod1impl_fk | id ↙ ❏ bridge_constr_element(lod1_implicit_rep_id) | |
| bridge_constr_lod2impl_fk | id ↙ ❏ bridge_constr_element(lod2_implicit_rep_id) | |
| bridge_constr_lod3impl_fk | id ↙ ❏ bridge_constr_element(lod3_implicit_rep_id) | |
| bridge_constr_lod4impl_fk | id ↙ ❏ bridge_constr_element(lod4_implicit_rep_id) | |
| bridge_furn_lod4impl_fk | id ↙ ❏ bridge_furniture(lod4_implicit_rep_id) | |
| bridge_inst_lod2impl_fk | id ↙ ❏ bridge_installation(lod2_implicit_rep_id) | |
| bridge_inst_lod3impl_fk | id ↙ ❏ bridge_installation(lod3_implicit_rep_id) | |
| bridge_inst_lod4impl_fk | id ↙ ❏ bridge_installation(lod4_implicit_rep_id) | |
| bridge_open_lod3impl_fk | id ↙ ❏ bridge_opening(lod3_implicit_rep_id) | |
| bridge_open_lod4impl_fk | id ↙ ❏ bridge_opening(lod4_implicit_rep_id) | |
| city_furn_lod1impl_fk | id ↙ ❏ city_furniture(lod1_implicit_rep_id) | |
| city_furn_lod2impl_fk | id ↙ ❏ city_furniture(lod2_implicit_rep_id) | |
| city_furn_lod3impl_fk | id ↙ ❏ city_furniture(lod3_implicit_rep_id) | |
| city_furn_lod4impl_fk | id ↙ ❏ city_furniture(lod4_implicit_rep_id) | |
| gen_object_lod0impl_fk | id ↙ ❏ generic_cityobject(lod0_implicit_rep_id) | |
| gen_object_lod1impl_fk | id ↙ ❏ generic_cityobject(lod1_implicit_rep_id) | |
| gen_object_lod2impl_fk | id ↙ ❏ generic_cityobject(lod2_implicit_rep_id) | |
| gen_object_lod3impl_fk | id ↙ ❏ generic_cityobject(lod3_implicit_rep_id) | |
| gen_object_lod4impl_fk | id ↙ ❏ generic_cityobject(lod4_implicit_rep_id) | |
| opening_lod3impl_fk | id ↙ ❏ opening(lod3_implicit_rep_id) | |
| opening_lod4impl_fk | id ↙ ❏ opening(lod4_implicit_rep_id) | |
| sol_veg_obj_lod1impl_fk | id ↙ ❏ solitary_vegetat_object(lod1_implicit_rep_id) | |
| sol_veg_obj_lod2impl_fk | id ↙ ❏ solitary_vegetat_object(lod2_implicit_rep_id) | |
| sol_veg_obj_lod3impl_fk | id ↙ ❏ solitary_vegetat_object(lod3_implicit_rep_id) | |
| sol_veg_obj_lod4impl_fk | id ↙ ❏ solitary_vegetat_object(lod4_implicit_rep_id) | |
| tunnel_furn_lod4impl_fk | id ↙ ❏ tunnel_furniture(lod4_implicit_rep_id) | |
| tunnel_inst_lod2impl_fk | id ↙ ❏ tunnel_installation(lod2_implicit_rep_id) | |
| tunnel_inst_lod3impl_fk | id ↙ ❏ tunnel_installation(lod3_implicit_rep_id) | |
| tunnel_inst_lod4impl_fk | id ↙ ❏ tunnel_installation(lod4_implicit_rep_id) | |
| tunnel_open_lod3impl_fk | id ↙ ❏ tunnel_opening(lod3_implicit_rep_id) | |
| tunnel_open_lod4impl_fk | id ↙ ❏ tunnel_opening(lod4_implicit_rep_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | integer DEFAULT nextval('index_table_id_seq'::regclass) |
| obj | index_obj | |
| Indexes | ||
| index_table_pkey | ON 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) | |
| lod0_multi_surface_id | bigint | |
| lod1_multi_surface_id | bigint | |
| lod2_multi_surface_id | bigint | |
| lod3_multi_surface_id | bigint | |
| lod4_multi_surface_id | bigint | |
| Indexes | ||
| land_use_pk | ON id | |
| land_use_lod0msrf_fkx | ON lod0_multi_surface_id | |
| land_use_lod1msrf_fkx | ON lod1_multi_surface_id | |
| land_use_lod2msrf_fkx | ON lod2_multi_surface_id | |
| land_use_lod3msrf_fkx | ON lod3_multi_surface_id | |
| land_use_lod4msrf_fkx | ON lod4_multi_surface_id | |
| land_use_objclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| land_use_cityobject_fk | id ↗ ❏ cityobject | |
| land_use_lod0msrf_fk | lod0_multi_surface_id ↗ ❏ surface_geometry(id) | |
| land_use_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| land_use_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| land_use_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| land_use_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| relief_points | geometry | |
| Indexes | ||
| masspoint_relief_pk | ON id | |
| masspoint_rel_objclass_fkx | ON objectclass_id | |
| masspoint_relief_spx | ON relief_points | |
| Foreign Keys | ||
| masspoint_relief_comp_fk | id ↗ ❏ relief_component | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | integer |
| superclass_id | integer | |
| baseclass_id | integer | |
| * | class_name | varchar |
| package | varchar | |
| is_top_level | numeric | |
| ade_id | integer | |
| Indexes | ||
| t_objectclass_pkey | ON id | |
| Foreign Keys | ||
| fk_t_objectclass_baseclass_id | baseclass_id ↗ ❏ objectclass(id) | |
| fk_t_objectclass_superclass_id | superclass_id ↗ ❏ objectclass(id) | |
| Referring Foreign Keys | ||
| fk_t_objectclass_baseclass_id | id ↙ ❏ objectclass(baseclass_id) | |
| fk_t_objectclass_superclass_id | id ↙ ❏ objectclass(superclass_id) | |
| 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) | |
| average_height | double precision | |
| average_height_unit | varchar(4000) | |
| lod1_multi_surface_id | bigint | |
| lod2_multi_surface_id | bigint | |
| lod3_multi_surface_id | bigint | |
| lod4_multi_surface_id | bigint | |
| lod1_multi_solid_id | bigint | |
| lod2_multi_solid_id | bigint | |
| lod3_multi_solid_id | bigint | |
| lod4_multi_solid_id | bigint | |
| Indexes | ||
| plant_cover_pk | ON id | |
| plant_cover_lod1msrf_fkx | ON lod1_multi_surface_id | |
| plant_cover_lod2msrf_fkx | ON lod2_multi_surface_id | |
| plant_cover_lod3msrf_fkx | ON lod3_multi_surface_id | |
| plant_cover_lod4msrf_fkx | ON lod4_multi_surface_id | |
| plant_cover_lod1msolid_fkx | ON lod1_multi_solid_id | |
| plant_cover_lod2msolid_fkx | ON lod2_multi_solid_id | |
| plant_cover_lod3msolid_fkx | ON lod3_multi_solid_id | |
| plant_cover_lod4msolid_fkx | ON lod4_multi_solid_id | |
| plant_cover_objclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| plant_cover_cityobject_fk | id ↗ ❏ cityobject | |
| plant_cover_lod1msolid_fk | lod1_multi_solid_id ↗ ❏ surface_geometry(id) | |
| plant_cover_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| plant_cover_lod2msolid_fk | lod2_multi_solid_id ↗ ❏ surface_geometry(id) | |
| plant_cover_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| plant_cover_lod3msolid_fk | lod3_multi_solid_id ↗ ❏ surface_geometry(id) | |
| plant_cover_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| plant_cover_lod4msolid_fk | lod4_multi_solid_id ↗ ❏ surface_geometry(id) | |
| plant_cover_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| raster_uri | varchar(4000) | |
| coverage_id | bigint | |
| Indexes | ||
| raster_relief_pk | ON id | |
| raster_relief_coverage_fkx | ON coverage_id | |
| raster_relief_objclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| raster_relief_coverage_fk | coverage_id ↗ ❏ grid_coverage(id) | |
| raster_relief_comp_fk | id ↗ ❏ relief_component | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| lod | numeric | |
| extent | geometry | |
| Indexes | ||
| relief_component_pk | ON id | |
| relief_comp_objclass_fkx | ON objectclass_id | |
| relief_comp_extent_spx | ON extent | |
| Foreign Keys | ||
| relief_comp_cityobject_fk | id ↗ ❏ cityobject | |
| Referring Foreign Keys | ||
| breakline_relief_comp_fk | id ↙ ❏ breakline_relief | |
| masspoint_relief_comp_fk | id ↙ ❏ masspoint_relief | |
| raster_relief_comp_fk | id ↙ ❏ raster_relief | |
| rel_feat_to_rel_comp_fk | id ↙ ❏ relief_feat_to_rel_comp(relief_component_id) | |
| tin_relief_comp_fk | id ↙ ❏ tin_relief | |
| Constraints | ||
| relief_comp_lod_chk | ((lod >= (0)::numeric) AND (lod < (5)::numeric)) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | relief_component_id | bigint |
| * | relief_feature_id | bigint |
| Indexes | ||
| relief_feat_to_rel_comp_pk | ON relief_component_id, relief_feature_id | |
| rel_feat_to_rel_comp_fkx | ON relief_component_id | |
| rel_feat_to_rel_comp_fkx1 | ON relief_feature_id | |
| Foreign Keys | ||
| rel_feat_to_rel_comp_fk | relief_component_id ↗ ❏ relief_component(id) | |
| rel_feat_to_rel_comp_fk1 | relief_feature_id ↗ ❏ relief_feature(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| lod | numeric | |
| Indexes | ||
| relief_feature_pk | ON id | |
| relief_feat_objclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| relief_feat_cityobject_fk | id ↗ ❏ cityobject | |
| Referring Foreign Keys | ||
| rel_feat_to_rel_comp_fk1 | id ↙ ❏ relief_feat_to_rel_comp(relief_feature_id) | |
| Constraints | ||
| relief_feat_lod_chk | ((lod >= (0)::numeric) AND (lod < (5)::numeric)) | |
| 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 | integer DEFAULT nextval('schema_seq'::regclass) |
| * | is_ade_root | numeric |
| * | citygml_version | varchar(50) |
| * | xml_namespace_uri | varchar(4000) |
| * | xml_namespace_prefix | varchar(50) |
| xml_schema_location | varchar(4000) | |
| xml_schemafile | bytea | |
| xml_schemafile_type | varchar(256) | |
| ade_id | integer | |
| Indexes | ||
| schema_pk | ON id | |
| Foreign Keys | ||
| schema_ade_fk | ade_id ↗ ❏ ade(id) | |
| Referring Foreign Keys | ||
| schema_referencing_fk1 | id ↙ ❏ schema_referencing(referencing_id) | |
| schema_referencing_fk2 | id ↙ ❏ schema_referencing(referenced_id) | |
| schema_to_objectclass_fk1 | id ↙ ❏ schema_to_objectclass(schema_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | referencing_id | integer |
| * | referenced_id | integer |
| Indexes | ||
| schema_referencing_pk | ON referenced_id, referencing_id | |
| schema_referencing_fkx1 | ON referenced_id | |
| schema_referencing_fkx2 | ON referencing_id | |
| Foreign Keys | ||
| schema_referencing_fk1 | referencing_id ↗ ❏ schema(id) | |
| schema_referencing_fk2 | referenced_id ↗ ❏ schema(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | schema_id | integer |
| * | objectclass_id | integer |
| Indexes | ||
| schema_to_objectclass_pk | ON schema_id, objectclass_id | |
| schema_to_objectclass_fkx1 | ON schema_id | |
| schema_to_objectclass_fkx2 | ON objectclass_id | |
| Foreign Keys | ||
| schema_to_objectclass_fk1 | schema_id ↗ ❏ schema(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) | |
| species | varchar(1000) | |
| species_codespace | varchar(4000) | |
| height | double precision | |
| height_unit | varchar(4000) | |
| trunk_diameter | double precision | |
| trunk_diameter_unit | varchar(4000) | |
| crown_diameter | double precision | |
| crown_diameter_unit | varchar(4000) | |
| 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 | ||
| solitary_veg_object_pk | ON id | |
| sol_veg_obj_lod1brep_fkx | ON lod1_brep_id | |
| sol_veg_obj_lod2brep_fkx | ON lod2_brep_id | |
| sol_veg_obj_lod3brep_fkx | ON lod3_brep_id | |
| sol_veg_obj_lod4brep_fkx | ON lod4_brep_id | |
| sol_veg_obj_lod1impl_fkx | ON lod1_implicit_rep_id | |
| sol_veg_obj_lod2impl_fkx | ON lod2_implicit_rep_id | |
| sol_veg_obj_lod3impl_fkx | ON lod3_implicit_rep_id | |
| sol_veg_obj_lod4impl_fkx | ON lod4_implicit_rep_id | |
| sol_veg_obj_objclass_fkx | ON objectclass_id | |
| sol_veg_obj_lod1xgeom_spx | ON lod1_other_geom | |
| sol_veg_obj_lod2xgeom_spx | ON lod2_other_geom | |
| sol_veg_obj_lod3xgeom_spx | ON lod3_other_geom | |
| sol_veg_obj_lod4xgeom_spx | ON lod4_other_geom | |
| sol_veg_obj_lod1refpt_spx | ON lod1_implicit_ref_point | |
| sol_veg_obj_lod2refpt_spx | ON lod2_implicit_ref_point | |
| sol_veg_obj_lod3refpt_spx | ON lod3_implicit_ref_point | |
| sol_veg_obj_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| sol_veg_obj_cityobject_fk | id ↗ ❏ cityobject | |
| sol_veg_obj_lod1impl_fk | lod1_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| sol_veg_obj_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| sol_veg_obj_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| sol_veg_obj_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| sol_veg_obj_lod1brep_fk | lod1_brep_id ↗ ❏ surface_geometry(id) | |
| sol_veg_obj_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| sol_veg_obj_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| sol_veg_obj_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('surface_data_seq'::regclass) |
| gmlid | varchar(256) | |
| gmlid_codespace | varchar(1000) | |
| is_front | numeric | |
| * | objectclass_id | integer |
| x3d_shininess | double precision | |
| x3d_transparency | double precision | |
| x3d_ambient_intensity | double precision | |
| x3d_specular_color | varchar(256) | |
| x3d_diffuse_color | varchar(256) | |
| x3d_emissive_color | varchar(256) | |
| x3d_is_smooth | numeric | |
| tex_image_id | bigint | |
| tex_texture_type | varchar(256) | |
| tex_wrap_mode | varchar(256) | |
| tex_border_color | varchar(256) | |
| gt_prefer_worldfile | numeric | |
| gt_orientation | varchar(256) | |
| gt_reference_point | geometry | |
| Indexes | ||
| surface_data_pk | ON id | |
| surface_data_inx | ON gmlid, gmlid_codespace | |
| surface_data_tex_image_fkx | ON tex_image_id | |
| surface_data_objclass_fkx | ON objectclass_id | |
| surface_data_spx | ON gt_reference_point | |
| Foreign Keys | ||
| surface_data_tex_image_fk | tex_image_id ↗ ❏ tex_image(id) | |
| Referring Foreign Keys | ||
| app_to_surf_data_fk | id ↙ ❏ appear_to_surface_data(surface_data_id) | |
| texparam_surface_data_fk | id ↙ ❏ textureparam(surface_data_id) | |
| 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 | ON id | |
| surface_geom_inx | ON gmlid, gmlid_codespace | |
| surface_geom_parent_fkx | ON parent_id | |
| surface_geom_root_fkx | ON root_id | |
| surface_geom_cityobj_fkx | ON cityobject_id | |
| surface_geom_solid_spx | ON solid_geometry | |
| surface_geom_spx | ON geometry | |
| Foreign Keys | ||
| surface_geom_cityobj_fk | cityobject_id ↗ ❏ cityobject(id) | |
| surface_geom_parent_fk | parent_id ↗ ❏ surface_geometry(id) | |
| surface_geom_root_fk | root_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| bldg_furn_lod4brep_fk | id ↙ ❏ building_furniture(lod4_brep_id) | |
| bldg_inst_lod2brep_fk | id ↙ ❏ building_installation(lod2_brep_id) | |
| bldg_inst_lod3brep_fk | id ↙ ❏ building_installation(lod3_brep_id) | |
| bldg_inst_lod4brep_fk | id ↙ ❏ building_installation(lod4_brep_id) | |
| brd_them_srf_lod2msrf_fk | id ↙ ❏ bridge_thematic_surface(lod2_multi_surface_id) | |
| brd_them_srf_lod3msrf_fk | id ↙ ❏ bridge_thematic_surface(lod3_multi_surface_id) | |
| brd_them_srf_lod4msrf_fk | id ↙ ❏ bridge_thematic_surface(lod4_multi_surface_id) | |
| bridge_constr_lod1brep_fk | id ↙ ❏ bridge_constr_element(lod1_brep_id) | |
| bridge_constr_lod2brep_fk | id ↙ ❏ bridge_constr_element(lod2_brep_id) | |
| bridge_constr_lod3brep_fk | id ↙ ❏ bridge_constr_element(lod3_brep_id) | |
| bridge_constr_lod4brep_fk | id ↙ ❏ bridge_constr_element(lod4_brep_id) | |
| bridge_furn_lod4brep_fk | id ↙ ❏ bridge_furniture(lod4_brep_id) | |
| bridge_inst_lod2brep_fk | id ↙ ❏ bridge_installation(lod2_brep_id) | |
| bridge_inst_lod3brep_fk | id ↙ ❏ bridge_installation(lod3_brep_id) | |
| bridge_inst_lod4brep_fk | id ↙ ❏ bridge_installation(lod4_brep_id) | |
| bridge_lod1msrf_fk | id ↙ ❏ bridge(lod1_multi_surface_id) | |
| bridge_lod1solid_fk | id ↙ ❏ bridge(lod1_solid_id) | |
| bridge_lod2msrf_fk | id ↙ ❏ bridge(lod2_multi_surface_id) | |
| bridge_lod2solid_fk | id ↙ ❏ bridge(lod2_solid_id) | |
| bridge_lod3msrf_fk | id ↙ ❏ bridge(lod3_multi_surface_id) | |
| bridge_lod3solid_fk | id ↙ ❏ bridge(lod3_solid_id) | |
| bridge_lod4msrf_fk | id ↙ ❏ bridge(lod4_multi_surface_id) | |
| bridge_lod4solid_fk | id ↙ ❏ bridge(lod4_solid_id) | |
| bridge_open_lod3msrf_fk | id ↙ ❏ bridge_opening(lod3_multi_surface_id) | |
| bridge_open_lod4msrf_fk | id ↙ ❏ bridge_opening(lod4_multi_surface_id) | |
| bridge_room_lod4msrf_fk | id ↙ ❏ bridge_room(lod4_multi_surface_id) | |
| bridge_room_lod4solid_fk | id ↙ ❏ bridge_room(lod4_solid_id) | |
| building_lod0footprint_fk | id ↙ ❏ building(lod0_footprint_id) | |
| building_lod0roofprint_fk | id ↙ ❏ building(lod0_roofprint_id) | |
| building_lod1msrf_fk | id ↙ ❏ building(lod1_multi_surface_id) | |
| building_lod1solid_fk | id ↙ ❏ building(lod1_solid_id) | |
| building_lod2msrf_fk | id ↙ ❏ building(lod2_multi_surface_id) | |
| building_lod2solid_fk | id ↙ ❏ building(lod2_solid_id) | |
| building_lod3msrf_fk | id ↙ ❏ building(lod3_multi_surface_id) | |
| building_lod3solid_fk | id ↙ ❏ building(lod3_solid_id) | |
| building_lod4msrf_fk | id ↙ ❏ building(lod4_multi_surface_id) | |
| building_lod4solid_fk | id ↙ ❏ building(lod4_solid_id) | |
| city_furn_lod1brep_fk | id ↙ ❏ city_furniture(lod1_brep_id) | |
| city_furn_lod2brep_fk | id ↙ ❏ city_furniture(lod2_brep_id) | |
| city_furn_lod3brep_fk | id ↙ ❏ city_furniture(lod3_brep_id) | |
| city_furn_lod4brep_fk | id ↙ ❏ city_furniture(lod4_brep_id) | |
| gen_object_lod0brep_fk | id ↙ ❏ generic_cityobject(lod0_brep_id) | |
| gen_object_lod1brep_fk | id ↙ ❏ generic_cityobject(lod1_brep_id) | |
| gen_object_lod2brep_fk | id ↙ ❏ generic_cityobject(lod2_brep_id) | |
| gen_object_lod3brep_fk | id ↙ ❏ generic_cityobject(lod3_brep_id) | |
| gen_object_lod4brep_fk | id ↙ ❏ generic_cityobject(lod4_brep_id) | |
| genericattrib_geom_fk | id ↙ ❏ cityobject_genericattrib(surface_geometry_id) | |
| group_brep_fk | id ↙ ❏ cityobjectgroup(brep_id) | |
| implicit_geom_brep_fk | id ↙ ❏ implicit_geometry(relative_brep_id) | |
| land_use_lod0msrf_fk | id ↙ ❏ land_use(lod0_multi_surface_id) | |
| land_use_lod1msrf_fk | id ↙ ❏ land_use(lod1_multi_surface_id) | |
| land_use_lod2msrf_fk | id ↙ ❏ land_use(lod2_multi_surface_id) | |
| land_use_lod3msrf_fk | id ↙ ❏ land_use(lod3_multi_surface_id) | |
| land_use_lod4msrf_fk | id ↙ ❏ land_use(lod4_multi_surface_id) | |
| opening_lod3msrf_fk | id ↙ ❏ opening(lod3_multi_surface_id) | |
| opening_lod4msrf_fk | id ↙ ❏ opening(lod4_multi_surface_id) | |
| plant_cover_lod1msolid_fk | id ↙ ❏ plant_cover(lod1_multi_solid_id) | |
| plant_cover_lod1msrf_fk | id ↙ ❏ plant_cover(lod1_multi_surface_id) | |
| plant_cover_lod2msolid_fk | id ↙ ❏ plant_cover(lod2_multi_solid_id) | |
| plant_cover_lod2msrf_fk | id ↙ ❏ plant_cover(lod2_multi_surface_id) | |
| plant_cover_lod3msolid_fk | id ↙ ❏ plant_cover(lod3_multi_solid_id) | |
| plant_cover_lod3msrf_fk | id ↙ ❏ plant_cover(lod3_multi_surface_id) | |
| plant_cover_lod4msolid_fk | id ↙ ❏ plant_cover(lod4_multi_solid_id) | |
| plant_cover_lod4msrf_fk | id ↙ ❏ plant_cover(lod4_multi_surface_id) | |
| room_lod4msrf_fk | id ↙ ❏ room(lod4_multi_surface_id) | |
| room_lod4solid_fk | id ↙ ❏ room(lod4_solid_id) | |
| sol_veg_obj_lod1brep_fk | id ↙ ❏ solitary_vegetat_object(lod1_brep_id) | |
| sol_veg_obj_lod2brep_fk | id ↙ ❏ solitary_vegetat_object(lod2_brep_id) | |
| sol_veg_obj_lod3brep_fk | id ↙ ❏ solitary_vegetat_object(lod3_brep_id) | |
| sol_veg_obj_lod4brep_fk | id ↙ ❏ solitary_vegetat_object(lod4_brep_id) | |
| surface_geom_parent_fk | id ↙ ❏ surface_geometry(parent_id) | |
| surface_geom_root_fk | id ↙ ❏ surface_geometry(root_id) | |
| texparam_geom_fk | id ↙ ❏ textureparam(surface_geometry_id) | |
| them_surface_lod2msrf_fk | id ↙ ❏ thematic_surface(lod2_multi_surface_id) | |
| them_surface_lod3msrf_fk | id ↙ ❏ thematic_surface(lod3_multi_surface_id) | |
| them_surface_lod4msrf_fk | id ↙ ❏ thematic_surface(lod4_multi_surface_id) | |
| tin_relief_geom_fk | id ↙ ❏ tin_relief(surface_geometry_id) | |
| traffic_area_lod2msrf_fk | id ↙ ❏ traffic_area(lod2_multi_surface_id) | |
| traffic_area_lod3msrf_fk | id ↙ ❏ traffic_area(lod3_multi_surface_id) | |
| traffic_area_lod4msrf_fk | id ↙ ❏ traffic_area(lod4_multi_surface_id) | |
| tran_complex_lod1msrf_fk | id ↙ ❏ transportation_complex(lod1_multi_surface_id) | |
| tran_complex_lod2msrf_fk | id ↙ ❏ transportation_complex(lod2_multi_surface_id) | |
| tran_complex_lod3msrf_fk | id ↙ ❏ transportation_complex(lod3_multi_surface_id) | |
| tran_complex_lod4msrf_fk | id ↙ ❏ transportation_complex(lod4_multi_surface_id) | |
| tun_hspace_lod4msrf_fk | id ↙ ❏ tunnel_hollow_space(lod4_multi_surface_id) | |
| tun_hspace_lod4solid_fk | id ↙ ❏ tunnel_hollow_space(lod4_solid_id) | |
| tun_them_srf_lod2msrf_fk | id ↙ ❏ tunnel_thematic_surface(lod2_multi_surface_id) | |
| tun_them_srf_lod3msrf_fk | id ↙ ❏ tunnel_thematic_surface(lod3_multi_surface_id) | |
| tun_them_srf_lod4msrf_fk | id ↙ ❏ tunnel_thematic_surface(lod4_multi_surface_id) | |
| tunnel_furn_lod4brep_fk | id ↙ ❏ tunnel_furniture(lod4_brep_id) | |
| tunnel_inst_lod2brep_fk | id ↙ ❏ tunnel_installation(lod2_brep_id) | |
| tunnel_inst_lod3brep_fk | id ↙ ❏ tunnel_installation(lod3_brep_id) | |
| tunnel_inst_lod4brep_fk | id ↙ ❏ tunnel_installation(lod4_brep_id) | |
| tunnel_lod1msrf_fk | id ↙ ❏ tunnel(lod1_multi_surface_id) | |
| tunnel_lod1solid_fk | id ↙ ❏ tunnel(lod1_solid_id) | |
| tunnel_lod2msrf_fk | id ↙ ❏ tunnel(lod2_multi_surface_id) | |
| tunnel_lod2solid_fk | id ↙ ❏ tunnel(lod2_solid_id) | |
| tunnel_lod3msrf_fk | id ↙ ❏ tunnel(lod3_multi_surface_id) | |
| tunnel_lod3solid_fk | id ↙ ❏ tunnel(lod3_solid_id) | |
| tunnel_lod4msrf_fk | id ↙ ❏ tunnel(lod4_multi_surface_id) | |
| tunnel_lod4solid_fk | id ↙ ❏ tunnel(lod4_solid_id) | |
| tunnel_open_lod3msrf_fk | id ↙ ❏ tunnel_opening(lod3_multi_surface_id) | |
| tunnel_open_lod4msrf_fk | id ↙ ❏ tunnel_opening(lod4_multi_surface_id) | |
| waterbnd_srf_lod2srf_fk | id ↙ ❏ waterboundary_surface(lod2_surface_id) | |
| waterbnd_srf_lod3srf_fk | id ↙ ❏ waterboundary_surface(lod3_surface_id) | |
| waterbnd_srf_lod4srf_fk | id ↙ ❏ waterboundary_surface(lod4_surface_id) | |
| waterbody_lod0msrf_fk | id ↙ ❏ waterbody(lod0_multi_surface_id) | |
| waterbody_lod1msrf_fk | id ↙ ❏ waterbody(lod1_multi_surface_id) | |
| waterbody_lod1solid_fk | id ↙ ❏ waterbody(lod1_solid_id) | |
| waterbody_lod2solid_fk | id ↙ ❏ waterbody(lod2_solid_id) | |
| waterbody_lod3solid_fk | id ↙ ❏ waterbody(lod3_solid_id) | |
| waterbody_lod4solid_fk | id ↙ ❏ waterbody(lod4_solid_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('tex_image_seq'::regclass) |
| tex_image_uri | varchar(4000) | |
| tex_image_data | bytea | |
| tex_mime_type | varchar(256) | |
| tex_mime_type_codespace | varchar(4000) | |
| Indexes | ||
| tex_image_pk | ON id | |
| Referring Foreign Keys | ||
| surface_data_tex_image_fk | id ↙ ❏ surface_data(tex_image_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | surface_geometry_id | bigint |
| is_texture_parametrization | numeric | |
| world_to_texture | varchar(1000) | |
| texture_coordinates | geometry | |
| * | surface_data_id | bigint |
| Indexes | ||
| textureparam_pk | ON surface_geometry_id, surface_data_id | |
| texparam_geom_fkx | ON surface_geometry_id | |
| texparam_surface_data_fkx | ON surface_data_id | |
| Foreign Keys | ||
| texparam_surface_data_fk | surface_data_id ↗ ❏ surface_data(id) | |
| texparam_geom_fk | surface_geometry_id ↗ ❏ surface_geometry(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) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| max_length | double precision | |
| max_length_unit | varchar(4000) | |
| stop_lines | geometry | |
| break_lines | geometry | |
| control_points | geometry | |
| surface_geometry_id | bigint | |
| Indexes | ||
| tin_relief_pk | ON id | |
| tin_relief_geom_fkx | ON surface_geometry_id | |
| tin_relief_objclass_fkx | ON objectclass_id | |
| tin_relief_stop_spx | ON stop_lines | |
| tin_relief_break_spx | ON break_lines | |
| tin_relief_crtlpts_spx | ON control_points | |
| Foreign Keys | ||
| tin_relief_comp_fk | id ↗ ❏ relief_component | |
| tin_relief_geom_fk | surface_geometry_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) | |
| surface_material | varchar(256) | |
| surface_material_codespace | varchar(4000) | |
| lod2_multi_surface_id | bigint | |
| lod3_multi_surface_id | bigint | |
| lod4_multi_surface_id | bigint | |
| transportation_complex_id | bigint | |
| Indexes | ||
| traffic_area_pk | ON id | |
| traffic_area_objclass_fkx | ON objectclass_id | |
| traffic_area_lod2msrf_fkx | ON lod2_multi_surface_id | |
| traffic_area_lod3msrf_fkx | ON lod3_multi_surface_id | |
| traffic_area_lod4msrf_fkx | ON lod4_multi_surface_id | |
| traffic_area_trancmplx_fkx | ON transportation_complex_id | |
| Foreign Keys | ||
| traffic_area_cityobject_fk | id ↗ ❏ cityobject | |
| traffic_area_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| traffic_area_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| traffic_area_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| traffic_area_trancmplx_fk | transportation_complex_id ↗ ❏ transportation_complex(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) | |
| lod0_network | geometry | |
| lod1_multi_surface_id | bigint | |
| lod2_multi_surface_id | bigint | |
| lod3_multi_surface_id | bigint | |
| lod4_multi_surface_id | bigint | |
| Indexes | ||
| transportation_complex_pk | ON id | |
| tran_complex_objclass_fkx | ON objectclass_id | |
| tran_complex_lod1msrf_fkx | ON lod1_multi_surface_id | |
| tran_complex_lod2msrf_fkx | ON lod2_multi_surface_id | |
| tran_complex_lod3msrf_fkx | ON lod3_multi_surface_id | |
| tran_complex_lod4msrf_fkx | ON lod4_multi_surface_id | |
| tran_complex_lod0net_spx | ON lod0_network | |
| Foreign Keys | ||
| tran_complex_cityobject_fk | id ↗ ❏ cityobject | |
| tran_complex_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tran_complex_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tran_complex_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tran_complex_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| traffic_area_trancmplx_fk | id ↙ ❏ traffic_area(transportation_complex_id) | |
| 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 | ON id | |
| tunnel_parent_fkx | ON tunnel_parent_id | |
| tunnel_root_fkx | ON tunnel_root_id | |
| tunnel_lod1msrf_fkx | ON lod1_multi_surface_id | |
| tunnel_lod2msrf_fkx | ON lod2_multi_surface_id | |
| tunnel_lod3msrf_fkx | ON lod3_multi_surface_id | |
| tunnel_lod4msrf_fkx | ON lod4_multi_surface_id | |
| tunnel_lod1solid_fkx | ON lod1_solid_id | |
| tunnel_lod2solid_fkx | ON lod2_solid_id | |
| tunnel_lod3solid_fkx | ON lod3_solid_id | |
| tunnel_lod4solid_fkx | ON lod4_solid_id | |
| tunnel_objectclass_fkx | ON objectclass_id | |
| tunnel_lod1terr_spx | ON lod1_terrain_intersection | |
| tunnel_lod2terr_spx | ON lod2_terrain_intersection | |
| tunnel_lod3terr_spx | ON lod3_terrain_intersection | |
| tunnel_lod4terr_spx | ON lod4_terrain_intersection | |
| tunnel_lod2curve_spx | ON lod2_multi_curve | |
| tunnel_lod3curve_spx | ON lod3_multi_curve | |
| tunnel_lod4curve_spx | ON lod4_multi_curve | |
| Foreign Keys | ||
| tunnel_cityobject_fk | id ↗ ❏ cityobject | |
| tunnel_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tunnel_lod1solid_fk | lod1_solid_id ↗ ❏ surface_geometry(id) | |
| tunnel_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tunnel_lod2solid_fk | lod2_solid_id ↗ ❏ surface_geometry(id) | |
| tunnel_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tunnel_lod3solid_fk | lod3_solid_id ↗ ❏ surface_geometry(id) | |
| tunnel_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tunnel_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| tunnel_parent_fk | tunnel_parent_id ↗ ❏ tunnel(id) | |
| tunnel_root_fk | tunnel_root_id ↗ ❏ tunnel(id) | |
| Referring Foreign Keys | ||
| tun_hspace_tunnel_fk | id ↙ ❏ tunnel_hollow_space(tunnel_id) | |
| tun_them_srf_tunnel_fk | id ↙ ❏ tunnel_thematic_surface(tunnel_id) | |
| tunnel_inst_tunnel_fk | id ↙ ❏ tunnel_installation(tunnel_id) | |
| tunnel_parent_fk | id ↙ ❏ tunnel(tunnel_parent_id) | |
| tunnel_root_fk | id ↙ ❏ tunnel(tunnel_root_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) | |
| 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 | ON id | |
| tunnel_furn_hspace_fkx | ON tunnel_hollow_space_id | |
| tunnel_furn_lod4brep_fkx | ON lod4_brep_id | |
| tunnel_furn_lod4impl_fkx | ON lod4_implicit_rep_id | |
| tunnel_furn_objclass_fkx | ON objectclass_id | |
| tunnel_furn_lod4xgeom_spx | ON lod4_other_geom | |
| tunnel_furn_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| tunnel_furn_cityobject_fk | id ↗ ❏ cityobject | |
| tunnel_furn_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| tunnel_furn_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| tunnel_furn_hspace_fk | tunnel_hollow_space_id ↗ ❏ tunnel_hollow_space(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) | |
| tunnel_id | bigint | |
| lod4_multi_surface_id | bigint | |
| lod4_solid_id | bigint | |
| Indexes | ||
| tunnel_hollow_space_pk | ON id | |
| tun_hspace_tunnel_fkx | ON tunnel_id | |
| tun_hspace_lod4msrf_fkx | ON lod4_multi_surface_id | |
| tun_hspace_lod4solid_fkx | ON lod4_solid_id | |
| tun_hspace_objclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| tun_hspace_cityobj_fk | id ↗ ❏ cityobject | |
| tun_hspace_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tun_hspace_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| tun_hspace_tunnel_fk | tunnel_id ↗ ❏ tunnel(id) | |
| Referring Foreign Keys | ||
| tun_them_srf_hspace_fk | id ↙ ❏ tunnel_thematic_surface(tunnel_hollow_space_id) | |
| tunnel_furn_hspace_fk | id ↙ ❏ tunnel_furniture(tunnel_hollow_space_id) | |
| tunnel_inst_hspace_fk | id ↙ ❏ tunnel_installation(tunnel_hollow_space_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) | |
| 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 | ON id | |
| tunnel_inst_objclass_fkx | ON objectclass_id | |
| tunnel_inst_tunnel_fkx | ON tunnel_id | |
| tunnel_inst_hspace_fkx | ON tunnel_hollow_space_id | |
| tunnel_inst_lod2brep_fkx | ON lod2_brep_id | |
| tunnel_inst_lod3brep_fkx | ON lod3_brep_id | |
| tunnel_inst_lod4brep_fkx | ON lod4_brep_id | |
| tunnel_inst_lod2impl_fkx | ON lod2_implicit_rep_id | |
| tunnel_inst_lod3impl_fkx | ON lod3_implicit_rep_id | |
| tunnel_inst_lod4impl_fkx | ON lod4_implicit_rep_id | |
| tunnel_inst_lod2xgeom_spx | ON lod2_other_geom | |
| tunnel_inst_lod3xgeom_spx | ON lod3_other_geom | |
| tunnel_inst_lod4xgeom_spx | ON lod4_other_geom | |
| tunnel_inst_lod2refpt_spx | ON lod2_implicit_ref_point | |
| tunnel_inst_lod3refpt_spx | ON lod3_implicit_ref_point | |
| tunnel_inst_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| tunnel_inst_cityobject_fk | id ↗ ❏ cityobject | |
| tunnel_inst_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| tunnel_inst_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| tunnel_inst_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| tunnel_inst_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| tunnel_inst_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| tunnel_inst_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| tunnel_inst_tunnel_fk | tunnel_id ↗ ❏ tunnel(id) | |
| tunnel_inst_hspace_fk | tunnel_hollow_space_id ↗ ❏ tunnel_hollow_space(id) | |
| Referring Foreign Keys | ||
| tun_them_srf_tun_inst_fk | id ↙ ❏ tunnel_thematic_surface(tunnel_installation_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | tunnel_opening_id | bigint |
| * | tunnel_thematic_surface_id | bigint |
| Indexes | ||
| tunnel_open_to_them_srf_pk | ON tunnel_opening_id, tunnel_thematic_surface_id | |
| tun_open_to_them_srf_fkx | ON tunnel_opening_id | |
| tun_open_to_them_srf_fkx1 | ON tunnel_thematic_surface_id | |
| Foreign Keys | ||
| tun_open_to_them_srf_fk | tunnel_opening_id ↗ ❏ tunnel_opening(id) | |
| tun_open_to_them_srf_fk1 | tunnel_thematic_surface_id ↗ ❏ tunnel_thematic_surface(id) | |
| 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 | ON id | |
| tunnel_open_objclass_fkx | ON objectclass_id | |
| tunnel_open_lod3msrf_fkx | ON lod3_multi_surface_id | |
| tunnel_open_lod4msrf_fkx | ON lod4_multi_surface_id | |
| tunnel_open_lod3impl_fkx | ON lod3_implicit_rep_id | |
| tunnel_open_lod4impl_fkx | ON lod4_implicit_rep_id | |
| tunnel_open_lod3refpt_spx | ON lod3_implicit_ref_point | |
| tunnel_open_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| tunnel_open_cityobject_fk | id ↗ ❏ cityobject | |
| tunnel_open_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| tunnel_open_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| tunnel_open_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tunnel_open_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| tun_open_to_them_srf_fk | id ↙ ❏ tunnel_open_to_them_srf(tunnel_opening_id) | |
| 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 | ON id | |
| tun_them_srf_objclass_fkx | ON objectclass_id | |
| tun_them_srf_tunnel_fkx | ON tunnel_id | |
| tun_them_srf_hspace_fkx | ON tunnel_hollow_space_id | |
| tun_them_srf_tun_inst_fkx | ON tunnel_installation_id | |
| tun_them_srf_lod2msrf_fkx | ON lod2_multi_surface_id | |
| tun_them_srf_lod3msrf_fkx | ON lod3_multi_surface_id | |
| tun_them_srf_lod4msrf_fkx | ON lod4_multi_surface_id | |
| Foreign Keys | ||
| tun_them_srf_cityobj_fk | id ↗ ❏ cityobject | |
| tun_them_srf_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tun_them_srf_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tun_them_srf_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| tun_them_srf_tunnel_fk | tunnel_id ↗ ❏ tunnel(id) | |
| tun_them_srf_hspace_fk | tunnel_hollow_space_id ↗ ❏ tunnel_hollow_space(id) | |
| tun_them_srf_tun_inst_fk | tunnel_installation_id ↗ ❏ tunnel_installation(id) | |
| Referring Foreign Keys | ||
| tun_open_to_them_srf_fk1 | id ↙ ❏ tunnel_open_to_them_srf(tunnel_thematic_surface_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | waterboundary_surface_id | bigint |
| * | waterbody_id | bigint |
| Indexes | ||
| waterbod_to_waterbnd_pk | ON waterboundary_surface_id, waterbody_id | |
| waterbod_to_waterbnd_fkx | ON waterboundary_surface_id | |
| waterbod_to_waterbnd_fkx1 | ON waterbody_id | |
| Foreign Keys | ||
| waterbod_to_waterbnd_fk1 | waterbody_id ↗ ❏ waterbody(id) | |
| waterbod_to_waterbnd_fk | waterboundary_surface_id ↗ ❏ waterboundary_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) | |
| lod0_multi_curve | geometry | |
| lod1_multi_curve | geometry | |
| lod0_multi_surface_id | bigint | |
| lod1_multi_surface_id | bigint | |
| lod1_solid_id | bigint | |
| lod2_solid_id | bigint | |
| lod3_solid_id | bigint | |
| lod4_solid_id | bigint | |
| Indexes | ||
| waterbody_pk | ON id | |
| waterbody_lod0msrf_fkx | ON lod0_multi_surface_id | |
| waterbody_lod1msrf_fkx | ON lod1_multi_surface_id | |
| waterbody_lod1solid_fkx | ON lod1_solid_id | |
| waterbody_lod2solid_fkx | ON lod2_solid_id | |
| waterbody_lod3solid_fkx | ON lod3_solid_id | |
| waterbody_lod4solid_fkx | ON lod4_solid_id | |
| waterbody_objclass_fkx | ON objectclass_id | |
| waterbody_lod0curve_spx | ON lod0_multi_curve | |
| waterbody_lod1curve_spx | ON lod1_multi_curve | |
| Foreign Keys | ||
| waterbody_cityobject_fk | id ↗ ❏ cityobject | |
| waterbody_lod0msrf_fk | lod0_multi_surface_id ↗ ❏ surface_geometry(id) | |
| waterbody_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| waterbody_lod1solid_fk | lod1_solid_id ↗ ❏ surface_geometry(id) | |
| waterbody_lod2solid_fk | lod2_solid_id ↗ ❏ surface_geometry(id) | |
| waterbody_lod3solid_fk | lod3_solid_id ↗ ❏ surface_geometry(id) | |
| waterbody_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| waterbod_to_waterbnd_fk1 | id ↙ ❏ waterbod_to_waterbnd_srf(waterbody_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| water_level | varchar(256) | |
| water_level_codespace | varchar(4000) | |
| lod2_surface_id | bigint | |
| lod3_surface_id | bigint | |
| lod4_surface_id | bigint | |
| Indexes | ||
| waterboundary_surface_pk | ON id | |
| waterbnd_srf_objclass_fkx | ON objectclass_id | |
| waterbnd_srf_lod2srf_fkx | ON lod2_surface_id | |
| waterbnd_srf_lod3srf_fkx | ON lod3_surface_id | |
| waterbnd_srf_lod4srf_fkx | ON lod4_surface_id | |
| Foreign Keys | ||
| waterbnd_srf_cityobject_fk | id ↗ ❏ cityobject | |
| waterbnd_srf_lod2srf_fk | lod2_surface_id ↗ ❏ surface_geometry(id) | |
| waterbnd_srf_lod3srf_fk | lod3_surface_id ↗ ❏ surface_geometry(id) | |
| waterbnd_srf_lod4srf_fk | lod4_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| waterbod_to_waterbnd_fk | id ↙ ❏ waterbod_to_waterbnd_srf(waterboundary_surface_id) | |