units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
4464 | 4464 | 4463 | {"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 | 46647 | Arts District Park | 32785 | 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.514 | Arts District Park | 2016 | Local Park 2 | 4 | |
14704 | 14704 | 14703 | {"type": "Polygon", "coordinates": [[[-118.30056, 34.0395], [-118.30046, 34.0395], [-118.30046, 34.03918], [-118.30049, 34.03915], [-118.30055, 34.03915], [-118.30056, 34.0395]]]} | Open Access 1 | 45059 | West Adams Heights Park | 32572 | 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 | https://www.laparks.org/park/west-adams-heights-park | Los Angeles 6 | 0.088 | West Adams Heights Park | 2014 | Local Park 2 | 4 |
14705 | 14705 | 14704 | {"type": "Polygon", "coordinates": [[[-118.34039, 34.03371], [-118.34038, 34.03384], [-118.34032, 34.03407], [-118.34007, 34.03394], [-118.34039, 34.03352], [-118.34039, 34.03371]]]} | Open Access 1 | 45060 | Gladys Jean Wesson Park | 32559 | 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 | https://www.laparks.org/park/gladys-jean-wesson-park-aka-west-boulevard | Los Angeles 6 | 0.209 | Gladys Jean Wesson Park | 2014 | Local Park 2 | 4 |
15069 | 15069 | 15068 | {"type": "Polygon", "coordinates": [[[-118.26494, 34.06366], [-118.26472, 34.06401], [-118.26443, 34.06388], [-118.26465, 34.06353], [-118.26494, 34.06366]]]} | Open Access 1 | 45834 | Unidad Park | 28853 | 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.324 | Unidad Park | 2007 | Local Park 2 | 4 | |
7138 | 7138 | 7137 | {"type": "Polygon", "coordinates": [[[-118.24127, 33.93867], [-118.24126, 33.93886], [-118.24082, 33.93867], [-118.24091, 33.93867], [-118.24127, 33.93867]]]} | Open Access 1 | 6221 | Watts Towers of Simon Rodia State Historic Park | 30713 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.109 | Watts Towers of Simon Rodia SHP | 1978 | None 584 | ||
15729 | 15729 | 15728 | {"type": "MultiPolygon", "coordinates": [[[[-118.27411, 34.26728], [-118.26543, 34.26717], [-118.26542, 34.26731], [-118.26105, 34.26727], [-118.26104, 34.26578], [-118.26156, 34.26573], [-118.26177, 34.26567], [-118.26196, 34.26554], [-118.2622, 34.2653], [-118.26227, 34.26527], [-118.26261, 34.26521], [-118.26278, 34.26515], [-118.26387, 34.26451], [-118.26404, 34.26444], [-118.26423, 34.26439], [-118.2644, 34.26437], [-118.26471, 34.2644], [-118.26538, 34.2646], [-118.26538, 34.2647], [-118.26551, 34.26471], [-118.26566, 34.26467], [-118.26574, 34.26461], [-118.26586, 34.26443], [-118.26591, 34.26438], [-118.26596, 34.26436], [-118.26623, 34.26429], [-118.26631, 34.26426], [-118.26636, 34.2642], [-118.26638, 34.26412], [-118.26636, 34.26405], [-118.26629, 34.26399], [-118.26621, 34.26397], [-118.26614, 34.26397], [-118.26606, 34.264], [-118.26559, 34.26438], [-118.2655, 34.26439], [-118.26538, 34.26435], [-118.26538, 34.26446], [-118.26545, 34.26449], [-118.26558, 34.2645], [-118.26569, 34.26445], [-118.26564, 34.26453], [-118.26559, 34.26458], [-118.2655, 34.26461], [-118.26538, 34.26459], [-118.26537, 34.26449], [-118.26481, 34.26431], [-118.26462, 34.26427], [-118.26437, 34.26427], [-118.26407, 34.26431], [-118.26391, 34.26437], [-118.26378, 34.26443], [-118.26272, 34.26505], [-118.26254, 34.26511], [-118.26225, 34.26516], [-118.26214, 34.2652], [-118.26202, 34.26529], [-118.26191, 34.26544], [-118.26174, 34.26555], [-118.26154, 34.26562], [-118.26104, 34.26567], [-118.26102, 34.26357], [-118.26535, 34.26361], [-118.26536, 34.26349], [-118.26863, 34.26353], [-118.26871, 34.26544], [-118.26884, 34.26545], [-118.26974, 34.26546], [-118.26974, 34.2647], [-118.26968, 34.26353], [-118.26968, 34.25986], [-118.27407, 34.25988], [-118.27411, 34.26728]], [[-118.26537, 34.26484], [-118.26538, 34.26483], [-118.26538, 34.26473], [-118.2649, 34.26465], [-118.26474, 34.26465], [-118.26458, 34.26468], [-118.26432, 34.26478], [-118.26301, 34.26581], [-118.26292, 34.2659], [-118.26283, 34.26603], [-118.26272, 34.26632], [-118.26268, 34.26639], [-118.26245, 34.26664], [-118.26241, 34.2667], [-118.2624, 34.26678], [-118.26244, 34.26687], [-118.26252, 34.26694], [-118.2626, 34.26697], [-118.26263, 34.26687], [-118.26259, 34.26685], [-118.26255, 34.2668], [-118.26254, 34.26672], [-118.26278, 34.26647], [-118.26288, 34.26627], [-118.26295, 34.26608], [-118.26306, 34.26592], [-118.26435, 34.2649], [-118.26443, 34.26485], [-118.2646, 34.26479], [-118.26479, 34.26476], [-118.26496, 34.26476], [-118.26537, 34.26484]]], [[[-118.26624, 34.26416], [-118.26621, 34.26418], [-118.26594, 34.26425], [-118.26617, 34.26408], [-118.2662, 34.26408], [-118.26624, 34.2641], [-118.26624, 34.26416]]], [[[-118.2728, 34.25874], [-118.2726, 34.25889], [-118.2726, 34.25789], [-118.2728, 34.25775], [-118.2728, 34.25874]]]]} | Open Access 1 | 7119 | Angeles National Forest | 15492 | 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://lacity.org/ | Los Angeles 6 | 155.09 | Angeles NF | 1908 | National Forest 11 | 3 |
44 | 44 | 43 | {"type": "Polygon", "coordinates": [[[-118.35044, 34.13077], [-118.35003, 34.13136], [-118.34933, 34.1306], [-118.3496, 34.13019], [-118.35044, 34.13077]]]} | Open Access 1 | 99 | El Paseo Cahuenga Park | 18526 | 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 | 1.546 | El Paseo Cahuenga Park | 0 | Local Park 2 | 4 | |
66 | 66 | 65 | {"type": "Polygon", "coordinates": [[[-118.24767, 33.99122], [-118.24568, 33.99122], [-118.24567, 33.98955], [-118.24762, 33.98955], [-118.24767, 33.99122]]]} | Open Access 1 | 190 | Augustus Hawkins Natural Park | 15707 | 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 | 8.369 | Augustus Hawkins Natural Park | 0 | Local Park 2 | 4 | |
95 | 95 | 94 | {"type": "Polygon", "coordinates": [[[-118.50316, 34.16163], [-118.50227, 34.16163], [-118.50228, 34.15971], [-118.50316, 34.15991], [-118.50316, 34.16163]]]} | Open Access 1 | 302 | Encino Park | 18668 | 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 | 4.067 | Encino Park | 0 | Local Park 2 | 4 | |
127 | 127 | 126 | {"type": "MultiPolygon", "coordinates": [[[[-118.41914, 34.18293], [-118.4191, 34.18296], [-118.41829, 34.18296], [-118.41826, 34.18294], [-118.41825, 34.1818], [-118.41911, 34.18181], [-118.41914, 34.18184], [-118.41914, 34.18293]]], [[[-118.42023, 34.18293], [-118.42019, 34.18296], [-118.41938, 34.18296], [-118.41935, 34.18294], [-118.41934, 34.18184], [-118.42023, 34.18184], [-118.42023, 34.18293]]]]} | Open Access 1 | 335 | Valley Glen Community Park | 26789 | 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 | 5.115 | Valley Glen Community Park | 0 | Local Park 2 | 4 | |
156 | 156 | 155 | {"type": "Polygon", "coordinates": [[[-118.27409, 34.2411], [-118.27374, 34.24114], [-118.2736, 34.24083], [-118.27329, 34.24038], [-118.2733, 34.24033], [-118.27334, 34.24031], [-118.27398, 34.2402], [-118.27404, 34.24086], [-118.27409, 34.2411]]]} | Open Access 1 | 494 | Fehlhaber-Houk Park | 28620 | 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/dos/parks/facility/fehlhaberHoukPk.htm | Los Angeles 6 | 1.175 | Fehlhaber-Houk Park | 0 | Local Park 2 | 4 |
159 | 159 | 158 | {"type": "Polygon", "coordinates": [[[-118.24886, 34.06967], [-118.24887, 34.07033], [-118.24883, 34.07039], [-118.24876, 34.07043], [-118.24868, 34.07045], [-118.2486, 34.07043], [-118.24854, 34.0704], [-118.2485, 34.07035], [-118.24848, 34.07029], [-118.24848, 34.07024], [-118.24877, 34.06965], [-118.24882, 34.06963], [-118.24886, 34.06967]]]} | Open Access 1 | 405 | Everett Park | 18763 | 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.521 | Everett Park | 0 | Local Park 2 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 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 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
319 | 319 | 318 | {"type": "Polygon", "coordinates": [[[-118.18189, 34.12005], [-118.18189, 34.12005], [-118.17889, 34.12008], [-118.1804, 34.11888], [-118.18088, 34.11808], [-118.18153, 34.11815], [-118.18189, 34.12005]]]} | Open Access 1 | 855 | Garvanza Park | 19226 | 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 | 8.274 | Garvanza Park | 0 | Local Park 2 | 4 | |
331 | 331 | 330 | {"type": "Polygon", "coordinates": [[[-118.36901, 34.03598], [-118.36855, 34.03714], [-118.36689, 34.03694], [-118.36745, 34.03546], [-118.36901, 34.03598]]]} | Open Access 1 | 908 | Genesee Avenue Park | 19255 | 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 | 5.852 | Genesee Avenue Park | 0 | Local Park 2 | 4 | |
449 | 449 | 448 | {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} | Open Access 1 | 1807 | Highland Park | 19932 | 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.045 | Highland Park | 0 | Local Park 2 | 4 | |
493 | 493 | 492 | {"type": "Polygon", "coordinates": [[[-118.40813, 34.28144], [-118.40657, 34.28258], [-118.40505, 34.28116], [-118.40662, 34.28002], [-118.40813, 34.28144]]]} | Open Access 1 | 1998 | Hubert H. Humphrey Memorial Park | 20130 | 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 | 9.987 | Hubert H. Humphrey Memorial Park | 0 | Local Park 2 | 4 | |
511 | 511 | 510 | {"type": "Polygon", "coordinates": [[[-118.19601, 34.05796], [-118.19489, 34.05976], [-118.19436, 34.05954], [-118.19513, 34.0583], [-118.1952, 34.05834], [-118.19523, 34.05833], [-118.19532, 34.05836], [-118.19542, 34.05832], [-118.19563, 34.05796], [-118.19573, 34.058], [-118.19601, 34.05796]]]} | Open Access 1 | 1704 | Henry Alvarez Memorial Park | 19822 | 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.566 | Henry Alvarez Memorial Park | 0 | Local Park 2 | 4 | |
514 | 514 | 513 | {"type": "Polygon", "coordinates": [[[-118.29549, 34.09994], [-118.29552, 34.10008], [-118.29552, 34.10036], [-118.2955, 34.10049], [-118.29546, 34.10058], [-118.29538, 34.10069], [-118.29515, 34.10094], [-118.29543, 34.10117], [-118.29519, 34.10127], [-118.2953, 34.10134], [-118.2953, 34.10166], [-118.29326, 34.10167], [-118.29326, 34.10131], [-118.29305, 34.10119], [-118.29296, 34.10103], [-118.29294, 34.10094], [-118.29294, 34.10085], [-118.29299, 34.10075], [-118.29298, 34.09918], [-118.29357, 34.0992], [-118.29358, 34.09919], [-118.29391, 34.09915], [-118.29454, 34.09916], [-118.29462, 34.0992], [-118.29469, 34.09919], [-118.29473, 34.09923], [-118.29489, 34.09928], [-118.29489, 34.09935], [-118.29492, 34.09941], [-118.29518, 34.0996], [-118.29539, 34.09978], [-118.29549, 34.09994]]]} | Open Access 1 | 1713 | Barnsdall Park | 15825 | 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 | 14.293 | Barnsdall 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]);