units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where MNG_AGENCY = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 20
- Local Park 90
- Local Recreation Area 26
- Local Conservation Area 15
- Local Other or Unknown 7
- National Recreation Area 2
- 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4613 | 4613 | 4612 | {"type": "Polygon", "coordinates": [[[-118.63997, 34.08326], [-118.63997, 34.08356], [-118.63947, 34.08386], [-118.6392, 34.08385], [-118.63897, 34.08343], [-118.63935, 34.08326], [-118.63997, 34.08326]]]} | No Public Access 3 | 35763 | Unnamed site - Los Angeles County Waterworks | 30320 | 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 | 1.128 | 0 | Local Other or Unknown 14 | 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 | ||
13458 | 13458 | 13457 | {"type": "Polygon", "coordinates": [[[-118.16322, 34.20967], [-118.16308, 34.21031], [-118.16183, 34.21032], [-118.1618, 34.20908], [-118.16226, 34.2091], [-118.16218, 34.20921], [-118.16211, 34.20936], [-118.16205, 34.20959], [-118.16203, 34.20973], [-118.16203, 34.21], [-118.16209, 34.2101], [-118.1622, 34.21018], [-118.16229, 34.2102], [-118.1624, 34.2102], [-118.16254, 34.21015], [-118.16284, 34.20986], [-118.16294, 34.20972], [-118.16298, 34.20963], [-118.16322, 34.20967]]]} | Open Access 1 | 35757 | Los Angeles holding 7 | 21494 | 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 | 1.731 | Los Angeles holding 7 | 0 | Local Other or Unknown 14 | 4 | |
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 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 | 1.951 | Atlantic Avenue Park | 0 | Local Park 2 | 4 | |
6056 | 6056 | 6055 | {"type": "Polygon", "coordinates": [[[-118.65875, 34.07333], [-118.65821, 34.07334], [-118.6582, 34.07327], [-118.65765, 34.07327], [-118.65765, 34.07272], [-118.65786, 34.07272], [-118.65786, 34.0725], [-118.65875, 34.07256], [-118.65875, 34.07333]]]} | Restricted Access 2 | 12780 | Santa Monica Mountains National Recreation Area | 29657 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 2.045 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
931 | 931 | 930 | {"type": "Polygon", "coordinates": [[[-118.0711, 34.1307], [-118.0711, 34.13084], [-118.07107, 34.13097], [-118.07101, 34.13109], [-118.0709, 34.13121], [-118.07078, 34.1313], [-118.07065, 34.13137], [-118.07052, 34.13141], [-118.07035, 34.13143], [-118.07018, 34.13143], [-118.07004, 34.1314], [-118.06991, 34.13135], [-118.06977, 34.13128], [-118.06965, 34.13117], [-118.06958, 34.13108], [-118.06952, 34.13097], [-118.06949, 34.13082], [-118.0711, 34.1307]]]} | Open Access 1 | 5345 | Michillinda Park | 22201 | 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.162 | Michillinda 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 |
4413 | 4413 | 4412 | {"type": "Polygon", "coordinates": [[[-117.92209, 33.97404], [-117.9218, 33.97523], [-117.9216, 33.97518], [-117.92132, 33.97508], [-117.92083, 33.97478], [-117.92109, 33.9745], [-117.92144, 33.97416], [-117.92158, 33.974], [-117.92181, 33.97364], [-117.92189, 33.97331], [-117.92205, 33.97332], [-117.92199, 33.97395], [-117.92209, 33.97404]]]} | Open Access 1 | 46293 | Trailview Park | 29585 | 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/Trailview_Park | Los Angeles 6 | 2.717 | Trailview Park | 0 | Local Park 2 | 4 |
14245 | 14245 | 14244 | {"type": "Polygon", "coordinates": [[[-118.03024, 34.15973], [-118.02975, 34.15977], [-118.0297, 34.1602], [-118.02916, 34.16008], [-118.02882, 34.16003], [-118.02852, 34.16], [-118.02806, 34.16001], [-118.02952, 34.15919], [-118.03012, 34.15918], [-118.03024, 34.15973]]]} | Restricted Access 2 | 44142 | Highland Oaks Park | 19930 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.851 | Highland Oaks Park | 0 | Local Park 2 | 4 | |
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 | |||
4422 | 4422 | 4421 | {"type": "Polygon", "coordinates": [[[-117.95901, 34.54284], [-117.95831, 34.54284], [-117.95827, 34.54281], [-117.95826, 34.54126], [-117.95829, 34.54122], [-117.95901, 34.54121], [-117.95901, 34.54284]]]} | Open Access 1 | 46290 | Mattie M. Primmer Park | 29583 | 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.034 | Mattie M. Primmer Park | 0 | Local Park 2 | 4 | |
4973 | 4973 | 4972 | {"type": "Polygon", "coordinates": [[[-118.60043, 34.03928], [-118.59866, 34.03936], [-118.59704, 34.03949], [-118.59696, 34.03894], [-118.59729, 34.03892], [-118.59789, 34.03909], [-118.59841, 34.03915], [-118.59889, 34.03908], [-118.59909, 34.03891], [-118.60041, 34.039], [-118.60043, 34.03928]]]} | Open Access 1 | 3710 | Las Tunas County Beach | 21070 | 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.146 | Las Tunas County Beach | 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 | |||
15253 | 15253 | 15252 | {"type": "Polygon", "coordinates": [[[-117.83699, 34.08985], [-117.83673, 34.08994], [-117.83653, 34.08996], [-117.83639, 34.08993], [-117.83584, 34.08976], [-117.83566, 34.08974], [-117.83549, 34.08978], [-117.83504, 34.08995], [-117.83494, 34.09], [-117.83486, 34.09007], [-117.83466, 34.09033], [-117.83457, 34.0904], [-117.83461, 34.09043], [-117.8346, 34.09048], [-117.8345, 34.09064], [-117.83412, 34.09094], [-117.83411, 34.09105], [-117.83404, 34.09105], [-117.83392, 34.09111], [-117.83371, 34.09097], [-117.83288, 34.09149], [-117.83288, 34.09151], [-117.83312, 34.09166], [-117.83266, 34.09198], [-117.83208, 34.09179], [-117.83371, 34.09078], [-117.83396, 34.09098], [-117.83404, 34.09095], [-117.83405, 34.09078], [-117.83451, 34.09034], [-117.83467, 34.0901], [-117.83486, 34.08988], [-117.83536, 34.08953], [-117.8357, 34.08948], [-117.83608, 34.08955], [-117.83627, 34.08953], [-117.83661, 34.08973], [-117.83687, 34.08962], [-117.83699, 34.08985]]]} | Open Access 1 | 46302 | Valley Center Staging Area | 29586 | 3365 | Buddhist Compassion Relief Tzu Chi Foundation 1144 | Non Profit 6 | Non Profit - Other 22 | http://www.tzuchi.us/ | Non Governmental Organization 10 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.239 | Valley Ctr. Staging Area | None 1343 | |||
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 | |
2467 | 2467 | 2466 | {"type": "Polygon", "coordinates": [[[-118.22632, 33.89521], [-118.22505, 33.89528], [-118.22499, 33.89426], [-118.22564, 33.89422], [-118.22561, 33.89372], [-118.22622, 33.89369], [-118.22632, 33.89521]]]} | Open Access 1 | 6275 | Martin Luther King Jr. Memorial | 21909 | 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.068 | Martin Luther King Jr. Memorial | 0 | None 204 | ||
16431 | 16431 | 16430 | {"type": "Polygon", "coordinates": [[[-117.83973, 34.08948], [-117.83939, 34.08989], [-117.83876, 34.08965], [-117.83843, 34.08942], [-117.83824, 34.08936], [-117.83808, 34.08936], [-117.83791, 34.08941], [-117.83777, 34.08951], [-117.8376, 34.08971], [-117.83744, 34.08977], [-117.83718, 34.0898], [-117.83699, 34.08985], [-117.83687, 34.08962], [-117.83699, 34.08957], [-117.83757, 34.08887], [-117.83804, 34.08872], [-117.83842, 34.08887], [-117.83904, 34.08915], [-117.83954, 34.08911], [-117.83973, 34.08948]]]} | Open Access 1 | 46301 | Walnut Creek Community Regional Park | 29589 | 3365 | Buddhist Compassion Relief Tzu Chi Foundation 1144 | Non Profit 6 | Non Profit - Other 22 | http://www.tzuchi.us/ | Non Governmental Organization 10 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Walnut_Creek_Community_Regional_Park | Los Angeles 6 | 4.239 | Walnut Creek Community RP | 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 | |
9780 | 9780 | 9779 | {"type": "Polygon", "coordinates": [[[-118.63702, 34.45237], [-118.63703, 34.45246], [-118.63701, 34.45251], [-118.63659, 34.45296], [-118.63652, 34.45292], [-118.63652, 34.45288], [-118.63643, 34.45278], [-118.63616, 34.45261], [-118.63605, 34.45258], [-118.63601, 34.45258], [-118.63597, 34.45263], [-118.63589, 34.4526], [-118.63582, 34.45248], [-118.63576, 34.45241], [-118.63541, 34.45209], [-118.63522, 34.45196], [-118.63509, 34.45188], [-118.63491, 34.45173], [-118.63482, 34.45162], [-118.63482, 34.45156], [-118.63492, 34.45143], [-118.63508, 34.45129], [-118.63542, 34.45113], [-118.63578, 34.45131], [-118.63605, 34.45148], [-118.63627, 34.45166], [-118.63652, 34.45162], [-118.63658, 34.45164], [-118.63659, 34.45166], [-118.63663, 34.45196], [-118.63675, 34.45213], [-118.63683, 34.45227], [-118.63697, 34.45233], [-118.63702, 34.45237]]]} | Open Access 1 | 47885 | Hasley Canyon Equestrian Park | 31829 | 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/hasley-canyon-equestrian-park/ | Los Angeles 6 | 4.746 | Hasley Canyon Equestrian Park | 0 | Local Recreation Area 3 | 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]);