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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5794 | 5794 | 5793 | {"type": "Polygon", "coordinates": [[[-118.12344, 33.75467], [-118.1234, 33.75459], [-118.1234, 33.75451], [-118.12344, 33.75443], [-118.12352, 33.75438], [-118.12362, 33.75435], [-118.12371, 33.75437], [-118.1238, 33.75441], [-118.12385, 33.75448], [-118.12387, 33.75455], [-118.12385, 33.75462], [-118.12381, 33.75468], [-118.12374, 33.75473], [-118.12367, 33.75475], [-118.12358, 33.75475], [-118.1235, 33.75472], [-118.12344, 33.75467]]]} | Open Access 1 | La Bella Fontana Di Napoli | 20741 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.369 | La Bella Fontana Di Napoli | ||
6174 | 6174 | 6173 | {"type": "Polygon", "coordinates": [[[-118.07283, 33.81486], [-118.07254, 33.81515], [-118.07246, 33.81527], [-118.07239, 33.81542], [-118.07195, 33.8153], [-118.07283, 33.81486]]]} | Open Access 1 | Lilly Park | 21238 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.332 | Lilly Park | ||
6195 | 6195 | 6194 | {"type": "Polygon", "coordinates": [[[-118.19511, 33.76865], [-118.19493, 33.76865], [-118.19494, 33.76918], [-118.19389, 33.76918], [-118.19389, 33.76817], [-118.1949, 33.76817], [-118.19491, 33.76828], [-118.19494, 33.76834], [-118.19502, 33.76837], [-118.19511, 33.76837], [-118.19511, 33.76865]]]} | Open Access 1 | Lincoln Park | 21264 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.818 | Lincoln Park | ||
6308 | 6308 | 6307 | {"type": "MultiPolygon", "coordinates": [[[[-118.13513, 33.76319], [-118.13494, 33.76348], [-118.13464, 33.76355], [-118.13433, 33.76341], [-118.13513, 33.76319]]], [[[-118.13617, 33.76292], [-118.13599, 33.7632], [-118.13525, 33.7634], [-118.13521, 33.7634], [-118.13518, 33.76337], [-118.13519, 33.76334], [-118.13531, 33.76315], [-118.13617, 33.76292]]], [[[-118.1372, 33.76265], [-118.13714, 33.7629], [-118.13629, 33.76312], [-118.13625, 33.76312], [-118.13623, 33.76309], [-118.13623, 33.76306], [-118.13636, 33.76287], [-118.1372, 33.76265]]], [[[-118.13839, 33.76234], [-118.13834, 33.76258], [-118.13735, 33.76284], [-118.13743, 33.76259], [-118.13839, 33.76234]]]]} | Open Access 1 | Livingston Drive Greenbelt and Playground | 21383 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.922 | Livingston Drive Greenbelt and Playground | 2008 | |
6360 | 6360 | 6359 | {"type": "Polygon", "coordinates": [[[-118.17741, 33.80621], [-118.17642, 33.80621], [-118.17642, 33.80452], [-118.17647, 33.80448], [-118.1774, 33.80448], [-118.17741, 33.80621]]]} | Open Access 1 | Long Beach Municipal Cemetery | 21448 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.335 | Long Beach Municipal Cemetery | ||
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 |
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]);