| 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('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 | 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 |
| * | 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) | |