units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,486
- Recreation/Parks District 704
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7294 | 7294 | 7293 | {"type": "Polygon", "coordinates": [[[-118.07409, 34.02003], [-118.07253, 34.02084], [-118.06905, 34.02101], [-118.06903, 34.02046], [-118.06945, 34.01932], [-118.06976, 34.01935], [-118.0698, 34.01927], [-118.07064, 34.01943], [-118.07024, 34.02012], [-118.0702, 34.02012], [-118.07003, 34.02041], [-118.07017, 34.02048], [-118.0708, 34.01943], [-118.07409, 34.02003]]]} | Open Access 1 | 6573 | Streamland Park | 32518 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 14.075 | Streamland Park | 0 | Local Park 2 | 4 | |
12993 | 12993 | 12992 | {"type": "Polygon", "coordinates": [[[-122.33026, 37.82072], [-122.32855, 37.821], [-122.32573, 37.82142], [-122.32338, 37.82152], [-122.32103, 37.82184], [-122.32075, 37.82185], [-122.32073, 37.82154], [-122.3199, 37.8199], [-122.31924, 37.81945], [-122.31952, 37.81919], [-122.32164, 37.81919], [-122.32165, 37.82097], [-122.32188, 37.82093], [-122.3223, 37.82093], [-122.32253, 37.821], [-122.32267, 37.82099], [-122.32306, 37.82102], [-122.32326, 37.82109], [-122.32373, 37.82106], [-122.32388, 37.82107], [-122.32404, 37.82103], [-122.3242, 37.82103], [-122.32434, 37.82097], [-122.32454, 37.82101], [-122.32474, 37.821], [-122.32495, 37.82094], [-122.32502, 37.82091], [-122.32508, 37.82083], [-122.32518, 37.82079], [-122.32521, 37.8208], [-122.32528, 37.82085], [-122.32552, 37.82092], [-122.32566, 37.82091], [-122.32593, 37.82091], [-122.32601, 37.82089], [-122.32606, 37.82087], [-122.32615, 37.82088], [-122.32642, 37.82084], [-122.32661, 37.82077], [-122.32678, 37.82076], [-122.32689, 37.82071], [-122.32719, 37.82065], [-122.32745, 37.82057], [-122.32761, 37.82056], [-122.32777, 37.82061], [-122.32831, 37.82061], [-122.32853, 37.82058], [-122.32861, 37.82055], [-122.32876, 37.82054], [-122.32941, 37.82044], [-122.32994, 37.82033], [-122.3301, 37.82031], [-122.33015, 37.82031], [-122.33026, 37.82072]]]} | No Public Access 3 | 46946 | East Bay Gateway Shoreline | 30571 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 20.218 | East Bay Gateway Shoreline | 0 | Local Park 2 | 4 | |
16314 | 16314 | 16313 | {"type": "Polygon", "coordinates": [[[-117.28945, 34.33654], [-117.28507, 34.33656], [-117.2851, 34.34012], [-117.27636, 34.34019], [-117.27198, 34.34026], [-117.27199, 34.34382], [-117.25304, 34.3441], [-117.25384, 34.3436], [-117.25441, 34.34318], [-117.25912, 34.33904], [-117.25935, 34.33878], [-117.25943, 34.33867], [-117.25952, 34.33849], [-117.25956, 34.33836], [-117.2596, 34.33818], [-117.25962, 34.33797], [-117.25959, 34.33685], [-117.25828, 34.33686], [-117.25829, 34.33802], [-117.25825, 34.33816], [-117.25815, 34.33829], [-117.25357, 34.34232], [-117.25315, 34.34265], [-117.25283, 34.34287], [-117.25183, 34.34348], [-117.25163, 34.34326], [-117.2487, 34.34503], [-117.249, 34.34536], [-117.24879, 34.3455], [-117.24854, 34.34569], [-117.24823, 34.34599], [-117.24794, 34.34636], [-117.24771, 34.34677], [-117.2476, 34.34703], [-117.24752, 34.3473], [-117.24746, 34.34758], [-117.24744, 34.3478], [-117.24748, 34.35136], [-117.24585, 34.3514], [-117.24591, 34.36404], [-117.24152, 34.36413], [-117.24147, 34.35697], [-117.23941, 34.3571], [-117.23945, 34.35004], [-117.23311, 34.3505], [-117.23296, 34.34672], [-117.23284, 34.34305], [-117.23714, 34.34288], [-117.24164, 34.34291], [-117.24167, 34.34027], [-117.24586, 34.34043], [-117.24591, 34.33855], [-117.24381, 34.33848], [-117.24389, 34.33473], [-117.24494, 34.33477], [-117.24492, 34.33554], [-117.24545, 34.33556], [-117.24543, 34.33665], [-117.24594, 34.33667], [-117.24597, 34.33557], [-117.2465, 34.33558], [-117.24652, 34.33481], [-117.24678, 34.33481], [-117.2468, 34.33388], [-117.24785, 34.33391], [-117.24787, 34.33297], [-117.25023, 34.33303], [-117.25028, 34.33119], [-117.2524, 34.33125], [-117.25242, 34.33033], [-117.25352, 34.32761], [-117.25879, 34.32779], [-117.25929, 34.32596], [-117.26315, 34.32593], [-117.26316, 34.32609], [-117.26641, 34.32606], [-117.26642, 34.3268], [-117.26749, 34.3268], [-117.2675, 34.32588], [-117.2762, 34.32579], [-117.27627, 34.33308], [-117.28942, 34.33296], [-117.28945, 34.33654]]]} | Open Access 1 | 3195 | Mojave River Forks Regional Park | 13576 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/MojaveRiverForksRegionalPark.aspx | San Bernardino 22 | 1866.795 | Mojave River Forks RP | 0 | Local Park 2 | 4 |
16340 | 16340 | 16339 | {"type": "MultiPolygon", "coordinates": [[[[-117.6664, 33.93913], [-117.66482, 33.93912], [-117.66308, 33.93745], [-117.66057, 33.93495], [-117.65676, 33.93497], [-117.65664, 33.93484], [-117.6577, 33.93194], [-117.66023, 33.93195], [-117.66035, 33.93204], [-117.6604, 33.9323], [-117.66086, 33.93285], [-117.66136, 33.9333], [-117.66165, 33.9335], [-117.66216, 33.9341], [-117.66247, 33.93525], [-117.66309, 33.93548], [-117.66308, 33.93716], [-117.66469, 33.93718], [-117.66521, 33.93789], [-117.6654, 33.93813], [-117.6664, 33.93913]]], [[[-117.67181, 33.94502], [-117.6718, 33.94627], [-117.66839, 33.94626], [-117.66809, 33.9459], [-117.66689, 33.94268], [-117.6699, 33.9427], [-117.6701, 33.94292], [-117.67034, 33.94332], [-117.67067, 33.94358], [-117.67105, 33.94403], [-117.67129, 33.94439], [-117.67164, 33.94476], [-117.67181, 33.94502]]], [[[-117.65508, 33.93913], [-117.6565, 33.93524], [-117.65671, 33.93511], [-117.6605, 33.93509], [-117.66307, 33.9377], [-117.66454, 33.93911], [-117.66306, 33.93911], [-117.66304, 33.94185], [-117.66612, 33.94145], [-117.66618, 33.94161], [-117.66629, 33.94159], [-117.66731, 33.9444], [-117.66789, 33.94593], [-117.66815, 33.94626], [-117.66817, 33.94626], [-117.66969, 33.94802], [-117.66298, 33.94983], [-117.66297, 33.94656], [-117.66296, 33.94655], [-117.66278, 33.94988], [-117.65744, 33.95133], [-117.65748, 33.94787], [-117.65784, 33.94786], [-117.65805, 33.94622], [-117.65484, 33.9462], [-117.65476, 33.94966], [-117.65125, 33.94963], [-117.65135, 33.94931], [-117.65256, 33.9462], [-117.65255, 33.94619], [-117.6525, 33.94619], [-117.65492, 33.93955], [-117.65506, 33.93917], [-117.65508, 33.93913]]], [[[-117.66683, 33.95388], [-117.66257, 33.9539], [-117.66256, 33.95392], [-117.6582, 33.95395], [-117.65817, 33.9513], [-117.66189, 33.9503], [-117.66251, 33.95029], [-117.66252, 33.95027], [-117.66449, 33.95027], [-117.66682, 33.95291], [-117.66683, 33.95388]]], [[[-117.65679, 33.93193], [-117.65572, 33.93485], [-117.65552, 33.93498], [-117.65555, 33.93512], [-117.65566, 33.93525], [-117.65168, 33.94617], [-117.65173, 33.94618], [-117.6506, 33.94911], [-117.65067, 33.94914], [-117.65051, 33.94963], [-117.64604, 33.94961], [-117.64604, 33.9513], [-117.64559, 33.95145], [-117.6435, 33.95068], [-117.64283, 33.95091], [-117.64222, 33.95125], [-117.64114, 33.95147], [-117.64077, 33.9521], [-117.64039, 33.95259], [-117.63979, 33.95316], [-117.63913, 33.95348], [-117.63889, 33.95415], [-117.6385, 33.95449], [-117.63798, 33.95399], [-117.63766, 33.95352], [-117.63758, 33.95322], [-117.63777, 33.95293], [-117.63801, 33.95268], [-117.6383, 33.95213], [-117.63866, 33.95181], [-117.63951, 33.95063], [-117.63974, 33.94992], [-117.63992, 33.94958], [-117.64063, 33.94878], [-117.64073, 33.9482], [-117.64103, 33.94736], [-117.64145, 33.94713], [-117.64176, 33.94705], [-117.64201, 33.94684], [-117.64228, 33.94647], [-117.64231, 33.94569], [-117.64196, 33.9452], [-117.64161, 33.94489], [-117.64129, 33.94479], [-117.64377, 33.94336], [-117.64599, 33.94346], [-117.64599, 33.94021], [-117.63971, 33.94], [-117.63971, 33.93961], [-117.63331, 33.93958], [-117.63346, 33.93118], [-117.6288, 33.93123], [-117.62881, 33.93135], [-117.6333, 33.93132], [-117.63323, 33.93536], [-117.62098, 33.93536], [-117.62167, 33.93416], [-117.62208, 33.93371], [-117.62262, 33.93338], [-117.62293, 33.93327], [-117.62418, 33.93238], [-117.62463, 33.93132], [-117.62461, 33.93099], [-117.62434, 33.9307], [-117.62401, 33.93047], [-117.62325, 33.9302], [-117.62253, 33.92987], [-117.62228, 33.92966], [-117.62527, 33.92659], [-117.63215, 33.92645], [-117.63212, 33.9245], [-117.65515, 33.92486], [-117.65531, 33.92521], [-117.65519, 33.93015], [-117.65517, 33.93191], [-117.65679, 33.93193]]], [[[-117.67131, 33.9593], [-117.66704, 33.95933], [-117.66699, 33.95388], [-117.66767, 33.95388], [-117.6713, 33.958], [-117.67131, 33.9593]]], [[[-117.67941, 33.96241], [-117.67861, 33.96236], [-117.67863, 33.96284], [-117.6784, 33.96334], [-117.67836, 33.96367], [-117.67802, 33.96419], [-117.67797, 33.96433], [-117.67746, 33.96463], [-117.6771, 33.96421], [-117.67701, 33.96404], [-117.67727, 33.96348], [-117.6771, 33.96252], [-117.6768, 33.96222], [-117.67631, 33.96189], [-117.67616, 33.96142], [-117.67561, 33.96106], [-117.67544, 33.9611], [-117.67517, 33.96132], [-117.67466, 33.96083], [-117.67411, 33.96075], [-117.67412, 33.96046], [-117.67392, 33.96015], [-117.67333, 33.96003], [-117.66421, 33.94967], [-117.66985, 33.94815], [-117.67702, 33.95364], [-117.67327, 33.95592], [-117.67354, 33.95699], [-117.67429, 33.95766], [-117.6739, 33.95841], [-117.67438, 33.95864], [-117.67462, 33.95873], [-117.67481, 33.95998], [-117.67531, 33.9602], [-117.67571, 33.96078], [-117.67644, 33.96096], [-117.67698, 33.96152], [-117.67797, 33.96158], [-117.67941, 33.96241]]]]} | Open Access 1 | 8883 | Prado Regional Park | 13583 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/PradoRegionalPark.aspx | San Bernardino 22 | 2110.592 | Prado RP | 0 | Local Park 2 | 4 |
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 |
12958 | 12958 | 12957 | {"type": "Polygon", "coordinates": [[[-114.60317, 34.84764], [-114.60145, 34.84762], [-114.60072, 34.84705], [-114.60071, 34.84633], [-114.60186, 34.84686], [-114.60298, 34.84742], [-114.60317, 34.84764]]]} | Open Access 1 | 30413 | Manny Morris Beach Side Park | 33661 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/manny-morris-beach-side-park/ | San Bernardino 22 | 3.852 | Manny Morris Beach Side Park | 0 | Local Park 2 | 4 |
16336 | 16336 | 16335 | {"type": "Polygon", "coordinates": [[[-121.83759, 37.97592], [-121.83299, 37.97585], [-121.82581, 37.9799], [-121.82385, 37.97979], [-121.82383, 37.97965], [-121.82147, 37.97953], [-121.82006, 37.97971], [-121.81763, 37.97959], [-121.8175, 37.97959], [-121.81684, 37.97977], [-121.81672, 37.97978], [-121.8147, 37.97943], [-121.81469, 37.97946], [-121.8142, 37.97938], [-121.81292, 37.97929], [-121.8128, 37.97929], [-121.81268, 37.97931], [-121.81191, 37.97964], [-121.81095, 37.9796], [-121.81049, 37.9796], [-121.80944, 37.97821], [-121.81013, 37.97849], [-121.81346, 37.97593], [-121.81438, 37.97557], [-121.81433, 37.96849], [-121.80559, 37.96849], [-121.80559, 37.9677], [-121.80563, 37.96767], [-121.80647, 37.96768], [-121.80719, 37.96766], [-121.80791, 37.96758], [-121.80861, 37.96745], [-121.80929, 37.96725], [-121.80994, 37.967], [-121.81055, 37.9667], [-121.81094, 37.96647], [-121.81179, 37.96593], [-121.81205, 37.96578], [-121.81225, 37.9657], [-121.81245, 37.96564], [-121.81288, 37.96556], [-121.82247, 37.96552], [-121.82255, 37.96573], [-121.82385, 37.96572], [-121.82386, 37.9656], [-121.83352, 37.96573], [-121.83382, 37.96588], [-121.83445, 37.96601], [-121.8375, 37.96763], [-121.83762, 37.96865], [-121.83759, 37.97592]]]} | Open Access 1 | 14204 | Contra Loma Regional Park | 13801 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/contra_loma | Contra Costa 12 | 767.487 | Contra Loma RP | 1968 | Local Park 2 | 4 |
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
11506 | 11506 | 11505 | {"type": "MultiPolygon", "coordinates": [[[[-122.26439, 40.46354], [-122.26186, 40.46573], [-122.26173, 40.46555], [-122.26152, 40.46533], [-122.26093, 40.46456], [-122.26067, 40.46429], [-122.26042, 40.46408], [-122.25979, 40.46373], [-122.25937, 40.46342], [-122.25849, 40.46291], [-122.2574, 40.4625], [-122.25689, 40.46224], [-122.25581, 40.46194], [-122.25528, 40.46176], [-122.25826, 40.45926], [-122.25894, 40.45972], [-122.25774, 40.46074], [-122.25774, 40.46075], [-122.25834, 40.46116], [-122.25955, 40.46015], [-122.26439, 40.46354]]], [[[-122.27724, 40.46773], [-122.27711, 40.46784], [-122.27722, 40.46806], [-122.27378, 40.4691], [-122.27158, 40.47075], [-122.27044, 40.47169], [-122.26905, 40.47272], [-122.26848, 40.47302], [-122.26697, 40.47311], [-122.26542, 40.47269], [-122.2634, 40.47184], [-122.26244, 40.47132], [-122.26088, 40.47093], [-122.25945, 40.47025], [-122.25885, 40.46904], [-122.25868, 40.46843], [-122.26163, 40.46594], [-122.26734, 40.46985], [-122.27317, 40.46493], [-122.27724, 40.46773]]], [[[-122.28086, 40.46807], [-122.27979, 40.46787], [-122.27888, 40.46784], [-122.27965, 40.46719], [-122.27968, 40.4672], [-122.27964, 40.46726], [-122.28086, 40.46807]]]]} | Open Access 1 | 48204 | Anderson River Park | 32743 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1421 | Anderson, City of 602 | City 2 | City Agency 2 | http://cms3.revize.com/revize/andersoncanew/departments/parks.php | Shasta 27 | 212.125 | Anderson River Park | 0 | Local Park 2 | 4 |
1086 | 1086 | 1085 | {"type": "MultiPolygon", "coordinates": [[[[-118.70777, 34.08133], [-118.70681, 34.0813], [-118.70623, 34.08114], [-118.70622, 34.08048], [-118.70776, 34.08048], [-118.70777, 34.08133]]], [[[-118.71107, 34.08337], [-118.71107, 34.08905], [-118.70501, 34.08902], [-118.70468, 34.08872], [-118.70458, 34.08871], [-118.70446, 34.08865], [-118.70384, 34.08818], [-118.70376, 34.08805], [-118.70405, 34.08651], [-118.70448, 34.08541], [-118.70225, 34.08541], [-118.70224, 34.08133], [-118.70325, 34.08192], [-118.70432, 34.0824], [-118.70448, 34.08253], [-118.7046, 34.08271], [-118.70472, 34.08318], [-118.70474, 34.08317], [-118.70472, 34.08304], [-118.70466, 34.08277], [-118.70458, 34.08252], [-118.70455, 34.08244], [-118.70452, 34.08241], [-118.70427, 34.08224], [-118.70329, 34.08181], [-118.70419, 34.08181], [-118.70421, 34.08184], [-118.70436, 34.0818], [-118.7069, 34.08182], [-118.70864, 34.08246], [-118.70839, 34.08293], [-118.7084, 34.08294], [-118.70854, 34.08298], [-118.70879, 34.08252], [-118.71107, 34.08337]]]]} | Open Access 1 | 6475 | Tapia Park | 26185 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 138.571 | Tapia Park | 0 | Local Park 2 | 4 | |
4978 | 4978 | 4977 | {"type": "Polygon", "coordinates": [[[-122.28393, 37.76682], [-122.28393, 37.77013], [-122.28285, 37.77012], [-122.28281, 37.77095], [-122.28162, 37.77109], [-122.28162, 37.76827], [-122.27932, 37.76826], [-122.2793, 37.76863], [-122.27857, 37.76862], [-122.27848, 37.77085], [-122.27851, 37.77086], [-122.2785, 37.771], [-122.27847, 37.77101], [-122.27845, 37.77136], [-122.27822, 37.77135], [-122.27828, 37.76974], [-122.2759, 37.76967], [-122.27589, 37.7695], [-122.2753, 37.76949], [-122.27531, 37.76908], [-122.27476, 37.76908], [-122.27475, 37.76858], [-122.27202, 37.76755], [-122.27198, 37.7675], [-122.27186, 37.76731], [-122.2718, 37.76716], [-122.27175, 37.76698], [-122.27172, 37.76683], [-122.27172, 37.76649], [-122.27166, 37.76597], [-122.27166, 37.76247], [-122.27158, 37.76221], [-122.27292, 37.76284], [-122.27475, 37.76352], [-122.28282, 37.76638], [-122.28393, 37.76682]]]} | Open Access 1 | 15087 | Crown Memorial Regional Shoreline | 1486 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/crown_beach | Alameda 17 | 133.46 | Crown Memorial Reg. Shoreline | 1967 | Local Park 2 | 4 |
13921 | 13921 | 13920 | {"type": "Polygon", "coordinates": [[[-121.84833, 37.25563], [-121.84663, 37.25985], [-121.84562, 37.26362], [-121.84547, 37.26412], [-121.84533, 37.26464], [-121.84206, 37.26469], [-121.8397, 37.26156], [-121.83774, 37.26159], [-121.83639, 37.25952], [-121.83617, 37.25916], [-121.84291, 37.25912], [-121.84291, 37.25868], [-121.84339, 37.2577], [-121.84335, 37.2575], [-121.8432, 37.2571], [-121.84276, 37.25508], [-121.84294, 37.25507], [-121.84294, 37.25502], [-121.84498, 37.25499], [-121.84601, 37.25529], [-121.84678, 37.25546], [-121.84741, 37.25556], [-121.84833, 37.25563]]]} | Open Access 1 | 46977 | Martial Cottle Park | 30611 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/martialcottle.aspx | Santa Clara 19 | 137.123 | Martial Cottle Park | 1963 | Local Park 2 | 4 |
4007 | 4007 | 4006 | {"type": "MultiPolygon", "coordinates": [[[[-117.14406, 32.70147], [-117.1438, 32.70178], [-117.14126, 32.70002], [-117.14133, 32.6999], [-117.14168, 32.70003], [-117.14184, 32.70014], [-117.14214, 32.70029], [-117.14239, 32.70037], [-117.14245, 32.70033], [-117.14406, 32.70147]]], [[[-117.14441, 32.70113], [-117.14421, 32.70131], [-117.14265, 32.70025], [-117.14169, 32.69956], [-117.14176, 32.69951], [-117.14179, 32.69934], [-117.14203, 32.69909], [-117.14229, 32.69886], [-117.1439, 32.7], [-117.14382, 32.70008], [-117.14379, 32.70022], [-117.14379, 32.70042], [-117.14375, 32.70045], [-117.14383, 32.70053], [-117.14392, 32.70058], [-117.14392, 32.70062], [-117.14396, 32.70074], [-117.14401, 32.70083], [-117.14441, 32.70113]]]]} | Open Access 1 | 46820 | Chicano Park | 17188 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.609 | Chicano Park | 0 | Local Park 2 | 4 | |
11165 | 11165 | 11164 | {"type": "Polygon", "coordinates": [[[-118.15596, 34.11789], [-118.15596, 34.11836], [-118.15571, 34.11836], [-118.15572, 34.11789], [-118.15596, 34.11789]]]} | Open Access 1 | 47994 | South Pasadena Community Garden and Demonstration Garden | 32415 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/community-garden | Los Angeles 6 | 0.293 | South Pasadena Community Garden and Demonstration Garden | 2015 | Local Park 2 | 4 |
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
13118 | 13118 | 13117 | {"type": "Polygon", "coordinates": [[[-118.32897, 34.10547], [-118.32877, 34.10597], [-118.32865, 34.10616], [-118.32806, 34.1056], [-118.32807, 34.10559], [-118.32819, 34.10555], [-118.32853, 34.1055], [-118.32891, 34.10541], [-118.32895, 34.10543], [-118.32897, 34.10547]]]} | Open Access 1 | 45044 | Franklin Ivar Park | 19059 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.862 | Franklin Ivar Park | 0 | Local Park 2 | 4 | |
15360 | 15360 | 15359 | {"type": "Polygon", "coordinates": [[[-118.08168, 34.07278], [-118.08143, 34.0728], [-118.08143, 34.07246], [-118.08165, 34.07245], [-118.08168, 34.07278]]]} | Open Access 1 | 46551 | Olney Park | 29847 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.199 | Olney Park | 0 | Local Park 2 | 4 | |
3271 | 3271 | 3270 | {"type": "Polygon", "coordinates": [[[-121.96963, 38.04434], [-121.96963, 38.04843], [-121.96528, 38.04832], [-121.96268, 38.04843], [-121.96269, 38.04202], [-121.9663, 38.04288], [-121.96623, 38.04318], [-121.96849, 38.0443], [-121.96963, 38.04434]]]} | Open Access 1 | 29409 | Bay Point Regional Shoreline | 32664 | 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 | https://www.ebparks.org/parks/bay_point/default.htm | Contra Costa 12 | 86.981 | Bay Point Reg. Shoreline | 1996 | Local Park 2 | 4 |
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 | |
12258 | 12258 | 12257 | {"type": "Polygon", "coordinates": [[[-122.29218, 38.01568], [-122.29031, 38.01802], [-122.28912, 38.01718], [-122.28922, 38.01688], [-122.28938, 38.0167], [-122.28977, 38.01698], [-122.29009, 38.01702], [-122.29019, 38.01671], [-122.2906, 38.0165], [-122.2905, 38.01637], [-122.29193, 38.01586], [-122.29218, 38.01568]]]} | Open Access 1 | 25796 | San Pablo Bay Regional Shoreline | 24965 | 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 | 5.337 | San Pablo Bay Reg. Shoreline | 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]);