units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 180 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16436 | 16436 | 16435 | {"type": "MultiPolygon", "coordinates": [[[[-118.51739, 34.02521], [-118.51653, 34.02589], [-118.51439, 34.02481], [-118.51406, 34.02525], [-118.5134, 34.02491], [-118.51238, 34.02435], [-118.51199, 34.02412], [-118.51237, 34.0237], [-118.51161, 34.0232], [-118.5112, 34.0236], [-118.51097, 34.02344], [-118.51137, 34.02304], [-118.50904, 34.02123], [-118.50859, 34.02159], [-118.50852, 34.02154], [-118.50853, 34.0215], [-118.50769, 34.02085], [-118.50809, 34.02048], [-118.50677, 34.01947], [-118.50634, 34.01983], [-118.50632, 34.01982], [-118.50673, 34.01945], [-118.50659, 34.01933], [-118.50617, 34.0197], [-118.50581, 34.01942], [-118.50622, 34.01905], [-118.50587, 34.01877], [-118.50545, 34.01913], [-118.50524, 34.01897], [-118.50565, 34.0186], [-118.50523, 34.01825], [-118.5048, 34.01862], [-118.50458, 34.01846], [-118.50501, 34.01807], [-118.50473, 34.01785], [-118.5043, 34.01822], [-118.50403, 34.01802], [-118.50448, 34.01765], [-118.50435, 34.01754], [-118.50388, 34.01791], [-118.50193, 34.01637], [-118.50222, 34.01612], [-118.50373, 34.01741], [-118.50378, 34.01738], [-118.50123, 34.01521], [-118.50097, 34.01506], [-118.49608, 34.0106], [-118.49497, 34.00952], [-118.49503, 34.00947], [-118.49498, 34.00936], [-118.4947, 34.0091], [-118.49465, 34.00908], [-118.49457, 34.00914], [-118.49188, 34.00657], [-118.49169, 34.00641], [-118.49144, 34.00614], [-118.49146, 34.00611], [-118.49135, 34.006], [-118.49133, 34.006], [-118.48736, 34.00198], [-118.48698, 34.00157], [-118.48726, 34.0014], [-118.48792, 34.00211], [-118.48814, 34.00196], [-118.48693, 34.00069], [-118.48689, 34.0007], [-118.48681, 34.00062], [-118.48676, 34.00061], [-118.48666, 34.00053], [-118.48649, 34.00059], [-118.48639, 34.00049], [-118.48652, 34.00037], [-118.48642, 34.00027], [-118.48646, 34.00024], [-118.48635, 34.00013], [-118.48638, 34.0001], [-118.48629, 33.99999], [-118.48636, 33.99995], [-118.48622, 33.99979], [-118.48628, 33.99974], [-118.4861, 33.99955], [-118.48549, 33.99996], [-118.48409, 33.99847], [-118.48355, 33.99794], [-118.48411, 33.99757], [-118.48411, 33.99755], [-118.48402, 33.99748], [-118.48387, 33.99748], [-118.48347, 33.99773], [-118.48336, 33.99775], [-118.48265, 33.99704], [-118.48266, 33.99682], [-118.48261, 33.99671], [-118.48254, 33.99663], [-118.48245, 33.99655], [-118.48212, 33.99647], [-118.48193, 33.99627], [-118.482, 33.99621], [-118.48163, 33.99581], [-118.48214, 33.99547], [-118.48257, 33.99589], [-118.48352, 33.99534], [-118.48429, 33.99629], [-118.48542, 33.99756], [-118.48626, 33.9987], [-118.48672, 33.99921], [-118.48679, 33.99935], [-118.48711, 33.99973], [-118.48732, 33.99988], [-118.48764, 34.00019], [-118.48802, 34.00047], [-118.48827, 34.00069], [-118.48869, 34.00121], [-118.48893, 34.00156], [-118.48981, 34.00261], [-118.49033, 34.00315], [-118.49117, 34.00405], [-118.49219, 34.00526], [-118.49346, 34.00642], [-118.49466, 34.00733], [-118.49572, 34.00794], [-118.49658, 34.00837], [-118.49746, 34.00864], [-118.49796, 34.00895], [-118.49851, 34.00949], [-118.49904, 34.0098], [-118.49966, 34.00998], [-118.50024, 34.0104], [-118.501, 34.01129], [-118.50147, 34.01199], [-118.50289, 34.01419], [-118.50413, 34.01521], [-118.50517, 34.0161], [-118.50641, 34.0172], [-118.50874, 34.01906], [-118.50938, 34.01951], [-118.51008, 34.02018], [-118.51093, 34.02084], [-118.51237, 34.02183], [-118.51313, 34.02238], [-118.51402, 34.02295], [-118.51468, 34.0234], [-118.51565, 34.02398], [-118.51729, 34.02516], [-118.51739, 34.02521]]], [[[-118.49294, 34.00767], [-118.49265, 34.00791], [-118.49195, 34.00725], [-118.49225, 34.00701], [-118.49294, 34.00767]]], [[[-118.49444, 34.0091], [-118.49414, 34.00934], [-118.49379, 34.00901], [-118.49409, 34.00877], [-118.49444, 34.0091]]], [[[-118.49478, 34.00943], [-118.49449, 34.00967], [-118.49432, 34.0095], [-118.49461, 34.00926], [-118.49478, 34.00943]]], [[[-118.49544, 34.01006], [-118.49512, 34.01031], [-118.49465, 34.00986], [-118.49496, 34.0096], [-118.49544, 34.01006]]], [[[-118.49751, 34.01198], [-118.49725, 34.01217], [-118.497, 34.01196], [-118.49725, 34.01176], [-118.49751, 34.01198]]], [[[-118.49825, 34.01266], [-118.49801, 34.01286], [-118.4974, 34.01231], [-118.49766, 34.01212], [-118.49825, 34.01266]]], [[[-118.50218, 34.01609], [-118.50188, 34.01633], [-118.50134, 34.0159], [-118.50043, 34.01511], [-118.5007, 34.01489], [-118.50095, 34.01512], [-118.50119, 34.01525], [-118.50218, 34.01609]]]]} | Open Access 1 | 6337 | Santa Monica State Beach | 1737 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://www.smgov.net/portals/beach/ | Los Angeles 6 | 204.076 | Santa Monica SB | 1948 | None 1402 | |
15361 | 15361 | 15360 | {"type": "Polygon", "coordinates": [[[-118.4923, 34.01178], [-118.49207, 34.01197], [-118.49131, 34.01131], [-118.49152, 34.01112], [-118.4923, 34.01178]]]} | Open Access 1 | 46568 | Ken Genser Square | 29872 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.733 | Ken Genser Square | 0 | Local Park 2 | 4 | |
12573 | 12573 | 12572 | {"type": "MultiPolygon", "coordinates": [[[[-118.47679, 34.04462], [-118.47644, 34.045], [-118.47629, 34.04491], [-118.47509, 34.04389], [-118.4755, 34.04355], [-118.47659, 34.04447], [-118.47679, 34.04462]]], [[[-118.47729, 34.0442], [-118.47702, 34.04455], [-118.47678, 34.04439], [-118.47647, 34.04414], [-118.47682, 34.04385], [-118.4771, 34.04408], [-118.47729, 34.0442]]]]} | No Public Access 3 | 29309 | Mount Olivet Reservoir | 29887 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.989 | Mount Olivet Reservoir | 0 | Local Recreation Area 3 | 4 | |
11356 | 11356 | 11355 | {"type": "Polygon", "coordinates": [[[-118.46638, 34.02705], [-118.46616, 34.02727], [-118.46622, 34.02748], [-118.4648, 34.02781], [-118.46472, 34.02771], [-118.46448, 34.02748], [-118.46478, 34.02703], [-118.46562, 34.02633], [-118.46638, 34.02705]]]} | Open Access 1 | 22159 | Stewart Street Park | 25849 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 3.939 | Stewart Street Park | 0 | Local Park 2 | 4 | |
11232 | 11232 | 11231 | {"type": "Polygon", "coordinates": [[[-118.46481, 34.02853], [-118.4639, 34.02872], [-118.46352, 34.02864], [-118.46131, 34.02909], [-118.46102, 34.02931], [-118.46054, 34.02941], [-118.46045, 34.02911], [-118.46466, 34.02825], [-118.46471, 34.02825], [-118.46473, 34.02828], [-118.46481, 34.02853]]]} | Open Access 1 | 48030 | Ishihara Park | 32517 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | Los Angeles 6 | 2.358 | Ishihara Park | 2017 | Local Park 2 | 4 |
10828 | 10828 | 10827 | {"type": "Polygon", "coordinates": [[[-118.47609, 34.03049], [-118.47597, 34.03058], [-118.47565, 34.03031], [-118.47575, 34.03022], [-118.47542, 34.02995], [-118.47544, 34.02993], [-118.47609, 34.03049]]]} | Open Access 1 | 20668 | Schrader Park | 25193 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.19 | Schrader Park | 0 | Local Park 2 | 4 | |
10815 | 10815 | 10814 | {"type": "Polygon", "coordinates": [[[-118.47532, 34.03118], [-118.47521, 34.03127], [-118.47452, 34.03068], [-118.47463, 34.03059], [-118.47532, 34.03118]]]} | Open Access 1 | 20667 | Park Drive Park | 23428 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.344 | Park Drive Park | 0 | Local Park 2 | 4 | |
10545 | 10545 | 10544 | {"type": "Polygon", "coordinates": [[[-118.48061, 34.03614], [-118.47995, 34.03667], [-118.47845, 34.03539], [-118.47912, 34.03486], [-118.48061, 34.03614]]]} | Open Access 1 | 18759 | Douglas Park | 18246 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 4.182 | Douglas Park | 0 | Local Park 2 | 4 | |
9110 | 9110 | 9109 | {"type": "Polygon", "coordinates": [[[-118.46924, 34.02156], [-118.46803, 34.02254], [-118.46748, 34.02207], [-118.46771, 34.02188], [-118.46742, 34.02162], [-118.46669, 34.0222], [-118.46596, 34.02158], [-118.46597, 34.02148], [-118.46834, 34.02021], [-118.46879, 34.02059], [-118.46856, 34.02079], [-118.46867, 34.02089], [-118.46856, 34.02099], [-118.46924, 34.02156]]]} | Open Access 1 | 15098 | Virginia Avenue Park | 27155 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 9.358 | Virginia Avenue Park | 0 | Local Park 2 | 4 | |
7649 | 7649 | 7648 | {"type": "Polygon", "coordinates": [[[-118.51554, 34.02623], [-118.51524, 34.02694], [-118.51348, 34.02593], [-118.51343, 34.02598], [-118.50911, 34.02349], [-118.50707, 34.02177], [-118.50709, 34.02166], [-118.49823, 34.01407], [-118.49516, 34.01147], [-118.49507, 34.01136], [-118.4953, 34.01117], [-118.49682, 34.01245], [-118.49851, 34.01396], [-118.50012, 34.01525], [-118.50093, 34.01608], [-118.5022, 34.01714], [-118.50307, 34.01784], [-118.50311, 34.0181], [-118.50326, 34.01815], [-118.50549, 34.01978], [-118.50656, 34.02039], [-118.50676, 34.02042], [-118.50747, 34.02098], [-118.50746, 34.02101], [-118.50832, 34.02168], [-118.50835, 34.02167], [-118.51046, 34.02332], [-118.51101, 34.02372], [-118.51159, 34.0241], [-118.51218, 34.02447], [-118.51279, 34.02481], [-118.51554, 34.02623]]]} | Open Access 1 | 7461 | Palisades Park | 23333 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 32.641 | Palisades Park | 0 | Local Park 2 | 4 | |
6660 | 6660 | 6659 | {"type": "Polygon", "coordinates": [[[-118.48239, 34.00642], [-118.48168, 34.00691], [-118.48093, 34.00617], [-118.48112, 34.00605], [-118.48105, 34.00596], [-118.48158, 34.00562], [-118.48239, 34.00642]]]} | Open Access 1 | 4709 | Los Amigos Park | 21476 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.418 | Los Amigos Park | 0 | Local Park 2 | 4 | |
5719 | 5719 | 5718 | {"type": "Polygon", "coordinates": [[[-118.48412, 33.99756], [-118.4834, 33.99805], [-118.48337, 33.99812], [-118.48332, 33.99811], [-118.48328, 33.99809], [-118.48292, 33.99767], [-118.48257, 33.99731], [-118.4825, 33.99717], [-118.48233, 33.99697], [-118.48232, 33.9969], [-118.48229, 33.99684], [-118.48218, 33.99678], [-118.48205, 33.99672], [-118.4818, 33.99666], [-118.48179, 33.99661], [-118.48206, 33.99641], [-118.48212, 33.99647], [-118.48242, 33.99654], [-118.48248, 33.99657], [-118.48259, 33.99669], [-118.48265, 33.99679], [-118.48267, 33.99687], [-118.48265, 33.99704], [-118.48336, 33.99775], [-118.48347, 33.99773], [-118.48387, 33.99748], [-118.48402, 33.99749], [-118.48412, 33.99756]]]} | Open Access 1 | 46574 | South Beach Park | 29877 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 1.927 | South Beach Park | 0 | Local Park 2 | 4 | |
5718 | 5718 | 5717 | {"type": "Polygon", "coordinates": [[[-118.48747, 34.00126], [-118.48694, 34.00159], [-118.48684, 34.00159], [-118.48551, 34.00018], [-118.48543, 34.0], [-118.48609, 33.99954], [-118.48629, 33.99975], [-118.48623, 33.9998], [-118.48636, 33.99995], [-118.48629, 34.0], [-118.48639, 34.00011], [-118.48636, 34.00014], [-118.48646, 34.00024], [-118.48643, 34.00028], [-118.48653, 34.00037], [-118.4864, 34.00048], [-118.4864, 34.00049], [-118.48649, 34.00059], [-118.48666, 34.00053], [-118.48676, 34.00061], [-118.48681, 34.00062], [-118.48689, 34.0007], [-118.48693, 34.00069], [-118.48747, 34.00126]]]} | Open Access 1 | 46573 | Beach Park 1 | 29876 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 3.774 | Beach Park 1 | None 460 | |||
5717 | 5717 | 5716 | {"type": "Polygon", "coordinates": [[[-118.48814, 34.00196], [-118.48792, 34.00211], [-118.48726, 34.0014], [-118.48747, 34.00126], [-118.48814, 34.00196]]]} | Open Access 1 | 46572 | Beach Green Park | 29875 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.64 | Beach Green Park | 0 | Local Park 2 | 4 | |
5274 | 5274 | 5273 | {"type": "Polygon", "coordinates": [[[-118.48223, 34.00832], [-118.48111, 34.00898], [-118.48056, 34.00851], [-118.48172, 34.00782], [-118.48223, 34.00832]]]} | Open Access 1 | 2576 | Joslyn Park | 20508 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.299 | Joslyn Park | 0 | Local Park 2 | 4 | |
5218 | 5218 | 5217 | {"type": "Polygon", "coordinates": [[[-118.48466, 34.02177], [-118.48429, 34.02207], [-118.48409, 34.0219], [-118.48445, 34.02159], [-118.48466, 34.02177]]]} | Open Access 1 | 20669 | Euclid Park | 18745 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.321 | Euclid Park | 0 | Local Park 2 | 4 | |
4829 | 4829 | 4828 | {"type": "Polygon", "coordinates": [[[-118.49504, 34.00947], [-118.49495, 34.00953], [-118.49455, 34.00915], [-118.49465, 34.00908], [-118.4947, 34.0091], [-118.49498, 34.00936], [-118.49504, 34.00947]]]} | Open Access 1 | 46569 | Chess Park | 29873 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.191 | Chess Park | 0 | Local Park 2 | 4 | |
4225 | 4225 | 4224 | {"type": "Polygon", "coordinates": [[[-118.47891, 34.01843], [-118.47761, 34.01948], [-118.47634, 34.0184], [-118.47499, 34.01949], [-118.47298, 34.01777], [-118.47616, 34.01607], [-118.47891, 34.01843]]]} | Open Access 1 | 29311 | Woodlawn Cemetery | 27728 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 26.5 | Woodlawn Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
4012 | 4012 | 4011 | {"type": "Polygon", "coordinates": [[[-118.48789, 34.00292], [-118.48772, 34.00305], [-118.48765, 34.00305], [-118.48759, 34.00303], [-118.48743, 34.00263], [-118.48732, 34.00241], [-118.48573, 34.00074], [-118.48564, 34.00056], [-118.48456, 33.99943], [-118.48443, 33.99935], [-118.48412, 33.99903], [-118.48337, 33.99821], [-118.48336, 33.99817], [-118.48347, 33.99814], [-118.48499, 33.99976], [-118.48551, 34.00018], [-118.48683, 34.00157], [-118.48696, 34.00176], [-118.48754, 34.00237], [-118.48748, 34.00241], [-118.4875, 34.00246], [-118.48748, 34.0025], [-118.48789, 34.00292]]]} | Open Access 1 | 20675 | Barnard Way Linear Park | 15820 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.746 | Barnard Way Linear Park | 0 | Local Park 2 | 4 | |
4011 | 4011 | 4010 | {"type": "Polygon", "coordinates": [[[-118.48814, 34.00558], [-118.48776, 34.00585], [-118.4875, 34.0056], [-118.48788, 34.00533], [-118.48814, 34.00558]]]} | Open Access 1 | 20674 | Pacific Street Park | 23306 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.414 | Pacific Street Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);