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_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22 | 22 | 21 | {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20167, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.20119, 34.07523], [-118.20091, 34.07524], [-118.20089, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20178, 34.07497], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} | Restricted Access 2 | Abraham Lincoln High School Park | 31843 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.473 | Abraham Lincoln High School Park | ||
307 | 307 | 306 | {"type": "Polygon", "coordinates": [[[-118.2635, 34.06257], [-118.26306, 34.06324], [-118.26301, 34.06325], [-118.26135, 34.0625], [-118.2617, 34.06184], [-118.2635, 34.06257]]]} | Restricted Access 2 | Belmont High School Park | 31940 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.75 | Belmont High School Park | ||
308 | 308 | 307 | {"type": "Polygon", "coordinates": [[[-118.50705, 34.19144], [-118.50564, 34.19144], [-118.5056, 34.19012], [-118.50703, 34.19012], [-118.50705, 34.19144]]]} | Restricted Access 2 | Birmingham High School Park | 31941 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.739 | Birmingham High School Park | ||
367 | 367 | 366 | {"type": "Polygon", "coordinates": [[[-118.53768, 34.04164], [-118.5375, 34.04184], [-118.53746, 34.04185], [-118.53734, 34.04177], [-118.53733, 34.04174], [-118.53752, 34.04153], [-118.53768, 34.04164]]]} | Open Access 1 | Almar Plaza | 15394 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.144 | Almar Plaza | ||
554 | 554 | 553 | {"type": "Polygon", "coordinates": [[[-118.33238, 34.00416], [-118.3308, 34.00412], [-118.3308, 34.00412], [-118.33091, 34.00377], [-118.33196, 34.00376], [-118.33238, 34.00416]]]} | Open Access 1 | Leimert Park | 21145 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.261 | Leimert Park | ||
702 | 702 | 701 | {"type": "Polygon", "coordinates": [[[-118.30502, 34.08785], [-118.30481, 34.08785], [-118.30454, 34.08756], [-118.30453, 34.08743], [-118.30421, 34.0871], [-118.30393, 34.08695], [-118.30365, 34.0867], [-118.30352, 34.08656], [-118.30334, 34.08644], [-118.30334, 34.08634], [-118.30501, 34.08633], [-118.30502, 34.08785]]]} | Open Access 1 | Lemon Grove Recreation Center | 21152 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.523 | Lemon Grove Rec. Ctr. | ||
706 | 706 | 705 | {"type": "Polygon", "coordinates": [[[-118.53593, 34.2532], [-118.53593, 34.25409], [-118.53392, 34.2541], [-118.53391, 34.25537], [-118.53113, 34.25537], [-118.53086, 34.25535], [-118.53057, 34.25529], [-118.53059, 34.25521], [-118.53164, 34.25372], [-118.53391, 34.25187], [-118.53392, 34.25273], [-118.53593, 34.25274], [-118.53593, 34.2532]]]} | Open Access 1 | Northridge Recreation Center | 22889 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 24.057 | Northridge Rec. Ctr. | ||
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. | ||
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-118.29057, 34.06819], [-118.28977, 34.0682], [-118.28975, 34.06824], [-118.28918, 34.06824], [-118.28917, 34.0681], [-118.28859, 34.06811], [-118.28858, 34.06771], [-118.2885, 34.06769], [-118.28849, 34.06692], [-118.28898, 34.06714], [-118.28914, 34.06719], [-118.28931, 34.06722], [-118.28957, 34.06721], [-118.29026, 34.06706], [-118.29044, 34.06706], [-118.29056, 34.06708], [-118.29057, 34.06819]]]} | Open Access 1 | Shatto Recreation Center | 25373 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.463 | Shatto Rec. Ctr. | ||
712 | 712 | 711 | {"type": "Polygon", "coordinates": [[[-118.3746, 34.21924], [-118.37049, 34.21923], [-118.37046, 34.21918], [-118.37045, 34.21764], [-118.37049, 34.21764], [-118.37052, 34.2176], [-118.37057, 34.21759], [-118.3746, 34.21759], [-118.3746, 34.21924]]]} | Open Access 1 | Sun Valley Park & Recreation Center | 25981 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 17.226 | Sun Valley Park & Rec. Ctr. | ||
713 | 713 | 712 | {"type": "Polygon", "coordinates": [[[-118.31914, 33.98922], [-118.31914, 33.99022], [-118.31862, 33.9902], [-118.31861, 33.99043], [-118.31792, 33.99045], [-118.31788, 33.991], [-118.31761, 33.991], [-118.31761, 33.9903], [-118.31728, 33.99029], [-118.31736, 33.99], [-118.31754, 33.9896], [-118.31757, 33.98958], [-118.31756, 33.98956], [-118.31762, 33.98945], [-118.31762, 33.98921], [-118.31911, 33.9892], [-118.31914, 33.98922]]]} | Open Access 1 | Van Ness Recreation Center | 26828 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.294 | Van Ness Rec. Ctr. | ||
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. | ||
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. | ||
716 | 716 | 715 | {"type": "Polygon", "coordinates": [[[-118.28341, 34.08393], [-118.283, 34.08459], [-118.28255, 34.08442], [-118.28134, 34.08636], [-118.28032, 34.08591], [-118.28183, 34.08349], [-118.28339, 34.0839], [-118.28341, 34.08393]]]} | Open Access 1 | Bellevue Recreation Center | 28615 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.133 | Bellevue Rec. Ctr. | ||
758 | 758 | 757 | {"type": "Polygon", "coordinates": [[[-118.19168, 34.07683], [-118.18719, 34.07679], [-118.18716, 34.07318], [-118.18429, 34.07319], [-118.18475, 34.07243], [-118.18551, 34.07261], [-118.18608, 34.07165], [-118.18639, 34.07172], [-118.18681, 34.07056], [-118.18859, 34.06993], [-118.18873, 34.06991], [-118.18923, 34.06988], [-118.18938, 34.06984], [-118.18951, 34.06978], [-118.18983, 34.06958], [-118.19164, 34.06958], [-118.19168, 34.07683]]]} | Open Access 1 | Ascot Hills Park | 15645 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 88.28 | Ascot Hills Park | ||
870 | 870 | 869 | {"type": "Polygon", "coordinates": [[[-118.4065, 34.23117], [-118.4061, 34.23146], [-118.40628, 34.23165], [-118.40483, 34.23133], [-118.40587, 34.23057], [-118.4065, 34.23117]]]} | Open Access 1 | Sheldon Skate Park | 32744 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.191 | Sheldon Skate Park | ||
902 | 902 | 901 | {"type": "Polygon", "coordinates": [[[-118.2356, 34.04165], [-118.23514, 34.0417], [-118.23507, 34.04127], [-118.23553, 34.04121], [-118.2356, 34.04165]]]} | Open Access 1 | Arts District Park | 32785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.514 | Arts District Park | 2016 | |
1094 | 1094 | 1093 | {"type": "Polygon", "coordinates": [[[-118.28686, 33.95825], [-118.28478, 33.95826], [-118.28477, 33.95515], [-118.28686, 33.95513], [-118.28685, 33.95598], [-118.28686, 33.95825]]]} | Open Access 1 | Algin Sutton Recreation Center | 15356 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 16.442 | Algin Sutton Rec. Ctr. | ||
1148 | 1148 | 1147 | {"type": "Polygon", "coordinates": [[[-118.541, 34.2968], [-118.53999, 34.29722], [-118.53874, 34.29483], [-118.53724, 34.29395], [-118.53571, 34.29246], [-118.53461, 34.29157], [-118.53328, 34.29016], [-118.53158, 34.28785], [-118.52831, 34.285], [-118.52778, 34.28256], [-118.52757, 34.2807], [-118.52696, 34.27905], [-118.52695, 34.27888], [-118.52724, 34.27881], [-118.52806, 34.27867], [-118.52953, 34.28314], [-118.53017, 34.28407], [-118.53092, 34.2845], [-118.53097, 34.2851], [-118.53147, 34.28538], [-118.53159, 34.28554], [-118.53148, 34.28561], [-118.53138, 34.28569], [-118.53124, 34.28586], [-118.53117, 34.28606], [-118.53116, 34.28619], [-118.53117, 34.28629], [-118.53123, 34.28647], [-118.53134, 34.28663], [-118.53245, 34.28776], [-118.53213, 34.28797], [-118.53213, 34.28799], [-118.5332, 34.28916], [-118.53392, 34.28967], [-118.53406, 34.28995], [-118.53415, 34.29019], [-118.53443, 34.29042], [-118.53519, 34.29078], [-118.53536, 34.29076], [-118.53539, 34.29082], [-118.53591, 34.2907], [-118.53596, 34.29081], [-118.53604, 34.29091], [-118.53654, 34.29145], [-118.53596, 34.29182], [-118.53596, 34.29184], [-118.5366, 34.29242], [-118.53904, 34.29448], [-118.54, 34.29518], [-118.54059, 34.29647], [-118.541, 34.2968]]]} | Open Access 1 | Aliso Canyon Park | 15370 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 60.476 | Aliso Canyon Park | ||
1173 | 1173 | 1172 | {"type": "Polygon", "coordinates": [[[-118.28562, 33.73651], [-118.28561, 33.73685], [-118.28455, 33.73685], [-118.28456, 33.73651], [-118.28492, 33.73649], [-118.28492, 33.73611], [-118.28561, 33.73611], [-118.2856, 33.73648], [-118.28562, 33.73651]]]} | Open Access 1 | Anderson Playground and Senior Citizen Center | 15480 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.618 | Anderson Playground and Senior Citizen Ctr. |
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]);