superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
171 rows where MNG_AGENCY = 16 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12494 | 12494 | 12493 | {"type": "Polygon", "coordinates": [[[-118.37777, 34.01479], [-118.37753, 34.0148], [-118.37747, 34.01477], [-118.37741, 34.01476], [-118.37599, 34.0148], [-118.37598, 34.01451], [-118.37593, 34.01451], [-118.37619, 34.01404], [-118.37647, 34.01384], [-118.37662, 34.01349], [-118.37761, 34.01347], [-118.37774, 34.01366], [-118.37777, 34.01479]]]} | Open Access 1 | Stoneview Park | 29580 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.018 | Stoneview Park | 2017 | |
11635 | 11635 | 11634 | {"type": "Polygon", "coordinates": [[[-118.41054, 34.22709], [-118.4103, 34.22778], [-118.40776, 34.22897], [-118.40741, 34.22916], [-118.40705, 34.2294], [-118.407, 34.22941], [-118.40696, 34.22939], [-118.404, 34.22662], [-118.40712, 34.22434], [-118.40755, 34.22467], [-118.40844, 34.22521], [-118.40886, 34.2255], [-118.41022, 34.22678], [-118.41054, 34.22709]]]} | Open Access 1 | Sheldon-Arleta Park | http://www.laparks.org/dos/parks/facility/devonshireArletaPk.htm | 28186 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 45.126 | Sheldon-Arleta Park | 2016 |
6550 | 6550 | 6549 | {"type": "MultiPolygon", "coordinates": [[[[-118.67646, 34.03707], [-118.67629, 34.03715], [-118.67638, 34.03729], [-118.67622, 34.03728], [-118.6754, 34.0376], [-118.67481, 34.0378], [-118.67474, 34.03767], [-118.67555, 34.03741], [-118.6763, 34.03706], [-118.67642, 34.03702], [-118.67646, 34.03707]]], [[[-118.68069, 34.03475], [-118.68034, 34.03486], [-118.67997, 34.03502], [-118.67962, 34.0352], [-118.6793, 34.03539], [-118.67884, 34.03574], [-118.67771, 34.0367], [-118.67744, 34.03647], [-118.67726, 34.03661], [-118.67677, 34.03691], [-118.67665, 34.03693], [-118.67654, 34.03698], [-118.67647, 34.03688], [-118.67663, 34.03681], [-118.67677, 34.03672], [-118.67699, 34.03656], [-118.67734, 34.03625], [-118.6779, 34.03553], [-118.67822, 34.03495], [-118.67858, 34.0341], [-118.67889, 34.03394], [-118.67915, 34.03376], [-118.67926, 34.03353], [-118.67958, 34.03389], [-118.67912, 34.03417], [-118.67883, 34.03473], [-118.67917, 34.03516], [-118.67947, 34.03501], [-118.67978, 34.03488], [-118.67983, 34.03492], [-118.6801, 34.03483], [-118.68027, 34.0348], [-118.68066, 34.03468], [-118.68069, 34.03475]]], [[[-118.68268, 34.03131], [-118.682, 34.03166], [-118.68189, 34.0319], [-118.68113, 34.03114], [-118.68152, 34.03111], [-118.68266, 34.03076], [-118.68268, 34.03131]]]]} | Open Access 1 | Malibu Lagoon State Beach | http://www.parks.ca.gov/?page_id=835 | 21710 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 9.808 | Malibu Lagoon SB | 1951 |
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 | |
93 | 93 | 92 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04258, 34.13198], [-118.04251, 34.13189], [-118.04241, 34.13199], [-118.04249, 34.13207], [-118.04258, 34.13198]]]} | Restricted Access 2 | Santa Anita Golf Course | 33023 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 130.966 | Santa Anita GC | ||
127 | 127 | 126 | {"type": "Polygon", "coordinates": [[[-118.29278, 34.22166], [-118.2774, 34.22176], [-118.27738, 34.21871], [-118.2773, 34.21531], [-118.27833, 34.21531], [-118.27835, 34.21456], [-118.28057, 34.21456], [-118.28668, 34.2146], [-118.29156, 34.2202], [-118.29278, 34.22166]], [[-118.28164, 34.21534], [-118.28164, 34.21531], [-118.28095, 34.21457], [-118.27956, 34.21495], [-118.27872, 34.21549], [-118.27971, 34.21654], [-118.28164, 34.21534]]]} | Open Access 1 | Henderson Canyon Open Space | 19812 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 214.089 | Henderson Canyon OS | ||
138 | 138 | 137 | {"type": "Polygon", "coordinates": [[[-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.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.63493, 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], [-118.63703, 34.45246]]]} | Open Access 1 | Hasley Canyon Equestrian Park | http://parks.lacounty.gov/hasley-canyon-equestrian-park/ | 31829 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 4.749 | Hasley Canyon Equestrian Park | |
145 | 145 | 144 | {"type": "Polygon", "coordinates": [[[-118.32848, 33.72943], [-118.32671, 33.73239], [-118.32526, 33.73476], [-118.31854, 33.73477], [-118.31852, 33.73479], [-118.31769, 33.73479], [-118.31759, 33.73502], [-118.31794, 33.73542], [-118.31779, 33.7355], [-118.31769, 33.73519], [-118.31743, 33.73524], [-118.31733, 33.73494], [-118.31728, 33.73465], [-118.31685, 33.73415], [-118.3168, 33.73389], [-118.31671, 33.7336], [-118.31656, 33.73327], [-118.31645, 33.73309], [-118.31625, 33.73283], [-118.31524, 33.73163], [-118.31697, 33.73061], [-118.3163, 33.72979], [-118.3163, 33.72938], [-118.31855, 33.72939], [-118.31854, 33.73106], [-118.31856, 33.73198], [-118.31984, 33.73199], [-118.31986, 33.73185], [-118.31991, 33.7317], [-118.31997, 33.73159], [-118.32008, 33.73147], [-118.32022, 33.73136], [-118.3203, 33.73132], [-118.3208, 33.73113], [-118.32094, 33.73103], [-118.32102, 33.73089], [-118.32101, 33.7294], [-118.32848, 33.72943]]]} | Open Access 1 | Deane Dana Friendship Natural Area | http://parks.lacounty.gov/deane-dana-friendship-natural-area/ | 31836 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 129.634 | Deane Dana Friendship Natural Area | |
516 | 516 | 515 | {"type": "Polygon", "coordinates": [[[-118.52638, 34.34108], [-118.52584, 34.34096], [-118.52536, 34.34088], [-118.52304, 34.34055], [-118.52197, 34.34042], [-118.52208, 34.33992], [-118.523, 34.33996], [-118.5235, 34.33945], [-118.52521, 34.3407], [-118.52551, 34.34042], [-118.52601, 34.34081], [-118.5261, 34.34068], [-118.52638, 34.34073], [-118.52638, 34.34108]]]} | Open Access 1 | Michael D Antonovich Open Space | http://www.lamountains.com/parks.asp?parkid=8 | 6049 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 6.271 | Michael D Antonovich OS | |
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 | ||
651 | 651 | 650 | {"type": "Polygon", "coordinates": [[[-118.46707, 34.3301], [-118.46689, 34.33699], [-118.44933, 34.3374], [-118.44942, 34.32994], [-118.46482, 34.33008], [-118.46481, 34.33011], [-118.46429, 34.3302], [-118.46422, 34.33041], [-118.46386, 34.33059], [-118.46412, 34.33168], [-118.46384, 34.33173], [-118.46383, 34.33175], [-118.46393, 34.33219], [-118.46417, 34.33245], [-118.46391, 34.3328], [-118.46431, 34.33309], [-118.46458, 34.33243], [-118.46458, 34.332], [-118.46516, 34.33138], [-118.46517, 34.33076], [-118.46563, 34.33072], [-118.46564, 34.33048], [-118.46525, 34.33044], [-118.46531, 34.33009], [-118.46707, 34.3301]]]} | Open Access 1 | Rim of the Valley County Parkland | 6072 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 311.913 | Rim of the Valley County Parkland | ||
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-118.21741, 34.23745], [-118.21722, 34.24452], [-118.21284, 34.2442], [-118.21294, 34.24101], [-118.21292, 34.241], [-118.20853, 34.24092], [-118.20841, 34.24387], [-118.20398, 34.24355], [-118.20426, 34.23723], [-118.20431, 34.23366], [-118.2065, 34.23369], [-118.2083, 34.23106], [-118.20982, 34.22811], [-118.21083, 34.22869], [-118.21091, 34.22868], [-118.21098, 34.22864], [-118.21133, 34.22834], [-118.21139, 34.22827], [-118.21146, 34.22812], [-118.21187, 34.22837], [-118.21208, 34.22824], [-118.21233, 34.22814], [-118.21242, 34.22809], [-118.21258, 34.22789], [-118.21276, 34.22776], [-118.2129, 34.22771], [-118.21311, 34.22768], [-118.21319, 34.22762], [-118.21328, 34.22765], [-118.21332, 34.22758], [-118.21332, 34.22747], [-118.21328, 34.2274], [-118.21321, 34.22733], [-118.21319, 34.22729], [-118.21321, 34.22707], [-118.21362, 34.22719], [-118.21387, 34.22687], [-118.21432, 34.22655], [-118.21681, 34.22656], [-118.21613, 34.22701], [-118.21663, 34.22744], [-118.21527, 34.22884], [-118.21313, 34.23019], [-118.2131, 34.23379], [-118.21162, 34.23378], [-118.21159, 34.23733], [-118.21741, 34.23745]]]} | Open Access 1 | Winery Canyon Open Space | 6117 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 343.012 | Winery Canyon OS | ||
665 | 665 | 664 | {"type": "Polygon", "coordinates": [[[-118.44648, 33.97594], [-118.44644, 33.97736], [-118.44573, 33.9777], [-118.44549, 33.97734], [-118.44394, 33.97806], [-118.44347, 33.97739], [-118.44648, 33.97594]]]} | Open Access 1 | Burton W. Chace Park | http://www.chacepark.com/index.htm | 16535 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 7.377 | Burton W. Chace 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 | ||
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 | ||
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 | |
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 | ||
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 |
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]);