units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,626
- County Agency 1,129
- Recreation/Parks District 1,117
- State Agency 1,114
- Non Profit - Land Trust 586
- Federal Agency 498
- Open Space District 405
- Water District 235
- County Agency - Parks 228
- Home Owners Association 203
- Community Services District 197
- Non Profit - Conservation 148
- Flood District 104
- Irrigation District 49
- Cemetery District 46
- Non Profit - Other 45
- School District 38
- County Agency - Other 34
- Port/Harbor District 29
- 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
- …
MNG_AGENCY >30
- San Diego, City of 477
- Los Angeles, City of 437
- California Department of Fish and Wildlife 434
- California Department of Parks and Recreation 372
- Mountains Recreation and Conservation Authority 329
- San Jose, City of 233
- Sacramento, City of 220
- San Francisco, City and County of 198
- East Bay Regional Park District 164
- Los Angeles, County of 154
- Ventura, City of 144
- Roseville, City of 130
- Long Beach, City of 129
- Oakland, City of 119
- United States Bureau of Land Management 117
- Santa Barbara, County of 110
- United States Forest Service 105
- San Diego, County of 105
- Irvine, City of 98
- Consumnes Community Services District 94
- Orange, County of 85
- Modesto, City of 85
- California State Lands Commission 83
- United States Fish and Wildlife Service 82
- United States National Park Service 82
- Hayward Area Recreation and Park District 82
- Stockton, City of 81
- Napa, City of 81
- Santa Rosa, City of 79
- Tracy, City of 73
- …
DES_TP >30
- Local Park 8,484
- Local Recreation Area 1,902
- Local Other or Unknown 1,176
- Private Conservation 615
- Local Conservation Area 465
- State Conservation Area 374
- Private Recreation or Education 268
- State Park 204
- State Resource Management Area 159
- State Recreation Area 140
- Local Historic or Cultural Area 96
- National Forest 92
- National Wildlife Refuge 74
- National Public Lands 72
- State Other or Unknown 68
- State Historic or Cultural Area 63
- Recreation Management Area 58
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 37
- Resource Management Area 26
- National Park 24
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 13
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 13,355
- Restricted Access 1,203
- No Public Access 969
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1235 | 1235 | 1234 | {"type": "Polygon", "coordinates": [[[-118.17369, 33.96951], [-118.1736, 33.97012], [-118.17246, 33.97], [-118.17256, 33.96943], [-118.17258, 33.9694], [-118.17369, 33.96951]]]} | Open Access 1 | 8946 | Pritchard Field | 24012 | 1022 | Bell, City of 336 | City 2 | City Agency 2 | http://www.cityofbell.org/?navid=118 | City 2 | 1022 | Bell, City of 333 | City 2 | City Agency 2 | Los Angeles 6 | 1.763 | Pritchard Field | 0 | Local Recreation Area 3 | 4 | |
1236 | 1236 | 1235 | {"type": "Polygon", "coordinates": [[[-121.79176, 37.32836], [-121.79033, 37.3288], [-121.79007, 37.32825], [-121.79043, 37.32791], [-121.79028, 37.32778], [-121.79036, 37.32774], [-121.79023, 37.32751], [-121.78996, 37.32754], [-121.78992, 37.32741], [-121.79122, 37.32722], [-121.79176, 37.32836]]]} | Open Access 1 | 8978 | Norwood Creek Park | 22906 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.234 | Norwood Creek Park | 1992 | Local Park 2 | 4 | |
1237 | 1237 | 1236 | {"type": "MultiPolygon", "coordinates": [[[[-117.83721, 34.04066], [-117.83646, 34.0409], [-117.83629, 34.04045], [-117.83637, 34.04038], [-117.83637, 34.0403], [-117.83604, 34.03922], [-117.83595, 34.03901], [-117.83583, 34.0388], [-117.83523, 34.03821], [-117.83547, 34.03806], [-117.83532, 34.03769], [-117.83556, 34.03745], [-117.83585, 34.03753], [-117.83604, 34.03754], [-117.83602, 34.0378], [-117.83608, 34.03822], [-117.83613, 34.03844], [-117.83627, 34.03884], [-117.83671, 34.03957], [-117.83721, 34.04066]]], [[[-117.837, 34.03542], [-117.83675, 34.03553], [-117.83609, 34.03718], [-117.83605, 34.03741], [-117.83576, 34.03737], [-117.8356, 34.03731], [-117.83559, 34.0373], [-117.83575, 34.03701], [-117.83591, 34.03682], [-117.83599, 34.03656], [-117.83597, 34.0365], [-117.83601, 34.03648], [-117.83613, 34.03616], [-117.83624, 34.03599], [-117.8363, 34.03575], [-117.8363, 34.03569], [-117.83628, 34.03566], [-117.83633, 34.03562], [-117.83645, 34.03532], [-117.83668, 34.03538], [-117.837, 34.03542]]], [[[-117.83951, 34.03538], [-117.839, 34.0355], [-117.83871, 34.03552], [-117.83662, 34.03522], [-117.83681, 34.03494], [-117.83672, 34.03484], [-117.83677, 34.0348], [-117.83678, 34.03476], [-117.83677, 34.03474], [-117.8369, 34.03471], [-117.83728, 34.03445], [-117.83745, 34.03423], [-117.83739, 34.03413], [-117.83743, 34.03409], [-117.83744, 34.03405], [-117.83829, 34.03353], [-117.83828, 34.03326], [-117.83816, 34.0332], [-117.83817, 34.03312], [-117.83815, 34.0331], [-117.83809, 34.03306], [-117.83812, 34.03301], [-117.83806, 34.03276], [-117.8378, 34.03271], [-117.83789, 34.03236], [-117.83778, 34.03229], [-117.8378, 34.03223], [-117.83778, 34.03217], [-117.8377, 34.03212], [-117.83765, 34.03212], [-117.83759, 34.03185], [-117.83739, 34.03177], [-117.8374, 34.0314], [-117.83728, 34.03133], [-117.8373, 34.03131], [-117.83731, 34.03124], [-117.83728, 34.0312], [-117.83723, 34.03117], [-117.83719, 34.03116], [-117.83719, 34.03105], [-117.83709, 34.03084], [-117.83668, 34.03097], [-117.83641, 34.03097], [-117.83642, 34.03072], [-117.83649, 34.03052], [-117.83655, 34.03041], [-117.83665, 34.0303], [-117.83672, 34.03024], [-117.83689, 34.03013], [-117.83708, 34.03007], [-117.8384, 34.03272], [-117.83843, 34.03285], [-117.83855, 34.03296], [-117.83863, 34.03313], [-117.83853, 34.03317], [-117.83855, 34.03321], [-117.83866, 34.03318], [-117.83899, 34.03386], [-117.83908, 34.03408], [-117.83905, 34.0341], [-117.83907, 34.03414], [-117.8391, 34.03413], [-117.8392, 34.03437], [-117.83944, 34.03504], [-117.83941, 34.03506], [-117.83951, 34.03538]]], [[[-117.84179, 34.03918], [-117.84065, 34.03955], [-117.84049, 34.03896], [-117.83992, 34.0385], [-117.83938, 34.03759], [-117.83924, 34.03723], [-117.83921, 34.03683], [-117.83899, 34.0359], [-117.83877, 34.03565], [-117.83909, 34.03565], [-117.83957, 34.03557], [-117.83963, 34.03558], [-117.83968, 34.03562], [-117.84, 34.03688], [-117.84014, 34.03723], [-117.84035, 34.03764], [-117.84065, 34.03809], [-117.84097, 34.03846], [-117.84115, 34.03863], [-117.84179, 34.03918]]]]} | Open Access 1 | 7063 | Snow Creek Park | 25583 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 29.667 | Snow Creek Park | 0 | Local Park 2 | 4 | |
1238 | 1238 | 1237 | {"type": "Polygon", "coordinates": [[[-117.90357, 34.04177], [-117.90199, 34.04524], [-117.90201, 34.04526], [-117.90197, 34.0453], [-117.9019, 34.04545], [-117.90185, 34.04562], [-117.90185, 34.04576], [-117.90191, 34.04595], [-117.89926, 34.04592], [-117.89933, 34.04073], [-117.90357, 34.04177]]]} | Open Access 1 | 7071 | Galster Wilderness Park | 19180 | 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 | 40.865 | Galster Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1239 | 1239 | 1238 | {"type": "Polygon", "coordinates": [[[-117.91673, 34.03954], [-117.91669, 34.03967], [-117.91661, 34.03977], [-117.91653, 34.03985], [-117.91626, 34.03999], [-117.91602, 34.04007], [-117.9157, 34.0404], [-117.91547, 34.0407], [-117.91533, 34.04067], [-117.91519, 34.04059], [-117.91507, 34.0406], [-117.91496, 34.04058], [-117.91476, 34.0405], [-117.91458, 34.04038], [-117.91455, 34.04033], [-117.91453, 34.04026], [-117.91445, 34.04018], [-117.91428, 34.04014], [-117.91425, 34.04013], [-117.91421, 34.04004], [-117.91414, 34.03995], [-117.91418, 34.03992], [-117.91451, 34.03984], [-117.91534, 34.03877], [-117.91519, 34.03817], [-117.91544, 34.03825], [-117.91557, 34.0381], [-117.91565, 34.03812], [-117.91576, 34.03809], [-117.9158, 34.03803], [-117.91581, 34.03799], [-117.91606, 34.03806], [-117.91622, 34.0378], [-117.91629, 34.03783], [-117.91628, 34.03785], [-117.91642, 34.03801], [-117.91637, 34.03806], [-117.91635, 34.03811], [-117.91659, 34.03832], [-117.91668, 34.03836], [-117.91668, 34.0384], [-117.91665, 34.0385], [-117.91665, 34.03865], [-117.91673, 34.03954]]]} | Open Access 1 | 7074 | Woodgrove Park | 29905 | 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 | 10.006 | Woodgrove Park | 0 | Local Park 2 | 4 | |
1240 | 1240 | 1239 | {"type": "Polygon", "coordinates": [[[-117.90983, 34.02504], [-117.90973, 34.02515], [-117.90941, 34.02544], [-117.90758, 34.02543], [-117.90758, 34.0257], [-117.90745, 34.0257], [-117.90745, 34.02542], [-117.90751, 34.0252], [-117.90737, 34.02485], [-117.90737, 34.02385], [-117.90734, 34.02368], [-117.90719, 34.02346], [-117.90729, 34.02331], [-117.9079, 34.02352], [-117.90785, 34.02359], [-117.90786, 34.02366], [-117.90789, 34.0237], [-117.90783, 34.02375], [-117.90787, 34.02401], [-117.90943, 34.02387], [-117.90945, 34.02446], [-117.90947, 34.02459], [-117.90953, 34.02473], [-117.90961, 34.02485], [-117.90978, 34.02501], [-117.90983, 34.02504]]]} | Open Access 1 | 7075 | Gingrich Park | 19299 | 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 | 8.932 | Gingrich 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 | |
1242 | 1242 | 1241 | {"type": "MultiPolygon", "coordinates": [[[[-121.77122, 37.32389], [-121.77105, 37.32387], [-121.77102, 37.32367], [-121.77098, 37.32363], [-121.77095, 37.32344], [-121.77113, 37.32346], [-121.77115, 37.32364], [-121.77119, 37.32368], [-121.77122, 37.32389]]], [[[-121.77133, 37.32443], [-121.77116, 37.32444], [-121.77111, 37.32402], [-121.77128, 37.32402], [-121.77133, 37.32443]]], [[[-121.77142, 37.32496], [-121.77125, 37.32498], [-121.77117, 37.32458], [-121.77135, 37.32456], [-121.77142, 37.32496]]]]} | Open Access 1 | 9136 | Pocket Park No. 4 | 23834 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.527 | PP No. 4 | 2004 | Local Park 2 | 4 | |
1243 | 1243 | 1242 | {"type": "Polygon", "coordinates": [[[-118.25098, 34.17212], [-118.25095, 34.17243], [-118.25087, 34.17251], [-118.25076, 34.17252], [-118.25042, 34.17245], [-118.25036, 34.17242], [-118.25034, 34.17238], [-118.25034, 34.17208], [-118.2503, 34.17197], [-118.25018, 34.17186], [-118.24999, 34.1718], [-118.24996, 34.17176], [-118.25, 34.17174], [-118.2503, 34.17172], [-118.25062, 34.1719], [-118.25084, 34.17211], [-118.25098, 34.17212]]]} | Open Access 1 | 7146 | City of Glendale Open Space | 17315 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.988 | City of Glendale OS | 0 | Local Recreation Area 3 | 4 | |
1244 | 1244 | 1243 | {"type": "Polygon", "coordinates": [[[-118.75782, 34.14997], [-118.75728, 34.1502], [-118.75717, 34.15022], [-118.75588, 34.15073], [-118.75575, 34.15081], [-118.75566, 34.15093], [-118.75562, 34.15105], [-118.75565, 34.15116], [-118.75578, 34.15144], [-118.7558, 34.15161], [-118.75578, 34.15167], [-118.75575, 34.15168], [-118.75537, 34.15161], [-118.75497, 34.15156], [-118.75442, 34.15158], [-118.7544, 34.15156], [-118.7543, 34.15109], [-118.75429, 34.15092], [-118.7543, 34.15034], [-118.75437, 34.15019], [-118.75443, 34.15012], [-118.75454, 34.15006], [-118.75517, 34.14985], [-118.75535, 34.14977], [-118.75551, 34.14964], [-118.75559, 34.14954], [-118.75564, 34.14946], [-118.75571, 34.14928], [-118.75696, 34.14927], [-118.75696, 34.14847], [-118.75721, 34.14848], [-118.7572, 34.14881], [-118.75728, 34.14907], [-118.75782, 34.14997]]]} | Open Access 1 | 7084 | Chumash Park | 17244 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 12.237 | Chumash Park | 0 | Local Park 2 | 4 | |
1245 | 1245 | 1244 | {"type": "Polygon", "coordinates": [[[-118.69322, 34.16142], [-118.69181, 34.16257], [-118.69104, 34.16222], [-118.69115, 34.16183], [-118.69132, 34.16146], [-118.69151, 34.16115], [-118.69177, 34.16082], [-118.69208, 34.16051], [-118.69243, 34.16025], [-118.69282, 34.16001], [-118.6932, 34.15983], [-118.69322, 34.16142]]]} | Open Access 1 | 7095 | Gates Canyon Park | 19232 | 1040 | Calabasas, City of 313 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | Los Angeles 6 | 8.306 | Gates Canyon Park | 0 | Local Park 2 | 4 | |
1246 | 1246 | 1245 | {"type": "Polygon", "coordinates": [[[-122.27628, 37.89224], [-122.2759, 37.8923], [-122.27586, 37.89215], [-122.2762, 37.89203], [-122.27628, 37.89224]]]} | Open Access 1 | 44896 | Contra Costa Rock Park | 17607 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.169 | Contra Costa Rock Park | 0 | Local Park 2 | 4 | |
1248 | 1248 | 1247 | {"type": "Polygon", "coordinates": [[[-118.33325, 34.04972], [-118.33236, 34.05184], [-118.33135, 34.05158], [-118.33231, 34.04955], [-118.33325, 34.04972]]]} | Open Access 1 | 9240 | Queen Anne Recreation Center | 24060 | 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.637 | Queen Anne Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1249 | 1249 | 1248 | {"type": "Polygon", "coordinates": [[[-118.74028, 34.14602], [-118.74025, 34.14701], [-118.74023, 34.14701], [-118.74007, 34.14713], [-118.73888, 34.14804], [-118.73793, 34.1474], [-118.7382, 34.14683], [-118.73883, 34.14538], [-118.73887, 34.14538], [-118.73978, 34.14564], [-118.7397, 34.14577], [-118.7399, 34.14588], [-118.74001, 34.14577], [-118.74025, 34.14595], [-118.74028, 34.14602]]]} | Open Access 1 | 7089 | Old Agoura Park | 23080 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 9.855 | Old Agoura Park | 0 | Local Park 2 | 4 | |
1250 | 1250 | 1249 | {"type": "Polygon", "coordinates": [[[-118.44667, 34.27166], [-118.44626, 34.27196], [-118.44604, 34.27175], [-118.44645, 34.27145], [-118.44667, 34.27166]]]} | Open Access 1 | 45527 | Fox and Laurel Park | 28361 | 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 | 0.377 | Fox and Laurel Park | 0 | Local Park 2 | 4 | |
1251 | 1251 | 1250 | {"type": "Polygon", "coordinates": [[[-118.70902, 34.1269], [-118.70783, 34.12774], [-118.70746, 34.12721], [-118.70711, 34.12683], [-118.70688, 34.12662], [-118.70665, 34.12643], [-118.70665, 34.1264], [-118.70664, 34.12641], [-118.706, 34.12586], [-118.706, 34.12581], [-118.70618, 34.12564], [-118.70635, 34.12543], [-118.70855, 34.12542], [-118.70846, 34.12562], [-118.7083, 34.12571], [-118.7079, 34.12578], [-118.7076, 34.12579], [-118.70733, 34.12582], [-118.70712, 34.12589], [-118.70674, 34.12627], [-118.70675, 34.12628], [-118.70711, 34.12593], [-118.70734, 34.12586], [-118.7076, 34.12583], [-118.70792, 34.12583], [-118.70832, 34.12574], [-118.70854, 34.12563], [-118.70872, 34.12541], [-118.709, 34.12542], [-118.70902, 34.1269]], [[-118.70668, 34.12638], [-118.70667, 34.12637], [-118.70666, 34.12639], [-118.70667, 34.12639], [-118.70668, 34.12638]], [[-118.70671, 34.12634], [-118.7067, 34.12633], [-118.70669, 34.12634], [-118.7067, 34.12635], [-118.70671, 34.12634]], [[-118.70674, 34.1263], [-118.70673, 34.12629], [-118.70671, 34.12632], [-118.70672, 34.12632], [-118.70674, 34.1263]]]} | Open Access 1 | 7098 | Juan Bautista de Anza Park | 20512 | 1040 | Calabasas, City of 313 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation/deanza.html | Los Angeles 6 | 11.191 | Juan Bautista de Anza Park | 0 | Local Park 2 | 4 |
1252 | 1252 | 1251 | {"type": "Polygon", "coordinates": [[[-118.71115, 34.14166], [-118.71115, 34.14319], [-118.71031, 34.14318], [-118.71032, 34.14181], [-118.71115, 34.14166]]]} | Open Access 1 | 7099 | Grape Arbor Park | 19445 | 1040 | Calabasas, City of 313 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | Los Angeles 6 | 3.056 | Grape Arbor Park | 0 | Local Park 2 | 4 | |
1253 | 1253 | 1252 | {"type": "Polygon", "coordinates": [[[-118.79537, 34.15242], [-118.79497, 34.15286], [-118.79441, 34.15335], [-118.79391, 34.15297], [-118.79391, 34.15293], [-118.79386, 34.15288], [-118.79379, 34.15286], [-118.79376, 34.15286], [-118.79359, 34.15274], [-118.79355, 34.15277], [-118.79327, 34.15256], [-118.79328, 34.1525], [-118.7939, 34.15196], [-118.79424, 34.15222], [-118.79482, 34.15185], [-118.79537, 34.15242]]]} | Open Access 1 | 7100 | Russell Ranch Park | 24743 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 4.205 | Russell Ranch Park | 0 | Local Park 2 | 4 | |
1254 | 1254 | 1253 | {"type": "Polygon", "coordinates": [[[-118.79338, 34.16493], [-118.79331, 34.16496], [-118.79273, 34.16504], [-118.7925, 34.16505], [-118.79222, 34.16501], [-118.7921, 34.16497], [-118.79177, 34.16483], [-118.79154, 34.16466], [-118.79143, 34.16454], [-118.79197, 34.16423], [-118.79206, 34.16433], [-118.79216, 34.1644], [-118.79235, 34.16448], [-118.79248, 34.16451], [-118.79273, 34.1645], [-118.79324, 34.16438], [-118.79327, 34.1644], [-118.79335, 34.16463], [-118.79338, 34.16493]]]} | Open Access 1 | 7101 | Canyon Oaks Park | 16822 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 2.489 | Canyon Oaks Park | 0 | Local Park 2 | 4 | |
1255 | 1255 | 1254 | {"type": "Polygon", "coordinates": [[[-118.83685, 34.13445], [-118.83636, 34.13472], [-118.83618, 34.13484], [-118.83602, 34.13497], [-118.83556, 34.13457], [-118.83442, 34.13387], [-118.83461, 34.13313], [-118.83489, 34.13312], [-118.83581, 34.13331], [-118.83628, 34.1336], [-118.83641, 34.13392], [-118.83685, 34.13445]]]} | Open Access 1 | 7102 | Three Springs Park | 26334 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 6.208 | Three Springs 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]);