superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by ACCESS_TYP descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
891 | 891 | 890 | {"type": "Polygon", "coordinates": [[[-118.0907, 33.82486], [-118.09069, 33.82685], [-118.09002, 33.82685], [-118.09001, 33.82754], [-118.08923, 33.8273], [-118.08925, 33.82484], [-118.0907, 33.82486]]]} | No Public Access 3 | El Dorado East Regional Park | 32766 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 8.527 | El Dorado East RP | ||
11320 | 11320 | 11319 | {"type": "MultiPolygon", "coordinates": [[[[-118.19258, 33.84372], [-118.18742, 33.84551], [-118.1873, 33.84546], [-118.18731, 33.84541], [-118.18835, 33.84504], [-118.18837, 33.84497], [-118.18857, 33.84497], [-118.18981, 33.84454], [-118.18983, 33.84457], [-118.19066, 33.8443], [-118.19068, 33.84423], [-118.19254, 33.8436], [-118.19258, 33.84372]]], [[[-118.19442, 33.8431], [-118.19291, 33.84361], [-118.19283, 33.84363], [-118.19279, 33.84352], [-118.194, 33.8431], [-118.19442, 33.8431]]]]} | No Public Access 3 | Sleepy Hollow Greenbelt | 29956 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.298 | Sleepy Hollow Greenbelt | ||
12757 | 12757 | 12756 | {"type": "MultiPolygon", "coordinates": [[[[-118.1485, 33.77888], [-118.14796, 33.77888], [-118.14599, 33.77761], [-118.14599, 33.77723], [-118.14605, 33.77723], [-118.14796, 33.77847], [-118.14797, 33.77854], [-118.1485, 33.77888]]], [[[-118.15014, 33.78025], [-118.14868, 33.77931], [-118.14828, 33.77905], [-118.1488, 33.77905], [-118.15013, 33.7799], [-118.15014, 33.78025]]]]} | No Public Access 3 | Pacific Electric Greenbelt | 29943 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.702 | Pacific Electric Greenbelt | ||
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 | |
898 | 898 | 897 | {"type": "Polygon", "coordinates": [[[-118.19678, 33.8389], [-118.19592, 33.84035], [-118.19458, 33.8398], [-118.1951, 33.83894], [-118.19569, 33.83917], [-118.19612, 33.8388], [-118.19607, 33.83861], [-118.19622, 33.83873], [-118.19634, 33.8388], [-118.19678, 33.8389]]]} | Restricted Access 2 | Rancho Los Cerritos Historic Site | 32776 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.79 | Rancho Los Cerritos Historic Site | ||
930 | 930 | 929 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | El Dorado Community Gardens | 32803 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 8.254 | El Dorado Community Gardens | ||
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 | ||
11644 | 11644 | 11643 | {"type": "MultiPolygon", "coordinates": [[[[-118.13501, 33.77369], [-118.13477, 33.7743], [-118.13469, 33.77462], [-118.13464, 33.77502], [-118.13454, 33.77499], [-118.1345, 33.77494], [-118.13435, 33.77492], [-118.13433, 33.77494], [-118.13425, 33.77511], [-118.13425, 33.77522], [-118.12861, 33.77521], [-118.12861, 33.77359], [-118.13184, 33.77359], [-118.13186, 33.77356], [-118.13486, 33.77356], [-118.13498, 33.77362], [-118.13501, 33.77369]]], [[[-118.13709, 33.77258], [-118.13709, 33.77342], [-118.13549, 33.77344], [-118.13549, 33.77345], [-118.13554, 33.77351], [-118.13295, 33.77351], [-118.13294, 33.77344], [-118.13291, 33.77343], [-118.13288, 33.77266], [-118.13278, 33.77231], [-118.13275, 33.77212], [-118.13276, 33.7719], [-118.1328, 33.7718], [-118.13288, 33.77168], [-118.13298, 33.77163], [-118.13306, 33.77162], [-118.13502, 33.77188], [-118.13513, 33.77204], [-118.13533, 33.77205], [-118.13573, 33.7722], [-118.1358, 33.77229], [-118.13586, 33.77253], [-118.13593, 33.77262], [-118.13602, 33.7727], [-118.13612, 33.77274], [-118.13623, 33.77276], [-118.13634, 33.77276], [-118.13644, 33.77273], [-118.13657, 33.77265], [-118.13666, 33.77253], [-118.13709, 33.77258]]]]} | Restricted Access 2 | Recreation 9 Hole Golf Course | http://www.recpark9.com/ | 33115 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 40.595 | Rec. 9 Hole GC | |
12062 | 12062 | 12061 | {"type": "Polygon", "coordinates": [[[-118.19716, 33.76369], [-118.19705, 33.76402], [-118.19697, 33.76419], [-118.19684, 33.7644], [-118.19667, 33.76459], [-118.19658, 33.76458], [-118.19607, 33.76429], [-118.19559, 33.76406], [-118.19599, 33.76353], [-118.19603, 33.76342], [-118.19603, 33.76328], [-118.19614, 33.76327], [-118.19626, 33.76322], [-118.19631, 33.76322], [-118.19716, 33.76369]]]} | Restricted Access 2 | Long Beach Aquarium of the Pacific | 28978 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.167 | Long Beach Aquarium of the Pacific | ||
13566 | 13566 | 13565 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | Martin Luther King Jr. Park | 32772 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.547 | Martin Luther King Jr. Park | ||
13720 | 13720 | 13719 | {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10506, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} | Restricted Access 2 | Heartwell Golf Course | 33019 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 36.519 | Heartwell GC | ||
14563 | 14563 | 14562 | {"type": "MultiPolygon", "coordinates": [[[[-118.14175, 33.82338], [-118.13512, 33.82334], [-118.13509, 33.82283], [-118.13466, 33.82244], [-118.13408, 33.82244], [-118.13409, 33.81902], [-118.13416, 33.81896], [-118.13886, 33.81895], [-118.139, 33.81906], [-118.1391, 33.81948], [-118.13924, 33.81986], [-118.13935, 33.82009], [-118.13975, 33.82078], [-118.13995, 33.82107], [-118.14019, 33.82137], [-118.14125, 33.82253], [-118.14146, 33.82291], [-118.14163, 33.82315], [-118.14164, 33.82325], [-118.14169, 33.82326], [-118.14175, 33.82338]]], [[[-118.13891, 33.81857], [-118.13878, 33.81867], [-118.13416, 33.81868], [-118.1341, 33.81863], [-118.13413, 33.81186], [-118.13414, 33.81143], [-118.13419, 33.81124], [-118.1342, 33.81077], [-118.13422, 33.81074], [-118.13428, 33.81072], [-118.13441, 33.81072], [-118.13497, 33.81078], [-118.13539, 33.81088], [-118.13582, 33.81105], [-118.13625, 33.81129], [-118.13757, 33.81228], [-118.13794, 33.81248], [-118.13814, 33.81256], [-118.13848, 33.81267], [-118.1388, 33.81275], [-118.1389, 33.81284], [-118.1389, 33.81374], [-118.13894, 33.81402], [-118.13894, 33.81428], [-118.13895, 33.81713], [-118.13889, 33.81799], [-118.13889, 33.81832], [-118.13891, 33.81857]]]]} | Restricted Access 2 | Skylinks Golf Course | 33018 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 152.019 | Skylinks GC | ||
506 | 506 | 505 | {"type": "MultiPolygon", "coordinates": [[[[-118.09899, 33.80339], [-118.09898, 33.80692], [-118.09892, 33.8069], [-118.0986, 33.8069], [-118.09853, 33.80691], [-118.09849, 33.80693], [-118.09845, 33.807], [-118.09844, 33.80738], [-118.09845, 33.80743], [-118.09847, 33.80749], [-118.09857, 33.80755], [-118.09893, 33.80755], [-118.09897, 33.80753], [-118.09896, 33.81027], [-118.09889, 33.81033], [-118.09798, 33.81032], [-118.09751, 33.8103], [-118.09184, 33.81029], [-118.09183, 33.81024], [-118.09172, 33.81024], [-118.0917, 33.80987], [-118.09176, 33.80986], [-118.0925, 33.81009], [-118.09343, 33.81003], [-118.09439, 33.81005], [-118.09542, 33.80984], [-118.09547, 33.8085], [-118.0948, 33.80682], [-118.09427, 33.80608], [-118.09376, 33.80564], [-118.09295, 33.80521], [-118.09249, 33.80501], [-118.0921, 33.8049], [-118.09208, 33.80476], [-118.09184, 33.80467], [-118.09162, 33.80454], [-118.0916, 33.80443], [-118.09178, 33.80441], [-118.09247, 33.80438], [-118.0928, 33.80433], [-118.09295, 33.80427], [-118.09344, 33.80418], [-118.09389, 33.80408], [-118.09567, 33.80357], [-118.09606, 33.80348], [-118.09649, 33.80341], [-118.09702, 33.80335], [-118.09755, 33.80333], [-118.09892, 33.80333], [-118.09899, 33.80339]]], [[[-118.09903, 33.79594], [-118.09899, 33.803], [-118.09892, 33.80306], [-118.09731, 33.80306], [-118.09688, 33.80308], [-118.09646, 33.80313], [-118.09607, 33.80319], [-118.09561, 33.80329], [-118.09451, 33.80361], [-118.09458, 33.80348], [-118.09473, 33.80327], [-118.09538, 33.80256], [-118.09551, 33.80237], [-118.09561, 33.80217], [-118.09568, 33.80195], [-118.0958, 33.80124], [-118.09587, 33.80097], [-118.09597, 33.80071], [-118.09637, 33.80014], [-118.09656, 33.80001], [-118.09686, 33.79988], [-118.09713, 33.7998], [-118.09743, 33.7998], [-118.0977, 33.79976], [-118.09805, 33.79961], [-118.09829, 33.79943], [-118.09852, 33.7992], [-118.09876, 33.79898], [-118.09888, 33.79874], [-118.09886, 33.7985], [-118.09879, 33.7984], [-118.09869, 33.79802], [-118.09858, 33.79781], [-118.09818, 33.79722], [-118.09762, 33.79721], [-118.09753, 33.79691], [-118.09735, 33.79656], [-118.09718, 33.79627], [-118.09701, 33.79609], [-118.09679, 33.79593], [-118.09903, 33.79594]]]]} | Open Access 1 | El Dorado Park West | http://www.longbeach.gov/park/parks_and_open_spaces/parks/el_dorado_park_west.asp | 5429 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 116.612 | El Dorado Park West | |
694 | 694 | 693 | {"type": "Polygon", "coordinates": [[[-118.18058, 33.78624], [-118.18058, 33.78705], [-118.17942, 33.78705], [-118.17942, 33.78668], [-118.1799, 33.78668], [-118.17992, 33.78631], [-118.18015, 33.7863], [-118.18015, 33.7856], [-118.18058, 33.7856], [-118.18058, 33.78624]]]} | Open Access 1 | Ernest McBride Park & California Recreation Community Center | http://www.longbeach.gov/park/park-and-facilities/directory/mcbride-park/ | 30888 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.487 | Ernest McBride Park & California Rec. Community Ctr. | |
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 | ||
737 | 737 | 736 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79555], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 21st to Hill Mini Park | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | 28944 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.91 | 21st to Hill 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 |
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]);