units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
71 rows where ACCESS_TYP = 2, COUNTY = 6, LAYER = 4 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID
MNG_AGENCY 24
- Whittier, City of 18
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- Lawndale, City of 4
- Los Angeles, City of 3
- Palmdale, City of 3
- Pasadena, City of 3
- San Gabriel, City of 3
- Glendora, City of 2
- Sierra Madre, City of 2
- South El Monte, City of 2
- Huntington Park, City of 1
- Burbank, City of 1
- Azusa, 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
- Malibu, City of 1
DES_TP 2
MNG_AG_TYP 1
- City Agency · 71 ✖
ACCESS_TYP 1
- Restricted Access · 71 ✖
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 | |
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 |
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 | |
5725 | 5725 | 5724 | {"type": "Polygon", "coordinates": [[[-117.99673, 33.93815], [-117.99599, 33.93932], [-117.99462, 33.93933], [-117.9946, 33.93877], [-117.99468, 33.93871], [-117.99477, 33.93872], [-117.99483, 33.93869], [-117.99485, 33.93866], [-117.99484, 33.93805], [-117.99631, 33.93805], [-117.99648, 33.93807], [-117.99673, 33.93815]]]} | Restricted Access 2 | 46580 | Leffingwell Elementary School Park | 31918 | 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.265 | Leffingwell Elementary School Park | 0 | Local Park 2 | 4 | |
10780 | 10780 | 10779 | {"type": "Polygon", "coordinates": [[[-117.76612, 34.10899], [-117.7652, 34.11126], [-117.76228, 34.1103], [-117.76223, 34.11016], [-117.76212, 34.10995], [-117.76202, 34.1098], [-117.7623, 34.10965], [-117.76255, 34.10947], [-117.76279, 34.10925], [-117.76296, 34.10904], [-117.76318, 34.10868], [-117.7637, 34.10752], [-117.76409, 34.10765], [-117.76407, 34.10773], [-117.76441, 34.10784], [-117.76461, 34.10794], [-117.76462, 34.10793], [-117.76466, 34.10782], [-117.76493, 34.10789], [-117.76612, 34.10899]]]} | Restricted Access 2 | 20550 | La Verne Sports Park | 31619 | 2398 | Bonita Unified School District 956 | Special District 4 | School District 14 | http://do.bonita.k12.ca.us/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 22.089 | La Verne Sports Park | 0 | Local Recreation Area 3 | 4 | |
10833 | 10833 | 10832 | {"type": "Polygon", "coordinates": [[[-118.04952, 34.04372], [-118.04824, 34.04477], [-118.04749, 34.04407], [-118.04784, 34.04378], [-118.0473, 34.04332], [-118.04797, 34.0428], [-118.04825, 34.04303], [-118.04849, 34.04284], [-118.04952, 34.04372]]]} | Restricted Access 2 | 20608 | Shiveley Park | 31648 | 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.916 | Shiveley Park | 0 | Local Park 2 | 4 | |
10843 | 10843 | 10842 | {"type": "Polygon", "coordinates": [[[-118.41941, 33.92466], [-118.4187, 33.92467], [-118.4187, 33.92444], [-118.41841, 33.92444], [-118.41841, 33.92366], [-118.41941, 33.92366], [-118.41941, 33.92466]]]} | Restricted Access 2 | 20624 | Richmond Street Field | 31642 | 2378 | El Segundo Unified School District 958 | Special District 4 | School District 14 | http://www.elsegundousd.net/ | Special District 4 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 2.392 | Richmond Street Field | 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]);