superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 and MNG_AG_TYP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14333 | 14333 | 14332 | {"type": "Polygon", "coordinates": [[[-118.14894, 33.76065], [-118.14889, 33.76086], [-118.14849, 33.76069], [-118.14818, 33.7606], [-118.14798, 33.76055], [-118.14796, 33.76053], [-118.14796, 33.76047], [-118.14799, 33.76044], [-118.14803, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | Unknown park - Long Beach, City of | 29921 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.432 | |||
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 | ||
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 | |
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 | |
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 | |
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 | ||
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 | ||
14318 | 14318 | 14317 | {"type": "Polygon", "coordinates": [[[-118.19096, 33.844], [-118.1907, 33.84409], [-118.19069, 33.84339], [-118.19096, 33.84339], [-118.19096, 33.844]]]} | Open Access 1 | Arbor Street Park | 28932 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.43 | Arbor Street Park | ||
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 | ||
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 | ||
12735 | 12735 | 12734 | {"type": "MultiPolygon", "coordinates": [[[[-118.13088, 33.75291], [-118.13072, 33.75313], [-118.12914, 33.75219], [-118.12927, 33.75199], [-118.13088, 33.75291]]], [[[-118.13211, 33.75514], [-118.13039, 33.75789], [-118.13018, 33.75781], [-118.1303, 33.75771], [-118.13125, 33.75618], [-118.13149, 33.75596], [-118.13175, 33.7552], [-118.13179, 33.75507], [-118.1318, 33.7548], [-118.13162, 33.75434], [-118.13155, 33.75402], [-118.13074, 33.7533], [-118.13079, 33.75324], [-118.13095, 33.75332], [-118.13107, 33.7532], [-118.13126, 33.75329], [-118.13114, 33.75344], [-118.13128, 33.75352], [-118.13152, 33.75325], [-118.13174, 33.75337], [-118.1315, 33.75376], [-118.13193, 33.75398], [-118.13176, 33.75426], [-118.13211, 33.75514]]]]} | Open Access 1 | Bayshore Beach | 29929 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.17 | Bayshore Beach | ||
12734 | 12734 | 12733 | {"type": "Polygon", "coordinates": [[[-118.13217, 33.7536], [-118.13193, 33.75398], [-118.13149, 33.75376], [-118.13174, 33.75337], [-118.13217, 33.7536]]]} | Open Access 1 | Bayshore Park | 29912 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.568 | Bayshore Park | 1934 | |
12750 | 12750 | 12749 | {"type": "Polygon", "coordinates": [[[-118.14809, 33.75779], [-118.14772, 33.75908], [-118.14638, 33.7588], [-118.14641, 33.75866], [-118.14626, 33.75863], [-118.14648, 33.75785], [-118.14496, 33.75754], [-118.14525, 33.75697], [-118.14662, 33.75743], [-118.14809, 33.75779]]]} | Open Access 1 | Belmont Plaza Beach | 29954 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.28 | Belmont Plaza Beach | ||
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 | ||
12766 | 12766 | 12765 | {"type": "Polygon", "coordinates": [[[-118.14947, 33.75539], [-118.14946, 33.75548], [-118.14908, 33.75548], [-118.14906, 33.75553], [-118.14898, 33.75553], [-118.14897, 33.75556], [-118.14887, 33.75557], [-118.14862, 33.75644], [-118.14864, 33.75647], [-118.14864, 33.75653], [-118.1486, 33.75667], [-118.14856, 33.75674], [-118.14852, 33.75675], [-118.14791, 33.75886], [-118.14838, 33.75898], [-118.14834, 33.75914], [-118.14824, 33.75913], [-118.14821, 33.75924], [-118.14797, 33.75913], [-118.14772, 33.75908], [-118.14809, 33.75779], [-118.14842, 33.75672], [-118.1484, 33.7567], [-118.1484, 33.75656], [-118.14847, 33.75645], [-118.14851, 33.75644], [-118.14865, 33.75595], [-118.14863, 33.75593], [-118.1487, 33.75569], [-118.1486, 33.75556], [-118.14854, 33.75562], [-118.14856, 33.75566], [-118.14836, 33.75576], [-118.14831, 33.75569], [-118.14849, 33.75561], [-118.14849, 33.75559], [-118.14845, 33.75556], [-118.14829, 33.75563], [-118.14823, 33.75556], [-118.14841, 33.75547], [-118.14847, 33.75552], [-118.14856, 33.75549], [-118.14859, 33.75548], [-118.14862, 33.75539], [-118.1483, 33.75524], [-118.14835, 33.75515], [-118.14869, 33.7553], [-118.14871, 33.75528], [-118.14891, 33.75528], [-118.14907, 33.75535], [-118.14908, 33.75539], [-118.14947, 33.75539]]]} | Open Access 1 | Belmont Veterans Memorial Pier | 29955 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.109 | Belmont Veterans Memorial Pier | ||
12048 | 12048 | 12047 | {"type": "Polygon", "coordinates": [[[-118.10508, 33.83028], [-118.10508, 33.83056], [-118.10362, 33.83055], [-118.10362, 33.83028], [-118.10508, 33.83028]]]} | Open Access 1 | Birdcage Park | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/Birdcage-Park/ | 28957 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.033 | Birdcage Park | |
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 |
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]);