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 158
- Hayward Area Recreation and Park District 68
- Valley-Wide Recreation and Park District 64
- Midpeninsula Regional Open Space District 50
- Rancho Simi Recreation and Park District 40
- Southgate Recreation and Park District 40
- Sunrise Recreation and Park District 39
- Marin County Open Space District 36
- Cordova Recreation and Park District 35
- Conejo Recreation and Park District 30
- Greater Vallejo Recreation and Park District 24
- Santa Clara Valley Open Space Authority 24
- Monterey Peninsula Regional Park District 23
- North of the River Recreation and Park District 22
- Pleasant Valley Recreation and Park District 20
- Sonoma County Agricultural Preservation and Open Space District 19
- Jurupa Area Recreation and Park District 14
- Isla Vista Recreation and Park District 13
- Mission Oaks Recreation and Park District 13
- Carmichael Recreation and Park District 12
- North Highland Recreation and Park District 11
- Apple Valley Recreation and Park District 10
- Livermore Area Recreation and Park District 10
- Auburn Area Recreation and Park District 10
- Pleasant Hill Recreation and Park District 10
- Hesperia Recreation and Park District 10
- Miraleste Recreation and Park District 10
- Tuolumne Park and Recreation District 9
- Orangevale Recreation and Park District 9
- Fair Oaks Recreation and Park District 9
- …
DES_TP >30
- Local Park 589
- Local Conservation Area 163
- Local Recreation Area 146
- Local Other or Unknown 26
- 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 4
- Open Access 840
- No Public Access 102
- Restricted Access 60
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,003 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436 | 3436 | 3435 | {"type": "Polygon", "coordinates": [[[-121.076, 38.88682], [-121.07557, 38.88683], [-121.07504, 38.88688], [-121.07451, 38.88696], [-121.07409, 38.88705], [-121.07249, 38.88759], [-121.07175, 38.88795], [-121.07161, 38.8875], [-121.07166, 38.88748], [-121.07166, 38.88711], [-121.07176, 38.88677], [-121.07185, 38.88667], [-121.07219, 38.88647], [-121.07232, 38.88631], [-121.07265, 38.88601], [-121.07292, 38.88593], [-121.07309, 38.88592], [-121.07325, 38.88593], [-121.0738, 38.88606], [-121.07413, 38.8861], [-121.07443, 38.88607], [-121.07496, 38.88595], [-121.07513, 38.88597], [-121.07535, 38.88594], [-121.07538, 38.88637], [-121.07595, 38.88636], [-121.076, 38.88682]]]} | Open Access 1 | 48745 | Railhead Park | 33471 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_railhead.php | Placer 35 | 10.958 | Railhead Park | 0 | Local Park 2 | 4 |
3460 | 3460 | 3459 | {"type": "Polygon", "coordinates": [[[-119.08491, 35.40132], [-119.08461, 35.40134], [-119.08421, 35.40131], [-119.08354, 35.40131], [-119.08346, 35.40125], [-119.08344, 35.39843], [-119.08349, 35.39838], [-119.08459, 35.39842], [-119.08461, 35.39892], [-119.08458, 35.39901], [-119.08458, 35.39909], [-119.08463, 35.39919], [-119.08475, 35.39924], [-119.08485, 35.39927], [-119.0849, 35.39975], [-119.08491, 35.40132]]]} | Open Access 1 | 25362 | Emerald Cove Park | 18613 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 9.921 | Emerald Cove Park | 0 | Local Park 2 | 4 | |
3472 | 3472 | 3471 | {"type": "Polygon", "coordinates": [[[-116.97601, 33.97243], [-116.97466, 33.97406], [-116.97417, 33.97481], [-116.97355, 33.97529], [-116.97366, 33.97499], [-116.97373, 33.97474], [-116.97393, 33.97458], [-116.9744, 33.97369], [-116.97556, 33.97245], [-116.97558, 33.97244], [-116.97601, 33.97243]]]} | Open Access 1 | 25787 | Edgar Canyon Nature Park | 18432 | 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 | 3.121 | Edgar Canyon Nature Park | 0 | Local Park 2 | 4 | |
3473 | 3473 | 3472 | {"type": "Polygon", "coordinates": [[[-119.03006, 35.43544], [-119.03004, 35.43691], [-119.02772, 35.4369], [-119.02772, 35.43538], [-119.02999, 35.43538], [-119.03006, 35.43544]]]} | Open Access 1 | 25789 | North Meadows Park | 22830 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 8.835 | North Meadows Park | 0 | Local Park 2 | 4 | |
3476 | 3476 | 3475 | {"type": "Polygon", "coordinates": [[[-117.25211, 34.38399], [-117.25224, 34.38434], [-117.25234, 34.38472], [-117.25239, 34.38511], [-117.25239, 34.3855], [-117.25228, 34.38688], [-117.25223, 34.38719], [-117.25212, 34.38763], [-117.25199, 34.38794], [-117.25184, 34.38824], [-117.25142, 34.38807], [-117.24954, 34.38869], [-117.24644, 34.39464], [-117.24169, 34.39943], [-117.24162, 34.3841], [-117.24424, 34.38408], [-117.24545, 34.38678], [-117.24656, 34.38679], [-117.24659, 34.38405], [-117.25211, 34.38399]], [[-117.25042, 34.38594], [-117.25031, 34.3856], [-117.25044, 34.38525], [-117.25031, 34.38489], [-117.25022, 34.38483], [-117.25013, 34.38488], [-117.24976, 34.38526], [-117.24965, 34.38562], [-117.24962, 34.38637], [-117.24954, 34.38656], [-117.24936, 34.38667], [-117.24939, 34.38712], [-117.24911, 34.38728], [-117.24916, 34.38799], [-117.24921, 34.38814], [-117.24928, 34.38819], [-117.24962, 34.38824], [-117.2506, 34.38776], [-117.25149, 34.38713], [-117.25156, 34.38696], [-117.25157, 34.3868], [-117.25062, 34.386], [-117.25042, 34.38594]]]} | Open Access 1 | 25798 | Hesperia Lake Park | 4453 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/hesperia-lake-park/ | San Bernardino 22 | 223.101 | Hesperia Lake Park | 0 | Local Park 2 | 4 |
3486 | 3486 | 3485 | {"type": "Polygon", "coordinates": [[[-122.04254, 37.69324], [-122.04258, 37.69353], [-122.04254, 37.69359], [-122.04245, 37.69363], [-122.04168, 37.69356], [-122.04021, 37.69367], [-122.04031, 37.69501], [-122.0398, 37.6962], [-122.03857, 37.69573], [-122.03373, 37.69642], [-122.03244, 37.69557], [-122.0294, 37.69336], [-122.02923, 37.6932], [-122.02911, 37.69298], [-122.02965, 37.69307], [-122.03009, 37.6934], [-122.03051, 37.69331], [-122.03084, 37.69344], [-122.03097, 37.69365], [-122.03108, 37.69367], [-122.03129, 37.69369], [-122.03163, 37.69355], [-122.03186, 37.69322], [-122.03235, 37.69309], [-122.03281, 37.69308], [-122.03302, 37.69322], [-122.03334, 37.69316], [-122.03333, 37.69293], [-122.03356, 37.69289], [-122.03402, 37.69255], [-122.03407, 37.69237], [-122.03435, 37.69371], [-122.04, 37.69298], [-122.04254, 37.69324]]]} | No Public Access 3 | 46879 | Chabot - Garin Trail Corridor | 30360 | 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 | 63.522 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
3497 | 3497 | 3496 | {"type": "Polygon", "coordinates": [[[-121.28691, 38.57521], [-121.28655, 38.57524], [-121.28655, 38.57552], [-121.2865, 38.57556], [-121.28649, 38.57561], [-121.28641, 38.57562], [-121.28641, 38.57596], [-121.28637, 38.57601], [-121.28626, 38.57596], [-121.28579, 38.5756], [-121.2855, 38.57543], [-121.28552, 38.57532], [-121.28571, 38.57498], [-121.28582, 38.57472], [-121.28589, 38.57448], [-121.28599, 38.57405], [-121.28601, 38.57401], [-121.28606, 38.57398], [-121.28679, 38.57398], [-121.28691, 38.57521]]]} | Open Access 1 | 25941 | Sonoma Park | 25617 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.233 | Sonoma Park | 0 | Local Park 2 | 4 | |
3500 | 3500 | 3499 | {"type": "Polygon", "coordinates": [[[-121.30119, 38.67445], [-121.30091, 38.67484], [-121.30047, 38.67468], [-121.30035, 38.67441], [-121.29992, 38.67421], [-121.2994, 38.67448], [-121.2988, 38.67434], [-121.29862, 38.67432], [-121.29865, 38.67415], [-121.29816, 38.6737], [-121.29776, 38.67344], [-121.29772, 38.67344], [-121.29767, 38.67337], [-121.29756, 38.67331], [-121.29688, 38.67257], [-121.29668, 38.67246], [-121.29633, 38.67237], [-121.29631, 38.67233], [-121.2963, 38.67214], [-121.29687, 38.67227], [-121.29722, 38.67242], [-121.29767, 38.67288], [-121.29844, 38.67353], [-121.29879, 38.67377], [-121.2998, 38.67379], [-121.30011, 38.67385], [-121.30119, 38.67445]]]} | Open Access 1 | 36016 | Cherry Creek Park | 17168 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.473 | Cherry Creek Park | 0 | Local Park 2 | 4 | |
3502 | 3502 | 3501 | {"type": "MultiPolygon", "coordinates": [[[[-121.38155, 38.45546], [-121.38133, 38.45552], [-121.38115, 38.45563], [-121.38102, 38.45578], [-121.38096, 38.45595], [-121.38097, 38.45515], [-121.38053, 38.45511], [-121.38059, 38.45505], [-121.3806, 38.45497], [-121.38057, 38.45493], [-121.38053, 38.45491], [-121.38047, 38.4549], [-121.38041, 38.4549], [-121.38041, 38.45474], [-121.38085, 38.45497], [-121.38115, 38.45506], [-121.3814, 38.45506], [-121.38155, 38.45546]]], [[[-121.38319, 38.45988], [-121.38277, 38.45988], [-121.38264, 38.4596], [-121.38272, 38.45954], [-121.38274, 38.45948], [-121.3827, 38.45937], [-121.3827, 38.45913], [-121.38268, 38.45901], [-121.38261, 38.45886], [-121.38245, 38.45861], [-121.38238, 38.45845], [-121.38224, 38.45784], [-121.38214, 38.45762], [-121.38195, 38.4573], [-121.38188, 38.45714], [-121.38182, 38.45694], [-121.38176, 38.45661], [-121.38171, 38.45649], [-121.38156, 38.45622], [-121.38155, 38.45617], [-121.38155, 38.4561], [-121.38154, 38.45606], [-121.38149, 38.45601], [-121.3814, 38.456], [-121.38131, 38.45603], [-121.38128, 38.45611], [-121.38109, 38.45611], [-121.38109, 38.45594], [-121.38113, 38.45583], [-121.38123, 38.4557], [-121.38135, 38.45562], [-121.38148, 38.45558], [-121.38159, 38.45557], [-121.38319, 38.45988]]]]} | Open Access 1 | 36025 | Danbury Parkway | 17917 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.905 | Danbury Parkway | 0 | Local Recreation Area 3 | 4 | |
3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | 15364 | Brooks Island Regional Preserve | 31524 | 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 | Contra Costa 12 | 3.177 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
3578 | 3578 | 3577 | {"type": "Polygon", "coordinates": [[[-122.50669, 37.8972], [-122.50645, 37.89864], [-122.50643, 37.89867], [-122.50639, 37.89869], [-122.50539, 37.89873], [-122.50513, 37.89873], [-122.50539, 37.89714], [-122.50534, 37.8971], [-122.50546, 37.89701], [-122.50553, 37.89707], [-122.50669, 37.8972]]]} | Open Access 1 | 29130 | Strawberry Park | 25917 | 2162 | Strawberry Recreation District 662 | Special District 4 | Recreation/Parks District 4 | http://strawberry.marin.org/ | Special District 4 | 2162 | Strawberry Recreation District 650 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 5.012 | Strawberry Park | 0 | Local Park 2 | 4 | |
3610 | 3610 | 3609 | {"type": "Polygon", "coordinates": [[[-122.14555, 37.66548], [-122.14449, 37.66584], [-122.14439, 37.66644], [-122.14233, 37.66724], [-122.14201, 37.66706], [-122.14184, 37.66295], [-122.14345, 37.66316], [-122.14555, 37.66548]]]} | Open Access 1 | 441 | San Lorenzo Community Park | 24925 | 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 | 23.787 | San Lorenzo Community Park | 0 | Local Park 2 | 4 | |
3615 | 3615 | 3614 | {"type": "Polygon", "coordinates": [[[-119.03777, 34.21545], [-119.03764, 34.21629], [-119.037, 34.21622], [-119.03713, 34.21538], [-119.03777, 34.21545]]]} | Open Access 1 | 13517 | Dizdar Park | 18174 | 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.381 | Dizdar Park | 0 | Local Park 2 | 4 | |
3617 | 3617 | 3616 | {"type": "Polygon", "coordinates": [[[-122.74565, 38.48914], [-122.74561, 38.49073], [-122.74474, 38.49073], [-122.74477, 38.48913], [-122.74565, 38.48914]]]} | Restricted Access 2 | 29390 | Dogbane Preserve | 18185 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 3.337 | Dogbane Preserve | 1997 | Local Conservation Area 4 | 2 | |
3618 | 3618 | 3617 | {"type": "Polygon", "coordinates": [[[-122.86656, 38.63964], [-122.86596, 38.63964], [-122.86647, 38.64012], [-122.86574, 38.6404], [-122.86547, 38.64047], [-122.86505, 38.64053], [-122.86448, 38.64051], [-122.86448, 38.64019], [-122.86476, 38.64017], [-122.86473, 38.63964], [-122.86467, 38.63963], [-122.86468, 38.63867], [-122.86087, 38.63871], [-122.86085, 38.64085], [-122.86055, 38.64103], [-122.86021, 38.64133], [-122.85973, 38.64155], [-122.85936, 38.64175], [-122.85896, 38.64201], [-122.85847, 38.64237], [-122.85417, 38.6424], [-122.85423, 38.63869], [-122.8542, 38.6379], [-122.85419, 38.63504], [-122.86329, 38.63498], [-122.86458, 38.63659], [-122.86456, 38.63763], [-122.86619, 38.63767], [-122.86652, 38.63788], [-122.86656, 38.63964]]]} | Open Access 1 | 29389 | Healdsburg Ridge Open Space Preserve | 19773 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 155.058 | Healdsburg Ridge OSP | 0 | Local Conservation Area 4 | 2 | |
3621 | 3621 | 3620 | {"type": "Polygon", "coordinates": [[[-122.13468, 38.02843], [-122.13427, 38.02977], [-122.13074, 38.03157], [-122.13026, 38.02906], [-122.13025, 38.02905], [-122.12946, 38.02945], [-122.12902, 38.02716], [-122.12945, 38.02692], [-122.13129, 38.02602], [-122.13153, 38.02637], [-122.13293, 38.02824], [-122.13468, 38.02843]]]} | Open Access 1 | 29404 | Martinez Regional Shoreline | 21926 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 38.97 | Martinez Reg. Shoreline | 1979 | Local Park 2 | 4 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 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 | Contra Costa 12 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
3665 | 3665 | 3664 | {"type": "Polygon", "coordinates": [[[-121.3432, 38.60453], [-121.34288, 38.60452], [-121.34282, 38.6045], [-121.3427, 38.6041], [-121.34268, 38.60395], [-121.34268, 38.60346], [-121.3427, 38.60341], [-121.34276, 38.60333], [-121.34276, 38.60327], [-121.34272, 38.60322], [-121.34266, 38.60319], [-121.34259, 38.6032], [-121.34252, 38.60323], [-121.34208, 38.60299], [-121.34208, 38.60274], [-121.34313, 38.60275], [-121.34323, 38.6032], [-121.34328, 38.60362], [-121.34327, 38.60448], [-121.34325, 38.60451], [-121.3432, 38.60453]]]} | Open Access 1 | 44149 | Glancy Oaks Park | 19307 | 2306 | Carmichael Recreation and Park District 671 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.847 | Glancy Oaks Park | 0 | Local Park 2 | 4 | |
3666 | 3666 | 3665 | {"type": "Polygon", "coordinates": [[[-121.57867, 39.52781], [-121.5776, 39.52782], [-121.5776, 39.52519], [-121.57866, 39.5252], [-121.57867, 39.52781]]]} | Open Access 1 | 44171 | Nelson Park | 22699 | 2222 | Feather River Recreation and Park District 308 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 6.584 | Nelson 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]);