units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where MNG_AGENCY = 16 sorted by YR_EST
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1649 | 1649 | 1648 | {"type": "MultiPolygon", "coordinates": [[[[-117.70252, 34.62762], [-117.70249, 34.63864], [-117.69592, 34.63871], [-117.69593, 34.63687], [-117.69482, 34.63688], [-117.69483, 34.63504], [-117.69373, 34.63504], [-117.69369, 34.63873], [-117.69146, 34.63875], [-117.69147, 34.63692], [-117.69137, 34.63691], [-117.69036, 34.63692], [-117.69035, 34.63876], [-117.68478, 34.63881], [-117.68481, 34.63143], [-117.68928, 34.6314], [-117.68928, 34.62771], [-117.69375, 34.62768], [-117.69376, 34.624], [-117.69823, 34.62397], [-117.69822, 34.62765], [-117.70252, 34.62762]]], [[[-117.70248, 34.64227], [-117.70247, 34.64598], [-117.69364, 34.64598], [-117.69366, 34.64235], [-117.70248, 34.64227]]]]} | Open Access 1 | 14183 | Carl O. Gerhardy Wildlife Sanctuary | 16854 | 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/Carl_O_Gerhardy_Wildlife_Sanctuary | Los Angeles 6 | 552.259 | Carl O. Gerhardy Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
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 | |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | 6243 | Victoria Golf Course | 33008 | 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 | 167.229 | Victoria GC | 0 | Local Recreation Area 3 | 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 | |
3839 | 3839 | 3838 | {"type": "Polygon", "coordinates": [[[-117.83849, 34.61111], [-117.83844, 34.61122], [-117.83629, 34.61123], [-117.83631, 34.61635], [-117.8355, 34.61634], [-117.83549, 34.61306], [-117.83548, 34.61288], [-117.83541, 34.61251], [-117.83529, 34.61217], [-117.8348, 34.61124], [-117.8346, 34.61086], [-117.83444, 34.61059], [-117.83432, 34.61046], [-117.83412, 34.6103], [-117.83399, 34.61024], [-117.83363, 34.61011], [-117.83351, 34.61008], [-117.83185, 34.6085], [-117.83127, 34.6083], [-117.82893, 34.60825], [-117.82623, 34.60825], [-117.82514, 34.60681], [-117.82557, 34.60661], [-117.82567, 34.60658], [-117.82681, 34.60652], [-117.82705, 34.60648], [-117.82743, 34.60639], [-117.82795, 34.6062], [-117.82811, 34.60612], [-117.82829, 34.60603], [-117.82856, 34.60584], [-117.82856, 34.60583], [-117.82814, 34.60543], [-117.82814, 34.60539], [-117.8281, 34.60533], [-117.82805, 34.6053], [-117.82799, 34.60529], [-117.82755, 34.60489], [-117.82881, 34.60398], [-117.82949, 34.60318], [-117.82979, 34.60335], [-117.83009, 34.60355], [-117.83037, 34.60377], [-117.83062, 34.604], [-117.8308, 34.60419], [-117.83296, 34.60663], [-117.83319, 34.60687], [-117.83344, 34.60708], [-117.83363, 34.60723], [-117.83392, 34.60744], [-117.83421, 34.60761], [-117.8347, 34.60786], [-117.8352, 34.60806], [-117.83588, 34.60825], [-117.83805, 34.60874], [-117.83794, 34.60908], [-117.83794, 34.61049], [-117.83849, 34.61111]]]} | Open Access 1 | 45402 | Stephen Sorensen Park | 28178 | 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/Stephen_Sorensen_Park | Los Angeles 6 | 108.11 | Stephen Sorensen Park | 0 | Local Park 2 | 4 |
3840 | 3840 | 3839 | {"type": "Polygon", "coordinates": [[[-118.19365, 34.46865], [-118.19179, 34.46986], [-118.18708, 34.46989], [-118.18708, 34.47143], [-118.18489, 34.47176], [-118.18486, 34.46632], [-118.19145, 34.46629], [-118.19146, 34.4681], [-118.19365, 34.46809], [-118.19365, 34.46865]]]} | Open Access 1 | 45411 | Acton Wash Wildlife Sanctuary | 28184 | 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/Acton_Wash_Sanctuary | Los Angeles 6 | 75.717 | Acton Wash Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
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 | |
4319 | 4319 | 4318 | {"type": "Polygon", "coordinates": [[[-118.50639, 34.77821], [-118.50636, 34.78185], [-118.50197, 34.78185], [-118.50201, 34.77821], [-118.50639, 34.77821]]]} | Open Access 1 | 45412 | Neenach Wildlife Preserve | 28185 | 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/Neenach_Wildlife_Preserve | Los Angeles 6 | 40.113 | Neenach Wildlife Preserve | 0 | Local Conservation Area 4 | 2 |
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 |
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 | |
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 |
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]);