units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where MNG_AGENCY = 16 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
DES_TP 23
- Local Park 88
- Local Recreation Area 22
- Local Conservation Area 15
- Local Other or Unknown 9
- National Recreation Area 3
- National Forest 1
- Local Historic or Cultural 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
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 155
MNG_AGENCY 1
- Los Angeles, County of · 155 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15092 | 15092 | 15091 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | 45876 | Martin Luther King Jr. Fitness Garden | 28949 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Martin_Luther_King_Jr_Fitness_Park | Los Angeles 6 | 0.133 | Martin Luther King Jr. Fitness Garden | 0 | Local Park 2 | 4 |
15086 | 15086 | 15085 | {"type": "Polygon", "coordinates": [[[-118.59334, 34.29692], [-118.59288, 34.29636], [-118.59275, 34.29613], [-118.59187, 34.29638], [-118.5913, 34.29686], [-118.59115, 34.29672], [-118.5903, 34.29651], [-118.58963, 34.29617], [-118.59055, 34.2929], [-118.59249, 34.29293], [-118.59294, 34.2935], [-118.593, 34.29362], [-118.59302, 34.29375], [-118.59298, 34.29408], [-118.59299, 34.29418], [-118.5931, 34.29447], [-118.59311, 34.29458], [-118.5931, 34.29469], [-118.59291, 34.29525], [-118.59332, 34.29526], [-118.59334, 34.29692]]]} | Unknown Access 4 | 45869 | Browns Canyon | 28917 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 27.196 | Browns Canyon | None 1309 | |||
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | 45867 | Woods Avenue Park | 28914 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | Los Angeles 6 | 0.218 | Woods Avenue Park | 0 | Local Park 2 | 4 |
15084 | 15084 | 15083 | {"type": "Polygon", "coordinates": [[[-118.25293, 33.92759], [-118.25261, 33.92765], [-118.25157, 33.92387], [-118.2519, 33.92387], [-118.25293, 33.92759]]]} | Open Access 1 | 45866 | Compton Creek Walking Path Phase I | 28915 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.181 | Compton Creek Walking Path Phase I | None 1308 | |||
15083 | 15083 | 15082 | {"type": "Polygon", "coordinates": [[[-118.19408, 33.89119], [-118.19324, 33.89119], [-118.19323, 33.89102], [-118.19407, 33.89102], [-118.19408, 33.89119]]]} | Unknown Access 4 | 45865 | Washington Ave Park | 28912 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.359 | Washington Ave Park | 0 | Local Park 2 | 4 | |
4372 | 4372 | 4371 | {"type": "Polygon", "coordinates": [[[-118.22505, 33.96758], [-118.22454, 33.96753], [-118.22448, 33.9675], [-118.22431, 33.96734], [-118.22437, 33.96694], [-118.22436, 33.96693], [-118.22415, 33.96711], [-118.22327, 33.96702], [-118.22323, 33.96723], [-118.22254, 33.96715], [-118.22254, 33.96649], [-118.22474, 33.96672], [-118.22469, 33.96704], [-118.22505, 33.96708], [-118.22505, 33.96758]]]} | Restricted Access 2 | 45864 | Walnut Nature Park | 28911 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.587 | Walnut Nature Park | 0 | Local Park 2 | 4 | |
15082 | 15082 | 15081 | {"type": "Polygon", "coordinates": [[[-118.41856, 34.08619], [-118.41823, 34.08644], [-118.41824, 34.08733], [-118.41701, 34.08733], [-118.4168, 34.08749], [-118.41625, 34.08688], [-118.41708, 34.08619], [-118.41716, 34.08623], [-118.41724, 34.08621], [-118.4173, 34.08614], [-118.41728, 34.08606], [-118.41826, 34.08553], [-118.41856, 34.08619]]]} | Open Access 1 | 45863 | Virginia Robinson Gardens | 28910 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 6.159 | Virginia Robinson Gardens | 0 | Local Park 2 | 4 | |
3900 | 3900 | 3899 | {"type": "Polygon", "coordinates": [[[-118.31984, 34.69203], [-118.31779, 34.69204], [-118.31778, 34.69113], [-118.31984, 34.69112], [-118.31984, 34.69203]]]} | Open Access 1 | 45862 | Pioneer Park | 28909 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 4.685 | Pioneer Park | 0 | Local Park 2 | 4 | |
15081 | 15081 | 15080 | {"type": "MultiPolygon", "coordinates": [[[[-118.18119, 34.01648], [-118.18066, 34.01648], [-118.18065, 34.01554], [-118.18118, 34.01554], [-118.18119, 34.01648]]], [[[-118.1819, 34.01593], [-118.18139, 34.01594], [-118.18139, 34.01566], [-118.1819, 34.01566], [-118.1819, 34.01593]]]]} | Open Access 1 | 45861 | Parque de los Suenos | 28908 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Parque_de_los_Suenos | Los Angeles 6 | 1.61 | Parque de los Suenos | None 1307 | ||
15079 | 15079 | 15078 | {"type": "Polygon", "coordinates": [[[-117.998, 34.01148], [-117.99705, 34.01309], [-117.99598, 34.01266], [-117.99685, 34.011], [-117.998, 34.01148]]]} | Open Access 1 | 45859 | Orange Grove Park | 28906 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Orange_Grove_Park | Los Angeles 6 | 5.663 | Orange Grove Park | 0 | Local Park 2 | 4 |
15078 | 15078 | 15077 | {"type": "MultiPolygon", "coordinates": [[[[-118.55697, 34.47401], [-118.55687, 34.47405], [-118.55682, 34.47398], [-118.55671, 34.47402], [-118.55648, 34.47366], [-118.55626, 34.47374], [-118.55607, 34.4736], [-118.55577, 34.47347], [-118.55556, 34.47333], [-118.55558, 34.47306], [-118.55594, 34.4727], [-118.55656, 34.47312], [-118.55676, 34.47328], [-118.55694, 34.47345], [-118.55684, 34.47354], [-118.55681, 34.47366], [-118.55686, 34.47383], [-118.55697, 34.47401]]], [[[-118.55698, 34.47342], [-118.55697, 34.47342], [-118.55694, 34.47339], [-118.55695, 34.47339], [-118.55698, 34.47342]]]]} | Open Access 1 | 45858 | Tesoro Adobe Historic Park | 28905 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Tesoro_Adobe_Historic_Park | Los Angeles 6 | 2.26 | Tesoro Adobe Historic Park | 0 | Local Historic or Cultural Area 19 | 4 |
15077 | 15077 | 15076 | {"type": "MultiPolygon", "coordinates": [[[[-118.37011, 33.90959], [-118.37014, 33.91163], [-118.37007, 33.91219], [-118.37, 33.91302], [-118.36995, 33.91336], [-118.36991, 33.91356], [-118.36983, 33.91356], [-118.36984, 33.91332], [-118.36982, 33.91301], [-118.36988, 33.91265], [-118.36997, 33.91165], [-118.36996, 33.91074], [-118.36997, 33.90959], [-118.37011, 33.90959]]], [[[-118.3701, 33.90936], [-118.37008, 33.90937], [-118.37003, 33.90937], [-118.36997, 33.90931], [-118.37, 33.90514], [-118.37008, 33.90515], [-118.3701, 33.90936]]]]} | Open Access 1 | 45857 | Wiseburn Walking Path | 30944 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://file.lacounty.gov/dpr/cms1_186946.pdf | Los Angeles 6 | 2.639 | Wiseburn Walking Path | 0 | Local Recreation Area 3 | 4 |
15074 | 15074 | 15073 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | 45853 | Casa Del Caballero | 28900 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.819 | Casa Del Caballero | None 1306 | |||
4371 | 4371 | 4370 | {"type": "MultiPolygon", "coordinates": [[[[-118.24124, 33.92765], [-118.24116, 33.9276], [-118.24085, 33.92733], [-118.24124, 33.92733], [-118.24124, 33.92765]]], [[[-118.24433, 33.92779], [-118.24433, 33.92814], [-118.24389, 33.92811], [-118.2427, 33.92796], [-118.24172, 33.92781], [-118.24433, 33.92779]]], [[[-118.24465, 33.92779], [-118.24465, 33.92817], [-118.24449, 33.92815], [-118.24449, 33.92779], [-118.24465, 33.92779]]], [[[-118.24611, 33.9282], [-118.24572, 33.9282], [-118.24571, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784], [-118.24611, 33.9282]]]]} | Unknown Access 4 | 45850 | 117th and Compton | 28898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.884 | 117th and Compton | None 387 | |||
3899 | 3899 | 3898 | {"type": "Polygon", "coordinates": [[[-117.8205, 34.09105], [-117.82051, 34.09113], [-117.82049, 34.09123], [-117.82036, 34.09135], [-117.82033, 34.09142], [-117.82026, 34.09145], [-117.82024, 34.09087], [-117.82037, 34.09095], [-117.8205, 34.09105]]]} | Open Access 1 | 45847 | San Dimas Staging Area | 28895 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/San_Dimas_Staging_Area | Los Angeles 6 | 0.247 | San Dimas Staging Area | None 334 | ||
4892 | 4892 | 4891 | {"type": "MultiPolygon", "coordinates": [[[[-118.15498, 33.83254], [-118.15491, 33.83579], [-118.15381, 33.83579], [-118.15367, 33.83568], [-118.15367, 33.83541], [-118.15336, 33.8354], [-118.15335, 33.83567], [-118.15358, 33.83568], [-118.15378, 33.83584], [-118.15123, 33.83584], [-118.15123, 33.83648], [-118.15303, 33.83854], [-118.15303, 33.83964], [-118.14813, 33.83963], [-118.14827, 33.83948], [-118.14837, 33.83933], [-118.14842, 33.83919], [-118.1485, 33.83886], [-118.15013, 33.83865], [-118.15122, 33.83875], [-118.15122, 33.8381], [-118.1496, 33.83658], [-118.14871, 33.83658], [-118.14676, 33.83715], [-118.14799, 33.83893], [-118.14829, 33.83889], [-118.14823, 33.83915], [-118.14819, 33.83926], [-118.14811, 33.83939], [-118.14799, 33.83951], [-118.14782, 33.83963], [-118.14742, 33.83963], [-118.14397, 33.83644], [-118.14405, 33.83636], [-118.14424, 33.83639], [-118.14429, 33.83617], [-118.14441, 33.83597], [-118.1462, 33.83409], [-118.14639, 33.83392], [-118.14756, 33.833], [-118.14768, 33.83283], [-118.14773, 33.8327], [-118.14775, 33.83255], [-118.14781, 33.83251], [-118.15469, 33.83253], [-118.1547, 33.83254], [-118.15498, 33.83254]]], [[[-118.15984, 33.8286], [-118.15959, 33.8286], [-118.15661, 33.83004], [-118.15469, 33.83035], [-118.15293, 33.83225], [-118.15, 33.83223], [-118.15104, 33.82949], [-118.15192, 33.82897], [-118.1541, 33.82898], [-118.15411, 33.82768], [-118.15982, 33.82769], [-118.15984, 33.8286]]]]} | Restricted Access 2 | 45718 | Lakewood Golf Course | 33113 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Lakewood_Golf_Course | Los Angeles 6 | 176.286 | Lakewood GC | 0 | Local Recreation Area 3 | 4 |
4355 | 4355 | 4354 | {"type": "Polygon", "coordinates": [[[-117.89899, 34.6164], [-117.89012, 34.61649], [-117.89008, 34.61647], [-117.89004, 34.61644], [-117.88983, 34.60198], [-117.89861, 34.60192], [-117.89899, 34.6164]]]} | Open Access 1 | 45699 | Alpine Butte Wildlife Sanctuary | 28598 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Alpine_Butte_Wildlife_Sanctuary | Los Angeles 6 | 323.116 | Alpine Butte Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
13498 | 13498 | 13497 | {"type": "Polygon", "coordinates": [[[-117.99482, 34.0355], [-117.99427, 34.03605], [-117.99393, 34.03583], [-117.99375, 34.036], [-117.99242, 34.03508], [-117.99314, 34.03435], [-117.99482, 34.0355]]]} | Open Access 1 | 45698 | Avenue Park | 28597 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Avenue_Park | Los Angeles 6 | 4.957 | Avenue Park | 0 | Local Park 2 | 4 |
14999 | 14999 | 14998 | {"type": "MultiPolygon", "coordinates": [[[[-118.55957, 34.45501], [-118.55935, 34.45501], [-118.55916, 34.45505], [-118.55895, 34.45512], [-118.55877, 34.45521], [-118.55844, 34.45462], [-118.5583, 34.4544], [-118.55844, 34.45358], [-118.55844, 34.45314], [-118.55847, 34.4531], [-118.55852, 34.45311], [-118.55957, 34.45501]]], [[[-118.56041, 34.45653], [-118.56029, 34.45665], [-118.56015, 34.45676], [-118.55999, 34.45684], [-118.55982, 34.45689], [-118.55966, 34.45692], [-118.55948, 34.45693], [-118.55926, 34.4569], [-118.5591, 34.45685], [-118.5589, 34.45676], [-118.55878, 34.45668], [-118.55867, 34.45658], [-118.55857, 34.45643], [-118.55849, 34.45625], [-118.55847, 34.45614], [-118.55847, 34.45596], [-118.55852, 34.45578], [-118.55862, 34.4556], [-118.5587, 34.45551], [-118.55879, 34.45542], [-118.55896, 34.45532], [-118.55913, 34.45524], [-118.55929, 34.4552], [-118.55948, 34.45518], [-118.55967, 34.45519], [-118.56041, 34.45653]]], [[[-118.56119, 34.45959], [-118.5598, 34.45708], [-118.55998, 34.45704], [-118.56014, 34.45697], [-118.5604, 34.45682], [-118.56045, 34.45683], [-118.56054, 34.4569], [-118.56072, 34.4571], [-118.56162, 34.45874], [-118.56172, 34.45889], [-118.56191, 34.45914], [-118.56189, 34.45918], [-118.56119, 34.45959]]], [[[-118.5627, 34.46069], [-118.562, 34.46106], [-118.56128, 34.45975], [-118.56196, 34.45935], [-118.5627, 34.46069]]]]} | Open Access 1 | 45646 | West Creek Community Park | 28462 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/West_Creek_Park | Los Angeles 6 | 17.651 | West Creek Community Park | 0 | Local Park 2 | 4 |
14998 | 14998 | 14997 | {"type": "Polygon", "coordinates": [[[-117.7039, 34.48398], [-117.69522, 34.48397], [-117.69519, 34.47942], [-117.70386, 34.47942], [-117.7039, 34.48398]]]} | Open Access 1 | 45645 | Mescal Wildlife Sanctuary | 28461 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Mescal_Wildlife_Sanctuary | Los Angeles 6 | 99.463 | Mescal Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
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]);