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 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11941 | 11941 | 11940 | {"type": "Polygon", "coordinates": [[[-118.2853, 33.94082], [-118.2853, 33.94114], [-118.28516, 33.94114], [-118.28516, 33.94082], [-118.2853, 33.94082]]]} | Open Access 1 | 105th Street Pocket Park | http://www.laparks.org/environmental/105th.htm | 28734 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.111 | 105th Street PP | |
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. | ||
9897 | 9897 | 9896 | {"type": "Polygon", "coordinates": [[[-118.2713, 33.93401], [-118.2713, 33.93437], [-118.2712, 33.93437], [-118.2712, 33.93401], [-118.2713, 33.93401]]]} | Open Access 1 | 111th Place Neighborhood Park | http://www.laparks.org/environmental/pdf/111thPark.pdf | 27920 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.09 | 111th Place Neighborhood Park | |
11955 | 11955 | 11954 | {"type": "Polygon", "coordinates": [[[-118.32926, 33.98393], [-118.32926, 33.98408], [-118.32896, 33.98418], [-118.32863, 33.98434], [-118.32863, 33.98418], [-118.3287, 33.98418], [-118.32926, 33.98393]]]} | Open Access 1 | 11th Avenue Park | http://www.lanlt.org/parks-and-gardens.php#11th | 28781 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.207 | 11th Avenue 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 | ||
11974 | 11974 | 11973 | {"type": "Polygon", "coordinates": [[[-118.2636, 33.99857], [-118.26343, 33.99857], [-118.26343, 33.99811], [-118.2636, 33.99811], [-118.2636, 33.99857]]]} | Open Access 1 | 49th Street Pocket Park | http://www.laparks.org/environmental/49thStPark.htm | 28800 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.189 | 49th Street PP | |
11975 | 11975 | 11974 | {"type": "Polygon", "coordinates": [[[-118.27253, 33.98433], [-118.27253, 33.98468], [-118.2724, 33.98468], [-118.2724, 33.98433], [-118.27253, 33.98433]]]} | Open Access 1 | 61st Street Pocket Park | 28801 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.117 | 61st Street PP | ||
11976 | 11976 | 11975 | {"type": "Polygon", "coordinates": [[[-118.28833, 33.97082], [-118.28833, 33.9712], [-118.2882, 33.9712], [-118.2882, 33.97082], [-118.28833, 33.97082]]]} | Open Access 1 | 76th Street Pocket Park | http://www.lanlt.org/parks-and-gardens.php#76th | 28802 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.128 | 76th Street PP | |
15637 | 15637 | 15636 | {"type": "Polygon", "coordinates": [[[-118.28476, 33.94818], [-118.28463, 33.94818], [-118.28463, 33.9478], [-118.28476, 33.9478], [-118.28476, 33.94818]]]} | Open Access 1 | 97th Street Pocket Park | 28803 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.128 | 97th Street PP | ||
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 | ||
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 | ||
11537 | 11537 | 11536 | {"type": "Polygon", "coordinates": [[[-118.22397, 34.07081], [-118.22363, 34.07096], [-118.22278, 34.06958], [-118.2227, 34.0696], [-118.22244, 34.06918], [-118.22382, 34.06776], [-118.22387, 34.06883], [-118.22386, 34.06909], [-118.22382, 34.06912], [-118.22384, 34.06948], [-118.22382, 34.06989], [-118.22386, 34.06991], [-118.2239, 34.07036], [-118.22397, 34.07081]]]} | Open Access 1 | Albion Riverside Park | http://albionriversidepark.com/ | 27965 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 6.193 | Albion Riverside Park | |
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 | ||
11942 | 11942 | 11941 | {"type": "Polygon", "coordinates": [[[-118.22281, 34.0523], [-118.22263, 34.05242], [-118.22258, 34.05226], [-118.22258, 34.05226], [-118.22281, 34.0523]]]} | Open Access 1 | Aliso Triangle | 28745 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.043 | Aliso Triangle | ||
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 | ||
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 | ||
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 | ||
13380 | 13380 | 13379 | {"type": "Polygon", "coordinates": [[[-118.2415, 34.06352], [-118.24093, 34.0646], [-118.24034, 34.06439], [-118.24089, 34.06331], [-118.2415, 34.06352]]]} | Open Access 1 | Alpine Park and Recreation Center | http://www.laparks.org/dos/reccenter/facility/alpineRC.htm | 30744 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.936 | Alpine Park and Rec. Ctr. | |
11929 | 11929 | 11928 | {"type": "Polygon", "coordinates": [[[-118.28175, 34.04485], [-118.28173, 34.04489], [-118.28136, 34.04495], [-118.28111, 34.04502], [-118.28081, 34.04516], [-118.28055, 34.04534], [-118.28048, 34.04531], [-118.281, 34.04451], [-118.28175, 34.04485]]]} | Open Access 1 | Alvarado Terrace Park | http://www.laparks.org/dos/parks/facility/alvaradoTerrPk.htm | 28724 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.926 | Alvarado Terrace 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]);