units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 6,548
- County Agency 740
- Recreation/Parks District 711
- State Agency 690
- Non Profit - Land Trust 358
- Federal Agency 314
- Water District 196
- Open Space District 183
- County Agency - Parks 145
- Community Services District 120
- Non Profit - Conservation 106
- Home Owners Association 98
- Irrigation District 44
- Flood District 36
- Cemetery District 35
- Non Profit - Other 34
- County Agency - Other 29
- School District 19
- Port/Harbor District 16
- Commercial 8
- Sanitation District 8
- Special District - Other 8
- Joint Powers Authority 7
- Non Profit - Cemetery District 4
- Conservation District 4
- Other 3
- Mitigation Bank 3
- Non Profit - Education 3
- Transportation Agency 2
- Airport District 1
- …
MNG_AGENCY >30
- San Diego, City of 354
- Los Angeles, City of 321
- California Department of Fish and Wildlife 259
- California Department of Parks and Recreation 219
- San Jose, City of 156
- San Francisco, City and County of 143
- Sacramento, City of 140
- Ventura, City of 132
- Mountains Recreation and Conservation Authority 126
- Los Angeles, County of 107
- Roseville, City of 95
- United States Forest Service 93
- Long Beach, City of 87
- East Bay Regional Park District 86
- California State Lands Commission 84
- San Diego, County of 78
- Irvine, City of 76
- Orange, County of 74
- Oakland, City of 68
- Santa Barbara, County of 64
- Fresno, City of 63
- United States National Park Service 58
- Poway, City of 58
- Consumnes Community Services District 58
- United States Fish and Wildlife Service 54
- Stockton, City of 53
- Lake, County of 51
- Modesto, City of 51
- Yuba County Water Agency 50
- Chula Vista, City of 49
- …
DES_TP >30
- Local Park 5,818
- Local Recreation Area 1,250
- Local Other or Unknown 635
- Private Conservation 408
- Local Conservation Area 298
- State Conservation Area 228
- Private Recreation or Education 149
- State Resource Management Area 129
- State Park 120
- National Forest 87
- State Recreation Area 79
- Local Historic or Cultural Area 75
- National Wildlife Refuge 53
- Recreation Management Area 41
- State Historic or Cultural Area 38
- National Recreation Area 25
- State Other or Unknown 23
- Resource Management Area 21
- Local Resource Management Area 21
- National Park 20
- Federal Other or Unknown 18
- National Monument or Landmark 17
- Private Agricultural 9
- Conservation Area 6
- Wilderness Area 6
- National Public Lands 3
- Historic or Cultural Area 3
- Private Historic or Cultural 3
- State Wilderness 2
- Area of Critical Environmental Concern 2
- …
ACCESS_TYP 4
- Open Access 9,012
- Restricted Access 687
- No Public Access 588
- Unknown Access 188
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1128 | 1128 | 1127 | {"type": "MultiPolygon", "coordinates": [[[[-118.65001, 34.07927], [-118.64902, 34.07928], [-118.6491, 34.07916], [-118.64914, 34.07903], [-118.64913, 34.07888], [-118.64909, 34.07874], [-118.64901, 34.07862], [-118.64888, 34.07851], [-118.64873, 34.07843], [-118.64854, 34.07839], [-118.64834, 34.07839], [-118.64815, 34.07844], [-118.64681, 34.07901], [-118.64666, 34.07901], [-118.64638, 34.07905], [-118.64564, 34.07927], [-118.64543, 34.07928], [-118.64496, 34.07925], [-118.64461, 34.07919], [-118.64334, 34.07882], [-118.64322, 34.07877], [-118.64307, 34.07863], [-118.64299, 34.07846], [-118.64299, 34.07832], [-118.64303, 34.0782], [-118.64313, 34.07807], [-118.64333, 34.0779], [-118.64352, 34.07783], [-118.64373, 34.07769], [-118.64454, 34.07796], [-118.6449, 34.0779], [-118.64493, 34.0781], [-118.6456, 34.07833], [-118.65, 34.07832], [-118.65001, 34.07927]]], [[[-118.64879, 34.07893], [-118.64876, 34.079], [-118.64867, 34.07908], [-118.64557, 34.08106], [-118.64541, 34.08113], [-118.64518, 34.08114], [-118.64488, 34.08105], [-118.64479, 34.08105], [-118.64464, 34.08108], [-118.64452, 34.08114], [-118.64397, 34.08117], [-118.64382, 34.08117], [-118.64366, 34.08083], [-118.64334, 34.08006], [-118.64335, 34.08001], [-118.64344, 34.08002], [-118.64352, 34.08], [-118.64361, 34.07994], [-118.64367, 34.07987], [-118.6438, 34.0792], [-118.64493, 34.07943], [-118.6452, 34.07946], [-118.64544, 34.07946], [-118.64594, 34.07942], [-118.64631, 34.07935], [-118.64668, 34.07924], [-118.64684, 34.07918], [-118.64743, 34.07918], [-118.64762, 34.07915], [-118.64778, 34.07909], [-118.64793, 34.07901], [-118.64809, 34.07888], [-118.64829, 34.07866], [-118.6484, 34.07862], [-118.64858, 34.07862], [-118.64871, 34.07869], [-118.64877, 34.07878], [-118.64879, 34.07893]]], [[[-118.64799, 34.07869], [-118.64782, 34.07887], [-118.64765, 34.07896], [-118.64747, 34.07901], [-118.64723, 34.07901], [-118.64799, 34.07869]]], [[[-118.64889, 34.07913], [-118.64884, 34.07921], [-118.64877, 34.07927], [-118.64851, 34.0794], [-118.64883, 34.0792], [-118.64889, 34.07913]]]]} | Open Access 1 | 7215 | Hepatic Gulch Open Space | 14226 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 29.855 | Hepatic Gulch OS | 0 | Recreation Management Area 49 | 4 | |
6291 | 6291 | 6290 | {"type": "Polygon", "coordinates": [[[-121.24447, 38.2956], [-121.24433, 38.29571], [-121.24395, 38.2959], [-121.24332, 38.29626], [-121.24327, 38.29627], [-121.24321, 38.29625], [-121.24323, 38.29563], [-121.24327, 38.29546], [-121.24333, 38.29535], [-121.24343, 38.29529], [-121.24365, 38.29521], [-121.24382, 38.29521], [-121.24402, 38.29524], [-121.24425, 38.29534], [-121.24431, 38.29542], [-121.24444, 38.29556], [-121.24447, 38.2956]]]} | Open Access 1 | 48884 | Herald Park | 33605 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | https://regionalparks.saccounty.net/SpecialEventsReservations/Pages/HeraldPark.aspx | Sacramento 41 | 1.953 | Herald Park | 0 | Local Park 2 | 4 |
11758 | 11758 | 11757 | {"type": "Polygon", "coordinates": [[[-121.42469, 38.4338], [-121.42405, 38.4338], [-121.42403, 38.43382], [-121.42397, 38.43381], [-121.42389, 38.43382], [-121.42386, 38.4338], [-121.42355, 38.4338], [-121.42354, 38.43312], [-121.42461, 38.43311], [-121.42466, 38.43313], [-121.42468, 38.43315], [-121.42469, 38.4338]]]} | Open Access 1 | 24051 | Herburger Park | 19831 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.877 | Herburger Park | 0 | Local Park 2 | 4 | |
6559 | 6559 | 6558 | {"type": "Polygon", "coordinates": [[[-122.25538, 38.00159], [-122.25435, 38.00281], [-122.25412, 38.00263], [-122.25336, 38.00223], [-122.25278, 38.00201], [-122.25257, 38.00201], [-122.25192, 38.00158], [-122.25156, 38.00143], [-122.25141, 38.00151], [-122.25101, 38.00123], [-122.25072, 38.00116], [-122.2507, 38.00114], [-122.25022, 38.00086], [-122.25, 38.00083], [-122.24938, 38.00053], [-122.24896, 38.00066], [-122.24856, 38.00072], [-122.24827, 38.00072], [-122.24798, 38.00065], [-122.24767, 38.00048], [-122.24734, 38.00021], [-122.24715, 37.99991], [-122.24686, 37.99835], [-122.24698, 37.99805], [-122.24718, 37.9979], [-122.24752, 37.99777], [-122.24733, 37.99736], [-122.2477, 37.99706], [-122.24827, 37.99756], [-122.24917, 37.99858], [-122.24991, 37.99904], [-122.25092, 37.99953], [-122.25097, 37.99964], [-122.2513, 37.99978], [-122.25136, 37.99971], [-122.25169, 37.99986], [-122.25173, 37.99985], [-122.25202, 38.0], [-122.25509, 38.00144], [-122.25538, 38.00159]]]} | No Public Access 3 | 3421 | Hercules | 19832 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 37.784 | Hercules | None 526 | |||
429 | 429 | 428 | {"type": "Polygon", "coordinates": [[[-117.49266, 34.11629], [-117.4928, 34.1163], [-117.49293, 34.11635], [-117.49305, 34.11641], [-117.49313, 34.11648], [-117.49322, 34.11658], [-117.49327, 34.11668], [-117.4933, 34.11678], [-117.4933, 34.11692], [-117.49327, 34.11701], [-117.49322, 34.11712], [-117.49313, 34.11722], [-117.49304, 34.11729], [-117.49292, 34.11736], [-117.4928, 34.11739], [-117.49267, 34.11741], [-117.49253, 34.11741], [-117.4923, 34.11734], [-117.49218, 34.11728], [-117.49209, 34.1172], [-117.49201, 34.1171], [-117.49197, 34.11701], [-117.49195, 34.11691], [-117.49195, 34.11678], [-117.49197, 34.11669], [-117.49202, 34.11659], [-117.49209, 34.1165], [-117.49219, 34.11642], [-117.49238, 34.11632], [-117.4925, 34.11629], [-117.49266, 34.11629]]]} | Open Access 1 | 1717 | Heritage Circle Park | 19833 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.008 | Heritage Circle Park | 0 | Local Park 2 | 4 | |
521 | 521 | 520 | {"type": "MultiPolygon", "coordinates": [[[[-117.61193, 34.15189], [-117.60787, 34.15443], [-117.60757, 34.15463], [-117.60753, 34.15115], [-117.61191, 34.15114], [-117.61193, 34.15189]]], [[[-117.61195, 34.15478], [-117.60789, 34.1548], [-117.60788, 34.1548], [-117.61193, 34.15227], [-117.61195, 34.15478]]]]} | Open Access 1 | 1723 | Heritage Community Park | 19834 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 36.415 | Heritage Community Park | 0 | Local Park 2 | 4 | |
430 | 430 | 429 | {"type": "Polygon", "coordinates": [[[-117.69087, 33.64713], [-117.69085, 33.64716], [-117.69051, 33.64729], [-117.68995, 33.64727], [-117.68923, 33.64768], [-117.68869, 33.64759], [-117.68877, 33.64738], [-117.68882, 33.64717], [-117.68975, 33.64643], [-117.69027, 33.64681], [-117.69087, 33.64713]]]} | Open Access 1 | 1728 | Heritage Hill Historic Site | 19835 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.228 | Heritage Hill Historic Site | 0 | Local Historic or Cultural Area 19 | 4 | |
16069 | 16069 | 16068 | {"type": "MultiPolygon", "coordinates": [[[[-117.87756, 34.04701], [-117.87755, 34.04709], [-117.87726, 34.04791], [-117.87593, 34.05167], [-117.87586, 34.05064], [-117.87633, 34.04919], [-117.87634, 34.04862], [-117.87427, 34.04854], [-117.87402, 34.04975], [-117.87371, 34.04947], [-117.87361, 34.04941], [-117.87345, 34.04937], [-117.87336, 34.04936], [-117.87317, 34.04939], [-117.87301, 34.04879], [-117.87262, 34.04874], [-117.87209, 34.04938], [-117.87156, 34.05081], [-117.87131, 34.05196], [-117.87111, 34.05116], [-117.87056, 34.04931], [-117.87033, 34.04824], [-117.8703, 34.04824], [-117.86985, 34.04849], [-117.86857, 34.04751], [-117.86825, 34.0478], [-117.86819, 34.04777], [-117.86813, 34.04776], [-117.86807, 34.04777], [-117.86802, 34.0478], [-117.86771, 34.04765], [-117.86755, 34.04784], [-117.86729, 34.04803], [-117.86788, 34.04913], [-117.86752, 34.04928], [-117.86751, 34.04929], [-117.86785, 34.04969], [-117.86834, 34.04995], [-117.86893, 34.05018], [-117.86892, 34.05019], [-117.86885, 34.05029], [-117.86872, 34.05041], [-117.86844, 34.05085], [-117.8674, 34.04942], [-117.86639, 34.04879], [-117.86543, 34.04972], [-117.86625, 34.05109], [-117.86504, 34.05177], [-117.86548, 34.0532], [-117.86604, 34.05363], [-117.86695, 34.0536], [-117.86803, 34.05465], [-117.86786, 34.0546], [-117.86778, 34.05455], [-117.86765, 34.05451], [-117.86746, 34.05447], [-117.86734, 34.05447], [-117.86659, 34.05459], [-117.86638, 34.05458], [-117.86596, 34.05449], [-117.86573, 34.05449], [-117.86562, 34.05452], [-117.86549, 34.05434], [-117.86505, 34.05364], [-117.86482, 34.05333], [-117.86475, 34.05309], [-117.86467, 34.05295], [-117.86452, 34.05272], [-117.86447, 34.0526], [-117.86445, 34.05246], [-117.86436, 34.0523], [-117.86425, 34.05221], [-117.86413, 34.05213], [-117.86358, 34.05196], [-117.86312, 34.05177], [-117.863, 34.0517], [-117.86702, 34.0466], [-117.87163, 34.04832], [-117.87516, 34.04824], [-117.87756, 34.04701]]], [[[-117.87026, 34.05488], [-117.87025, 34.05494], [-117.86677, 34.05491], [-117.8661, 34.05526], [-117.86598, 34.05496], [-117.86574, 34.05466], [-117.86593, 34.05465], [-117.86635, 34.05474], [-117.86653, 34.05476], [-117.86731, 34.05464], [-117.86749, 34.05464], [-117.86761, 34.05467], [-117.86784, 34.05477], [-117.868, 34.05482], [-117.86819, 34.05484], [-117.86833, 34.05484], [-117.8686, 34.0548], [-117.86876, 34.05473], [-117.86888, 34.05467], [-117.86899, 34.05458], [-117.86909, 34.05449], [-117.87026, 34.05488]]], [[[-117.86995, 34.05316], [-117.86977, 34.05316], [-117.86963, 34.053], [-117.86897, 34.05313], [-117.86869, 34.05269], [-117.86843, 34.05168], [-117.86848, 34.05109], [-117.86882, 34.05057], [-117.86899, 34.05068], [-117.86916, 34.05155], [-117.86995, 34.05316]]], [[[-117.87565, 34.06005], [-117.87563, 34.06011], [-117.87558, 34.06016], [-117.87552, 34.06017], [-117.87521, 34.06008], [-117.87494, 34.05998], [-117.87474, 34.05989], [-117.87451, 34.05977], [-117.87413, 34.0595], [-117.87395, 34.05933], [-117.87375, 34.05912], [-117.87301, 34.05819], [-117.87333, 34.05796], [-117.87307, 34.0577], [-117.87314, 34.05717], [-117.87365, 34.05729], [-117.87347, 34.05759], [-117.87394, 34.05889], [-117.87485, 34.05979], [-117.87565, 34.06005]]], [[[-117.8748, 34.05214], [-117.87473, 34.05251], [-117.87396, 34.05242], [-117.87368, 34.05154], [-117.87311, 34.05148], [-117.87389, 34.04984], [-117.87435, 34.05026], [-117.87412, 34.05205], [-117.8748, 34.05214]]], [[[-117.87502, 34.05379], [-117.87493, 34.05393], [-117.87486, 34.05412], [-117.87486, 34.0543], [-117.87488, 34.05436], [-117.87434, 34.05451], [-117.87454, 34.05511], [-117.87397, 34.05668], [-117.87394, 34.05667], [-117.87387, 34.05663], [-117.87369, 34.05648], [-117.87361, 34.05638], [-117.87353, 34.05622], [-117.8735, 34.05605], [-117.87349, 34.05507], [-117.87408, 34.05502], [-117.87405, 34.05466], [-117.87365, 34.05399], [-117.87449, 34.05393], [-117.87455, 34.05359], [-117.87495, 34.05361], [-117.87501, 34.05366], [-117.87502, 34.05379]]], [[[-117.87626, 34.05554], [-117.87619, 34.05563], [-117.87536, 34.05536], [-117.87541, 34.0552], [-117.87541, 34.055], [-117.87538, 34.05491], [-117.87532, 34.05477], [-117.87503, 34.05439], [-117.87499, 34.05425], [-117.875, 34.05411], [-117.87504, 34.054], [-117.87511, 34.05389], [-117.87515, 34.05381], [-117.87516, 34.0537], [-117.87514, 34.05364], [-117.87516, 34.05364], [-117.87517, 34.0536], [-117.87519, 34.05358], [-117.87553, 34.05348], [-117.87564, 34.05343], [-117.87616, 34.05401], [-117.87626, 34.05554]]], [[[-117.87663, 34.06025], [-117.87625, 34.06026], [-117.87583, 34.06022], [-117.8758, 34.06019], [-117.87577, 34.06014], [-117.8758, 34.05999], [-117.8758, 34.05988], [-117.87654, 34.05987], [-117.87663, 34.06025]]]]} | Open Access 1 | 7072 | Heritage Hills Open Space | 19836 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | Los Angeles 6 | 86.42 | Heritage Hills OS | 0 | Local Recreation Area 3 | 4 | |
14312 | 14312 | 14311 | {"type": "Polygon", "coordinates": [[[-117.50464, 34.12099], [-117.50442, 34.121], [-117.50442, 34.1212], [-117.49962, 34.12119], [-117.50229, 34.11894], [-117.50274, 34.11906], [-117.50322, 34.11924], [-117.50361, 34.11945], [-117.50395, 34.1197], [-117.50412, 34.11987], [-117.50414, 34.11992], [-117.50412, 34.11996], [-117.50351, 34.1203], [-117.50346, 34.12031], [-117.50332, 34.12043], [-117.50344, 34.12052], [-117.50352, 34.12054], [-117.50361, 34.12053], [-117.50369, 34.12049], [-117.50378, 34.12041], [-117.50423, 34.12017], [-117.50427, 34.12015], [-117.50433, 34.12016], [-117.50437, 34.12019], [-117.50442, 34.12028], [-117.50454, 34.12054], [-117.50461, 34.12077], [-117.50464, 34.12099]], [[-117.49993, 34.12104], [-117.50009, 34.12105], [-117.5001, 34.12101], [-117.49994, 34.121], [-117.49993, 34.12104]]]} | Open Access 1 | 44269 | Heritage Neighborhood Center | 19837 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 16.905 | Heritage Neighborhood Ctr. | 0 | Local Recreation Area 3 | 4 | |
1682 | 1682 | 1681 | {"type": "Polygon", "coordinates": [[[-122.0369, 37.58934], [-122.03679, 37.58946], [-122.03652, 37.5893], [-122.0365, 37.58926], [-122.03659, 37.58916], [-122.0369, 37.58934]]]} | Open Access 1 | 12695 | Heritage Oak Park | 19838 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.139 | Heritage Oak Park | 2000 | Local Park 2 | 4 | |
11088 | 11088 | 11087 | {"type": "Polygon", "coordinates": [[[-121.52004, 38.5459], [-121.51947, 38.54718], [-121.51687, 38.5467], [-121.5169, 38.54634], [-121.51696, 38.54607], [-121.51702, 38.54589], [-121.51716, 38.54559], [-121.51741, 38.54513], [-121.51748, 38.54507], [-121.51756, 38.54507], [-121.52004, 38.5459]]]} | Open Access 1 | 21336 | Heritage Oak Park | 19839 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 10.351 | Heritage Oak Park | 0 | Local Park 2 | 4 | |
1895 | 1895 | 1894 | {"type": "Polygon", "coordinates": [[[-122.08727, 37.3596], [-122.08625, 37.35958], [-122.08624, 37.35771], [-122.08618, 37.35747], [-122.08608, 37.35729], [-122.08627, 37.35728], [-122.08635, 37.35738], [-122.08663, 37.35765], [-122.08692, 37.35782], [-122.08728, 37.3587], [-122.08734, 37.35889], [-122.08737, 37.35908], [-122.08736, 37.35928], [-122.08733, 37.35944], [-122.08727, 37.3596]]]} | Open Access 1 | 14591 | Heritage Oaks Park | 19840 | 1186 | Los Altos, City of 451 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | Santa Clara 19 | 4.684 | Heritage Oaks Park | 2000 | Local Park 2 | 4 | |
1013 | 1013 | 1012 | {"type": "Polygon", "coordinates": [[[-117.77666, 34.12771], [-117.77648, 34.12776], [-117.77611, 34.1278], [-117.7758, 34.12781], [-117.77566, 34.12789], [-117.77553, 34.128], [-117.77517, 34.12848], [-117.77516, 34.12873], [-117.77513, 34.12876], [-117.77504, 34.12875], [-117.77491, 34.12831], [-117.77483, 34.12796], [-117.77483, 34.12784], [-117.77492, 34.12751], [-117.77553, 34.12759], [-117.77594, 34.12763], [-117.77604, 34.12765], [-117.77661, 34.12766], [-117.77665, 34.12768], [-117.77666, 34.12771]]]} | Open Access 1 | 6795 | Heritage Park | 19851 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 1.913 | Heritage Park | 0 | Local Park 2 | 4 | |
1074 | 1074 | 1073 | {"type": "Polygon", "coordinates": [[[-118.06361, 33.86403], [-118.06242, 33.86403], [-118.0624, 33.86397], [-118.06237, 33.86394], [-118.06227, 33.8639], [-118.06219, 33.86391], [-118.0621, 33.86397], [-118.06202, 33.86399], [-118.05989, 33.864], [-118.05986, 33.86224], [-118.06149, 33.86223], [-118.0615, 33.8625], [-118.06309, 33.86249], [-118.0631, 33.86291], [-118.06351, 33.8629], [-118.06351, 33.86249], [-118.06359, 33.86248], [-118.06361, 33.86403]]]} | Open Access 1 | 5660 | Heritage Park | 19843 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 14.909 | Heritage Park | 0 | Local Park 2 | 4 | |
1075 | 1075 | 1074 | {"type": "Polygon", "coordinates": [[[-117.71322, 34.01347], [-117.71112, 34.01349], [-117.7111, 34.01176], [-117.7132, 34.01175], [-117.71322, 34.01347]]]} | Open Access 1 | 5661 | Heritage Park | 19844 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/heritage-park | San Bernardino 22 | 9.153 | Heritage Park | 0 | Local Park 2 | 4 |
1076 | 1076 | 1075 | {"type": "Polygon", "coordinates": [[[-117.93514, 33.73981], [-117.93478, 33.74004], [-117.93455, 33.74022], [-117.93426, 33.74049], [-117.93398, 33.7408], [-117.93383, 33.74101], [-117.93354, 33.74148], [-117.93336, 33.74182], [-117.9331, 33.74245], [-117.93308, 33.74147], [-117.93261, 33.74146], [-117.93261, 33.73985], [-117.93299, 33.73995], [-117.93393, 33.73994], [-117.93402, 33.73984], [-117.93402, 33.73981], [-117.93514, 33.73981]]]} | Open Access 1 | 5664 | Heritage Park | 19854 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.795 | Heritage Park | 0 | Local Park 2 | 4 | |
1077 | 1077 | 1076 | {"type": "Polygon", "coordinates": [[[-117.78086, 33.70027], [-117.78075, 33.70072], [-117.7807, 33.7008], [-117.7806, 33.70085], [-117.78027, 33.70086], [-117.78023, 33.70088], [-117.78016, 33.70097], [-117.77979, 33.70281], [-117.77977, 33.70299], [-117.77956, 33.70288], [-117.77939, 33.70284], [-117.77925, 33.70283], [-117.77909, 33.70284], [-117.77894, 33.70289], [-117.77872, 33.7031], [-117.77862, 33.7033], [-117.7785, 33.70404], [-117.77844, 33.70421], [-117.77816, 33.70418], [-117.77764, 33.7034], [-117.77759, 33.70343], [-117.77669, 33.70213], [-117.77721, 33.70186], [-117.7765, 33.70075], [-117.77767, 33.69954], [-117.77828, 33.69995], [-117.77854, 33.69994], [-117.7791, 33.69938], [-117.77899, 33.69929], [-117.77925, 33.69903], [-117.78064, 33.69999], [-117.78058, 33.70006], [-117.78086, 33.70027]], [[-117.77835, 33.70067], [-117.7784, 33.70062], [-117.77849, 33.70056], [-117.77867, 33.70047], [-117.77872, 33.7004], [-117.77873, 33.70033], [-117.77872, 33.70027], [-117.77867, 33.70022], [-117.7786, 33.70018], [-117.77853, 33.70018], [-117.77843, 33.7002], [-117.77835, 33.70024], [-117.77829, 33.7003], [-117.77818, 33.70055], [-117.77812, 33.70062], [-117.77795, 33.70075], [-117.77791, 33.7008], [-117.7779, 33.70088], [-117.77797, 33.70102], [-117.77798, 33.70109], [-117.77795, 33.70119], [-117.77797, 33.70127], [-117.77801, 33.7013], [-117.77813, 33.70132], [-117.7783, 33.70128], [-117.77836, 33.70125], [-117.77847, 33.70114], [-117.77852, 33.70104], [-117.77853, 33.70097], [-117.7785, 33.7009], [-117.77834, 33.70074], [-117.77835, 33.70067]]]} | Open Access 1 | 5665 | Heritage Park | 19850 | 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 | 29.375 | Heritage Park | 0 | Local Park 2 | 4 | |
1078 | 1078 | 1077 | {"type": "Polygon", "coordinates": [[[-117.57751, 33.84415], [-117.57745, 33.84458], [-117.57741, 33.84466], [-117.57731, 33.84478], [-117.57728, 33.84484], [-117.57731, 33.84492], [-117.57738, 33.84498], [-117.57734, 33.8453], [-117.57585, 33.84516], [-117.57613, 33.84334], [-117.57618, 33.84334], [-117.57617, 33.84345], [-117.57612, 33.84363], [-117.57612, 33.84368], [-117.57618, 33.84379], [-117.57626, 33.84383], [-117.57623, 33.84413], [-117.57666, 33.84413], [-117.5769, 33.8441], [-117.57751, 33.84415]]]} | Open Access 1 | 5668 | Heritage Park | 19846 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 4.401 | Heritage Park | 0 | Local Park 2 | 4 | |
1096 | 1096 | 1095 | {"type": "Polygon", "coordinates": [[[-117.84397, 33.97359], [-117.84302, 33.97478], [-117.84226, 33.97435], [-117.84321, 33.97317], [-117.84397, 33.97359]]]} | Open Access 1 | 7051 | Heritage Park | 19848 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 3.321 | Heritage Park | 0 | Local Park 2 | 4 | |
1241 | 1241 | 1240 | {"type": "Polygon", "coordinates": [[[-117.8726, 34.05496], [-117.87256, 34.05763], [-117.87241, 34.05747], [-117.8721, 34.05723], [-117.87146, 34.05685], [-117.87082, 34.05667], [-117.87053, 34.0566], [-117.87027, 34.05658], [-117.87028, 34.05562], [-117.87025, 34.05561], [-117.87026, 34.05429], [-117.87106, 34.05432], [-117.87173, 34.05453], [-117.8726, 34.05496]]]} | Open Access 1 | 7076 | Heritage Park | 19859 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | Los Angeles 6 | 14.33 | Heritage 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]);