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_AG_TYP >30
- City Agency 5,088
- Recreation/Parks District 728
- State Agency 726
- County Agency 613
- Federal Agency 287
- Non Profit - Land Trust 265
- Open Space District 194
- Community Services District 152
- County Agency - Parks 140
- Water District 135
- Home Owners Association 125
- Non Profit - Conservation 91
- Flood District 66
- School District 29
- Irrigation District 26
- Non Profit - Other 21
- Cemetery District 13
- County Agency - Other 12
- Special District - Other 11
- Port/Harbor District 10
- Commercial 8
- Joint Powers Authority 7
- Sanitation District 5
- Other 5
- Transportation Agency 5
- Conservation District 4
- Non Profit - Education 3
- Mitigation Bank 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- …
MNG_AGENCY >30
- California Department of Parks and Recreation 275
- California Department of Fish and Wildlife 272
- San Diego, City of 208
- Los Angeles, City of 165
- Sacramento, City of 145
- Mountains Recreation and Conservation Authority 133
- East Bay Regional Park District 128
- San Jose, City of 122
- Ventura, City of 113
- Roseville, City of 97
- Consumnes Community Services District 86
- Los Angeles, County of 78
- Oakland, City of 78
- California State Lands Commission 66
- United States Fish and Wildlife Service 65
- United States Bureau of Land Management 64
- San Francisco, City and County of 64
- United States Forest Service 61
- Long Beach, City of 61
- Napa, City of 59
- Davis, City of 56
- Stockton, City of 56
- Orange, County of 54
- Hayward Area Recreation and Park District 51
- Santa Barbara, County of 49
- Irvine, City of 48
- Modesto, City of 48
- Poway, City of 46
- Tracy, City of 46
- Manteca, City of 45
- …
DES_TP >30
- Local Park 4,354
- Local Recreation Area 1,185
- Local Other or Unknown 730
- Private Conservation 311
- Local Conservation Area 269
- State Conservation Area 265
- State Park 159
- Private Recreation or Education 155
- State Resource Management Area 94
- State Recreation Area 92
- National Wildlife Refuge 59
- National Forest 56
- State Historic or Cultural Area 50
- National Public Lands 41
- Local Historic or Cultural Area 36
- Recreation Management Area 32
- National Monument or Landmark 25
- National Recreation Area 20
- State Other or Unknown 19
- National Park 14
- Local Resource Management Area 13
- Federal Other or Unknown 13
- Conservation Area 9
- Private Agricultural 9
- Private Other or Unknown 9
- Resource Management Area 7
- Historic or Cultural Area 4
- Area of Critical Environmental Concern 4
- Wilderness Area 2
- State Wilderness 1
- …
ACCESS_TYP 4
- Open Access 7,378
- Restricted Access 721
- No Public Access 493
- Unknown Access 182
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8295 | 8295 | 8294 | {"type": "Polygon", "coordinates": [[[-118.44066, 34.32991], [-118.44064, 34.33152], [-118.43961, 34.33184], [-118.43917, 34.33239], [-118.43727, 34.33306], [-118.43591, 34.33306], [-118.43464, 34.33355], [-118.4344, 34.33311], [-118.43366, 34.33287], [-118.43328, 34.33317], [-118.43276, 34.33272], [-118.43306, 34.33152], [-118.43441, 34.33071], [-118.43503, 34.33053], [-118.43502, 34.3299], [-118.43183, 34.32988], [-118.43185, 34.3275], [-118.43215, 34.32748], [-118.43219, 34.32749], [-118.43222, 34.32753], [-118.43237, 34.32753], [-118.43239, 34.32749], [-118.43242, 34.32747], [-118.43272, 34.32745], [-118.43274, 34.32766], [-118.43307, 34.32764], [-118.43308, 34.32772], [-118.43659, 34.32755], [-118.43659, 34.32747], [-118.43694, 34.32744], [-118.43744, 34.32745], [-118.43745, 34.32741], [-118.43782, 34.32741], [-118.43782, 34.3299], [-118.44066, 34.32991]]]} | No Public Access 3 | 12714 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 85.213 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8296 | 8296 | 8295 | {"type": "Polygon", "coordinates": [[[-118.46627, 34.32993], [-118.46601, 34.32993], [-118.466, 34.32966], [-118.46531, 34.32965], [-118.46531, 34.32993], [-118.46492, 34.32992], [-118.4651, 34.32938], [-118.46586, 34.32944], [-118.46627, 34.32993]]]} | No Public Access 3 | 12715 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.889 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8297 | 8297 | 8296 | {"type": "Polygon", "coordinates": [[[-122.02239, 37.53645], [-122.02193, 37.53702], [-122.0216, 37.53688], [-122.0216, 37.53681], [-122.02155, 37.53674], [-122.02091, 37.5364], [-122.02082, 37.5363], [-122.02073, 37.53612], [-122.02064, 37.536], [-122.0205, 37.53588], [-122.0203, 37.53577], [-122.02028, 37.53573], [-122.02049, 37.53547], [-122.02239, 37.53645]]]} | Open Access 1 | 12790 | Byington Park | 16617 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 2.957 | Byington Park | 1984 | Local Park 2 | 4 | |
8298 | 8298 | 8297 | {"type": "Polygon", "coordinates": [[[-118.42996, 34.33076], [-118.42998, 34.3313], [-118.42978, 34.33175], [-118.42986, 34.33266], [-118.42959, 34.33271], [-118.42929, 34.33205], [-118.42879, 34.33196], [-118.4284, 34.33155], [-118.42781, 34.33143], [-118.42735, 34.33145], [-118.42681, 34.33168], [-118.42663, 34.3315], [-118.42709, 34.33123], [-118.42776, 34.33103], [-118.42849, 34.33092], [-118.42842, 34.33034], [-118.42684, 34.33026], [-118.42679, 34.33], [-118.42852, 34.32962], [-118.42869, 34.32985], [-118.42874, 34.32985], [-118.42897, 34.32974], [-118.42912, 34.3296], [-118.42922, 34.32943], [-118.42925, 34.32922], [-118.4294, 34.32923], [-118.4294, 34.32942], [-118.42954, 34.33013], [-118.42957, 34.33017], [-118.42962, 34.3302], [-118.42968, 34.3302], [-118.42974, 34.33019], [-118.4298, 34.33026], [-118.42957, 34.33035], [-118.42956, 34.33037], [-118.42969, 34.33054], [-118.42996, 34.33076]]]} | No Public Access 3 | 12716 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 12.167 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8299 | 8299 | 8298 | {"type": "Polygon", "coordinates": [[[-122.03914, 37.55416], [-122.03903, 37.55429], [-122.03873, 37.55414], [-122.03869, 37.55414], [-122.03865, 37.55416], [-122.03835, 37.55453], [-122.03835, 37.55456], [-122.03837, 37.5546], [-122.03867, 37.55475], [-122.03857, 37.55488], [-122.03826, 37.55473], [-122.03819, 37.55474], [-122.03789, 37.55513], [-122.03788, 37.55516], [-122.03791, 37.5552], [-122.0382, 37.55535], [-122.0381, 37.55548], [-122.0378, 37.55533], [-122.03773, 37.55534], [-122.03742, 37.55573], [-122.03741, 37.55577], [-122.03743, 37.5558], [-122.03774, 37.55595], [-122.03773, 37.55604], [-122.03777, 37.55613], [-122.03753, 37.55643], [-122.03711, 37.55742], [-122.0362, 37.55696], [-122.03696, 37.55599], [-122.03694, 37.55594], [-122.03661, 37.55577], [-122.03658, 37.55565], [-122.03648, 37.55556], [-122.03667, 37.55532], [-122.03667, 37.5553], [-122.03666, 37.55527], [-122.03546, 37.55467], [-122.0354, 37.55468], [-122.0352, 37.55492], [-122.03501, 37.55483], [-122.03519, 37.55458], [-122.0352, 37.55456], [-122.03519, 37.55453], [-122.03399, 37.55393], [-122.03395, 37.55393], [-122.03391, 37.55395], [-122.03372, 37.55419], [-122.03363, 37.55416], [-122.03355, 37.55416], [-122.03345, 37.55418], [-122.03338, 37.55422], [-122.03275, 37.55391], [-122.03282, 37.55371], [-122.03283, 37.5535], [-122.03276, 37.55328], [-122.03264, 37.55308], [-122.03325, 37.55232], [-122.03339, 37.55234], [-122.03353, 37.55232], [-122.03387, 37.55249], [-122.0339, 37.55249], [-122.03394, 37.55248], [-122.03494, 37.55119], [-122.0356, 37.55151], [-122.03576, 37.55157], [-122.03604, 37.55161], [-122.03647, 37.55159], [-122.03651, 37.5516], [-122.03654, 37.55162], [-122.03658, 37.55177], [-122.03667, 37.55196], [-122.03681, 37.55216], [-122.03695, 37.55232], [-122.03696, 37.55236], [-122.03664, 37.55271], [-122.03638, 37.55261], [-122.03627, 37.55261], [-122.0362, 37.55265], [-122.03602, 37.55285], [-122.03594, 37.55289], [-122.03584, 37.55289], [-122.03572, 37.55284], [-122.03566, 37.55276], [-122.03565, 37.55269], [-122.03571, 37.55251], [-122.0357, 37.55237], [-122.03564, 37.55222], [-122.03554, 37.55212], [-122.03539, 37.55203], [-122.0352, 37.55198], [-122.035, 37.55199], [-122.03484, 37.55204], [-122.03468, 37.55213], [-122.03457, 37.55227], [-122.03453, 37.55242], [-122.03455, 37.55262], [-122.03451, 37.5527], [-122.03442, 37.55277], [-122.03422, 37.55282], [-122.03411, 37.55288], [-122.03402, 37.55297], [-122.03394, 37.55308], [-122.03391, 37.55323], [-122.03393, 37.55336], [-122.03399, 37.55349], [-122.0341, 37.55359], [-122.03424, 37.55366], [-122.0344, 37.5537], [-122.03458, 37.55371], [-122.03477, 37.55367], [-122.03485, 37.55368], [-122.0353, 37.55404], [-122.03553, 37.55417], [-122.03581, 37.5543], [-122.03622, 37.55444], [-122.03667, 37.55452], [-122.03672, 37.55456], [-122.03686, 37.55469], [-122.03706, 37.55478], [-122.03728, 37.5548], [-122.03746, 37.55477], [-122.03758, 37.55472], [-122.0377, 37.55463], [-122.03779, 37.5545], [-122.03783, 37.55435], [-122.03786, 37.5543], [-122.03803, 37.55419], [-122.03813, 37.55409], [-122.03819, 37.55396], [-122.03821, 37.55381], [-122.03817, 37.55368], [-122.03808, 37.55355], [-122.03797, 37.55347], [-122.0378, 37.5534], [-122.03764, 37.55338], [-122.03745, 37.5534], [-122.03732, 37.55345], [-122.03718, 37.55353], [-122.03711, 37.55354], [-122.03701, 37.55353], [-122.03695, 37.55347], [-122.03692, 37.55341], [-122.03694, 37.55335], [-122.03712, 37.55312], [-122.03713, 37.55304], [-122.03709, 37.55296], [-122.03686, 37.55282], [-122.03707, 37.55257], [-122.03714, 37.55251], [-122.0372, 37.5525], [-122.03907, 37.55342], [-122.03892, 37.55364], [-122.03882, 37.55397], [-122.03885, 37.55401], [-122.03914, 37.55416]]]} | Open Access 1 | 12717 | Lakeshore Park | 20972 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 25.795 | Lakeshore Park | 1973 | Local Park 2 | 4 | |
8300 | 8300 | 8299 | {"type": "Polygon", "coordinates": [[[-118.46565, 34.33048], [-118.46562, 34.33062], [-118.46563, 34.33073], [-118.46517, 34.33077], [-118.46516, 34.33138], [-118.46458, 34.332], [-118.46458, 34.33243], [-118.46432, 34.33311], [-118.4639, 34.3328], [-118.46417, 34.33245], [-118.46393, 34.33219], [-118.46382, 34.33173], [-118.46412, 34.33168], [-118.46385, 34.33059], [-118.46422, 34.33041], [-118.46428, 34.3302], [-118.4648, 34.33011], [-118.46482, 34.33008], [-118.46531, 34.33009], [-118.46526, 34.33043], [-118.46565, 34.33048]]]} | No Public Access 3 | 12719 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 6.732 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8301 | 8301 | 8300 | {"type": "Polygon", "coordinates": [[[-118.45954, 34.32608], [-118.45903, 34.32693], [-118.45897, 34.32748], [-118.45866, 34.32801], [-118.45855, 34.32801], [-118.45828, 34.32695], [-118.45824, 34.32695], [-118.45826, 34.32561], [-118.45823, 34.3255], [-118.458, 34.32543], [-118.4579, 34.32485], [-118.45808, 34.32479], [-118.45807, 34.32476], [-118.45823, 34.32469], [-118.45797, 34.32414], [-118.45813, 34.32418], [-118.45857, 34.32507], [-118.45921, 34.32507], [-118.45954, 34.32608]]]} | No Public Access 3 | 12720 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 7.386 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8302 | 8302 | 8301 | {"type": "MultiPolygon", "coordinates": [[[[-118.47595, 34.32868], [-118.47522, 34.32881], [-118.47516, 34.32877], [-118.475, 34.3286], [-118.47468, 34.32886], [-118.47418, 34.32872], [-118.47382, 34.32824], [-118.47375, 34.32796], [-118.47388, 34.32773], [-118.47425, 34.32782], [-118.47464, 34.3274], [-118.47489, 34.32723], [-118.475, 34.32723], [-118.47498, 34.32741], [-118.47504, 34.32747], [-118.47515, 34.32748], [-118.47595, 34.32868]]], [[[-118.47687, 34.33028], [-118.47677, 34.33041], [-118.47584, 34.32924], [-118.4757, 34.32915], [-118.4762, 34.32905], [-118.47683, 34.33027], [-118.47687, 34.33028]]]]} | No Public Access 3 | 12721 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 6.178 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8303 | 8303 | 8302 | {"type": "Polygon", "coordinates": [[[-118.47061, 34.3327], [-118.47016, 34.33284], [-118.46964, 34.33229], [-118.46861, 34.33235], [-118.46846, 34.33475], [-118.46779, 34.33473], [-118.46763, 34.33148], [-118.46832, 34.33146], [-118.46882, 34.3306], [-118.46881, 34.33058], [-118.46838, 34.33055], [-118.46839, 34.33011], [-118.46915, 34.33012], [-118.46944, 34.33023], [-118.46958, 34.33035], [-118.47003, 34.33102], [-118.47061, 34.3327]]]} | No Public Access 3 | 12722 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 15.975 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8304 | 8304 | 8303 | {"type": "Polygon", "coordinates": [[[-118.44775, 34.33271], [-118.44653, 34.33307], [-118.44644, 34.33288], [-118.44629, 34.33208], [-118.44632, 34.3321], [-118.44633, 34.33209], [-118.44593, 34.33133], [-118.4458, 34.33101], [-118.44556, 34.33066], [-118.44548, 34.3306], [-118.44537, 34.33055], [-118.44527, 34.33054], [-118.44516, 34.33055], [-118.44502, 34.3306], [-118.44486, 34.33072], [-118.44462, 34.33082], [-118.44455, 34.33083], [-118.44446, 34.3308], [-118.4444, 34.33074], [-118.44438, 34.33068], [-118.4444, 34.33061], [-118.44498, 34.32992], [-118.44717, 34.32993], [-118.44716, 34.33007], [-118.44756, 34.33103], [-118.44775, 34.33271]]]} | No Public Access 3 | 12723 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 13.401 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8305 | 8305 | 8304 | {"type": "Polygon", "coordinates": [[[-118.77471, 34.06273], [-118.7747, 34.06488], [-118.77445, 34.06486], [-118.77447, 34.06468], [-118.77443, 34.0646], [-118.77436, 34.06455], [-118.77319, 34.06472], [-118.77312, 34.06476], [-118.77306, 34.06483], [-118.77302, 34.0649], [-118.77301, 34.06505], [-118.77293, 34.06506], [-118.77242, 34.06439], [-118.77233, 34.06435], [-118.77224, 34.06435], [-118.77199, 34.06442], [-118.77192, 34.06441], [-118.77186, 34.06437], [-118.77183, 34.06424], [-118.77177, 34.06418], [-118.77149, 34.06407], [-118.77142, 34.06401], [-118.77141, 34.06391], [-118.77168, 34.06353], [-118.7717, 34.06346], [-118.77171, 34.06334], [-118.77166, 34.0632], [-118.77133, 34.0626], [-118.77132, 34.06224], [-118.7713, 34.06224], [-118.7712, 34.06249], [-118.77144, 34.06331], [-118.77142, 34.06333], [-118.77135, 34.06332], [-118.77109, 34.06287], [-118.77101, 34.06282], [-118.77093, 34.06281], [-118.77087, 34.06283], [-118.77053, 34.06302], [-118.77043, 34.06312], [-118.77033, 34.06328], [-118.77027, 34.06335], [-118.77025, 34.06184], [-118.77242, 34.06182], [-118.77243, 34.06271], [-118.77471, 34.06273]]]} | Open Access 1 | 12728 | Upper Solstice Canyon | 14300 | 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 | http://www.nps.gov/samo/planyourvisit/solsticecanyon.htm | Los Angeles 6 | 20.51 | Upper Solstice Canyon | 0 | National Recreation Area 54 | 3 |
8306 | 8306 | 8305 | {"type": "MultiPolygon", "coordinates": [[[[-117.76027, 33.70922], [-117.76023, 33.70926], [-117.76014, 33.70941], [-117.75687, 33.70715], [-117.75487, 33.70571], [-117.75375, 33.70493], [-117.75391, 33.70478], [-117.75668, 33.7067], [-117.76027, 33.70922]]], [[[-117.76357, 33.71154], [-117.76342, 33.71169], [-117.76036, 33.70957], [-117.76049, 33.7094], [-117.76357, 33.71154]]], [[[-117.76853, 33.71508], [-117.7684, 33.71517], [-117.7669, 33.71412], [-117.76624, 33.71369], [-117.76368, 33.71188], [-117.76381, 33.71176], [-117.76853, 33.71508]]], [[[-117.77278, 33.71794], [-117.7726, 33.71811], [-117.77193, 33.71765], [-117.76914, 33.71567], [-117.76862, 33.71535], [-117.76879, 33.71522], [-117.77086, 33.71666], [-117.77208, 33.71748], [-117.7721, 33.71747], [-117.77278, 33.71794]]]]} | Open Access 1 | 12734 | Venta Spur Trail | 26848 | 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 | 11.547 | Venta Spur Trail | 0 | Local Recreation Area 3 | 4 | |
8307 | 8307 | 8306 | {"type": "Polygon", "coordinates": [[[-117.70889, 33.62595], [-117.70716, 33.62703], [-117.70692, 33.62672], [-117.70676, 33.62655], [-117.70639, 33.62641], [-117.70653, 33.62626], [-117.70639, 33.62614], [-117.70639, 33.62609], [-117.70666, 33.62608], [-117.70664, 33.62538], [-117.70644, 33.62536], [-117.7069, 33.62524], [-117.70721, 33.62505], [-117.70742, 33.62528], [-117.70748, 33.62526], [-117.708, 33.6258], [-117.70847, 33.62552], [-117.70889, 33.62595]]]} | Open Access 1 | 12735 | Village Pond Park | 27121 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 6.331 | Village Pond Park | 0 | Local Park 2 | 4 | |
8308 | 8308 | 8307 | {"type": "Polygon", "coordinates": [[[-117.33623, 33.21599], [-117.33279, 33.22069], [-117.33193, 33.22042], [-117.33199, 33.22009], [-117.33205, 33.21957], [-117.33208, 33.21908], [-117.33208, 33.2186], [-117.33211, 33.21826], [-117.33221, 33.21782], [-117.3323, 33.21756], [-117.33241, 33.2172], [-117.33249, 33.21674], [-117.33251, 33.21653], [-117.33255, 33.21549], [-117.33262, 33.21504], [-117.33268, 33.21475], [-117.33282, 33.2143], [-117.33327, 33.21307], [-117.33336, 33.21277], [-117.33342, 33.21248], [-117.33471, 33.21244], [-117.33623, 33.21599]]]} | No Public Access 3 | 12737 | Vista de la Valle - Land Preserve/Mitigation Area | 27166 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 50.738 | Vista de la Valle - Land Preserve/Mitigation Area | 0 | Private Conservation 16 | 2 | ||
8309 | 8309 | 8308 | {"type": "Polygon", "coordinates": [[[-118.60165, 34.05301], [-118.60165, 34.05347], [-118.60118, 34.05348], [-118.60118, 34.05301], [-118.60165, 34.05301]]]} | No Public Access 3 | 12776 | Los Angeles County Open Space | 21480 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.548 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
8310 | 8310 | 8309 | {"type": "Polygon", "coordinates": [[[-117.81322, 33.67765], [-117.81281, 33.67806], [-117.81272, 33.67808], [-117.81269, 33.67807], [-117.8117, 33.6774], [-117.8122, 33.67696], [-117.81322, 33.67765]]]} | Restricted Access 2 | 12758 | Windjammer Park | 27627 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.035 | Windjammer Park | 0 | Private Recreation or Education 65 | 4 | |
8311 | 8311 | 8310 | {"type": "Polygon", "coordinates": [[[-117.5345, 33.98645], [-117.53339, 33.98645], [-117.53326, 33.98678], [-117.53299, 33.98668], [-117.5328, 33.98657], [-117.53267, 33.9865], [-117.53237, 33.98641], [-117.53234, 33.98636], [-117.53244, 33.98618], [-117.53265, 33.98593], [-117.53291, 33.98572], [-117.53312, 33.98561], [-117.53332, 33.98554], [-117.5336, 33.98547], [-117.53388, 33.98544], [-117.53446, 33.98543], [-117.5345, 33.98547], [-117.5345, 33.98645]]]} | Open Access 1 | 12759 | Wineville Park | 27645 | 2051 | Jurupa Area Recreation and Park District 364 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 4.843 | Wineville Park | 0 | Local Park 2 | 4 | |
8312 | 8312 | 8311 | {"type": "Polygon", "coordinates": [[[-117.80304, 33.6655], [-117.80296, 33.66592], [-117.80301, 33.66599], [-117.80294, 33.66604], [-117.80285, 33.66622], [-117.80277, 33.66631], [-117.80242, 33.66649], [-117.80227, 33.66661], [-117.80216, 33.66673], [-117.80207, 33.66688], [-117.80202, 33.66707], [-117.80206, 33.6668], [-117.80218, 33.66645], [-117.80241, 33.66541], [-117.80304, 33.6655]]]} | Restricted Access 2 | 12760 | Wintermist Park | 27654 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.725 | Wintermist Park | 0 | Private Recreation or Education 65 | 4 | |
8313 | 8313 | 8312 | {"type": "Polygon", "coordinates": [[[-122.05539, 37.53459], [-122.05494, 37.53486], [-122.05338, 37.53409], [-122.05373, 37.53374], [-122.05382, 37.53347], [-122.05426, 37.53356], [-122.05443, 37.53361], [-122.05462, 37.53369], [-122.05477, 37.53378], [-122.05494, 37.53391], [-122.05514, 37.53414], [-122.05539, 37.53459]]]} | Open Access 1 | 12763 | Bridgepointe Park | 16377 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 3.527 | Bridgepointe Park | 1984 | Local Park 2 | 4 | |
8314 | 8314 | 8313 | {"type": "Polygon", "coordinates": [[[-122.03974, 37.52433], [-122.03781, 37.52499], [-122.03779, 37.52499], [-122.03778, 37.52488], [-122.03775, 37.52484], [-122.0377, 37.52481], [-122.03761, 37.52478], [-122.03747, 37.52481], [-122.03718, 37.52491], [-122.03694, 37.52445], [-122.03816, 37.52403], [-122.03938, 37.52364], [-122.03974, 37.52433]]]} | Open Access 1 | 12784 | Ash Street Park | 15649 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 4.542 | Ash Street Park | 1973 | 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]);