3DCityDB v4 - Database Schema - AIO
HTML Mode
Click Here to View same Document in Interactive HTML Mode
All-in-One Layout
Tables
- citydb.address 2. citydb.address_to_bridge 3. citydb.address_to_building 4. citydb.ade 5. citydb.aggregation_info 6. citydb.appear_to_surface_data 7. citydb.appearance 8. citydb.breakline_relief 9. citydb.bridge 10. citydb.bridge_constr_element 11. citydb.bridge_furniture 12. citydb.bridge_installation 13. citydb.bridge_open_to_them_srf 14. citydb.bridge_opening 15. citydb.bridge_room 16. citydb.bridge_thematic_surface 17. citydb.building 18. citydb.building_furniture 19. citydb.building_installation 20. citydb.city_furniture 21. citydb.citymodel 22. citydb.cityobject 23. citydb.cityobject_genericattrib 24. citydb.cityobject_member 25. citydb.cityobjectgroup 26. citydb.database_srs 27. citydb.external_reference 28. citydb.generalization 29. citydb.generic_cityobject 30. citydb.grid_coverage 31. citydb.group_to_cityobject 32. citydb.implicit_geometry 33. citydb.index_table 34. citydb.land_use 35. citydb.masspoint_relief 36. citydb.objectclass 37. citydb.opening 38. citydb.opening_to_them_surface 39. citydb.plant_cover 40. citydb.raster_relief 41. citydb.relief_component 42. citydb.relief_feat_to_rel_comp 43. citydb.relief_feature 44. citydb.room 45. citydb.schema 46. citydb.schema_referencing 47. citydb.schema_to_objectclass 48. citydb.solitary_vegetat_object 49. citydb.surface_data 50. citydb.surface_geometry 51. citydb.tex_image 52. citydb.textureparam 53. citydb.thematic_surface 54. citydb.tin_relief 55. citydb.traffic_area 56. citydb.transportation_complex 57. citydb.tunnel 58. citydb.tunnel_furniture 59. citydb.tunnel_hollow_space 60. citydb.tunnel_installation 61. citydb.tunnel_open_to_them_srf 62. citydb.tunnel_opening 63. citydb.tunnel_thematic_surface 64. citydb.waterbod_to_waterbnd_srf 65. citydb.waterbody 66. citydb.waterboundary_surface
Table address
| 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 | |
| 🔎 | address_inx | |
| 🔎 | address_point_spx |
Table address_to_bridge
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | bridge_id | bigint |
| *🔑 ⬈ | address_id | bigint |
| Indexes | ||
| 🔑 | address_to_bridge_pk | |
| 🔎 | address_to_bridge_fkx | |
| 🔎 | address_to_bridge_fkx1 | |
| Foreign Keys | ||
| address_to_bridge_fk | ( address_id ) ref citydb.address (id) | |
| address_to_bridge_fk1 | ( bridge_id ) ref citydb.bridge (id) |
Table address_to_building
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | building_id | bigint |
| *🔑 ⬈ | address_id | bigint |
| Indexes | ||
| 🔑 | address_to_building_pk | |
| 🔎 | address_to_building_fkx | |
| 🔎 | address_to_building_fkx1 | |
| Foreign Keys | ||
| address_to_building_fk | ( address_id ) ref citydb.address (id) | |
| address_to_building_fk1 | ( building_id ) ref citydb.building (id) |
Table ade
| 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 |
Table aggregation_info
| Idx | Field Name | Data Type |
|---|---|---|
| * | child_id | integer |
| * | parent_id | integer |
| min_occurs | integer | |
| max_occurs | integer | |
| is_composite | numeric |
Table appear_to_surface_data
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | surface_data_id | bigint |
| *🔑 ⬈ | appearance_id | bigint |
| Indexes | ||
| 🔑 | appear_to_surface_data_pk | |
| 🔎 | app_to_surf_data_fkx | |
| 🔎 | app_to_surf_data_fkx1 | |
| Foreign Keys | ||
| app_to_surf_data_fk1 | ( appearance_id ) ref citydb.appearance (id) | |
| app_to_surf_data_fk | ( surface_data_id ) ref citydb.surface_data (id) |
Table appearance
| 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 | |
| 🔎 | appearance_inx | |
| 🔎 | appearance_theme_inx | |
| 🔎 | appearance_citymodel_fkx | |
| 🔎 | appearance_cityobject_fkx | |
| Foreign Keys | ||
| appearance_citymodel_fk | ( citymodel_id ) ref citydb.citymodel (id) | |
| appearance_cityobject_fk | ( cityobject_id ) ref citydb.cityobject (id) |
Table breakline_relief
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 | ridge_or_valley_lines | geometry |
| 🔎 | break_lines | geometry |
| Indexes | ||
| 🔑 | breakline_relief_pk | |
| 🔎 | breakline_rel_objclass_fkx | |
| 🔎 | breakline_ridge_spx | |
| 🔎 | breakline_break_spx | |
| Foreign Keys | ||
| breakline_relief_comp_fk | ( id ) ref citydb.relief_component (id) |
Table bridge
| 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 | |
| 🔎 | bridge_parent_fkx | |
| 🔎 | bridge_root_fkx | |
| 🔎 | bridge_lod1msrf_fkx | |
| 🔎 | bridge_lod2msrf_fkx | |
| 🔎 | bridge_lod3msrf_fkx | |
| 🔎 | bridge_lod4msrf_fkx | |
| 🔎 | bridge_lod1solid_fkx | |
| 🔎 | bridge_lod2solid_fkx | |
| 🔎 | bridge_lod3solid_fkx | |
| 🔎 | bridge_lod4solid_fkx | |
| 🔎 | bridge_objectclass_fkx | |
| 🔎 | bridge_lod1terr_spx | |
| 🔎 | bridge_lod2terr_spx | |
| 🔎 | bridge_lod3terr_spx | |
| 🔎 | bridge_lod4terr_spx | |
| 🔎 | bridge_lod2curve_spx | |
| 🔎 | bridge_lod3curve_spx | |
| 🔎 | bridge_lod4curve_spx | |
| Foreign Keys | ||
| bridge_parent_fk | ( bridge_parent_id ) ref citydb.bridge (id) | |
| bridge_root_fk | ( bridge_root_id ) ref citydb.bridge (id) | |
| bridge_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod1solid_fk | ( lod1_solid_id ) ref citydb.surface_geometry (id) | |
| bridge_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod2solid_fk | ( lod2_solid_id ) ref citydb.surface_geometry (id) | |
| bridge_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod3solid_fk | ( lod3_solid_id ) ref citydb.surface_geometry (id) | |
| bridge_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table bridge_constr_element
| 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 | |
| 🔎 | bridge_constr_bridge_fkx | |
| 🔎 | bridge_constr_lod1brep_fkx | |
| 🔎 | bridge_constr_lod2brep_fkx | |
| 🔎 | bridge_constr_lod3brep_fkx | |
| 🔎 | bridge_constr_lod4brep_fkx | |
| 🔎 | bridge_constr_lod1impl_fkx | |
| 🔎 | bridge_constr_lod2impl_fkx | |
| 🔎 | bridge_constr_lod3impl_fkx | |
| 🔎 | bridge_constr_lod4impl_fkx | |
| 🔎 | bridge_constr_objclass_fkx | |
| 🔎 | bridge_constr_lod1terr_spx | |
| 🔎 | bridge_constr_lod2terr_spx | |
| 🔎 | bridge_constr_lod3terr_spx | |
| 🔎 | bridge_constr_lod4terr_spx | |
| 🔎 | bridge_const_lod1xgeom_spx | |
| 🔎 | bridge_const_lod2xgeom_spx | |
| 🔎 | bridge_const_lod3xgeom_spx | |
| 🔎 | bridge_const_lod4xgeom_spx | |
| 🔎 | bridge_const_lod1refpt_spx | |
| 🔎 | bridge_const_lod2refpt_spx | |
| 🔎 | bridge_const_lod3refpt_spx | |
| 🔎 | bridge_const_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_constr_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| bridge_constr_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_constr_lod1impl_fk | ( lod1_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_constr_lod1brep_fk | ( lod1_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_constr_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_constr_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_constr_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table bridge_furniture
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | 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 | |
| 🔎 | bridge_furn_brd_room_fkx | |
| 🔎 | bridge_furn_lod4brep_fkx | |
| 🔎 | bridge_furn_lod4impl_fkx | |
| 🔎 | bridge_furn_objclass_fkx | |
| 🔎 | bridge_furn_lod4xgeom_spx | |
| 🔎 | bridge_furn_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_furn_brd_room_fk | ( bridge_room_id ) ref citydb.bridge_room (id) | |
| bridge_furn_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_furn_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_furn_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table bridge_installation
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | 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 | |
| 🔎 | bridge_inst_objclass_fkx | |
| 🔎 | bridge_inst_bridge_fkx | |
| 🔎 | bridge_inst_brd_room_fkx | |
| 🔎 | bridge_inst_lod2brep_fkx | |
| 🔎 | bridge_inst_lod3brep_fkx | |
| 🔎 | bridge_inst_lod4brep_fkx | |
| 🔎 | bridge_inst_lod2impl_fkx | |
| 🔎 | bridge_inst_lod3impl_fkx | |
| 🔎 | bridge_inst_lod4impl_fkx | |
| 🔎 | bridge_inst_lod2xgeom_spx | |
| 🔎 | bridge_inst_lod3xgeom_spx | |
| 🔎 | bridge_inst_lod4xgeom_spx | |
| 🔎 | bridge_inst_lod2refpt_spx | |
| 🔎 | bridge_inst_lod3refpt_spx | |
| 🔎 | bridge_inst_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_inst_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| bridge_inst_brd_room_fk | ( bridge_room_id ) ref citydb.bridge_room (id) | |
| bridge_inst_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_inst_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_inst_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_inst_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_inst_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_inst_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| bridge_inst_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table bridge_open_to_them_srf
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | bridge_opening_id | bigint |
| *🔑 ⬈ | bridge_thematic_surface_id | bigint |
| Indexes | ||
| 🔑 | bridge_open_to_them_srf_pk | |
| 🔎 | brd_open_to_them_srf_fkx | |
| 🔎 | brd_open_to_them_srf_fkx1 | |
| Foreign Keys | ||
| brd_open_to_them_srf_fk | ( bridge_opening_id ) ref citydb.bridge_opening (id) | |
| brd_open_to_them_srf_fk1 | ( bridge_thematic_surface_id ) ref citydb.bridge_thematic_surface (id) |
Table bridge_opening
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | address_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | bridge_opening_pk | |
| 🔎 | bridge_open_objclass_fkx | |
| 🔎 | bridge_open_address_fkx | |
| 🔎 | bridge_open_lod3msrf_fkx | |
| 🔎 | bridge_open_lod4msrf_fkx | |
| 🔎 | bridge_open_lod3impl_fkx | |
| 🔎 | bridge_open_lod4impl_fkx | |
| 🔎 | bridge_open_lod3refpt_spx | |
| 🔎 | bridge_open_lod4refpt_spx | |
| Foreign Keys | ||
| bridge_open_address_fk | ( address_id ) ref citydb.address (id) | |
| bridge_open_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_open_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_open_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bridge_open_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_open_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table bridge_room
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | bridge_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | bridge_room_pk | |
| 🔎 | bridge_room_bridge_fkx | |
| 🔎 | bridge_room_lod4msrf_fkx | |
| 🔎 | bridge_room_lod4solid_fkx | |
| 🔎 | bridge_room_objclass_fkx | |
| Foreign Keys | ||
| bridge_room_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| bridge_room_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bridge_room_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| bridge_room_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table bridge_thematic_surface
| 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 | |
| 🔎 | brd_them_srf_objclass_fkx | |
| 🔎 | brd_them_srf_bridge_fkx | |
| 🔎 | brd_them_srf_brd_room_fkx | |
| 🔎 | brd_them_srf_brd_inst_fkx | |
| 🔎 | brd_them_srf_brd_const_fkx | |
| 🔎 | brd_them_srf_lod2msrf_fkx | |
| 🔎 | brd_them_srf_lod3msrf_fkx | |
| 🔎 | brd_them_srf_lod4msrf_fkx | |
| Foreign Keys | ||
| brd_them_srf_bridge_fk | ( bridge_id ) ref citydb.bridge (id) | |
| brd_them_srf_brd_const_fk | ( bridge_constr_element_id ) ref citydb.bridge_constr_element (id) | |
| brd_them_srf_brd_inst_fk | ( bridge_installation_id ) ref citydb.bridge_installation (id) | |
| brd_them_srf_brd_room_fk | ( bridge_room_id ) ref citydb.bridge_room (id) | |
| brd_them_srf_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| brd_them_srf_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| brd_them_srf_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| brd_them_srf_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table building
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | building_parent_id | bigint |
| 🔎 ⬈ | building_root_id | bigint |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| year_of_construction | date | |
| year_of_demolition | date | |
| roof_type | varchar(256) | |
| roof_type_codespace | varchar(4000) | |
| measured_height | double precision | |
| measured_height_unit | varchar(4000) | |
| storeys_above_ground | numeric(8,0) | |
| storeys_below_ground | numeric(8,0) | |
| storey_heights_above_ground | varchar(4000) | |
| storey_heights_ag_unit | varchar(4000) | |
| storey_heights_below_ground | varchar(4000) | |
| storey_heights_bg_unit | varchar(4000) | |
| 🔎 | lod1_terrain_intersection | geometry |
| 🔎 | lod2_terrain_intersection | geometry |
| 🔎 | lod3_terrain_intersection | geometry |
| 🔎 | lod4_terrain_intersection | geometry |
| 🔎 | lod2_multi_curve | geometry |
| 🔎 | lod3_multi_curve | geometry |
| 🔎 | lod4_multi_curve | geometry |
| 🔎 ⬈ | lod0_footprint_id | bigint |
| 🔎 ⬈ | lod0_roofprint_id | bigint |
| 🔎 ⬈ | lod1_multi_surface_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod1_solid_id | bigint |
| 🔎 ⬈ | lod2_solid_id | bigint |
| 🔎 ⬈ | lod3_solid_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | building_pk | |
| 🔎 | building_parent_fkx | |
| 🔎 | building_root_fkx | |
| 🔎 | building_lod0footprint_fkx | |
| 🔎 | building_lod0roofprint_fkx | |
| 🔎 | building_lod1msrf_fkx | |
| 🔎 | building_lod2msrf_fkx | |
| 🔎 | building_lod3msrf_fkx | |
| 🔎 | building_lod4msrf_fkx | |
| 🔎 | building_lod1solid_fkx | |
| 🔎 | building_lod2solid_fkx | |
| 🔎 | building_lod3solid_fkx | |
| 🔎 | building_lod4solid_fkx | |
| 🔎 | building_objectclass_fkx | |
| 🔎 | building_lod1terr_spx | |
| 🔎 | building_lod2terr_spx | |
| 🔎 | building_lod3terr_spx | |
| 🔎 | building_lod4terr_spx | |
| 🔎 | building_lod2curve_spx | |
| 🔎 | building_lod3curve_spx | |
| 🔎 | building_lod4curve_spx | |
| Foreign Keys | ||
| building_parent_fk | ( building_parent_id ) ref citydb.building (id) | |
| building_root_fk | ( building_root_id ) ref citydb.building (id) | |
| building_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| building_lod0footprint_fk | ( lod0_footprint_id ) ref citydb.surface_geometry (id) | |
| building_lod0roofprint_fk | ( lod0_roofprint_id ) ref citydb.surface_geometry (id) | |
| building_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod1solid_fk | ( lod1_solid_id ) ref citydb.surface_geometry (id) | |
| building_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod2solid_fk | ( lod2_solid_id ) ref citydb.surface_geometry (id) | |
| building_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod3solid_fk | ( lod3_solid_id ) ref citydb.surface_geometry (id) | |
| building_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| building_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table building_furniture
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | room_id | bigint |
| 🔎 ⬈ | lod4_brep_id | bigint |
| 🔎 | lod4_other_geom | geometry |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | building_furniture_pk | |
| 🔎 | bldg_furn_room_fkx | |
| 🔎 | bldg_furn_lod4brep_fkx | |
| 🔎 | bldg_furn_lod4impl_fkx | |
| 🔎 | bldg_furn_objclass_fkx | |
| 🔎 | bldg_furn_lod4xgeom_spx | |
| 🔎 | bldg_furn_lod4refpt_spx | |
| Foreign Keys | ||
| bldg_furn_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bldg_furn_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_furn_room_fk | ( room_id ) ref citydb.room (id) | |
| bldg_furn_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table building_installation
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | building_id | bigint |
| 🔎 ⬈ | room_id | bigint |
| 🔎 ⬈ | lod2_brep_id | bigint |
| 🔎 ⬈ | lod3_brep_id | bigint |
| 🔎 ⬈ | lod4_brep_id | bigint |
| 🔎 | lod2_other_geom | geometry |
| 🔎 | lod3_other_geom | geometry |
| 🔎 | lod4_other_geom | geometry |
| 🔎 ⬈ | lod2_implicit_rep_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod2_implicit_ref_point | geometry |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod2_implicit_transformation | varchar(1000) | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | building_installation_pk | |
| 🔎 | bldg_inst_objclass_fkx | |
| 🔎 | bldg_inst_building_fkx | |
| 🔎 | bldg_inst_room_fkx | |
| 🔎 | bldg_inst_lod2brep_fkx | |
| 🔎 | bldg_inst_lod3brep_fkx | |
| 🔎 | bldg_inst_lod4brep_fkx | |
| 🔎 | bldg_inst_lod2impl_fkx | |
| 🔎 | bldg_inst_lod3impl_fkx | |
| 🔎 | bldg_inst_lod4impl_fkx | |
| 🔎 | bldg_inst_lod2xgeom_spx | |
| 🔎 | bldg_inst_lod3xgeom_spx | |
| 🔎 | bldg_inst_lod4xgeom_spx | |
| 🔎 | bldg_inst_lod2refpt_spx | |
| 🔎 | bldg_inst_lod3refpt_spx | |
| 🔎 | bldg_inst_lod4refpt_spx | |
| Foreign Keys | ||
| bldg_inst_building_fk | ( building_id ) ref citydb.building (id) | |
| bldg_inst_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| bldg_inst_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_inst_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_inst_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| bldg_inst_room_fk | ( room_id ) ref citydb.room (id) | |
| bldg_inst_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| bldg_inst_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| bldg_inst_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table city_furniture
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 | 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 | |
| 🔎 | city_furn_lod1brep_fkx | |
| 🔎 | city_furn_lod2brep_fkx | |
| 🔎 | city_furn_lod3brep_fkx | |
| 🔎 | city_furn_lod4brep_fkx | |
| 🔎 | city_furn_lod1impl_fkx | |
| 🔎 | city_furn_lod2impl_fkx | |
| 🔎 | city_furn_lod3impl_fkx | |
| 🔎 | city_furn_lod4impl_fkx | |
| 🔎 | city_furn_objclass_fkx | |
| 🔎 | city_furn_lod1terr_spx | |
| 🔎 | city_furn_lod2terr_spx | |
| 🔎 | city_furn_lod3terr_spx | |
| 🔎 | city_furn_lod4terr_spx | |
| 🔎 | city_furn_lod1xgeom_spx | |
| 🔎 | city_furn_lod2xgeom_spx | |
| 🔎 | city_furn_lod3xgeom_spx | |
| 🔎 | city_furn_lod4xgeom_spx | |
| 🔎 | city_furn_lod1refpnt_spx | |
| 🔎 | city_furn_lod2refpnt_spx | |
| 🔎 | city_furn_lod3refpnt_spx | |
| 🔎 | city_furn_lod4refpnt_spx | |
| Foreign Keys | ||
| city_furn_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| city_furn_lod1impl_fk | ( lod1_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| city_furn_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| city_furn_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| city_furn_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| city_furn_lod1brep_fk | ( lod1_brep_id ) ref citydb.surface_geometry (id) | |
| city_furn_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| city_furn_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| city_furn_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table citymodel
| 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 | |
| 🔎 | citymodel_inx | |
| 🔎 | citymodel_envelope_spx |
Table cityobject
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('cityobject_seq'::regclass) |
| *🔎 | objectclass_id | integer |
| 🔎 | gmlid | varchar(256) |
| 🔎 | gmlid_codespace | varchar(1000) |
| name | varchar(1000) | |
| name_codespace | varchar(4000) | |
| description | varchar(4000) | |
| 🔎 | envelope | geometry |
| 🔎 | creation_date | timestamptz |
| 🔎 | termination_date | timestamptz |
| relative_to_terrain | varchar(256) | |
| relative_to_water | varchar(256) | |
| 🔎 | last_modification_date | timestamptz |
| updating_person | varchar(256) | |
| reason_for_update | varchar(4000) | |
| 🔎 | lineage | varchar(256) |
| xml_source | text | |
| Indexes | ||
| 🔑 | cityobject_pk | |
| 🔎 | cityobject_inx | |
| 🔎 | cityobject_objectclass_fkx | |
| 🔎 | cityobject_lineage_inx | |
| 🔎 | cityobj_creation_date_inx | |
| 🔎 | cityobj_term_date_inx | |
| 🔎 | cityobj_last_mod_date_inx | |
| 🔎 | cityobject_envelope_spx |
Table cityobject_genericattrib
| 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 | |
| 🔎 | genericattrib_parent_fkx | |
| 🔎 | genericattrib_root_fkx | |
| 🔎 | genericattrib_geom_fkx | |
| 🔎 | genericattrib_cityobj_fkx | |
| 🔎 | genericattrib_datatype_btr | |
| Foreign Keys | ||
| genericattrib_cityobj_fk | ( cityobject_id ) ref citydb.cityobject (id) | |
| genericattrib_parent_fk | ( parent_genattrib_id ) ref citydb.cityobject_genericattrib (id) | |
| genericattrib_root_fk | ( root_genattrib_id ) ref citydb.cityobject_genericattrib (id) | |
| genericattrib_geom_fk | ( surface_geometry_id ) ref citydb.surface_geometry (id) |
Table cityobject_member
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | citymodel_id | bigint |
| *🔑 ⬈ | cityobject_id | bigint |
| Indexes | ||
| 🔑 | cityobject_member_pk | |
| 🔎 | cityobject_member_fkx | |
| 🔎 | cityobject_member_fkx1 | |
| Foreign Keys | ||
| cityobject_member_fk1 | ( citymodel_id ) ref citydb.citymodel (id) | |
| cityobject_member_fk | ( cityobject_id ) ref citydb.cityobject (id) |
Table cityobjectgroup
| 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 | |
| 🔎 | group_brep_fkx | |
| 🔎 | group_parent_cityobj_fkx | |
| 🔎 | group_objectclass_fkx | |
| 🔎 | group_xgeom_spx | |
| Foreign Keys | ||
| group_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| group_parent_cityobj_fk | ( parent_cityobject_id ) ref citydb.cityobject (id) | |
| group_brep_fk | ( brep_id ) ref citydb.surface_geometry (id) |
Table database_srs
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 | srid | integer |
| gml_srs_name | varchar(1000) | |
| Indexes | ||
| 🔑 | database_srs_pk |
Table external_reference
| 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 | |
| 🔎 | ext_ref_cityobject_fkx | |
| Foreign Keys | ||
| ext_ref_cityobject_fk | ( cityobject_id ) ref citydb.cityobject (id) |
Table generalization
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | cityobject_id | bigint |
| *🔑 ⬈ | generalizes_to_id | bigint |
| Indexes | ||
| 🔑 | generalization_pk | |
| 🔎 | general_cityobject_fkx | |
| 🔎 | general_generalizes_to_fkx | |
| Foreign Keys | ||
| general_cityobject_fk | ( cityobject_id ) ref citydb.cityobject (id) | |
| general_generalizes_to_fk | ( generalizes_to_id ) ref citydb.cityobject (id) |
Table generic_cityobject
| 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 | |
| 🔎 | gen_object_lod0brep_fkx | |
| 🔎 | gen_object_lod1brep_fkx | |
| 🔎 | gen_object_lod2brep_fkx | |
| 🔎 | gen_object_lod3brep_fkx | |
| 🔎 | gen_object_lod4brep_fkx | |
| 🔎 | gen_object_lod0impl_fkx | |
| 🔎 | gen_object_lod1impl_fkx | |
| 🔎 | gen_object_lod2impl_fkx | |
| 🔎 | gen_object_lod3impl_fkx | |
| 🔎 | gen_object_lod4impl_fkx | |
| 🔎 | gen_object_objclass_fkx | |
| 🔎 | gen_object_lod0terr_spx | |
| 🔎 | gen_object_lod1terr_spx | |
| 🔎 | gen_object_lod2terr_spx | |
| 🔎 | gen_object_lod3terr_spx | |
| 🔎 | gen_object_lod4terr_spx | |
| 🔎 | gen_object_lod0xgeom_spx | |
| 🔎 | gen_object_lod1xgeom_spx | |
| 🔎 | gen_object_lod2xgeom_spx | |
| 🔎 | gen_object_lod3xgeom_spx | |
| 🔎 | gen_object_lod4xgeom_spx | |
| 🔎 | gen_object_lod0refpnt_spx | |
| 🔎 | gen_object_lod1refpnt_spx | |
| 🔎 | gen_object_lod2refpnt_spx | |
| 🔎 | gen_object_lod3refpnt_spx | |
| 🔎 | gen_object_lod4refpnt_spx | |
| Foreign Keys | ||
| gen_object_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| gen_object_lod0impl_fk | ( lod0_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| gen_object_lod1impl_fk | ( lod1_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| gen_object_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| gen_object_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| gen_object_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| gen_object_lod0brep_fk | ( lod0_brep_id ) ref citydb.surface_geometry (id) | |
| gen_object_lod1brep_fk | ( lod1_brep_id ) ref citydb.surface_geometry (id) | |
| gen_object_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| gen_object_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| gen_object_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table grid_coverage
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('grid_coverage_seq'::regclass) |
| rasterproperty | raster | |
| 🔎 | st_convexhull(rasterproperty) | varchar |
| Indexes | ||
| 🔑 | grid_coverage_pk | |
| 🔎 | grid_coverage_raster_spx |
Table group_to_cityobject
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | cityobject_id | bigint |
| *🔑 ⬈ | cityobjectgroup_id | bigint |
| role | varchar(256) | |
| Indexes | ||
| 🔑 | group_to_cityobject_pk | |
| 🔎 | group_to_cityobject_fkx | |
| 🔎 | group_to_cityobject_fkx1 | |
| Foreign Keys | ||
| group_to_cityobject_fk | ( cityobject_id ) ref citydb.cityobject (id) | |
| group_to_cityobject_fk1 | ( cityobjectgroup_id ) ref citydb.cityobjectgroup (id) |
Table implicit_geometry
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('implicit_geometry_seq'::regclass) |
| mime_type | varchar(256) | |
| 🔎 | reference_to_library | varchar(4000) |
| library_object | bytea | |
| 🔎 ⬈ | relative_brep_id | bigint |
| relative_other_geom | geometry | |
| Indexes | ||
| 🔑 | implicit_geometry_pk | |
| 🔎 | implicit_geom_ref2lib_inx | |
| 🔎 | implicit_geom_brep_fkx | |
| Foreign Keys | ||
| implicit_geom_brep_fk | ( relative_brep_id ) ref citydb.surface_geometry (id) |
Table index_table
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 | id | integer DEFAULT nextval('index_table_id_seq'::regclass) |
| obj | index_obj | |
| Indexes | ||
| 🔑 | index_table_pkey |
Table land_use
| 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 | |
| 🔎 | land_use_lod0msrf_fkx | |
| 🔎 | land_use_lod1msrf_fkx | |
| 🔎 | land_use_lod2msrf_fkx | |
| 🔎 | land_use_lod3msrf_fkx | |
| 🔎 | land_use_lod4msrf_fkx | |
| 🔎 | land_use_objclass_fkx | |
| Foreign Keys | ||
| land_use_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| land_use_lod0msrf_fk | ( lod0_multi_surface_id ) ref citydb.surface_geometry (id) | |
| land_use_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| land_use_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| land_use_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| land_use_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table masspoint_relief
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 | relief_points | geometry |
| Indexes | ||
| 🔑 | masspoint_relief_pk | |
| 🔎 | masspoint_rel_objclass_fkx | |
| 🔎 | masspoint_relief_spx | |
| Foreign Keys | ||
| masspoint_relief_comp_fk | ( id ) ref citydb.relief_component (id) |
Table objectclass
| 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 | |
| Foreign Keys | ||
| fk_t_objectclass_baseclass_id | ( baseclass_id ) ref citydb.objectclass (id) | |
| fk_t_objectclass_superclass_id | ( superclass_id ) ref citydb.objectclass (id) |
Table opening
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | address_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | opening_pk | |
| 🔎 | opening_objectclass_fkx | |
| 🔎 | opening_address_fkx | |
| 🔎 | opening_lod3msrf_fkx | |
| 🔎 | opening_lod4msrf_fkx | |
| 🔎 | opening_lod3impl_fkx | |
| 🔎 | opening_lod4impl_fkx | |
| 🔎 | opening_lod3refpt_spx | |
| 🔎 | opening_lod4refpt_spx | |
| Foreign Keys | ||
| opening_address_fk | ( address_id ) ref citydb.address (id) | |
| opening_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| opening_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| opening_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| opening_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| opening_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table opening_to_them_surface
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | opening_id | bigint |
| *🔑 ⬈ | thematic_surface_id | bigint |
| Indexes | ||
| 🔑 | opening_to_them_surface_pk | |
| 🔎 | open_to_them_surface_fkx | |
| 🔎 | open_to_them_surface_fkx1 | |
| Foreign Keys | ||
| open_to_them_surface_fk | ( opening_id ) ref citydb.opening (id) | |
| open_to_them_surface_fk1 | ( thematic_surface_id ) ref citydb.thematic_surface (id) |
Table plant_cover
| 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 | |
| 🔎 | plant_cover_lod1msrf_fkx | |
| 🔎 | plant_cover_lod2msrf_fkx | |
| 🔎 | plant_cover_lod3msrf_fkx | |
| 🔎 | plant_cover_lod4msrf_fkx | |
| 🔎 | plant_cover_lod1msolid_fkx | |
| 🔎 | plant_cover_lod2msolid_fkx | |
| 🔎 | plant_cover_lod3msolid_fkx | |
| 🔎 | plant_cover_lod4msolid_fkx | |
| 🔎 | plant_cover_objclass_fkx | |
| Foreign Keys | ||
| plant_cover_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| plant_cover_lod1msolid_fk | ( lod1_multi_solid_id ) ref citydb.surface_geometry (id) | |
| plant_cover_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| plant_cover_lod2msolid_fk | ( lod2_multi_solid_id ) ref citydb.surface_geometry (id) | |
| plant_cover_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| plant_cover_lod3msolid_fk | ( lod3_multi_solid_id ) ref citydb.surface_geometry (id) | |
| plant_cover_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| plant_cover_lod4msolid_fk | ( lod4_multi_solid_id ) ref citydb.surface_geometry (id) | |
| plant_cover_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table raster_relief
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| raster_uri | varchar(4000) | |
| 🔎 ⬈ | coverage_id | bigint |
| Indexes | ||
| 🔑 | raster_relief_pk | |
| 🔎 | raster_relief_coverage_fkx | |
| 🔎 | raster_relief_objclass_fkx | |
| Foreign Keys | ||
| raster_relief_coverage_fk | ( coverage_id ) ref citydb.grid_coverage (id) | |
| raster_relief_comp_fk | ( id ) ref citydb.relief_component (id) |
Table relief_component
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| lod | numeric | |
| 🔎 | extent | geometry |
| Indexes | ||
| 🔑 | relief_component_pk | |
| 🔎 | relief_comp_objclass_fkx | |
| 🔎 | relief_comp_extent_spx | |
| Foreign Keys | ||
| relief_comp_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| Constraints | ||
| relief_comp_lod_chk | ((lod >= (0)::numeric) AND (lod < (5)::numeric)) |
Table relief_feat_to_rel_comp
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | relief_component_id | bigint |
| *🔑 ⬈ | relief_feature_id | bigint |
| Indexes | ||
| 🔑 | relief_feat_to_rel_comp_pk | |
| 🔎 | rel_feat_to_rel_comp_fkx | |
| 🔎 | rel_feat_to_rel_comp_fkx1 | |
| Foreign Keys | ||
| rel_feat_to_rel_comp_fk | ( relief_component_id ) ref citydb.relief_component (id) | |
| rel_feat_to_rel_comp_fk1 | ( relief_feature_id ) ref citydb.relief_feature (id) |
Table relief_feature
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| lod | numeric | |
| Indexes | ||
| 🔑 | relief_feature_pk | |
| 🔎 | relief_feat_objclass_fkx | |
| Foreign Keys | ||
| relief_feat_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| Constraints | ||
| relief_feat_lod_chk | ((lod >= (0)::numeric) AND (lod < (5)::numeric)) |
Table room
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | building_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | room_pk | |
| 🔎 | room_building_fkx | |
| 🔎 | room_lod4msrf_fkx | |
| 🔎 | room_lod4solid_fkx | |
| 🔎 | room_objectclass_fkx | |
| Foreign Keys | ||
| room_building_fk | ( building_id ) ref citydb.building (id) | |
| room_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| room_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| room_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table schema
| 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 | |
| Foreign Keys | ||
| schema_ade_fk | ( ade_id ) ref citydb.ade (id) |
Table schema_referencing
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | referencing_id | integer |
| *🔑 ⬈ | referenced_id | integer |
| Indexes | ||
| 🔑 | schema_referencing_pk | |
| 🔎 | schema_referencing_fkx1 | |
| 🔎 | schema_referencing_fkx2 | |
| Foreign Keys | ||
| schema_referencing_fk1 | ( referencing_id ) ref citydb.schema (id) | |
| schema_referencing_fk2 | ( referenced_id ) ref citydb.schema (id) |
Table schema_to_objectclass
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | schema_id | integer |
| *🔑 | objectclass_id | integer |
| Indexes | ||
| 🔑 | schema_to_objectclass_pk | |
| 🔎 | schema_to_objectclass_fkx1 | |
| 🔎 | schema_to_objectclass_fkx2 | |
| Foreign Keys | ||
| schema_to_objectclass_fk1 | ( schema_id ) ref citydb.schema (id) |
Table solitary_vegetat_object
| 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 | |
| 🔎 | sol_veg_obj_lod1brep_fkx | |
| 🔎 | sol_veg_obj_lod2brep_fkx | |
| 🔎 | sol_veg_obj_lod3brep_fkx | |
| 🔎 | sol_veg_obj_lod4brep_fkx | |
| 🔎 | sol_veg_obj_lod1impl_fkx | |
| 🔎 | sol_veg_obj_lod2impl_fkx | |
| 🔎 | sol_veg_obj_lod3impl_fkx | |
| 🔎 | sol_veg_obj_lod4impl_fkx | |
| 🔎 | sol_veg_obj_objclass_fkx | |
| 🔎 | sol_veg_obj_lod1xgeom_spx | |
| 🔎 | sol_veg_obj_lod2xgeom_spx | |
| 🔎 | sol_veg_obj_lod3xgeom_spx | |
| 🔎 | sol_veg_obj_lod4xgeom_spx | |
| 🔎 | sol_veg_obj_lod1refpt_spx | |
| 🔎 | sol_veg_obj_lod2refpt_spx | |
| 🔎 | sol_veg_obj_lod3refpt_spx | |
| 🔎 | sol_veg_obj_lod4refpt_spx | |
| Foreign Keys | ||
| sol_veg_obj_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| sol_veg_obj_lod1impl_fk | ( lod1_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| sol_veg_obj_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| sol_veg_obj_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| sol_veg_obj_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| sol_veg_obj_lod1brep_fk | ( lod1_brep_id ) ref citydb.surface_geometry (id) | |
| sol_veg_obj_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| sol_veg_obj_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| sol_veg_obj_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) |
Table surface_data
| 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 | |
| 🔎 | surface_data_inx | |
| 🔎 | surface_data_tex_image_fkx | |
| 🔎 | surface_data_objclass_fkx | |
| 🔎 | surface_data_spx | |
| Foreign Keys | ||
| surface_data_tex_image_fk | ( tex_image_id ) ref citydb.tex_image (id) |
Table surface_geometry
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('surface_geometry_seq'::regclass) |
| 🔎 | gmlid | varchar(256) |
| 🔎 | gmlid_codespace | varchar(1000) |
| 🔎 ⬈ | parent_id | bigint |
| 🔎 ⬈ | root_id | bigint |
| is_solid | numeric | |
| is_composite | numeric | |
| is_triangulated | numeric | |
| is_xlink | numeric | |
| is_reverse | numeric | |
| 🔎 | solid_geometry | geometry |
| 🔎 | geometry | geometry |
| implicit_geometry | geometry | |
| 🔎 ⬈ | cityobject_id | bigint |
| Indexes | ||
| 🔑 | surface_geometry_pk | |
| 🔎 | surface_geom_inx | |
| 🔎 | surface_geom_parent_fkx | |
| 🔎 | surface_geom_root_fkx | |
| 🔎 | surface_geom_cityobj_fkx | |
| 🔎 | surface_geom_solid_spx | |
| 🔎 | surface_geom_spx | |
| Foreign Keys | ||
| surface_geom_cityobj_fk | ( cityobject_id ) ref citydb.cityobject (id) | |
| surface_geom_parent_fk | ( parent_id ) ref citydb.surface_geometry (id) | |
| surface_geom_root_fk | ( root_id ) ref citydb.surface_geometry (id) |
Table tex_image
| 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 |
Table textureparam
| 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 | |
| 🔎 | texparam_geom_fkx | |
| 🔎 | texparam_surface_data_fkx | |
| Foreign Keys | ||
| texparam_surface_data_fk | ( surface_data_id ) ref citydb.surface_data (id) | |
| texparam_geom_fk | ( surface_geometry_id ) ref citydb.surface_geometry (id) |
Table thematic_surface
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | building_id | bigint |
| 🔎 ⬈ | room_id | bigint |
| 🔎 ⬈ | building_installation_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| Indexes | ||
| 🔑 | thematic_surface_pk | |
| 🔎 | them_surface_objclass_fkx | |
| 🔎 | them_surface_building_fkx | |
| 🔎 | them_surface_room_fkx | |
| 🔎 | them_surface_bldg_inst_fkx | |
| 🔎 | them_surface_lod2msrf_fkx | |
| 🔎 | them_surface_lod3msrf_fkx | |
| 🔎 | them_surface_lod4msrf_fkx | |
| Foreign Keys | ||
| them_surface_building_fk | ( building_id ) ref citydb.building (id) | |
| them_surface_bldg_inst_fk | ( building_installation_id ) ref citydb.building_installation (id) | |
| them_surface_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| them_surface_room_fk | ( room_id ) ref citydb.room (id) | |
| them_surface_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| them_surface_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| them_surface_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table tin_relief
| 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 | |
| 🔎 | tin_relief_geom_fkx | |
| 🔎 | tin_relief_objclass_fkx | |
| 🔎 | tin_relief_stop_spx | |
| 🔎 | tin_relief_break_spx | |
| 🔎 | tin_relief_crtlpts_spx | |
| Foreign Keys | ||
| tin_relief_comp_fk | ( id ) ref citydb.relief_component (id) | |
| tin_relief_geom_fk | ( surface_geometry_id ) ref citydb.surface_geometry (id) |
Table traffic_area
| 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 | |
| 🔎 | traffic_area_objclass_fkx | |
| 🔎 | traffic_area_lod2msrf_fkx | |
| 🔎 | traffic_area_lod3msrf_fkx | |
| 🔎 | traffic_area_lod4msrf_fkx | |
| 🔎 | traffic_area_trancmplx_fkx | |
| Foreign Keys | ||
| traffic_area_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| traffic_area_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| traffic_area_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| traffic_area_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| traffic_area_trancmplx_fk | ( transportation_complex_id ) ref citydb.transportation_complex (id) |
Table transportation_complex
| 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 | |
| 🔎 | tran_complex_objclass_fkx | |
| 🔎 | tran_complex_lod1msrf_fkx | |
| 🔎 | tran_complex_lod2msrf_fkx | |
| 🔎 | tran_complex_lod3msrf_fkx | |
| 🔎 | tran_complex_lod4msrf_fkx | |
| 🔎 | tran_complex_lod0net_spx | |
| Foreign Keys | ||
| tran_complex_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tran_complex_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tran_complex_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tran_complex_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tran_complex_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table tunnel
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | tunnel_parent_id | bigint |
| 🔎 ⬈ | tunnel_root_id | bigint |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| year_of_construction | date | |
| year_of_demolition | date | |
| 🔎 | lod1_terrain_intersection | geometry |
| 🔎 | lod2_terrain_intersection | geometry |
| 🔎 | lod3_terrain_intersection | geometry |
| 🔎 | lod4_terrain_intersection | geometry |
| 🔎 | lod2_multi_curve | geometry |
| 🔎 | lod3_multi_curve | geometry |
| 🔎 | lod4_multi_curve | geometry |
| 🔎 ⬈ | lod1_multi_surface_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod1_solid_id | bigint |
| 🔎 ⬈ | lod2_solid_id | bigint |
| 🔎 ⬈ | lod3_solid_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | tunnel_pk | |
| 🔎 | tunnel_parent_fkx | |
| 🔎 | tunnel_root_fkx | |
| 🔎 | tunnel_lod1msrf_fkx | |
| 🔎 | tunnel_lod2msrf_fkx | |
| 🔎 | tunnel_lod3msrf_fkx | |
| 🔎 | tunnel_lod4msrf_fkx | |
| 🔎 | tunnel_lod1solid_fkx | |
| 🔎 | tunnel_lod2solid_fkx | |
| 🔎 | tunnel_lod3solid_fkx | |
| 🔎 | tunnel_lod4solid_fkx | |
| 🔎 | tunnel_objectclass_fkx | |
| 🔎 | tunnel_lod1terr_spx | |
| 🔎 | tunnel_lod2terr_spx | |
| 🔎 | tunnel_lod3terr_spx | |
| 🔎 | tunnel_lod4terr_spx | |
| 🔎 | tunnel_lod2curve_spx | |
| 🔎 | tunnel_lod3curve_spx | |
| 🔎 | tunnel_lod4curve_spx | |
| Foreign Keys | ||
| tunnel_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod1solid_fk | ( lod1_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod2solid_fk | ( lod2_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod3solid_fk | ( lod3_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) | |
| tunnel_parent_fk | ( tunnel_parent_id ) ref citydb.tunnel (id) | |
| tunnel_root_fk | ( tunnel_root_id ) ref citydb.tunnel (id) |
Table tunnel_furniture
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | tunnel_hollow_space_id | bigint |
| 🔎 ⬈ | lod4_brep_id | bigint |
| 🔎 | lod4_other_geom | geometry |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | tunnel_furniture_pk | |
| 🔎 | tunnel_furn_hspace_fkx | |
| 🔎 | tunnel_furn_lod4brep_fkx | |
| 🔎 | tunnel_furn_lod4impl_fkx | |
| 🔎 | tunnel_furn_objclass_fkx | |
| 🔎 | tunnel_furn_lod4xgeom_spx | |
| 🔎 | tunnel_furn_lod4refpt_spx | |
| Foreign Keys | ||
| tunnel_furn_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_furn_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_furn_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_furn_hspace_fk | ( tunnel_hollow_space_id ) ref citydb.tunnel_hollow_space (id) |
Table tunnel_hollow_space
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | tunnel_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_solid_id | bigint |
| Indexes | ||
| 🔑 | tunnel_hollow_space_pk | |
| 🔎 | tun_hspace_tunnel_fkx | |
| 🔎 | tun_hspace_lod4msrf_fkx | |
| 🔎 | tun_hspace_lod4solid_fkx | |
| 🔎 | tun_hspace_objclass_fkx | |
| Foreign Keys | ||
| tun_hspace_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| tun_hspace_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_hspace_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) | |
| tun_hspace_tunnel_fk | ( tunnel_id ) ref citydb.tunnel (id) |
Table tunnel_installation
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| 🔎 ⬈ | tunnel_id | bigint |
| 🔎 ⬈ | tunnel_hollow_space_id | bigint |
| 🔎 ⬈ | lod2_brep_id | bigint |
| 🔎 ⬈ | lod3_brep_id | bigint |
| 🔎 ⬈ | lod4_brep_id | bigint |
| 🔎 | lod2_other_geom | geometry |
| 🔎 | lod3_other_geom | geometry |
| 🔎 | lod4_other_geom | geometry |
| 🔎 ⬈ | lod2_implicit_rep_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod2_implicit_ref_point | geometry |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod2_implicit_transformation | varchar(1000) | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | tunnel_installation_pk | |
| 🔎 | tunnel_inst_objclass_fkx | |
| 🔎 | tunnel_inst_tunnel_fkx | |
| 🔎 | tunnel_inst_hspace_fkx | |
| 🔎 | tunnel_inst_lod2brep_fkx | |
| 🔎 | tunnel_inst_lod3brep_fkx | |
| 🔎 | tunnel_inst_lod4brep_fkx | |
| 🔎 | tunnel_inst_lod2impl_fkx | |
| 🔎 | tunnel_inst_lod3impl_fkx | |
| 🔎 | tunnel_inst_lod4impl_fkx | |
| 🔎 | tunnel_inst_lod2xgeom_spx | |
| 🔎 | tunnel_inst_lod3xgeom_spx | |
| 🔎 | tunnel_inst_lod4xgeom_spx | |
| 🔎 | tunnel_inst_lod2refpt_spx | |
| 🔎 | tunnel_inst_lod3refpt_spx | |
| 🔎 | tunnel_inst_lod4refpt_spx | |
| Foreign Keys | ||
| tunnel_inst_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_inst_lod2impl_fk | ( lod2_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_inst_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_inst_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_inst_lod2brep_fk | ( lod2_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_inst_lod3brep_fk | ( lod3_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_inst_lod4brep_fk | ( lod4_brep_id ) ref citydb.surface_geometry (id) | |
| tunnel_inst_tunnel_fk | ( tunnel_id ) ref citydb.tunnel (id) | |
| tunnel_inst_hspace_fk | ( tunnel_hollow_space_id ) ref citydb.tunnel_hollow_space (id) |
Table tunnel_open_to_them_srf
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | tunnel_opening_id | bigint |
| *🔑 ⬈ | tunnel_thematic_surface_id | bigint |
| Indexes | ||
| 🔑 | tunnel_open_to_them_srf_pk | |
| 🔎 | tun_open_to_them_srf_fkx | |
| 🔎 | tun_open_to_them_srf_fkx1 | |
| Foreign Keys | ||
| tun_open_to_them_srf_fk | ( tunnel_opening_id ) ref citydb.tunnel_opening (id) | |
| tun_open_to_them_srf_fk1 | ( tunnel_thematic_surface_id ) ref citydb.tunnel_thematic_surface (id) |
Table tunnel_opening
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_implicit_rep_id | bigint |
| 🔎 ⬈ | lod4_implicit_rep_id | bigint |
| 🔎 | lod3_implicit_ref_point | geometry |
| 🔎 | lod4_implicit_ref_point | geometry |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| 🔑 | tunnel_opening_pk | |
| 🔎 | tunnel_open_objclass_fkx | |
| 🔎 | tunnel_open_lod3msrf_fkx | |
| 🔎 | tunnel_open_lod4msrf_fkx | |
| 🔎 | tunnel_open_lod3impl_fkx | |
| 🔎 | tunnel_open_lod4impl_fkx | |
| 🔎 | tunnel_open_lod3refpt_spx | |
| 🔎 | tunnel_open_lod4refpt_spx | |
| Foreign Keys | ||
| tunnel_open_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| tunnel_open_lod3impl_fk | ( lod3_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_open_lod4impl_fk | ( lod4_implicit_rep_id ) ref citydb.implicit_geometry (id) | |
| tunnel_open_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tunnel_open_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) |
Table tunnel_thematic_surface
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | id | bigint |
| *🔎 | objectclass_id | integer |
| 🔎 ⬈ | tunnel_id | bigint |
| 🔎 ⬈ | tunnel_hollow_space_id | bigint |
| 🔎 ⬈ | tunnel_installation_id | bigint |
| 🔎 ⬈ | lod2_multi_surface_id | bigint |
| 🔎 ⬈ | lod3_multi_surface_id | bigint |
| 🔎 ⬈ | lod4_multi_surface_id | bigint |
| Indexes | ||
| 🔑 | tunnel_thematic_surface_pk | |
| 🔎 | tun_them_srf_objclass_fkx | |
| 🔎 | tun_them_srf_tunnel_fkx | |
| 🔎 | tun_them_srf_hspace_fkx | |
| 🔎 | tun_them_srf_tun_inst_fkx | |
| 🔎 | tun_them_srf_lod2msrf_fkx | |
| 🔎 | tun_them_srf_lod3msrf_fkx | |
| 🔎 | tun_them_srf_lod4msrf_fkx | |
| Foreign Keys | ||
| tun_them_srf_cityobj_fk | ( id ) ref citydb.cityobject (id) | |
| tun_them_srf_lod2msrf_fk | ( lod2_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_them_srf_lod3msrf_fk | ( lod3_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_them_srf_lod4msrf_fk | ( lod4_multi_surface_id ) ref citydb.surface_geometry (id) | |
| tun_them_srf_tunnel_fk | ( tunnel_id ) ref citydb.tunnel (id) | |
| tun_them_srf_hspace_fk | ( tunnel_hollow_space_id ) ref citydb.tunnel_hollow_space (id) | |
| tun_them_srf_tun_inst_fk | ( tunnel_installation_id ) ref citydb.tunnel_installation (id) |
Table waterbod_to_waterbnd_srf
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | waterboundary_surface_id | bigint |
| *🔑 ⬈ | waterbody_id | bigint |
| Indexes | ||
| 🔑 | waterbod_to_waterbnd_pk | |
| 🔎 | waterbod_to_waterbnd_fkx | |
| 🔎 | waterbod_to_waterbnd_fkx1 | |
| Foreign Keys | ||
| waterbod_to_waterbnd_fk1 | ( waterbody_id ) ref citydb.waterbody (id) | |
| waterbod_to_waterbnd_fk | ( waterboundary_surface_id ) ref citydb.waterboundary_surface (id) |
Table waterbody
| 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 | |
| 🔎 | waterbody_lod0msrf_fkx | |
| 🔎 | waterbody_lod1msrf_fkx | |
| 🔎 | waterbody_lod1solid_fkx | |
| 🔎 | waterbody_lod2solid_fkx | |
| 🔎 | waterbody_lod3solid_fkx | |
| 🔎 | waterbody_lod4solid_fkx | |
| 🔎 | waterbody_objclass_fkx | |
| 🔎 | waterbody_lod0curve_spx | |
| 🔎 | waterbody_lod1curve_spx | |
| Foreign Keys | ||
| waterbody_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| waterbody_lod0msrf_fk | ( lod0_multi_surface_id ) ref citydb.surface_geometry (id) | |
| waterbody_lod1msrf_fk | ( lod1_multi_surface_id ) ref citydb.surface_geometry (id) | |
| waterbody_lod1solid_fk | ( lod1_solid_id ) ref citydb.surface_geometry (id) | |
| waterbody_lod2solid_fk | ( lod2_solid_id ) ref citydb.surface_geometry (id) | |
| waterbody_lod3solid_fk | ( lod3_solid_id ) ref citydb.surface_geometry (id) | |
| waterbody_lod4solid_fk | ( lod4_solid_id ) ref citydb.surface_geometry (id) |
Table waterboundary_surface
| 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 | |
| 🔎 | waterbnd_srf_objclass_fkx | |
| 🔎 | waterbnd_srf_lod2srf_fkx | |
| 🔎 | waterbnd_srf_lod3srf_fkx | |
| 🔎 | waterbnd_srf_lod4srf_fkx | |
| Foreign Keys | ||
| waterbnd_srf_cityobject_fk | ( id ) ref citydb.cityobject (id) | |
| waterbnd_srf_lod2srf_fk | ( lod2_surface_id ) ref citydb.surface_geometry (id) | |
| waterbnd_srf_lod3srf_fk | ( lod3_surface_id ) ref citydb.surface_geometry (id) | |
| waterbnd_srf_lod4srf_fk | ( lod4_surface_id ) ref citydb.surface_geometry (id) |