superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2173 | 2173 | 2172 | {"type": "MultiPolygon", "coordinates": [[[[-118.12869, 33.78809], [-118.12814, 33.78802], [-118.12762, 33.788], [-118.12762, 33.78783], [-118.12856, 33.78792], [-118.12866, 33.78798], [-118.12869, 33.78809]]], [[[-118.12949, 33.78801], [-118.12946, 33.78827], [-118.12881, 33.78811], [-118.12876, 33.78794], [-118.12949, 33.78801]]]]} | Open Access 1 | Bouton Creek Park | 16303 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.769 | Bouton Creek Park | ||
11923 | 11923 | 11922 | {"type": "Polygon", "coordinates": [[[-118.19523, 33.85437], [-118.19505, 33.85468], [-118.19468, 33.85468], [-118.19486, 33.85437], [-118.19523, 33.85437]]]} | Open Access 1 | Burton W. Chace Park | 28711 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.286 | Burton W. Chace Park | ||
14047 | 14047 | 14046 | {"type": "Polygon", "coordinates": [[[-118.20162, 33.84535], [-118.20155, 33.84639], [-118.20035, 33.8464], [-118.20034, 33.84535], [-118.20162, 33.84535]]]} | Open Access 1 | C. David Molina Park | 32623 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.292 | C. David Molina Park | ||
2664 | 2664 | 2663 | {"type": "MultiPolygon", "coordinates": [[[[-118.1632, 33.76891], [-118.16311, 33.76896], [-118.16311, 33.76887], [-118.16315, 33.76889], [-118.1632, 33.76891]]], [[[-118.16334, 33.77076], [-118.16323, 33.77082], [-118.16314, 33.7709], [-118.16315, 33.77079], [-118.16313, 33.77068], [-118.16334, 33.77076]]], [[[-118.16428, 33.76891], [-118.16414, 33.769], [-118.16403, 33.76911], [-118.16392, 33.769], [-118.16378, 33.76891], [-118.16392, 33.76882], [-118.16403, 33.76871], [-118.16414, 33.76882], [-118.16428, 33.76891]]], [[[-118.16441, 33.77044], [-118.16441, 33.77044], [-118.16398, 33.77055], [-118.16404, 33.77047], [-118.16408, 33.77039], [-118.1641, 33.7703], [-118.1641, 33.7702], [-118.16423, 33.77032], [-118.16441, 33.77044]]]]} | Open Access 1 | Carroll Parks | 16919 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.426 | Carroll Parks | ||
2812 | 2812 | 2811 | {"type": "MultiPolygon", "coordinates": [[[[-118.20289, 33.77061], [-118.2028, 33.77063], [-118.2028, 33.77101], [-118.20239, 33.771], [-118.20239, 33.77061], [-118.20257, 33.7706], [-118.20258, 33.77058], [-118.20251, 33.77054], [-118.20225, 33.7705], [-118.20193, 33.7705], [-118.20193, 33.77027], [-118.2019, 33.77026], [-118.20191, 33.77014], [-118.20189, 33.7701], [-118.20183, 33.77008], [-118.20183, 33.76935], [-118.20193, 33.76935], [-118.20195, 33.7694], [-118.20233, 33.7694], [-118.20235, 33.76937], [-118.20278, 33.76942], [-118.20289, 33.77061]], [[-118.20226, 33.76983], [-118.20226, 33.76981], [-118.20194, 33.7698], [-118.20193, 33.76981], [-118.20226, 33.76983]]], [[[-118.20234, 33.77103], [-118.20234, 33.77152], [-118.20192, 33.77152], [-118.20193, 33.77103], [-118.20234, 33.77103]]], [[[-118.2028, 33.7728], [-118.20193, 33.77281], [-118.20192, 33.77254], [-118.20213, 33.77253], [-118.20246, 33.77258], [-118.20265, 33.77258], [-118.20279, 33.77256], [-118.2028, 33.7728]]], [[[-118.20234, 33.771], [-118.20193, 33.77101], [-118.20193, 33.7706], [-118.20226, 33.7706], [-118.20234, 33.77061], [-118.20234, 33.771]]], [[[-118.20234, 33.77347], [-118.20234, 33.77401], [-118.20193, 33.77402], [-118.20193, 33.77303], [-118.20234, 33.77303], [-118.20234, 33.77347]]], [[[-118.20306, 33.77226], [-118.20298, 33.77231], [-118.20278, 33.77239], [-118.20264, 33.77241], [-118.20245, 33.77241], [-118.2021, 33.77236], [-118.20193, 33.77238], [-118.20193, 33.77181], [-118.20222, 33.77181], [-118.20249, 33.77186], [-118.20259, 33.77186], [-118.20279, 33.7718], [-118.20305, 33.77165], [-118.20306, 33.77226]]], [[[-118.20234, 33.77166], [-118.20202, 33.77164], [-118.20196, 33.77163], [-118.20193, 33.77159], [-118.20234, 33.77159], [-118.20234, 33.77166]]], [[[-118.20281, 33.77399], [-118.20277, 33.77402], [-118.20239, 33.77401], [-118.20239, 33.7739], [-118.20238, 33.77303], [-118.20279, 33.77303], [-118.20281, 33.77399]]], [[[-118.2028, 33.77103], [-118.20278, 33.77158], [-118.20256, 33.77168], [-118.20239, 33.77167], [-118.20239, 33.77103], [-118.2028, 33.77103]]]]} | Open Access 1 | Cesar E. Chavez Park | 17104 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 9.084 | Cesar E. Chavez Park | ||
12741 | 12741 | 12740 | {"type": "MultiPolygon", "coordinates": [[[[-118.20232, 33.76745], [-118.20223, 33.76752], [-118.20217, 33.76759], [-118.20213, 33.76768], [-118.20212, 33.7678], [-118.20212, 33.76789], [-118.20216, 33.76799], [-118.20223, 33.7681], [-118.2023, 33.76819], [-118.20215, 33.7681], [-118.20201, 33.76792], [-118.20196, 33.76777], [-118.20196, 33.76749], [-118.20199, 33.76745], [-118.20232, 33.76745]]], [[[-118.20355, 33.7681], [-118.2035, 33.76819], [-118.20307, 33.7688], [-118.20299, 33.76894], [-118.2029, 33.76919], [-118.20289, 33.76932], [-118.20289, 33.76963], [-118.20287, 33.7694], [-118.20285, 33.76928], [-118.20272, 33.76894], [-118.2026, 33.76872], [-118.20243, 33.76849], [-118.20217, 33.76824], [-118.20211, 33.76816], [-118.20231, 33.76828], [-118.2025, 33.76835], [-118.20267, 33.76838], [-118.20289, 33.76839], [-118.20309, 33.76835], [-118.20328, 33.76828], [-118.20342, 33.76821], [-118.20355, 33.7681]]], [[[-118.20372, 33.76743], [-118.20369, 33.76769], [-118.20364, 33.76785], [-118.20357, 33.76796], [-118.20341, 33.76813], [-118.2033, 33.7682], [-118.20316, 33.76827], [-118.20298, 33.76831], [-118.20288, 33.76832], [-118.20272, 33.76831], [-118.20261, 33.76829], [-118.20251, 33.76825], [-118.20238, 33.76817], [-118.2023, 33.76809], [-118.20223, 33.76797], [-118.20219, 33.76783], [-118.2022, 33.7677], [-118.20227, 33.76758], [-118.20241, 33.76748], [-118.20257, 33.76745], [-118.20259, 33.76746], [-118.20293, 33.76745], [-118.20372, 33.76743]]], [[[-118.20277, 33.76928], [-118.20246, 33.7692], [-118.20256, 33.76906], [-118.2026, 33.7689], [-118.20271, 33.76908], [-118.20277, 33.76928]]], [[[-118.20398, 33.77217], [-118.20393, 33.77217], [-118.20381, 33.77206], [-118.20348, 33.77228], [-118.2032, 33.77242], [-118.20319, 33.77247], [-118.2031, 33.77247], [-118.20306, 33.77249], [-118.20305, 33.77135], [-118.20306, 33.77073], [-118.20305, 33.76945], [-118.20334, 33.76948], [-118.2036, 33.76957], [-118.2038, 33.76972], [-118.20389, 33.76984], [-118.20394, 33.76994], [-118.20397, 33.77013], [-118.20394, 33.77077], [-118.20398, 33.77125], [-118.20398, 33.77217]]], [[[-118.20408, 33.76943], [-118.20408, 33.76967], [-118.20406, 33.76999], [-118.20399, 33.7698], [-118.20394, 33.76973], [-118.20385, 33.76962], [-118.20371, 33.76952], [-118.20349, 33.76942], [-118.20305, 33.76934], [-118.20313, 33.76903], [-118.20328, 33.76879], [-118.2033, 33.7688], [-118.2033, 33.76894], [-118.20335, 33.76908], [-118.2034, 33.76916], [-118.2035, 33.76926], [-118.20363, 33.76934], [-118.20375, 33.76938], [-118.20388, 33.7694], [-118.20406, 33.76941], [-118.20408, 33.76943]]], [[[-118.20396, 33.77281], [-118.20389, 33.77304], [-118.20338, 33.77408], [-118.2033, 33.77437], [-118.20328, 33.77438], [-118.20327, 33.77471], [-118.20325, 33.77471], [-118.2031, 33.77343], [-118.20307, 33.77281], [-118.20396, 33.77281]]], [[[-118.20408, 33.76924], [-118.20405, 33.76929], [-118.20394, 33.7693], [-118.20379, 33.76928], [-118.20364, 33.76921], [-118.20355, 33.76914], [-118.20347, 33.76905], [-118.20341, 33.76887], [-118.20342, 33.76875], [-118.20346, 33.76863], [-118.20382, 33.76795], [-118.20391, 33.76765], [-118.20394, 33.76742], [-118.20402, 33.76742], [-118.20408, 33.76924]]]]} | Open Access 1 | Cesar E. Chavez Park Terminus | 29914 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 15.114 | Cesar E. Chavez Park Terminus | ||
2832 | 2832 | 2831 | {"type": "Polygon", "coordinates": [[[-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77171], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10418, 33.7718], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752]]]} | Open Access 1 | Channel View Park | 17123 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 5.302 | Channel View Park | 1968 | |
2870 | 2870 | 2869 | {"type": "Polygon", "coordinates": [[[-118.17036, 33.83866], [-118.16951, 33.84005], [-118.16951, 33.84054], [-118.16776, 33.84055], [-118.16775, 33.8387], [-118.16781, 33.83865], [-118.17036, 33.83866]]]} | Open Access 1 | Cherry Avenue Park | 17164 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 9.932 | Cherry Avenue Park | ||
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79346], [-118.17189, 33.79348]]]} | Open Access 1 | Chittick Field | 29942 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 19.456 | Chittick Field | 2014 | |
12758 | 12758 | 12757 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | Chittick Field | 29944 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.181 | Chittick Field | 2014 | |
3088 | 3088 | 3087 | {"type": "Polygon", "coordinates": [[[-118.09912, 33.77631], [-118.09911, 33.77677], [-118.09895, 33.77678], [-118.09833, 33.77779], [-118.09836, 33.7755], [-118.09894, 33.77631], [-118.09912, 33.77631]]]} | Open Access 1 | College Estates Park | 17500 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.301 | College Estates Park | ||
3115 | 3115 | 3114 | {"type": "Polygon", "coordinates": [[[-118.13709, 33.77176], [-118.13709, 33.77258], [-118.13666, 33.77253], [-118.13657, 33.77265], [-118.13644, 33.77273], [-118.13634, 33.77276], [-118.13623, 33.77276], [-118.13607, 33.77272], [-118.13593, 33.77262], [-118.13584, 33.77248], [-118.1358, 33.77229], [-118.13572, 33.7722], [-118.13564, 33.77215], [-118.13533, 33.77205], [-118.13513, 33.77205], [-118.13502, 33.77188], [-118.1331, 33.77163], [-118.13298, 33.77163], [-118.13291, 33.77166], [-118.13282, 33.77175], [-118.13277, 33.77185], [-118.13275, 33.77196], [-118.13276, 33.77223], [-118.13288, 33.77268], [-118.13291, 33.77341], [-118.13295, 33.77343], [-118.13295, 33.77351], [-118.13186, 33.77351], [-118.13186, 33.77178], [-118.13184, 33.77162], [-118.13177, 33.77161], [-118.13176, 33.77087], [-118.13132, 33.77085], [-118.13129, 33.77072], [-118.13078, 33.77072], [-118.13078, 33.76996], [-118.1341, 33.76996], [-118.13709, 33.77176]]]} | Open Access 1 | Colorado Lagoon Park | 17542 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 27.354 | Colorado Lagoon Park | ||
3174 | 3174 | 3173 | {"type": "Polygon", "coordinates": [[[-118.19536, 33.87403], [-118.19508, 33.874], [-118.19483, 33.87391], [-118.19478, 33.87373], [-118.19471, 33.87356], [-118.19449, 33.87322], [-118.19443, 33.87308], [-118.19439, 33.87291], [-118.19437, 33.87267], [-118.19437, 33.8726], [-118.19457, 33.87162], [-118.19472, 33.87105], [-118.19496, 33.8704], [-118.19529, 33.86975], [-118.19535, 33.86975], [-118.19534, 33.87241], [-118.19536, 33.87403]]]} | Open Access 1 | Coolidge Park | 17621 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.123 | Coolidge Park | ||
12742 | 12742 | 12741 | {"type": "Polygon", "coordinates": [[[-118.1174, 33.75277], [-118.11739, 33.75279], [-118.11726, 33.75277], [-118.11703, 33.7527], [-118.11686, 33.75264], [-118.11541, 33.75191], [-118.11518, 33.75192], [-118.11462, 33.75214], [-118.11459, 33.75211], [-118.11517, 33.75188], [-118.11542, 33.75187], [-118.11678, 33.75255], [-118.11739, 33.75274], [-118.1174, 33.75277]]]} | Open Access 1 | Corso di Oro Parkway | 29916 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.341 | Corso di Oro Parkway | ||
12049 | 12049 | 12048 | {"type": "Polygon", "coordinates": [[[-118.17739, 33.77764], [-118.17739, 33.77777], [-118.17643, 33.77777], [-118.17643, 33.77764], [-118.17739, 33.77764]]]} | Open Access 1 | Craftsman Village Park | http://www.craftsmanvillage.org/ | 28959 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.33 | Craftsman Village Park | |
12050 | 12050 | 12049 | {"type": "Polygon", "coordinates": [[[-118.20433, 33.79158], [-118.20409, 33.79158], [-118.20409, 33.79103], [-118.20419, 33.79101], [-118.20418, 33.7909], [-118.2041, 33.79089], [-118.2041, 33.79048], [-118.20433, 33.79048], [-118.20433, 33.79158]]]} | Open Access 1 | Cressa Park | 28960 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.616 | Cressa Park | ||
3404 | 3404 | 3403 | {"type": "MultiPolygon", "coordinates": [[[[-118.19943, 33.79521], [-118.19929, 33.79521], [-118.19927, 33.79361], [-118.19943, 33.79359], [-118.19943, 33.79521]]], [[[-118.19942, 33.79542], [-118.19941, 33.79702], [-118.19929, 33.79703], [-118.19927, 33.79542], [-118.19942, 33.79542]]], [[[-118.19944, 33.79178], [-118.19943, 33.79341], [-118.19928, 33.79342], [-118.1993, 33.79178], [-118.19944, 33.79178]]], [[[-118.19946, 33.79006], [-118.19943, 33.7916], [-118.19929, 33.7916], [-118.19931, 33.79007], [-118.19946, 33.79006]]]]} | Open Access 1 | Daisy Greenbelt | 17892 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.319 | Daisy Greenbelt | ||
11925 | 11925 | 11924 | {"type": "Polygon", "coordinates": [[[-118.15763, 33.85724], [-118.15761, 33.85726], [-118.15761, 33.85746], [-118.15552, 33.85747], [-118.15552, 33.85685], [-118.1555, 33.85684], [-118.15551, 33.85637], [-118.15762, 33.85637], [-118.15763, 33.85724]]]} | Open Access 1 | Davenport Park | 28713 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 5.858 | Davenport Park | ||
10485 | 10485 | 10484 | {"type": "Polygon", "coordinates": [[[-118.1198, 33.76062], [-118.11979, 33.76069], [-118.11975, 33.76074], [-118.11964, 33.7608], [-118.11701, 33.75838], [-118.11694, 33.75835], [-118.1168, 33.75835], [-118.11667, 33.7584], [-118.1165, 33.75853], [-118.1164, 33.75854], [-118.11633, 33.75852], [-118.11608, 33.75832], [-118.11531, 33.75762], [-118.11527, 33.75757], [-118.11514, 33.75749], [-118.11501, 33.75745], [-118.11529, 33.7574], [-118.11572, 33.75726], [-118.11599, 33.75708], [-118.11976, 33.76053], [-118.1198, 33.76062]]]} | Open Access 1 | Davies Launch Ramp | 28975 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6.062 | Davies Launch Ramp | ||
3519 | 3519 | 3518 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86062], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | DeForest Park | 18015 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 34.119 | DeForest Park | 2018 |
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]);