units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
162 rows where LAYER = 4 and MNG_AG_TYP = 2 sorted by COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Whittier, City of 18
- San Ramon, City of 17
- Manhattan Beach, City of 8
- Arcadia, City of 7
- Hollister, City of 6
- Fresno, City of 5
- Santa Ana, City of 5
- Los Angeles, City of 5
- Beverly Hills, City of 5
- Palmdale, City of 4
- Sierra Madre, City of 4
- Santa Clarita, City of 4
- Bellflower, City of 4
- Lawndale, City of 4
- San Diego, City of 3
- Carlsbad, City of 3
- San Bernardino, City of 3
- Pasadena, City of 3
- San Gabriel, City of 3
- Santa Maria, City of 2
- Glendora, City of 2
- Lake Elsinore, City of 2
- San Marcos, City of 2
- La Verne, City of 2
- Duarte, City of 2
- Clovis, City of 2
- South El Monte, City of 2
- Culver City, City of 1
- San Francisco, City and County of 1
- Santa Rosa, City of 1
- …
DES_TP 9
- Local Park 116
- Local Recreation Area 35
- Local Conservation Area 5
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Restricted Access 117
- Open Access 42
- No Public Access 3
MNG_AG_TYP 1
- City Agency · 162 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} | Restricted Access 2 | 47437 | Monroe Elementary School Field | 31153 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.918 | Monroe Elementary School Field | 0 | Local Recreation Area 3 | 4 | |
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} | Restricted Access 2 | 47438 | Spurgeon Intermediate School Field | 31154 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 12.376 | Spurgeon Intermediate School Field | 0 | Local Recreation Area 3 | 4 | |
6328 | 6328 | 6327 | {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} | Restricted Access 2 | 47436 | Valley High School Field | 31152 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 24.28 | Valley High School Field | 0 | Local Recreation Area 3 | 4 | |
6335 | 6335 | 6334 | {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} | Restricted Access 2 | 47439 | Hector G. Godinez High School Field | 31155 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.664 | Hector G. Godinez High School Field | 0 | Local Recreation Area 3 | 4 | |
6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | 47441 | Rose Drive Elementary School Recreational Facilities | 31157 | 2410 | Placentia-Yorba Linda Unified School District 833 | Special District 4 | School District 14 | http://www.pylusd.org/ | Special District 4 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.295 | Rose Drive Elementary School Recreational Facilities | 0 | Local Recreation Area 3 | 4 | |
14210 | 14210 | 14209 | {"type": "Polygon", "coordinates": [[[-117.89549, 33.9268], [-117.89549, 33.92741], [-117.89547, 33.92752], [-117.89199, 33.92753], [-117.89193, 33.92519], [-117.89201, 33.9251], [-117.8935, 33.92506], [-117.89355, 33.9268], [-117.89549, 33.9268]]]} | Restricted Access 2 | 44076 | Brea Junior High Park | 16342 | 2311 | Brea Olinda Unified School District 1100 | Special District 4 | School District 14 | http://www.bousd.k12.ca.us/ | Special District 4 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | Orange 3 | 13.284 | Brea Junior High Park | 0 | Local Park 2 | 4 | |
14241 | 14241 | 14240 | {"type": "Polygon", "coordinates": [[[-117.90149, 33.74169], [-117.90036, 33.7417], [-117.90037, 33.74], [-117.90142, 33.73999], [-117.90142, 33.7407], [-117.90149, 33.74074], [-117.90149, 33.74169]]]} | Restricted Access 2 | 44131 | Friendship Park | 19123 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 4.747 | Friendship Park | 0 | Local Park 2 | 4 | |
4386 | 4386 | 4385 | {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} | Restricted Access 2 | 45967 | South Oceanside School Park | 31598 | 2100 | Oceanside Unified School District 756 | Special District 4 | School District 14 | http://www.oside.k12.ca.us/ | Special District 4 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 | San Diego 4 | 4.254 | South Oceanside School Park | 0 | Local Park 2 | 4 |
5896 | 5896 | 5895 | {"type": "Polygon", "coordinates": [[[-117.06009, 32.76351], [-117.05994, 32.76363], [-117.05895, 32.76366], [-117.05892, 32.76238], [-117.06004, 32.76235], [-117.06009, 32.76351]]]} | Restricted Access 2 | 46816 | Clay Elementary School Park | 31950 | 2310 | San Diego Unified School District 820 | Special District 4 | School District 14 | http://www.sandi.net/sandi | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.701 | Clay Elementary School Park | 0 | Local Park 2 | 4 | |
7621 | 7621 | 7620 | {"type": "Polygon", "coordinates": [[[-117.28518, 33.02562], [-117.28529, 33.02578], [-117.28529, 33.02582], [-117.28512, 33.0259], [-117.28506, 33.02592], [-117.28492, 33.02592], [-117.28455, 33.02589], [-117.28394, 33.02578], [-117.28407, 33.02539], [-117.28421, 33.02491], [-117.28411, 33.02487], [-117.28368, 33.02416], [-117.2841, 33.02397], [-117.28416, 33.02397], [-117.28518, 33.02562]]]} | Restricted Access 2 | 47635 | George Berkich Park | 31614 | 2412 | Cardiff School District 875 | Special District 4 | School District 14 | http://cardiffschools.com/ | Special District 4 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.697 | George Berkich Park | 0 | Local Park 2 | 4 | |
7803 | 7803 | 7802 | {"type": "Polygon", "coordinates": [[[-117.12407, 32.90826], [-117.1212, 32.90829], [-117.12119, 32.9083], [-117.1212, 32.90846], [-117.12031, 32.90848], [-117.12032, 32.9079], [-117.11968, 32.90787], [-117.11963, 32.90544], [-117.12392, 32.90544], [-117.12399, 32.90551], [-117.12407, 32.90826]]]} | Open Access 1 | 47682 | Hourglass Field Community Park and Field House | 31418 | 2413 | San Diego Community College District 878 | Special District 4 | School District 14 | http://www.sdccd.edu/ | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/centers/recctr/hourglass | San Diego 4 | 31.533 | Hourglass Field Community Park and Field House | None 650 | ||
8217 | 8217 | 8216 | {"type": "Polygon", "coordinates": [[[-117.17097, 33.11374], [-117.17037, 33.11403], [-117.16936, 33.1144], [-117.16869, 33.11525], [-117.16869, 33.11589], [-117.1677, 33.11649], [-117.16752, 33.11688], [-117.16683, 33.11688], [-117.16714, 33.11618], [-117.16679, 33.11598], [-117.16555, 33.11598], [-117.16559, 33.11623], [-117.16539, 33.11626], [-117.16533, 33.11598], [-117.16473, 33.11597], [-117.16472, 33.11457], [-117.16443, 33.11428], [-117.16415, 33.11412], [-117.16436, 33.11387], [-117.16443, 33.1135], [-117.16443, 33.11338], [-117.16416, 33.11309], [-117.16432, 33.11292], [-117.16492, 33.11313], [-117.16499, 33.11327], [-117.16616, 33.11328], [-117.16617, 33.11297], [-117.1667, 33.11245], [-117.16671, 33.11222], [-117.16609, 33.1121], [-117.16543, 33.11143], [-117.16572, 33.11127], [-117.16596, 33.11142], [-117.16637, 33.11155], [-117.16697, 33.1115], [-117.16709, 33.11132], [-117.16748, 33.11138], [-117.16788, 33.11159], [-117.16805, 33.11267], [-117.16799, 33.11329], [-117.16876, 33.11329], [-117.16878, 33.11319], [-117.16924, 33.11279], [-117.17009, 33.11237], [-117.16996, 33.11267], [-117.16958, 33.1131], [-117.16954, 33.11329], [-117.16947, 33.1133], [-117.16942, 33.11355], [-117.16966, 33.11366], [-117.17097, 33.11374]], [[-117.16912, 33.11452], [-117.16939, 33.11424], [-117.16972, 33.11406], [-117.16972, 33.11395], [-117.16945, 33.11372], [-117.16928, 33.11338], [-117.16907, 33.11344], [-117.16868, 33.11397], [-117.1683, 33.11424], [-117.16779, 33.11418], [-117.16765, 33.11374], [-117.16769, 33.11329], [-117.16666, 33.11328], [-117.16658, 33.11343], [-117.16583, 33.11369], [-117.1652, 33.11353], [-117.1649, 33.11361], [-117.16487, 33.11397], [-117.16536, 33.11482], [-117.16555, 33.11498], [-117.16593, 33.11491], [-117.16683, 33.11496], [-117.16743, 33.1153], [-117.16849, 33.11523], [-117.16906, 33.11473], [-117.16912, 33.11452]]]} | No Public Access 3 | 47786 | South Lake Park | 31662 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 29.916 | South Lake Park | 0 | Local Park 2 | 4 | |
8218 | 8218 | 8217 | {"type": "MultiPolygon", "coordinates": [[[[-117.15598, 33.10707], [-117.15561, 33.10724], [-117.15541, 33.10729], [-117.15513, 33.10743], [-117.15484, 33.1075], [-117.15451, 33.10766], [-117.15398, 33.10779], [-117.15382, 33.10784], [-117.15357, 33.10796], [-117.15344, 33.10805], [-117.1534, 33.10809], [-117.15337, 33.10818], [-117.1534, 33.10835], [-117.15356, 33.10863], [-117.15377, 33.10915], [-117.15402, 33.10997], [-117.15394, 33.10991], [-117.15386, 33.10987], [-117.15326, 33.10975], [-117.15296, 33.10964], [-117.15283, 33.11018], [-117.15297, 33.11064], [-117.15345, 33.11053], [-117.15394, 33.11036], [-117.15385, 33.11066], [-117.1538, 33.11078], [-117.15369, 33.11096], [-117.15363, 33.111], [-117.15356, 33.11101], [-117.15302, 33.11098], [-117.15136, 33.11131], [-117.15112, 33.11093], [-117.15102, 33.11072], [-117.151, 33.11064], [-117.151, 33.11048], [-117.15098, 33.11037], [-117.15081, 33.10999], [-117.1507, 33.10967], [-117.1507, 33.10956], [-117.15072, 33.10945], [-117.15071, 33.10937], [-117.15038, 33.10894], [-117.15017, 33.10859], [-117.15012, 33.10852], [-117.15003, 33.10847], [-117.14962, 33.10829], [-117.14952, 33.10827], [-117.14942, 33.10828], [-117.14875, 33.10845], [-117.14855, 33.10847], [-117.14838, 33.10846], [-117.14822, 33.10849], [-117.14822, 33.1055], [-117.14954, 33.10548], [-117.1506, 33.10609], [-117.15282, 33.10654], [-117.15402, 33.10642], [-117.15598, 33.10707]]], [[[-117.16972, 33.11406], [-117.16939, 33.11424], [-117.16912, 33.11452], [-117.16906, 33.11473], [-117.16849, 33.11523], [-117.16743, 33.1153], [-117.16683, 33.11496], [-117.16594, 33.11491], [-117.16555, 33.11498], [-117.16536, 33.11482], [-117.16487, 33.11397], [-117.1649, 33.1136], [-117.1652, 33.11353], [-117.16583, 33.11369], [-117.16658, 33.11343], [-117.16665, 33.11328], [-117.1677, 33.11329], [-117.16765, 33.11374], [-117.16779, 33.11418], [-117.1683, 33.11424], [-117.16868, 33.11397], [-117.16907, 33.11344], [-117.16928, 33.11337], [-117.16945, 33.11372], [-117.16972, 33.11395], [-117.16972, 33.11406]]]]} | No Public Access 3 | 47787 | South Lake Mitigation | 31663 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 72.132 | South Lake Mitigation | 0 | Local Other or Unknown 14 | 4 | |
13646 | 13646 | 13645 | {"type": "Polygon", "coordinates": [[[-116.97354, 32.83713], [-116.97353, 32.83828], [-116.97352, 32.83831], [-116.97349, 32.83833], [-116.96945, 32.83826], [-116.96948, 32.83738], [-116.97011, 32.83739], [-116.97013, 32.83657], [-116.97133, 32.8366], [-116.97132, 32.83709], [-116.97354, 32.83713]]]} | Open Access 1 | 45974 | Santee Mini Park | 29124 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=67 | San Diego 4 | 13.58 | Santee MP | 0 | Local Park 2 | 4 |
14205 | 14205 | 14204 | {"type": "Polygon", "coordinates": [[[-117.0489, 32.67824], [-117.04772, 32.67864], [-117.04697, 32.67911], [-117.04638, 32.67955], [-117.04603, 32.67827], [-117.04596, 32.67806], [-117.04688, 32.67781], [-117.04697, 32.6778], [-117.04699, 32.67778], [-117.04668, 32.67615], [-117.04831, 32.67614], [-117.04833, 32.67636], [-117.04857, 32.67756], [-117.0487, 32.67789], [-117.0489, 32.67824]]]} | Restricted Access 2 | 44066 | Penn Athletic Field | 31636 | 2310 | San Diego Unified School District 820 | Special District 4 | School District 14 | http://www.sandi.net/sandi | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 13.867 | Penn Athletic Field | 0 | Local Recreation Area 3 | 4 | |
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
944 | 944 | 943 | {"type": "Polygon", "coordinates": [[[-118.31116, 33.76052], [-118.31051, 33.76273], [-118.30904, 33.76256], [-118.30904, 33.76051], [-118.31116, 33.76052]]]} | Open Access 1 | 5973 | Eastview Park | 18401 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 9.81 | Eastview 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]);