units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where ACCESS_TYP = 2, DES_TP = 2 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Whittier, City of 20
- San Ramon, City of 13
- Los Angeles, City of 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- San Diego, City of 4
- Fullerton, City of 4
- Vacaville, City of 4
- Hollister, City of 4
- Pasadena, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Glendora, City of 3
- Carlsbad, City of 3
- Palmdale, City of 3
- Mountain View, City of 3
- Garden Grove, City of 2
- Oceanside, City of 2
- Lake Elsinore, City of 2
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Sacramento, City of 2
- South El Monte, City of 2
- San Gabriel, City of 2
- Watsonville, City of 1
- Fresno, City of 1
- Santa Ana, City of 1
- …
MNG_AG_TYP 1
- City Agency · 151 ✖
DES_TP 1
- Local Park · 151 ✖
ACCESS_TYP 1
- Restricted Access · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16368 | 16368 | 16367 | {"type": "MultiPolygon", "coordinates": [[[[-120.96864, 37.62414], [-120.96864, 37.62434], [-120.96817, 37.62428], [-120.96808, 37.62467], [-120.9679, 37.62465], [-120.96799, 37.62426], [-120.96782, 37.62423], [-120.96772, 37.62462], [-120.96754, 37.6246], [-120.96762, 37.62421], [-120.96745, 37.62418], [-120.96736, 37.62457], [-120.96663, 37.62447], [-120.96672, 37.62407], [-120.9669, 37.6241], [-120.96689, 37.62415], [-120.96706, 37.62418], [-120.96708, 37.62412], [-120.96744, 37.62417], [-120.96749, 37.62391], [-120.96864, 37.62414]]], [[[-120.96854, 37.62474], [-120.96827, 37.6247], [-120.96834, 37.62437], [-120.96854, 37.6244], [-120.96854, 37.62474]]], [[[-120.9746, 37.62611], [-120.97324, 37.62554], [-120.97195, 37.62512], [-120.97082, 37.62484], [-120.97081, 37.62292], [-120.97343, 37.62388], [-120.97378, 37.62412], [-120.97459, 37.62461], [-120.9746, 37.62611]]]]} | Restricted Access 2 | 34897 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 17.831 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
16267 | 16267 | 16266 | {"type": "MultiPolygon", "coordinates": [[[[-120.96798, 37.62431], [-120.9679, 37.62465], [-120.96772, 37.62462], [-120.9678, 37.62428], [-120.96798, 37.62431]]], [[[-120.96854, 37.6244], [-120.96834, 37.62437], [-120.96827, 37.6247], [-120.96809, 37.62467], [-120.96817, 37.62428], [-120.96853, 37.62433], [-120.96854, 37.6244]]], [[[-120.97082, 37.62484], [-120.97024, 37.62472], [-120.97023, 37.62482], [-120.96997, 37.62477], [-120.9698, 37.62476], [-120.96964, 37.62479], [-120.96944, 37.62487], [-120.96906, 37.62491], [-120.96905, 37.62476], [-120.96863, 37.62475], [-120.96864, 37.62414], [-120.9675, 37.62391], [-120.96745, 37.62417], [-120.96763, 37.6242], [-120.96754, 37.6246], [-120.96736, 37.62457], [-120.96744, 37.62418], [-120.96708, 37.62412], [-120.96672, 37.62408], [-120.96663, 37.62447], [-120.96632, 37.62442], [-120.96629, 37.6244], [-120.96626, 37.62432], [-120.96624, 37.6242], [-120.96623, 37.62277], [-120.96846, 37.62263], [-120.96924, 37.62277], [-120.97081, 37.62292], [-120.97082, 37.62484]]]]} | Restricted Access 2 | 34896 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.414 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
15728 | 15728 | 15727 | {"type": "Polygon", "coordinates": [[[-118.15633, 33.9544], [-118.15556, 33.95835], [-118.15532, 33.95831], [-118.15543, 33.95776], [-118.15531, 33.95757], [-118.15526, 33.95754], [-118.15527, 33.9572], [-118.15505, 33.95697], [-118.15296, 33.95675], [-118.15268, 33.95647], [-118.15483, 33.95531], [-118.15633, 33.9544]]]} | Restricted Access 2 | 46197 | Bell Gardens Golf Course at Ford Park | 33117 | 1023 | Bell Gardens, City of 226 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | Los Angeles 6 | 12.793 | Bell Gardens GC at Ford Park | 0 | Local Park 2 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
15417 | 15417 | 15416 | {"type": "Polygon", "coordinates": [[[-118.01776, 33.8507], [-118.01418, 33.8507], [-118.01417, 33.85018], [-118.01775, 33.85014], [-118.01776, 33.8507]]]} | Restricted Access 2 | 46649 | City of Buena Park Community Gardens | 29984 | 1037 | Buena Park, City of 136 | City 2 | City Agency 2 | http://www.buenapark.com/ | City 2 | 1037 | Buena Park, City of 133 | City 2 | City Agency 2 | http://www.buenapark.com/index.aspx?page=109 | Orange 3 | 4.9 | City of Buena Park Community Gardens | 0 | Local Park 2 | 4 |
15404 | 15404 | 15403 | {"type": "MultiPolygon", "coordinates": [[[[-118.19426, 33.9184], [-118.19422, 33.91851], [-118.19419, 33.91851], [-118.19416, 33.91858], [-118.19409, 33.91861], [-118.19408, 33.91863], [-118.18946, 33.91662], [-118.18957, 33.91635], [-118.19426, 33.9184]]], [[[-118.2018, 33.92167], [-118.20172, 33.92179], [-118.20163, 33.92175], [-118.20157, 33.92184], [-118.2009, 33.92156], [-118.20088, 33.92158], [-118.19826, 33.92045], [-118.19827, 33.92042], [-118.19825, 33.92037], [-118.19826, 33.92031], [-118.1981, 33.92025], [-118.19808, 33.92028], [-118.19801, 33.92031], [-118.19799, 33.92033], [-118.19479, 33.91894], [-118.19434, 33.91875], [-118.19436, 33.91872], [-118.19433, 33.91867], [-118.19436, 33.9186], [-118.19433, 33.91858], [-118.19438, 33.91845], [-118.2018, 33.92167]]], [[[-118.2066, 33.92375], [-118.20651, 33.92402], [-118.20411, 33.92299], [-118.20412, 33.92296], [-118.20411, 33.9229], [-118.20414, 33.92288], [-118.20413, 33.92286], [-118.20397, 33.92279], [-118.20392, 33.92284], [-118.20386, 33.92285], [-118.20384, 33.92287], [-118.20191, 33.92203], [-118.20193, 33.92201], [-118.20191, 33.92195], [-118.20204, 33.92178], [-118.2066, 33.92375]]]]} | Restricted Access 2 | 46625 | Ricardo Lara Linear Park | 31641 | 1191 | Lynwood, City of 258 | City 2 | City Agency 2 | http://www.lynwood.ca.us/ | City 2 | 1191 | Lynwood, City of 254 | City 2 | City Agency 2 | Los Angeles 6 | 12.923 | Ricardo Lara Linear Park | 0 | Local Park 2 | 4 | |
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
15395 | 15395 | 15394 | {"type": "Polygon", "coordinates": [[[-118.39514, 33.8615], [-118.39468, 33.86158], [-118.39458, 33.86123], [-118.39504, 33.86114], [-118.39514, 33.8615]]]} | Restricted Access 2 | 46635 | Lawn Bowling Green | 29962 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=262 | Los Angeles 6 | 0.443 | Lawn Bowling Green | 1958 | Local Park 2 | 4 |
15375 | 15375 | 15374 | {"type": "Polygon", "coordinates": [[[-118.06214, 33.99624], [-118.06143, 33.99697], [-118.06026, 33.99618], [-118.06023, 33.99613], [-118.06024, 33.99609], [-118.06036, 33.99592], [-118.06036, 33.99586], [-118.06034, 33.99581], [-118.06029, 33.99577], [-118.06042, 33.99562], [-118.06025, 33.99551], [-118.06031, 33.99544], [-118.06042, 33.99552], [-118.06068, 33.99526], [-118.06125, 33.99569], [-118.06164, 33.99594], [-118.06214, 33.99624]]]} | Restricted Access 2 | 46586 | Orange Grove Elementary School Park | 31923 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 4.112 | Orange Grove Elementary School Park | 0 | Local Park 2 | 4 | |
15374 | 15374 | 15373 | {"type": "Polygon", "coordinates": [[[-118.07089, 33.98277], [-118.07034, 33.98332], [-118.07025, 33.98332], [-118.07025, 33.98291], [-118.06916, 33.98298], [-118.06903, 33.98295], [-118.06895, 33.98284], [-118.06879, 33.9828], [-118.06867, 33.98281], [-118.06848, 33.98289], [-118.06761, 33.98287], [-118.06732, 33.98319], [-118.06592, 33.98222], [-118.0659, 33.98218], [-118.06677, 33.98141], [-118.0679, 33.98219], [-118.06876, 33.9813], [-118.07089, 33.98277]]]} | Restricted Access 2 | 46585 | Katherine Edwards Middle School Park | 31922 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.444 | Katherine Edwards Middle School Park | 0 | Local Park 2 | 4 | |
15373 | 15373 | 15372 | {"type": "Polygon", "coordinates": [[[-118.00906, 33.93605], [-118.00905, 33.93665], [-118.00888, 33.93669], [-118.00796, 33.93701], [-118.00795, 33.93695], [-118.0074, 33.93695], [-118.00741, 33.93657], [-118.00719, 33.93652], [-118.00734, 33.93606], [-118.00706, 33.936], [-118.00713, 33.93579], [-118.00721, 33.93576], [-118.00718, 33.9357], [-118.00732, 33.93569], [-118.00731, 33.93533], [-118.0077, 33.93533], [-118.00906, 33.93605]]]} | Restricted Access 2 | 46584 | Orchard Dale Elementary School Park | 31921 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.701 | Orchard Dale Elementary School Park | 0 | Local Park 2 | 4 | |
15372 | 15372 | 15371 | {"type": "Polygon", "coordinates": [[[-117.98787, 33.94757], [-117.98771, 33.94783], [-117.98755, 33.94804], [-117.98742, 33.94817], [-117.98728, 33.94827], [-117.98705, 33.9484], [-117.9864, 33.94818], [-117.98619, 33.94749], [-117.98701, 33.94731], [-117.98787, 33.94757]]]} | Restricted Access 2 | 46581 | Murphy Ranch Elementary School Park | 31919 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 3.01 | Murphy Ranch Elementary School Park | 0 | Local Park 2 | 4 | |
15371 | 15371 | 15370 | {"type": "Polygon", "coordinates": [[[-118.00458, 33.9266], [-118.00234, 33.92712], [-118.00169, 33.92516], [-118.00393, 33.92463], [-118.00458, 33.9266]]]} | Restricted Access 2 | 46567 | Granada Middle School Park | 31912 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.037 | Granada Middle School Park | 0 | Local Park 2 | 4 | |
15370 | 15370 | 15369 | {"type": "Polygon", "coordinates": [[[-118.05409, 33.98997], [-118.05257, 33.98997], [-118.05256, 33.98817], [-118.05247, 33.98816], [-118.05247, 33.98725], [-118.05276, 33.98725], [-118.05365, 33.98816], [-118.05359, 33.98816], [-118.05358, 33.98817], [-118.05408, 33.98868], [-118.05409, 33.98997]]]} | Restricted Access 2 | 46566 | Dexter Middle School Park | 31911 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 8.327 | Dexter Middle School Park | 0 | Local Park 2 | 4 | |
15369 | 15369 | 15368 | {"type": "Polygon", "coordinates": [[[-118.04661, 33.98098], [-118.0466, 33.98257], [-118.04655, 33.98262], [-118.0434, 33.98262], [-118.04335, 33.98259], [-118.04335, 33.98089], [-118.0454, 33.98089], [-118.04541, 33.98097], [-118.04661, 33.98098]]]} | Restricted Access 2 | 46565 | Whittier High School Park | 31910 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 14.027 | Whittier High School Park | 0 | Local Park 2 | 4 | |
15368 | 15368 | 15367 | {"type": "Polygon", "coordinates": [[[-118.04953, 33.95322], [-118.04794, 33.95479], [-118.04703, 33.95414], [-118.04712, 33.95402], [-118.04661, 33.95363], [-118.0473, 33.95299], [-118.04766, 33.95262], [-118.04765, 33.95257], [-118.04729, 33.95235], [-118.04701, 33.95253], [-118.04688, 33.95257], [-118.04672, 33.95256], [-118.04499, 33.95139], [-118.04575, 33.95062], [-118.04953, 33.95322]]]} | Restricted Access 2 | 46564 | Sierra Vista Adult School Park | 31909 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 16.345 | Sierra Vista Adult School Park | 0 | Local Park 2 | 4 | |
15367 | 15367 | 15366 | {"type": "Polygon", "coordinates": [[[-118.02225, 33.94131], [-118.02046, 33.94359], [-118.01735, 33.94146], [-118.01943, 33.93937], [-118.02225, 33.94131]]]} | Restricted Access 2 | 46563 | California High School Park | 31908 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 26.421 | California High School Park | 0 | Local Park 2 | 4 | |
15366 | 15366 | 15365 | {"type": "Polygon", "coordinates": [[[-117.99819, 33.95654], [-117.99808, 33.957], [-117.99805, 33.95724], [-117.99805, 33.95742], [-117.99797, 33.95761], [-117.99795, 33.95761], [-117.99766, 33.9579], [-117.99726, 33.95842], [-117.99394, 33.95658], [-117.99393, 33.95522], [-117.99456, 33.95479], [-117.9948, 33.95469], [-117.99819, 33.95654]]]} | Restricted Access 2 | 46562 | La Serna High School Park | 31907 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 22.498 | La Serna High School Park | 0 | Local Park 2 | 4 | |
15365 | 15365 | 15364 | {"type": "Polygon", "coordinates": [[[-118.00234, 33.92712], [-118.00162, 33.92729], [-118.0016, 33.92713], [-118.0015, 33.92688], [-118.00137, 33.92672], [-118.00117, 33.92657], [-118.00098, 33.92647], [-118.00074, 33.92575], [-118.0018, 33.92549], [-118.00234, 33.92712]]]} | Restricted Access 2 | 46561 | Scott Avenue Elementary School Park | 31906 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 4.025 | Scott Avenue Elementary School Park | 0 | Local Park 2 | 4 | |
15354 | 15354 | 15353 | {"type": "Polygon", "coordinates": [[[-118.41174, 33.895], [-118.41119, 33.89534], [-118.41102, 33.89519], [-118.41023, 33.89479], [-118.41014, 33.89462], [-118.41067, 33.89448], [-118.41069, 33.89451], [-118.41147, 33.8943], [-118.41174, 33.895]]]} | Restricted Access 2 | 46541 | Grand View Elementary School Park | 31904 | 2380 | Manhattan Beach Unified School District 971 | Special District 4 | School District 14 | http://www.mbusd.org/ | Special District 4 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | Los Angeles 6 | 2.292 | Grand View Elementary School 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]);