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