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
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
3924 | 3924 | 3923 | {"type": "Polygon", "coordinates": [[[-118.42983, 33.91628], [-118.4284, 33.91628], [-118.4259, 33.91134], [-118.42605, 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.91175], [-118.42983, 33.91628]]]} | Open Access 1 | El Segundo Beach | 18539 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 27.601 | El Segundo Beach | ||
4041 | 4041 | 4040 | {"type": "Polygon", "coordinates": [[[-118.25872, 33.91281], [-118.25871, 33.91462], [-118.25659, 33.91463], [-118.25655, 33.9146], [-118.25654, 33.91456], [-118.25654, 33.91282], [-118.25872, 33.91281]]]} | Open Access 1 | Enterprise Park | 18685 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 9.987 | Enterprise Park | ||
4053 | 4053 | 4052 | {"type": "Polygon", "coordinates": [[[-118.78814, 34.01865], [-118.7881, 34.01912], [-118.78785, 34.01951], [-118.78753, 34.01984], [-118.78591, 34.02079], [-118.78483, 34.02128], [-118.78461, 34.02141], [-118.78379, 34.02177], [-118.78296, 34.02206], [-118.78252, 34.02224], [-118.7821, 34.02236], [-118.78205, 34.02231], [-118.78188, 34.02237], [-118.78182, 34.02243], [-118.78146, 34.02251], [-118.78103, 34.02265], [-118.7807, 34.02267], [-118.77956, 34.02287], [-118.77921, 34.02296], [-118.77874, 34.02305], [-118.77808, 34.0231], [-118.77791, 34.02314], [-118.77752, 34.02319], [-118.77673, 34.02342], [-118.77616, 34.02353], [-118.77593, 34.02364], [-118.77481, 34.02384], [-118.77368, 34.02413], [-118.77248, 34.02437], [-118.77115, 34.02452], [-118.77058, 34.02462], [-118.77031, 34.02457], [-118.76986, 34.02458], [-118.76947, 34.02469], [-118.76932, 34.02479], [-118.76842, 34.02498], [-118.76834, 34.02478], [-118.7686, 34.02479], [-118.76883, 34.02473], [-118.76915, 34.02468], [-118.76961, 34.02456], [-118.76982, 34.02448], [-118.77072, 34.02438], [-118.77175, 34.02418], [-118.77267, 34.02409], [-118.77303, 34.02395], [-118.77336, 34.02393], [-118.77428, 34.02373], [-118.77462, 34.02364], [-118.77484, 34.02355], [-118.77549, 34.02337], [-118.776, 34.02327], [-118.77624, 34.02315], [-118.77663, 34.0231], [-118.77688, 34.02312], [-118.77714, 34.02309], [-118.77772, 34.02293], [-118.77799, 34.02289], [-118.77833, 34.02289], [-118.77869, 34.02284], [-118.77917, 34.02274], [-118.77965, 34.02263], [-118.7799, 34.02255], [-118.78021, 34.02252], [-118.78076, 34.02239], [-118.78149, 34.0223], [-118.78173, 34.02224], [-118.78193, 34.02214], [-118.78204, 34.02211], [-118.78238, 34.02198], [-118.78266, 34.0219], [-118.78271, 34.02185], [-118.78317, 34.02177], [-118.78364, 34.02162], [-118.78375, 34.02155], [-118.78394, 34.02146], [-118.78404, 34.02145], [-118.78425, 34.02134], [-118.78432, 34.02128], [-118.78456, 34.0212], [-118.78487, 34.02104], [-118.7859, 34.02061], [-118.78626, 34.0203], [-118.78585, 34.0199], [-118.78593, 34.01982], [-118.78616, 34.02004], [-118.78615, 34.02008], [-118.78631, 34.02022], [-118.78671, 34.01992], [-118.78709, 34.01966], [-118.78719, 34.01957], [-118.78733, 34.01936], [-118.78756, 34.01913], [-118.78775, 34.01869], [-118.7878, 34.01825], [-118.78814, 34.01865]]]} | Open Access 1 | Escondido Beach | 18702 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 13.665 | Escondido Beach | ||
4103 | 4103 | 4102 | {"type": "Polygon", "coordinates": [[[-117.96673, 34.52821], [-117.9667, 34.52825], [-117.96665, 34.52827], [-117.96573, 34.52827], [-117.96572, 34.52596], [-117.96673, 34.52596], [-117.96673, 34.52821]]]} | Open Access 1 | Everett Martin Park | 18762 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.821 | Everett Martin Park | ||
4178 | 4178 | 4177 | {"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.13299, 34.20069], [-118.13453, 34.20119], [-118.13505, 34.20048], [-118.13552, 34.20063]]]} | Open Access 1 | Farnsworth Park | 18847 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 14.791 | Farnsworth Park | ||
4545 | 4545 | 4544 | {"type": "Polygon", "coordinates": [[[-118.22958, 34.6528], [-118.22758, 34.6528], [-118.22752, 34.65275], [-118.22746, 34.65017], [-118.22952, 34.65016], [-118.22958, 34.6528]]]} | Open Access 1 | George Lane Park | 19270 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 13.664 | George Lane Park | ||
4669 | 4669 | 4668 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | Goose Egg Park | 19406 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.674 | Goose Egg Park | ||
4956 | 4956 | 4955 | {"type": "Polygon", "coordinates": [[[-118.62106, 34.45164], [-118.62107, 34.45184], [-118.62102, 34.45201], [-118.62091, 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.45258], [-118.61893, 34.45157], [-118.61917, 34.45156], [-118.61924, 34.45151], [-118.61933, 34.45154], [-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 | Hasley Canyon Park | 19731 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.364 | Hasley Canyon 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]);