units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,162 rows where MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 143
- Hayward Area Recreation and Park District 67
- Valley-Wide Recreation and Park District 54
- Midpeninsula Regional Open Space District 47
- Rancho Simi Recreation and Park District 37
- Southgate Recreation and Park District 37
- Marin County Open Space District 36
- Cordova Recreation and Park District 34
- Sunrise Recreation and Park District 33
- Conejo Recreation and Park District 28
- Santa Clara Valley Open Space Authority 24
- Greater Vallejo Recreation and Park District 23
- Monterey Peninsula Regional Park District 20
- Pleasant Valley Recreation and Park District 19
- North of the River Recreation and Park District 18
- Sonoma County Agricultural Preservation and Open Space District 17
- Isla Vista Recreation and Park District 13
- Jurupa Area Recreation and Park District 13
- Mission Oaks Recreation and Park District 13
- North Highland Recreation and Park District 11
- Apple Valley Recreation and Park District 10
- Livermore Area Recreation and Park District 10
- Pleasant Hill Recreation and Park District 10
- Carmichael Recreation and Park District 10
- Miraleste Recreation and Park District 10
- Hesperia Recreation and Park District 9
- Orangevale Recreation and Park District 9
- Fair Oaks Recreation and Park District 9
- Napa County Regional Park and Open Space District 8
- Desert Recreation District 8
- …
DES_TP >30
- Local Park 542
- Local Conservation Area 152
- Local Recreation Area 137
- Local Other or Unknown 12
- Local Resource Management Area 2
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 3
- Open Access 767
- No Public Access 96
- Restricted Access 50
MNG_AG_TYP 1
- Recreation/Parks District · 913 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | 15062 | Pleasant Valley Recreation and Park District | 23802 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.025 | Pleasant Valley Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5082 | 5082 | 5081 | {"type": "Polygon", "coordinates": [[[-118.85008, 34.18256], [-118.84998, 34.18289], [-118.84956, 34.1828], [-118.84971, 34.18249], [-118.85008, 34.18256]]]} | Open Access 1 | 15579 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.346 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-118.89482, 34.22828], [-118.89475, 34.22845], [-118.8946, 34.2284], [-118.8946, 34.22839], [-118.89482, 34.22828]]]} | Open Access 1 | 15581 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.041 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5110 | 5110 | 5109 | {"type": "Polygon", "coordinates": [[[-122.63003, 38.12056], [-122.62866, 38.12079], [-122.62849, 38.12084], [-122.62828, 38.12092], [-122.62813, 38.12103], [-122.62802, 38.12123], [-122.6279, 38.12139], [-122.62743, 38.12165], [-122.627, 38.12185], [-122.62683, 38.12198], [-122.62643, 38.12233], [-122.62629, 38.12242], [-122.62616, 38.12247], [-122.62604, 38.12249], [-122.62588, 38.12248], [-122.6258, 38.12246], [-122.62536, 38.12223], [-122.62512, 38.12214], [-122.62475, 38.1219], [-122.62457, 38.1218], [-122.62443, 38.12167], [-122.62422, 38.12142], [-122.6241, 38.12133], [-122.62393, 38.12126], [-122.62377, 38.12122], [-122.62357, 38.12121], [-122.62326, 38.12124], [-122.62301, 38.12122], [-122.62263, 38.12112], [-122.62248, 38.12112], [-122.62223, 38.12107], [-122.62203, 38.12096], [-122.6214, 38.12026], [-122.62113, 38.11978], [-122.62101, 38.1197], [-122.62085, 38.11968], [-122.62047, 38.11976], [-122.62027, 38.11977], [-122.61989, 38.11977], [-122.6198, 38.11972], [-122.61975, 38.11965], [-122.61965, 38.11941], [-122.61954, 38.11935], [-122.62072, 38.11659], [-122.62052, 38.11661], [-122.61976, 38.11657], [-122.6148, 38.11518], [-122.61336, 38.11466], [-122.61588, 38.11359], [-122.61582, 38.11322], [-122.61631, 38.11317], [-122.6163, 38.11298], [-122.61727, 38.11303], [-122.61904, 38.113], [-122.61906, 38.11268], [-122.61919, 38.11268], [-122.61919, 38.113], [-122.62004, 38.113], [-122.62035, 38.11302], [-122.62059, 38.11302], [-122.62092, 38.11298], [-122.62101, 38.11295], [-122.62083, 38.11264], [-122.62096, 38.11258], [-122.62115, 38.11289], [-122.62133, 38.11281], [-122.62175, 38.11271], [-122.62278, 38.11279], [-122.62313, 38.11275], [-122.62305, 38.11242], [-122.62312, 38.1124], [-122.62328, 38.11271], [-122.62354, 38.11263], [-122.62364, 38.11256], [-122.62383, 38.11239], [-122.62422, 38.11251], [-122.6245, 38.11258], [-122.62496, 38.11263], [-122.62498, 38.11228], [-122.62511, 38.11228], [-122.62511, 38.11264], [-122.62619, 38.11265], [-122.6262, 38.11229], [-122.62633, 38.11229], [-122.62634, 38.11264], [-122.62736, 38.11264], [-122.62776, 38.11287], [-122.6281, 38.11294], [-122.62843, 38.11287], [-122.62891, 38.11259], [-122.62897, 38.11254], [-122.62903, 38.11229], [-122.62911, 38.1123], [-122.62905, 38.11259], [-122.62908, 38.11261], [-122.62996, 38.1126], [-122.63003, 38.12056]]]} | Open Access 1 | 17396 | Little Mountain Open Space Preserve | 31441 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/depts/pk/divisions/open-space/little-mountain | Marin 23 | 239.312 | Little Mtn. OSP | 1995 | Local Conservation Area 4 | 2 |
5167 | 5167 | 5166 | {"type": "Polygon", "coordinates": [[[-119.05134, 34.21367], [-119.05046, 34.21364], [-119.05039, 34.21361], [-119.05038, 34.21356], [-119.05043, 34.21324], [-119.05057, 34.21284], [-119.05134, 34.21287], [-119.05134, 34.21367]]]} | Open Access 1 | 3782 | Carmenita Park | 16879 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 1.792 | Carmenita Park | 0 | Local Park 2 | 4 | |
5221 | 5221 | 5220 | {"type": "Polygon", "coordinates": [[[-121.98774, 37.69927], [-121.987, 37.69915], [-121.98436, 37.69881], [-121.98245, 37.69859], [-121.98161, 37.69845], [-121.98091, 37.69828], [-121.98042, 37.69813], [-121.97989, 37.69799], [-121.97915, 37.69786], [-121.97787, 37.69781], [-121.97662, 37.69763], [-121.97536, 37.69737], [-121.97291, 37.69698], [-121.97296, 37.6967], [-121.97308, 37.69667], [-121.97325, 37.69658], [-121.97334, 37.69638], [-121.97349, 37.69634], [-121.97353, 37.69606], [-121.97363, 37.69594], [-121.97374, 37.69576], [-121.97373, 37.69571], [-121.97376, 37.69562], [-121.97371, 37.69553], [-121.97377, 37.69509], [-121.97355, 37.69429], [-121.97839, 37.69432], [-121.97841, 37.69486], [-121.98072, 37.69488], [-121.98068, 37.69509], [-121.98129, 37.6962], [-121.98162, 37.69661], [-121.98198, 37.697], [-121.98199, 37.69713], [-121.98773, 37.69755], [-121.98774, 37.69927]]]} | Open Access 1 | 289 | Rowell Ranch Rodeo Park | 24705 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 83.074 | Rowell Ranch Rodeo Park | 0 | Local Park 2 | 4 | |
5223 | 5223 | 5222 | {"type": "Polygon", "coordinates": [[[-118.72434, 34.27437], [-118.72415, 34.27481], [-118.72395, 34.27536], [-118.72372, 34.27531], [-118.72189, 34.27531], [-118.72189, 34.27445], [-118.72156, 34.27444], [-118.72156, 34.27436], [-118.72161, 34.27433], [-118.7243, 34.27434], [-118.72433, 34.27435], [-118.72434, 34.27437]]]} | Open Access 1 | 763 | Sequoia Park | 25312 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.671 | Sequoia Park | 0 | Local Park 2 | 4 | |
5243 | 5243 | 5242 | {"type": "Polygon", "coordinates": [[[-118.87309, 34.18644], [-118.87297, 34.18708], [-118.87264, 34.18703], [-118.87276, 34.1864], [-118.87309, 34.18644]]]} | Open Access 1 | 15577 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.536 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5254 | 5254 | 5253 | {"type": "Polygon", "coordinates": [[[-119.07578, 34.22175], [-119.07584, 34.22177], [-119.07586, 34.22181], [-119.07586, 34.2234], [-119.0758, 34.22343], [-119.0747, 34.22344], [-119.07468, 34.22175], [-119.07578, 34.22175]]]} | Open Access 1 | 48373 | Mel Vincent Park | 32939 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/parks/park_list/mel_vincent_park.asp | Ventura 8 | 4.981 | Mel Vincent Park | 2017 | Local Park 2 | 4 |
5257 | 5257 | 5256 | {"type": "Polygon", "coordinates": [[[-117.13403, 33.61701], [-117.13395, 33.61707], [-117.13333, 33.617], [-117.13282, 33.61699], [-117.13274, 33.61693], [-117.13274, 33.61667], [-117.13278, 33.6165], [-117.13278, 33.61645], [-117.13273, 33.61639], [-117.13265, 33.61637], [-117.13264, 33.61635], [-117.13261, 33.61635], [-117.1325, 33.61602], [-117.13258, 33.616], [-117.13263, 33.61592], [-117.13259, 33.61572], [-117.13259, 33.61544], [-117.13266, 33.61539], [-117.13289, 33.61536], [-117.13311, 33.61532], [-117.13381, 33.61508], [-117.13391, 33.61513], [-117.13398, 33.61534], [-117.13402, 33.61557], [-117.13403, 33.61701]]]} | Open Access 1 | 48382 | Mahogany Meadows Park | 32946 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://github.com/GreenInfo-Network/cpad/issues/37 | Riverside 10 | 6.166 | Mahogany Meadows Park | 0 | Local Park 2 | 4 |
5258 | 5258 | 5257 | {"type": "Polygon", "coordinates": [[[-117.1093, 33.59153], [-117.1089, 33.59184], [-117.10882, 33.59184], [-117.10882, 33.59154], [-117.10915, 33.59157], [-117.10922, 33.59155], [-117.10929, 33.59152], [-117.1093, 33.59153]]]} | Open Access 1 | 48383 | Pompei Pocket Park | 32947 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/pompei-pocket-park | Riverside 10 | 0.197 | Pompei PP | 0 | Local Park 2 | 4 | |
5283 | 5283 | 5282 | {"type": "Polygon", "coordinates": [[[-117.12889, 33.61282], [-117.12851, 33.61291], [-117.12886, 33.61428], [-117.12859, 33.61432], [-117.12851, 33.61411], [-117.12842, 33.61354], [-117.1283, 33.61315], [-117.1283, 33.61293], [-117.12828, 33.61271], [-117.12798, 33.6127], [-117.128, 33.61263], [-117.12799, 33.61259], [-117.12794, 33.61253], [-117.12789, 33.61251], [-117.1278, 33.61251], [-117.12774, 33.61254], [-117.12769, 33.61249], [-117.12733, 33.61255], [-117.12733, 33.61251], [-117.12788, 33.61241], [-117.12845, 33.61224], [-117.12854, 33.61226], [-117.12889, 33.61282]]]} | Open Access 1 | 48401 | Linear Workout Park | 32968 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 2.073 | Linear Workout Park | 0 | Local Park 2 | 4 | |
5287 | 5287 | 5286 | {"type": "Polygon", "coordinates": [[[-122.05946, 37.69439], [-122.05885, 37.69507], [-122.05883, 37.69556], [-122.05837, 37.69604], [-122.0583, 37.69656], [-122.05816, 37.69676], [-122.05724, 37.69663], [-122.0572, 37.69677], [-122.05723, 37.69694], [-122.05723, 37.69719], [-122.05716, 37.69742], [-122.05696, 37.69785], [-122.0571, 37.69796], [-122.05793, 37.698], [-122.05779, 37.69844], [-122.05769, 37.69896], [-122.05722, 37.6991], [-122.0572, 37.69932], [-122.05738, 37.6997], [-122.05682, 37.69978], [-122.0567, 37.70057], [-122.05573, 37.70103], [-122.05575, 37.70138], [-122.05386, 37.70191], [-122.0541, 37.70148], [-122.05419, 37.70111], [-122.05497, 37.70103], [-122.05533, 37.70088], [-122.05541, 37.70078], [-122.05512, 37.7002], [-122.05508, 37.69964], [-122.05485, 37.69902], [-122.05494, 37.69854], [-122.05526, 37.69825], [-122.05619, 37.69811], [-122.05662, 37.69776], [-122.05681, 37.69721], [-122.05677, 37.69689], [-122.05636, 37.69651], [-122.05587, 37.69632], [-122.05596, 37.69539], [-122.05657, 37.69468], [-122.05841, 37.69457], [-122.05946, 37.69439]]]} | Open Access 1 | 15159 | Earl Warren Park | 18355 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 31.448 | Earl Warren Park | 0 | Local Park 2 | 4 | |
5289 | 5289 | 5288 | {"type": "Polygon", "coordinates": [[[-122.09801, 37.95417], [-122.09793, 37.95431], [-122.09779, 37.95437], [-122.0975, 37.95437], [-122.09697, 37.95431], [-122.09675, 37.95434], [-122.0967, 37.95451], [-122.0958, 37.95456], [-122.09576, 37.95409], [-122.09611, 37.9541], [-122.09648, 37.95405], [-122.09776, 37.95382], [-122.0979, 37.95384], [-122.098, 37.95403], [-122.09801, 37.95417]]]} | Open Access 1 | 15139 | Shannon Hills Park | 25358 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 2.405 | Shannon Hills Park | 0 | Local Park 2 | 4 | |
5291 | 5291 | 5290 | {"type": "Polygon", "coordinates": [[[-122.0789, 37.9493], [-122.07888, 37.9497], [-122.07834, 37.94968], [-122.07834, 37.94934], [-122.07844, 37.94935], [-122.0785, 37.94932], [-122.07854, 37.94929], [-122.0789, 37.9493]]]} | Open Access 1 | 15142 | Pinewood Park | 23695 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.501 | Pinewood Park | 0 | Local Park 2 | 4 | |
5292 | 5292 | 5291 | {"type": "Polygon", "coordinates": [[[-122.07585, 37.95631], [-122.07582, 37.96109], [-122.07561, 37.9611], [-122.07477, 37.95927], [-122.07458, 37.95916], [-122.07418, 37.95897], [-122.07407, 37.95887], [-122.07404, 37.95874], [-122.0741, 37.95856], [-122.0742, 37.95845], [-122.07494, 37.95802], [-122.07566, 37.95736], [-122.07566, 37.95724], [-122.07549, 37.95674], [-122.07554, 37.95661], [-122.07585, 37.95631]]]} | Open Access 1 | 15144 | Las Juntas Park | 21055 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 8.74 | Las Juntas Park | 0 | Local Park 2 | 4 | |
5293 | 5293 | 5292 | {"type": "Polygon", "coordinates": [[[-122.06741, 37.97231], [-122.06681, 37.97235], [-122.06681, 37.97255], [-122.06594, 37.97257], [-122.06679, 37.97165], [-122.0674, 37.97163], [-122.06741, 37.97231]]]} | Open Access 1 | 15147 | Chilpancingo Park | 17201 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1.966 | Chilpancingo Park | 0 | Local Park 2 | 4 | |
5305 | 5305 | 5304 | {"type": "Polygon", "coordinates": [[[-116.99153, 33.94716], [-116.98809, 33.95221], [-116.98774, 33.95265], [-116.98754, 33.95289], [-116.98684, 33.95363], [-116.98442, 33.94713], [-116.99153, 33.94716]]]} | Open Access 1 | 5781 | Noble Creek Park | 22776 | 2205 | Beaumont-Cherry Valley Recreation and Park District 646 | Special District 4 | Recreation/Parks District 4 | http://www.bcvparks.com/ | Special District 4 | 2205 | Beaumont-Cherry Valley Recreation and Park District 636 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 60.311 | Noble Creek Park | 0 | Local Park 2 | 4 | |
5316 | 5316 | 5315 | {"type": "Polygon", "coordinates": [[[-120.10648, 36.2016], [-120.10497, 36.20223], [-120.10374, 36.1999], [-120.10522, 36.19929], [-120.10648, 36.2016]]]} | Open Access 1 | 5578 | Keenan Park | 20571 | 2021 | Coalinga-Huron Recreation and Park District 275 | Special District 4 | Recreation/Parks District 4 | http://www.chrpd.org/ | Special District 4 | 2021 | Coalinga-Huron Recreation and Park District 270 | Special District 4 | Recreation/Parks District 4 | Fresno 9 | 10.458 | Keenan Park | 0 | Local Park 2 | 4 | |
5344 | 5344 | 5343 | {"type": "Polygon", "coordinates": [[[-119.0427, 34.22709], [-119.04183, 34.2271], [-119.04183, 34.22684], [-119.04176, 34.22677], [-119.04181, 34.22671], [-119.04183, 34.22664], [-119.04181, 34.22643], [-119.04185, 34.22641], [-119.04264, 34.2264], [-119.04267, 34.22641], [-119.04269, 34.22646], [-119.0427, 34.22709]]]} | Open Access 1 | 17313 | Laurelwood Park - PVRPD | 21108 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 1.519 | Laurelwood Park - PVRPD | None 435 |
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]);