Boundaries Data Dictionary Q1 2018
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
COLUMN_IDCOLUMN_NAMEDATA_TYPEEXAMPLEDESCRIPTION
2
1CHANGE_FLAGVARCHAR2(1)II(nsert), A(ttribute change), B(oth attribute + geometry change), C(hange - uncategorized), G(eometry change), D(elete), N(o change)
3
2RECORD_IDNUMBER(15)10819539Unique record ID, used for purposes of support. This ID should not be used for linking data.
4
GEO_CODEVARCHAR2(16)2517Numerical portion of the GEO_ID
5
3GEO_IDVARCHAR2(18)ND0000002517Linking key to other Onboard geographic content using the fully formatted GEO_ID
6
4GEO_NAMEVARCHAR2(100)HilltopArea Name
7
5NAMETYPENUMBER(2)1Type of geo name (see Name Type Lookup)
8
6REFERENCE1VARCHAR2(200)MT30004130Additional ID's to relate to other sources and content (see Reference Lookup)
9
7REFERENCE2VARCHAR2(200)Wilmington, DEAdditional ID's to relate to other sources and content (see Reference Lookup)
10
8REFERENCE3VARCHAR2(200)3204Additional ID's to relate to other sources and content (see Reference Lookup)
11
9REFERENCE4VARCHAR2(200)30913600Additional ID's to relate to other sources and content (see Reference Lookup)
12
10REFERENCE5VARCHAR2(200)Reserved for future use
13
11TYPE1NUMBER(5)10300Additional Type to define and segment the areas (see Type Lookup)
14
12TYPE2NUMBER(5)20910Additional Type to define and segment the areas (see Type Lookup)
15
13TYPE3NUMBER(5)30360Additional Type to define and segment the areas (see Type Lookup)
16
14TYPE4NUMBER(5)Additional Type to define and segment the areas (see Type Lookup)
17
15TYPE5NUMBER(5)Reserved for future use
18
16CENTERVARCHAR2(64)POINT(-75.566583,39.745856)Area geographic centroid
19
17CENTER_LATNUMBER(17,6)39.745856Latitude component of centroid
20
18CENTER_LONNUMBER(17,6)-75.566583Longitude component of centroid
21
19AREABINARY_DOUBLE()0.208558646Area measurement
22
20AREA_UNITVARCHAR2(13)SQ MIUnits for area measurement
23
21DATE_ADDEDDATE21-Sep-15Date area definition first added to Onboard systems
24
22DATE_MODIFIEDDATE24-Sep-15Date of last modification
25
23VINTAGEDATE201509Data vintage in YYYY-MM format
26
24BNDY_IDNUMBER(20)114040000003204Unique boundary ID
27
25BOUNDARYSDO_GEOMETRY()[MDSYS.SDO_GEOMETRY]Area geometry
28
26STATE2VARCHAR2(2)10County FIPS code
29
27COUNTY5VARCHAR2(5)10003State FIPS code
30
28COUNTRY2CHAR(2)USCountry Code – ISO-3166 alpha 2
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu