units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where DES_TP = 2 and MNG_AGENCY = 16 sorted by AGNCY_LEV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1198 | 1198 | 1197 | {"type": "Polygon", "coordinates": [[[-117.94417, 33.99296], [-117.94358, 33.99312], [-117.94315, 33.99321], [-117.94258, 33.9933], [-117.94209, 33.99335], [-117.94199, 33.99239], [-117.94203, 33.99236], [-117.94252, 33.99232], [-117.94272, 33.99228], [-117.94343, 33.99205], [-117.94387, 33.99201], [-117.94393, 33.99239], [-117.94417, 33.99296]]]} | Open Access 1 | 8300 | Pepperbrook Park | 23596 | 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.118 | Pepperbrook Park | 0 | Local Park 2 | 4 | |
1530 | 1530 | 1529 | {"type": "MultiPolygon", "coordinates": [[[[-118.24585, 34.05493], [-118.24508, 34.05575], [-118.24423, 34.05519], [-118.245, 34.05437], [-118.24585, 34.05493]]], [[[-118.24802, 34.05649], [-118.24774, 34.05684], [-118.24735, 34.05721], [-118.24724, 34.05714], [-118.24721, 34.05717], [-118.24519, 34.05598], [-118.24595, 34.05518], [-118.24772, 34.05633], [-118.24775, 34.05632], [-118.24802, 34.05649]]]]} | Open Access 1 | 12926 | Grand Park | 29040 | 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.306 | Grand Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 |
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 | |
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 |
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 | |
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 | |
6746 | 6746 | 6745 | {"type": "Polygon", "coordinates": [[[-117.97585, 34.00262], [-117.97532, 34.00429], [-117.97272, 34.0035], [-117.97327, 34.00182], [-117.97585, 34.00262]]]} | Open Access 1 | 5089 | Manzanita Park | 21767 | 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 | 12.116 | Manzanita Park | 0 | Local Park 2 | 4 | |
6842 | 6842 | 6841 | {"type": "Polygon", "coordinates": [[[-118.62491, 34.03758], [-118.6246, 34.03769], [-118.62402, 34.03776], [-118.62328, 34.0378], [-118.62269, 34.0378], [-118.62242, 34.03779], [-118.62218, 34.0377], [-118.62193, 34.03765], [-118.62107, 34.03764], [-118.62025, 34.03753], [-118.61966, 34.0375], [-118.61937, 34.03744], [-118.61881, 34.03741], [-118.61666, 34.03722], [-118.61634, 34.03716], [-118.61595, 34.03704], [-118.61566, 34.03701], [-118.61535, 34.03694], [-118.61516, 34.03692], [-118.6148, 34.03692], [-118.61451, 34.03695], [-118.61391, 34.03695], [-118.61311, 34.03689], [-118.61289, 34.03691], [-118.61253, 34.03691], [-118.61234, 34.03688], [-118.61197, 34.03679], [-118.6119, 34.03683], [-118.61168, 34.03679], [-118.61022, 34.03651], [-118.60983, 34.03648], [-118.60949, 34.03654], [-118.60912, 34.03666], [-118.60906, 34.03649], [-118.60955, 34.03616], [-118.60993, 34.03612], [-118.61164, 34.03655], [-118.61233, 34.03669], [-118.61421, 34.03668], [-118.61548, 34.03682], [-118.61679, 34.03701], [-118.61735, 34.03698], [-118.61856, 34.03714], [-118.61901, 34.03728], [-118.61992, 34.03734], [-118.62085, 34.03746], [-118.62219, 34.03757], [-118.62289, 34.03761], [-118.62384, 34.0376], [-118.62484, 34.03749], [-118.62491, 34.03758]]]} | Open Access 1 | 5472 | Big Rock Beach | 16086 | 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.357 | Big Rock Beach | 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]);