superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
171 rows where AGNCY_WEB = "http://parks.lacounty.gov" and MNG_AG_LEV = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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]);