-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathwisc_crosswalk.sql
More file actions
434 lines (434 loc) · 37.5 KB
/
wisc_crosswalk.sql
File metadata and controls
434 lines (434 loc) · 37.5 KB
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
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
CREATE TABLE IF NOT EXISTS wisc_crosswalk (
`lea_name` VARCHAR(46),
`lea_id` INT,
`fed_id` INT,
`street1` VARCHAR(30),
`street2` VARCHAR(27),
`city` VARCHAR(17),
`state` VARCHAR(2)
);
INSERT INTO wisc_crosswalk VALUES
('Abbotsford School District',0007,5500030,'510 W Hemlock St',NULL,'Abbotsford','WI'),
('Adams-Friendship Area School District',0014,5500060,'201 W 6th St',NULL,'Friendship','WI'),
('Albany School District',0063,5500120,'PO Box 349',NULL,'Albany','WI'),
('Algoma School District',0070,5500150,'1715 Division St',NULL,'Algoma','WI'),
('Alma Center School District',0091,5500210,'PO Box 308',NULL,'Alma Center','WI'),
('Alma School District',0084,5500180,'S1618 State Road 35',NULL,'Alma','WI'),
('Almond-Bancroft School District',0105,5500240,'1336 Elm St',NULL,'Almond','WI'),
('Altoona School District',0112,5500270,'District Office','1903 Bartlett Ave','Altoona','WI'),
('Amery School District',0119,5500300,'543 Minneapolis Ave S',NULL,'Amery','WI'),
('Antigo Unified School District',0140,5500360,'120 S Dorr St',NULL,'Antigo','WI'),
('Appleton Area School District',0147,5500390,'PO Box 2019',NULL,'Appleton','WI'),
('Arcadia School District',0154,5500420,'756 Raider Dr',NULL,'Arcadia','WI'),
('Argyle School District',0161,5500450,'PO Box 256',NULL,'Argyle','WI'),
('Arrowhead UHS School District',2450,5506180,'700 North Ave',NULL,'Hartland','WI'),
('Ashland School District',0170,5500510,'2000 Beaser Ave',NULL,'Ashland','WI'),
('Ashwaubenon School District',0182,5500540,'1055 Griffiths Ln',NULL,'Green Bay','WI'),
('Athens School District',0196,5500570,'601 W Village Limits Rd',NULL,'Athens','WI'),
('Auburndale School District',0203,5500600,'PO Box 139',NULL,'Auburndale','WI'),
('Augusta School District',0217,5500630,'E19320 Bartig Rd',NULL,'Augusta','WI'),
('Baldwin-Woodville Area School District',0231,5500720,'550 US Highway 12',NULL,'Baldwin','WI'),
('Bangor School District',0245,5500780,'PO Box 99',NULL,'Bangor','WI'),
('Baraboo School District',0280,5500810,'423 Linn St',NULL,'Baraboo','WI'),
('Barneveld School District',0287,5500840,'304 S Jones St',NULL,'Barneveld','WI'),
('Barron Area School District',0308,5500870,'100 W River Ave',NULL,'Barron','WI'),
('Bayfield School District',0315,5500900,'300 N 4th St',NULL,'Bayfield','WI'),
('Beaver Dam Unified School District',0336,5500960,'705 McKinley St',NULL,'Beaver Dam','WI'),
('Beecher-Dunbar-Pembine School District',4263,5511550,'PO Box 247',NULL,'Pembine','WI'),
('Belleville School District',0350,5500990,'625 W Church St',NULL,'Belleville','WI'),
('Belmont Community School District',0364,5501020,'PO Box 348',NULL,'Belmont','WI'),
('Beloit School District',0413,5501050,'Kolak Education Center','1633 Keeler Ave','Beloit','WI'),
('Beloit Turner School District',0422,5501080,'1237 Inman Pkwy',NULL,'Beloit','WI'),
('Benton School District',0427,5501110,'PO Box 7',NULL,'Benton','WI'),
('Berlin Area School District',0434,5501140,'295 E Marquette St',NULL,'Berlin','WI'),
('Big Foot UHS School District',6013,5515480,'PO Box 99',NULL,'Walworth','WI'),
('Birchwood School District',0441,5501170,'300 S Wilson St',NULL,'Birchwood','WI'),
('Black Hawk School District',2240,5505730,'PO Box 303',NULL,'South Wayne','WI'),
('Black River Falls School District',0476,5501260,'301 N 4th St',NULL,'Black River Falls','WI'),
('Blair-Taylor School District',0485,5500016,'N31024 Elland Rd',NULL,'Blair','WI'),
('Bloomer School District',0497,5501350,'1310 17th Ave',NULL,'Bloomer','WI'),
('Bonduel School District',0602,5501470,'PO Box 310',NULL,'Bonduel','WI'),
('Boscobel Area School District',0609,5501500,'1110 Park St',NULL,'Boscobel','WI'),
('Bowler School District',0623,5501560,'500 S Almon St',NULL,'Bowler','WI'),
('Boyceville Community School District',0637,5501590,'1003 Tiffany St',NULL,'Boyceville','WI'),
('Brighton #1 School District',0657,5501650,'1200 248th Ave',NULL,'Kansasville','WI'),
('Brillion School District',0658,5501680,'315 S Main St',NULL,'Brillion','WI'),
('Bristol #1 School District',0665,5501710,'20121 83rd St',NULL,'Bristol','WI'),
('Brodhead School District',0700,5501740,'2501 W 5th Ave',NULL,'Brodhead','WI'),
('Brown Deer School District',0721,5501800,'8200 N 60th St',NULL,'Brown Deer','WI'),
('Bruce School District',0735,5501830,'104 W Washington Ave',NULL,'Bruce','WI'),
('Burlington Area School District',0777,5501890,'100 N Kane St',NULL,'Burlington','WI'),
('Butternut School District',0840,5501920,'PO Box 247',NULL,'Butternut','WI'),
('Cadott Community School District',0870,5502040,'426 Myrtle St',NULL,'Cadott','WI'),
('Cambria-Friesland School District',0882,5502070,'410 E Edgewater St',NULL,'Cambria','WI'),
('Cambridge School District',0896,5502100,'403 Blue Jay Way',NULL,'Cambridge','WI'),
('Cameron School District',0903,5502130,'PO Box 378',NULL,'Cameron','WI'),
('Campbellsport School District',0910,5502160,'114 W Sheboygan St',NULL,'Campbellsport','WI'),
('Cashton School District',0980,5502340,'PO Box 129',NULL,'Cashton','WI'),
('Cassville School District',0994,5502400,'715 E Amelia St',NULL,'Cassville','WI'),
('Cedar Grove-Belgium Area School District',1029,5502430,'321 N 2nd St',NULL,'Cedar Grove','WI'),
('Cedarburg School District',1015,5502460,'W68N611 Evergreen Blvd',NULL,'Cedarburg','WI'),
('Central/Westosha UHS School District',5054,5513290,'PO Box 38',NULL,'Salem','WI'),
('Chequamegon School District',1071,5500058,'420 9th St N',NULL,'Park Falls','WI'),
('Chetek-Weyerhaeuser Area School District',1080,5500061,'PO Box 6',NULL,'Chetek','WI'),
('Chilton School District',1085,5502520,'530 W Main St',NULL,'Chilton','WI'),
('Chippewa Falls Area Unified School District',1092,5502550,'1130 Miles St',NULL,'Chippewa Falls','WI'),
('Clayton School District',1120,5502580,'236 Polk Ave W',NULL,'Clayton','WI'),
('Clear Lake School District',1127,5502610,'1101 3rd St SW',NULL,'Clear Lake','WI'),
('Clinton Community School District',1134,5502640,'PO Box 566',NULL,'Clinton','WI'),
('Clintonville School District',1141,5502670,'45 W Green Tree Rd',NULL,'Clintonville','WI'),
('Cochrane-Fountain City School District',1155,5502700,'S2770 State Hwy 35',NULL,'Fountain City','WI'),
('Colby School District',1162,5502730,'PO Box 110',NULL,'Colby','WI'),
('Coleman School District',1169,5502760,'District Office','347 Business 141 N','Coleman','WI'),
('Colfax School District',1176,5502790,'601 University Ave',NULL,'Colfax','WI'),
('Columbus School District',1183,5502820,'200 W School St',NULL,'Columbus','WI'),
('Cornell School District',1204,5502880,'PO Box 517',NULL,'Cornell','WI'),
('Crandon School District',1218,5502910,'9750 US Highway 8 W',NULL,'Crandon','WI'),
('Crivitz School District',1232,5502970,'400 South Ave',NULL,'Crivitz','WI'),
('Cuba City School District',1246,5503030,'101 N School St',NULL,'Cuba City','WI'),
('Cudahy School District',1253,5503060,'2915 E Ramsey Ave',NULL,'Cudahy','WI'),
('Cumberland School District',1260,5503090,'1010 8th Ave',NULL,'Cumberland','WI'),
('D C Everest Area School District',4970,5513170,'6300 Alderson St',NULL,'Weston','WI'),
('Darlington Community School District',1295,5503150,'11630 Center Hill Rd',NULL,'Darlington','WI'),
('De Forest Area School District',1316,5503180,'520 E Holum St',NULL,'De Forest','WI'),
('De Pere School District',1414,5503210,'1700 Chicago St',NULL,'De Pere','WI'),
('De Soto Area School District',1421,5503240,'615 Main St',NULL,'De Soto','WI'),
('Deerfield Community School District',1309,5503270,'300 Simonson Blvd',NULL,'Deerfield','WI'),
('Delavan-Darien School District',1380,5503640,'324 Beloit St',NULL,'Delavan','WI'),
('Denmark School District',1407,5503660,'450 N Wall St',NULL,'Denmark','WI'),
('Dodgeland School District',2744,5507260,'401 S Western Ave',NULL,'Juneau','WI'),
('Dodgeville School District',1428,5503690,'916 W Chapel St',NULL,'Dodgeville','WI'),
('Dover #1 School District',1449,5503750,'4101 S Beaumont Ave',NULL,'Kansasville','WI'),
('Drummond Area School District',1491,5503810,'52440 Eastern Ave',NULL,'Drummond','WI'),
('Durand-Arkansaw School District',1499,5503840,'PO Box 190',NULL,'Durand','WI'),
('East Troy Community School District',1540,5504020,'2040 Beulah Ave',NULL,'East Troy','WI'),
('Eau Claire Area School District',1554,5504050,'500 Main St',NULL,'Eau Claire','WI'),
('Edgar School District',1561,5504080,'PO Box 196',NULL,'Edgar','WI'),
('Edgerton School District',1568,5504110,'200 Elm High Dr',NULL,'Edgerton','WI'),
('Elcho School District',1582,5504170,'PO Box 800',NULL,'Elcho','WI'),
('Eleva-Strum School District',1600,5504200,'W23597 US Highway 10',NULL,'Strum','WI'),
('Elk Mound Area School District',1645,5504230,'405 University St',NULL,'Elk Mound','WI'),
('Elkhart Lake-Glenbeulah School District',1631,5504260,'PO Box 326',NULL,'Elkhart Lake','WI'),
('Elkhorn Area School District',1638,5504290,'3 N Jackson St',NULL,'Elkhorn','WI'),
('Ellsworth Community School District',1659,5504320,'PO Box 1500',NULL,'Ellsworth','WI'),
('Elmbrook School District',0714,5501770,'PO Box 1830',NULL,'Brookfield','WI'),
('Elmwood School District',1666,5504350,'213 S Scott St',NULL,'Elmwood','WI'),
('Erin School District',1687,5504410,'6901 County Highway O',NULL,'Hartford','WI'),
('Evansville Community School District',1694,5504440,'340 Fair St',NULL,'Evansville','WI'),
('Fall Creek School District',1729,5504500,'336 E Hoover Ave',NULL,'Fall Creek','WI'),
('Fall River School District',1736,5504530,'PO Box 116',NULL,'Fall River','WI'),
('Fennimore Community School District',1813,5504590,'1397 9th St',NULL,'Fennimore','WI'),
('Flambeau School District',5757,5514970,'PO Box 86',NULL,'Tony','WI'),
('Florence County School District',1855,5504650,'PO Box 440',NULL,'Florence','WI'),
('Fond du Lac School District',1862,5504680,'72 W 9th St',NULL,'Fond du Lac','WI'),
('Fontana J8 School District',1870,5504720,'450 S Main St',NULL,'Fontana','WI'),
('Fort Atkinson School District',1883,5504740,'201 Park St',NULL,'Fort Atkinson','WI'),
('Fox Point J2 School District',1890,5504800,'7300 N Lombardy Rd',NULL,'Milwaukee','WI'),
('Franklin Public School District',1900,5504830,'8255 W Forest Hill Ave',NULL,'Franklin','WI'),
('Frederic School District',1939,5504860,'1437 Clam Falls Dr',NULL,'Frederic','WI'),
('Freedom Area School District',1953,5504920,'N4021 County Road E',NULL,'Freedom','WI'),
('Friess Lake School District',4843,5512880,'1750 Highway 164',NULL,'Hubertus','WI'),
('Galesville-Ettrick-Trempealeau School District',2009,5504960,'PO Box 4000',NULL,'Galesville','WI'),
('Geneva J4 School District',2044,5505100,'N2575 Snake Rd',NULL,'Lake Geneva','WI'),
('Genoa City J2 School District',2051,5505130,'PO Box 250',NULL,'Genoa City','WI'),
('Germantown School District',2058,5505160,'N104W13840 Donges Bay Rd',NULL,'Germantown','WI'),
('Gibraltar Area School District',2114,5505220,'3924 State Highway 42',NULL,'Fish Creek','WI'),
('Gillett School District',2128,5505250,'PO Box 227',NULL,'Gillett','WI'),
('Gilman School District',2135,5505280,'325 N Fifth Ave',NULL,'Gilman','WI'),
('Gilmanton School District',2142,5505370,'PO Box 28',NULL,'Gilmanton','WI'),
('Glendale-River Hills School District',2184,5505460,'2600 W Mill Rd',NULL,'Glendale','WI'),
('Glenwood City School District',2198,5505520,'850 Maple St',NULL,'Glenwood City','WI'),
('Goodman-Armstrong Creek School District',2212,5505580,'PO Box 160',NULL,'Goodman','WI'),
('Grafton School District',2217,5505610,'1900 Washington St',NULL,'Grafton','WI'),
('Granton Area School District',2226,5505640,'217 N Main St',NULL,'Granton','WI'),
('Grantsburg School District',2233,5505670,'480 E James Ave',NULL,'Grantsburg','WI'),
('Green Bay Area Public School District',2289,5505820,'PO Box 23387',NULL,'Green Bay','WI'),
('Green Lake School District',2310,5505880,'PO Box 369',NULL,'Green Lake','WI'),
('Greendale School District',2296,5505910,'6815 Southway',NULL,'Greendale','WI'),
('Greenfield School District',2303,5505940,'4850 S 60th St',NULL,'Greenfield','WI'),
('Greenwood School District',2394,5505970,'PO Box 310',NULL,'Greenwood','WI'),
('Gresham School District',2415,5500056,'501 Schabow St',NULL,'Gresham','WI'),
('Hamilton School District',2420,5506030,'W220N6151 Town Line Rd',NULL,'Sussex','WI'),
('Hartford J1 School District',2443,5506090,'402 W Sumner St',NULL,'Hartford','WI'),
('Hartford UHS School District',2436,5506120,'805 Cedar St',NULL,'Hartford','WI'),
('Hartland-Lakeside J3 School District',2460,5506140,'800 E North Shore Dr',NULL,'Hartland','WI'),
('Hayward Community School District',2478,5506270,'15930 W 5th St',NULL,'Hayward','WI'),
('Herman-Neosho-Rubicon School District',2525,5500075,'201 Center Street',NULL,'Neosho','WI'),
('Highland School District',2527,5506420,'1030 Cardinal Dr',NULL,'Highland','WI'),
('Hilbert School District',2534,5506450,'PO Box 390',NULL,'Hilbert','WI'),
('Hillsboro School District',2541,5506480,'PO Box 526',NULL,'Hillsboro','WI'),
('Holmen School District',2562,5506540,'1019 McHugh Rd',NULL,'Holmen','WI'),
('Holy Hill Area School District',2570,5500080,'1750 Highway 164',NULL,'Hubertus','WI'),
('Horicon School District',2576,5506570,'611 Mill St',NULL,'Horicon','WI'),
('Hortonville Area School District',2583,5506600,'PO Box 70',NULL,'Hortonville','WI'),
('Howard-Suamico School District',2604,5506630,'2706 Lineville Rd',NULL,'Green Bay','WI'),
('Howards Grove School District',2605,5506660,'403 Audubon Rd',NULL,'Howards Grove','WI'),
('Hudson School District',2611,5506690,'644 Brakke Dr',NULL,'Hudson','WI'),
('Hurley School District',2618,5506750,'5503 W Range View Dr',NULL,'Hurley','WI'),
('Hustisford School District',2625,5506780,'PO Box 326',NULL,'Hustisford','WI'),
('Independence School District',2632,5506810,'23786 Indee Blvd',NULL,'Independence','WI'),
('Iola-Scandinavia School District',2639,5506840,'450 Division St',NULL,'Iola','WI'),
('Iowa-Grant School District',2646,5506870,'498 County Road IG',NULL,'Livingston','WI'),
('Ithaca School District',2660,5506960,'24615 State Hwy 58',NULL,'Richland Center','WI'),
('Janesville School District',2695,5507020,'527 S Franklin St',NULL,'Janesville','WI'),
('Jefferson School District',2702,5507050,'206 S Taft Ave',NULL,'Jefferson','WI'),
('Johnson Creek School District',2730,5507170,'PO Box 39',NULL,'Johnson Creek','WI'),
('Juda School District',2737,5507230,'N2385 Spring St',NULL,'Juda','WI'),
('Kaukauna Area School District',2758,5507290,'1701 County Road CE',NULL,'Kaukauna','WI'),
('Kenosha School District',2793,5507320,'3600 52nd St',NULL,'Kenosha','WI'),
('Kettle Moraine School District',1376,5503510,'563 A J Allen Cir',NULL,'Wales','WI'),
('Kewaskum School District',2800,5507380,'PO Box 37',NULL,'Kewaskum','WI'),
('Kewaunee School District',2814,5507410,'915 3rd St',NULL,'Kewaunee','WI'),
('Kickapoo Area School District',5960,5512540,'S6520 State Highway 131',NULL,'Viola','WI'),
('Kiel Area School District',2828,5507440,'PO Box 201',NULL,'Kiel','WI'),
('Kimberly Area School District',2835,5507470,'PO Box 159',NULL,'Combined Locks','WI'),
('Kohler School District',2842,5507500,'333 Upper Rd',NULL,'Kohler','WI'),
('La Crosse School District',2849,5507530,'Hogan Administrative Center','807 East Ave S','La Crosse','WI'),
('La Farge School District',2863,5507560,'301 W Adams St',NULL,'La Farge','WI'),
('Lac du Flambeau #1 School District',1848,5504620,'2899 State Hwy 47 South',NULL,'Lac du Flambeau','WI'),
('Ladysmith School District',2856,5507590,'1700 Edgewood Ave E',NULL,'Ladysmith','WI'),
('Lake Country School District',3862,5500013,'1800 Vettelson Rd',NULL,'Hartland','WI'),
('Lake Geneva J1 School District',2885,5507620,'208 E South St',NULL,'Lake Geneva','WI'),
('Lake Geneva-Genoa City UHS School District',2884,5507650,'208 E South St',NULL,'Lake Geneva','WI'),
('Lake Holcombe School District',2891,5507680,'27331 262nd Ave',NULL,'Holcombe','WI'),
('Lake Mills Area School District',2898,5507710,'120 E Lake Park Pl',NULL,'Lake Mills','WI'),
('Lakeland UHS School District',3647,5509630,'9573 State Hwy 70',NULL,'Minocqua','WI'),
('Lancaster Community School District',2912,5507770,'925 W Maple St',NULL,'Lancaster','WI'),
('Laona School District',2940,5507830,'5216 Forest Ave Ste A',NULL,'Laona','WI'),
('Lena School District',2961,5507860,'304 E Main St',NULL,'Lena','WI'),
('Linn J4 School District',3087,5508040,'W3490 Linton Rd',NULL,'Lake Geneva','WI'),
('Linn J6 School District',3094,5508070,'W4094 S Lakeshore Dr',NULL,'Lake Geneva','WI'),
('Little Chute Area School District',3129,5508160,'325 Meulemans St Ste A',NULL,'Little Chute','WI'),
('Lodi School District',3150,5508190,'115 School St',NULL,'Lodi','WI'),
('Lomira School District',3171,5508220,'PO Box 919',NULL,'Lomira','WI'),
('Loyal School District',3206,5508250,'PO Box 10',NULL,'Loyal','WI'),
('Luck School District',3213,5508280,'810 S 7th St',NULL,'Luck','WI'),
('Luxemburg-Casco School District',3220,5508340,'PO Box 70',NULL,'Luxemburg','WI'),
('Madison Metropolitan School District',3269,5508520,'545 W Dayton St',NULL,'Madison','WI'),
('Manawa School District',3276,5508550,'800 Beech St',NULL,'Manawa','WI'),
('Manitowoc School District',3290,5508610,'2902 Lindbergh Dr',NULL,'Manitowoc','WI'),
('Maple Dale-Indian Hill School District',1897,5504770,'8377 N Port Washington Rd',NULL,'Fox Point','WI'),
('Maple School District',3297,5508640,'4751 S County Road F',NULL,'Maple','WI'),
('Marathon City School District',3304,5508670,'PO Box 37',NULL,'Marathon','WI'),
('Marinette School District',3311,5508700,'2139 Pierce Ave',NULL,'Marinette','WI'),
('Marion School District',3318,5508730,'1001 N Main St',NULL,'Marion','WI'),
('Markesan School District',3325,5508760,'PO Box 248',NULL,'Markesan','WI'),
('Marshall School District',3332,5508790,'PO Box 76',NULL,'Marshall','WI'),
('Marshfield Unified School District',3339,5508820,'1010 E Fourth St',NULL,'Marshfield','WI'),
('Mauston School District',3360,5508850,'510 Grayside Ave',NULL,'Mauston','WI'),
('Mayville School District',3367,5508880,'N8210 Highway 28',NULL,'Mayville','WI'),
('McFarland School District',3381,5508910,'5101 Farwell St',NULL,'McFarland','WI'),
('Medford Area Public School District',3409,5508940,'124 W State St',NULL,'Medford','WI'),
('Mellen School District',3427,5508970,'PO Box 500',NULL,'Mellen','WI'),
('Melrose-Mindoro School District',3428,5509000,'N181 State Road 108',NULL,'Melrose','WI'),
('Menasha Joint School District',3430,5509030,'PO Box 360',NULL,'Menasha','WI'),
('Menominee Indian School District',3434,5509070,'PO Box 1330',NULL,'Keshena','WI'),
('Menomonee Falls School District',3437,5509060,'W156N8480 Pilgrim Rd',NULL,'Menomonee Falls','WI'),
('Menomonie Area School District',3444,5509090,'Administrative Service Center','215 Pine Ave NE','Menomonie','WI'),
('Mequon-Thiensville School District',3479,5509130,'5000 W Mequon Rd',NULL,'Mequon','WI'),
('Mercer School District',3484,5509150,'2690 W Margaret St',NULL,'Mercer','WI'),
('Merrill Area School District',3500,5509210,'1111 N Sales St',NULL,'Merrill','WI'),
('Merton Community School District',3528,5509360,'PO Box 15',NULL,'Merton','WI'),
('Middleton-Cross Plains Area School District',3549,5509510,'7106 South Ave',NULL,'Middleton','WI'),
('Milton School District',3612,5509570,'448 E High St',NULL,'Milton','WI'),
('Milwaukee School District',3619,5509600,'PO Box 2181',NULL,'Milwaukee','WI'),
('Mineral Point Unified School District',3633,5509660,'705 Ross St',NULL,'Mineral Point','WI'),
('Minocqua J1 School District',3640,5509690,'7450 Titus Dr',NULL,'Minocqua','WI'),
('Mishicot School District',3661,5509750,'PO Box 280',NULL,'Mishicot','WI'),
('Mondovi School District',3668,5509780,'337 N Jackson St',NULL,'Mondovi','WI'),
('Monona Grove School District',3675,5509810,'5301 Monona Dr',NULL,'Monona','WI'),
('Monroe School District',3682,5509840,'925 16th Ave Ste 3',NULL,'Monroe','WI'),
('Montello School District',3689,5509870,'222 Forest Ln',NULL,'Montello','WI'),
('Monticello School District',3696,5509900,'334 S Main St',NULL,'Monticello','WI'),
('Mosinee School District',3787,5509960,'591 W Highway 153',NULL,'Mosinee','WI'),
('Mount Horeb Area School District',3794,5509990,'District Office','1304 E Lincoln St','Mount Horeb','WI'),
('Mukwonago School District',3822,5510060,'385 E Veterans Way',NULL,'Mukwonago','WI'),
('Muskego-Norway School District',3857,5510170,'Educational Services Center','S87W18763 Woods Rd','Muskego','WI'),
('Necedah Area School District',3871,5510230,'1801 S Main St',NULL,'Necedah','WI'),
('Neenah Joint School District',3892,5510320,'410 S Commercial St',NULL,'Neenah','WI'),
('Neillsville School District',3899,5510350,'614 E 5th St',NULL,'Neillsville','WI'),
('Nekoosa School District',3906,5510380,'600 S Section St',NULL,'Nekoosa','WI'),
('New Auburn School District',3920,5510440,'704 N East St',NULL,'New Auburn','WI'),
('New Berlin School District',3925,5510470,'4333 S Sunnyslope Rd',NULL,'New Berlin','WI'),
('New Glarus School District',3934,5510500,'PO Box 7',NULL,'New Glarus','WI'),
('New Holstein School District',3941,5510530,'1715 Plymouth St',NULL,'New Holstein','WI'),
('New Lisbon School District',3948,5510560,'500 S Forest St',NULL,'New Lisbon','WI'),
('New London School District',3955,5510590,'901 W Washington St',NULL,'New London','WI'),
('New Richmond School District',3962,5510620,'701 E 11th St',NULL,'New Richmond','WI'),
('Niagara School District',3969,5510680,'700 Jefferson Ave',NULL,'Niagara','WI'),
('Nicolet UHS School District',2177,5505490,'6701 N Jean Nicolet Rd',NULL,'Glendale','WI'),
('Norris School District',3976,5510710,'W247S10395 Center Dr',NULL,'Mukwonago','WI');
INSERT INTO wisc_crosswalk VALUES
('North Cape School District',4690,5512510,'11926 W Highway K',NULL,'Franksville','WI'),
('North Crawford School District',2016,5504980,'47050 County Road X',NULL,'Soldiers Grove','WI'),
('North Fond du Lac School District',3983,5510740,'225 McKinley St',NULL,'North Fond du Lac','WI'),
('North Lake School District',3514,5509300,'PO Box 188',NULL,'North Lake','WI'),
('North Lakeland School District',0616,5501530,'12686 County Road K',NULL,'Manitowish Waters','WI'),
('Northern Ozaukee School District',1945,5504890,'401 Highland Dr',NULL,'Fredonia','WI'),
('Northland Pines School District',1526,5503860,'1800 Pleasure Island Rd',NULL,'Eagle River','WI'),
('Northwood School District',3654,5509720,'N14463 Highway 53',NULL,'Minong','WI'),
('Norwalk-Ontario-Wilton School District',3990,5510770,'PO Box 130',NULL,'Ontario','WI'),
('Norway J7 School District',4011,5510800,'21016 7 Mile Rd',NULL,'Franksville','WI'),
('Oak Creek-Franklin Joint School District',4018,5510830,'7630 S 10th St',NULL,'Oak Creek','WI'),
('Oakfield School District',4025,5510860,'PO Box 99',NULL,'Oakfield','WI'),
('Oconomowoc Area School District',4060,5510890,'W360N7077 Brown St',NULL,'Oconomowoc','WI'),
('Oconto Falls Public School District',4074,5510950,'200 N Farm Rd',NULL,'Oconto Falls','WI'),
('Oconto Unified School District',4067,5510920,'400 Michigan Ave',NULL,'Oconto','WI'),
('Omro School District',4088,5510980,'455 Fox Trl',NULL,'Omro','WI'),
('Onalaska School District',4095,5511010,'237 2nd Ave S',NULL,'Onalaska','WI'),
('Oostburg School District',4137,5511070,'PO Box 700100',NULL,'Oostburg','WI'),
('Oregon School District',4144,5511100,'123 E Grove St',NULL,'Oregon','WI'),
('Osceola School District',4165,5511160,'PO Box 128',NULL,'Osceola','WI'),
('Oshkosh Area School District',4179,5511190,'PO Box 3048',NULL,'Oshkosh','WI'),
('Osseo-Fairchild School District',4186,5511220,'50851 East St',NULL,'Osseo','WI'),
('Owen-Withee School District',4207,5511310,'PO Box 417',NULL,'Owen','WI'),
('Palmyra-Eagle Area School District',4221,5511350,'PO Box 901',NULL,'Palmyra','WI'),
('Pardeeville Area School District',4228,5511370,'PO Box 130',NULL,'Pardeeville','WI'),
('Paris J1 School District',4235,5511400,'1901 176th Ave',NULL,'Kenosha','WI'),
('Parkview School District',4151,5511130,'PO Box 250',NULL,'Orfordville','WI'),
('Pecatonica Area School District',0490,5501310,'PO Box 117',NULL,'Blanchardville','WI'),
('Pepin Area School District',4270,5511580,'PO Box 128',NULL,'Pepin','WI'),
('Peshtigo School District',4305,5511610,'341 N Emery Ave',NULL,'Peshtigo','WI'),
('Pewaukee School District',4312,5511640,'404 Lake St',NULL,'Pewaukee','WI'),
('Phelps School District',4330,5511710,'4451 Old School Rd',NULL,'Phelps','WI'),
('Phillips School District',4347,5511730,'PO Box 70',NULL,'Phillips','WI'),
('Pittsville School District',4368,5511790,'Pittsville District Office','5459 Elementary Ave Suite 2','Pittsville','WI'),
('Platteville School District',4389,5511850,'780 N 2nd St',NULL,'Platteville','WI'),
('Plum City School District',4459,5511880,'907 Main St',NULL,'Plum City','WI'),
('Plymouth Joint School District',4473,5511940,'125 S Highland Ave',NULL,'Plymouth','WI'),
('Port Edwards School District',4508,5511970,'801 2nd St',NULL,'Port Edwards','WI'),
('Port Washington-Saukville School District',4515,5512000,'100 W Monroe St',NULL,'Port Washington','WI'),
('Portage Community School District',4501,5512060,'305 E Slifer St',NULL,'Portage','WI'),
('Potosi School District',4529,5512090,'128 Highway 61 N',NULL,'Potosi','WI'),
('Poynette School District',4536,5512120,'PO Box 10',NULL,'Poynette','WI'),
('Prairie du Chien Area School District',4543,5512150,'800 E Crawford St Dist Ofc',NULL,'Prairie du Chien','WI'),
('Prairie Farm Public School District',4557,5512180,'630 River Ave S',NULL,'Prairie Farm','WI'),
('Prentice School District',4571,5512210,'1025 Town St',NULL,'Prentice','WI'),
('Prescott School District',4578,5512240,'1220 Saint Croix St',NULL,'Prescott','WI'),
('Princeton School District',4606,5512300,'PO Box 147',NULL,'Princeton','WI'),
('Pulaski Community School District',4613,5512330,'PO Box 36',NULL,'Pulaski','WI'),
('Racine Unified School District',4620,5512360,'Administrative Service Campus','3109 Mount Pleasant St','Racine','WI'),
('Randall J1 School District',4627,5512390,'37101 87th St',NULL,'Burlington','WI'),
('Randolph School District',4634,5512420,'110 Meadowood Dr',NULL,'Randolph','WI'),
('Random Lake School District',4641,5512450,'605 Random Lake Rd',NULL,'Random Lake','WI'),
('Raymond #14 School District',4686,5512480,'2659 76th St',NULL,'Franksville','WI'),
('Reedsburg School District',4753,5512660,'501 K St',NULL,'Reedsburg','WI'),
('Reedsville School District',4760,5512690,'340 Manitowoc St',NULL,'Reedsville','WI'),
('Rhinelander School District',4781,5512720,'665 Coolidge Ave Ste B',NULL,'Rhinelander','WI'),
('Rib Lake School District',4795,5512780,'PO Box 278',NULL,'Rib Lake','WI'),
('Rice Lake Area School District',4802,5512810,'700 Augusta St',NULL,'Rice Lake','WI'),
('Richfield J1 School District',4820,5512900,'PO Box 127',NULL,'Richfield','WI'),
('Richland School District',4851,5512960,'1996 US Hwy 14 W',NULL,'Richland Center','WI'),
('Richmond School District',3122,5508130,'N56W26530 Richmond Rd',NULL,'Sussex','WI'),
('Rio Community School District',4865,5512990,'411 Church St',NULL,'Rio','WI'),
('Ripon Area School District',4872,5513020,'Administrative Services Center','PO Box 991','Ripon','WI'),
('River Falls School District',4893,5513050,'852 E Division St',NULL,'River Falls','WI'),
('River Ridge School District',4904,5500017,'PO Box 78',NULL,'Patch Grove','WI'),
('River Valley School District',5523,5514250,'660 W Daley St',NULL,'Spring Green','WI'),
('Riverdale School District',3850,5510140,'District Office','747 N 6th Street','Muscoda','WI'),
('Rosendale-Brandon School District',4956,5513100,'300 W Wisconsin St',NULL,'Rosendale','WI'),
('Rosholt School District',4963,5513140,'PO Box 310',NULL,'Rosholt','WI'),
('Royall School District',1673,5504380,'1501 Academy St',NULL,'Elroy','WI'),
('Saint Croix Central School District',2422,5506060,'PO Box 118',NULL,'Hammond','WI'),
('Saint Croix Falls School District',5019,5513230,'740 Maple Dr',NULL,'Saint Croix Falls','WI'),
('Saint Francis School District',5026,5513260,'4225 S Lake Dr',NULL,'Saint Francis','WI'),
('Salem School District',5068,5513350,'PO Box 160',NULL,'Salem','WI'),
('Sauk Prairie School District',5100,5513410,'440 13th St',NULL,'Prairie du Sac','WI'),
('Seneca Area School District',5124,5513470,'PO Box 34',NULL,'Seneca','WI'),
('Sevastopol School District',5130,5513500,'4550 Highway 57',NULL,'Sturgeon Bay','WI'),
('Seymour Community School District',5138,5513530,'10 Circle Dr',NULL,'Seymour','WI'),
('Sharon J11 School District',5258,5513560,'104 E School St',NULL,'Sharon','WI'),
('Shawano School District',5264,5513620,'218 County Road B',NULL,'Shawano','WI'),
('Sheboygan Area School District',5271,5513650,'830 Virginia Ave',NULL,'Sheboygan','WI'),
('Sheboygan Falls School District',5278,5513680,'220 Amherst Ave',NULL,'Sheboygan Falls','WI'),
('Shell Lake School District',5306,5513710,'271 Highway 63',NULL,'Shell Lake','WI'),
('Shiocton School District',5348,5513770,'PO Box 68',NULL,'Shiocton','WI'),
('Shorewood School District',5355,5513800,'1701 E Capitol Dr',NULL,'Shorewood','WI'),
('Shullsburg School District',5362,5513830,'444 N Judgement St',NULL,'Shullsburg','WI'),
('Silver Lake J1 School District',5369,5513860,'PO Box 69',NULL,'Silver Lake','WI'),
('Siren School District',5376,5513890,'24022 4th Ave',NULL,'Siren','WI'),
('Slinger School District',5390,5513950,'207 Polk St',NULL,'Slinger','WI'),
('Solon Springs School District',5397,5513980,'8993 E Baldwin Ave',NULL,'Solon Springs','WI'),
('Somerset School District',5432,5514010,'PO Box 100',NULL,'Somerset','WI'),
('South Milwaukee School District',5439,5514040,'901 15th Ave',NULL,'South Milwaukee','WI'),
('South Shore School District',4522,5512030,'PO Box 40',NULL,'Port Wing','WI'),
('Southern Door County School District',5457,5514130,'2073 County Trunk DK',NULL,'Brussels','WI'),
('Southwestern Wisconsin School District',2485,5506300,'PO Box 368',NULL,'Hazel Green','WI'),
('Sparta Area School District',5460,5514160,'201 E Franklin St',NULL,'Sparta','WI'),
('Spencer School District',5467,5514190,'300 N School St',NULL,'Spencer','WI'),
('Spooner Area School District',5474,5514220,'801 County Highway A',NULL,'Spooner','WI'),
('Spring Valley School District',5586,5514340,'PO Box 249',NULL,'Spring Valley','WI'),
('Stanley-Boyd Area School District',5593,5514430,'507 E 1st Ave',NULL,'Stanley','WI'),
('Stevens Point Area Public School District',5607,5514490,'1900 Polk St',NULL,'Stevens Point','WI'),
('Stockbridge School District',5614,5514520,'PO Box 188',NULL,'Stockbridge','WI'),
('Stone Bank School District',3542,5509390,'N68W33866 County Road K',NULL,'Oconomowoc','WI'),
('Stoughton Area School District',5621,5514550,'320 North St',NULL,'Stoughton','WI'),
('Stratford School District',5628,5514580,'PO Box 7',NULL,'Stratford','WI'),
('Sturgeon Bay School District',5642,5514610,'1230 Michigan St',NULL,'Sturgeon Bay','WI'),
('Sun Prairie Area School District',5656,5514640,'501 S Bird St',NULL,'Sun Prairie','WI'),
('Superior School District',5663,5514670,'3025 Tower Ave',NULL,'Superior','WI'),
('Suring Public School District',5670,5514700,'PO Box 158',NULL,'Suring','WI'),
('Swallow School District',3510,5509240,'W299N5614 County Road E',NULL,'Hartland','WI'),
('Thorp School District',5726,5514820,'PO Box 449',NULL,'Thorp','WI'),
('Three Lakes School District',5733,5514850,'6930 W School St',NULL,'Three Lakes','WI'),
('Tigerton School District',5740,5514880,'PO Box 10',NULL,'Tigerton','WI'),
('Tomah Area School District',5747,5514910,'TASD District Office','129 W Clifton St','Tomah','WI'),
('Tomahawk School District',5754,5514940,'1048 E Kings Rd',NULL,'Tomahawk','WI'),
('Tomorrow River School District',0126,5500330,'357 N Main St',NULL,'Amherst','WI'),
('Trevor-Wilmot Consolidated School District',5780,5500052,'26325 Wilmot Rd',NULL,'Trevor','WI'),
('Tri-County Area School District',4375,5511820,'409 S West St',NULL,'Plainfield','WI'),
('Turtle Lake School District',5810,5515060,'205 Oak St N',NULL,'Turtle Lake','WI'),
('Twin Lakes #4 School District',5817,5515090,'1218 Wilmot Ave',NULL,'Twin Lakes','WI'),
('Two Rivers Public School District',5824,5515120,'4521 Lincoln Ave',NULL,'Two Rivers','WI'),
('Union Grove J1 School District',5859,5515180,'1745 Milldrum St',NULL,'Union Grove','WI'),
('Union Grove UHS School District',5852,5515150,'3433 S Colony Ave',NULL,'Union Grove','WI'),
('Unity School District',0238,5500750,'1908 150th St Hwy 46 N',NULL,'Balsam Lake','WI'),
('Valders Area School District',5866,5515210,'138 Wilson St',NULL,'Valders','WI'),
('Verona Area School District',5901,5515330,'700 N Main St',NULL,'Verona','WI'),
('Viroqua Area School District',5985,5515360,'115 N Education Ave',NULL,'Viroqua','WI'),
('Wabeno Area School District',5992,5515390,'PO Box 460',NULL,'Wabeno','WI'),
('Walworth J1 School District',6022,5515450,'121 Beloit St',NULL,'Walworth','WI'),
('Washburn School District',6027,5515540,'PO Box 730',NULL,'Washburn','WI'),
('Washington School District',6069,5515570,'888 Main Rd',NULL,'Washington Island','WI'),
('Washington-Caldwell School District',6104,5515700,'8937 Big Bend Rd',NULL,'Waterford','WI'),
('Waterford Graded J1 School District',6113,5515660,'819 W Main St',NULL,'Waterford','WI'),
('Waterford UHS School District',6083,5515600,'507 W Main St',NULL,'Waterford','WI'),
('Waterloo School District',6118,5515720,'813 N Monroe St',NULL,'Waterloo','WI'),
('Watertown Unified School District',6125,5515750,'111 Dodge St',NULL,'Watertown','WI'),
('Waukesha School District',6174,5515780,'222 Maple Ave',NULL,'Waukesha','WI'),
('Waunakee Community School District',6181,5515810,'Administration and Maintenance','905 Bethel Cir','Waunakee','WI'),
('Waupaca School District',6195,5515840,'E2325 King Rd',NULL,'Waupaca','WI'),
('Waupun School District',6216,5515870,'Education Service Center','950 Wilcox St','Waupun','WI'),
('Wausau School District',6223,5515900,'PO Box 359',NULL,'Wausau','WI'),
('Wausaukee School District',6230,5515930,'PO Box 258',NULL,'Wausaukee','WI'),
('Wautoma Area School District',6237,5515960,'PO Box 870',NULL,'Wautoma','WI'),
('Wauwatosa School District',6244,5515990,'12121 W North Ave',NULL,'Wauwatosa','WI'),
('Wauzeka-Steuben School District',6251,5516020,'301 E Main St',NULL,'Wauzeka','WI'),
('Webster School District',6293,5516230,'PO Box 9',NULL,'Webster','WI'),
('West Allis-West Milwaukee School District',6300,5516260,'1205 S 70th St',NULL,'West Allis','WI'),
('West Bend School District',6307,5516290,'735 S Main St',NULL,'West Bend','WI'),
('West De Pere School District',6328,5516320,'400 Reid St Ste W',NULL,'De Pere','WI'),
('West Salem School District',6370,5516350,'405 E Hamlin St',NULL,'West Salem','WI'),
('Westby Area School District',6321,5516410,'206 West Ave S',NULL,'Westby','WI'),
('Westfield School District',6335,5516440,'N7046 County Road M',NULL,'Westfield','WI'),
('Weston School District',6354,5516470,'E2511 County Road S',NULL,'Cazenovia','WI'),
('Weyauwega-Fremont School District',6384,5516500,'PO Box 580',NULL,'Weyauwega','WI'),
('Wheatland J1 School District',6412,5516560,'6606 368th Ave',NULL,'Burlington','WI'),
('White Lake School District',6440,5516590,'PO Box 67',NULL,'White Lake','WI'),
('Whitefish Bay School District',6419,5516620,'1200 E Fairmount Ave',NULL,'Whitefish Bay','WI'),
('Whitehall School District',6426,5516650,'19121 Hobson St',NULL,'Whitehall','WI'),
('Whitewater Unified School District',6461,5516680,'419 S Elizabeth St',NULL,'Whitewater','WI'),
('Whitnall School District',6470,5506000,'5000 S 116th St',NULL,'Greenfield','WI'),
('Wild Rose School District',6475,5516710,'PO Box 276',NULL,'Wild Rose','WI'),
('Williams Bay School District',6482,5516740,'PO Box 1410',NULL,'Williams Bay','WI'),
('Wilmot UHS School District',6545,5516770,'PO Box 8',NULL,'Wilmot','WI'),
('Winneconne Community School District',6608,5516830,'PO Box 5000',NULL,'Winneconne','WI'),
('Winter School District',6615,5516860,'PO Box 310',NULL,'Winter','WI'),
('Wisconsin Dells School District',6678,5517040,'811 County Road H',NULL,'Wisconsin Dells','WI'),
('Wisconsin Heights School District',0469,5501230,'10173 US Highway 14',NULL,'Mazomanie','WI'),
('Wisconsin Rapids School District',6685,5517070,'510 Peach St',NULL,'Wisconsin Rapids','WI'),
('Wittenberg-Birnamwood School District',6692,5517100,'400 W Grand Ave',NULL,'Wittenberg','WI'),
('Wonewoc-Union Center School District',6713,5517130,'101 School Rd',NULL,'Wonewoc','WI'),
('Woodruff J1 School District',6720,5517160,'11065 Old Highway 51 N',NULL,'Arbor Vitae','WI'),
('Wrightstown Community School District',6734,5517190,'PO Box 128',NULL,'Wrightstown','WI'),
('Yorkville J2 School District',6748,5517220,'18621 Washington Ave',NULL,'Union Grove','WI');