superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
465 rows where MNG_AGENCY = 24 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME, PARK_URL, ACRES, LABEL_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12100 | 12100 | 12099 | {"type": "Polygon", "coordinates": [[[-118.66808, 34.19517], [-118.66804, 34.19881], [-118.66712, 34.1988], [-118.6671, 34.1986], [-118.66187, 34.19858], [-118.66196, 34.19793], [-118.6607, 34.19748], [-118.66049, 34.1971], [-118.66026, 34.19647], [-118.65986, 34.19603], [-118.65932, 34.19588], [-118.65877, 34.19529], [-118.65896, 34.19514], [-118.66089, 34.19511], [-118.66808, 34.19517]]]} | Open Access 1 | El Escorpion Park | 29037 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 66.952 | El Escorpion Park | ||
5761 | 5761 | 5760 | {"type": "Polygon", "coordinates": [[[-118.66738, 34.18769], [-118.66733, 34.19134], [-118.66148, 34.18951], [-118.6613, 34.18942], [-118.66109, 34.18936], [-118.65975, 34.1892], [-118.65953, 34.18919], [-118.65927, 34.1892], [-118.65868, 34.18927], [-118.65841, 34.18933], [-118.65818, 34.18941], [-118.65747, 34.18971], [-118.65772, 34.18768], [-118.66363, 34.18769], [-118.66365, 34.18691], [-118.66382, 34.1869], [-118.66509, 34.18549], [-118.66548, 34.18553], [-118.6657, 34.1858], [-118.66637, 34.18602], [-118.66659, 34.18616], [-118.66669, 34.18768], [-118.66738, 34.18769]]]} | Open Access 1 | Knapp Ranch Park | 20692 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 69.296 | Knapp Ranch Park | ||
714 | 714 | 713 | {"type": "Polygon", "coordinates": [[[-118.65865, 34.19869], [-118.65863, 34.19874], [-118.6586, 34.19985], [-118.65857, 34.20027], [-118.65854, 34.20034], [-118.65848, 34.20039], [-118.6584, 34.20041], [-118.65724, 34.2004], [-118.6572, 34.20039], [-118.65718, 34.20033], [-118.65721, 34.20009], [-118.65719, 34.19995], [-118.65714, 34.19979], [-118.65703, 34.19962], [-118.65699, 34.19959], [-118.65703, 34.19953], [-118.65687, 34.1993], [-118.65676, 34.19918], [-118.65661, 34.19907], [-118.6565, 34.19905], [-118.65678, 34.19675], [-118.65847, 34.19676], [-118.65848, 34.19859], [-118.65865, 34.19869]]]} | Open Access 1 | West Hills Recreation Center | 27360 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 16.147 | West Hills Rec. Ctr. | ||
2690 | 2690 | 2689 | {"type": "Polygon", "coordinates": [[[-118.65406, 34.20676], [-118.65401, 34.20707], [-118.65383, 34.20781], [-118.65381, 34.20784], [-118.65377, 34.20785], [-118.65337, 34.20778], [-118.65319, 34.20777], [-118.65295, 34.20779], [-118.65273, 34.20785], [-118.65253, 34.20746], [-118.65282, 34.20727], [-118.65308, 34.20706], [-118.65331, 34.20683], [-118.65352, 34.20659], [-118.65359, 34.20658], [-118.65381, 34.20667], [-118.65403, 34.20673], [-118.65406, 34.20676]]]} | Open Access 1 | Castle Peak Park | 16953 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.037 | Castle Peak Park | ||
8935 | 8935 | 8934 | {"type": "Polygon", "coordinates": [[[-118.65346, 34.21206], [-118.65173, 34.219], [-118.64897, 34.21904], [-118.64896, 34.21858], [-118.64916, 34.21842], [-118.64976, 34.21839], [-118.64975, 34.21784], [-118.64905, 34.21741], [-118.64856, 34.21792], [-118.64784, 34.21837], [-118.64645, 34.21837], [-118.64623, 34.21795], [-118.6464, 34.21788], [-118.64656, 34.21756], [-118.64664, 34.21754], [-118.64706, 34.21707], [-118.64738, 34.21705], [-118.64738, 34.21682], [-118.64756, 34.21681], [-118.64773, 34.21689], [-118.64804, 34.21662], [-118.64808, 34.2164], [-118.64825, 34.21624], [-118.64878, 34.21602], [-118.64887, 34.21596], [-118.6492, 34.21589], [-118.64935, 34.2158], [-118.64992, 34.21557], [-118.65014, 34.21553], [-118.65056, 34.21603], [-118.65075, 34.21602], [-118.65077, 34.21559], [-118.65114, 34.21515], [-118.65132, 34.21516], [-118.65163, 34.21498], [-118.65158, 34.21475], [-118.65164, 34.21473], [-118.65172, 34.21499], [-118.65221, 34.21498], [-118.65213, 34.21459], [-118.6521, 34.21423], [-118.65196, 34.21423], [-118.65201, 34.21395], [-118.65194, 34.21388], [-118.65168, 34.21378], [-118.65179, 34.21318], [-118.65268, 34.21278], [-118.65296, 34.21211], [-118.6527, 34.21155], [-118.65243, 34.2114], [-118.65196, 34.21078], [-118.65202, 34.21078], [-118.65346, 34.21206]]]} | Open Access 1 | Roscoe-Valley Circle Park | 24603 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 44.414 | Roscoe-Valley Circle Park | ||
707 | 707 | 706 | {"type": "Polygon", "coordinates": [[[-118.64797, 34.19522], [-118.64792, 34.19556], [-118.64772, 34.19554], [-118.64752, 34.19555], [-118.64721, 34.19561], [-118.64698, 34.19569], [-118.6464, 34.19595], [-118.64635, 34.19593], [-118.64625, 34.19573], [-118.64624, 34.19563], [-118.64627, 34.19542], [-118.64631, 34.19537], [-118.6464, 34.1953], [-118.64642, 34.19522], [-118.6464, 34.19518], [-118.64636, 34.19513], [-118.64629, 34.19511], [-118.64623, 34.19511], [-118.64624, 34.19507], [-118.64797, 34.19522]]]} | Open Access 1 | Mae Boyar Recreation Center | 21665 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.247 | Mae Boyar Rec. Ctr. | ||
6068 | 6068 | 6067 | {"type": "Polygon", "coordinates": [[[-118.6462, 34.21201], [-118.64612, 34.21245], [-118.64599, 34.21284], [-118.64584, 34.21312], [-118.6452, 34.21418], [-118.64505, 34.21455], [-118.64495, 34.21491], [-118.64489, 34.21494], [-118.6445, 34.21492], [-118.64449, 34.21195], [-118.64612, 34.21195], [-118.64617, 34.21197], [-118.6462, 34.21201]]]} | Open Access 1 | Lazy J Ranch Park | 21122 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.439 | Lazy J Ranch Park | ||
15417 | 15417 | 15416 | {"type": "Polygon", "coordinates": [[[-118.64349, 34.21894], [-118.64349, 34.21898], [-118.64346, 34.219], [-118.64336, 34.21902], [-118.63746, 34.21911], [-118.63782, 34.21884], [-118.63812, 34.21849], [-118.63838, 34.21802], [-118.63851, 34.21751], [-118.63864, 34.21738], [-118.63855, 34.21658], [-118.6387, 34.21672], [-118.63891, 34.21685], [-118.63909, 34.21692], [-118.63935, 34.21697], [-118.63961, 34.21698], [-118.63974, 34.21693], [-118.63988, 34.21692], [-118.63999, 34.21694], [-118.64016, 34.217], [-118.64026, 34.21702], [-118.64078, 34.21695], [-118.64225, 34.21702], [-118.64228, 34.21704], [-118.64296, 34.21848], [-118.64349, 34.21891], [-118.64349, 34.21894]]]} | Open Access 1 | Orcutt Ranch Horticultural Center Park | 23198 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 24.108 | Orcutt Ranch Horticultural Ctr. Park | ||
10237 | 10237 | 10236 | {"type": "Polygon", "coordinates": [[[-118.63871, 34.21307], [-118.63869, 34.21311], [-118.63865, 34.21313], [-118.63789, 34.21313], [-118.63786, 34.2131], [-118.63785, 34.21263], [-118.63787, 34.21258], [-118.63794, 34.21251], [-118.63796, 34.21245], [-118.63794, 34.21239], [-118.63788, 34.21235], [-118.63788, 34.21192], [-118.63813, 34.21192], [-118.63863, 34.21197], [-118.63868, 34.21199], [-118.63871, 34.21307]]]} | Open Access 1 | Taxco Trails Park | 26200 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.46 | Taxco Trails Park | ||
3047 | 3047 | 3046 | {"type": "Polygon", "coordinates": [[[-118.63562, 34.20587], [-118.63458, 34.20588], [-118.63453, 34.20586], [-118.6345, 34.20581], [-118.63451, 34.2052], [-118.63453, 34.20518], [-118.63458, 34.20516], [-118.63488, 34.20516], [-118.63503, 34.20521], [-118.6351, 34.20519], [-118.63514, 34.20515], [-118.63562, 34.20515], [-118.63562, 34.20587]]]} | Open Access 1 | Cohasset Melba Park | 17478 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.993 | Cohasset Melba Park | ||
2866 | 2866 | 2865 | {"type": "Polygon", "coordinates": [[[-118.63032, 34.2401], [-118.62961, 34.24045], [-118.6291, 34.24082], [-118.62822, 34.24015], [-118.62857, 34.24003], [-118.62851, 34.23987], [-118.62939, 34.2397], [-118.62948, 34.2399], [-118.62968, 34.23989], [-118.62987, 34.23992], [-118.63032, 34.2401]]]} | Open Access 1 | Chatsworth Oaks Park | 17158 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.915 | Chatsworth Oaks Park | ||
2868 | 2868 | 2867 | {"type": "Polygon", "coordinates": [[[-118.62354, 34.26184], [-118.6234, 34.26183], [-118.62333, 34.26212], [-118.62317, 34.2622], [-118.62319, 34.26224], [-118.62331, 34.26223], [-118.62354, 34.26226], [-118.62353, 34.26325], [-118.62191, 34.26307], [-118.62194, 34.26281], [-118.62193, 34.26279], [-118.62132, 34.26277], [-118.62077, 34.2628], [-118.62031, 34.26287], [-118.61946, 34.26308], [-118.6195, 34.26282], [-118.61921, 34.26278], [-118.61918, 34.2628], [-118.61915, 34.26305], [-118.6192, 34.26311], [-118.61928, 34.26312], [-118.61918, 34.26316], [-118.61917, 34.26344], [-118.61693, 34.26401], [-118.61694, 34.26081], [-118.61515, 34.2603], [-118.61481, 34.26029], [-118.61484, 34.25721], [-118.61543, 34.25721], [-118.61707, 34.25972], [-118.61812, 34.25972], [-118.62027, 34.25826], [-118.62354, 34.2616], [-118.62354, 34.26184]]]} | Open Access 1 | Chatsworth Park South | 17160 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 73.616 | Chatsworth Park South | ||
9541 | 9541 | 9540 | {"type": "Polygon", "coordinates": [[[-118.62116, 34.19554], [-118.62038, 34.19554], [-118.62038, 34.19646], [-118.61902, 34.19646], [-118.61901, 34.19385], [-118.62116, 34.19384], [-118.62116, 34.19554]]]} | Open Access 1 | Shadow Ranch Park | 25341 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 12.342 | Shadow Ranch Park | ||
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-118.61866, 34.22438], [-118.61702, 34.22438], [-118.61702, 34.22381], [-118.61712, 34.2234], [-118.61717, 34.22331], [-118.61734, 34.22315], [-118.61739, 34.22304], [-118.61738, 34.22293], [-118.61725, 34.22276], [-118.61762, 34.22275], [-118.61781, 34.22277], [-118.61799, 34.2228], [-118.61865, 34.22298], [-118.61866, 34.22438]]]} | Open Access 1 | Chase Park | 17156 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.968 | Chase Park | ||
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. | |
10005 | 10005 | 10004 | {"type": "Polygon", "coordinates": [[[-118.60611, 34.26878], [-118.60611, 34.26934], [-118.60608, 34.26959], [-118.60594, 34.27024], [-118.60589, 34.2704], [-118.60577, 34.27068], [-118.60558, 34.27109], [-118.60541, 34.27132], [-118.60497, 34.27197], [-118.60492, 34.27207], [-118.60295, 34.27218], [-118.60241, 34.27215], [-118.60187, 34.27206], [-118.60196, 34.27125], [-118.60202, 34.27092], [-118.60211, 34.27059], [-118.60224, 34.27028], [-118.60244, 34.26991], [-118.60264, 34.26961], [-118.60297, 34.2692], [-118.60317, 34.26902], [-118.60357, 34.26878], [-118.60611, 34.26878]]]} | Open Access 1 | Stoney Point Park | 25899 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 28.626 | Stoney Point Park | ||
10275 | 10275 | 10274 | {"type": "Polygon", "coordinates": [[[-118.60581, 34.21744], [-118.60579, 34.21747], [-118.60575, 34.21749], [-118.60178, 34.21749], [-118.60174, 34.21744], [-118.60174, 34.21566], [-118.60179, 34.21562], [-118.60577, 34.21562], [-118.60581, 34.21566], [-118.60581, 34.21744]]]} | Open Access 1 | Lanark Recreation Center | http://www.laparks.org/dos/reccenter/facility/lanarkRC.htm | 28623 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 19.127 | Lanark Rec. Ctr. | |
7995 | 7995 | 7994 | {"type": "Polygon", "coordinates": [[[-118.59935, 34.22803], [-118.59933, 34.22806], [-118.59929, 34.22807], [-118.59851, 34.22806], [-118.59851, 34.2274], [-118.59935, 34.2274], [-118.59935, 34.22803]]]} | Open Access 1 | Parthenia Park | 23485 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.413 | Parthenia Park | ||
11993 | 11993 | 11992 | {"type": "Polygon", "coordinates": [[[-118.59735, 34.1673], [-118.59689, 34.16721], [-118.59699, 34.16688], [-118.59728, 34.16693], [-118.59732, 34.16696], [-118.59735, 34.1671], [-118.59735, 34.1673]]]} | Open Access 1 | Old Fire Station 84 Pocket Park | http://www.laparks.org/environmental/oldFire.htm | 28839 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.358 | Old Fire Station 84 PP | |
9520 | 9520 | 9519 | {"type": "Polygon", "coordinates": [[[-118.58835, 34.1574], [-118.58606, 34.1574], [-118.58649, 34.15597], [-118.58652, 34.15583], [-118.58671, 34.15424], [-118.58675, 34.15418], [-118.58671, 34.15411], [-118.58664, 34.15409], [-118.58656, 34.15414], [-118.58655, 34.15417], [-118.58658, 34.15424], [-118.58638, 34.15587], [-118.58593, 34.1574], [-118.58588, 34.15747], [-118.58579, 34.15753], [-118.58572, 34.15755], [-118.58551, 34.15757], [-118.58506, 34.1552], [-118.58531, 34.15463], [-118.58518, 34.15359], [-118.58603, 34.1525], [-118.58688, 34.15235], [-118.58834, 34.15325], [-118.58835, 34.1574]]]} | Open Access 1 | Serrania Avenue Park | 25316 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 35.478 | Serrania Avenue Park |
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]);