superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
465 rows where MNG_AGENCY = 24 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 4
- Open Access 431
- Restricted Access 20
- No Public Access 11
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 465
MNG_AGENCY 1
- Los Angeles, City of · 465 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME ▲ | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-118.52574, 34.28307], [-118.52532, 34.28336], [-118.5247, 34.28385], [-118.52397, 34.28304], [-118.52299, 34.28249], [-118.52309, 34.28228], [-118.52327, 34.28207], [-118.52344, 34.28194], [-118.52411, 34.28154], [-118.52433, 34.28135], [-118.52467, 34.28097], [-118.52474, 34.28095], [-118.52478, 34.28098], [-118.52495, 34.28132], [-118.5251, 34.28185], [-118.52519, 34.28208], [-118.52531, 34.2823], [-118.52559, 34.2827], [-118.52567, 34.28285], [-118.52574, 34.28307]]]} | Open Access 1 | Zelzah Park | 27861 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.729 | Zelzah Park | ||
11438 | 11438 | 11437 | {"type": "Polygon", "coordinates": [[[-118.20833, 34.13041], [-118.20832, 34.13374], [-118.20706, 34.13351], [-118.20706, 34.13058], [-118.20833, 34.13041]]]} | Open Access 1 | Yosemite Recreation Center | 27785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 10.005 | Yosemite Rec. Ctr. | ||
631 | 631 | 630 | {"type": "Polygon", "coordinates": [[[-118.20749, 34.12111], [-118.2074, 34.12143], [-118.20711, 34.12138], [-118.20707, 34.12135], [-118.20707, 34.12132], [-118.20714, 34.12105], [-118.20749, 34.12111]]]} | Open Access 1 | York Boulevard Pocket Park | https://www.laparks.org/park/york-boulevard-park | 32599 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.293 | York Boulevard PP | |
11990 | 11990 | 11989 | {"type": "Polygon", "coordinates": [[[-118.20626, 34.09845], [-118.20591, 34.09868], [-118.20587, 34.09831], [-118.20587, 34.09831], [-118.20626, 34.09845]]]} | Open Access 1 | Woodside Triangle | 28859 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.175 | Woodside Triangle | ||
697 | 697 | 696 | {"type": "Polygon", "coordinates": [[[-118.61446, 34.17738], [-118.61023, 34.17739], [-118.61032, 34.17679], [-118.61033, 34.17586], [-118.61035, 34.17575], [-118.61046, 34.17557], [-118.61346, 34.17557], [-118.61355, 34.17563], [-118.61364, 34.17565], [-118.61441, 34.17565], [-118.61445, 34.1757], [-118.61446, 34.17738]]]} | Open Access 1 | Woodland Hills Recreation Center | http://www.laparks.org/dos/reccenter/facility/woodlandhillsrc.htm | 30898 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 18.773 | Woodland Hills Rec. Ctr. | |
11367 | 11367 | 11366 | {"type": "Polygon", "coordinates": [[[-118.37681, 34.15021], [-118.37679, 34.15024], [-118.37675, 34.15026], [-118.37608, 34.15026], [-118.37583, 34.14876], [-118.3746, 34.14875], [-118.3746, 34.14836], [-118.37468, 34.14841], [-118.37483, 34.14845], [-118.3751, 34.14845], [-118.37511, 34.14844], [-118.37561, 34.14841], [-118.37563, 34.1485], [-118.37567, 34.14856], [-118.37575, 34.14861], [-118.37583, 34.14864], [-118.37664, 34.14864], [-118.37668, 34.14866], [-118.3767, 34.14869], [-118.37672, 34.14904], [-118.37681, 34.1494], [-118.37681, 34.15021]]]} | Open Access 1 | Woodbridge Park | 27686 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.319 | Woodbridge Park | ||
11286 | 11286 | 11285 | {"type": "Polygon", "coordinates": [[[-118.40895, 34.028], [-118.40843, 34.0283], [-118.40795, 34.02768], [-118.40848, 34.0274], [-118.40895, 34.028]]]} | Open Access 1 | Woodbine Park | 27680 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.165 | Woodbine Park | ||
11349 | 11349 | 11348 | {"type": "Polygon", "coordinates": [[[-118.57323, 34.22459], [-118.57149, 34.22459], [-118.57148, 34.22451], [-118.57127, 34.22451], [-118.57122, 34.22448], [-118.5712, 34.22139], [-118.57323, 34.22139], [-118.57323, 34.22459]]]} | Open Access 1 | Winnetka Recreation Center | 27649 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 16.271 | Winnetka Rec. Ctr. | ||
11936 | 11936 | 11935 | {"type": "Polygon", "coordinates": [[[-118.31504, 34.05232], [-118.31497, 34.05239], [-118.31494, 34.05241], [-118.31469, 34.05242], [-118.31465, 34.0524], [-118.31463, 34.05237], [-118.31463, 34.05232], [-118.31504, 34.05232]]]} | Open Access 1 | Wilton Place Park | 28736 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.082 | Wilton Place Park | ||
11297 | 11297 | 11296 | {"type": "Polygon", "coordinates": [[[-118.26239, 33.78114], [-118.2619, 33.78117], [-118.26187, 33.78079], [-118.26235, 33.78076], [-118.26239, 33.78114]]]} | Open Access 1 | Wilmington Town Square | 27600 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.479 | Wilmington Town Square | ||
715 | 715 | 714 | {"type": "Polygon", "coordinates": [[[-118.26976, 33.7748], [-118.2695, 33.77482], [-118.26952, 33.77513], [-118.2687, 33.77517], [-118.26849, 33.77245], [-118.26957, 33.77239], [-118.26976, 33.7748]]]} | Open Access 1 | Wilmington Recreation Center | 27599 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 7.339 | Wilmington Rec. Ctr. | ||
11268 | 11268 | 11267 | {"type": "Polygon", "coordinates": [[[-118.24936, 33.93257], [-118.24848, 33.93258], [-118.24841, 33.93254], [-118.24704, 33.93254], [-118.24703, 33.93182], [-118.24935, 33.9318], [-118.24936, 33.93257]]]} | Open Access 1 | William Nickerson Recreation Center | 27554 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.332 | William Nickerson Rec. Ctr. | ||
11204 | 11204 | 11203 | {"type": "Polygon", "coordinates": [[[-118.29052, 33.70593], [-118.29052, 33.70629], [-118.2901, 33.70629], [-118.28968, 33.70635], [-118.28937, 33.70643], [-118.28917, 33.70649], [-118.28883, 33.70664], [-118.28863, 33.70632], [-118.28909, 33.70613], [-118.28954, 33.70601], [-118.29003, 33.70594], [-118.29052, 33.70593]]]} | Open Access 1 | Wilder's Addition (Point Fermin Park) | 27505 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.693 | Wilder's Addition (Point Fermin Park) | ||
9618 | 9618 | 9617 | {"type": "Polygon", "coordinates": [[[-118.55793, 34.28887], [-118.55765, 34.28932], [-118.55729, 34.29006], [-118.55645, 34.28989], [-118.55582, 34.28949], [-118.55571, 34.28898], [-118.55575, 34.28896], [-118.55581, 34.28854], [-118.55421, 34.28854], [-118.55552, 34.28833], [-118.55589, 34.28831], [-118.55632, 34.28833], [-118.55686, 34.28841], [-118.55729, 34.28854], [-118.55775, 34.28874], [-118.55791, 34.28882], [-118.55793, 34.28887]]]} | Open Access 1 | Wilbur Tampa Park | 27492 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 7.284 | Wilbur Tampa Park | ||
11953 | 11953 | 11952 | {"type": "MultiPolygon", "coordinates": [[[[-118.36143, 34.17579], [-118.36127, 34.1758], [-118.36022, 34.17494], [-118.35903, 34.17411], [-118.35811, 34.17344], [-118.35805, 34.17299], [-118.35808, 34.17295], [-118.35817, 34.17297], [-118.36047, 34.17457], [-118.36049, 34.17484], [-118.36081, 34.17486], [-118.36142, 34.17536], [-118.36143, 34.17579]]], [[[-118.36606, 34.17927], [-118.36606, 34.17933], [-118.36541, 34.1793], [-118.36259, 34.17692], [-118.3625, 34.17681], [-118.36278, 34.17658], [-118.36295, 34.17663], [-118.36606, 34.17927]]]]} | Open Access 1 | Whitnall Highway Park | 28778 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.079 | Whitnall Highway Park | ||
11182 | 11182 | 11181 | {"type": "Polygon", "coordinates": [[[-118.31996, 33.71882], [-118.31992, 33.71892], [-118.31987, 33.71898], [-118.31931, 33.71943], [-118.31914, 33.71952], [-118.31826, 33.71986], [-118.31801, 33.71998], [-118.31765, 33.72021], [-118.31693, 33.72077], [-118.3164, 33.7211], [-118.31544, 33.72053], [-118.3148, 33.72061], [-118.31405, 33.72094], [-118.31274, 33.72104], [-118.3129, 33.72083], [-118.31202, 33.71937], [-118.31156, 33.71925], [-118.31157, 33.71814], [-118.31151, 33.71788], [-118.31141, 33.71763], [-118.31133, 33.7175], [-118.31115, 33.71727], [-118.31097, 33.71709], [-118.31084, 33.71699], [-118.31054, 33.71683], [-118.31, 33.71662], [-118.31115, 33.71474], [-118.31773, 33.71644], [-118.31775, 33.71647], [-118.31794, 33.71655], [-118.31807, 33.71666], [-118.31897, 33.71778], [-118.31913, 33.71793], [-118.31938, 33.71815], [-118.31973, 33.71838], [-118.31958, 33.71856], [-118.31996, 33.71882]]]} | Open Access 1 | White Point Nature Preserve | 27463 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 95.026 | White Point Nature Preserve | ||
9569 | 9569 | 9568 | {"type": "MultiPolygon", "coordinates": [[[[-118.44903, 34.05338], [-118.44583, 34.0553], [-118.44413, 34.05332], [-118.44804, 34.05223], [-118.44903, 34.05338]]], [[[-118.44909, 34.052], [-118.44847, 34.05236], [-118.44679, 34.05041], [-118.44817, 34.04958], [-118.44909, 34.052]]]]} | Open Access 1 | Westwood Park | 27441 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 26.686 | Westwood Park | ||
11989 | 11989 | 11988 | {"type": "Polygon", "coordinates": [[[-118.44182, 34.05762], [-118.44151, 34.05771], [-118.44138, 34.05738], [-118.44169, 34.0573], [-118.44182, 34.05762]]]} | Open Access 1 | Westwood Gardens Park | 28858 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.287 | Westwood Gardens Park | ||
11151 | 11151 | 11150 | {"type": "MultiPolygon", "coordinates": [[[[-118.37173, 34.02977], [-118.37167, 34.03005], [-118.37157, 34.03032], [-118.37117, 34.03022], [-118.37129, 34.02989], [-118.37097, 34.02971], [-118.37016, 34.02987], [-118.36964, 34.02932], [-118.36974, 34.02903], [-118.36844, 34.02832], [-118.36844, 34.02807], [-118.36848, 34.02804], [-118.36852, 34.02803], [-118.37167, 34.02976], [-118.37173, 34.02977]]], [[[-118.37079, 34.03204], [-118.37067, 34.03229], [-118.37063, 34.03231], [-118.3704, 34.03231], [-118.3705, 34.03204], [-118.37079, 34.03204]]], [[[-118.37106, 34.03142], [-118.37082, 34.03199], [-118.37049, 34.03199], [-118.37075, 34.03131], [-118.37103, 34.03138], [-118.37106, 34.03142]]]]} | Open Access 1 | Westside Neighborhood Park | 27423 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.933 | Westside Neighborhood Park | ||
11146 | 11146 | 11145 | {"type": "Polygon", "coordinates": [[[-118.51707, 34.12476], [-118.51169, 34.12287], [-118.50522, 34.11808], [-118.50208, 34.11085], [-118.50114, 34.10951], [-118.50141, 34.10932], [-118.50238, 34.11073], [-118.5055, 34.11792], [-118.50867, 34.12027], [-118.50994, 34.11967], [-118.51004, 34.12128], [-118.51187, 34.12264], [-118.51704, 34.12445], [-118.51707, 34.12476]]]} | Open Access 1 | Westridge-Canyonback Wilderness Park of LA | 27417 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 20.362 | Westridge-Canyonback Wilderness Park of LA |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);