units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
126 rows where AGNCY_TYP = 3 and DES_TP = 3 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, MNG_AG_ID, MNG_AG_LEV, COUNTY
MNG_AGENCY 28
- Los Angeles, County of 25
- Santa Barbara, County of 18
- Los Angeles - Department of Parks and Recreation, County of 13
- Sacramento, County of 9
- San Diego, County of 7
- Santa Cruz, County of 5
- San Luis Obispo, County of 5
- Monterey, County of 5
- Orange, County of 5
- Riverside, County of 5
- Ventura, County of 4
- Fresno, County of 3
- Kern, County of 3
- Placer, County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Yolo, County of 2
- Valley-Wide Recreation and Park District 1
- Cerritos, City of 1
- Lake, County of 1
- Desert Recreation District 1
- Torrance, City of 1
- Long Beach, City of 1
- San Bernardino, County of 1
- Humboldt, County of 1
- Siskiyou, County of 1
- Amador, County of 1
- Sutter, County of 1
MNG_AG_TYP 4
ACCESS_TYP 4
DES_TP 1
- Local Recreation Area · 126 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14991 | 14991 | 14990 | {"type": "Polygon", "coordinates": [[[-120.74127, 38.54448], [-120.74125, 38.54475], [-120.74104, 38.54487], [-120.74089, 38.54509], [-120.74089, 38.54533], [-120.74091, 38.54553], [-120.74099, 38.54569], [-120.74082, 38.54569], [-120.74076, 38.54552], [-120.74073, 38.54533], [-120.74063, 38.5451], [-120.74034, 38.54496], [-120.74036, 38.54455], [-120.74062, 38.54449], [-120.74127, 38.54448]]]} | Open Access 1 | 45637 | River Pines Playground | 28454 | 372 | Amador, County of 755 | County 3 | County Agency 3 | http://www.co.amador.ca.us/ | County 3 | 372 | Amador, County of 741 | County 3 | County Agency 3 | http://www.touramador.com/parks | Amador 52 | 1.32 | River Pines Playground | 0 | Local Recreation Area 3 | 4 |
14981 | 14981 | 14980 | {"type": "Polygon", "coordinates": [[[-121.63358, 39.27281], [-121.63254, 39.27519], [-121.63254, 39.27536], [-121.6327, 39.27598], [-121.63105, 39.27599], [-121.63025, 39.27499], [-121.63004, 39.27326], [-121.63182, 39.27344], [-121.63195, 39.27327], [-121.63234, 39.27302], [-121.63264, 39.27265], [-121.63358, 39.27281]]]} | Open Access 1 | 45598 | Live Oak Park and Recreation Area | 28424 | 366 | Sutter, County of 1128 | County 3 | County Agency 3 | http://www.co.sutter.ca.us/ | County 3 | 366 | Sutter, County of 1083 | County 3 | County Agency 3 | https://www.co.sutter.ca.us/doc/living/entertainment/recreation/pw_live_oak_park | Sutter 47 | 17.329 | Live Oak Park and Rec. Area | 0 | Local Recreation Area 3 | 4 |
3211 | 3211 | 3210 | {"type": "Polygon", "coordinates": [[[-122.63748, 41.70784], [-122.63684, 41.70871], [-122.63636, 41.70858], [-122.63561, 41.70825], [-122.63577, 41.70803], [-122.63593, 41.70785], [-122.63621, 41.70776], [-122.63657, 41.70768], [-122.63678, 41.70769], [-122.63748, 41.70784]]]} | Open Access 1 | 28144 | Hibbard Field | 19892 | 365 | Siskiyou, County of 596 | County 3 | County Agency 3 | http://www.co.siskiyou.ca.us/ | County 3 | 365 | Siskiyou, County of 586 | County 3 | County Agency 3 | Siskiyou 28 | 2.667 | Hibbard Field | 0 | Local Recreation Area 3 | 4 | |
12588 | 12588 | 12587 | {"type": "Polygon", "coordinates": [[[-123.99351, 40.88039], [-123.99291, 40.88117], [-123.99172, 40.88062], [-123.99228, 40.87997], [-123.99351, 40.88039]]]} | Open Access 1 | 29310 | Gymkhana Field | 19579 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 2.642 | Gymkhana Field | 0 | Local Recreation Area 3 | 4 | |
11863 | 11863 | 11862 | {"type": "MultiPolygon", "coordinates": [[[[-122.9546, 38.94653], [-122.95306, 38.94643], [-122.95002, 38.94634], [-122.94994, 38.94325], [-122.95117, 38.94382], [-122.95151, 38.94392], [-122.95178, 38.94404], [-122.95195, 38.94473], [-122.95231, 38.94518], [-122.95246, 38.94561], [-122.95267, 38.94569], [-122.95308, 38.94565], [-122.95356, 38.94572], [-122.954, 38.94569], [-122.95446, 38.94583], [-122.95479, 38.94577], [-122.95491, 38.94577], [-122.95488, 38.94585], [-122.95443, 38.94623], [-122.95442, 38.94636], [-122.95448, 38.94647], [-122.9546, 38.94653], [-122.95486, 38.94645], [-122.95501, 38.94649], [-122.95515, 38.9465], [-122.95528, 38.94648], [-122.95557, 38.94638], [-122.95626, 38.94647], [-122.95671, 38.94657], [-122.95695, 38.9467], [-122.9551, 38.94653], [-122.9546, 38.94653]]], [[[-122.90255, 38.94905], [-122.90246, 38.94915], [-122.90245, 38.94663], [-122.90226, 38.94607], [-122.90242, 38.94631], [-122.90269, 38.94661], [-122.90284, 38.94686], [-122.9029, 38.94713], [-122.90288, 38.94729], [-122.90282, 38.94745], [-122.90258, 38.94783], [-122.90255, 38.94802], [-122.90255, 38.94905]]], [[[-122.9594, 38.94295], [-122.95921, 38.94666], [-122.95716, 38.94669], [-122.95708, 38.94659], [-122.95675, 38.94644], [-122.9563, 38.94635], [-122.95558, 38.94624], [-122.9552, 38.94636], [-122.9551, 38.94636], [-122.95492, 38.94631], [-122.95471, 38.94633], [-122.95459, 38.94637], [-122.95459, 38.94629], [-122.95507, 38.94588], [-122.95509, 38.94573], [-122.95497, 38.94563], [-122.95483, 38.94563], [-122.95448, 38.9457], [-122.95402, 38.94555], [-122.95357, 38.94558], [-122.95308, 38.94551], [-122.95265, 38.94553], [-122.95251, 38.94518], [-122.95211, 38.94466], [-122.95197, 38.94404], [-122.95183, 38.94388], [-122.95123, 38.9437], [-122.94994, 38.9431], [-122.94993, 38.94274], [-122.94805, 38.94276], [-122.94813, 38.94235], [-122.94814, 38.94202], [-122.94795, 38.94159], [-122.94775, 38.94105], [-122.94758, 38.94065], [-122.94732, 38.94043], [-122.94703, 38.9403], [-122.94663, 38.94009], [-122.94605, 38.93984], [-122.945, 38.93923], [-122.9444, 38.93895], [-122.94366, 38.93876], [-122.94334, 38.93874], [-122.94304, 38.9387], [-122.9423, 38.93845], [-122.94189, 38.9383], [-122.94163, 38.93814], [-122.94133, 38.93809], [-122.94112, 38.93799], [-122.94093, 38.93783], [-122.94059, 38.93763], [-122.93991, 38.93751], [-122.93925, 38.93729], [-122.93907, 38.93727], [-122.93874, 38.93733], [-122.93835, 38.93736], [-122.938, 38.93733], [-122.93776, 38.93727], [-122.93757, 38.93712], [-122.93745, 38.93695], [-122.9373, 38.9368], [-122.93717, 38.93676], [-122.93696, 38.93669], [-122.93668, 38.9367], [-122.9364, 38.93674], [-122.93599, 38.93668], [-122.93582, 38.93659], [-122.93564, 38.9363], [-122.93527, 38.93594], [-122.93486, 38.9352], [-122.93481, 38.93473], [-122.93436, 38.93394], [-122.93405, 38.93356], [-122.93385, 38.93339], [-122.93358, 38.93321], [-122.93324, 38.93304], [-122.93278, 38.93286], [-122.93227, 38.93268], [-122.93198, 38.93252], [-122.93117, 38.932], [-122.9308, 38.93191], [-122.93013, 38.93192], [-122.92995, 38.93189], [-122.92978, 38.93181], [-122.92927, 38.9315], [-122.92866, 38.93099], [-122.92827, 38.9307], [-122.92713, 38.92996], [-122.92691, 38.92988], [-122.92663, 38.92996], [-122.92619, 38.93022], [-122.92593, 38.93026], [-122.92567, 38.93033], [-122.92512, 38.9306], [-122.92497, 38.93073], [-122.92484, 38.93098], [-122.92471, 38.93109], [-122.92454, 38.93114], [-122.9244, 38.93112], [-122.92424, 38.93104], [-122.92412, 38.93096], [-122.9234, 38.93039], [-122.92292, 38.9302], [-122.92201, 38.92995], [-122.92166, 38.92994], [-122.92092, 38.93004], [-122.92018, 38.93037], [-122.91993, 38.9304], [-122.91935, 38.93033], [-122.91879, 38.93048], [-122.91848, 38.93069], [-122.91831, 38.93093], [-122.91806, 38.9314], [-122.91752, 38.93254], [-122.91724, 38.93289], [-122.91695, 38.93306], [-122.91668, 38.9331], [-122.91638, 38.93303], [-122.91575, 38.93281], [-122.91536, 38.93274], [-122.91494, 38.93279], [-122.91365, 38.93329], [-122.91336, 38.93351], [-122.91318, 38.93372], [-122.9125, 38.93478], [-122.9122, 38.93514], [-122.91179, 38.93545], [-122.91057, 38.93581], [-122.91011, 38.93607], [-122.90977, 38.93641], [-122.90959, 38.93672], [-122.90941, 38.9373], [-122.90912, 38.93786], [-122.90904, 38.93819], [-122.90904, 38.93851], [-122.9092, 38.93921], [-122.90917, 38.9395], [-122.90892, 38.94012], [-122.90895, 38.94047], [-122.90906, 38.94076], [-122.9093, 38.94101], [-122.90965, 38.94122], [-122.90999, 38.94138], [-122.9103, 38.94162], [-122.91048, 38.94188], [-122.91052, 38.94229], [-122.91044, 38.94273], [-122.91022, 38.94305], [-122.91004, 38.94323], [-122.90976, 38.94339], [-122.90947, 38.94348], [-122.90882, 38.94363], [-122.90854, 38.94377], [-122.90823, 38.944], [-122.90797, 38.94438], [-122.90788, 38.94474], [-122.90791, 38.94501], [-122.90798, 38.94524], [-122.90824, 38.94569], [-122.90842, 38.94607], [-122.90854, 38.94645], [-122.9086, 38.94691], [-122.90857, 38.94868], [-122.90852, 38.94892], [-122.90844, 38.94906], [-122.90829, 38.94919], [-122.90811, 38.94927], [-122.90796, 38.94932], [-122.9078, 38.94933], [-122.9076, 38.94932], [-122.90666, 38.94902], [-122.90608, 38.94891], [-122.90409, 38.94867], [-122.90373, 38.94866], [-122.90315, 38.94875], [-122.90286, 38.94885], [-122.90265, 38.94899], [-122.90265, 38.94802], [-122.90269, 38.94786], [-122.90292, 38.94747], [-122.90299, 38.94729], [-122.903, 38.94712], [-122.90295, 38.94683], [-122.90278, 38.94657], [-122.90252, 38.94628], [-122.90234, 38.94601], [-122.90226, 38.94575], [-122.90211, 38.94458], [-122.90196, 38.94418], [-122.90127, 38.94315], [-122.90068, 38.94258], [-122.90056, 38.94231], [-122.90049, 38.942], [-122.90032, 38.94156], [-122.90012, 38.94113], [-122.90005, 38.94071], [-122.90014, 38.9399], [-122.9002, 38.93945], [-122.90032, 38.93921], [-122.90046, 38.93905], [-122.90082, 38.93888], [-122.90117, 38.93876], [-122.90149, 38.9386], [-122.9027, 38.93764], [-122.90292, 38.93752], [-122.90354, 38.93703], [-122.90354, 38.93701], [-122.90348, 38.93696], [-122.90286, 38.93745], [-122.90264, 38.93758], [-122.90169, 38.93835], [-122.90115, 38.93867], [-122.9008, 38.93879], [-122.90042, 38.93897], [-122.90023, 38.93918], [-122.9001, 38.93946], [-122.90003, 38.9399], [-122.89995, 38.9407], [-122.90002, 38.94114], [-122.90038, 38.94199], [-122.90044, 38.94234], [-122.90059, 38.94263], [-122.90103, 38.94304], [-122.90007, 38.94305], [-122.90006, 38.94271], [-122.89548, 38.94267], [-122.89546, 38.94302], [-122.89319, 38.943], [-122.89275, 38.94505], [-122.8919, 38.94504], [-122.8912, 38.94309], [-122.89075, 38.94307], [-122.88949, 38.94335], [-122.88845, 38.94301], [-122.88809, 38.94301], [-122.888, 38.94292], [-122.88852, 38.9429], [-122.889, 38.94283], [-122.88828, 38.94156], [-122.88816, 38.94083], [-122.88798, 38.93923], [-122.88713, 38.93861], [-122.88654, 38.93848], [-122.8861, 38.93791], [-122.88609, 38.93709], [-122.88611, 38.93568], [-122.88184, 38.93563], [-122.88168, 38.9354], [-122.88167, 38.93198], [-122.89541, 38.93213], [-122.89537, 38.92485], [-122.91357, 38.92503], [-122.93287, 38.92501], [-122.93232, 38.93223], [-122.93699, 38.93224], [-122.93663, 38.93583], [-122.94593, 38.93578], [-122.94546, 38.9393], [-122.95017, 38.93923], [-122.95487, 38.93922], [-122.95461, 38.94298], [-122.9594, 38.94295]]], [[[-122.94788, 38.94277], [-122.94053, 38.94286], [-122.94039, 38.93937], [-122.93177, 38.93946], [-122.91358, 38.93953], [-122.91353, 38.94309], [-122.91804, 38.9431], [-122.91784, 38.95396], [-122.91758, 38.95761], [-122.91327, 38.95741], [-122.91335, 38.95377], [-122.90483, 38.95379], [-122.90484, 38.95033], [-122.90191, 38.95024], [-122.9021, 38.94997], [-122.9022, 38.94967], [-122.90261, 38.9492], [-122.90293, 38.94899], [-122.90317, 38.94889], [-122.90362, 38.94881], [-122.90372, 38.9488], [-122.90409, 38.9488], [-122.90606, 38.94905], [-122.90659, 38.94915], [-122.90686, 38.94922], [-122.90754, 38.94945], [-122.90779, 38.94947], [-122.90798, 38.94945], [-122.90819, 38.9494], [-122.90838, 38.9493], [-122.90857, 38.94914], [-122.90868, 38.94898], [-122.90874, 38.94867], [-122.90878, 38.94689], [-122.90871, 38.94641], [-122.90859, 38.94605], [-122.90841, 38.94566], [-122.90815, 38.94521], [-122.90807, 38.94498], [-122.90806, 38.94475], [-122.90814, 38.94441], [-122.90839, 38.94406], [-122.90863, 38.94388], [-122.90889, 38.94376], [-122.90952, 38.94361], [-122.90987, 38.9435], [-122.91017, 38.94331], [-122.91041, 38.94308], [-122.9106, 38.94276], [-122.91072, 38.94228], [-122.91064, 38.94184], [-122.91043, 38.94152], [-122.91006, 38.94125], [-122.90975, 38.94111], [-122.90939, 38.94088], [-122.90921, 38.94068], [-122.90912, 38.94043], [-122.9091, 38.94014], [-122.90923, 38.93977], [-122.90937, 38.93951], [-122.90939, 38.93921], [-122.90921, 38.93847], [-122.90922, 38.93824], [-122.90927, 38.93795], [-122.90958, 38.93732], [-122.90974, 38.93675], [-122.90991, 38.93648], [-122.91025, 38.93616], [-122.91065, 38.93594], [-122.91186, 38.93559], [-122.91234, 38.93524], [-122.91264, 38.93484], [-122.91334, 38.93377], [-122.91347, 38.93361], [-122.91375, 38.93339], [-122.915, 38.93291], [-122.91535, 38.93287], [-122.91573, 38.93295], [-122.91633, 38.93316], [-122.91667, 38.93324], [-122.917, 38.93319], [-122.91737, 38.93299], [-122.91768, 38.93262], [-122.91822, 38.93146], [-122.91846, 38.931], [-122.91863, 38.93077], [-122.9189, 38.93059], [-122.91934, 38.93047], [-122.91994, 38.93054], [-122.92025, 38.9305], [-122.92098, 38.93017], [-122.92167, 38.93007], [-122.9219, 38.93008], [-122.92212, 38.93012], [-122.92287, 38.93033], [-122.92328, 38.9305], [-122.92349, 38.93064], [-122.92412, 38.93115], [-122.92427, 38.93123], [-122.92458, 38.93128], [-122.9248, 38.93122], [-122.92494, 38.93113], [-122.92512, 38.9308], [-122.92523, 38.93071], [-122.92574, 38.93046], [-122.92595, 38.93039], [-122.92624, 38.93035], [-122.92648, 38.93024], [-122.9267, 38.93009], [-122.92691, 38.93002], [-122.92701, 38.93007], [-122.92776, 38.93053], [-122.92856, 38.93111], [-122.92915, 38.93161], [-122.9297, 38.93193], [-122.92991, 38.93203], [-122.93017, 38.93207], [-122.93079, 38.93206], [-122.9311, 38.93212], [-122.93191, 38.93265], [-122.93227, 38.93283], [-122.93284, 38.93303], [-122.93322, 38.93318], [-122.93349, 38.93333], [-122.93374, 38.9335], [-122.93392, 38.93367], [-122.93421, 38.93402], [-122.93462, 38.93472], [-122.93469, 38.93523], [-122.93513, 38.936], [-122.93549, 38.93638], [-122.9357, 38.93669], [-122.93592, 38.93681], [-122.93639, 38.93688], [-122.93672, 38.93683], [-122.93696, 38.93683], [-122.93718, 38.93691], [-122.93734, 38.93705], [-122.93745, 38.93722], [-122.93768, 38.9374], [-122.93796, 38.93746], [-122.93836, 38.93749], [-122.93876, 38.93747], [-122.93906, 38.9374], [-122.93942, 38.93749], [-122.9398, 38.93763], [-122.94052, 38.93775], [-122.94081, 38.93794], [-122.94106, 38.93813], [-122.94128, 38.93822], [-122.94157, 38.93828], [-122.94181, 38.93842], [-122.94224, 38.93858], [-122.94295, 38.93882], [-122.94329, 38.93888], [-122.94362, 38.93889], [-122.9443, 38.93908], [-122.94483, 38.93931], [-122.94594, 38.93994], [-122.94651, 38.94019], [-122.94694, 38.94043], [-122.94723, 38.94055], [-122.94744, 38.94074], [-122.94779, 38.94165], [-122.94796, 38.94203], [-122.94795, 38.94233], [-122.94788, 38.94277]]]]} | Open Access 1 | 25233 | Highland Springs Recreation Area | 5079 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://www.co.lake.ca.us/Government/Directory/Parks_and_Recreation/Parks_Search/Highland_Springs_Recreation_Area.htm | Lake 40 | 2434.453 | Highland Springs Rec. Area | 0 | Local Recreation Area 3 | 4 |
3673 | 3673 | 3672 | {"type": "Polygon", "coordinates": [[[-121.764, 38.67997], [-121.76378, 38.68], [-121.76291, 38.68027], [-121.7627, 38.68031], [-121.75975, 38.68029], [-121.75975, 38.67976], [-121.7603, 38.67977], [-121.7603, 38.67979], [-121.76059, 38.67981], [-121.76213, 38.67983], [-121.76214, 38.67974], [-121.76325, 38.67977], [-121.76325, 38.67994], [-121.764, 38.67997]]]} | Open Access 1 | 29720 | Gonzales Park Soccer Field | 19399 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 4.348 | Gonzales Park Soccer Field | 0 | Local Recreation Area 3 | 4 | |
15626 | 15626 | 15625 | {"type": "Polygon", "coordinates": [[[-122.04736, 38.71131], [-122.04679, 38.71342], [-122.04678, 38.71342], [-122.04617, 38.71298], [-122.04428, 38.71266], [-122.04431, 38.712], [-122.04324, 38.71157], [-122.04085, 38.71104], [-122.03867, 38.71114], [-122.03866, 38.71066], [-122.04, 38.71056], [-122.04079, 38.71053], [-122.04216, 38.71076], [-122.04291, 38.71092], [-122.04307, 38.71094], [-122.04336, 38.71093], [-122.04351, 38.71095], [-122.04425, 38.71115], [-122.04454, 38.71121], [-122.04504, 38.71123], [-122.04518, 38.71121], [-122.04577, 38.71106], [-122.04615, 38.71101], [-122.04668, 38.7111], [-122.04691, 38.71111], [-122.04736, 38.71131]]]} | Open Access 1 | 21411 | Capay Open Space Park | 16830 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 19.97 | Capay OS Park | 0 | Local Recreation Area 3 | 4 | |
4220 | 4220 | 4219 | {"type": "Polygon", "coordinates": [[[-119.22967, 34.44042], [-119.22934, 34.44104], [-119.22896, 34.44199], [-119.22891, 34.4424], [-119.2287, 34.44271], [-119.2267, 34.44309], [-119.22634, 34.44335], [-119.22505, 34.44413], [-119.22493, 34.44422], [-119.22486, 34.44385], [-119.22446, 34.44408], [-119.22421, 34.44417], [-119.22364, 34.44429], [-119.22324, 34.44458], [-119.22283, 34.44477], [-119.22248, 34.44279], [-119.22792, 34.44213], [-119.22748, 34.43959], [-119.22936, 34.43921], [-119.22967, 34.44042]]]} | Open Access 1 | 44996 | Soule Recreation Area | 25633 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 30.851 | Soule Rec. Area | 0 | Local Recreation Area 3 | 4 | |
5855 | 5855 | 5854 | {"type": "Polygon", "coordinates": [[[-118.87212, 34.31513], [-118.86601, 34.31512], [-118.86602, 34.31149], [-118.86145, 34.31148], [-118.85913, 34.30851], [-118.85892, 34.3046], [-118.85829, 34.30065], [-118.86599, 34.30066], [-118.86602, 34.30788], [-118.86833, 34.30788], [-118.87066, 34.30982], [-118.87207, 34.31343], [-118.87212, 34.31513]]]} | Restricted Access 2 | 224 | Rustic Canyon Golf Course | 32984 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 277.113 | Rustic Canyon GC | 0 | Local Recreation Area 3 | 4 | |
6002 | 6002 | 6001 | {"type": "Polygon", "coordinates": [[[-119.16058, 34.28227], [-119.1606, 34.28232], [-119.16056, 34.28237], [-119.1576, 34.28415], [-119.15733, 34.28384], [-119.15656, 34.2843], [-119.15656, 34.28431], [-119.15682, 34.28462], [-119.15395, 34.28635], [-119.15198, 34.28407], [-119.15254, 34.28373], [-119.15218, 34.28332], [-119.15296, 34.28284], [-119.15581, 34.28113], [-119.15737, 34.28293], [-119.16005, 34.28166], [-119.16058, 34.28227]]]} | Restricted Access 2 | 646 | Saticoy Regional Golf Course | 32989 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 48.962 | Saticoy Reg. GC | 0 | Local Recreation Area 3 | 4 | |
15989 | 15989 | 15988 | {"type": "Polygon", "coordinates": [[[-118.83946, 34.24946], [-118.83926, 34.24994], [-118.83054, 34.24995], [-118.83088, 34.24987], [-118.83099, 34.24983], [-118.83165, 34.24954], [-118.83188, 34.24941], [-118.83227, 34.24914], [-118.83247, 34.24897], [-118.83283, 34.2486], [-118.83303, 34.24836], [-118.83365, 34.24841], [-118.83379, 34.24837], [-118.8341, 34.24821], [-118.83431, 34.2482], [-118.83453, 34.24827], [-118.83468, 34.24841], [-118.83486, 34.2485], [-118.83509, 34.2485], [-118.83529, 34.24844], [-118.83542, 34.24832], [-118.8355, 34.24816], [-118.83555, 34.24796], [-118.83572, 34.24786], [-118.83589, 34.24769], [-118.83618, 34.24723], [-118.83626, 34.24705], [-118.83628, 34.24668], [-118.83712, 34.24662], [-118.8375, 34.24662], [-118.83776, 34.24651], [-118.83788, 34.24635], [-118.83782, 34.24616], [-118.83784, 34.24596], [-118.83779, 34.24578], [-118.83782, 34.24558], [-118.83776, 34.24524], [-118.83761, 34.24509], [-118.83736, 34.24506], [-118.83692, 34.2451], [-118.83666, 34.2451], [-118.8364, 34.24516], [-118.83566, 34.24518], [-118.83516, 34.24514], [-118.83475, 34.24506], [-118.83468, 34.24502], [-118.83489, 34.24478], [-118.83507, 34.24461], [-118.83547, 34.24429], [-118.83574, 34.24411], [-118.839, 34.24411], [-118.83906, 34.24414], [-118.83867, 34.24452], [-118.83864, 34.24469], [-118.83921, 34.24531], [-118.83912, 34.24685], [-118.83845, 34.24721], [-118.83863, 34.24856], [-118.83929, 34.24906], [-118.83946, 34.24946]]]} | Open Access 1 | 1216 | Sunset Hills - Olsen Road Open Space | 26047 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 54.712 | Sunset Hills - Olsen Road OS | 0 | Local Recreation Area 3 | 4 | |
10266 | 10266 | 10265 | {"type": "Polygon", "coordinates": [[[-121.18041, 37.56148], [-121.17609, 37.56266], [-121.17586, 37.56246], [-121.17687, 37.56164], [-121.17721, 37.56192], [-121.18024, 37.56108], [-121.18041, 37.56148]]]} | Open Access 1 | 18218 | United Community Center and Park | 26664 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 5.043 | United Community Ctr. and Park | 0 | Local Recreation Area 3 | 4 | |
15596 | 15596 | 15595 | {"type": "Polygon", "coordinates": [[[-121.08537, 37.50062], [-121.08475, 37.50123], [-121.08407, 37.50118], [-121.08416, 37.50091], [-121.0842, 37.50073], [-121.08421, 37.50005], [-121.0838, 37.49907], [-121.08359, 37.4984], [-121.08321, 37.49772], [-121.08342, 37.49748], [-121.08456, 37.49999], [-121.08535, 37.50032], [-121.08537, 37.50062]]]} | Unknown Access 4 | 18177 | Las Palmas Fishing Access | 21059 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 4.583 | Las Palmas FA | 0 | Local Recreation Area 3 | 4 | |
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 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 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
6125 | 6125 | 6124 | {"type": "MultiPolygon", "coordinates": [[[[-121.9654, 36.95968], [-121.96527, 36.95978], [-121.96488, 36.96008], [-121.96489, 36.9599], [-121.96496, 36.95985], [-121.96516, 36.95981], [-121.96528, 36.95971], [-121.96532, 36.95963], [-121.96534, 36.95945], [-121.9654, 36.95935], [-121.9654, 36.95968]]], [[[-121.96554, 36.96051], [-121.96499, 36.96051], [-121.96499, 36.96023], [-121.96554, 36.9598], [-121.96554, 36.96051]]]]} | Open Access 1 | 1336 | The Hook Beach Access | 26285 | 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 | 0.827 | The Hook Beach Access | 0 | Local Recreation Area 3 | 4 | |
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 |
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 | |
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 |
2429 | 2429 | 2428 | {"type": "Polygon", "coordinates": [[[-119.73275, 34.45416], [-119.73256, 34.45495], [-119.73033, 34.45569], [-119.73131, 34.45385], [-119.73248, 34.45385], [-119.73275, 34.45416]]]} | Open Access 1 | 17293 | Lauro Canyon Reservoir | 33319 | 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 | 6.232 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 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 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 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]);