superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
135 rows where ACCESS_TYP = 1, MNG_AGENCY = 294 and MNG_AG_TYP = 2 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 135 ✖
MNG_AGENCY 1
- Long Beach, City of · 135 ✖
ACCESS_TYP 1
- Open Access · 135 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
735 | 735 | 734 | {"type": "MultiPolygon", "coordinates": [[[[-118.13185, 33.7681], [-118.13155, 33.76841], [-118.13116, 33.76817], [-118.13149, 33.76786], [-118.13185, 33.7681]]], [[[-118.13275, 33.76887], [-118.13275, 33.76923], [-118.1317, 33.76851], [-118.13201, 33.7682], [-118.13242, 33.76845], [-118.13275, 33.76887]]]]} | Open Access 1 | Will Rogers Mini Park | 27529 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.644 | Will Rogers MP | ||
814 | 814 | 813 | {"type": "Polygon", "coordinates": [[[-118.1834, 33.76411], [-118.18316, 33.76539], [-118.1831, 33.76539], [-118.18307, 33.76547], [-118.18236, 33.76542], [-118.18237, 33.76532], [-118.18187, 33.76524], [-118.18183, 33.76536], [-118.18164, 33.76534], [-118.18145, 33.76534], [-118.17698, 33.76475], [-118.1768, 33.76474], [-118.17179, 33.76407], [-118.1716, 33.76411], [-118.17089, 33.76396], [-118.16946, 33.76377], [-118.16945, 33.76376], [-118.16902, 33.7637], [-118.16918, 33.76281], [-118.16993, 33.76293], [-118.17053, 33.76303], [-118.17088, 33.76311], [-118.17134, 33.76324], [-118.17264, 33.76338], [-118.17411, 33.76338], [-118.17465, 33.76332], [-118.17525, 33.7633], [-118.17654, 33.76338], [-118.17721, 33.76338], [-118.17812, 33.76333], [-118.17907, 33.7632], [-118.17996, 33.76298], [-118.18051, 33.76266], [-118.181, 33.76231], [-118.18149, 33.76159], [-118.18316, 33.76335], [-118.18317, 33.76386], [-118.1834, 33.76411]]]} | Open Access 1 | Alamitos Beach | 15314 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 56.55 | Alamitos Beach | ||
817 | 817 | 816 | {"type": "Polygon", "coordinates": [[[-118.1171, 33.74531], [-118.11692, 33.74554], [-118.11665, 33.7454], [-118.11684, 33.74516], [-118.1171, 33.74531]]]} | Open Access 1 | Alamitos Park | 15315 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.225 | Alamitos Park | ||
1386 | 1386 | 1385 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 14th Street Park and Playground | 15173 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.66 | 14th Street Park and Playground | ||
1650 | 1650 | 1649 | {"type": "Polygon", "coordinates": [[[-118.18416, 33.84964], [-118.18416, 33.84977], [-118.1839, 33.84978], [-118.18368, 33.84995], [-118.18366, 33.85], [-118.18366, 33.85103], [-118.18368, 33.85107], [-118.18389, 33.85124], [-118.18415, 33.85125], [-118.18412, 33.8514], [-118.18406, 33.85154], [-118.18391, 33.85147], [-118.18377, 33.85139], [-118.18366, 33.85128], [-118.18358, 33.85119], [-118.18348, 33.85098], [-118.18344, 33.85061], [-118.18338, 33.85051], [-118.18271, 33.85006], [-118.18216, 33.84996], [-118.1804, 33.85003], [-118.18036, 33.85027], [-118.18017, 33.85029], [-118.18011, 33.85019], [-118.18008, 33.84977], [-118.17983, 33.84976], [-118.17975, 33.84957], [-118.17968, 33.84949], [-118.17974, 33.84942], [-118.17984, 33.84936], [-118.18021, 33.84922], [-118.18033, 33.84962], [-118.18037, 33.84983], [-118.18192, 33.84976], [-118.18192, 33.84935], [-118.18225, 33.84922], [-118.18204, 33.84878], [-118.18212, 33.84873], [-118.18233, 33.84879], [-118.18248, 33.84853], [-118.18292, 33.84865], [-118.18288, 33.84873], [-118.1827, 33.84886], [-118.18252, 33.84907], [-118.18305, 33.84956], [-118.18339, 33.84983], [-118.18349, 33.84986], [-118.18356, 33.84986], [-118.18363, 33.84983], [-118.18379, 33.8497], [-118.18388, 33.84966], [-118.18397, 33.84964], [-118.18416, 33.84964]]]} | Open Access 1 | Atlantic Plaza Park | 15675 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6.606 | Atlantic Plaza Park | ||
1942 | 1942 | 1941 | {"type": "Polygon", "coordinates": [[[-118.14525, 33.75697], [-118.14496, 33.75754], [-118.14479, 33.75793], [-118.14365, 33.75749], [-118.14336, 33.75801], [-118.13788, 33.7558], [-118.13804, 33.75551], [-118.13804, 33.75549], [-118.1379, 33.75545], [-118.13773, 33.75574], [-118.13625, 33.75515], [-118.13492, 33.75459], [-118.13352, 33.75392], [-118.13251, 33.75341], [-118.13274, 33.75309], [-118.13268, 33.75304], [-118.1339, 33.75143], [-118.13532, 33.75207], [-118.13542, 33.75215], [-118.13585, 33.75238], [-118.13652, 33.75266], [-118.13693, 33.75286], [-118.13741, 33.75313], [-118.13762, 33.75323], [-118.13934, 33.75415], [-118.14089, 33.75501], [-118.14093, 33.75504], [-118.14132, 33.75525], [-118.14136, 33.75528], [-118.14147, 33.75533], [-118.1415, 33.75538], [-118.14142, 33.75557], [-118.14525, 33.75697]]]} | Open Access 1 | Belmont Shore Beach | 15995 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 64.109 | Belmont Shore Beach | ||
2036 | 2036 | 2035 | {"type": "Polygon", "coordinates": [[[-118.18037, 33.84032], [-118.18037, 33.84033], [-118.17814, 33.84152], [-118.17816, 33.84104], [-118.17814, 33.8409], [-118.17808, 33.84071], [-118.17988, 33.83974], [-118.18009, 33.84], [-118.18012, 33.84], [-118.18037, 33.84032]]]} | Open Access 1 | Bixby Knolls Park | 16130 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.268 | Bixby Knolls Park | ||
2037 | 2037 | 2036 | {"type": "MultiPolygon", "coordinates": [[[[-118.16786, 33.76675], [-118.16779, 33.76716], [-118.16686, 33.76704], [-118.16596, 33.76685], [-118.16609, 33.76645], [-118.16696, 33.76664], [-118.16786, 33.76675]]], [[[-118.16806, 33.76568], [-118.1679, 33.76655], [-118.16701, 33.76644], [-118.16614, 33.76625], [-118.1664, 33.7654], [-118.16722, 33.76558], [-118.16806, 33.76568]]], [[[-118.16849, 33.76328], [-118.16831, 33.76434], [-118.16756, 33.76424], [-118.16632, 33.76398], [-118.16646, 33.76352], [-118.16629, 33.76346], [-118.16642, 33.76296], [-118.16849, 33.76328]]], [[[-118.16827, 33.76461], [-118.1681, 33.76548], [-118.16727, 33.76538], [-118.16646, 33.7652], [-118.16671, 33.76434], [-118.16748, 33.76452], [-118.16827, 33.76461]]]]} | Open Access 1 | Bixby Park | 16131 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 15.025 | Bixby Park | ||
2092 | 2092 | 2091 | {"type": "Polygon", "coordinates": [[[-118.16446, 33.76279], [-118.1643, 33.76333], [-118.15256, 33.76088], [-118.15255, 33.76085], [-118.15103, 33.76079], [-118.15064, 33.7607], [-118.15091, 33.75983], [-118.15284, 33.76035], [-118.15644, 33.76123], [-118.1582, 33.76158], [-118.15995, 33.76196], [-118.16348, 33.76263], [-118.16446, 33.76279]]]} | Open Access 1 | Bluff Park | 16198 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 18.611 | Bluff Park | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
3684 | 3684 | 3683 | {"type": "Polygon", "coordinates": [[[-118.17515, 33.78271], [-118.17514, 33.78433], [-118.17425, 33.78433], [-118.17426, 33.78271], [-118.17515, 33.78271]]]} | Open Access 1 | Douglas MacArthur Park | 18245 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.647 | Douglas MacArthur 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]);