units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 212
- California Department of Fish and Wildlife 186
- San Diego, City of 128
- Mountains Recreation and Conservation Authority 113
- Ventura, City of 96
- Los Angeles, City of 95
- East Bay Regional Park District 92
- Los Angeles, County of 58
- United States Fish and Wildlife Service 58
- California State Lands Commission 57
- Long Beach, City of 54
- Roseville, City of 47
- Butte, County of 44
- Poway, City of 43
- United States Forest Service 38
- Midpeninsula Regional Open Space District 37
- Orange, County of 36
- Irvine, City of 32
- Lake, County of 32
- San Jose, City of 31
- San Diego, County of 31
- El Dorado, County of 31
- United States National Park Service 30
- Torrance, City of 29
- Conejo Open Space Conservation Agency 29
- Yuba County Water Agency 28
- San Ramon, City of 26
- Sunrise Recreation and Park District 26
- Valley-Wide Recreation and Park District 25
- Davis, City of 25
- …
DES_TP >30
- Local Park 1,312
- Local Recreation Area 771
- Local Other or Unknown 668
- State Conservation Area 184
- Local Conservation Area 181
- Private Conservation 154
- State Park 124
- Private Recreation or Education 119
- State Resource Management Area 68
- State Recreation Area 64
- National Wildlife Refuge 53
- State Historic or Cultural Area 37
- National Forest 36
- Recreation Management Area 20
- National Monument or Landmark 18
- State Other or Unknown 15
- National Recreation Area 12
- National Public Lands 11
- National Park 11
- Conservation Area 8
- Private Other or Unknown 8
- Local Historic or Cultural Area 6
- Private Agricultural 6
- Federal Other or Unknown 5
- Resource Management Area 3
- Historic or Cultural Area 3
- Local Resource Management Area 2
- Wilderness Area 1
- State Wilderness 1
- Area of Critical Environmental Concern 1
- …
MNG_AG_TYP 28
- City Agency 2,107
- State Agency 517
- County Agency 349
- Recreation/Parks District 347
- Federal Agency 172
- Open Space District 151
- Non Profit - Land Trust 130
- Home Owners Association 94
- Water District 70
- County Agency - Parks 65
- Non Profit - Conservation 62
- Community Services District 41
- Flood District 38
- Non Profit - Other 11
- Irrigation District 7
- Commercial 7
- School District 6
- County Agency - Other 5
- Transportation Agency 5
- Special District - Other 4
- Cemetery District 3
- Joint Powers Authority 3
- Other 3
- Port/Harbor District 2
- Sanitation District 2
- Mitigation Bank 2
- Conservation District 2
- Non Profit - Education 1
ACCESS_TYP 4
- Open Access 3,319
- Restricted Access 475
- No Public Access 264
- Unknown Access 148
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12863 | 12863 | 12862 | {"type": "Polygon", "coordinates": [[[-117.71584, 33.46163], [-117.71573, 33.46176], [-117.71562, 33.46176], [-117.71537, 33.46189], [-117.71535, 33.46194], [-117.7154, 33.4621], [-117.71547, 33.46211], [-117.71551, 33.46214], [-117.71544, 33.46221], [-117.71544, 33.46227], [-117.71557, 33.46233], [-117.71564, 33.46227], [-117.71568, 33.46229], [-117.71572, 33.46246], [-117.71554, 33.46274], [-117.71525, 33.463], [-117.71509, 33.46302], [-117.71507, 33.46296], [-117.71505, 33.46295], [-117.71507, 33.46283], [-117.71494, 33.46283], [-117.71491, 33.46278], [-117.71475, 33.46286], [-117.71477, 33.46295], [-117.71465, 33.46314], [-117.71396, 33.46292], [-117.71339, 33.46248], [-117.71325, 33.46261], [-117.71323, 33.46261], [-117.71316, 33.46258], [-117.71145, 33.46152], [-117.71137, 33.46138], [-117.71182, 33.46122], [-117.71183, 33.46113], [-117.71201, 33.46106], [-117.71202, 33.46008], [-117.7144, 33.45995], [-117.71472, 33.45996], [-117.71517, 33.46053], [-117.7156, 33.46073], [-117.71581, 33.46104], [-117.7157, 33.46123], [-117.71575, 33.46127], [-117.71559, 33.46149], [-117.71584, 33.46163]]]} | Open Access 1 | 44543 | Dana Point Preserve | 17914 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Orange 3 | 24.066 | Dana Point Preserve | 0 | Private Conservation 16 | 2 | |
12864 | 12864 | 12863 | {"type": "Polygon", "coordinates": [[[-117.71104, 33.46017], [-117.71103, 33.46132], [-117.71091, 33.46132], [-117.71082, 33.46129], [-117.71053, 33.46117], [-117.71035, 33.46112], [-117.71006, 33.46109], [-117.7098, 33.46111], [-117.70924, 33.46126], [-117.70911, 33.46123], [-117.70902, 33.46126], [-117.70898, 33.46133], [-117.709, 33.46143], [-117.70887, 33.46176], [-117.70813, 33.46154], [-117.70793, 33.46151], [-117.70785, 33.46153], [-117.70771, 33.46161], [-117.70757, 33.4618], [-117.70768, 33.46192], [-117.70724, 33.46192], [-117.70717, 33.46174], [-117.70713, 33.46155], [-117.7071, 33.46152], [-117.70708, 33.46145], [-117.70709, 33.46122], [-117.70715, 33.46108], [-117.70718, 33.46086], [-117.70724, 33.46071], [-117.70752, 33.46051], [-117.70763, 33.46051], [-117.70792, 33.46064], [-117.70826, 33.46076], [-117.70852, 33.46079], [-117.70925, 33.46045], [-117.70975, 33.46033], [-117.71008, 33.46028], [-117.71032, 33.46031], [-117.71078, 33.46019], [-117.71104, 33.46017]]]} | Open Access 1 | 44544 | Dana Point Park | 17912 | 1079 | Dana Point, City of 134 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | Orange 3 | 9.325 | Dana Point Park | 0 | Local Park 2 | 4 | |
12865 | 12865 | 12864 | {"type": "Polygon", "coordinates": [[[-117.76555, 33.88034], [-117.76461, 33.88017], [-117.76306, 33.88031], [-117.76281, 33.88041], [-117.76189, 33.87954], [-117.76233, 33.87972], [-117.76268, 33.87981], [-117.76335, 33.8799], [-117.76416, 33.87985], [-117.76458, 33.87971], [-117.76515, 33.87938], [-117.76551, 33.87923], [-117.76552, 33.87943], [-117.76549, 33.87972], [-117.76555, 33.88034]]]} | Open Access 1 | 30320 | Dominguez Trailside Park | 18198 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 4.344 | Dominguez Trailside Park | 0 | Local Park 2 | 4 | |
12866 | 12866 | 12865 | {"type": "Polygon", "coordinates": [[[-117.77295, 33.68528], [-117.76975, 33.68834], [-117.76927, 33.68793], [-117.77229, 33.68487], [-117.77295, 33.68528]]]} | Open Access 1 | 35914 | Irvine holding 21 | 20251 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 7.653 | Irvine holding 21 | 0 | Local Other or Unknown 14 | 4 | |
12867 | 12867 | 12866 | {"type": "Polygon", "coordinates": [[[-117.92738, 33.88967], [-117.92683, 33.89063], [-117.9268, 33.89078], [-117.9268, 33.89083], [-117.92692, 33.89116], [-117.92694, 33.89128], [-117.92694, 33.8914], [-117.92694, 33.89153], [-117.92689, 33.89177], [-117.92688, 33.8929], [-117.9268, 33.89344], [-117.92642, 33.89211], [-117.9259, 33.89215], [-117.92583, 33.89233], [-117.92558, 33.89252], [-117.92554, 33.89382], [-117.92547, 33.89383], [-117.92548, 33.89448], [-117.92588, 33.89544], [-117.92617, 33.89571], [-117.92624, 33.89575], [-117.92629, 33.89584], [-117.92626, 33.89589], [-117.92608, 33.89602], [-117.9256, 33.89626], [-117.92524, 33.89651], [-117.92482, 33.89689], [-117.9246, 33.89687], [-117.92444, 33.89697], [-117.92431, 33.89691], [-117.92412, 33.89678], [-117.92401, 33.89662], [-117.92404, 33.89652], [-117.92401, 33.89637], [-117.9239, 33.89627], [-117.92377, 33.89618], [-117.92352, 33.89606], [-117.92318, 33.89582], [-117.92284, 33.89563], [-117.92272, 33.8956], [-117.92096, 33.89558], [-117.91994, 33.89559], [-117.91993, 33.89534], [-117.92275, 33.89432], [-117.92279, 33.89429], [-117.92282, 33.89425], [-117.9228, 33.8942], [-117.92274, 33.89416], [-117.92228, 33.89399], [-117.92209, 33.89397], [-117.92168, 33.89381], [-117.92178, 33.89266], [-117.92176, 33.8926], [-117.92172, 33.89256], [-117.92144, 33.89244], [-117.92184, 33.89187], [-117.92212, 33.89201], [-117.92275, 33.89172], [-117.9226, 33.89125], [-117.92258, 33.89109], [-117.92259, 33.89081], [-117.922, 33.89084], [-117.9218, 33.89086], [-117.92189, 33.89034], [-117.92192, 33.89024], [-117.92197, 33.89014], [-117.9221, 33.89001], [-117.92232, 33.88991], [-117.9221, 33.88951], [-117.92244, 33.88941], [-117.92227, 33.88891], [-117.92253, 33.88884], [-117.92242, 33.88814], [-117.92259, 33.88812], [-117.92256, 33.88756], [-117.92263, 33.88757], [-117.92278, 33.88765], [-117.92279, 33.88765], [-117.92283, 33.88749], [-117.92291, 33.88685], [-117.92298, 33.88687], [-117.92322, 33.88686], [-117.92433, 33.88686], [-117.92433, 33.88691], [-117.92435, 33.88692], [-117.92591, 33.8861], [-117.92602, 33.88643], [-117.92627, 33.88635], [-117.92729, 33.8893], [-117.92734, 33.88945], [-117.92738, 33.88967]]]} | Open Access 1 | 30309 | Brea Dam Park | 16341 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 105.528 | Brea Dam Park | 0 | Local Park 2 | 4 | |
12868 | 12868 | 12867 | {"type": "Polygon", "coordinates": [[[-117.93319, 33.89474], [-117.93316, 33.89535], [-117.93309, 33.89568], [-117.93278, 33.89561], [-117.93269, 33.8958], [-117.93199, 33.89562], [-117.93177, 33.89614], [-117.93144, 33.89605], [-117.93131, 33.89545], [-117.93168, 33.89521], [-117.93261, 33.89468], [-117.93285, 33.89466], [-117.93289, 33.89473], [-117.93319, 33.89474]]]} | Restricted Access 2 | 30311 | Laguna Road School Park | 31597 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.908 | Laguna Road School Park | 0 | Local Park 2 | 4 | |
12869 | 12869 | 12868 | {"type": "Polygon", "coordinates": [[[-117.84731, 33.88348], [-117.84722, 33.88366], [-117.84704, 33.88393], [-117.84684, 33.88414], [-117.84638, 33.88454], [-117.84623, 33.88473], [-117.84617, 33.88484], [-117.84611, 33.88498], [-117.84606, 33.88524], [-117.84606, 33.88537], [-117.8461, 33.88585], [-117.84551, 33.88585], [-117.84546, 33.88529], [-117.84548, 33.88506], [-117.84554, 33.88485], [-117.8456, 33.8847], [-117.84577, 33.88443], [-117.84592, 33.88425], [-117.84642, 33.8838], [-117.84668, 33.88378], [-117.84682, 33.88345], [-117.84682, 33.88331], [-117.84731, 33.88348]]]} | Open Access 1 | 30313 | Parque del Arroyo Verde | 23478 | 1255 | Placentia, City of 241 | City 2 | City Agency 2 | http://www.placentia.org/ | City 2 | 1255 | Placentia, City of 237 | City 2 | City Agency 2 | Orange 3 | 3.978 | Parque del Arroyo Verde | None 1124 | |||
12870 | 12870 | 12869 | {"type": "Polygon", "coordinates": [[[-117.8396, 33.87693], [-117.83858, 33.87693], [-117.83858, 33.87723], [-117.83827, 33.87736], [-117.83782, 33.87737], [-117.83744, 33.87727], [-117.83736, 33.87725], [-117.83733, 33.87722], [-117.83732, 33.87425], [-117.83741, 33.87418], [-117.8381, 33.87419], [-117.83846, 33.8742], [-117.83865, 33.87424], [-117.83868, 33.8759], [-117.83959, 33.8759], [-117.8396, 33.87693]]]} | Open Access 1 | 30314 | Placentia Champions Sports Complex | 23761 | 1255 | Placentia, City of 241 | City 2 | City Agency 2 | http://www.placentia.org/ | City 2 | 1255 | Placentia, City of 237 | City 2 | City Agency 2 | Orange 3 | 12.979 | Placentia Champions Sports Complex | 0 | Local Recreation Area 3 | 4 | |
12871 | 12871 | 12870 | {"type": "Polygon", "coordinates": [[[-117.70288, 33.87817], [-117.70251, 33.87832], [-117.70206, 33.87863], [-117.70185, 33.87874], [-117.70172, 33.87879], [-117.70147, 33.87886], [-117.70108, 33.87889], [-117.70017, 33.87881], [-117.69987, 33.87873], [-117.69893, 33.87834], [-117.69873, 33.87829], [-117.69841, 33.87826], [-117.69839, 33.87801], [-117.69991, 33.8781], [-117.70086, 33.87811], [-117.70161, 33.87808], [-117.70218, 33.87803], [-117.70279, 33.87795], [-117.70288, 33.87817]]]} | Open Access 1 | 30315 | Brush Canyon Park | 16452 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.253 | Brush Canyon Park | 0 | Local Park 2 | 4 | |
12872 | 12872 | 12871 | {"type": "Polygon", "coordinates": [[[-117.71543, 33.88099], [-117.71522, 33.88101], [-117.71505, 33.88106], [-117.71493, 33.88115], [-117.71472, 33.88136], [-117.71458, 33.88166], [-117.71451, 33.88166], [-117.71445, 33.88123], [-117.71436, 33.88118], [-117.71431, 33.88117], [-117.71407, 33.88137], [-117.71396, 33.88129], [-117.71391, 33.88128], [-117.71385, 33.88129], [-117.7137, 33.8814], [-117.71361, 33.8814], [-117.71357, 33.88127], [-117.71346, 33.88116], [-117.71338, 33.88111], [-117.71335, 33.88102], [-117.71335, 33.88093], [-117.71337, 33.88087], [-117.71323, 33.88077], [-117.71345, 33.88066], [-117.71368, 33.88049], [-117.71381, 33.88039], [-117.714, 33.8802], [-117.71543, 33.88099]]]} | Open Access 1 | 30316 | Bryant Ranch Park | 16459 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 3.661 | Bryant Ranch Park | 0 | Local Park 2 | 4 | |
12873 | 12873 | 12872 | {"type": "Polygon", "coordinates": [[[-117.72843, 33.88586], [-117.72826, 33.88624], [-117.72779, 33.88617], [-117.72761, 33.8864], [-117.72743, 33.88638], [-117.7273, 33.88689], [-117.7271, 33.88749], [-117.72611, 33.88751], [-117.727, 33.88512], [-117.72779, 33.88526], [-117.72824, 33.88528], [-117.72829, 33.88532], [-117.72831, 33.88558], [-117.72835, 33.88572], [-117.72843, 33.88586]]]} | Open Access 1 | 30317 | Box Canyon Park | 16313 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.091 | Box Canyon Park | 0 | Local Park 2 | 4 | |
12874 | 12874 | 12873 | {"type": "Polygon", "coordinates": [[[-117.75005, 33.87785], [-117.74989, 33.87934], [-117.74912, 33.88554], [-117.74839, 33.88686], [-117.74802, 33.88679], [-117.74801, 33.88677], [-117.74797, 33.88676], [-117.74775, 33.88679], [-117.74591, 33.88666], [-117.74591, 33.88628], [-117.74601, 33.88553], [-117.74597, 33.88517], [-117.74588, 33.88488], [-117.7459, 33.88373], [-117.74699, 33.88334], [-117.74711, 33.88264], [-117.74716, 33.88247], [-117.74735, 33.8821], [-117.74736, 33.88214], [-117.74739, 33.88218], [-117.74746, 33.8822], [-117.74761, 33.88219], [-117.74778, 33.88213], [-117.74796, 33.88203], [-117.74809, 33.8819], [-117.74816, 33.88181], [-117.74828, 33.88162], [-117.74848, 33.88126], [-117.74858, 33.88093], [-117.74887, 33.87857], [-117.74889, 33.87839], [-117.74887, 33.87835], [-117.74895, 33.87822], [-117.74904, 33.87815], [-117.74927, 33.87802], [-117.74953, 33.87791], [-117.74981, 33.87786], [-117.75005, 33.87785]]]} | Open Access 1 | 30318 | East Side Community Park | 18382 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 46.316 | East Side Community Park | 0 | Local Park 2 | 4 | |
12875 | 12875 | 12874 | {"type": "Polygon", "coordinates": [[[-117.75023, 33.88204], [-117.7501, 33.88221], [-117.74999, 33.88239], [-117.74953, 33.88226], [-117.74969, 33.88091], [-117.74971, 33.88107], [-117.75, 33.8819], [-117.75023, 33.88204]]]} | Open Access 1 | 30319 | Jean Woodard Park | 20374 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 1.117 | Jean Woodard Park | 0 | Local Park 2 | 4 | |
12876 | 12876 | 12875 | {"type": "Polygon", "coordinates": [[[-117.99859, 33.80404], [-117.99817, 33.80405], [-117.99816, 33.8035], [-117.99859, 33.80349], [-117.99859, 33.80404]]]} | Open Access 1 | 30339 | Zuniga Park | 27872 | 1342 | Stanton, City of 745 | City 2 | City Agency 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | City 2 | 1342 | Stanton, City of 731 | City 2 | City Agency 2 | Orange 3 | 0.588 | Zuniga Park | 0 | Local Park 2 | 4 | |
12877 | 12877 | 12876 | {"type": "Polygon", "coordinates": [[[-117.77905, 33.87882], [-117.77899, 33.87886], [-117.77897, 33.87889], [-117.77884, 33.87887], [-117.77865, 33.87908], [-117.7788, 33.87926], [-117.77873, 33.8794], [-117.77866, 33.87938], [-117.77855, 33.87943], [-117.77852, 33.87952], [-117.77833, 33.8798], [-117.77858, 33.87992], [-117.77866, 33.87993], [-117.77865, 33.88007], [-117.77848, 33.88004], [-117.77807, 33.87987], [-117.77775, 33.8798], [-117.77747, 33.87979], [-117.77705, 33.87987], [-117.77672, 33.87956], [-117.77618, 33.87996], [-117.77617, 33.88009], [-117.77613, 33.88012], [-117.77582, 33.87979], [-117.77583, 33.87973], [-117.77588, 33.87966], [-117.77626, 33.87941], [-117.77649, 33.87921], [-117.77674, 33.87891], [-117.77683, 33.87877], [-117.77722, 33.87883], [-117.77755, 33.87877], [-117.77803, 33.87858], [-117.77865, 33.87871], [-117.77875, 33.87841], [-117.77886, 33.87848], [-117.77905, 33.87882]]]} | Open Access 1 | 30321 | Shapell Park | 25361 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.801 | Shapell Park | 0 | Local Park 2 | 4 | |
12878 | 12878 | 12877 | {"type": "Polygon", "coordinates": [[[-117.77337, 33.88169], [-117.77357, 33.88214], [-117.77368, 33.88232], [-117.77387, 33.88252], [-117.77413, 33.88273], [-117.77419, 33.88281], [-117.77421, 33.88288], [-117.77418, 33.88292], [-117.77414, 33.88294], [-117.77301, 33.88328], [-117.773, 33.88273], [-117.77295, 33.88171], [-117.77337, 33.88169]]]} | Open Access 1 | 30322 | Las Palomas Tennis Park | 21062 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 2.926 | Las Palomas Tennis Park | 0 | Local Recreation Area 3 | 4 | |
12879 | 12879 | 12878 | {"type": "Polygon", "coordinates": [[[-117.79103, 33.87264], [-117.79058, 33.87268], [-117.79038, 33.87272], [-117.78998, 33.87288], [-117.7898, 33.87298], [-117.78901, 33.87354], [-117.78878, 33.87377], [-117.78863, 33.87392], [-117.78844, 33.87421], [-117.78833, 33.87443], [-117.78827, 33.87456], [-117.78824, 33.8747], [-117.78822, 33.87493], [-117.7885, 33.875], [-117.7883, 33.87576], [-117.78825, 33.8761], [-117.78828, 33.87713], [-117.78837, 33.87859], [-117.78835, 33.87892], [-117.78827, 33.87923], [-117.78813, 33.87954], [-117.78793, 33.87983], [-117.78776, 33.88001], [-117.78746, 33.88041], [-117.78723, 33.88029], [-117.78719, 33.88026], [-117.78718, 33.88022], [-117.78783, 33.87925], [-117.78794, 33.87899], [-117.78799, 33.87872], [-117.78794, 33.87714], [-117.7879, 33.87682], [-117.78785, 33.87532], [-117.78781, 33.87462], [-117.78804, 33.87408], [-117.78829, 33.87372], [-117.78846, 33.87353], [-117.78873, 33.87327], [-117.78921, 33.87291], [-117.78964, 33.87252], [-117.79025, 33.87217], [-117.79062, 33.87192], [-117.79087, 33.87211], [-117.79093, 33.87217], [-117.79099, 33.87225], [-117.79102, 33.87235], [-117.79103, 33.87264]]]} | Open Access 1 | 30323 | Kingsbriar Park | 20666 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 10.664 | Kingsbriar Park | 0 | Local Park 2 | 4 | |
12880 | 12880 | 12879 | {"type": "MultiPolygon", "coordinates": [[[[-117.78339, 33.89132], [-117.7834, 33.89134], [-117.7833, 33.89222], [-117.78322, 33.89345], [-117.78315, 33.89373], [-117.78307, 33.89389], [-117.78277, 33.89428], [-117.78215, 33.89503], [-117.7819, 33.89535], [-117.78168, 33.89575], [-117.78164, 33.89576], [-117.78107, 33.89563], [-117.78114, 33.89559], [-117.78122, 33.89531], [-117.78126, 33.89513], [-117.78162, 33.89495], [-117.78177, 33.89483], [-117.78198, 33.89464], [-117.78245, 33.89414], [-117.78284, 33.89367], [-117.78296, 33.89343], [-117.78298, 33.89329], [-117.78302, 33.89126], [-117.78332, 33.89128], [-117.78339, 33.89132]]], [[[-117.78372, 33.8898], [-117.78373, 33.88987], [-117.78369, 33.89009], [-117.7835, 33.89064], [-117.78338, 33.8911], [-117.7833, 33.89114], [-117.78299, 33.8911], [-117.78304, 33.89069], [-117.7832, 33.89066], [-117.78318, 33.89033], [-117.78322, 33.89027], [-117.78322, 33.89021], [-117.78338, 33.8901], [-117.78335, 33.88975], [-117.78364, 33.88976], [-117.78372, 33.8898]]]]} | Open Access 1 | 30324 | Rio Del Oro Park | 24375 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.004 | Rio Del Oro Park | 0 | Local Park 2 | 4 | |
12881 | 12881 | 12880 | {"type": "Polygon", "coordinates": [[[-117.82627, 33.9047], [-117.82616, 33.90487], [-117.82525, 33.90443], [-117.82487, 33.90428], [-117.82447, 33.90415], [-117.82406, 33.90405], [-117.82441, 33.90353], [-117.82466, 33.90333], [-117.82472, 33.90307], [-117.82625, 33.90306], [-117.82627, 33.9047]]]} | Open Access 1 | 30325 | Vista Del Verde Park | 27172 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.7 | Vista Del Verde Park | 0 | Local Park 2 | 4 | |
12882 | 12882 | 12881 | {"type": "Polygon", "coordinates": [[[-118.05429, 33.81815], [-118.05422, 33.81822], [-118.05373, 33.81824], [-118.05352, 33.81823], [-118.05283, 33.81801], [-118.05218, 33.81778], [-118.05182, 33.81771], [-118.05178, 33.81769], [-118.05177, 33.81764], [-118.05187, 33.81707], [-118.05194, 33.817], [-118.05228, 33.817], [-118.05255, 33.81697], [-118.05347, 33.81698], [-118.05412, 33.81704], [-118.05425, 33.81712], [-118.05425, 33.81768], [-118.05429, 33.81815]]]} | Open Access 1 | 30333 | Veterans Park | 27042 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 6.431 | Veterans 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]);