units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,490 rows where MNG_AG_LEV = 3 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 175
- San Diego, County of 123
- Santa Barbara, County of 119
- Orange, County of 95
- Los Angeles - Department of Parks and Recreation, County of 65
- Lake, County of 56
- Sacramento, County of 56
- Santa Clara County Parks and Recreation Dept., County of 55
- Butte, County of 53
- Sonoma County Regional Parks Dept., County of 50
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 25
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Santa Cruz, County of 11
- Contra Costa County Public Works Dept., County of 11
- …
DES_TP >30
- Local Park 784
- Local Other or Unknown 219
- Local Recreation Area 156
- Local Conservation Area 114
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- 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 1,286
- Restricted Access 80
- No Public Access 47
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,179
- County Agency - Parks 236
- County Agency - Other 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10113 | 10113 | 10112 | {"type": "Polygon", "coordinates": [[[-121.85358, 36.92094], [-121.85322, 36.92159], [-121.85317, 36.92157], [-121.85338, 36.92118], [-121.85334, 36.92115], [-121.85347, 36.92092], [-121.85358, 36.92094]]]} | Open Access 1 | 17544 | Manresa State Beach Access | 21760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.parks.ca.gov/?page_id=545 | Santa Cruz 5 | 0.136 | Manresa SB Access | 0 | Local Recreation Area 3 | 4 |
10146 | 10146 | 10145 | {"type": "Polygon", "coordinates": [[[-121.76493, 36.96594], [-121.76442, 36.96592], [-121.76403, 36.96472], [-121.76492, 36.96472], [-121.76493, 36.96594]]]} | Open Access 1 | 17782 | Mesa Village Park | 22182 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.066 | Mesa Village Park | 0 | Local Park 2 | 4 | |
10179 | 10179 | 10178 | {"type": "Polygon", "coordinates": [[[-122.0518, 37.04316], [-122.05171, 37.04325], [-122.05136, 37.04307], [-122.05098, 37.04293], [-122.04999, 37.04275], [-122.05026, 37.04347], [-122.04925, 37.04495], [-122.0486, 37.04622], [-122.04469, 37.04114], [-122.04518, 37.04088], [-122.04547, 37.04119], [-122.04567, 37.04136], [-122.04589, 37.04151], [-122.04612, 37.04165], [-122.04637, 37.04178], [-122.04664, 37.04188], [-122.04719, 37.04204], [-122.05101, 37.04281], [-122.05123, 37.04287], [-122.05152, 37.04299], [-122.0518, 37.04316]]]} | Open Access 1 | 17811 | Michael Gray Field Park | 22195 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 27.906 | Michael Gray Field Park | 0 | Local Recreation Area 3 | 4 | |
10200 | 10200 | 10199 | {"type": "MultiPolygon", "coordinates": [[[[-122.12695, 37.15886], [-122.12688, 37.15908], [-122.12693, 37.15949], [-122.12686, 37.1596], [-122.12676, 37.15972], [-122.12663, 37.15982], [-122.12646, 37.15991], [-122.12603, 37.16008], [-122.12577, 37.16023], [-122.12556, 37.16043], [-122.12542, 37.16067], [-122.12536, 37.16093], [-122.12534, 37.16109], [-122.1253, 37.16125], [-122.12469, 37.16238], [-122.12442, 37.16276], [-122.12403, 37.16305], [-122.12382, 37.16311], [-122.12368, 37.16339], [-122.12366, 37.16406], [-122.12331, 37.16443], [-122.12297, 37.16476], [-122.12282, 37.16546], [-122.11806, 37.16587], [-122.11653, 37.16016], [-122.11657, 37.15906], [-122.12571, 37.15915], [-122.12695, 37.15886]]], [[[-122.13103, 37.16474], [-122.13043, 37.16479], [-122.12301, 37.16544], [-122.12314, 37.16482], [-122.12374, 37.16422], [-122.12388, 37.164], [-122.12399, 37.16337], [-122.12412, 37.16317], [-122.12456, 37.16284], [-122.12467, 37.16271], [-122.12485, 37.16244], [-122.1251, 37.162], [-122.12546, 37.16129], [-122.1255, 37.16116], [-122.12553, 37.16093], [-122.12561, 37.16064], [-122.12581, 37.16039], [-122.12611, 37.1602], [-122.12648, 37.16009], [-122.1268, 37.15992], [-122.12704, 37.15968], [-122.12714, 37.15952], [-122.12708, 37.15901], [-122.12714, 37.15882], [-122.13035, 37.15808], [-122.13103, 37.16474]]]]} | Open Access 1 | 17835 | Miller Property County Park | 22248 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 208.728 | Miller Property County Park | 0 | Local Other or Unknown 14 | 4 | |
10210 | 10210 | 10209 | {"type": "Polygon", "coordinates": [[[-121.82055, 36.97299], [-121.81716, 36.97618], [-121.81662, 36.97634], [-121.81537, 36.97315], [-121.81532, 36.97306], [-121.81525, 36.97298], [-121.81716, 36.97213], [-121.81729, 36.9723], [-121.8174, 36.9724], [-121.81753, 36.97247], [-121.81777, 36.9725], [-121.81817, 36.97252], [-121.81837, 36.97245], [-121.81846, 36.97233], [-121.81851, 36.9722], [-121.81858, 36.97178], [-121.81871, 36.97143], [-121.81877, 36.97133], [-121.81885, 36.97126], [-121.8192, 36.97109], [-121.81943, 36.97142], [-121.81996, 36.97239], [-121.82016, 36.97266], [-121.82041, 36.97289], [-121.82055, 36.97299]]]} | Open Access 1 | 17847 | Bert Scott Estate Park | 16037 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 32.194 | Bert Scott Estate Park | 0 | Local Park 2 | 4 | |
10310 | 10310 | 10309 | {"type": "Polygon", "coordinates": [[[-121.74548, 36.91252], [-121.74543, 36.91258], [-121.74506, 36.91341], [-121.74351, 36.91547], [-121.7433, 36.91528], [-121.74403, 36.91429], [-121.74416, 36.91385], [-121.74483, 36.91341], [-121.74512, 36.91263], [-121.74548, 36.91252]]]} | Open Access 1 | 18353 | Pajaro River | 28154 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.421 | Pajaro River | None 901 | |||
10478 | 10478 | 10477 | {"type": "Polygon", "coordinates": [[[-121.78052, 36.96318], [-121.77845, 36.96386], [-121.77285, 36.96386], [-121.77286, 36.96497], [-121.76764, 36.965], [-121.76763, 36.96507], [-121.76721, 36.96507], [-121.76719, 36.96458], [-121.76511, 36.96457], [-121.76511, 36.96371], [-121.7679, 36.96373], [-121.76868, 36.9632], [-121.76904, 36.96274], [-121.76886, 36.96189], [-121.76851, 36.96134], [-121.768, 36.96075], [-121.7678, 36.96029], [-121.77036, 36.95751], [-121.77175, 36.95749], [-121.77176, 36.95734], [-121.77403, 36.95659], [-121.77841, 36.95854], [-121.7789, 36.95964], [-121.78052, 36.96318]]]} | Open Access 1 | 18562 | Pinto Lake Park | 23706 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 186.068 | Pinto Lake Park | 0 | Local Park 2 | 4 | |
10497 | 10497 | 10496 | {"type": "Polygon", "coordinates": [[[-121.85845, 36.92895], [-121.85841, 36.9293], [-121.85822, 36.92941], [-121.8581, 36.92954], [-121.85786, 36.92946], [-121.85754, 36.93007], [-121.85696, 36.92982], [-121.85766, 36.92846], [-121.8577, 36.92845], [-121.85774, 36.92846], [-121.85764, 36.92869], [-121.85845, 36.92895]]]} | Open Access 1 | 18621 | Place de Mer Park | 23760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.659 | Place de Mer Park | 0 | Local Park 2 | 4 | |
10543 | 10543 | 10542 | {"type": "MultiPolygon", "coordinates": [[[[-121.8835, 36.97893], [-121.88331, 36.97947], [-121.88316, 36.97975], [-121.88196, 36.98072], [-121.88189, 36.98075], [-121.88181, 36.98077], [-121.88125, 36.98065], [-121.88096, 36.98068], [-121.88071, 36.98079], [-121.88026, 36.98105], [-121.88021, 36.98107], [-121.88013, 36.98106], [-121.87992, 36.98133], [-121.87975, 36.98142], [-121.87919, 36.98229], [-121.87872, 36.98226], [-121.87821, 36.98272], [-121.87793, 36.98253], [-121.87787, 36.98236], [-121.87805, 36.98216], [-121.87789, 36.98198], [-121.87786, 36.98181], [-121.8777, 36.98183], [-121.87745, 36.98209], [-121.87697, 36.98284], [-121.87663, 36.98278], [-121.87654, 36.98282], [-121.87645, 36.9831], [-121.87615, 36.98336], [-121.87587, 36.98373], [-121.87554, 36.98396], [-121.87482, 36.98371], [-121.87456, 36.98364], [-121.87431, 36.98366], [-121.87389, 36.98414], [-121.87344, 36.98398], [-121.87253, 36.98125], [-121.87492, 36.98126], [-121.88113, 36.97826], [-121.88151, 36.97884], [-121.88172, 36.97876], [-121.88212, 36.97864], [-121.88254, 36.9786], [-121.88296, 36.97862], [-121.88337, 36.97873], [-121.88348, 36.97881], [-121.8835, 36.97893]]], [[[-121.88406, 36.97913], [-121.88403, 36.97919], [-121.88359, 36.9791], [-121.88361, 36.97903], [-121.88406, 36.97913]]]]} | Open Access 1 | 18757 | Polo Grounds Park | 23875 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 61.312 | Polo Grounds Park | 0 | Local Park 2 | 4 | |
15469 | 15469 | 15468 | {"type": "Polygon", "coordinates": [[[-121.98479, 36.95999], [-121.98474, 36.96002], [-121.98461, 36.96034], [-121.98443, 36.96068], [-121.98393, 36.96052], [-121.98353, 36.96036], [-121.98386, 36.96002], [-121.98431, 36.95983], [-121.98479, 36.95999]]]} | Open Access 1 | 36562 | Unnamed site - Santa Cruz, County of | 28666 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.486 | 0 | Local Other or Unknown 14 | 4 | ||
17031 | 17031 | 17030 | {"type": "Polygon", "coordinates": [[[-121.94388, 36.98798], [-121.94332, 36.99061], [-121.94267, 36.99058], [-121.94267, 36.99056], [-121.94276, 36.99045], [-121.94269, 36.99022], [-121.94259, 36.99013], [-121.94264, 36.98993], [-121.94279, 36.98973], [-121.9428, 36.98959], [-121.94286, 36.98949], [-121.94287, 36.98945], [-121.94242, 36.98943], [-121.94249, 36.98922], [-121.94269, 36.98889], [-121.94279, 36.98867], [-121.94289, 36.98833], [-121.94293, 36.98807], [-121.94297, 36.98802], [-121.94302, 36.98799], [-121.9433, 36.98804], [-121.94345, 36.98801], [-121.94346, 36.98799], [-121.94388, 36.98798]]]} | Open Access 1 | 48177 | The Farm Park & Community Center | 32712 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/Home/Parks/TheFarmPark-CommunityMeetings.aspx | Santa Cruz 5 | 5.534 | The Farm Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 |
9 | 9 | 8 | {"type": "Polygon", "coordinates": [[[-119.48323, 34.37952], [-119.48284, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952]]]} | Open Access 1 | 36 | Rincon Beach Park | 24367 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.623 | Rincon Beach Park | 0 | Local Park 2 | 4 | |
31 | 31 | 30 | {"type": "Polygon", "coordinates": [[[-120.44007, 34.65751], [-120.44003, 34.66064], [-120.4377, 34.66062], [-120.43735, 34.65839], [-120.43399, 34.65557], [-120.43409, 34.64948], [-120.43349, 34.64835], [-120.43323, 34.648], [-120.4329, 34.64769], [-120.43272, 34.64755], [-120.43252, 34.64742], [-120.43202, 34.64716], [-120.43205, 34.64698], [-120.43156, 34.64672], [-120.4313, 34.64654], [-120.43107, 34.64633], [-120.43086, 34.64611], [-120.43007, 34.64516], [-120.42988, 34.64496], [-120.42986, 34.6449], [-120.42988, 34.64483], [-120.43012, 34.64467], [-120.43121, 34.64405], [-120.43128, 34.64412], [-120.43217, 34.6436], [-120.43226, 34.6436], [-120.43589, 34.64992], [-120.4396, 34.65676], [-120.44007, 34.65751]]]} | Open Access 1 | 80 | River Park | 24416 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 123.418 | River Park | 0 | Local Park 2 | 4 | |
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | 414 | San Roque Creek | 24990 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.477 | San Roque Creek | 0 | Local Other or Unknown 14 | 4 | |
223 | 223 | 222 | {"type": "Polygon", "coordinates": [[[-120.30735, 34.60822], [-120.30677, 34.60853], [-120.30678, 34.60893], [-120.3056, 34.60813], [-120.30557, 34.6074], [-120.30189, 34.60527], [-120.30097, 34.60541], [-120.30098, 34.60492], [-120.30091, 34.60466], [-120.30062, 34.60438], [-120.30092, 34.60412], [-120.29991, 34.60337], [-120.29883, 34.60341], [-120.29874, 34.60326], [-120.29916, 34.60305], [-120.30017, 34.60306], [-120.301, 34.60348], [-120.30152, 34.60338], [-120.30129, 34.60386], [-120.30172, 34.60416], [-120.30208, 34.60463], [-120.30257, 34.60484], [-120.30301, 34.60488], [-120.30316, 34.60512], [-120.30339, 34.60529], [-120.30363, 34.60552], [-120.30404, 34.60552], [-120.30465, 34.60545], [-120.30514, 34.60554], [-120.30564, 34.6055], [-120.30565, 34.60574], [-120.306, 34.60603], [-120.30666, 34.60682], [-120.30735, 34.60822]]]} | Open Access 1 | 610 | Santa Rosa Park | 25134 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 24.322 | Santa Rosa Park | 0 | Local Park 2 | 4 | |
314 | 314 | 313 | {"type": "Polygon", "coordinates": [[[-119.69311, 34.46023], [-119.69221, 34.46094], [-119.69162, 34.46037], [-119.6916, 34.46001], [-119.69199, 34.45915], [-119.69235, 34.45915], [-119.69311, 34.46023]]]} | Open Access 1 | 847 | Skofield Park | 25529 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 4.077 | Skofield Park | 0 | Local Park 2 | 4 | |
345 | 345 | 344 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | 1191 | Summerland Greenwell Preserve | 25961 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.774 | Summerland Greenwell Preserve | 0 | Local Conservation Area 4 | 2 | |
387 | 387 | 386 | {"type": "Polygon", "coordinates": [[[-119.84568, 34.44599], [-119.84615, 34.44647], [-119.84624, 34.44662], [-119.84629, 34.44677], [-119.8465, 34.44822], [-119.84663, 34.44933], [-119.84663, 34.44955], [-119.84655, 34.4499], [-119.84653, 34.45018], [-119.84655, 34.45047], [-119.84663, 34.45075], [-119.84662, 34.45079], [-119.8466, 34.45083], [-119.84655, 34.45087], [-119.84628, 34.45093], [-119.84609, 34.45095], [-119.8459, 34.45096], [-119.84512, 34.45092], [-119.84515, 34.45003], [-119.8452, 34.44961], [-119.84524, 34.44939], [-119.8453, 34.44915], [-119.84542, 34.44878], [-119.84574, 34.44803], [-119.84584, 34.44762], [-119.84586, 34.44739], [-119.84586, 34.44718], [-119.84584, 34.44697], [-119.8458, 34.44677], [-119.84565, 34.44636], [-119.84555, 34.44616], [-119.84545, 34.446], [-119.84553, 34.44596], [-119.8456, 34.44597], [-119.84565, 34.44601], [-119.84568, 34.44599]]]} | Open Access 1 | 1154 | Stow Grove Park | 25905 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.813 | Stow Grove Park | 0 | Local Park 2 | 4 | |
445 | 445 | 444 | {"type": "Polygon", "coordinates": [[[-119.56174, 34.43642], [-119.54997, 34.43637], [-119.54992, 34.43528], [-119.55032, 34.43491], [-119.55041, 34.43442], [-119.553, 34.4332], [-119.55302, 34.4319], [-119.55511, 34.43201], [-119.55572, 34.43196], [-119.55613, 34.43206], [-119.55647, 34.43203], [-119.55731, 34.43219], [-119.55826, 34.43235], [-119.55812, 34.43257], [-119.55654, 34.43284], [-119.55664, 34.43332], [-119.55682, 34.43352], [-119.55775, 34.43371], [-119.55825, 34.43377], [-119.55918, 34.43363], [-119.55997, 34.4338], [-119.56007, 34.43451], [-119.56063, 34.435], [-119.56121, 34.43547], [-119.56174, 34.43642]]]} | Open Access 1 | 1384 | Toro Canyon Park | 26412 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 88.907 | Toro Canyon Park | 0 | Local Park 2 | 4 | |
579 | 579 | 578 | {"type": "Polygon", "coordinates": [[[-119.89552, 34.4344], [-119.89508, 34.43471], [-119.89486, 34.4345], [-119.89513, 34.43431], [-119.89512, 34.4338], [-119.89489, 34.4336], [-119.8955, 34.43359], [-119.89552, 34.4344]]]} | Open Access 1 | 1927 | Winchester I Park | 27619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.139 | Winchester I 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]);