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 SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST
MNG_AGENCY 57
- 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
- Huntington Park, City of 1
- El Centro, City of 1
- Burbank, City of 1
- Azusa, City of 1
- Riverside, County of 1
- Walnut Creek, City of 1
- Brea, City of 1
- Needles, City of 1
- Paramount, City of 1
- Hawthorne, City of 1
- El Segundo, City of 1
- La Verne, City of 1
- Santa Clarita, City of 1
- Duarte, City of 1
- La Canada Flintridge, City of 1
- Pico Rivera, City of 1
- La Quinta, City of 1
- Grass Valley, City of 1
- Santa Clara Unified School District 1
- Norwalk La Mirada Unified School District 1
- Whittier Union High School District 1
- Whittier City School District 1
- Malibu, City of 1
- Redondo Beach Unified School District 1
- Arcadia Unified School District 1
- William S. Hart Union High School District 1
- Downey Unified School District 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14237 | 14237 | 14236 | {"type": "Polygon", "coordinates": [[[-121.97293, 37.76113], [-121.97254, 37.7613], [-121.97237, 37.76105], [-121.97216, 37.76105], [-121.9722, 37.7609], [-121.9704, 37.76037], [-121.9707, 37.75957], [-121.97077, 37.75953], [-121.97127, 37.75964], [-121.97156, 37.75969], [-121.97186, 37.75971], [-121.97215, 37.7597], [-121.97243, 37.75968], [-121.97293, 37.76113]]]} | Restricted Access 2 | 44124 | Bollinger Canyon School Park | 16244 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 5.795 | Bollinger Canyon 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 | |
14270 | 14270 | 14269 | {"type": "Polygon", "coordinates": [[[-121.41823, 36.85522], [-121.41821, 36.85579], [-121.41762, 36.85577], [-121.41756, 36.85611], [-121.41681, 36.85613], [-121.41681, 36.85719], [-121.41572, 36.85714], [-121.4157, 36.85711], [-121.41574, 36.85598], [-121.41578, 36.85511], [-121.41823, 36.85522]]]} | Restricted Access 2 | 44193 | Calaveras School Park | 16672 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 8.022 | Calaveras School Park | 0 | Local Park 2 | 4 | |
14227 | 14227 | 14226 | {"type": "Polygon", "coordinates": [[[-121.94225, 37.72945], [-121.94179, 37.72969], [-121.94173, 37.72975], [-121.94168, 37.72982], [-121.94162, 37.73001], [-121.94075, 37.73035], [-121.94089, 37.73059], [-121.9408, 37.73065], [-121.94061, 37.73042], [-121.9403, 37.73014], [-121.9393, 37.7297], [-121.93903, 37.72966], [-121.93913, 37.72914], [-121.9392, 37.72899], [-121.93932, 37.72886], [-121.93956, 37.72875], [-121.93967, 37.72887], [-121.93995, 37.72874], [-121.94032, 37.7292], [-121.94159, 37.7286], [-121.94225, 37.72945]]]} | Restricted Access 2 | 44105 | Country Club School Park | 17695 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 8.158 | Country Club School Park | 0 | Local Park 2 | 4 | |
14240 | 14240 | 14239 | {"type": "Polygon", "coordinates": [[[-117.2567, 34.15055], [-117.25532, 34.15056], [-117.25532, 34.14958], [-117.25669, 34.14958], [-117.2567, 34.15055]]]} | Restricted Access 2 | 44129 | Del Rosa School Field | 18054 | 2314 | San Bernardino City Unified School District 832 | Special District 4 | School District 14 | http://www.sbcusd.k12.ca.us/ | Special District 4 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 3.38 | Del Rosa School Field | 0 | Local Recreation Area 3 | 4 | |
14241 | 14241 | 14240 | {"type": "Polygon", "coordinates": [[[-117.90149, 33.74169], [-117.90036, 33.7417], [-117.90037, 33.74], [-117.90142, 33.73999], [-117.90142, 33.7407], [-117.90149, 33.74074], [-117.90149, 33.74169]]]} | Restricted Access 2 | 44131 | Friendship Park | 19123 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 4.747 | Friendship Park | 0 | Local Park 2 | 4 | |
14215 | 14215 | 14214 | {"type": "Polygon", "coordinates": [[[-121.94491, 37.78771], [-121.94478, 37.78784], [-121.94467, 37.78781], [-121.94454, 37.78785], [-121.94428, 37.78813], [-121.94429, 37.78815], [-121.94463, 37.7882], [-121.94463, 37.78826], [-121.94451, 37.78824], [-121.94394, 37.78832], [-121.9436, 37.78851], [-121.94337, 37.78825], [-121.94307, 37.78788], [-121.94292, 37.78777], [-121.9427, 37.78767], [-121.94282, 37.78743], [-121.9428, 37.78741], [-121.94396, 37.78677], [-121.94429, 37.78718], [-121.94454, 37.78743], [-121.94491, 37.78771]]]} | Restricted Access 2 | 44122 | Golden View School Park | 19375 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 4.778 | Golden View School Park | 0 | Local Park 2 | 4 | |
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 | |
14238 | 14238 | 14237 | {"type": "Polygon", "coordinates": [[[-121.95137, 37.75529], [-121.95025, 37.75568], [-121.95026, 37.75575], [-121.94955, 37.75603], [-121.94872, 37.75487], [-121.95042, 37.75417], [-121.95075, 37.75467], [-121.95116, 37.75511], [-121.95137, 37.75529]]]} | Restricted Access 2 | 44126 | Montevideo School Park | 22435 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 6.15 | Montevideo School Park | 0 | Local Park 2 | 4 | |
14229 | 14229 | 14228 | {"type": "Polygon", "coordinates": [[[-121.95043, 37.74153], [-121.95047, 37.74159], [-121.95043, 37.74164], [-121.9484, 37.74261], [-121.94834, 37.74259], [-121.94817, 37.74236], [-121.94777, 37.74195], [-121.94951, 37.74127], [-121.94991, 37.74104], [-121.95019, 37.74134], [-121.95043, 37.74153]]]} | Restricted Access 2 | 44108 | Neil Armstrong School Park | 22687 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 4.399 | Neil Armstrong School Park | 0 | Local Park 2 | 4 | |
14211 | 14211 | 14210 | {"type": "Polygon", "coordinates": [[[-117.87806, 34.14125], [-117.87974, 34.14126], [-117.87973, 34.14276], [-117.8798, 34.14277], [-117.8798, 34.14319], [-117.87707, 34.1432], [-117.87704, 34.14224], [-117.87705, 34.14128], [-117.87806, 34.14125]]]} | Restricted Access 2 | 44077 | Sandburg School Park | 25016 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 13.227 | Sandburg School Park | 0 | Local Park 2 | 4 | |
14214 | 14214 | 14213 | {"type": "Polygon", "coordinates": [[[-121.9876, 37.76853], [-121.98744, 37.76865], [-121.98732, 37.76882], [-121.98698, 37.76998], [-121.98688, 37.7701], [-121.98675, 37.77019], [-121.98566, 37.76912], [-121.98609, 37.7689], [-121.98606, 37.76878], [-121.98611, 37.76873], [-121.98623, 37.76869], [-121.98634, 37.7685], [-121.98633, 37.76837], [-121.98622, 37.76824], [-121.98677, 37.76779], [-121.98701, 37.76794], [-121.9876, 37.76853]]]} | Restricted Access 2 | 44087 | Twin Creeks School Park | 26613 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 5.487 | Twin Creeks School Park | 0 | Local Park 2 | 4 | |
4031 | 4031 | 4030 | {"type": "Polygon", "coordinates": [[[-122.01457, 37.93282], [-122.01322, 37.93363], [-122.01205, 37.93236], [-122.01398, 37.93158], [-122.01414, 37.93182], [-122.01456, 37.93195], [-122.01454, 37.93209], [-122.01455, 37.93222], [-122.01415, 37.93237], [-122.01457, 37.93282]]]} | Restricted Access 2 | 44198 | Valle Verde Park | 26771 | 2317 | Mount Diablo Unified School District 712 | Special District 4 | School District 14 | http://www.mdusd.org/ | Special District 4 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 6.862 | Valle Verde Park | 0 | Local Park 2 | 4 | |
14234 | 14234 | 14233 | {"type": "Polygon", "coordinates": [[[-121.9381, 37.74068], [-121.93767, 37.74085], [-121.93742, 37.74094], [-121.93721, 37.74099], [-121.93699, 37.74102], [-121.93652, 37.74105], [-121.93627, 37.74109], [-121.93549, 37.7397], [-121.93684, 37.73917], [-121.9381, 37.74068]]]} | Restricted Access 2 | 44112 | Walt Disney School Park | 27245 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 6.985 | Walt Disney School Park | 0 | Local Park 2 | 4 | |
3663 | 3663 | 3662 | {"type": "Polygon", "coordinates": [[[-118.35756, 33.87843], [-118.35626, 33.87843], [-118.35625, 33.87755], [-118.3565, 33.87755], [-118.35651, 33.87731], [-118.35663, 33.87731], [-118.35663, 33.87709], [-118.35756, 33.87709], [-118.35756, 33.87843]]]} | Restricted Access 2 | 44123 | William Green Park | 27544 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/williamgreenpark.pdf | Los Angeles 6 | 4.064 | William Green Park | 0 | Local Park 2 | 4 |
15126 | 15126 | 15125 | {"type": "Polygon", "coordinates": [[[-118.14136, 34.15891], [-118.14137, 34.15954], [-118.14136, 34.15957], [-118.14132, 34.15958], [-118.14069, 34.15958], [-118.14069, 34.15892], [-118.14136, 34.15891]]]} | Restricted Access 2 | 45946 | James Madison Park | 29094 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://pasadenacsp.org/pcsp/site/joint_use/ | Los Angeles 6 | 1.131 | James Madison Park | 0 | Local Park 2 | 4 |
15127 | 15127 | 15126 | {"type": "Polygon", "coordinates": [[[-118.17896, 34.16949], [-118.17802, 34.16949], [-118.17798, 34.1694], [-118.17765, 34.1694], [-118.17765, 34.16937], [-118.17745, 34.16924], [-118.17743, 34.16921], [-118.17744, 34.16919], [-118.17742, 34.16917], [-118.17731, 34.1689], [-118.17725, 34.16889], [-118.17724, 34.16868], [-118.17682, 34.16868], [-118.17682, 34.1686], [-118.1774, 34.1686], [-118.17741, 34.16854], [-118.17892, 34.16941], [-118.17896, 34.16949]]]} | Restricted Access 2 | 45947 | Linda Vista Park | 29095 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.lvaa.net/linda-vista-park.html | Los Angeles 6 | 2.012 | Linda Vista Park | 0 | Local Park 2 | 4 |
15128 | 15128 | 15127 | {"type": "Polygon", "coordinates": [[[-118.13599, 34.13887], [-118.13522, 34.13887], [-118.13522, 34.13738], [-118.13596, 34.13739], [-118.13596, 34.13773], [-118.13594, 34.13774], [-118.13595, 34.13826], [-118.13598, 34.13827], [-118.13599, 34.13887]]]} | Restricted Access 2 | 45948 | McKinley School Park | 29097 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://pasadenacsp.org/pcsp/site/joint_use/ | Los Angeles 6 | 2.802 | McKinley School Park | 0 | Local Park 2 | 4 |
15164 | 15164 | 15163 | {"type": "Polygon", "coordinates": [[[-118.19697, 33.98506], [-118.19692, 33.98539], [-118.196, 33.9853], [-118.19606, 33.98497], [-118.19697, 33.98506]]]} | Restricted Access 2 | 46015 | Freedom Park Athletic Field | 29338 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1142 | Huntington Park, City of 83 | City 2 | City Agency 2 | Los Angeles 6 | 0.778 | Freedom Park Athletic Field | 0 | Local Recreation Area 3 | 4 | |
6617 | 6617 | 6616 | {"type": "Polygon", "coordinates": [[[-118.39361, 34.0222], [-118.39299, 34.02292], [-118.39286, 34.02283], [-118.39221, 34.02248], [-118.39279, 34.02174], [-118.39361, 34.0222]]]} | Restricted Access 2 | 4230 | Linwood E. Howe Playground | 29386 | 2367 | Culver City Unified School District 789 | Special District 4 | School District 14 | http://www.ccusd.org/ | Special District 4 | 2367 | Culver City Unified School District 768 | Special District 4 | School District 21 | Los Angeles 6 | 2.149 | Linwood E. Howe Playground | 0 | Local Recreation Area 3 | 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]);