-
Notifications
You must be signed in to change notification settings - Fork 4
/
schema.yml
266 lines (252 loc) · 12.5 KB
/
schema.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
models:
- name: location.access
description: '{{ doc("table_access") }}'
- name: location.census
description: '{{ doc("table_census") }}'
- name: location.census_2010
description: '{{ doc("table_census_2010") }}'
- name: location.census_acs5
description: '{{ doc("table_census_acs5") }}'
- name: location.chicago
description: '{{ doc("table_chicago") }}'
- name: location.crosswalk_year_fill
description: '{{ doc("table_crosswalk_year_fill") }}'
- name: location.economy
description: '{{ doc("table_economy") }}'
- name: location.environment
description: '{{ doc("table_environment") }}'
- name: location.other
description: '{{ doc("table_other") }}'
- name: location.political
description: '{{ doc("table_political") }}'
- name: location.school
description: '{{ doc("table_school") }}'
- name: location.tax
description: '{{ doc("table_tax") }}'
- name: location.vw_pin10_location
description: '{{ doc("view_vw_pin10_location") }}'
columns: &vw_location_columns
- name: access_cmap_walk_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: access_cmap_walk_id
description: '{{ doc("column_access_cmap_walk_id") }}'
- name: access_cmap_walk_nta_score
description: '{{ doc("column_access_cmap_walk_nta_score") }}'
- name: access_cmap_walk_total_score
description: '{{ doc("column_access_cmap_walk_total_score") }}'
- name: census_acs5_congressional_district_geoid
description: '{{ doc("column_census_congressional_district_geoid") }}'
- name: census_acs5_county_subdivision_geoid
description: '{{ doc("column_census_county_subdivision_geoid") }}'
- name: census_acs5_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: census_acs5_place_geoid
description: '{{ doc("column_census_place_geoid") }}'
- name: census_acs5_puma_geoid
description: '{{ doc("column_census_puma_geoid") }}'
- name: census_acs5_school_district_elementary_geoid
description: '{{ doc("column_census_school_district_elementary_geoid") }}'
- name: census_acs5_school_district_secondary_geoid
description: '{{ doc("column_census_school_district_secondary_geoid") }}'
- name: census_acs5_school_district_unified_geoid
description: '{{ doc("column_census_school_district_unified_geoid") }}'
- name: census_acs5_state_representative_geoid
description: '{{ doc("column_census_state_representative_geoid") }}'
- name: census_acs5_state_senate_geoid
description: '{{ doc("column_census_state_senate_geoid") }}'
- name: census_acs5_tract_geoid
description: '{{ doc("column_census_tract_geoid") }}'
- name: census_block_geoid
description: '{{ doc("column_census_block_geoid") }}'
- name: census_block_group_geoid
description: '{{ doc("column_census_block_group_geoid") }}'
- name: census_congressional_district_geoid
description: '{{ doc("column_census_congressional_district_geoid") }}'
- name: census_county_subdivision_geoid
description: '{{ doc("column_census_county_subdivision_geoid") }}'
- name: census_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: census_place_geoid
description: '{{ doc("column_census_place_geoid") }}'
- name: census_puma_geoid
description: '{{ doc("column_census_puma_geoid") }}'
- name: census_school_district_elementary_geoid
description: '{{ doc("column_census_school_district_elementary_geoid") }}'
- name: census_school_district_secondary_geoid
description: '{{ doc("column_census_school_district_secondary_geoid") }}'
- name: census_school_district_unified_geoid
description: '{{ doc("column_census_school_district_unified_geoid") }}'
- name: census_state_representative_geoid
description: '{{ doc("column_census_state_representative_geoid") }}'
- name: census_state_senate_geoid
description: '{{ doc("column_census_state_senate_geoid") }}'
- name: census_tract_geoid
description: '{{ doc("column_census_tract_geoid") }}'
- name: census_zcta_geoid
description: '{{ doc("column_census_zcta_geoid") }}'
- name: chicago_community_area_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: chicago_community_area_name
description: '{{ doc("column_chicago_community_area_name") }}'
- name: chicago_community_area_num
description: '{{ doc("column_chicago_community_area_num") }}'
- name: chicago_industrial_corridor_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: chicago_industrial_corridor_name
description: '{{ doc("column_chicago_industrial_corridor_name") }}'
- name: chicago_industrial_corridor_num
description: '{{ doc("column_chicago_industrial_corridor_num") }}'
- name: chicago_police_district_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: chicago_police_district_num
description: '{{ doc("column_chicago_police_district_num") }}'
- name: cook_board_of_review_district_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: cook_board_of_review_district_num
description: '{{ doc("column_cook_board_of_review_district_num") }}'
- name: cook_commissioner_district_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: cook_commissioner_district_num
description: '{{ doc("column_cook_commissioner_district_num") }}'
- name: cook_judicial_district_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: cook_judicial_district_num
description: '{{ doc("column_cook_judicial_district_num") }}'
- name: econ_coordinated_care_area_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: econ_coordinated_care_area_num
description: '{{ doc("column_econ_coordinated_care_area_num") }}'
- name: econ_enterprise_zone_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: econ_enterprise_zone_num
description: '{{ doc("column_econ_enterprise_zone_num") }}'
- name: econ_industrial_growth_zone_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: econ_industrial_growth_zone_num
description: '{{ doc("column_econ_industrial_growth_zone_num") }}'
- name: econ_qualified_opportunity_zone_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: econ_qualified_opportunity_zone_num
description: '{{ doc("column_econ_qualified_opportunity_zone_num") }}'
- name: env_airport_noise_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: env_airport_noise_dnl
description: '{{ doc("column_env_airport_noise_dnl") }}'
- name: env_flood_fema_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: env_flood_fema_sfha
description: '{{ doc("column_env_flood_fema_sfha") }}'
- name: env_flood_fs_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: env_flood_fs_factor
description: '{{ doc("column_env_flood_fs_factor") }}'
- name: env_flood_fs_risk_direction
description: '{{ doc("column_env_flood_fs_risk_direction") }}'
- name: env_ohare_noise_contour_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: env_ohare_noise_contour_half_mile_buffer_bool
description: '{{ doc("column_env_ohare_noise_contour_half_mile_buffer_bool") }}'
- name: env_ohare_noise_contour_no_buffer_bool
description: '{{ doc("column_env_ohare_noise_contour_no_buffer_bool") }}'
- name: misc_subdivision_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: misc_subdivision_id
description: '{{ doc("column_misc_subdivision_id") }}'
- name: pin10
description: '{{ doc("shared_column_pin10") }}'
- name: school_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: school_elementary_district_geoid
description: '{{ doc("column_school_elementary_district_geoid") }}'
- name: school_elementary_district_name
description: '{{ doc("column_school_elementary_district_name") }}'
- name: school_school_year
description: '{{ doc("column_school_year") }}'
- name: school_secondary_district_geoid
description: '{{ doc("column_school_secondary_district_geoid") }}'
- name: school_secondary_district_name
description: '{{ doc("column_school_secondary_district_name") }}'
- name: school_unified_district_geoid
description: '{{ doc("column_school_unified_district_geoid") }}'
- name: school_unified_district_name
description: '{{ doc("column_school_unified_district_name") }}'
- name: tax_community_college_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_community_college_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: tax_fire_protection_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_fire_protection_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_library_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_library_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_municipality_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_municipality_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_park_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_park_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_sanitation_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_sanitation_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_school_elementary_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_school_elementary_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_school_secondary_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_school_secondary_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_school_unified_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_school_unified_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_special_service_area_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_special_service_area_num
description: '{{ doc("column_tax_district_num") }}'
- name: tax_tif_district_name
description: '{{ doc("column_tax_district_name") }}'
- name: tax_tif_district_num
description: '{{ doc("column_tax_district_num") }}'
- name: ward_chicago_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: ward_evanston_data_year
description: '{{ doc("shared_column_data_year") }}'
- name: ward_name
description: '{{ doc("column_ward_name") }}'
- name: ward_num
description: '{{ doc("column_ward_num") }}'
- name: year
description: '{{ doc("shared_column_year") }}'
data_tests:
- column_length:
name: location_vw_pin10_location_7_digit_ids_are_correct_length
length: 7
column_names:
- census_place_geoid
- census_puma_geoid
- census_school_district_elementary_geoid
- census_school_district_secondary_geoid
- census_acs5_place_geoid
- census_acs5_puma_geoid
- census_acs5_school_district_elementary_geoid
- census_acs5_school_district_secondary_geoid
additional_select_columns:
- pin10
- year
- unique_combination_of_columns:
name: location_vw_pin10_location_unique_by_keys
combination_of_columns:
- pin10
- year
- name: location.vw_pin10_location_fill
description: '{{ doc("view_vw_pin10_location_fill") }}'
columns: *vw_location_columns