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