superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
431 rows where ACCESS_TYP = 1 and MNG_AGENCY = 24 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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. | ||
1188 | 1188 | 1187 | {"type": "Polygon", "coordinates": [[[-118.46665, 34.26852], [-118.46658, 34.26867], [-118.46651, 34.2688], [-118.46623, 34.26916], [-118.46517, 34.26895], [-118.46537, 34.26826], [-118.46665, 34.26852]]]} | Open Access 1 | Andreas Pico Adobe Park | 15483 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.193 | Andreas Pico Adobe Park | ||
1219 | 1219 | 1218 | {"type": "MultiPolygon", "coordinates": [[[[-118.60663, 34.15154], [-118.60662, 34.15157], [-118.60658, 34.15159], [-118.60632, 34.15157], [-118.60607, 34.15151], [-118.60577, 34.15141], [-118.60556, 34.1513], [-118.60538, 34.15118], [-118.60492, 34.15074], [-118.60496, 34.1505], [-118.60531, 34.14901], [-118.60561, 34.14906], [-118.60532, 34.15029], [-118.60582, 34.15077], [-118.60618, 34.15096], [-118.60635, 34.15131], [-118.60663, 34.15131], [-118.60663, 34.15154]]], [[[-118.6092, 34.15036], [-118.60818, 34.15113], [-118.60785, 34.15132], [-118.60756, 34.15144], [-118.60725, 34.15153], [-118.60685, 34.15158], [-118.6068, 34.15157], [-118.60678, 34.15155], [-118.60678, 34.15113], [-118.60751, 34.1512], [-118.60754, 34.15097], [-118.60816, 34.15053], [-118.60812, 34.15043], [-118.60875, 34.14995], [-118.6092, 34.15036]]]]} | Open Access 1 | Alizondo Drive Park | 15374 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 6.628 | Alizondo Drive Park | ||
1288 | 1288 | 1287 | {"type": "Polygon", "coordinates": [[[-118.26022, 33.79126], [-118.25632, 33.79146], [-118.25629, 33.79144], [-118.25614, 33.78933], [-118.25992, 33.78912], [-118.26015, 33.79039], [-118.26022, 33.79126]]]} | Open Access 1 | Banning Park and Museum | 15798 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 21.104 | Banning Park and Museum |
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]);