superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
171 rows where MNG_AGENCY = 16 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME, PARK_URL, LABEL_NAME
Link | rowid | id | map | ACCESS_TYP | PARK_NAME ▼ | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12017 | 12017 | 12016 | {"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.92784], [-118.24611, 33.9282], [-118.24572, 33.9282], [-118.2457, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784]]]]} | Unknown Access 4 | 117th and Compton | 28898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 2.883 | 117th and Compton | ||
11633 | 11633 | 11632 | {"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 | Acton Wash Wildlife Sanctuary | http://parks.lacounty.gov/wps/portal/dpr/Parks/Acton_Wash_Sanctuary | 28184 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 75.745 | Acton Wash Wildlife Sanctuary | |
606 | 606 | 605 | {"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.03777, 33.94223]]]} | Open Access 1 | Adventure Park | 15277 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 14.562 | Adventure Park | ||
12487 | 12487 | 12486 | {"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.44875], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44875]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | Agua Dulce Canyon Parkland | 29553 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 61.585 | Agua Dulce Canyon Parkland | ||
1224 | 1224 | 1223 | {"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 | Allen J Martin Park | 15378 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 6.796 | Allen J Martin Park | ||
685 | 685 | 684 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88725], [-118.34029, 33.88725], [-118.34013, 33.88558], [-118.34366, 33.88545], [-118.34366, 33.88725]]]} | Open Access 1 | Alondra Community Regional Park | 15402 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.212 | Alondra Community RP | ||
14611 | 14611 | 14610 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88545], [-118.34014, 33.88558], [-118.34029, 33.88725], [-118.33518, 33.88725], [-118.33518, 33.88623], [-118.33512, 33.88577], [-118.33502, 33.88542], [-118.33485, 33.88504], [-118.33464, 33.88473], [-118.33435, 33.88438], [-118.33446, 33.88429], [-118.33398, 33.88376], [-118.33384, 33.88384], [-118.33158, 33.88141], [-118.34006, 33.87868], [-118.34008, 33.87868], [-118.34029, 33.87861], [-118.3403, 33.8786], [-118.34353, 33.87755], [-118.34365, 33.87762], [-118.34366, 33.88545]]]} | Restricted Access 2 | Alondra Golf Course | 33106 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 187.763 | Alondra GC | ||
11896 | 11896 | 11895 | {"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 | Alpine Butte Wildlife Sanctuary | http://parks.lacounty.gov/wps/portal/dpr/Parks/Alpine_Butte_Wildlife_Sanctuary | 28598 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 323.107 | Alpine Butte Wildlife Sanctuary | |
14579 | 14579 | 14578 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.1211, 34.18492], [-118.12098, 34.18506], [-118.12058, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18573], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18335], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11781, 34.18091], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18008], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.1832], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12169, 34.18412]]]} | Restricted Access 2 | Altadena Golf Course | 33022 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 57.751 | Altadena GC | ||
1466 | 1466 | 1465 | {"type": "Polygon", "coordinates": [[[-118.70661, 34.02967], [-118.70628, 34.02966], [-118.70561, 34.02975], [-118.70526, 34.02983], [-118.70503, 34.03003], [-118.70481, 34.03012], [-118.70419, 34.03031], [-118.70382, 34.03037], [-118.70373, 34.03036], [-118.70346, 34.03042], [-118.70316, 34.03054], [-118.70299, 34.0305], [-118.70275, 34.03058], [-118.70225, 34.03072], [-118.70199, 34.03075], [-118.70161, 34.03085], [-118.70144, 34.03079], [-118.70127, 34.03077], [-118.70101, 34.0309], [-118.7003, 34.03111], [-118.70019, 34.03118], [-118.69989, 34.03128], [-118.69944, 34.03147], [-118.69944, 34.03155], [-118.69921, 34.0316], [-118.69916, 34.03149], [-118.69885, 34.03153], [-118.69884, 34.03154], [-118.69891, 34.03167], [-118.69846, 34.03179], [-118.69837, 34.03173], [-118.69826, 34.03179], [-118.69825, 34.03188], [-118.69792, 34.03201], [-118.69769, 34.03212], [-118.69763, 34.03207], [-118.69732, 34.03223], [-118.6972, 34.03217], [-118.69697, 34.03227], [-118.69681, 34.03228], [-118.69627, 34.0325], [-118.69582, 34.03263], [-118.69571, 34.03238], [-118.69614, 34.03228], [-118.69686, 34.03216], [-118.69835, 34.0316], [-118.69939, 34.03133], [-118.69992, 34.0311], [-118.70058, 34.03087], [-118.70138, 34.03063], [-118.70161, 34.0306], [-118.70178, 34.03062], [-118.70227, 34.03055], [-118.70288, 34.03032], [-118.70426, 34.03001], [-118.70525, 34.02965], [-118.70589, 34.0295], [-118.70651, 34.02923], [-118.70661, 34.02967]]]} | Open Access 1 | Amarillo Beach | 15438 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.783 | Amarillo Beach | ||
1474 | 1474 | 1473 | {"type": "Polygon", "coordinates": [[[-118.05172, 33.93163], [-118.05126, 33.93164], [-118.05124, 33.93161], [-118.0496, 33.93161], [-118.04959, 33.92815], [-118.05097, 33.92917], [-118.05171, 33.92968], [-118.05172, 33.93163]]]} | Open Access 1 | Amelia Mayberry Park | 15446 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 14.436 | Amelia Mayberry Park | ||
1498 | 1498 | 1497 | {"type": "Polygon", "coordinates": [[[-118.08333, 34.20101], [-118.0833, 34.20282], [-118.0787, 34.20281], [-118.07873, 34.201], [-118.08333, 34.20101]]]} | Open Access 1 | Angeles National Forest | 15491 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 21.075 | Angeles NF | 1908 | |
1553 | 1553 | 1552 | {"type": "MultiPolygon", "coordinates": [[[[-118.0383, 34.1366], [-118.03704, 34.13795], [-118.03692, 34.1379], [-118.03674, 34.1381], [-118.03674, 34.13812], [-118.03683, 34.13817], [-118.03527, 34.13986], [-118.0351, 34.13987], [-118.03504, 34.13992], [-118.0316, 34.13997], [-118.03151, 34.13565], [-118.03198, 34.13576], [-118.03227, 34.13601], [-118.03259, 34.13624], [-118.03292, 34.13634], [-118.03343, 34.13635], [-118.03405, 34.13627], [-118.0349, 34.13614], [-118.03571, 34.13614], [-118.03624, 34.13619], [-118.03681, 34.13613], [-118.03775, 34.13635], [-118.0383, 34.1366]]], [[[-118.04112, 34.13356], [-118.04112, 34.13356], [-118.04099, 34.1337], [-118.04109, 34.13358], [-118.04112, 34.13356]]]]} | Open Access 1 | Arcadia Community Regional Park | 15565 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 50.673 | Arcadia Community RP | ||
1642 | 1642 | 1641 | {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91876], [-118.2806, 33.91994], [-118.27843, 33.91994], [-118.27849, 33.9166], [-118.27855, 33.91656], [-118.2806, 33.91655], [-118.28067, 33.91661], [-118.28068, 33.91874]]]} | Open Access 1 | Athens Park | 15666 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 18.721 | Athens Park | ||
1649 | 1649 | 1648 | {"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.15502, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.951 | Atlantic Avenue Park | ||
1249 | 1249 | 1248 | {"type": "Polygon", "coordinates": [[[-118.45619, 33.96552], [-118.45317, 33.967], [-118.45309, 33.9669], [-118.45614, 33.96543], [-118.45619, 33.96552]]]} | Open Access 1 | Aubrey E. Austin Jr. Park and North Jetty | https://beaches.lacounty.gov/?s=Aubrey+E.+Austin+Jr.+Park+and+North+Jetty | 15682 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.965 | Aubrey E. Austin Jr. Park and North Jetty | |
11891 | 11891 | 11890 | {"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 | Avenue Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Avenue_Park | 28597 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 4.958 | Avenue Park | |
13096 | 13096 | 13095 | {"type": "MultiPolygon", "coordinates": [[[[-118.4334, 33.97487], [-118.43334, 33.97494], [-118.43267, 33.97532], [-118.43253, 33.97541], [-118.4325, 33.97537], [-118.43334, 33.97488], [-118.43335, 33.97486], [-118.4334, 33.97487]]], [[[-118.4549, 33.9631], [-118.45487, 33.96311], [-118.45485, 33.9631], [-118.4546, 33.96321], [-118.45466, 33.96334], [-118.45351, 33.96386], [-118.45342, 33.96376], [-118.45282, 33.96406], [-118.45287, 33.96416], [-118.45163, 33.96472], [-118.45097, 33.96374], [-118.45201, 33.96315], [-118.45277, 33.96276], [-118.45277, 33.96271], [-118.45305, 33.96258], [-118.45376, 33.96368], [-118.4539, 33.96362], [-118.45391, 33.9636], [-118.45319, 33.96251], [-118.45385, 33.96218], [-118.45392, 33.96225], [-118.45421, 33.96211], [-118.4549, 33.9631]]]]} | Open Access 1 | Ballona Creek Trail and Bike Path | 30329 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 11.284 | Ballona Creek Trail and Bike Path | ||
1796 | 1796 | 1795 | {"type": "Polygon", "coordinates": [[[-117.98854, 34.05187], [-117.98765, 34.05279], [-117.98644, 34.05198], [-117.98629, 34.05211], [-117.98513, 34.05133], [-117.98614, 34.05027], [-117.98854, 34.05187]]]} | Open Access 1 | Bassett Park | 15856 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 9.79 | Bassett Park | ||
1945 | 1945 | 1944 | {"type": "Polygon", "coordinates": [[[-118.15988, 34.03624], [-118.15906, 34.03626], [-118.15743, 34.03622], [-118.15728, 34.03626], [-118.15722, 34.03384], [-118.15715, 34.03383], [-118.15715, 34.03355], [-118.15977, 34.03352], [-118.15977, 34.03385], [-118.15987, 34.03386], [-118.15988, 34.03624]]]} | Open Access 1 | Belvedere Park Lake | 16000 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 17.955 | Belvedere Park Lake |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);