Feature Class Relations

Trace how geometry, annotations
and derived attributes connect.

Interactive relationship map assembled from the current QGIS and GeoPackage audit files in Drive.

8feature classes

3verified relations

1association to review

SEARCH LAYERS OR KEYS

Swipe horizontally to inspect the full relation map

RELATION MAP

PKPrimary RKReference FKForeign NNNot null CHKCheck Verified Review

⋮

SELECTED FEATURE CLASS

parent

Library folderbuildingAudit sourceLibrary audit · 23 Jul 2026Relation keybuildingid

DATA SCHEMA36 fields

PRIMARY KEYfid

GEOMETRYPOLYGON

FILTER FIELDS

DRAG A HEADER EDGE TO RESIZE EACH COLUMN

#	Field name	Data type	Key / rules	Editable	Domain	Default value
0	`fid`	INTEGER	PKNN	No	—	—
1	`geom`	POLYGON	Nullable	Yes	—	—
2	`objectid`	INTEGER	Nullable	No	—	—
3	`creationdate`	DATETIME	Nullable	No	—	—
4	`lastamendmentdate`	DATETIME	Nullable	No	—	—
5	`datadisseminationlevel`	MEDIUMINT	Nullable	Yes	—	—
6	`buffer`	MEDIUMINT	Nullable	No	—	—
7	`buildingid`	INTEGER	RK	No	—	—
8	`usagetype`	TEXT(3)	Nullable	Yes		—
9	`category`	MEDIUMINT	Nullable	Yes		—
10	`typeofbuildingblock`	TEXT(5)	Nullable	Yes		—
11	`baselevel`	REAL	Nullable	Yes	—	—
12	`rooflevel`	REAL	Nullable	Yes	—	—
13	`baseleveldatasource`	MEDIUMINT	Nullable	Yes		—
14	`roofleveldatasource`	MEDIUMINT	Nullable	Yes		—
15	`buildingstatus`	TEXT(1)	Nullable	Yes		—
16	`certainty`	MEDIUMINT	Nullable	Yes		—
17	`georefno`	TEXT(10)	Nullable	No	—
18	`repairorder`	DATETIME	Nullable	Yes	—	—
19	`numberofunits`	MEDIUMINT	Nullable	Yes	—	—
20	`floorflag`	TEXT(3)	Nullable	Yes	—	—
21	`datasource`	MEDIUMINT	Nullable	Yes		—
22	`chinesedisplayname`	TEXT(255)	Nullable	Yes	—	—
23	`englishdisplayname`	TEXT(255)	Nullable	Yes	—	—
24	`model3dlevel1`	TEXT(50)	Nullable	Yes	—	—
25	`model3dlevel2`	TEXT(50)	Nullable	Yes	—	—
26	`model3dlevel3`	TEXT(50)	Nullable	Yes	—	—
27	`siteid`	INTEGER	Nullable	Yes	—	—
28	`floorid`	INTEGER	Nullable	Yes	—	—
29	`buildingcsuid`	TEXT(19)	Nullable	No	—
30	`dso`	TEXT(5)	Nullable	No
31	`symbol`	TEXT(50)	Nullable	No	—	—
32	`globalid`	TEXT(38)	Nullable	No	—	`uuid()`
33	`oldbuffer`	MEDIUMINT	Nullable	No	—	—
34	`modifiedby`	TEXT(51)	Nullable	No	—	`@user_account_name`
35	`gdb_geomattr_data`	BLOB	Nullable	Yes	—	—

Parent polygon. Triggers propagate ID, DSO and name changes to buildinganno; deletion clears the child link.

DATABASE AUTOMATION8 triggers

Click a trigger to inspect its function

GeoPackage indexes 0

No indexes were listed in this feature-class audit.

AUTHORITATIVE REVIEW FLAGS

Loading Review Flags from the generated Drive snapshot…

REMARKS

Loading remarks…

SOURCEREMARKS

Last updated unavailable
Last synchronized unavailable