superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
465 rows where MNG_AGENCY = 24 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
ACCESS_TYP 4
- Open Access 414
- Restricted Access 17
- No Public Access 11
- Unknown Access 3
MNG_AG_TYP 1
- City Agency · 445 ✖
MNG_AGENCY 1
- Los Angeles, City of · 445 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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. | ||
717 | 717 | 716 | {"type": "Polygon", "coordinates": [[[-118.45482, 34.21511], [-118.45417, 34.21512], [-118.45417, 34.21468], [-118.45441, 34.21468], [-118.45443, 34.2147], [-118.45482, 34.2147], [-118.45482, 34.21511]]]} | Open Access 1 | Andres and Maria Cardenas Recreation Center | http://www.laparks.org/dos/reccenter/facility/andresMariaRC.htm | 28617 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.696 | Andres and Maria Cardenas 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 | ||
1228 | 1228 | 1227 | {"type": "MultiPolygon", "coordinates": [[[[-118.19929, 34.10238], [-118.19783, 34.10295], [-118.19718, 34.10338], [-118.19708, 34.10349], [-118.1968, 34.10323], [-118.1968, 34.10319], [-118.19683, 34.10317], [-118.19725, 34.10308], [-118.19773, 34.10284], [-118.19913, 34.10228], [-118.19929, 34.10238]]], [[[-118.20099, 34.10144], [-118.20083, 34.10157], [-118.20051, 34.1018], [-118.20024, 34.10197], [-118.19973, 34.10221], [-118.1995, 34.1023], [-118.19933, 34.10221], [-118.19972, 34.10205], [-118.20017, 34.10182], [-118.20044, 34.10165], [-118.20063, 34.1015], [-118.20083, 34.10133], [-118.20099, 34.10144]]], [[[-118.20765, 34.08934], [-118.20748, 34.08952], [-118.20728, 34.08979], [-118.20629, 34.09132], [-118.20612, 34.09172], [-118.20607, 34.09195], [-118.20605, 34.09214], [-118.20607, 34.09249], [-118.20534, 34.09253], [-118.20532, 34.09251], [-118.20532, 34.09247], [-118.2071, 34.08969], [-118.20739, 34.08932], [-118.20765, 34.08934]]], [[[-118.20615, 34.0931], [-118.20549, 34.09272], [-118.20539, 34.09265], [-118.20539, 34.09264], [-118.20543, 34.09261], [-118.20601, 34.09258], [-118.20607, 34.09259], [-118.20609, 34.09261], [-118.20615, 34.0931]]]]} | Open Access 1 | Arroyo Seco | http://lacity.org/ | 15627 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.897 | Arroyo Seco | |
1286 | 1286 | 1285 | {"type": "Polygon", "coordinates": [[[-118.46153, 33.97503], [-118.46151, 33.97515], [-118.46145, 33.97532], [-118.4613, 33.97553], [-118.46123, 33.97559], [-118.46107, 33.97571], [-118.46039, 33.97608], [-118.45986, 33.97557], [-118.46056, 33.97514], [-118.46066, 33.97505], [-118.46076, 33.9749], [-118.4608, 33.97475], [-118.46078, 33.97459], [-118.46074, 33.97448], [-118.45889, 33.97201], [-118.45771, 33.97025], [-118.45652, 33.969], [-118.45648, 33.969], [-118.45458, 33.96645], [-118.45481, 33.96634], [-118.45481, 33.96632], [-118.45505, 33.9662], [-118.45681, 33.96885], [-118.45712, 33.96873], [-118.45717, 33.96881], [-118.45703, 33.96889], [-118.45708, 33.96897], [-118.45727, 33.96889], [-118.45758, 33.96936], [-118.45745, 33.96943], [-118.4575, 33.96951], [-118.45759, 33.96948], [-118.45794, 33.96993], [-118.45787, 33.96997], [-118.45787, 33.96999], [-118.45794, 33.97006], [-118.45801, 33.97002], [-118.45837, 33.97047], [-118.45829, 33.97051], [-118.45829, 33.97053], [-118.45836, 33.9706], [-118.45843, 33.97057], [-118.45879, 33.97101], [-118.45871, 33.97106], [-118.45871, 33.97107], [-118.45878, 33.97114], [-118.45885, 33.97111], [-118.45921, 33.97156], [-118.45913, 33.97159], [-118.45913, 33.97161], [-118.4592, 33.97169], [-118.45928, 33.97165], [-118.45963, 33.9721], [-118.45955, 33.97214], [-118.45955, 33.97216], [-118.45962, 33.97223], [-118.4597, 33.9722], [-118.46005, 33.97264], [-118.45997, 33.97268], [-118.45997, 33.9727], [-118.46004, 33.97277], [-118.46013, 33.97273], [-118.46047, 33.97319], [-118.4604, 33.97323], [-118.46045, 33.97331], [-118.46055, 33.97328], [-118.46093, 33.97378], [-118.46086, 33.97382], [-118.46086, 33.97384], [-118.46092, 33.97391], [-118.461, 33.97387], [-118.46135, 33.97431], [-118.46129, 33.97438], [-118.4614, 33.97453], [-118.46148, 33.97468], [-118.46153, 33.97487], [-118.46153, 33.97503]]]} | Open Access 1 | Ballona Lagoon Marine Preserve | http://lacity.org/ | 15788 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 16.02 | Ballona Lagoon Marine Preserve | |
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 | ||
1289 | 1289 | 1288 | {"type": "MultiPolygon", "coordinates": [[[[-118.29824, 33.7247], [-118.29785, 33.72471], [-118.29784, 33.7251], [-118.29692, 33.7251], [-118.29692, 33.72485], [-118.2973, 33.72485], [-118.29731, 33.72476], [-118.29758, 33.72475], [-118.29758, 33.72436], [-118.29823, 33.72436], [-118.29824, 33.7247]]], [[[-118.29797, 33.72561], [-118.29726, 33.72561], [-118.29724, 33.72563], [-118.29692, 33.72564], [-118.29692, 33.72527], [-118.29797, 33.72527], [-118.29797, 33.72561]]]]} | Open Access 1 | Alma Park | 15387 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.262 | Alma Park | ||
1360 | 1360 | 1359 | {"type": "Polygon", "coordinates": [[[-118.28458, 33.72533], [-118.2844, 33.72593], [-118.28373, 33.7268], [-118.28244, 33.72785], [-118.28077, 33.72872], [-118.28047, 33.72883], [-118.28046, 33.72831], [-118.28107, 33.72799], [-118.28046, 33.72628], [-118.28046, 33.72509], [-118.28209, 33.72464], [-118.28381, 33.72421], [-118.28389, 33.72418], [-118.28392, 33.72412], [-118.28389, 33.72397], [-118.28434, 33.72394], [-118.28451, 33.72426], [-118.28467, 33.72499], [-118.28458, 33.72533]]]} | Open Access 1 | 22nd Street Landing | 15183 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 30.564 | 22nd Street Landing | ||
1388 | 1388 | 1387 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 109th Street Recreation Center | 15168 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.183 | 109th Street Rec. Ctr. | ||
1419 | 1419 | 1418 | {"type": "Polygon", "coordinates": [[[-118.53705, 34.04425], [-118.53705, 34.04425], [-118.53673, 34.04434], [-118.53687, 34.04401], [-118.53705, 34.04425]]]} | Open Access 1 | Aiglon Plaza | 15299 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.12 | Aiglon Plaza |
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]);