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_LEV
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
AGNCY_LEV 8 ✖
- City 7,352
- Special District 1,139
- County 798
- State 36
- Private 36
- Federal 8
- Non Profit 5
- Joint 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
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 |
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 | |
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 |
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 |
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 |
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 |
2 | 2 | 1 | {"type": "Polygon", "coordinates": [[[-120.84977, 37.77283], [-120.84915, 37.77309], [-120.84786, 37.77119], [-120.84847, 37.77095], [-120.84977, 37.77283]]]} | Open Access 1 | 14 | Oaklawn Memorial Park | 23029 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.595 | Oaklawn Memorial Park | 0 | Local Park 2 | 4 | |
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.46 | Eisenhower Park | 0 | Local Park 2 | 4 | |
6 | 6 | 5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | Open Access 1 | 26 | Azalea Neighborhood Park | 30115 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.138 | Azalea Neighborhood Park | 0 | Local Park 2 | 4 | |
8 | 8 | 7 | {"type": "Polygon", "coordinates": [[[-117.70487, 34.09777], [-117.70457, 34.09776], [-117.7046, 34.09775], [-117.70462, 34.09772], [-117.70461, 34.09748], [-117.70381, 34.09747], [-117.7042, 34.09652], [-117.7048, 34.09652], [-117.70482, 34.09772], [-117.70483, 34.09775], [-117.70487, 34.09777]]]} | Open Access 1 | 30 | El Barrio Park | 18477 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 2.099 | El Barrio Park | 0 | Local Park 2 | 4 | |
11 | 11 | 10 | {"type": "Polygon", "coordinates": [[[-117.08431, 32.9339], [-117.08421, 32.93398], [-117.08411, 32.93375], [-117.08393, 32.93344], [-117.08356, 32.93329], [-117.08306, 32.93325], [-117.08297, 32.9331], [-117.08313, 32.93271], [-117.08313, 32.93246], [-117.08292, 32.93223], [-117.08257, 32.9321], [-117.08257, 32.93151], [-117.08386, 32.93278], [-117.08402, 32.93297], [-117.08415, 32.93318], [-117.08425, 32.93342], [-117.0843, 32.93368], [-117.08431, 32.9339]]]} | Open Access 1 | 46738 | Butterfly Mini-Park | 30187 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.079 | Butterfly Mini-Park | 0 | Local Park 2 | 4 | |
13 | 13 | 12 | {"type": "Polygon", "coordinates": [[[-120.84861, 37.76492], [-120.8483, 37.76505], [-120.84814, 37.76482], [-120.84845, 37.76468], [-120.84861, 37.76492]]]} | Open Access 1 | 49 | William Meyer Park | 27553 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 0.233 | William Meyer Park | 0 | Local Park 2 | 4 | |
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | 42 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.055 | Rincon Park | 0 | Local Park 2 | 4 | |
15 | 15 | 14 | {"type": "Polygon", "coordinates": [[[-120.87737, 37.76176], [-120.87616, 37.76176], [-120.87611, 37.76172], [-120.8761, 37.76055], [-120.87615, 37.76051], [-120.87682, 37.76051], [-120.87688, 37.76054], [-120.87736, 37.76051], [-120.87737, 37.76176]]]} | Open Access 1 | 43 | William A. Fish Veterans Memorial Park | 27537 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.803 | William A. Fish Veterans Memorial Park | 0 | Local Park 2 | 4 | |
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | Open Access 1 | 66 | Ambercot Park | 15443 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 4.088 | Ambercot Park | 0 | Local Park 2 | 4 | |
17 | 17 | 16 | {"type": "Polygon", "coordinates": [[[-118.12258, 34.69275], [-118.12251, 34.69275], [-118.1225, 34.69267], [-118.1217, 34.69267], [-118.12164, 34.69261], [-118.12164, 34.69054], [-118.12169, 34.69048], [-118.12257, 34.69049], [-118.12258, 34.69275]]]} | Open Access 1 | 56 | El Dorado Park | 18505 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 5.137 | El Dorado Park | 0 | Local Park 2 | 4 | |
19 | 19 | 18 | {"type": "Polygon", "coordinates": [[[-117.08916, 32.92533], [-117.08917, 32.92536], [-117.08915, 32.92627], [-117.08884, 32.92626], [-117.08902, 32.92612], [-117.08902, 32.926], [-117.08877, 32.92601], [-117.08855, 32.92613], [-117.08872, 32.92567], [-117.0877, 32.92529], [-117.08912, 32.92531], [-117.08916, 32.92533]]]} | Open Access 1 | 46740 | Dry Creek Mini-Park | 30190 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.479 | Dry Creek Mini-Park | 0 | Local Park 2 | 4 | |
20 | 20 | 19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | Open Access 1 | 76 | River Park | 24419 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 1.349 | River 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]);