units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 5,716
- County Agency 1,219
- Recreation/Parks District 1,162
- State Agency 1,141
- Non Profit - Land Trust 601
- Open Space District 428
- Water District 238
- County Agency - Parks 236
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- Airport District 1
- …
MNG_AGENCY >30
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 351
- San Diego, City of 242
- Los Angeles, City of 210
- Los Angeles, County of 175
- East Bay Regional Park District 167
- San Jose, City of 146
- Sacramento, City of 145
- San Diego, County of 123
- Santa Barbara, County of 119
- Ventura, City of 114
- Roseville, City of 98
- Orange, County of 95
- Consumnes Community Services District 94
- California State Lands Commission 86
- Hayward Area Recreation and Park District 84
- Oakland, City of 81
- San Francisco, City and County of 71
- Long Beach, City of 69
- Valley-Wide Recreation and Park District 67
- Los Angeles - Department of Parks and Recreation, County of 65
- Irvine, City of 62
- Napa, City of 59
- University of California 58
- Davis, City of 57
- Lake, County of 56
- Stockton, City of 56
- Sacramento, County of 56
- Santa Clara County Parks and Recreation Dept., County of 55
- …
DES_TP >30
- Local Park 5,675
- Local Recreation Area 1,434
- Local Other or Unknown 1,023
- Private Conservation 629
- Local Conservation Area 417
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 96
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Private Other or Unknown 51
- Local Resource Management Area 21
- National Monument or Landmark 15
- Private Agricultural 12
- National Recreation Area 6
- National Wildlife Refuge 4
- Private Historic or Cultural 4
- National Forest 3
- State Wilderness 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 9,532
- Restricted Access 1,007
- No Public Access 839
- Unknown Access 365
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7349 | 7349 | 7348 | {"type": "Polygon", "coordinates": [[[-118.17831, 33.79133], [-118.1783, 33.79257], [-118.17831, 33.79275], [-118.17797, 33.79275], [-118.17795, 33.79266], [-118.17746, 33.79266], [-118.17745, 33.79307], [-118.17742, 33.79308], [-118.17742, 33.7934], [-118.17642, 33.7934], [-118.17643, 33.79133], [-118.17831, 33.79133]]]} | Open Access 1 | 6671 | Martin Luther King Jr. Park | 21912 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 8.322 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
7350 | 7350 | 7349 | {"type": "Polygon", "coordinates": [[[-118.19306, 33.80927], [-118.19306, 33.8111], [-118.19251, 33.81108], [-118.19251, 33.8112], [-118.19208, 33.81133], [-118.1906, 33.80809], [-118.19282, 33.80809], [-118.19281, 33.80926], [-118.19306, 33.80927]]]} | Open Access 1 | 6672 | Veterans Park | 27045 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 13.027 | Veterans Park | 0 | Local Park 2 | 4 | |
7351 | 7351 | 7350 | {"type": "MultiPolygon", "coordinates": [[[[-118.20441, 33.8045], [-118.20433, 33.8046], [-118.20414, 33.8046], [-118.20413, 33.80458], [-118.20401, 33.80458], [-118.204, 33.8046], [-118.20355, 33.8046], [-118.20349, 33.80463], [-118.20345, 33.80467], [-118.20344, 33.80477], [-118.2025, 33.80477], [-118.20246, 33.80475], [-118.20246, 33.8046], [-118.20249, 33.8046], [-118.20249, 33.80452], [-118.20251, 33.8045], [-118.20441, 33.8045]]], [[[-118.20458, 33.81893], [-118.20429, 33.81892], [-118.20427, 33.81165], [-118.20428, 33.81154], [-118.20428, 33.80838], [-118.20426, 33.80766], [-118.20426, 33.80502], [-118.20428, 33.80502], [-118.20431, 33.80542], [-118.20447, 33.80664], [-118.20455, 33.80772], [-118.20454, 33.81285], [-118.20458, 33.81507], [-118.20457, 33.81568], [-118.20458, 33.81609], [-118.20454, 33.81631], [-118.20458, 33.81654], [-118.20453, 33.81736], [-118.20458, 33.81893]]]]} | Open Access 1 | 6673 | Willow & Golden N | 29903 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 9.937 | Willow & Golden N | None 608 | |||
7352 | 7352 | 7351 | {"type": "Polygon", "coordinates": [[[-118.41002, 34.00484], [-118.40588, 34.00996], [-118.40577, 34.00989], [-118.40592, 34.00969], [-118.40614, 34.00934], [-118.40986, 34.00475], [-118.41002, 34.00484]]]} | Open Access 1 | 6675 | Culver Boulevard Median Bicycle Path | 17851 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 3.049 | Culver Boulevard Median Bicycle Path | 0 | Local Recreation Area 3 | 4 | |
7353 | 7353 | 7352 | {"type": "Polygon", "coordinates": [[[-118.12999, 33.81894], [-118.12997, 33.82212], [-118.12801, 33.82211], [-118.12799, 33.8221], [-118.12797, 33.82208], [-118.12797, 33.82135], [-118.12799, 33.81897], [-118.12804, 33.81894], [-118.12999, 33.81894]]]} | Open Access 1 | 6677 | Wardlow Park | 27258 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 16.103 | Wardlow Park | 0 | Local Park 2 | 4 | |
7354 | 7354 | 7353 | {"type": "MultiPolygon", "coordinates": [[[[-118.18761, 33.80427], [-118.18745, 33.80427], [-118.18686, 33.80389], [-118.18692, 33.80382], [-118.18716, 33.80389], [-118.1873, 33.80394], [-118.18759, 33.80413], [-118.18761, 33.80416], [-118.18761, 33.80427]]], [[[-118.18785, 33.80426], [-118.18769, 33.80427], [-118.18769, 33.80415], [-118.18769, 33.80415], [-118.18785, 33.80426]]]]} | Open Access 1 | 6679 | Fellowship Park | 18869 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.365 | Fellowship Park | 0 | Local Park 2 | 4 | |
7355 | 7355 | 7354 | {"type": "Polygon", "coordinates": [[[-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77172], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10417, 33.77181], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788]]]} | Open Access 1 | 6680 | Channel View Park | 17123 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 5.302 | Channel View Park | 1968 | Local Park 2 | 4 | |
7358 | 7358 | 7357 | {"type": "Polygon", "coordinates": [[[-118.17822, 34.18964], [-118.17819, 34.19263], [-118.17815, 34.193], [-118.17806, 34.19331], [-118.17775, 34.194], [-118.17757, 34.19423], [-118.17747, 34.1946], [-118.17741, 34.19469], [-118.17729, 34.19479], [-118.17719, 34.19492], [-118.17706, 34.19502], [-118.177, 34.19509], [-118.17697, 34.19517], [-118.17693, 34.19538], [-118.1769, 34.19549], [-118.17674, 34.19575], [-118.17662, 34.19598], [-118.17654, 34.19608], [-118.17642, 34.19615], [-118.17623, 34.19631], [-118.17601, 34.19645], [-118.1759, 34.19658], [-118.17584, 34.19671], [-118.17584, 34.19695], [-118.17579, 34.19709], [-118.17519, 34.19783], [-118.17511, 34.19796], [-118.17507, 34.19812], [-118.17504, 34.19844], [-118.17312, 34.19845], [-118.17367, 34.19702], [-118.17209, 34.19702], [-118.17208, 34.197], [-118.17202, 34.197], [-118.16906, 34.19982], [-118.16779, 34.20095], [-118.16663, 34.20311], [-118.16533, 34.2031], [-118.16511, 34.20251], [-118.16483, 34.2027], [-118.16472, 34.20273], [-118.16474, 34.20269], [-118.16438, 34.20224], [-118.16431, 34.20209], [-118.16426, 34.20177], [-118.16427, 34.20146], [-118.16398, 34.20148], [-118.16491, 34.20016], [-118.16581, 34.19797], [-118.16694, 34.19597], [-118.16718, 34.19568], [-118.16742, 34.1953], [-118.16788, 34.19436], [-118.1679, 34.19424], [-118.16802, 34.19402], [-118.16816, 34.19406], [-118.16841, 34.19353], [-118.16849, 34.19329], [-118.16854, 34.19304], [-118.16856, 34.19258], [-118.16924, 34.19264], [-118.16937, 34.19244], [-118.16936, 34.19242], [-118.1693, 34.19242], [-118.16975, 34.19217], [-118.17023, 34.19159], [-118.17052, 34.19113], [-118.17061, 34.19012], [-118.17151, 34.18957], [-118.17184, 34.18911], [-118.17208, 34.18782], [-118.17289, 34.18645], [-118.17297, 34.18521], [-118.17253, 34.18359], [-118.17272, 34.18369], [-118.17294, 34.18366], [-118.17316, 34.18346], [-118.1749, 34.1842], [-118.17501, 34.1843], [-118.17509, 34.18438], [-118.17517, 34.18452], [-118.17533, 34.18512], [-118.17554, 34.18545], [-118.17566, 34.18584], [-118.17571, 34.18583], [-118.17587, 34.18584], [-118.17603, 34.18584], [-118.17642, 34.18578], [-118.17659, 34.1858], [-118.17707, 34.186], [-118.17769, 34.18616], [-118.17796, 34.18638], [-118.17824, 34.18664], [-118.17848, 34.18693], [-118.17863, 34.18722], [-118.17873, 34.18752], [-118.17876, 34.18783], [-118.17874, 34.18809], [-118.17866, 34.18836], [-118.17858, 34.18854], [-118.17839, 34.18888], [-118.17828, 34.18915], [-118.17821, 34.18946], [-118.1782, 34.18963], [-118.17822, 34.18964]]]} | Open Access 1 | 6715 | Hahamongna Watershed Park | 8427 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/hahamongna/ | Los Angeles 6 | 303.369 | Hahamongna Watershed Park | 0 | Local Park 2 | 4 |
7360 | 7360 | 7359 | {"type": "Polygon", "coordinates": [[[-118.08782, 34.09166], [-118.08668, 34.09167], [-118.08664, 34.09164], [-118.08661, 34.08959], [-118.08664, 34.08955], [-118.0867, 34.08954], [-118.08774, 34.08992], [-118.08782, 34.09166]]]} | Open Access 1 | 6756 | Sally Tanner Park | 29852 | 2136 | San Gabriel County Water District 858 | Special District 4 | Water District 13 | http://www.sgcwd.com/ | Special District 4 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 5.656 | Sally Tanner Park | 0 | Local Park 2 | 4 | |
7362 | 7362 | 7361 | {"type": "MultiPolygon", "coordinates": [[[[-122.03538, 36.95212], [-122.0353, 36.9523], [-122.03511, 36.95225], [-122.03518, 36.95204], [-122.03522, 36.95204], [-122.03538, 36.95212]]], [[[-122.03616, 36.95249], [-122.03607, 36.9526], [-122.0358, 36.95246], [-122.03587, 36.95235], [-122.03616, 36.95249]]], [[[-122.03706, 36.95292], [-122.03667, 36.95284], [-122.03627, 36.95268], [-122.03635, 36.95258], [-122.03706, 36.95292]]], [[[-122.04335, 36.95119], [-122.04321, 36.95125], [-122.04297, 36.9513], [-122.04287, 36.95135], [-122.04265, 36.95153], [-122.04235, 36.95186], [-122.04223, 36.95178], [-122.04223, 36.95171], [-122.04231, 36.9516], [-122.04243, 36.95156], [-122.04264, 36.95152], [-122.04267, 36.95147], [-122.04272, 36.95142], [-122.04272, 36.95138], [-122.04268, 36.95131], [-122.04269, 36.95129], [-122.04282, 36.95131], [-122.0429, 36.9513], [-122.04301, 36.95127], [-122.04334, 36.95113], [-122.04335, 36.95119]]], [[[-122.04432, 36.95078], [-122.04383, 36.95099], [-122.04383, 36.95099], [-122.04381, 36.9509], [-122.04385, 36.95088], [-122.04395, 36.95083], [-122.04403, 36.95082], [-122.0442, 36.95071], [-122.0443, 36.95067], [-122.04432, 36.95078]]], [[[-122.04653, 36.94982], [-122.04617, 36.95006], [-122.04599, 36.95014], [-122.04589, 36.95017], [-122.04568, 36.95017], [-122.0455, 36.95021], [-122.04547, 36.95006], [-122.04562, 36.95006], [-122.04575, 36.95009], [-122.04581, 36.95012], [-122.04591, 36.95012], [-122.04602, 36.95005], [-122.04606, 36.94995], [-122.04619, 36.94984], [-122.0465, 36.94968], [-122.04653, 36.94982]]]]} | Open Access 1 | 7318 | Cliff Drive Open Space | 17423 | 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 | 1.086 | Cliff Drive OS | 0 | Local Recreation Area 3 | 4 | |
7363 | 7363 | 7362 | {"type": "Polygon", "coordinates": [[[-118.15657, 34.16124], [-118.15621, 34.16175], [-118.15485, 34.16106], [-118.15557, 34.16043], [-118.15657, 34.16124]]]} | Open Access 1 | 6739 | Brenner Park | 16353 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 2.725 | Brenner Park | 0 | Local Park 2 | 4 | |
7364 | 7364 | 7363 | {"type": "Polygon", "coordinates": [[[-118.15055, 34.17015], [-118.14969, 34.17015], [-118.14969, 34.17057], [-118.14924, 34.17058], [-118.14923, 34.16897], [-118.15054, 34.16896], [-118.15055, 34.17015]]]} | Open Access 1 | 6740 | La Pintoresca Park | 20787 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.403 | La Pintoresca Park | 0 | Local Park 2 | 4 | |
7365 | 7365 | 7364 | {"type": "Polygon", "coordinates": [[[-118.12585, 34.14252], [-118.1246, 34.14252], [-118.12459, 34.14175], [-118.12584, 34.14174], [-118.12585, 34.14252]]]} | Open Access 1 | 6742 | Grant Park | 19439 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 2.459 | Grant Park | 0 | Local Park 2 | 4 | |
7366 | 7366 | 7365 | {"type": "Polygon", "coordinates": [[[-118.02524, 33.91003], [-118.02491, 33.91039], [-118.02474, 33.9105], [-118.02445, 33.91062], [-118.02439, 33.91071], [-118.02439, 33.91081], [-118.02457, 33.91117], [-118.02497, 33.91152], [-118.02497, 33.91155], [-118.02481, 33.91165], [-118.0247, 33.9117], [-118.02453, 33.91174], [-118.02436, 33.91177], [-118.02398, 33.91174], [-118.0237, 33.91176], [-118.02373, 33.91172], [-118.02367, 33.91131], [-118.02335, 33.9104], [-118.02332, 33.91038], [-118.02329, 33.91038], [-118.02416, 33.91016], [-118.02429, 33.91011], [-118.02446, 33.91], [-118.02471, 33.90972], [-118.02475, 33.90971], [-118.02478, 33.90971], [-118.02521, 33.90999], [-118.02524, 33.91003]]]} | Open Access 1 | 6772 | Gardenhill Park | 19204 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 5.108 | Gardenhill Park | 0 | Local Park 2 | 4 | |
7367 | 7367 | 7366 | {"type": "Polygon", "coordinates": [[[-117.97195, 33.89573], [-117.97185, 33.89613], [-117.97161, 33.89675], [-117.97149, 33.89687], [-117.97084, 33.89835], [-117.9703, 33.89888], [-117.97025, 33.89903], [-117.97009, 33.89903], [-117.97175, 33.89609], [-117.97178, 33.89573], [-117.97195, 33.89573]]]} | Open Access 1 | 6764 | City of Fullerton Open Space | 17314 | 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 | 1.863 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
7369 | 7369 | 7368 | {"type": "Polygon", "coordinates": [[[-118.10358, 33.92257], [-118.10149, 33.9215], [-118.10149, 33.92101], [-118.10288, 33.92102], [-118.10289, 33.92137], [-118.10357, 33.92137], [-118.10358, 33.92257]]]} | Open Access 1 | 6774 | Bob White Park | 16211 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 1225 | Norwalk, City of 235 | City 2 | City Agency 2 | Los Angeles 6 | 4.771 | Bob White Park | 0 | Local Park 2 | 4 | |
7370 | 7370 | 7369 | {"type": "Polygon", "coordinates": [[[-118.43921, 34.26819], [-118.43853, 34.26946], [-118.43808, 34.26979], [-118.43659, 34.26838], [-118.43713, 34.26827], [-118.43745, 34.26823], [-118.43921, 34.26819]]]} | Open Access 1 | 8130 | Paxton Park | 23537 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.754 | Paxton Park | 0 | Local Park 2 | 4 | |
7372 | 7372 | 7371 | {"type": "MultiPolygon", "coordinates": [[[[-118.16562, 34.20453], [-118.16512, 34.20421], [-118.1647, 34.20441], [-118.16469, 34.20459], [-118.16449, 34.20462], [-118.16415, 34.20437], [-118.16396, 34.20489], [-118.16291, 34.20463], [-118.1636, 34.20418], [-118.16413, 34.20406], [-118.16444, 34.20406], [-118.16559, 34.20393], [-118.16562, 34.20453]]], [[[-118.18394, 34.21609], [-118.18386, 34.21709], [-118.1839, 34.2171], [-118.18375, 34.21832], [-118.18361, 34.21831], [-118.1833, 34.21852], [-118.18323, 34.21871], [-118.18306, 34.21874], [-118.18288, 34.21881], [-118.18278, 34.2188], [-118.18269, 34.21882], [-118.18265, 34.21882], [-118.18257, 34.21876], [-118.18237, 34.21875], [-118.18151, 34.21832], [-118.18112, 34.21818], [-118.18111, 34.21819], [-118.18123, 34.21936], [-118.17894, 34.21936], [-118.17872, 34.21537], [-118.17019, 34.21543], [-118.16438, 34.21525], [-118.16441, 34.21524], [-118.16442, 34.21512], [-118.16438, 34.215], [-118.1645, 34.21494], [-118.16499, 34.21503], [-118.16511, 34.21494], [-118.16511, 34.21492], [-118.165, 34.21484], [-118.16499, 34.21476], [-118.16492, 34.21461], [-118.16505, 34.21441], [-118.16514, 34.21438], [-118.16519, 34.21423], [-118.16563, 34.21397], [-118.16582, 34.2139], [-118.16595, 34.21378], [-118.16602, 34.21376], [-118.16601, 34.21372], [-118.16592, 34.21374], [-118.1658, 34.21388], [-118.16561, 34.21393], [-118.16515, 34.2142], [-118.16511, 34.21436], [-118.16502, 34.21438], [-118.16487, 34.21461], [-118.16496, 34.21476], [-118.16495, 34.21485], [-118.16506, 34.21493], [-118.16498, 34.21499], [-118.1645, 34.21492], [-118.16434, 34.21499], [-118.16438, 34.21512], [-118.16437, 34.21522], [-118.16432, 34.21525], [-118.16343, 34.21522], [-118.16422, 34.21454], [-118.16473, 34.2138], [-118.16493, 34.21327], [-118.16485, 34.21315], [-118.16487, 34.21311], [-118.16482, 34.21311], [-118.16477, 34.21303], [-118.16526, 34.2125], [-118.16524, 34.21243], [-118.16497, 34.21225], [-118.16499, 34.21222], [-118.16503, 34.2122], [-118.16535, 34.21241], [-118.16595, 34.21177], [-118.16663, 34.21178], [-118.16664, 34.21181], [-118.16699, 34.21181], [-118.16724, 34.21175], [-118.16715, 34.21119], [-118.16691, 34.21101], [-118.16605, 34.21001], [-118.16603, 34.20808], [-118.17027, 34.20819], [-118.17026, 34.20534], [-118.17077, 34.20528], [-118.17097, 34.20533], [-118.17119, 34.20528], [-118.17147, 34.20544], [-118.17168, 34.20549], [-118.17235, 34.20573], [-118.1724, 34.20611], [-118.17288, 34.20616], [-118.17353, 34.20606], [-118.17367, 34.20615], [-118.17369, 34.20626], [-118.17367, 34.20632], [-118.17371, 34.20641], [-118.1737, 34.20648], [-118.17365, 34.20653], [-118.17364, 34.2066], [-118.17362, 34.20662], [-118.17336, 34.20689], [-118.17337, 34.2069], [-118.17344, 34.20693], [-118.17386, 34.20671], [-118.17398, 34.20675], [-118.1741, 34.20684], [-118.17413, 34.2069], [-118.17419, 34.2069], [-118.17424, 34.20693], [-118.17474, 34.20652], [-118.1749, 34.20677], [-118.17491, 34.20684], [-118.17487, 34.20696], [-118.17494, 34.20713], [-118.17494, 34.2072], [-118.17487, 34.2074], [-118.17487, 34.20748], [-118.1748, 34.20758], [-118.17481, 34.20759], [-118.17495, 34.20752], [-118.17497, 34.20757], [-118.17499, 34.20757], [-118.17505, 34.20763], [-118.17515, 34.20791], [-118.17503, 34.20803], [-118.17508, 34.20807], [-118.17528, 34.20791], [-118.17527, 34.20789], [-118.17536, 34.20777], [-118.17558, 34.20773], [-118.1756, 34.2077], [-118.17579, 34.20768], [-118.17582, 34.20775], [-118.17575, 34.20777], [-118.17581, 34.2079], [-118.17579, 34.20822], [-118.1762, 34.20876], [-118.17648, 34.20932], [-118.1765, 34.21035], [-118.17613, 34.21084], [-118.17602, 34.21087], [-118.17571, 34.21084], [-118.17541, 34.21071], [-118.17533, 34.21038], [-118.17512, 34.21028], [-118.17494, 34.21108], [-118.17481, 34.21119], [-118.1746, 34.21121], [-118.1746, 34.21124], [-118.17464, 34.21126], [-118.17464, 34.21128], [-118.17482, 34.21138], [-118.17485, 34.21137], [-118.17506, 34.21151], [-118.17513, 34.21164], [-118.17542, 34.21174], [-118.17566, 34.212], [-118.17571, 34.21207], [-118.17574, 34.21208], [-118.17593, 34.21194], [-118.17597, 34.21139], [-118.17605, 34.21137], [-118.17663, 34.21177], [-118.17667, 34.21197], [-118.17666, 34.21203], [-118.1767, 34.21209], [-118.17696, 34.21211], [-118.17729, 34.21217], [-118.17759, 34.21207], [-118.17774, 34.21242], [-118.17797, 34.21278], [-118.1777, 34.21291], [-118.17792, 34.21332], [-118.17798, 34.21339], [-118.17792, 34.2137], [-118.1779, 34.21369], [-118.17775, 34.21372], [-118.1778, 34.21382], [-118.17768, 34.21416], [-118.17838, 34.21445], [-118.1792, 34.21461], [-118.17982, 34.21489], [-118.17984, 34.21533], [-118.18011, 34.21543], [-118.18142, 34.21534], [-118.18231, 34.21574], [-118.18242, 34.21575], [-118.18255, 34.21579], [-118.18394, 34.21609]], [[-118.17123, 34.20986], [-118.1712, 34.20974], [-118.17115, 34.20968], [-118.17071, 34.20923], [-118.17026, 34.20954], [-118.17026, 34.21027], [-118.17128, 34.21028], [-118.17123, 34.20986]]], [[[-118.18482, 34.22101], [-118.1848, 34.22262], [-118.1791, 34.22258], [-118.17898, 34.22018], [-118.18185, 34.22018], [-118.18482, 34.22101]]], [[[-118.18938, 34.22352], [-118.18785, 34.2249], [-118.18778, 34.22497], [-118.18771, 34.22512], [-118.18768, 34.22526], [-118.18768, 34.22539], [-118.18773, 34.22556], [-118.18781, 34.22569], [-118.18809, 34.22598], [-118.18817, 34.22613], [-118.1882, 34.22624], [-118.18819, 34.22647], [-118.18816, 34.22657], [-118.1881, 34.22668], [-118.18802, 34.22678], [-118.18784, 34.22691], [-118.18764, 34.227], [-118.1875, 34.22702], [-118.18729, 34.22703], [-118.18694, 34.22699], [-118.18699, 34.22264], [-118.18887, 34.22266], [-118.18897, 34.22279], [-118.18896, 34.22332], [-118.18907, 34.22347], [-118.18938, 34.22352]]], [[[-118.18963, 34.23825], [-118.18961, 34.23842], [-118.18953, 34.23862], [-118.18943, 34.23874], [-118.18926, 34.23887], [-118.18926, 34.23796], [-118.18677, 34.23787], [-118.18677, 34.23764], [-118.18864, 34.23751], [-118.18891, 34.23753], [-118.18912, 34.23759], [-118.18927, 34.23767], [-118.18946, 34.23783], [-118.18953, 34.23792], [-118.18958, 34.23802], [-118.18962, 34.23814], [-118.18963, 34.23825]]], [[[-118.19823, 34.23605], [-118.19821, 34.23679], [-118.19551, 34.2366], [-118.19546, 34.23975], [-118.18926, 34.23952], [-118.18926, 34.23919], [-118.18946, 34.2391], [-118.18958, 34.23901], [-118.18973, 34.23887], [-118.18987, 34.23865], [-118.18995, 34.23842], [-118.18995, 34.23817], [-118.1899, 34.23794], [-118.18979, 34.23774], [-118.18962, 34.23756], [-118.18949, 34.23746], [-118.18927, 34.23734], [-118.18909, 34.23728], [-118.18883, 34.23724], [-118.18862, 34.23724], [-118.18677, 34.23737], [-118.18677, 34.23596], [-118.18693, 34.22908], [-118.18695, 34.22727], [-118.18743, 34.2273], [-118.18762, 34.22728], [-118.18777, 34.22725], [-118.18794, 34.22718], [-118.18817, 34.22704], [-118.18826, 34.22697], [-118.18839, 34.2268], [-118.18847, 34.22667], [-118.18853, 34.22646], [-118.18854, 34.22635], [-118.18853, 34.22619], [-118.18847, 34.22601], [-118.1884, 34.22589], [-118.18828, 34.22574], [-118.18807, 34.22553], [-118.18804, 34.22547], [-118.188, 34.22532], [-118.18804, 34.22518], [-118.18812, 34.22505], [-118.18823, 34.22497], [-118.18835, 34.22492], [-118.18864, 34.22486], [-118.18874, 34.22481], [-118.18888, 34.22474], [-118.189, 34.22463], [-118.18912, 34.22448], [-118.18927, 34.22418], [-118.1894, 34.22397], [-118.1895, 34.22383], [-118.18973, 34.2236], [-118.18985, 34.22364], [-118.1901, 34.22408], [-118.1902, 34.22456], [-118.19089, 34.22522], [-118.19102, 34.22579], [-118.19124, 34.2263], [-118.19142, 34.22655], [-118.19128, 34.22689], [-118.19122, 34.22697], [-118.19087, 34.22755], [-118.19045, 34.22794], [-118.1907, 34.22869], [-118.19068, 34.22897], [-118.19049, 34.22946], [-118.19034, 34.22997], [-118.19023, 34.23063], [-118.19002, 34.23112], [-118.19052, 34.23146], [-118.19066, 34.23154], [-118.19183, 34.23195], [-118.19227, 34.2322], [-118.19305, 34.23271], [-118.19361, 34.23283], [-118.1939, 34.23294], [-118.19405, 34.23313], [-118.19429, 34.23327], [-118.19458, 34.23332], [-118.19476, 34.23338], [-118.19596, 34.23332], [-118.19682, 34.23489], [-118.19727, 34.23504], [-118.19752, 34.23521], [-118.19823, 34.23605]]], [[[-118.19542, 34.24291], [-118.19527, 34.25152], [-118.19526, 34.25152], [-118.1944, 34.25063], [-118.19425, 34.2504], [-118.19421, 34.25024], [-118.19419, 34.25013], [-118.1942, 34.24997], [-118.19427, 34.24977], [-118.19434, 34.24964], [-118.1946, 34.24935], [-118.19468, 34.24918], [-118.19471, 34.24908], [-118.19474, 34.24889], [-118.19474, 34.24875], [-118.19471, 34.24862], [-118.19463, 34.24862], [-118.19458, 34.24849], [-118.19446, 34.24831], [-118.19429, 34.24815], [-118.19412, 34.24805], [-118.19378, 34.24794], [-118.19273, 34.2478], [-118.19261, 34.24777], [-118.19246, 34.2477], [-118.19227, 34.24755], [-118.19067, 34.24564], [-118.19059, 34.24547], [-118.19058, 34.24527], [-118.19062, 34.24508], [-118.1907, 34.24486], [-118.19073, 34.24469], [-118.19073, 34.24452], [-118.19068, 34.24431], [-118.19058, 34.24411], [-118.19048, 34.24397], [-118.19039, 34.24388], [-118.19026, 34.24377], [-118.18997, 34.24358], [-118.18981, 34.24342], [-118.18972, 34.24323], [-118.18971, 34.24299], [-118.18977, 34.24282], [-118.18988, 34.24281], [-118.1899, 34.24273], [-118.18989, 34.2425], [-118.19542, 34.24291]]]]} | Open Access 1 | 6720 | Upper Arroyo Seco | 8449 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Arroyo_Trails/ | Los Angeles 6 | 616.146 | Upper Arroyo Seco | 0 | None 611 | |
7374 | 7374 | 7373 | {"type": "Polygon", "coordinates": [[[-118.06737, 33.89147], [-118.06737, 33.89226], [-118.06725, 33.89238], [-118.06717, 33.8925], [-118.06712, 33.89265], [-118.0671, 33.89279], [-118.06712, 33.89294], [-118.06717, 33.89306], [-118.06725, 33.89318], [-118.06735, 33.89329], [-118.06735, 33.89488], [-118.06573, 33.89489], [-118.06575, 33.8924], [-118.06465, 33.89238], [-118.06466, 33.89151], [-118.06575, 33.8915], [-118.06576, 33.89148], [-118.06737, 33.89147]]]} | Open Access 1 | 6761 | Holifield Park | 20033 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 1225 | Norwalk, City of 235 | City 2 | City Agency 2 | Los Angeles 6 | 15.986 | Holifield Park | 0 | Local Park 2 | 4 | |
7375 | 7375 | 7374 | {"type": "MultiPolygon", "coordinates": [[[[-117.98765, 33.90292], [-117.98765, 33.90335], [-117.9876, 33.90368], [-117.98739, 33.90458], [-117.98734, 33.90462], [-117.98634, 33.90446], [-117.98612, 33.90441], [-117.9859, 33.90433], [-117.98565, 33.90419], [-117.98544, 33.904], [-117.98527, 33.9038], [-117.98524, 33.90364], [-117.98521, 33.9036], [-117.98511, 33.90356], [-117.98502, 33.9036], [-117.98488, 33.90349], [-117.98521, 33.90315], [-117.9855, 33.90276], [-117.98687, 33.90275], [-117.98688, 33.90286], [-117.98757, 33.90286], [-117.98762, 33.90288], [-117.98765, 33.90292]]], [[[-117.98975, 33.90265], [-117.9879, 33.90266], [-117.98554, 33.90268], [-117.98574, 33.90226], [-117.98587, 33.90182], [-117.98592, 33.90143], [-117.98593, 33.90094], [-117.98973, 33.90093], [-117.98975, 33.90265]]]]} | Restricted Access 2 | 6769 | Behringer Park | 29779 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 26.715 | Behringer 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]);