units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP >30
- Local Park 314
- Local Recreation Area 116
- Local Other or Unknown 26
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
AGNCY_NAME 6 ✖
ACCESS_TYP 4
- Open Access 432
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
MNG_AG_TYP 1
- City Agency · 491 ✖
MNG_AGENCY 1
- Los Angeles, City of · 491 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME ▼ | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4660 | 4660 | 4659 | {"type": "Polygon", "coordinates": [[[-118.445, 34.26558], [-118.44458, 34.26545], [-118.44422, 34.26529], [-118.4438, 34.26504], [-118.44347, 34.26478], [-118.44336, 34.26486], [-118.44333, 34.26484], [-118.44307, 34.26456], [-118.44309, 34.26422], [-118.44317, 34.26385], [-118.445, 34.26558]]]} | Open Access 1 | 36591 | Unnamed site - Los Angeles, City of | 28718 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.286 | 0 | Local Other or Unknown 14 | 4 | ||
4718 | 4718 | 4717 | {"type": "Polygon", "coordinates": [[[-118.28418, 34.23377], [-118.28386, 34.23376], [-118.28045, 34.23393], [-118.27981, 34.23393], [-118.27976, 34.22908], [-118.27539, 34.22911], [-118.27538, 34.22816], [-118.28411, 34.2281], [-118.28418, 34.23377]]]} | Unknown Access 4 | 46522 | Unnamed site - Los Angeles, City of | 29809 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 73.646 | 0 | Local Other or Unknown 14 | 4 | ||
4782 | 4782 | 4781 | {"type": "MultiPolygon", "coordinates": [[[[-118.31523, 34.27262], [-118.31155, 34.27525], [-118.31209, 34.27614], [-118.31019, 34.27715], [-118.31018, 34.27759], [-118.30864, 34.278], [-118.30827, 34.27922], [-118.30683, 34.28], [-118.30504, 34.28028], [-118.30418, 34.27659], [-118.3067, 34.27613], [-118.30776, 34.27606], [-118.30797, 34.27532], [-118.30739, 34.27455], [-118.3079, 34.27436], [-118.30845, 34.27422], [-118.30878, 34.27411], [-118.30893, 34.27404], [-118.30921, 34.27384], [-118.30958, 34.27409], [-118.31025, 34.27505], [-118.31221, 34.27344], [-118.31465, 34.27267], [-118.31408, 34.27288], [-118.31389, 34.27298], [-118.31396, 34.27307], [-118.31454, 34.27284], [-118.31523, 34.27262]], [[-118.30988, 34.27535], [-118.30988, 34.27534], [-118.30953, 34.27504], [-118.30924, 34.27461], [-118.30928, 34.27454], [-118.30927, 34.27453], [-118.30885, 34.27447], [-118.3087, 34.27429], [-118.30803, 34.27437], [-118.30782, 34.27443], [-118.30784, 34.27447], [-118.30799, 34.27441], [-118.3086, 34.27434], [-118.30861, 34.27438], [-118.30817, 34.27444], [-118.30816, 34.27446], [-118.30908, 34.27567], [-118.30988, 34.27535]]], [[[-118.31018, 34.27763], [-118.31014, 34.27952], [-118.30543, 34.28199], [-118.30505, 34.28031], [-118.30684, 34.28003], [-118.30831, 34.27923], [-118.30868, 34.27803], [-118.31018, 34.27763]]], [[[-118.31695, 34.27216], [-118.31632, 34.27264], [-118.31581, 34.27301], [-118.3158, 34.27253], [-118.31583, 34.27253], [-118.31587, 34.27248], [-118.31656, 34.27226], [-118.31695, 34.27216]]]]} | Restricted Access 2 | 47252 | Unnamed site - Los Angeles, City of | 30961 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 88.776 | 0 | Local Other or Unknown 14 | 4 | ||
4358 | 4358 | 4357 | {"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 | 45731 | 105th Street Pocket Park | 28734 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/environmental/105th.htm | Los Angeles 6 | 0.111 | 105th Street PP | 0 | Local Park 2 | 4 |
999 | 999 | 998 | {"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 | 6218 | 109th Street Recreation Center | 15168 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.184 | 109th Street Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
4223 | 4223 | 4222 | {"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 | 45017 | 111th Place Neighborhood Park | 27920 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/environmental/pdf/111thPark.pdf | Los Angeles 6 | 0.09 | 111th Place Neighborhood Park | 0 | Local Park 2 | 4 |
4363 | 4363 | 4362 | {"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 | 45774 | 11th Avenue Park | 28781 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.lanlt.org/parks-and-gardens.php#11th | Los Angeles 6 | 0.207 | 11th Avenue Park | 0 | Local Park 2 | 4 |
7015 | 7015 | 7014 | {"type": "Polygon", "coordinates": [[[-118.28389, 33.72397], [-118.28434, 33.72394], [-118.28451, 33.72426], [-118.28467, 33.72499], [-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.728], [-118.28046, 33.72628], [-118.28046, 33.72509], [-118.28209, 33.72464], [-118.28381, 33.72421], [-118.28389, 33.72419], [-118.28392, 33.72412], [-118.28389, 33.72397]]]} | Open Access 1 | 5957 | 22nd Street Landing | 15183 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 30.559 | 22nd Street Landing | 0 | None 574 | ||
5715 | 5715 | 5714 | {"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 | 45781 | 49th Street Pocket Park | 28800 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/environmental/49thStPark.htm | Los Angeles 6 | 0.189 | 49th Street PP | 0 | Local Park 2 | 4 |
5390 | 5390 | 5389 | {"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 | 45782 | 61st Street Pocket Park | 28801 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.118 | 61st Street PP | 0 | Local Park 2 | 4 | |
3875 | 3875 | 3874 | {"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 | 45783 | 76th Street Pocket Park | 28802 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.lanlt.org/parks-and-gardens.php#76th | Los Angeles 6 | 0.128 | 76th Street PP | 0 | Local Park 2 | 4 |
14867 | 14867 | 14866 | {"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 | 45784 | 97th Street Pocket Park | 28803 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.128 | 97th Street PP | 0 | Local Park 2 | 4 | |
12253 | 12253 | 12252 | {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20166, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.2012, 34.07523], [-118.20091, 34.07524], [-118.2009, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20177, 34.07498], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} | Restricted Access 2 | 46874 | Abraham Lincoln High School Park | 31843 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.467 | Abraham Lincoln High School Park | 0 | Local Park 2 | 4 | |
7192 | 7192 | 7191 | {"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 | 6344 | Aiglon Plaza | 15299 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.12 | Aiglon Plaza | 0 | Local Park 2 | 4 | |
14738 | 14738 | 14737 | {"type": "Polygon", "coordinates": [[[-118.22397, 34.07081], [-118.22363, 34.07096], [-118.22277, 34.06957], [-118.2227, 34.0696], [-118.22244, 34.06918], [-118.22382, 34.06776], [-118.22387, 34.06883], [-118.22386, 34.06909], [-118.22382, 34.06911], [-118.22384, 34.06948], [-118.22382, 34.0699], [-118.22386, 34.06991], [-118.2239, 34.07036], [-118.22397, 34.07081]]]} | Open Access 1 | 45116 | Albion Riverside Park | 27965 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://albionriversidepark.com/ | Los Angeles 6 | 6.193 | Albion Riverside Park | 0 | Local Park 2 | 4 |
7130 | 7130 | 7129 | {"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 | 6214 | Algin Sutton Recreation Center | 15356 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 16.444 | Algin Sutton Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
9424 | 9424 | 9423 | {"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.28313], [-118.53017, 34.28407], [-118.53092, 34.2845], [-118.53096, 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.53212, 34.28799], [-118.5332, 34.28916], [-118.53392, 34.28967], [-118.53406, 34.28995], [-118.53415, 34.29019], [-118.53443, 34.29042], [-118.5352, 34.29078], [-118.53536, 34.29076], [-118.53538, 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.29183], [-118.5366, 34.29242], [-118.53904, 34.29448], [-118.54, 34.29518], [-118.54059, 34.29647], [-118.541, 34.2968]]]} | Open Access 1 | 15757 | Aliso Canyon Park | 15370 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 60.465 | Aliso Canyon Park | 0 | Local Park 2 | 4 | |
4360 | 4360 | 4359 | {"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 | 45741 | Aliso Triangle | 28745 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.043 | Aliso Triangle | 0 | Local Other or Unknown 14 | 4 | |
9684 | 9684 | 9683 | {"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.60495, 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.15052], [-118.60812, 34.15043], [-118.60875, 34.14995], [-118.6092, 34.15036]]]]} | Open Access 1 | 16332 | Alizondo Drive Park | 15374 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 6.62 | Alizondo Drive Park | 0 | Local Park 2 | 4 | |
924 | 924 | 923 | {"type": "MultiPolygon", "coordinates": [[[[-118.29797, 33.72561], [-118.29725, 33.72561], [-118.29724, 33.72563], [-118.29692, 33.72564], [-118.29692, 33.72527], [-118.29797, 33.72527], [-118.29797, 33.72561]]], [[[-118.29824, 33.7247], [-118.29784, 33.7247], [-118.29784, 33.7251], [-118.29692, 33.7251], [-118.29692, 33.72485], [-118.29731, 33.72485], [-118.29731, 33.72476], [-118.29758, 33.72475], [-118.29758, 33.72436], [-118.29823, 33.72436], [-118.29824, 33.7247]]]]} | Open Access 1 | 5892 | Alma Park | 15387 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.257 | Alma Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);