units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where ACCESS_TYP = 2, COUNTY = 6, DES_TP = 2 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_ID, PARK_URL, YR_EST
MNG_AGENCY 27
- Whittier, City of 20
- Los Angeles, City of 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- Pasadena, City of 4
- Lawndale, City of 4
- Glendora, City of 3
- Palmdale, City of 3
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- South El Monte, City of 2
- San Gabriel, City of 2
- Burbank, City of 1
- Azusa, City of 1
- Redondo Beach, City of 1
- Lynwood, City of 1
- Compton, City of 1
- Paramount, City of 1
- Palos Verdes Estates, City of 1
- Hermosa Beach, City of 1
- Hawthorne, City of 1
- Santa Clarita, City of 1
- La Mirada, City of 1
- Duarte, City of 1
MNG_AG_TYP 1
- City Agency 84
DES_TP 1
- Local Park · 84 ✖
ACCESS_TYP 1
- Restricted Access · 84 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 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 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | Los Angeles 6 | 1.599 | Miller Park | 0 | Local Park 2 | 4 |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.535 | Holmby Park | 0 | Local Park 2 | 4 | |
3049 | 3049 | 3048 | {"type": "Polygon", "coordinates": [[[-118.16091, 34.13982], [-118.15954, 34.13982], [-118.15942, 34.13859], [-118.16072, 34.13858], [-118.16072, 34.13907], [-118.16084, 34.13908], [-118.16091, 34.13982]]]} | Restricted Access 2 | 24522 | Wrigley Gardens | 32656 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.163 | Wrigley Gardens | 0 | Local Park 2 | 4 | |
3545 | 3545 | 3544 | {"type": "Polygon", "coordinates": [[[-118.04485, 34.04282], [-118.04349, 34.04401], [-118.04261, 34.04329], [-118.04286, 34.04329], [-118.04283, 34.04288], [-118.04383, 34.04199], [-118.0448, 34.04278], [-118.04482, 34.04281], [-118.04485, 34.04282]]]} | Restricted Access 2 | 20607 | New Temple Park | 31632 | 2383 | Valle Lindo Unified School District 658 | Special District 4 | School District 14 | http://www.vallelindo.k12.ca.us/ | Special District 4 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | Los Angeles 6 | 5.682 | New Temple 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 |
3922 | 3922 | 3921 | {"type": "Polygon", "coordinates": [[[-118.17903, 34.59426], [-118.17429, 34.59426], [-118.17423, 34.59106], [-118.17426, 34.59084], [-118.17426, 34.59041], [-118.17434, 34.59034], [-118.17507, 34.59036], [-118.17509, 34.59034], [-118.17895, 34.59035], [-118.17903, 34.59426]]]} | Restricted Access 2 | 46141 | Highland High School Park | 31877 | 2388 | Antelope Valley Union High School District 698 | Special District 4 | School District 14 | http://www.avdistrict.org/ | Special District 4 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 46.587 | Highland High School Park | 0 | Local Park 2 | 4 | |
3932 | 3932 | 3931 | {"type": "Polygon", "coordinates": [[[-118.4757, 34.42905], [-118.47423, 34.42905], [-118.4742, 34.42839], [-118.47412, 34.42835], [-118.47409, 34.42733], [-118.47558, 34.42732], [-118.47558, 34.42796], [-118.47557, 34.42802], [-118.47558, 34.42841], [-118.47568, 34.42842], [-118.4757, 34.42905]]]} | Restricted Access 2 | 46226 | North Oaks Park | 31633 | 2389 | William S. Hart Union High School District 702 | Special District 4 | School District 14 | http://www.hartdistrict.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=413 | Los Angeles 6 | 6.399 | North Oaks Park | 0 | Local Park 2 | 4 |
3975 | 3975 | 3974 | {"type": "Polygon", "coordinates": [[[-118.01891, 33.96032], [-118.01812, 33.96131], [-118.01618, 33.96022], [-118.01659, 33.95971], [-118.01891, 33.96032]]]} | Restricted Access 2 | 46582 | Ocean View Elementary School Park | 31920 | 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.333 | Ocean View Elementary School Park | 0 | Local Park 2 | 4 | |
3978 | 3978 | 3977 | {"type": "Polygon", "coordinates": [[[-118.05658, 34.16669], [-118.05578, 34.16669], [-118.05577, 34.16573], [-118.05657, 34.16571], [-118.05658, 34.16669]]]} | Restricted Access 2 | 46602 | Sierra Madre Elementary School Park | 31924 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 1.948 | Sierra Madre Elementary School Park | 0 | Local Park 2 | 4 | |
4212 | 4212 | 4211 | {"type": "Polygon", "coordinates": [[[-118.35177, 33.8854], [-118.35106, 33.8854], [-118.35104, 33.88537], [-118.35099, 33.88502], [-118.35116, 33.88502], [-118.35131, 33.88511], [-118.35148, 33.88516], [-118.35162, 33.88518], [-118.35177, 33.88517], [-118.35177, 33.8854]]]} | Restricted Access 2 | 44962 | Dan McKenzie Community Gardens | 29797 | 1172 | Lawndale, City of 484 | City 2 | City Agency 2 | http://www.lawndalecity.org/ | City 2 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/html/depthtml/csd/McKenzieGarden.html | Los Angeles 6 | 0.544 | Dan McKenzie Community Gardens | 0 | Local Park 2 | 4 |
4264 | 4264 | 4263 | {"type": "Polygon", "coordinates": [[[-118.10522, 34.07637], [-118.10463, 34.07637], [-118.10463, 34.07569], [-118.1044, 34.07568], [-118.10441, 34.07532], [-118.10455, 34.0753], [-118.10521, 34.07529], [-118.10522, 34.07637]]]} | Restricted Access 2 | 45322 | Marshall Community Park | 32836 | 1301 | San Gabriel, City of 740 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | http://www.sangabrielcity.com/539/Marshall-Park | Los Angeles 6 | 1.81 | Marshall Community Park | 0 | Local Park 2 | 4 |
4318 | 4318 | 4317 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | 48251 | El Dorado Community Gardens | 32803 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 8.255 | El Dorado Community Gardens | 0 | Local Park 2 | 4 | |
4407 | 4407 | 4406 | {"type": "Polygon", "coordinates": [[[-118.14787, 33.95964], [-118.14683, 33.9602], [-118.14653, 33.95978], [-118.14761, 33.9592], [-118.14787, 33.95964]]]} | Restricted Access 2 | 46199 | Community Garden | 32757 | 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 | 1.546 | Community Garden | 0 | Local Park 2 | 4 | |
4432 | 4432 | 4431 | {"type": "Polygon", "coordinates": [[[-118.04648, 33.97899], [-118.04609, 33.979], [-118.04611, 33.97832], [-118.04619, 33.97833], [-118.04619, 33.97795], [-118.04624, 33.97795], [-118.04625, 33.97792], [-118.04643, 33.97792], [-118.04646, 33.97897], [-118.04648, 33.97899]]]} | Restricted Access 2 | 46559 | Whittier Dog Park | 29862 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.849 | Whittier Dog 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 |
4830 | 4830 | 4829 | {"type": "Polygon", "coordinates": [[[-118.01607, 33.95413], [-118.01537, 33.95498], [-118.01511, 33.95485], [-118.01456, 33.95558], [-118.01606, 33.9564], [-118.01525, 33.95741], [-118.01384, 33.95663], [-118.01356, 33.9561], [-118.0145, 33.95494], [-118.0145, 33.95492], [-118.01435, 33.95484], [-118.01524, 33.9537], [-118.01607, 33.95413]]]} | Restricted Access 2 | 46570 | East Whittier Middle School Park | 31913 | 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 | 10.453 | East Whittier Middle School Park | 0 | Local Park 2 | 4 | |
5465 | 5465 | 5464 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | Restricted Access 2 | 6273 | Zela Davis Elementary School Park | 31892 | 2044 | Hawthorne School District 808 | Special District 4 | School District 14 | http://www.hawthorne.k12.ca.us/ | Special District 4 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 1.201 | Zela Davis Elementary School Park | 0 | Local Park 2 | 4 | |
5604 | 5604 | 5603 | {"type": "Polygon", "coordinates": [[[-118.04327, 34.16534], [-118.04239, 34.16534], [-118.04238, 34.16395], [-118.04326, 34.16394], [-118.04327, 34.16534]]]} | Restricted Access 2 | 46603 | Sierra Madre Middle School Park | 31925 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 3.117 | Sierra Madre Middle 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]);