units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
128 rows where AGNCY_TYP = 14 and DES_TP = 2 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Whittier, City of 18
- Los Angeles Unified School District 15
- San Ramon, City of 13
- Manhattan Beach, City of 8
- Arcadia, City of 7
- Beverly Hills, City of 5
- Hollister, City of 4
- Azusa Unified School District 4
- Los Angeles, City of 3
- Palmdale, City of 3
- Pasadena, City of 3
- Lawndale, City of 3
- Conejo Valley Unified School District 3
- Glendora, City of 2
- Carlsbad, 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
- Los Nietos School District 2
- San Diego, City of 1
- Los Angeles, County of 1
- Santa Ana, City of 1
- Santa Rosa, City of 1
- Santa Maria, City of 1
- Encinitas, City of 1
- Oceanside, City of 1
- El Centro, City of 1
- Azusa, City of 1
- San Bernardino, City of 1
- …
MNG_AG_TYP 3
- City Agency 94
- School District 32
- County Agency 2
ACCESS_TYP 2
- Restricted Access 125
- Open Access 3
DES_TP 1
- Local Park · 128 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5896 | 5896 | 5895 | {"type": "Polygon", "coordinates": [[[-117.06009, 32.76351], [-117.05994, 32.76363], [-117.05895, 32.76366], [-117.05892, 32.76238], [-117.06004, 32.76235], [-117.06009, 32.76351]]]} | Restricted Access 2 | 46816 | Clay Elementary School Park | 31950 | 2310 | San Diego Unified School District 820 | Special District 4 | School District 14 | http://www.sandi.net/sandi | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.701 | Clay Elementary 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 | |
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 | |
12210 | 12210 | 12209 | {"type": "Polygon", "coordinates": [[[-118.2635, 34.06257], [-118.26306, 34.06324], [-118.26301, 34.06325], [-118.26135, 34.0625], [-118.2617, 34.06184], [-118.2635, 34.06257]]]} | Restricted Access 2 | 46871 | Belmont High School Park | 31940 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.751 | Belmont High School Park | 0 | Local Park 2 | 4 | |
12253 | 12253 | 12252 | {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20166, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.2012, 34.07523], [-118.20091, 34.07524], [-118.2009, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20177, 34.07498], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} | Restricted Access 2 | 46874 | Abraham Lincoln High School Park | 31843 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.467 | Abraham Lincoln High School Park | 0 | Local Park 2 | 4 | |
12267 | 12267 | 12266 | {"type": "Polygon", "coordinates": [[[-118.50705, 34.19144], [-118.50564, 34.19144], [-118.5056, 34.19012], [-118.50703, 34.19012], [-118.50705, 34.19144]]]} | Restricted Access 2 | 46875 | Birmingham High School Park | 31941 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.741 | Birmingham High School Park | 0 | Local Park 2 | 4 | |
14159 | 14159 | 14158 | {"type": "Polygon", "coordinates": [[[-122.75048, 38.43421], [-122.74811, 38.43393], [-122.74801, 38.43312], [-122.75043, 38.43316], [-122.75037, 38.43323], [-122.75048, 38.43421]]]} | Restricted Access 2 | 44115 | J.X. Wilson Park | 31385 | 2307 | Wright Elementary School District 1089 | Special District 4 | School District 14 | http://www.wrightesd.org/site/default.aspx?PageID=1 | Special District 4 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.235 | J.X. Wilson Park | 0 | Local Park 2 | 4 | |
9611 | 9611 | 9610 | {"type": "Polygon", "coordinates": [[[-120.42789, 34.94443], [-120.42481, 34.9444], [-120.42478, 34.94205], [-120.42786, 34.94209], [-120.42789, 34.94443]]]} | Open Access 1 | 47985 | Alice Threfts Park | 15362 | 2421 | Allan Hancock Community College District 917 | Special District 4 | School District 14 | https://www.hancockcollege.edu/ | Special District 4 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 18.102 | Alice Threfts Park | 0 | Local Park 2 | 4 | |
7621 | 7621 | 7620 | {"type": "Polygon", "coordinates": [[[-117.28518, 33.02562], [-117.28529, 33.02578], [-117.28529, 33.02582], [-117.28512, 33.0259], [-117.28506, 33.02592], [-117.28492, 33.02592], [-117.28455, 33.02589], [-117.28394, 33.02578], [-117.28407, 33.02539], [-117.28421, 33.02491], [-117.28411, 33.02487], [-117.28368, 33.02416], [-117.2841, 33.02397], [-117.28416, 33.02397], [-117.28518, 33.02562]]]} | Restricted Access 2 | 47635 | George Berkich Park | 31614 | 2412 | Cardiff School District 875 | Special District 4 | School District 14 | http://cardiffschools.com/ | Special District 4 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.697 | George Berkich Park | 0 | Local Park 2 | 4 | |
2098 | 2098 | 2097 | {"type": "Polygon", "coordinates": [[[-121.89542, 37.75272], [-121.89511, 37.75373], [-121.89391, 37.75351], [-121.89423, 37.75248], [-121.89542, 37.75272]]]} | Restricted Access 2 | 47568 | Live Oak School Park | 31293 | 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 | 3.116 | Live Oak School Park | 0 | Local Park 2 | 4 | |
2216 | 2216 | 2215 | {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} | Restricted Access 2 | 47570 | Windemere Ranch School Park | 31295 | 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 | 11.225 | Windemere Ranch School Park | 0 | Local Park 2 | 4 | |
7087 | 7087 | 7086 | {"type": "Polygon", "coordinates": [[[-121.92827, 37.77727], [-121.92804, 37.77725], [-121.92771, 37.77676], [-121.92634, 37.77723], [-121.92635, 37.77729], [-121.92603, 37.77741], [-121.9262, 37.77696], [-121.9263, 37.77648], [-121.92639, 37.77623], [-121.92667, 37.7756], [-121.9268, 37.77502], [-121.92685, 37.77498], [-121.9269, 37.775], [-121.927, 37.7751], [-121.92718, 37.77522], [-121.92806, 37.7757], [-121.92824, 37.7757], [-121.92827, 37.77727]]]} | Restricted Access 2 | 47564 | Coyote Creek School Park | 31288 | 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 | 7.42 | Coyote Creek School Park | 0 | Local Park 2 | 4 | |
7088 | 7088 | 7087 | {"type": "Polygon", "coordinates": [[[-121.89439, 37.76297], [-121.89423, 37.7636], [-121.89427, 37.76362], [-121.89343, 37.76401], [-121.89292, 37.7633], [-121.89275, 37.7633], [-121.89268, 37.76317], [-121.89342, 37.76277], [-121.89439, 37.76297]]]} | Restricted Access 2 | 47566 | Hidden Hills School Park | 31291 | 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 | 3.032 | Hidden Hills School Park | 0 | Local Park 2 | 4 | |
13103 | 13103 | 13102 | {"type": "Polygon", "coordinates": [[[-121.91287, 37.76913], [-121.91284, 37.76942], [-121.91276, 37.76971], [-121.91183, 37.77083], [-121.91053, 37.77015], [-121.91165, 37.76845], [-121.91176, 37.76849], [-121.91249, 37.76818], [-121.91267, 37.76845], [-121.91277, 37.76865], [-121.91284, 37.76889], [-121.91287, 37.76913]]]} | Restricted Access 2 | 35021 | Gale Ranch Middle School Park | 31290 | 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.61 | Gale Ranch Middle 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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);