units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
156 rows where ACCESS_TYP = 2 and AGNCY_TYP = 14 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, PARK_URL
MNG_AGENCY >30
- Whittier, City of 18
- Los Angeles Unified School District 16
- San Ramon, City of 15
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Hollister, City of 6
- Santa Ana, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 4
- Azusa Unified School District 4
- Los Angeles, City of 3
- Carlsbad, City of 3
- San Bernardino, City of 3
- Palmdale, City of 3
- Pasadena, City of 3
- Conejo Valley Unified School District 3
- San Gabriel, City of 3
- San Diego, City of 2
- Glendora, City of 2
- Lake Elsinore, City of 2
- Sierra Madre, City of 2
- South El Monte, City of 2
- San Gabriel Unified School District 2
- Culver City Unified School District 2
- Los Nietos School District 2
- Los Angeles, County of 1
- Santa Rosa, City of 1
- Encinitas, City of 1
- Yorba Linda, City of 1
- Oceanside, City of 1
- …
DES_TP 5
- Local Park 125
- Local Recreation Area 28
- None 1
- None 1
- None 1
MNG_AG_TYP 3
- City Agency 117
- School District 37
- County Agency 2
ACCESS_TYP 1
- Restricted Access · 156 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14245 | 14245 | 14244 | {"type": "Polygon", "coordinates": [[[-118.03024, 34.15973], [-118.02975, 34.15977], [-118.0297, 34.1602], [-118.02916, 34.16008], [-118.02882, 34.16003], [-118.02852, 34.16], [-118.02806, 34.16001], [-118.02952, 34.15919], [-118.03012, 34.15918], [-118.03024, 34.15973]]]} | Restricted Access 2 | 44142 | Highland Oaks Park | 19930 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.851 | Highland Oaks Park | 0 | Local Park 2 | 4 | |
13454 | 13454 | 13453 | {"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82177], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.82089], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82032], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]} | Restricted Access 2 | 35667 | Thousand Palms Community Park | 31650 | 2318 | Palm Springs Unified School District 1058 | Special District 4 | School District 14 | http://www.psusd.us/ | Special District 4 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 16.4 | Thousand Palms Community Park | 0 | Local Park 2 | 4 | |
4439 | 4439 | 4438 | {"type": "Polygon", "coordinates": [[[-118.03633, 34.13066], [-118.03547, 34.13067], [-118.03546, 34.13071], [-118.03229, 34.13073], [-118.03226, 34.12947], [-118.03497, 34.12908], [-118.03498, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.12981], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} | Restricted Access 2 | 46490 | Arcadia High School Park | 31846 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://ahs.ausd.net/ | Los Angeles 6 | 13.815 | Arcadia High School Park | 0 | Local Park 2 | 4 |
15311 | 15311 | 15310 | {"type": "Polygon", "coordinates": [[[-118.03099, 34.1252], [-118.02956, 34.12521], [-118.02955, 34.12535], [-118.02911, 34.12535], [-118.0291, 34.12542], [-118.02813, 34.12543], [-118.02812, 34.12478], [-118.02926, 34.12479], [-118.02927, 34.12465], [-118.02979, 34.12463], [-118.0298, 34.12408], [-118.02984, 34.12408], [-118.02985, 34.12371], [-118.03014, 34.12371], [-118.03015, 34.12396], [-118.03097, 34.12395], [-118.03099, 34.1252]]]} | Restricted Access 2 | 46489 | Dana Middle School Park | 31886 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://da.ausd.net/ | Los Angeles 6 | 6.595 | Dana Middle School Park | 0 | Local Park 2 | 4 |
15312 | 15312 | 15311 | {"type": "Polygon", "coordinates": [[[-118.0253, 34.15295], [-118.02529, 34.15431], [-118.02515, 34.15463], [-118.02234, 34.1547], [-118.0223, 34.1529], [-118.0231, 34.15289], [-118.02312, 34.15299], [-118.0253, 34.15295]]]} | Restricted Access 2 | 46491 | Highland Oaks Middle School Park | 31887 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | Los Angeles 6 | 12.835 | Highland Oaks Middle School Park | 0 | Local Park 2 | 4 | |
15313 | 15313 | 15312 | {"type": "Polygon", "coordinates": [[[-118.06394, 34.13718], [-118.06273, 34.13744], [-118.06271, 34.13685], [-118.06273, 34.13669], [-118.06278, 34.1366], [-118.06286, 34.13651], [-118.0633, 34.13619], [-118.06337, 34.13619], [-118.06339, 34.13621], [-118.06394, 34.13718]]]} | Restricted Access 2 | 46493 | Hugo Reid Elementary School Park | 31889 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://hr.ausd.net/ | Los Angeles 6 | 2.433 | Hugo Reid Elementary School Park | 0 | Local Park 2 | 4 |
15323 | 15323 | 15322 | {"type": "Polygon", "coordinates": [[[-118.03121, 34.13667], [-118.0302, 34.13668], [-118.03018, 34.13643], [-118.02964, 34.13643], [-118.02962, 34.13597], [-118.0302, 34.13596], [-118.0302, 34.13575], [-118.03119, 34.13574], [-118.03121, 34.13667]]]} | Restricted Access 2 | 46487 | First Avenue Middle School Park | 31905 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://fa.ausd.net/ | Los Angeles 6 | 3.017 | First Avenue Middle School Park | 0 | Local Park 2 | 4 |
15324 | 15324 | 15323 | {"type": "Polygon", "coordinates": [[[-118.04812, 34.11743], [-118.0462, 34.11746], [-118.04619, 34.11714], [-118.04576, 34.11714], [-118.04575, 34.11667], [-118.04763, 34.11665], [-118.04764, 34.11711], [-118.04812, 34.11711], [-118.04812, 34.11743]]]} | Restricted Access 2 | 46488 | Baldwin Stocker Elementary School Park | 31847 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://bs.ausd.net/ | Los Angeles 6 | 3.796 | Baldwin Stocker Elementary School Park | 0 | Local Park 2 | 4 |
15326 | 15326 | 15325 | {"type": "Polygon", "coordinates": [[[-118.04253, 34.10858], [-118.04125, 34.10859], [-118.04124, 34.10783], [-118.0413, 34.1078], [-118.04245, 34.10778], [-118.04249, 34.10779], [-118.04251, 34.10784], [-118.04253, 34.10858]]]} | Restricted Access 2 | 46492 | Longley Way Elementary School Park | 31888 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://lw.ausd.net/ | Los Angeles 6 | 2.552 | Longley Way Elementary School Park | 0 | Local Park 2 | 4 |
15171 | 15171 | 15170 | {"type": "Polygon", "coordinates": [[[-117.90331, 34.11113], [-117.90329, 34.11315], [-117.90111, 34.11315], [-117.90112, 34.11113], [-117.90331, 34.11113]]]} | Restricted Access 2 | 46041 | Murray Elementary School Park | 31893 | 2365 | Azusa Unified School District 736 | Special District 4 | School District 14 | https://ausd-ca.schoolloop.com/ | Special District 4 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1240 | Los Angeles 6 | 11.168 | Murray Elementary School Park | 0 | Local Park 2 | 4 |
15260 | 15260 | 15259 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06053], [-118.41139, 34.0606], [-118.41083, 34.06087], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06003], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06053]]], [[[-118.41243, 34.06254], [-118.41205, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41232, 34.06203], [-118.41217, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | 46326 | Beverly Hills High School Park | 31849 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 10.447 | Beverly Hills High School Park | 0 | Local Park 2 | 4 | |
15263 | 15263 | 15262 | {"type": "Polygon", "coordinates": [[[-118.38356, 34.06628], [-118.38312, 34.0663], [-118.3831, 34.06602], [-118.38268, 34.06603], [-118.38267, 34.06594], [-118.38262, 34.06594], [-118.3826, 34.06506], [-118.38346, 34.06506], [-118.38351, 34.06508], [-118.38356, 34.06628]]]} | Restricted Access 2 | 46327 | Horace Mann Elementary School Park | 31881 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.532 | Horace Mann Elementary School Park | 0 | Local Park 2 | 4 | |
15264 | 15264 | 15263 | {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} | Restricted Access 2 | 46328 | Beverly Vista Elementary School Park | 31882 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.838 | Beverly Vista Elementary School Park | 0 | Local Park 2 | 4 | |
15265 | 15265 | 15264 | {"type": "MultiPolygon", "coordinates": [[[[-118.40382, 34.07823], [-118.40328, 34.0785], [-118.40298, 34.07798], [-118.40351, 34.07775], [-118.40382, 34.07823]]], [[[-118.40519, 34.07988], [-118.404, 34.08055], [-118.40365, 34.08016], [-118.40422, 34.07986], [-118.40483, 34.07951], [-118.40519, 34.07988]]]]} | Restricted Access 2 | 46329 | Hawthorne Elementary School Park | 31883 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.583 | Hawthorne Elementary School Park | 0 | Local Park 2 | 4 | |
15266 | 15266 | 15265 | {"type": "Polygon", "coordinates": [[[-118.41726, 34.06839], [-118.41627, 34.06893], [-118.41611, 34.06874], [-118.41596, 34.06861], [-118.41582, 34.06852], [-118.41542, 34.06833], [-118.41525, 34.0682], [-118.41505, 34.068], [-118.41489, 34.06775], [-118.41483, 34.06759], [-118.41478, 34.06733], [-118.41477, 34.06722], [-118.41588, 34.06722], [-118.41602, 34.06756], [-118.41573, 34.06766], [-118.41586, 34.06795], [-118.41595, 34.06793], [-118.416, 34.06794], [-118.41609, 34.06801], [-118.41588, 34.0681], [-118.41597, 34.06833], [-118.41609, 34.0683], [-118.41627, 34.0687], [-118.41651, 34.06863], [-118.41669, 34.06851], [-118.41654, 34.06811], [-118.41696, 34.06797], [-118.41726, 34.06839]]]} | Restricted Access 2 | 46330 | El Rodeo Elementary School Park | 31884 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 3.998 | El Rodeo Elementary School Park | 0 | Local Park 2 | 4 | |
14210 | 14210 | 14209 | {"type": "Polygon", "coordinates": [[[-117.89549, 33.9268], [-117.89549, 33.92741], [-117.89547, 33.92752], [-117.89199, 33.92753], [-117.89193, 33.92519], [-117.89201, 33.9251], [-117.8935, 33.92506], [-117.89355, 33.9268], [-117.89549, 33.9268]]]} | Restricted Access 2 | 44076 | Brea Junior High Park | 16342 | 2311 | Brea Olinda Unified School District 1100 | Special District 4 | School District 14 | http://www.bousd.k12.ca.us/ | Special District 4 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | Orange 3 | 13.284 | Brea Junior High Park | 0 | Local Park 2 | 4 | |
4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | 46266 | Maple Street Playground | 31626 | 2391 | Burbank Unified School District 759 | Special District 4 | School District 14 | http://www.burbankusd.org/ | Special District 4 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | Los Angeles 6 | 0.55 | Maple Street Playground | 0 | Local Recreation Area 3 | 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 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 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 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 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 |
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]);