superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3247 | 3247 | 3246 | {"type": "MultiPolygon", "coordinates": [[[[-118.09888, 33.79874], [-118.09877, 33.79897], [-118.09852, 33.7992], [-118.09829, 33.79944], [-118.09804, 33.79961], [-118.0977, 33.79976], [-118.09743, 33.7998], [-118.09713, 33.7998], [-118.09686, 33.79988], [-118.09656, 33.80001], [-118.09637, 33.80014], [-118.09597, 33.80071], [-118.09587, 33.80097], [-118.0958, 33.80124], [-118.09568, 33.80195], [-118.09561, 33.80217], [-118.09551, 33.80237], [-118.09538, 33.80256], [-118.09473, 33.80327], [-118.09458, 33.80348], [-118.09451, 33.80361], [-118.09362, 33.80386], [-118.09289, 33.804], [-118.0921, 33.80403], [-118.09141, 33.804], [-118.09101, 33.79591], [-118.09679, 33.79593], [-118.09701, 33.79609], [-118.09718, 33.79627], [-118.09735, 33.79656], [-118.09753, 33.79691], [-118.09762, 33.7972], [-118.09817, 33.79721], [-118.09858, 33.79781], [-118.09869, 33.79802], [-118.09879, 33.7984], [-118.09886, 33.7985], [-118.09888, 33.79874]]], [[[-118.09543, 33.80984], [-118.09439, 33.81005], [-118.09343, 33.81003], [-118.0925, 33.81009], [-118.09177, 33.80986], [-118.0917, 33.80987], [-118.09143, 33.80443], [-118.0916, 33.80443], [-118.09163, 33.80455], [-118.09184, 33.80467], [-118.09209, 33.80476], [-118.09211, 33.80491], [-118.09249, 33.80501], [-118.09295, 33.8052], [-118.09376, 33.80564], [-118.09427, 33.80609], [-118.0948, 33.80682], [-118.09547, 33.8085], [-118.09543, 33.80984]]]]} | Restricted Access 2 | El Dorado Park Golf Course | http://www.eldoradoparkgc.com/ | 33114 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 154.986 | El Dorado Park GC | |
3346 | 3346 | 3345 | {"type": "Polygon", "coordinates": [[[-118.14026, 33.782], [-118.14026, 33.78244], [-118.13519, 33.78245], [-118.13517, 33.78214], [-118.13189, 33.78191], [-118.1286, 33.77948], [-118.1286, 33.77543], [-118.13159, 33.77543], [-118.13155, 33.77619], [-118.13253, 33.77718], [-118.13431, 33.77757], [-118.13695, 33.77795], [-118.1371, 33.77794], [-118.13729, 33.77819], [-118.13734, 33.77832], [-118.13746, 33.77879], [-118.13743, 33.77907], [-118.13769, 33.77961], [-118.13781, 33.77978], [-118.13825, 33.78024], [-118.1386, 33.78072], [-118.13873, 33.78094], [-118.13906, 33.78131], [-118.13928, 33.78148], [-118.13951, 33.78164], [-118.13984, 33.78183], [-118.14026, 33.782]]]} | Restricted Access 2 | Recreation Park 18 Hole Golf Course | 33116 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 119.653 | Rec. Park 18 Hole GC | ||
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 | ||
3707 | 3707 | 3706 | {"type": "Polygon", "coordinates": [[[-118.2025, 33.77758], [-118.2026, 33.7777], [-118.20268, 33.77783], [-118.20278, 33.7781], [-118.2028, 33.77825], [-118.2028, 33.77839], [-118.20273, 33.77867], [-118.20265, 33.77884], [-118.20253, 33.779], [-118.20193, 33.7796], [-118.20178, 33.77972], [-118.20163, 33.77982], [-118.20139, 33.77945], [-118.20154, 33.77936], [-118.20187, 33.77913], [-118.20155, 33.77883], [-118.20169, 33.77871], [-118.20177, 33.77862], [-118.20163, 33.77852], [-118.20145, 33.77868], [-118.20123, 33.7788], [-118.20097, 33.77886], [-118.2007, 33.77886], [-118.2007, 33.77787], [-118.20101, 33.77788], [-118.20123, 33.77793], [-118.20146, 33.77804], [-118.20164, 33.7782], [-118.2025, 33.77758]]]} | Open Access 1 | Drake Park | 18271 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6.126 | Drake Park | ||
4202 | 4202 | 4201 | {"type": "MultiPolygon", "coordinates": [[[[-118.18761, 33.80427], [-118.18745, 33.80427], [-118.18686, 33.80389], [-118.18692, 33.80382], [-118.18716, 33.80389], [-118.1873, 33.80394], [-118.18759, 33.80413], [-118.18761, 33.80416], [-118.18761, 33.80427]]], [[[-118.18785, 33.80426], [-118.18769, 33.80427], [-118.18769, 33.80415], [-118.18769, 33.80415], [-118.18785, 33.80426]]]]} | Open Access 1 | Fellowship Park | 18869 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.365 | Fellowship Park | ||
4639 | 4639 | 4638 | {"type": "Polygon", "coordinates": [[[-118.20247, 33.7629], [-118.20235, 33.76293], [-118.20228, 33.76291], [-118.20223, 33.76292], [-118.2021, 33.76307], [-118.20205, 33.76317], [-118.20207, 33.76345], [-118.20214, 33.76347], [-118.20218, 33.76352], [-118.20221, 33.76357], [-118.20221, 33.76394], [-118.20206, 33.76396], [-118.20192, 33.76395], [-118.20183, 33.76366], [-118.20183, 33.76317], [-118.20187, 33.76301], [-118.20199, 33.76286], [-118.202, 33.76282], [-118.20197, 33.76278], [-118.20196, 33.76272], [-118.20156, 33.76249], [-118.20096, 33.76248], [-118.20093, 33.76351], [-118.20063, 33.76329], [-118.20069, 33.76327], [-118.20078, 33.76317], [-118.20078, 33.76266], [-118.20075, 33.76245], [-118.20069, 33.76223], [-118.20061, 33.76208], [-118.20051, 33.76196], [-118.2003, 33.76176], [-118.20017, 33.76168], [-118.20008, 33.76166], [-118.20004, 33.76162], [-118.20006, 33.76157], [-118.20014, 33.76156], [-118.20025, 33.76165], [-118.20063, 33.76183], [-118.20247, 33.7629]]]} | Open Access 1 | Golden Shore Marine Biological Reserve Park | http://www.longbeach.gov/park/park-and-facilities/directory/golden-shore-marine-biological-reserve-park/ | 19372 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.568 | Golden Shore Marine Biological Reserve Park | |
4995 | 4995 | 4994 | {"type": "MultiPolygon", "coordinates": [[[[-118.11639, 33.83036], [-118.11638, 33.83207], [-118.11633, 33.83212], [-118.10791, 33.83209], [-118.10789, 33.83205], [-118.1079, 33.83031], [-118.10859, 33.83031], [-118.10861, 33.83034], [-118.11639, 33.83036]]], [[[-118.125, 33.83134], [-118.12426, 33.83136], [-118.12427, 33.83168], [-118.12499, 33.83168], [-118.12499, 33.83216], [-118.1168, 33.83213], [-118.11674, 33.83208], [-118.11672, 33.83131], [-118.11672, 33.83032], [-118.125, 33.83035], [-118.125, 33.83134]]], [[[-118.1337, 33.83037], [-118.13369, 33.8321], [-118.13362, 33.83217], [-118.12534, 33.83215], [-118.12534, 33.83154], [-118.12601, 33.83153], [-118.12601, 33.83087], [-118.12532, 33.83085], [-118.12532, 33.83035], [-118.1337, 33.83037]]]]} | Open Access 1 | Heartwell Park | 19777 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 112.265 | Heartwell Park | ||
5265 | 5265 | 5264 | {"type": "Polygon", "coordinates": [[[-118.18557, 33.87069], [-118.18217, 33.87067], [-118.18215, 33.86744], [-118.1851, 33.86743], [-118.18557, 33.87069]]]} | Open Access 1 | Houghton Park | 20109 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 26.138 | Houghton Park | ||
5286 | 5286 | 5285 | {"type": "Polygon", "coordinates": [[[-118.22322, 33.79713], [-118.2227, 33.79832], [-118.22143, 33.79833], [-118.22142, 33.79884], [-118.21988, 33.79884], [-118.21988, 33.7972], [-118.22031, 33.7972], [-118.22032, 33.79714], [-118.22322, 33.79713]]]} | Open Access 1 | Hudson Park | 20134 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 11.241 | Hudson Park | ||
5316 | 5316 | 5315 | {"type": "Polygon", "coordinates": [[[-118.12859, 33.79616], [-118.12861, 33.79621], [-118.12859, 33.79721], [-118.12654, 33.79721], [-118.12693, 33.79678], [-118.12699, 33.79668], [-118.12703, 33.79654], [-118.12704, 33.79618], [-118.12708, 33.79614], [-118.12853, 33.79614], [-118.12859, 33.79616]]]} | Open Access 1 | Los Altos Park | 21474 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.609 | Los Altos Park | ||
5317 | 5317 | 5316 | {"type": "Polygon", "coordinates": [[[-118.1318, 33.78335], [-118.13182, 33.7834], [-118.1318, 33.78348], [-118.13176, 33.78363], [-118.1317, 33.78373], [-118.13156, 33.7839], [-118.1315, 33.7839], [-118.13112, 33.78358], [-118.13112, 33.78353], [-118.13131, 33.78342], [-118.1315, 33.78334], [-118.13174, 33.78331], [-118.1318, 33.78335]]]} | Open Access 1 | Los Altos Plaza Park | 21475 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.637 | Los Altos Plaza Park | ||
5356 | 5356 | 5355 | {"type": "MultiPolygon", "coordinates": [[[[-118.19942, 33.8255], [-118.19859, 33.82589], [-118.19854, 33.82589], [-118.19827, 33.82551], [-118.1982, 33.82544], [-118.1982, 33.8254], [-118.19906, 33.82499], [-118.1991, 33.825], [-118.19941, 33.82546], [-118.19942, 33.8255]]], [[[-118.20044, 33.8271], [-118.19882, 33.82786], [-118.1986, 33.82599], [-118.19944, 33.82559], [-118.20044, 33.8271]]]]} | Open Access 1 | Los Cerritos Park | 21511 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.691 | Los Cerritos Park | ||
5437 | 5437 | 5436 | {"type": "Polygon", "coordinates": [[[-118.12099, 33.76215], [-118.12095, 33.76218], [-118.12089, 33.76215], [-118.12066, 33.76192], [-118.12054, 33.76183], [-118.11973, 33.76245], [-118.11976, 33.76251], [-118.11952, 33.76268], [-118.11946, 33.76265], [-118.119, 33.76301], [-118.11851, 33.76256], [-118.11853, 33.76255], [-118.11855, 33.76248], [-118.11858, 33.76245], [-118.11855, 33.7624], [-118.11988, 33.76164], [-118.1201, 33.76161], [-118.12043, 33.76165], [-118.12047, 33.76164], [-118.12057, 33.76171], [-118.12056, 33.76177], [-118.12099, 33.76215]]]} | Open Access 1 | Jack Dunster Marine Biological Reserve | 20302 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.223 | Jack Dunster Marine Biological Reserve | 2004 | |
5452 | 5452 | 5451 | {"type": "MultiPolygon", "coordinates": [[[[-118.17335, 33.85167], [-118.17333, 33.85169], [-118.17187, 33.8517], [-118.17186, 33.85125], [-118.17155, 33.85118], [-118.17166, 33.85115], [-118.1729, 33.85139], [-118.17313, 33.8514], [-118.17335, 33.85145], [-118.17335, 33.85167]]], [[[-118.17706, 33.85079], [-118.17676, 33.85084], [-118.17615, 33.85106], [-118.17614, 33.85132], [-118.17569, 33.85133], [-118.17568, 33.85168], [-118.17399, 33.85169], [-118.17399, 33.85161], [-118.17397, 33.8516], [-118.17395, 33.85169], [-118.17356, 33.85169], [-118.17353, 33.85166], [-118.17353, 33.85148], [-118.17409, 33.85159], [-118.17502, 33.85146], [-118.17612, 33.85101], [-118.17661, 33.85083], [-118.17705, 33.85077], [-118.17706, 33.85079]]]]} | Open Access 1 | Jackson Park | 20321 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.994 | Jackson Park | ||
5637 | 5637 | 5636 | {"type": "Polygon", "coordinates": [[[-118.16917, 33.76286], [-118.16902, 33.7637], [-118.16866, 33.76365], [-118.16869, 33.76343], [-118.16848, 33.7634], [-118.16848, 33.76327], [-118.16805, 33.76321], [-118.16809, 33.76292], [-118.16333, 33.76211], [-118.16329, 33.76239], [-118.16467, 33.76266], [-118.16452, 33.76307], [-118.16439, 33.76304], [-118.16446, 33.76281], [-118.16445, 33.76279], [-118.16349, 33.76263], [-118.15995, 33.76196], [-118.1582, 33.76158], [-118.15644, 33.76123], [-118.15284, 33.76035], [-118.15093, 33.75983], [-118.15086, 33.76], [-118.14821, 33.75924], [-118.14824, 33.75912], [-118.14834, 33.75913], [-118.14837, 33.75898], [-118.14791, 33.75888], [-118.1482, 33.75782], [-118.15107, 33.7587], [-118.15117, 33.7588], [-118.15507, 33.75983], [-118.15767, 33.76048], [-118.16043, 33.76106], [-118.16264, 33.76158], [-118.16496, 33.76209], [-118.16842, 33.76269], [-118.16917, 33.76286]]]} | Open Access 1 | Junipero Beach | 20529 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 48.528 | Junipero Beach |
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]);