units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
899 rows where GAP_STS = 4 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER
MNG_AGENCY >30
- East Bay Regional Park District 105
- Hayward Area Recreation and Park District 83
- Valley-Wide Recreation and Park District 66
- Rancho Simi Recreation and Park District 54
- Conejo Recreation and Park District 40
- Southgate Recreation and Park District 39
- Cordova Recreation and Park District 37
- Sunrise Recreation and Park District 37
- Greater Vallejo Recreation and Park District 30
- Pleasant Valley Recreation and Park District 28
- North of the River Recreation and Park District 27
- Isla Vista Recreation and Park District 18
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 14
- Mission Oaks Recreation and Park District 14
- Monterey Peninsula Regional Park District 13
- Apple Valley Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- Hesperia Recreation and Park District 11
- Carmichael Recreation and Park District 11
- North Highland Recreation and Park District 11
- Miraleste Recreation and Park District 9
- Fair Oaks Recreation and Park District 9
- Livermore Area Recreation and Park District 8
- Rio Linda Elverta Recreation and Park District 8
- Tuolumne Park and Recreation District 8
- La Selva Beach Recreation District 8
- Feather River Recreation and Park District 7
- Big Bear Valley Recreation and Park District 7
- …
DES_TP 4
ACCESS_TYP 3
- Open Access 832
- No Public Access 35
- Restricted Access 32
MNG_AG_TYP 1
- Recreation/Parks District · 899 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18 | 18 | 17 | {"type": "Polygon", "coordinates": [[[-118.95325, 34.18233], [-118.94954, 34.18265], [-118.94921, 34.18001], [-118.94982, 34.17958], [-118.95014, 34.17942], [-118.95045, 34.17932], [-118.95086, 34.17926], [-118.95165, 34.17922], [-118.9523, 34.17926], [-118.95325, 34.18233]]]} | Open Access 1 | 58 | Borchard Park | 16277 | 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 | 27.263 | Borchard Park | 0 | Local Park 2 | 4 | |
112 | 112 | 111 | {"type": "MultiPolygon", "coordinates": [[[[-121.89676, 36.61064], [-121.89648, 36.61079], [-121.89639, 36.61069], [-121.8964, 36.61049], [-121.89638, 36.61044], [-121.89628, 36.61029], [-121.89611, 36.6101], [-121.89602, 36.61002], [-121.89595, 36.61], [-121.8958, 36.61], [-121.89572, 36.60995], [-121.8956, 36.60978], [-121.89551, 36.6097], [-121.89543, 36.60948], [-121.89573, 36.60943], [-121.89676, 36.61064]]], [[[-121.89709, 36.61029], [-121.89683, 36.61043], [-121.89595, 36.60939], [-121.89629, 36.60934], [-121.89709, 36.61029]]]]} | Open Access 1 | 327 | San Carlos Beach Park | 24846 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.92 | San Carlos Beach Park | 0 | Local Park 2 | 4 | |
195 | 195 | 194 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | 569 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 9.887 | Foglesong Park/Eda Henderson Pool | 0 | Local Recreation Area 3 | 4 | ||
197 | 197 | 196 | {"type": "Polygon", "coordinates": [[[-118.66428, 34.25904], [-118.66428, 34.26108], [-118.66395, 34.26099], [-118.66351, 34.2609], [-118.66306, 34.26083], [-118.66261, 34.26078], [-118.66216, 34.26077], [-118.66178, 34.26077], [-118.66094, 34.26084], [-118.66094, 34.25904], [-118.66428, 34.25904]]]} | Open Access 1 | 615 | Santa Susana Park | 25139 | 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 | 15.254 | Santa Susana Park | 0 | Local Park 2 | 4 | |
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
303 | 303 | 302 | {"type": "Polygon", "coordinates": [[[-118.87425, 34.22586], [-118.87258, 34.2261], [-118.87258, 34.22433], [-118.87408, 34.22434], [-118.87409, 34.22539], [-118.87418, 34.22551], [-118.87425, 34.22586]]]} | Open Access 1 | 1040 | Spring Meadow Park | 25741 | 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 | 6.467 | Spring Meadow Park | 0 | Local Park 2 | 4 | |
358 | 358 | 357 | {"type": "Polygon", "coordinates": [[[-118.84164, 34.14351], [-118.84162, 34.14361], [-118.84153, 34.1437], [-118.84153, 34.14379], [-118.84163, 34.14385], [-118.84147, 34.14417], [-118.84155, 34.14456], [-118.8412, 34.14464], [-118.84027, 34.14465], [-118.83984, 34.1442], [-118.83987, 34.14412], [-118.84004, 34.14402], [-118.84058, 34.14361], [-118.84113, 34.14306], [-118.84128, 34.14315], [-118.84155, 34.14336], [-118.84164, 34.14351]]]} | Open Access 1 | 1009 | Southshore Hills Park | 25696 | 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 | 4.475 | Southshore Hills Park | 0 | Local Park 2 | 4 | |
365 | 365 | 364 | {"type": "MultiPolygon", "coordinates": [[[[-119.08732, 34.22541], [-119.08716, 34.2256], [-119.08697, 34.22573], [-119.08674, 34.22581], [-119.08637, 34.22589], [-119.08621, 34.22533], [-119.08622, 34.22508], [-119.08664, 34.22498], [-119.08731, 34.22537], [-119.08732, 34.22541]]], [[[-119.08846, 34.22607], [-119.08817, 34.22634], [-119.0866, 34.22666], [-119.08642, 34.22605], [-119.08683, 34.22596], [-119.08707, 34.22587], [-119.08725, 34.22575], [-119.08748, 34.22552], [-119.08752, 34.22551], [-119.08846, 34.22607]]]]} | Open Access 1 | 1045 | Springville Park | 25752 | 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 | 4.87 | Springville Park | 0 | Local Park 2 | 4 | |
368 | 368 | 367 | {"type": "Polygon", "coordinates": [[[-118.91305, 34.18088], [-118.91256, 34.18067], [-118.912, 34.18037], [-118.91123, 34.18041], [-118.91136, 34.17666], [-118.91295, 34.17687], [-118.91305, 34.18088]]]} | Open Access 1 | 1056 | Stagecoach Inn Park | 25777 | 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 | 16.214 | Stagecoach Inn Park | 0 | Local Park 2 | 4 | |
385 | 385 | 384 | {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} | Open Access 1 | 48338 | Lago Vista Sports Park | 32901 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/lago-vista-sports-park | Riverside 10 | 28.451 | Lago Vista Sports Park | 0 | Local Recreation Area 3 | 4 |
389 | 389 | 388 | {"type": "Polygon", "coordinates": [[[-118.80196, 34.27578], [-118.801, 34.27578], [-118.80023, 34.27408], [-118.80034, 34.2741], [-118.80041, 34.27419], [-118.80046, 34.27422], [-118.80057, 34.27424], [-118.80064, 34.27422], [-118.80071, 34.27418], [-118.80074, 34.27413], [-118.80076, 34.27408], [-118.80183, 34.27407], [-118.80196, 34.27578]]]} | Open Access 1 | 1158 | Strathearn Historical Park & Museum | 25908 | 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.386 | Strathearn Historical Park & Museum | 0 | Local Historic or Cultural Area 19 | 4 | |
447 | 447 | 446 | {"type": "Polygon", "coordinates": [[[-119.86022, 34.41121], [-119.86022, 34.41162], [-119.85989, 34.41162], [-119.85989, 34.41121], [-119.86022, 34.41121]]]} | Open Access 1 | 1418 | Trigo Pasado Park | 26535 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.344 | Trigo Pasado Park | 0 | Local Park 2 | 4 | |
450 | 450 | 449 | {"type": "Polygon", "coordinates": [[[-118.84969, 34.15691], [-118.84861, 34.15729], [-118.8484, 34.15705], [-118.84823, 34.15692], [-118.8481, 34.15686], [-118.84745, 34.15669], [-118.8474, 34.15675], [-118.84724, 34.15671], [-118.84701, 34.15669], [-118.84647, 34.15673], [-118.84613, 34.15674], [-118.84609, 34.15669], [-118.84529, 34.15636], [-118.84513, 34.15634], [-118.84475, 34.15615], [-118.84455, 34.15601], [-118.84392, 34.15522], [-118.84377, 34.15509], [-118.84351, 34.15491], [-118.84278, 34.1546], [-118.84282, 34.15435], [-118.84282, 34.15411], [-118.84286, 34.15404], [-118.84303, 34.154], [-118.84331, 34.15383], [-118.84351, 34.15362], [-118.84361, 34.1534], [-118.8436, 34.15311], [-118.84357, 34.15296], [-118.84413, 34.15317], [-118.84731, 34.15444], [-118.84968, 34.15512], [-118.84969, 34.15691]]]} | Open Access 1 | 1427 | Triunfo Park | 7237 | 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 | http://www.lamountains.com/parks.asp?parkid=62 | Ventura 8 | 38.958 | Triunfo Park | 0 | Local Park 2 | 4 |
484 | 484 | 483 | {"type": "Polygon", "coordinates": [[[-119.86222, 34.40916], [-119.86222, 34.40971], [-119.86197, 34.40971], [-119.86197, 34.40918], [-119.86222, 34.40916]]]} | Open Access 1 | 1943 | Window to the Sea Park | 27630 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.344 | Window to the Sea Park | 0 | Local Park 2 | 4 | |
487 | 487 | 486 | {"type": "Polygon", "coordinates": [[[-119.05827, 34.22788], [-119.05689, 34.22789], [-119.05662, 34.22786], [-119.05661, 34.22533], [-119.05785, 34.22532], [-119.05785, 34.22557], [-119.05784, 34.22566], [-119.05788, 34.22578], [-119.05795, 34.22584], [-119.05803, 34.22588], [-119.05815, 34.2259], [-119.05826, 34.22588], [-119.05827, 34.22788]]]} | Open Access 1 | 1684 | Valle Lindo Park | 26770 | 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 | 10.069 | Valle Lindo Park | 0 | Local Park 2 | 4 | |
491 | 491 | 490 | {"type": "Polygon", "coordinates": [[[-119.00089, 34.23254], [-119.0007, 34.23357], [-118.99913, 34.23337], [-118.99889, 34.23332], [-118.99884, 34.23328], [-118.99892, 34.23277], [-118.99894, 34.23232], [-119.00089, 34.23254]]]} | Open Access 1 | 1963 | Woodcreek Park | 27704 | 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 | 4.956 | Woodcreek Park | 0 | Local Park 2 | 4 | |
503 | 503 | 502 | {"type": "Polygon", "coordinates": [[[-118.97368, 34.20139], [-118.97368, 34.20163], [-118.97362, 34.20181], [-118.97355, 34.20201], [-118.97325, 34.20261], [-118.9732, 34.20278], [-118.97311, 34.20316], [-118.97299, 34.20341], [-118.97275, 34.20377], [-118.97187, 34.20442], [-118.97113, 34.20556], [-118.96893, 34.20529], [-118.97135, 34.20156], [-118.97201, 34.20157], [-118.97264, 34.20153], [-118.97368, 34.20139]]]} | Open Access 1 | 48367 | Camarillo Grove Park | 32933 | 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/camarillo_grove_park.asp | Ventura 8 | 25.264 | Camarillo Grove Park | 0 | Local Park 2 | 4 |
515 | 515 | 514 | {"type": "Polygon", "coordinates": [[[-118.67368, 34.2754], [-118.67345, 34.2754], [-118.67293, 34.27548], [-118.67292, 34.27601], [-118.67213, 34.2753], [-118.67207, 34.27515], [-118.67207, 34.27372], [-118.67302, 34.27372], [-118.67356, 34.27375], [-118.67356, 34.27402], [-118.67368, 34.27412], [-118.67368, 34.2754]]]} | Open Access 1 | 1716 | Verde Park | 26986 | 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 | 7.268 | Verde Park | 0 | Local Park 2 | 4 | |
532 | 532 | 531 | {"type": "Polygon", "coordinates": [[[-118.90336, 34.18406], [-118.90262, 34.18413], [-118.8993, 34.1842], [-118.89928, 34.18407], [-118.89887, 34.18356], [-118.89889, 34.18303], [-118.89872, 34.18292], [-118.89961, 34.18202], [-118.8998, 34.18225], [-118.90006, 34.18231], [-118.90027, 34.18246], [-118.90028, 34.18262], [-118.90087, 34.18263], [-118.90133, 34.18247], [-118.9018, 34.18266], [-118.9019, 34.18329], [-118.90208, 34.18388], [-118.90268, 34.18407], [-118.90324, 34.18397], [-118.90324, 34.18342], [-118.90333, 34.18327], [-118.90336, 34.18406]]]} | Open Access 1 | 1797 | Walnut Grove Equestrian Center | 27229 | 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 | 13.391 | Walnut Grove Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-118.8993, 34.1842], [-118.89897, 34.18424], [-118.89814, 34.18437], [-118.89767, 34.18434], [-118.89715, 34.18448], [-118.89638, 34.18443], [-118.89611, 34.18408], [-118.89593, 34.18404], [-118.89683, 34.18341], [-118.8969, 34.18346], [-118.89768, 34.18368], [-118.89819, 34.18346], [-118.89872, 34.18292], [-118.89889, 34.18303], [-118.89887, 34.18356], [-118.8993, 34.1842]]]} | Open Access 1 | 1801 | Walnut Grove Park | 27233 | 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 | 6.623 | Walnut Grove 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]);