units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 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 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 | |
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.13155, 32.60871], [-117.13082, 32.60779], [-117.1306, 32.6076], [-117.1302, 32.60762], [-117.12999, 32.60766], [-117.12894, 32.60764], [-117.12851, 32.60758], [-117.1281, 32.60746], [-117.12761, 32.60717], [-117.12702, 32.60667], [-117.12658, 32.60618], [-117.1259, 32.60554], [-117.12564, 32.60545], [-117.12498, 32.60536], [-117.12444, 32.60519], [-117.12507, 32.60517], [-117.12808, 32.60599], [-117.1287, 32.60621], [-117.12921, 32.60642], [-117.1296, 32.60663], [-117.12996, 32.60686], [-117.13025, 32.60707], [-117.1305, 32.60731], [-117.13071, 32.60753], [-117.13153, 32.60854], [-117.13155, 32.60871]]]} | No Public Access 3 | 47652 | South Bay Marine Biological Study Area | 31395 | 110 | United States Navy 876 | Federal 1 | Federal Agency 1 | http://www.navy.mil/ | Other Federal 13 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.569 | South Bay Marine Biological Study Area | None 645 | |||
10390 | 10390 | 10389 | {"type": "MultiPolygon", "coordinates": [[[[-114.59933, 34.8403], [-114.59817, 34.8403], [-114.59816, 34.8402], [-114.5974, 34.8402], [-114.59631, 34.83958], [-114.5963, 34.83674], [-114.59756, 34.83674], [-114.59859, 34.8376], [-114.59933, 34.83869], [-114.59933, 34.8403]]], [[[-114.60795, 34.84404], [-114.60512, 34.84402], [-114.60511, 34.84467], [-114.60415, 34.8444], [-114.60324, 34.84401], [-114.60287, 34.84401], [-114.60287, 34.84392], [-114.6039, 34.84392], [-114.6039, 34.84287], [-114.60365, 34.84287], [-114.60365, 34.84339], [-114.60348, 34.84339], [-114.60348, 34.84286], [-114.6026, 34.84286], [-114.6026, 34.84339], [-114.60251, 34.84339], [-114.60251, 34.84286], [-114.60171, 34.84285], [-114.60171, 34.8423], [-114.60114, 34.84229], [-114.60113, 34.84294], [-114.60104, 34.84294], [-114.60104, 34.84285], [-114.60095, 34.84285], [-114.60095, 34.84276], [-114.60071, 34.84255], [-114.60071, 34.84219], [-114.6002, 34.84219], [-114.6002, 34.84197], [-114.60003, 34.84197], [-114.60003, 34.84164], [-114.59969, 34.84163], [-114.59969, 34.84108], [-114.59892, 34.84108], [-114.59891, 34.841], [-114.59885, 34.841], [-114.59885, 34.84052], [-114.59986, 34.84052], [-114.59987, 34.84029], [-114.60042, 34.84029], [-114.60048, 34.84038], [-114.60071, 34.84038], [-114.60071, 34.84051], [-114.6002, 34.84053], [-114.6002, 34.84107], [-114.60054, 34.84107], [-114.60055, 34.8417], [-114.60312, 34.84171], [-114.60701, 34.84358], [-114.60702, 34.84394], [-114.60717, 34.84394], [-114.60718, 34.84366], [-114.60795, 34.84404]], [[-114.60449, 34.84342], [-114.60448, 34.84392], [-114.60464, 34.84393], [-114.60465, 34.84343], [-114.60449, 34.84342]]], [[[-114.60513, 34.84766], [-114.60318, 34.84764], [-114.60299, 34.84743], [-114.60187, 34.84686], [-114.60072, 34.84634], [-114.60071, 34.844], [-114.60242, 34.84401], [-114.60412, 34.84467], [-114.60511, 34.84523], [-114.60513, 34.84766]]]]} | Restricted Access 2 | 49071 | River's Edge Golf Course | 33774 | 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/services/rivers-edge-golf-course/ | San Bernardino 22 | 77.93 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
10571 | 10571 | 10570 | {"type": "Polygon", "coordinates": [[[-121.89896, 36.60742], [-121.89812, 36.60754], [-121.89778, 36.6077], [-121.89763, 36.60792], [-121.89754, 36.60846], [-121.89681, 36.60819], [-121.89539, 36.60759], [-121.89512, 36.60744], [-121.89498, 36.60735], [-121.89476, 36.60709], [-121.89472, 36.60703], [-121.89462, 36.60679], [-121.89461, 36.60647], [-121.89463, 36.60634], [-121.89509, 36.60549], [-121.89517, 36.60528], [-121.89521, 36.60511], [-121.8952, 36.60493], [-121.89517, 36.60469], [-121.89518, 36.60465], [-121.89567, 36.60458], [-121.89598, 36.60478], [-121.89608, 36.60434], [-121.89623, 36.60436], [-121.89613, 36.60485], [-121.89639, 36.60483], [-121.89669, 36.6049], [-121.89698, 36.60499], [-121.89717, 36.60525], [-121.8975, 36.60535], [-121.89771, 36.60527], [-121.89821, 36.60526], [-121.89877, 36.60499], [-121.89896, 36.60742]]]} | Open Access 1 | 18828 | Presidio | 23990 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 27.963 | Presidio | None 927 | |||
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 |
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 | |
3 | 3 | 2 | {"type": "Polygon", "coordinates": [[[-120.81796, 37.78801], [-120.81602, 37.78793], [-120.81565, 37.78787], [-120.81358, 37.7878], [-120.81268, 37.78774], [-120.8117, 37.78776], [-120.8111, 37.78789], [-120.81064, 37.78764], [-120.80991, 37.78733], [-120.80928, 37.78757], [-120.80895, 37.78704], [-120.80743, 37.78568], [-120.80702, 37.78537], [-120.80701, 37.78515], [-120.80703, 37.78338], [-120.80993, 37.78254], [-120.81293, 37.78022], [-120.81292, 37.77802], [-120.81434, 37.77723], [-120.81693, 37.77715], [-120.81697, 37.78113], [-120.81726, 37.78253], [-120.81756, 37.78477], [-120.81686, 37.78479], [-120.81635, 37.78482], [-120.8157, 37.78465], [-120.81513, 37.78463], [-120.81405, 37.78454], [-120.81371, 37.7843], [-120.81343, 37.78428], [-120.81288, 37.78427], [-120.81092, 37.78458], [-120.81058, 37.78429], [-120.81017, 37.78433], [-120.80902, 37.785], [-120.80861, 37.78529], [-120.80875, 37.78561], [-120.80897, 37.78583], [-120.80941, 37.78606], [-120.80994, 37.78614], [-120.81072, 37.78613], [-120.81093, 37.78596], [-120.8114, 37.78609], [-120.81224, 37.78639], [-120.81288, 37.78655], [-120.8129, 37.78674], [-120.81368, 37.78684], [-120.8148, 37.78683], [-120.81525, 37.78688], [-120.81579, 37.78697], [-120.81674, 37.78697], [-120.81725, 37.78683], [-120.81777, 37.7866], [-120.81796, 37.78801]], [[-120.81641, 37.7829], [-120.81637, 37.78261], [-120.81576, 37.78291], [-120.81539, 37.78302], [-120.81522, 37.78337], [-120.81521, 37.78348], [-120.8154, 37.78386], [-120.81556, 37.78389], [-120.81566, 37.78395], [-120.81602, 37.78396], [-120.81609, 37.784], [-120.81655, 37.78409], [-120.81655, 37.78401], [-120.81644, 37.78328], [-120.81641, 37.7829]]]} | Restricted Access 2 | 9 | Oakdale Golf & Country Club | 32983 | 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 | 137.317 | Oakdale Golf & Country Club | 0 | Local Recreation Area 3 | 4 | |
4 | 4 | 3 | {"type": "Polygon", "coordinates": [[[-120.8183, 37.79059], [-120.81762, 37.7907], [-120.81665, 37.79072], [-120.81597, 37.7907], [-120.81518, 37.79071], [-120.81444, 37.7908], [-120.81354, 37.79068], [-120.81324, 37.79069], [-120.81119, 37.79087], [-120.81012, 37.79017], [-120.80995, 37.78962], [-120.81, 37.78839], [-120.80928, 37.78757], [-120.80991, 37.78733], [-120.81064, 37.78764], [-120.8111, 37.78789], [-120.81169, 37.78776], [-120.81268, 37.78774], [-120.81358, 37.7878], [-120.81565, 37.78787], [-120.81602, 37.78793], [-120.81796, 37.78801], [-120.8183, 37.79059]]]} | Restricted Access 2 | 24 | Stanley Wakefield Wilderness Area | 25790 | 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 | 57.379 | Stanley Wakefield Wilderness Area | 0 | Local Conservation Area 4 | 2 | |
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 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 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.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 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]);