units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
153 rows where ACCESS_TYP = 1 and MNG_AGENCY = 16 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
DES_TP 19
- Local Park 75
- Local Recreation Area 20
- Local Conservation Area 14
- Local Other or Unknown 8
- National Recreation Area 2
- 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
MNG_AG_TYP 1
- County Agency 133
MNG_AGENCY 1
- Los Angeles, County of · 133 ✖
ACCESS_TYP 1
- Open Access · 133 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1614 | 1614 | 1613 | {"type": "Polygon", "coordinates": [[[-118.65024, 34.1181], [-118.65024, 34.11939], [-118.6502, 34.12172], [-118.64565, 34.1217], [-118.64568, 34.1181], [-118.65024, 34.1181]]]} | Open Access 1 | 12332 | Secret Valley | 32667 | 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 | 41.753 | Secret Valley | None 129 | |||
1686 | 1686 | 1685 | {"type": "Polygon", "coordinates": [[[-118.13552, 34.20063], [-118.13446, 34.2021], [-118.13438, 34.20208], [-118.13098, 34.20099], [-118.13105, 34.19921], [-118.13348, 34.19998], [-118.13298, 34.20069], [-118.13454, 34.20119], [-118.13505, 34.20048], [-118.13552, 34.20063]]]} | Open Access 1 | 6967 | Farnsworth Park | 18847 | 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 | 14.773 | Farnsworth Park | 0 | Local Park 2 | 4 | |
1718 | 1718 | 1717 | {"type": "Polygon", "coordinates": [[[-118.23745, 34.23344], [-118.23721, 34.23376], [-118.23671, 34.23428], [-118.23649, 34.23467], [-118.23516, 34.23385], [-118.23517, 34.23204], [-118.23745, 34.23344]]]} | Open Access 1 | 14870 | Two Strike Park | 26627 | 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 | 8.187 | Two Strike Park | 0 | Local Park 2 | 4 | |
2157 | 2157 | 2156 | {"type": "Polygon", "coordinates": [[[-118.35905, 33.9381], [-118.35751, 33.93811], [-118.3575, 33.93775], [-118.35755, 33.93774], [-118.35756, 33.93669], [-118.35858, 33.93669], [-118.3586, 33.93651], [-118.35905, 33.93651], [-118.35905, 33.9381]]]} | Open Access 1 | 6183 | Lennox Park | 21163 | 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 | 5.629 | Lennox Park | 0 | Local Park 2 | 4 | |
2194 | 2194 | 2193 | {"type": "Polygon", "coordinates": [[[-117.96354, 34.0398], [-117.96255, 34.04072], [-117.96092, 34.03957], [-117.96193, 34.03862], [-117.96354, 34.0398]]]} | Open Access 1 | 16435 | Allen J Martin Park | 15378 | 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.797 | Allen J Martin Park | 0 | Local Park 2 | 4 | |
2215 | 2215 | 2214 | {"type": "Polygon", "coordinates": [[[-118.42983, 33.91628], [-118.4284, 33.91628], [-118.4259, 33.91134], [-118.42606, 33.91129], [-118.42606, 33.91127], [-118.42358, 33.90637], [-118.42295, 33.90501], [-118.42323, 33.90492], [-118.42451, 33.90742], [-118.42615, 33.91031], [-118.42632, 33.9105], [-118.4267, 33.91083], [-118.42692, 33.91098], [-118.4275, 33.91078], [-118.42757, 33.91145], [-118.42767, 33.91174], [-118.42983, 33.91628]]]} | Open Access 1 | 6135 | El Segundo Beach | 18539 | 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.599 | El Segundo Beach | 0 | Local Park 2 | 4 | |
2388 | 2388 | 2387 | {"type": "Polygon", "coordinates": [[[-118.37617, 34.29334], [-118.37616, 34.29567], [-118.3754, 34.29566], [-118.37534, 34.29593], [-118.37525, 34.2961], [-118.37537, 34.29616], [-118.37601, 34.29595], [-118.37616, 34.29584], [-118.37615, 34.29697], [-118.37174, 34.29699], [-118.37177, 34.29335], [-118.37617, 34.29334]]]} | Open Access 1 | 18612 | Dexter Park | 18130 | 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 | 39.613 | Dexter 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 | ||
3382 | 3382 | 3381 | {"type": "Polygon", "coordinates": [[[-118.62106, 34.45164], [-118.62107, 34.45184], [-118.62102, 34.45201], [-118.62092, 34.45216], [-118.62076, 34.45229], [-118.62003, 34.45265], [-118.61979, 34.45275], [-118.61957, 34.45281], [-118.61934, 34.45285], [-118.61898, 34.45287], [-118.61899, 34.45259], [-118.61893, 34.45157], [-118.61917, 34.45156], [-118.61924, 34.45151], [-118.61933, 34.45155], [-118.61943, 34.45152], [-118.61948, 34.45157], [-118.62007, 34.45154], [-118.62014, 34.45147], [-118.62025, 34.4515], [-118.62029, 34.45158], [-118.62069, 34.45167], [-118.62071, 34.45165], [-118.62106, 34.45164]]]} | Open Access 1 | 24535 | Hasley Canyon Park | 19731 | 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 | 5.363 | Hasley Canyon Park | 0 | Local Park 2 | 4 | |
3454 | 3454 | 3453 | {"type": "Polygon", "coordinates": [[[-118.63309, 34.12589], [-118.63308, 34.12624], [-118.63243, 34.12624], [-118.63244, 34.12598], [-118.63309, 34.12589]]]} | Open Access 1 | 35562 | Los Angeles holding 5 | 21492 | 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.502 | Los Angeles holding 5 | 0 | Local Other or Unknown 14 | 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 | |
4027 | 4027 | 4026 | {"type": "Polygon", "coordinates": [[[-117.88249, 34.12031], [-117.88152, 34.12031], [-117.88149, 34.11967], [-117.8815, 34.11823], [-117.88152, 34.11821], [-117.88248, 34.11821], [-117.88249, 34.12031]]]} | Open Access 1 | 44271 | Dalton Park | 17899 | 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 | 5.245 | Dalton Park | 0 | Local Park 2 | 4 | |
4316 | 4316 | 4315 | {"type": "Polygon", "coordinates": [[[-117.71308, 34.52742], [-117.7107, 34.52743], [-117.70912, 34.52733], [-117.70868, 34.52731], [-117.70817, 34.52733], [-117.70657, 34.52746], [-117.70429, 34.52748], [-117.70429, 34.52697], [-117.70443, 34.52566], [-117.70444, 34.52536], [-117.70442, 34.52507], [-117.70429, 34.52397], [-117.70426, 34.52396], [-117.70423, 34.5203], [-117.71303, 34.52029], [-117.71308, 34.52742]]]} | Open Access 1 | 45408 | Payne Wildlife Sanctuary | 28183 | 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 | 156.867 | Payne Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
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 | |
4433 | 4433 | 4432 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44876], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44876]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | 46400 | Agua Dulce Canyon Parkland | 29553 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 61.59 | Agua Dulce Canyon Parkland | 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 | |
5092 | 5092 | 5091 | {"type": "Polygon", "coordinates": [[[-117.86138, 34.42461], [-117.86137, 34.42822], [-117.85696, 34.42822], [-117.85696, 34.42461], [-117.86138, 34.42461]]]} | Open Access 1 | 5339 | Blanche Hamilton Wildlife Sanctuary | 30666 | 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 | 40.243 | Blanche Hamilton Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
5277 | 5277 | 5276 | {"type": "Polygon", "coordinates": [[[-117.96221, 34.46435], [-117.95784, 34.46435], [-117.95784, 34.46345], [-117.9622, 34.46345], [-117.96221, 34.46435]]]} | Open Access 1 | 2606 | Juniper Hills Park | 20526 | 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 | 9.918 | Juniper Hills Park | 0 | Local Park 2 | 4 | |
6180 | 6180 | 6179 | {"type": "Polygon", "coordinates": [[[-118.03777, 33.94223], [-118.03775, 33.94226], [-118.03456, 33.94387], [-118.03448, 33.94386], [-118.0328, 33.9427], [-118.03497, 33.94159], [-118.03576, 33.94213], [-118.03685, 33.94158], [-118.03773, 33.94218], [-118.03774, 33.94222], [-118.03776, 33.94222], [-118.03777, 33.94223]]]} | Open Access 1 | 1282 | Adventure Park | 15277 | 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 | 14.559 | Adventure Park | 0 | Local Park 2 | 4 | |
6502 | 6502 | 6501 | {"type": "Polygon", "coordinates": [[[-117.9227, 34.54259], [-117.92261, 34.54266], [-117.90969, 34.54268], [-117.90967, 34.53918], [-117.92267, 34.53916], [-117.9227, 34.54259]]]} | Open Access 1 | 2385 | Jackrabbit Flats Wildlife Sanctuary | 20317 | 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 | 114.439 | Jackrabbit Flats 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]);