superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where ACCESS_TYP = 1 and MNG_AGENCY = 16 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency 129
MNG_AGENCY 1
- Los Angeles, County of · 129 ✖
ACCESS_TYP 1
- Open Access · 129 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2111 | 2111 | 2110 | {"type": "Polygon", "coordinates": [[[-118.3351, 33.89621], [-118.33509, 33.89639], [-118.33509, 33.89752], [-118.33391, 33.89739], [-118.33392, 33.89724], [-118.33319, 33.89717], [-118.33315, 33.89718], [-118.33305, 33.89734], [-118.33158, 33.89734], [-118.33196, 33.89699], [-118.33221, 33.89672], [-118.33335, 33.89514], [-118.33409, 33.89545], [-118.33411, 33.89592], [-118.33482, 33.89592], [-118.33483, 33.8962], [-118.3351, 33.89621]]]} | Open Access 1 | Bodger Park | 16222 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 11.874 | Bodger Park | ||
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 | |
12032 | 12032 | 12031 | {"type": "Polygon", "coordinates": [[[-118.65458, 34.1035], [-118.65456, 34.11081], [-118.64569, 34.11083], [-118.64567, 34.10718], [-118.65025, 34.10717], [-118.65024, 34.10352], [-118.65458, 34.1035]]]} | Open Access 1 | Calabasas Peak | 28924 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 121.916 | Calabasas Peak | ||
14773 | 14773 | 14772 | {"type": "Polygon", "coordinates": [[[-118.60408, 34.12532], [-118.60355, 34.12532], [-118.60343, 34.12511], [-118.60323, 34.12504], [-118.60322, 34.12533], [-118.60305, 34.12533], [-118.60304, 34.12497], [-118.60288, 34.12491], [-118.6019, 34.12492], [-118.6019, 34.12487], [-118.60222, 34.12486], [-118.60221, 34.12436], [-118.60228, 34.12438], [-118.6023, 34.12486], [-118.60291, 34.12486], [-118.60349, 34.12507], [-118.6036, 34.12527], [-118.60408, 34.12526], [-118.60408, 34.12532]]]} | Open Access 1 | Canyon Oaks Open Space Access | 16820 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.586 | Canyon Oaks OS Access | ||
2621 | 2621 | 2620 | {"type": "Polygon", "coordinates": [[[-118.67635, 34.03704], [-118.67555, 34.03741], [-118.67476, 34.03766], [-118.67481, 34.0378], [-118.67421, 34.03796], [-118.6731, 34.03833], [-118.67205, 34.03848], [-118.67185, 34.03853], [-118.67144, 34.03857], [-118.67137, 34.03871], [-118.67127, 34.03874], [-118.67122, 34.03872], [-118.67085, 34.03876], [-118.67075, 34.03884], [-118.67039, 34.03885], [-118.67035, 34.03875], [-118.67001, 34.03876], [-118.66988, 34.0388], [-118.66945, 34.03884], [-118.66921, 34.03881], [-118.6684, 34.03883], [-118.6682, 34.03886], [-118.66739, 34.03893], [-118.66734, 34.03909], [-118.66661, 34.03908], [-118.66654, 34.03896], [-118.66626, 34.03895], [-118.66409, 34.03909], [-118.66362, 34.03906], [-118.66324, 34.03906], [-118.66221, 34.03901], [-118.66136, 34.0389], [-118.66047, 34.03885], [-118.65997, 34.03878], [-118.65982, 34.03885], [-118.65873, 34.03879], [-118.65846, 34.03872], [-118.65774, 34.03872], [-118.65759, 34.03868], [-118.65617, 34.03852], [-118.65475, 34.03841], [-118.65425, 34.03831], [-118.65375, 34.03826], [-118.65313, 34.03815], [-118.65102, 34.03789], [-118.65109, 34.03761], [-118.65227, 34.03777], [-118.65334, 34.03795], [-118.65496, 34.03819], [-118.6568, 34.03837], [-118.65812, 34.03841], [-118.66, 34.03853], [-118.66038, 34.03854], [-118.66107, 34.0386], [-118.66209, 34.03864], [-118.66379, 34.03879], [-118.66522, 34.03882], [-118.66588, 34.0388], [-118.66629, 34.03876], [-118.6677, 34.03876], [-118.66784, 34.03874], [-118.66832, 34.03874], [-118.66862, 34.03868], [-118.66976, 34.03857], [-118.67077, 34.03849], [-118.671, 34.03853], [-118.67124, 34.0385], [-118.67166, 34.03846], [-118.67249, 34.03825], [-118.67326, 34.03808], [-118.67344, 34.03795], [-118.6741, 34.03774], [-118.67483, 34.03754], [-118.67571, 34.03725], [-118.67629, 34.03695], [-118.67635, 34.03704]]]} | Open Access 1 | Carbon Beach | http://www.coastal.ca.gov/access/Carbon_Beach_Access.pdf | 16843 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.413 | Carbon Beach | |
2626 | 2626 | 2625 | {"type": "MultiPolygon", "coordinates": [[[[-117.70252, 34.62762], [-117.70249, 34.63864], [-117.69592, 34.63871], [-117.69593, 34.63688], [-117.69482, 34.63688], [-117.69483, 34.63504], [-117.69374, 34.63504], [-117.69369, 34.63873], [-117.69146, 34.63875], [-117.69147, 34.63693], [-117.69137, 34.63691], [-117.69036, 34.63692], [-117.69035, 34.63876], [-117.68478, 34.63881], [-117.68481, 34.63143], [-117.68927, 34.63139], [-117.68928, 34.62771], [-117.69374, 34.62767], [-117.69376, 34.624], [-117.69823, 34.62397], [-117.69822, 34.62764], [-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 | Carl O. Gerhardy Wildlife Sanctuary | http://parks.lacounty.gov/wps/portal/dpr/Parks/Carl_O_Gerhardy_Wildlife_Sanctuary | 16854 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 552.415 | Carl O. Gerhardy Wildlife Sanctuary | |
2684 | 2684 | 2683 | {"type": "Polygon", "coordinates": [[[-118.61656, 34.48907], [-118.6132, 34.48908], [-118.61156, 34.48447], [-118.61157, 34.48188], [-118.61216, 34.48188], [-118.61218, 34.48184], [-118.61371, 34.48184], [-118.61372, 34.4819], [-118.61391, 34.48191], [-118.61407, 34.48241], [-118.61404, 34.48242], [-118.61406, 34.48249], [-118.61412, 34.48252], [-118.61473, 34.48408], [-118.6155, 34.48581], [-118.61579, 34.48675], [-118.61601, 34.4873], [-118.61656, 34.48907]]]} | Open Access 1 | Castaic Sports Complex | 16946 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 58.014 | Castaic Sports Complex | ||
2852 | 2852 | 2851 | {"type": "Polygon", "coordinates": [[[-118.1536, 34.18804], [-118.1534, 34.18861], [-118.15355, 34.18868], [-118.15335, 34.18924], [-118.15158, 34.18867], [-118.15198, 34.18752], [-118.1536, 34.18804]]]} | Open Access 1 | Charles White Park | 17143 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.476 | Charles White Park | ||
2859 | 2859 | 2858 | {"type": "Polygon", "coordinates": [[[-117.85944, 34.10168], [-117.85727, 34.10168], [-117.85726, 34.09953], [-117.85944, 34.09953], [-117.85944, 34.10168]]]} | Open Access 1 | Charter Oak Park | 17151 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 11.813 | Charter Oak Park | ||
2996 | 2996 | 2995 | {"type": "Polygon", "coordinates": [[[-118.17981, 34.04781], [-118.1799, 34.04804], [-118.17993, 34.04818], [-118.17993, 34.04836], [-118.17989, 34.04857], [-118.17979, 34.0488], [-118.17912, 34.0497], [-118.17896, 34.05001], [-118.17886, 34.05039], [-118.17888, 34.05063], [-118.17891, 34.05082], [-118.17896, 34.05097], [-118.17895, 34.05099], [-118.17799, 34.05084], [-118.17797, 34.05082], [-118.17796, 34.05075], [-118.1774, 34.05068], [-118.17742, 34.05053], [-118.1771, 34.05045], [-118.17716, 34.05027], [-118.17718, 34.05026], [-118.17724, 34.05003], [-118.17736, 34.04927], [-118.17741, 34.0491], [-118.17757, 34.04802], [-118.17755, 34.0479], [-118.17755, 34.04782], [-118.17981, 34.04781]]]} | Open Access 1 | City Terrace Park | 17347 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.438 | City Terrace Park | ||
11912 | 11912 | 11911 | {"type": "Polygon", "coordinates": [[[-118.66774, 34.09258], [-118.6677, 34.09531], [-118.66548, 34.0953], [-118.66549, 34.09463], [-118.66547, 34.09257], [-118.66774, 34.09258]]]} | Open Access 1 | Cold Creek Canyon | 29017 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.437 | Cold Creek Canyon | ||
3078 | 3078 | 3077 | {"type": "Polygon", "coordinates": [[[-118.24421, 33.95332], [-118.24419, 33.9549], [-118.24417, 33.96001], [-118.24345, 33.96001], [-118.24343, 33.95332], [-118.24421, 33.95332]]]} | Open Access 1 | Colonel Leon H. Washington Park | 17527 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 12.641 | Colonel Leon H. Washington Park | ||
12027 | 12027 | 12026 | {"type": "Polygon", "coordinates": [[[-118.25293, 33.92759], [-118.25261, 33.92765], [-118.25157, 33.92387], [-118.2519, 33.92387], [-118.25293, 33.92759]]]} | Open Access 1 | Compton Creek Walking Path Phase I | 28915 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 3.18 | Compton Creek Walking Path Phase I | ||
3244 | 3244 | 3243 | {"type": "Polygon", "coordinates": [[[-117.94269, 33.98979], [-117.94266, 33.98982], [-117.94246, 33.98992], [-117.94188, 33.99014], [-117.94156, 33.99032], [-117.94153, 33.99032], [-117.94034, 33.98943], [-117.94033, 33.9894], [-117.94086, 33.98881], [-117.94096, 33.98872], [-117.94106, 33.98865], [-117.94124, 33.98858], [-117.94141, 33.98854], [-117.94195, 33.98854], [-117.94201, 33.98858], [-117.94205, 33.98887], [-117.94209, 33.98901], [-117.94217, 33.98917], [-117.94231, 33.98937], [-117.94267, 33.98974], [-117.94269, 33.98979]]]} | Open Access 1 | Countrywood Park | 17710 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 6.208 | Countrywood Park | ||
3410 | 3410 | 3409 | {"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 | Dalton Park | 17899 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.244 | Dalton Park | ||
12103 | 12103 | 12102 | {"type": "MultiPolygon", "coordinates": [[[[-118.74516, 34.03243], [-118.74451, 34.03256], [-118.7437, 34.03276], [-118.74363, 34.03247], [-118.74326, 34.03252], [-118.74258, 34.03265], [-118.74255, 34.03267], [-118.74252, 34.03255], [-118.74363, 34.03237], [-118.74383, 34.03239], [-118.74398, 34.03236], [-118.74411, 34.03236], [-118.74439, 34.03233], [-118.74456, 34.03227], [-118.74478, 34.03225], [-118.74489, 34.03221], [-118.74505, 34.03211], [-118.74516, 34.03243]]], [[[-118.75347, 34.03026], [-118.75273, 34.03045], [-118.7523, 34.02969], [-118.75136, 34.03005], [-118.75093, 34.03031], [-118.75043, 34.03051], [-118.75011, 34.03072], [-118.75021, 34.03095], [-118.74969, 34.03114], [-118.74905, 34.03133], [-118.74901, 34.03128], [-118.74828, 34.03146], [-118.74787, 34.0316], [-118.74748, 34.03179], [-118.7454, 34.03237], [-118.74528, 34.03208], [-118.74621, 34.03183], [-118.74743, 34.0316], [-118.74838, 34.03126], [-118.74871, 34.03119], [-118.74894, 34.03111], [-118.74962, 34.03078], [-118.75005, 34.03061], [-118.75042, 34.03034], [-118.75081, 34.03016], [-118.75116, 34.02994], [-118.75137, 34.02984], [-118.75223, 34.02955], [-118.75259, 34.02936], [-118.75276, 34.02925], [-118.75347, 34.03026]]]]} | Open Access 1 | Dan Blocker Beach | http://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/dan+blocker+beach+detail | 29044 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 7.51 | Dan Blocker Beach | |
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 | |
12207 | 12207 | 12206 | {"type": "Polygon", "coordinates": [[[-117.86356, 34.41191], [-117.85922, 34.41198], [-117.8592, 34.41731], [-117.86116, 34.41727], [-117.86127, 34.41885], [-117.86348, 34.41886], [-117.86349, 34.42457], [-117.85264, 34.42458], [-117.85248, 34.41725], [-117.84376, 34.41711], [-117.84379, 34.41355], [-117.83502, 34.41335], [-117.83534, 34.39918], [-117.83541, 34.3956], [-117.85252, 34.39557], [-117.85268, 34.40743], [-117.85845, 34.4074], [-117.85845, 34.41018], [-117.86356, 34.41013], [-117.86356, 34.41191]]]} | Open Access 1 | Devil's Punchbowl Natural Area | http://parks.lacounty.gov/wps/portal/dpr/Parks/Devils_Punchbowl_Natural_Area | 29185 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1236.046 | Devil's Punchbowl Natural Area | |
3596 | 3596 | 3595 | {"type": "Polygon", "coordinates": [[[-118.37617, 34.29334], [-118.37616, 34.29567], [-118.37541, 34.29567], [-118.37534, 34.29593], [-118.37525, 34.2961], [-118.37538, 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 | Dexter Park | 18130 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 39.615 | Dexter Park | ||
3703 | 3703 | 3702 | {"type": "Polygon", "coordinates": [[[-118.59449, 34.38981], [-118.59364, 34.39261], [-118.59278, 34.39316], [-118.59237, 34.3929], [-118.59257, 34.39227], [-118.59257, 34.39208], [-118.59252, 34.39196], [-118.59248, 34.39189], [-118.59237, 34.39176], [-118.59216, 34.39164], [-118.59196, 34.39158], [-118.59172, 34.39159], [-118.59163, 34.39135], [-118.5923, 34.39114], [-118.59237, 34.39108], [-118.59238, 34.39105], [-118.5924, 34.391], [-118.59236, 34.39069], [-118.59236, 34.39041], [-118.59258, 34.38943], [-118.59258, 34.38913], [-118.59254, 34.38875], [-118.59255, 34.3887], [-118.59261, 34.38864], [-118.59272, 34.38863], [-118.59294, 34.3887], [-118.59314, 34.3888], [-118.59331, 34.38891], [-118.59351, 34.38906], [-118.5938, 34.38934], [-118.59397, 34.38947], [-118.59405, 34.38942], [-118.59419, 34.38956], [-118.59449, 34.38981]]]} | Open Access 1 | Dr. Richard H Rioux Memorial Park | 18267 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 16.663 | Dr. Richard H Rioux Memorial 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]);