units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
92 rows where AGNCY_LEV = 4, COUNTY = 6 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, YR_EST
MNG_AGENCY >30
- Whittier, City of 18
- Manhattan Beach, City of 8
- Arcadia, City of 7
- Los Angeles, City of 5
- Beverly Hills, City of 5
- Palmdale, City of 4
- Sierra Madre, City of 4
- Santa Clarita, City of 4
- Bellflower, City of 4
- Lawndale, City of 4
- Pasadena, City of 3
- San Gabriel, City of 3
- Glendora, City of 2
- La Verne, City of 2
- Duarte, City of 2
- South El Monte, City of 2
- Culver City, City of 1
- Huntington Park, City of 1
- Rosemead, City of 1
- Burbank, City of 1
- Azusa, City of 1
- Paramount, City of 1
- Rancho Palos Verdes, City of 1
- Long Beach, City of 1
- Hawthorne, City of 1
- El Segundo, City of 1
- Monrovia, City of 1
- Calabasas, City of 1
- La Canada Flintridge, City of 1
- Pico Rivera, City of 1
- …
DES_TP 4
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 92 ✖
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 | |
944 | 944 | 943 | {"type": "Polygon", "coordinates": [[[-118.31116, 33.76052], [-118.31051, 33.76273], [-118.30904, 33.76256], [-118.30904, 33.76051], [-118.31116, 33.76052]]]} | Open Access 1 | 5973 | Eastview Park | 18401 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 9.81 | Eastview Park | 0 | Local Park 2 | 4 | |
1709 | 1709 | 1708 | {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.7567, 34.1363], [-117.75036, 34.13633], [-117.75034, 34.13665], [-117.75035, 34.13666], [-117.75656, 34.13663], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75215, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75024, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} | No Public Access 3 | 12846 | Live Oak Reservoir | 21375 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 112.516 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
2710 | 2710 | 2709 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79347], [-118.17189, 33.79348]]]} | Open Access 1 | 6683 | Chittick Field | 29942 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 19.452 | Chittick Field | 2014 | Local Recreation Area 3 | 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 | |
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 |
4425 | 4425 | 4424 | {"type": "MultiPolygon", "coordinates": [[[[-118.10901, 33.88199], [-118.10866, 33.88199], [-118.10866, 33.88024], [-118.109, 33.88024], [-118.10901, 33.88199]]], [[[-118.10903, 33.88235], [-118.109, 33.88308], [-118.10866, 33.88309], [-118.10866, 33.88235], [-118.10903, 33.88235]]], [[[-118.10901, 33.8838], [-118.10866, 33.8838], [-118.10866, 33.88327], [-118.109, 33.88327], [-118.10899, 33.88344], [-118.10901, 33.8838]]], [[[-118.10904, 33.88598], [-118.10883, 33.88598], [-118.10867, 33.88576], [-118.10866, 33.88416], [-118.10901, 33.88416], [-118.10904, 33.88598]]], [[[-118.10902, 33.88748], [-118.10884, 33.88749], [-118.10874, 33.88743], [-118.10869, 33.88737], [-118.10868, 33.88706], [-118.10902, 33.88706], [-118.10902, 33.88748]]]]} | Open Access 1 | 46310 | Caruthers Park North | 29601 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 4.548 | Caruthers Park North | 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 | |
5721 | 5721 | 5720 | {"type": "Polygon", "coordinates": [[[-118.03804, 33.95602], [-118.03719, 33.95686], [-118.03667, 33.9565], [-118.03649, 33.95641], [-118.03662, 33.95617], [-118.03671, 33.9562], [-118.03678, 33.95608], [-118.03691, 33.95609], [-118.03698, 33.95594], [-118.03709, 33.95597], [-118.03726, 33.95566], [-118.03687, 33.95551], [-118.03656, 33.95547], [-118.03544, 33.95494], [-118.03587, 33.95451], [-118.03804, 33.95602]]]} | Restricted Access 2 | 46576 | Laurel Elementary School Park | 31914 | 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.34 | Laurel Elementary School Park | 0 | Local Park 2 | 4 | |
5722 | 5722 | 5721 | {"type": "Polygon", "coordinates": [[[-118.00903, 33.93231], [-118.00901, 33.93505], [-118.00717, 33.93505], [-118.00718, 33.93474], [-118.00684, 33.93474], [-118.00684, 33.93436], [-118.00787, 33.93437], [-118.00787, 33.93381], [-118.00782, 33.9337], [-118.00791, 33.93347], [-118.00798, 33.93313], [-118.00801, 33.93308], [-118.00808, 33.93307], [-118.00826, 33.93307], [-118.00832, 33.93305], [-118.00837, 33.93301], [-118.00852, 33.93231], [-118.00903, 33.93231]]]} | Restricted Access 2 | 46577 | Hillview Middle School Park | 31915 | 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 | 8.349 | Hillview Middle School Park | 0 | Local Park 2 | 4 | |
5723 | 5723 | 5722 | {"type": "Polygon", "coordinates": [[[-118.0221, 33.92802], [-118.02161, 33.92867], [-118.02021, 33.92797], [-118.02072, 33.92729], [-118.0221, 33.92802]]]} | Restricted Access 2 | 46578 | La Colima Elementary School Park | 31916 | 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.236 | La Colima Elementary School Park | 0 | Local Park 2 | 4 | |
5724 | 5724 | 5723 | {"type": "Polygon", "coordinates": [[[-118.02929, 33.94516], [-118.02862, 33.94584], [-118.02768, 33.94519], [-118.02852, 33.94479], [-118.02853, 33.94477], [-118.02849, 33.94475], [-118.02862, 33.94468], [-118.02929, 33.94516]]]} | Restricted Access 2 | 46579 | Mulberry Elementary School Park | 31917 | 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 | 2.31 | Mulberry 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]);