superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
171 rows where MNG_AGENCY = 16 and MNG_AG_TYP = 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2986 | 2986 | 2985 | {"type": "MultiPolygon", "coordinates": [[[[-118.15498, 33.83254], [-118.15491, 33.83579], [-118.15381, 33.83579], [-118.15367, 33.83568], [-118.15367, 33.83541], [-118.15337, 33.8354], [-118.15335, 33.83567], [-118.15358, 33.83568], [-118.15378, 33.83584], [-118.15123, 33.83585], [-118.15123, 33.83649], [-118.15303, 33.83854], [-118.15303, 33.83964], [-118.14813, 33.83963], [-118.14827, 33.83948], [-118.14837, 33.83933], [-118.14842, 33.83919], [-118.1485, 33.83886], [-118.15013, 33.83865], [-118.15122, 33.83874], [-118.15122, 33.8381], [-118.1496, 33.83658], [-118.14871, 33.83658], [-118.14677, 33.83715], [-118.14798, 33.83892], [-118.14829, 33.83889], [-118.14823, 33.83915], [-118.14819, 33.83926], [-118.14811, 33.83939], [-118.14799, 33.83951], [-118.14782, 33.83963], [-118.14742, 33.83963], [-118.14397, 33.83644], [-118.14405, 33.83636], [-118.14424, 33.83638], [-118.14429, 33.83617], [-118.14441, 33.83597], [-118.1462, 33.83409], [-118.14639, 33.83392], [-118.14756, 33.833], [-118.14768, 33.83283], [-118.14773, 33.8327], [-118.14775, 33.83255], [-118.14781, 33.83251], [-118.15469, 33.83253], [-118.15471, 33.83254], [-118.15498, 33.83254]]], [[[-118.15984, 33.8286], [-118.15959, 33.8286], [-118.15661, 33.83004], [-118.15469, 33.83035], [-118.15293, 33.83225], [-118.15, 33.83223], [-118.15104, 33.82949], [-118.15192, 33.82897], [-118.1541, 33.82897], [-118.15411, 33.82768], [-118.15982, 33.82769], [-118.15984, 33.8286]]]]} | Restricted Access 2 | Lakewood Golf Course | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Lakewood_Golf_Course | 33113 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 176.379 | Lakewood GC | |
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 | ||
3347 | 3347 | 3346 | {"type": "Polygon", "coordinates": [[[-117.78685, 34.08806], [-117.78682, 34.08835], [-117.78544, 34.08847], [-117.78504, 34.08833], [-117.78493, 34.08852], [-117.78422, 34.08859], [-117.78404, 34.08903], [-117.78042, 34.08809], [-117.78037, 34.08814], [-117.77867, 34.08717], [-117.77694, 34.08624], [-117.77697, 34.0862], [-117.77697, 34.08618], [-117.77522, 34.08526], [-117.77486, 34.08403], [-117.77477, 34.08386], [-117.77462, 34.08372], [-117.77291, 34.08262], [-117.77288, 34.08258], [-117.77288, 34.08254], [-117.77303, 34.08229], [-117.77324, 34.08205], [-117.77352, 34.08184], [-117.77384, 34.08168], [-117.77419, 34.08158], [-117.77414, 34.08161], [-117.77559, 34.08135], [-117.77669, 34.08111], [-117.77718, 34.08098], [-117.77767, 34.08079], [-117.77822, 34.08051], [-117.77878, 34.08014], [-117.77903, 34.07993], [-117.77937, 34.07959], [-117.77961, 34.07928], [-117.77973, 34.07925], [-117.7799, 34.07934], [-117.78382, 34.08108], [-117.78098, 34.08373], [-117.78203, 34.08538], [-117.78408, 34.0849], [-117.78541, 34.08509], [-117.78685, 34.08806]]]} | Restricted Access 2 | Mountain Meadows Golf Course | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Mountain_Meadows_Golf_Course | 33118 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 165.229 | Mtn. Meadows GC | |
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 | ||
4987 | 4987 | 4986 | {"type": "Polygon", "coordinates": [[[-118.60043, 34.03928], [-118.59866, 34.03936], [-118.59704, 34.03949], [-118.59696, 34.03894], [-118.59729, 34.03892], [-118.59789, 34.03909], [-118.59841, 34.03915], [-118.59889, 34.03908], [-118.59909, 34.03891], [-118.60041, 34.039], [-118.60043, 34.03928]]]} | Open Access 1 | Las Tunas County Beach | 21070 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 3.145 | Las Tunas County Beach | ||
5014 | 5014 | 5013 | {"type": "Polygon", "coordinates": [[[-118.29344, 33.91692], [-118.29343, 33.91878], [-118.29194, 33.91879], [-118.29196, 33.91698], [-118.29226, 33.91697], [-118.29228, 33.91692], [-118.29344, 33.91692]]]} | Open Access 1 | Helen Keller Park | 19797 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 6.993 | Helen Keller 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]);