superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME, ACRES, LABEL_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
12744 | 12744 | 12743 | {"type": "Polygon", "coordinates": [[[-118.2227, 33.79833], [-118.22247, 33.79885], [-118.22142, 33.79884], [-118.22142, 33.79833], [-118.2227, 33.79833]]]} | Open Access 1 | Hudson Park Community Garden | 29919 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.531 | Hudson Park Community Garden | ||
12749 | 12749 | 12748 | {"type": "Polygon", "coordinates": [[[-118.21763, 33.79448], [-118.21763, 33.79704], [-118.21597, 33.79703], [-118.21597, 33.79623], [-118.21554, 33.79621], [-118.21554, 33.7953], [-118.21585, 33.79531], [-118.21587, 33.79525], [-118.21585, 33.79524], [-118.21561, 33.79524], [-118.21561, 33.79448], [-118.21763, 33.79448]]]} | Open Access 1 | Admiral Issac C. Kidd Park | 29925 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 12.498 | Admiral Issac C. Kidd Park | ||
9400 | 9400 | 9399 | {"type": "Polygon", "coordinates": [[[-118.21529, 33.8152], [-118.21119, 33.81519], [-118.21119, 33.81407], [-118.21528, 33.81406], [-118.21529, 33.8152]]]} | Open Access 1 | Silverado Park | 25498 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 11.722 | Silverado Park | ||
12067 | 12067 | 12066 | {"type": "Polygon", "coordinates": [[[-118.21483, 33.79305], [-118.21483, 33.79341], [-118.21466, 33.79341], [-118.21466, 33.79305], [-118.21483, 33.79305]]]} | Open Access 1 | Mary Molina Community Garden | 28986 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.152 | Mary Molina Community Garden | ||
12721 | 12721 | 12720 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 34th St Greenbelt | 29894 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.927 | 34th St Greenbelt | 2007 | |
11259 | 11259 | 11258 | {"type": "Polygon", "coordinates": [[[-118.2044, 33.80427], [-118.20253, 33.80427], [-118.2025, 33.80426], [-118.20249, 33.80422], [-118.20246, 33.80421], [-118.20246, 33.80405], [-118.20248, 33.80403], [-118.20428, 33.80403], [-118.20428, 33.80418], [-118.2044, 33.80427]]]} | Open Access 1 | Willow & Golden S | 29904 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.118 | Willow & Golden S | ||
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 | ||
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 | |
9929 | 9929 | 9928 | {"type": "Polygon", "coordinates": [[[-118.2041, 33.77812], [-118.20413, 33.77876], [-118.20407, 33.77891], [-118.20398, 33.77908], [-118.20386, 33.77925], [-118.20372, 33.7794], [-118.2035, 33.77958], [-118.20334, 33.77968], [-118.20106, 33.78128], [-118.20102, 33.78137], [-118.2007, 33.78153], [-118.20044, 33.7817], [-118.20015, 33.78197], [-118.19976, 33.78248], [-118.19955, 33.78248], [-118.19977, 33.78213], [-118.20005, 33.78181], [-118.20033, 33.78157], [-118.20115, 33.781], [-118.20119, 33.78077], [-118.20134, 33.7806], [-118.20151, 33.78056], [-118.20132, 33.78016], [-118.20164, 33.78003], [-118.20194, 33.77984], [-118.20211, 33.77969], [-118.20269, 33.7791], [-118.20278, 33.77899], [-118.20299, 33.77911], [-118.20318, 33.77899], [-118.20317, 33.77898], [-118.20309, 33.77895], [-118.20314, 33.77882], [-118.20323, 33.77885], [-118.20344, 33.77871], [-118.20348, 33.77854], [-118.2035, 33.77836], [-118.20347, 33.77806], [-118.20393, 33.778], [-118.20395, 33.77813], [-118.2041, 33.77812]]]} | Open Access 1 | Drake/Chavez Soccer Fields and Parkway | 27996 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.972 | Drake/Chavez Soccer Fields and Parkway | 2018 | |
10469 | 10469 | 10468 | {"type": "Polygon", "coordinates": [[[-118.20273, 33.82355], [-118.20253, 33.8243], [-118.20239, 33.82419], [-118.20128, 33.82355], [-118.20273, 33.82355]]]} | Open Access 1 | Baker Street Park | 28945 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.331 | Baker Street Park | ||
12738 | 12738 | 12737 | {"type": "Polygon", "coordinates": [[[-118.20264, 33.82045], [-118.20248, 33.82045], [-118.20153, 33.81926], [-118.20157, 33.81922], [-118.2021, 33.81932], [-118.20229, 33.81937], [-118.20231, 33.81941], [-118.20247, 33.81946], [-118.20248, 33.81943], [-118.20264, 33.81948], [-118.20264, 33.82045]]]} | Open Access 1 | Wrigley Heights Dog Park | 29932 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.703 | Wrigley Heights Dog Park | 2014 | |
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 | ||
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 | |
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 | ||
12733 | 12733 | 12732 | {"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84874], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]} | Open Access 1 | 51st St Greenbelt | 29907 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.012 | 51st St Greenbelt | 2008 | |
10487 | 10487 | 10486 | {"type": "Polygon", "coordinates": [[[-118.20065, 33.78135], [-118.20033, 33.78157], [-118.20014, 33.78173], [-118.20008, 33.78169], [-118.20031, 33.7815], [-118.2005, 33.78127], [-118.20065, 33.78135]]]} | Open Access 1 | Loma Vista Park | 28977 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.143 | Loma Vista Park | ||
12080 | 12080 | 12079 | {"type": "Polygon", "coordinates": [[[-118.19844, 33.84148], [-118.19809, 33.84159], [-118.1981, 33.84183], [-118.19442, 33.8431], [-118.194, 33.8431], [-118.19802, 33.84171], [-118.19805, 33.84167], [-118.19804, 33.84148], [-118.198, 33.84136], [-118.19796, 33.84133], [-118.19797, 33.84132], [-118.19827, 33.84145], [-118.19844, 33.84148]]]} | Open Access 1 | Sleepy Hollow Greenbelt | http://www.longbeach.gov/park/park-and-facilities/directory/sleepy-hollow-greenbelt/ | 29005 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.577 | Sleepy Hollow 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 | |
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.19767, 33.78476], [-118.19649, 33.78476], [-118.19649, 33.78394], [-118.19754, 33.78395], [-118.19755, 33.78437], [-118.19761, 33.78443], [-118.19767, 33.78443], [-118.19767, 33.78476]]]} | Open Access 1 | Seaside Park | 25266 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.298 | Seaside 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]);