superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
135 rows where ACCESS_TYP = 1 and 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6634 | 6634 | 6633 | {"type": "Polygon", "coordinates": [[[-118.18924, 33.76079], [-118.18923, 33.76161], [-118.1892, 33.76167], [-118.1889, 33.76173], [-118.18823, 33.76179], [-118.18786, 33.76188], [-118.18762, 33.76195], [-118.18723, 33.76212], [-118.18697, 33.76226], [-118.18546, 33.76317], [-118.18538, 33.76318], [-118.18534, 33.76316], [-118.18519, 33.76325], [-118.1852, 33.76332], [-118.18516, 33.76336], [-118.18447, 33.76377], [-118.18422, 33.76395], [-118.18368, 33.7645], [-118.18357, 33.7645], [-118.18361, 33.76438], [-118.18333, 33.76403], [-118.18347, 33.76392], [-118.18498, 33.76301], [-118.18513, 33.7629], [-118.18688, 33.76188], [-118.18819, 33.76118], [-118.18924, 33.76079]]]} | Open Access 1 | Marina Green | 21822 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.807 | Marina Green | ||
6658 | 6658 | 6657 | {"type": "Polygon", "coordinates": [[[-118.13166, 33.76953], [-118.13146, 33.76962], [-118.13131, 33.76975], [-118.13122, 33.7698], [-118.12671, 33.7698], [-118.12625, 33.76903], [-118.12654, 33.76867], [-118.12596, 33.76849], [-118.12614, 33.76803], [-118.12599, 33.76797], [-118.126, 33.76796], [-118.12631, 33.76806], [-118.1267, 33.76827], [-118.1269, 33.76836], [-118.12715, 33.76844], [-118.12738, 33.76848], [-118.12774, 33.76849], [-118.12912, 33.7684], [-118.12935, 33.76843], [-118.12968, 33.76852], [-118.12988, 33.76855], [-118.13092, 33.76859], [-118.13105, 33.76861], [-118.13121, 33.76866], [-118.13156, 33.7689], [-118.13167, 33.76904], [-118.13173, 33.76923], [-118.13172, 33.76937], [-118.13166, 33.76953]]]} | Open Access 1 | Marina Vista Park | 21841 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 17.58 | Marina Vista Park | ||
6672 | 6672 | 6671 | {"type": "MultiPolygon", "coordinates": [[[[-118.12655, 33.764], [-118.12636, 33.76408], [-118.12377, 33.76183], [-118.12399, 33.76165], [-118.12655, 33.764]]], [[[-118.12538, 33.76725], [-118.12531, 33.76744], [-118.12529, 33.76765], [-118.12527, 33.76769], [-118.12506, 33.76776], [-118.12488, 33.76772], [-118.12507, 33.76713], [-118.12513, 33.76719], [-118.12538, 33.76725]]], [[[-118.13116, 33.76835], [-118.13102, 33.76843], [-118.12997, 33.76837], [-118.12976, 33.76835], [-118.12936, 33.76824], [-118.12909, 33.76822], [-118.12773, 33.76831], [-118.12773, 33.76804], [-118.12767, 33.76801], [-118.1276, 33.76791], [-118.1278, 33.76779], [-118.1279, 33.76787], [-118.1279, 33.76797], [-118.12795, 33.76805], [-118.12806, 33.7681], [-118.12861, 33.76812], [-118.12937, 33.76811], [-118.12953, 33.76816], [-118.12967, 33.76814], [-118.12982, 33.76803], [-118.13, 33.76786], [-118.13008, 33.7677], [-118.13016, 33.76766], [-118.13081, 33.76826], [-118.13106, 33.76827], [-118.13116, 33.76835]]]]} | Open Access 1 | Marine Stadium Park | 21849 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.843 | Marine Stadium Park | ||
6713 | 6713 | 6712 | {"type": "Polygon", "coordinates": [[[-118.17831, 33.79133], [-118.1783, 33.79257], [-118.17831, 33.79275], [-118.17797, 33.79275], [-118.17795, 33.79266], [-118.17746, 33.79266], [-118.17745, 33.79307], [-118.17742, 33.79309], [-118.17742, 33.7934], [-118.17642, 33.7934], [-118.17643, 33.79133], [-118.17831, 33.79133]]]} | Open Access 1 | Martin Luther King Jr. Park | 21912 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 8.326 | Martin Luther King Jr. Park | ||
6811 | 6811 | 6810 | {"type": "Polygon", "coordinates": [[[-118.18561, 33.78421], [-118.18515, 33.78421], [-118.18515, 33.78386], [-118.18561, 33.78387], [-118.18561, 33.78421]]]} | Open Access 1 | Peace Park | 23539 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.401 | Peace Park | ||
6843 | 6843 | 6842 | {"type": "MultiPolygon", "coordinates": [[[[-118.1339, 33.75143], [-118.13244, 33.75337], [-118.13223, 33.75326], [-118.13249, 33.75291], [-118.13249, 33.75289], [-118.13242, 33.75287], [-118.13216, 33.75322], [-118.13042, 33.75231], [-118.13062, 33.75203], [-118.13056, 33.75198], [-118.13049, 33.75196], [-118.13028, 33.75224], [-118.12972, 33.75195], [-118.12998, 33.75159], [-118.12994, 33.75155], [-118.12965, 33.75191], [-118.12875, 33.75144], [-118.12894, 33.75116], [-118.12893, 33.75115], [-118.12655, 33.74983], [-118.12441, 33.74861], [-118.12216, 33.74728], [-118.12094, 33.74658], [-118.12034, 33.7463], [-118.11915, 33.74576], [-118.11864, 33.74558], [-118.11827, 33.7455], [-118.11797, 33.7454], [-118.11797, 33.74537], [-118.11789, 33.74533], [-118.11762, 33.74568], [-118.11715, 33.74543], [-118.11718, 33.74536], [-118.11664, 33.74505], [-118.11771, 33.74349], [-118.11778, 33.7436], [-118.11787, 33.7437], [-118.11972, 33.7451], [-118.12233, 33.74681], [-118.12259, 33.74701], [-118.12286, 33.74717], [-118.12299, 33.74728], [-118.12361, 33.74762], [-118.12417, 33.74785], [-118.12484, 33.74819], [-118.12766, 33.74905], [-118.12844, 33.74937], [-118.12883, 33.74948], [-118.12931, 33.74968], [-118.12965, 33.74979], [-118.12998, 33.74993], [-118.13055, 33.7501], [-118.1312, 33.75037], [-118.13193, 33.75063], [-118.13349, 33.75125], [-118.1339, 33.75143]]], [[[-118.12134, 33.74925], [-118.12116, 33.74946], [-118.1204, 33.74887], [-118.1203, 33.74856], [-118.12014, 33.74849], [-118.11929, 33.74762], [-118.11787, 33.74681], [-118.11823, 33.7463], [-118.11841, 33.74654], [-118.11858, 33.74672], [-118.11946, 33.74748], [-118.1199, 33.74797], [-118.12038, 33.7484], [-118.12037, 33.74844], [-118.12045, 33.74848], [-118.12083, 33.74887], [-118.12134, 33.74925]]], [[[-118.12847, 33.75181], [-118.12844, 33.75187], [-118.12809, 33.75186], [-118.1255, 33.75117], [-118.12339, 33.75035], [-118.12263, 33.74994], [-118.1227, 33.74984], [-118.12324, 33.74999], [-118.12382, 33.75028], [-118.12512, 33.75067], [-118.12573, 33.75094], [-118.12636, 33.75116], [-118.12847, 33.75181]]]]} | Open Access 1 | Peninsula Beach | 23578 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 61.781 | Peninsula Beach | ||
7039 | 7039 | 7038 | {"type": "Polygon", "coordinates": [[[-118.17269, 33.77122], [-118.17269, 33.77163], [-118.17255, 33.77163], [-118.17255, 33.77122], [-118.17269, 33.77122]]]} | Open Access 1 | Miracle on Fourth Street Park | 22281 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.138 | Miracle on Fourth Street Park | ||
7750 | 7750 | 7749 | {"type": "Polygon", "coordinates": [[[-118.15882, 33.78532], [-118.15882, 33.78581], [-118.15805, 33.78532], [-118.15684, 33.78532], [-118.15684, 33.78449], [-118.15846, 33.78449], [-118.15846, 33.78475], [-118.15833, 33.78477], [-118.15833, 33.78497], [-118.15846, 33.78497], [-118.15846, 33.78529], [-118.15849, 33.78532], [-118.15882, 33.78532]]]} | Open Access 1 | Orizaba Park | 23204 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.78 | Orizaba Park | ||
7822 | 7822 | 7821 | {"type": "Polygon", "coordinates": [[[-118.1182, 33.75324], [-118.11816, 33.75325], [-118.11796, 33.75306], [-118.11778, 33.75291], [-118.11766, 33.75284], [-118.11739, 33.75275], [-118.11803, 33.75272], [-118.11813, 33.75268], [-118.11813, 33.75273], [-118.11819, 33.75279], [-118.1182, 33.75293], [-118.1182, 33.75324]]]} | Open Access 1 | Overlook Park (Naples Plaza) | 23275 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.466 | Overlook Park (Naples Plaza) | ||
7845 | 7845 | 7844 | {"type": "MultiPolygon", "coordinates": [[[[-118.14362, 33.77567], [-118.14362, 33.77608], [-118.14273, 33.77551], [-118.14273, 33.77544], [-118.14327, 33.77544], [-118.14362, 33.77567]]], [[[-118.14578, 33.77707], [-118.14515, 33.77707], [-118.14381, 33.77621], [-118.14381, 33.77579], [-118.14578, 33.77707]]]]} | Open Access 1 | Pacific Electric Greenbelt | 23297 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.421 | Pacific Electric Greenbelt | ||
7913 | 7913 | 7912 | {"type": "Polygon", "coordinates": [[[-118.13204, 33.83966], [-118.13203, 33.84296], [-118.1306, 33.84295], [-118.13062, 33.83966], [-118.13204, 33.83966]]]} | Open Access 1 | Pan American Park | 23383 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 11.969 | Pan American Park | ||
8450 | 8450 | 8449 | {"type": "Polygon", "coordinates": [[[-118.19583, 33.75484], [-118.1958, 33.7549], [-118.19566, 33.75492], [-118.19552, 33.75499], [-118.19539, 33.75504], [-118.19534, 33.75504], [-118.19525, 33.75502], [-118.19505, 33.75519], [-118.19498, 33.75519], [-118.19489, 33.75516], [-118.19473, 33.75496], [-118.19455, 33.7548], [-118.19449, 33.75476], [-118.19437, 33.75471], [-118.19433, 33.75467], [-118.19427, 33.75456], [-118.19424, 33.75444], [-118.19423, 33.75426], [-118.19419, 33.75415], [-118.19416, 33.75412], [-118.19408, 33.75409], [-118.19398, 33.75407], [-118.19373, 33.75397], [-118.19404, 33.75334], [-118.19536, 33.75382], [-118.19536, 33.75457], [-118.19537, 33.75465], [-118.19547, 33.75475], [-118.19583, 33.75484]]]} | Open Access 1 | Queen Mary Events Park | 24061 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.723 | Queen Mary Events Park | ||
8499 | 8499 | 8498 | {"type": "Polygon", "coordinates": [[[-118.15552, 33.87377], [-118.15359, 33.87378], [-118.15358, 33.87208], [-118.15446, 33.87208], [-118.15457, 33.87214], [-118.15466, 33.87229], [-118.15471, 33.87236], [-118.15487, 33.87246], [-118.15506, 33.8725], [-118.15552, 33.8725], [-118.15552, 33.87377]]]} | Open Access 1 | Ramona Park | 24119 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.458 | Ramona Park | ||
8526 | 8526 | 8525 | {"type": "Polygon", "coordinates": [[[-118.10845, 33.77696], [-118.10812, 33.77733], [-118.10811, 33.77767], [-118.1074, 33.77768], [-118.1063, 33.7776], [-118.10632, 33.77741], [-118.10608, 33.77704], [-118.10604, 33.77648], [-118.10563, 33.77642], [-118.10564, 33.77625], [-118.10604, 33.77629], [-118.10686, 33.77626], [-118.10722, 33.77607], [-118.10745, 33.77636], [-118.10786, 33.77635], [-118.10794, 33.77631], [-118.10845, 33.77696]]]} | Open Access 1 | Rancho Los Alamitos Historic Site | 24152 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.411 | Rancho Los Alamitos Historic Site | ||
8942 | 8942 | 8941 | {"type": "Polygon", "coordinates": [[[-118.15704, 33.77713], [-118.15703, 33.77723], [-118.15697, 33.77732], [-118.15687, 33.77738], [-118.15675, 33.7774], [-118.15663, 33.77737], [-118.15653, 33.77731], [-118.15647, 33.77722], [-118.15646, 33.77713], [-118.15649, 33.77705], [-118.15655, 33.77698], [-118.15664, 33.77693], [-118.15674, 33.77691], [-118.15685, 33.77692], [-118.15694, 33.77696], [-118.15701, 33.77703], [-118.15704, 33.77713]]]} | Open Access 1 | Rose Park | 24612 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.559 | Rose Park | ||
9008 | 9008 | 9007 | {"type": "Polygon", "coordinates": [[[-118.16535, 33.78974], [-118.16492, 33.78974], [-118.16342, 33.78877], [-118.16342, 33.78849], [-118.16535, 33.78974]]]} | Open Access 1 | Rotary Centennial Park | 24683 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.209 | Rotary Centennial Park | ||
9313 | 9313 | 9312 | {"type": "MultiPolygon", "coordinates": [[[[-118.19734, 33.76719], [-118.19543, 33.76709], [-118.19541, 33.76707], [-118.19499, 33.76705], [-118.19499, 33.76694], [-118.19543, 33.76696], [-118.1963, 33.76696], [-118.19733, 33.76699], [-118.19734, 33.76719]]], [[[-118.19792, 33.767], [-118.19792, 33.76721], [-118.19746, 33.7672], [-118.19745, 33.76699], [-118.19792, 33.767]]], [[[-118.19929, 33.76702], [-118.19929, 33.76707], [-118.19921, 33.76714], [-118.19825, 33.76714], [-118.19822, 33.76711], [-118.1982, 33.76721], [-118.19814, 33.76721], [-118.19814, 33.76703], [-118.19929, 33.76702]]], [[[-118.20049, 33.76703], [-118.20049, 33.76709], [-118.20043, 33.76714], [-118.19954, 33.76714], [-118.19949, 33.76707], [-118.19949, 33.76702], [-118.20049, 33.76703]]], [[[-118.20174, 33.76703], [-118.20174, 33.76709], [-118.20167, 33.76714], [-118.20076, 33.76714], [-118.2007, 33.76708], [-118.2007, 33.76703], [-118.20174, 33.76703]]]]} | Open Access 1 | Santa Cruz Park | 25082 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.095 | Santa Cruz Park | ||
9384 | 9384 | 9383 | {"type": "Polygon", "coordinates": [[[-118.19207, 33.84232], [-118.19185, 33.84231], [-118.19149, 33.84239], [-118.18788, 33.84325], [-118.18769, 33.84342], [-118.18738, 33.84539], [-118.1872, 33.84545], [-118.18698, 33.84535], [-118.18658, 33.84521], [-118.18617, 33.84512], [-118.18618, 33.84367], [-118.18513, 33.84366], [-118.18513, 33.84305], [-118.18873, 33.84219], [-118.19167, 33.84121], [-118.19207, 33.84232]]]} | Open Access 1 | Scherer Park | 25183 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 21.833 | Scherer 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 | ||
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]);