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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5265 | 5265 | 5264 | {"type": "Polygon", "coordinates": [[[-118.18557, 33.87069], [-118.18217, 33.87067], [-118.18215, 33.86744], [-118.1851, 33.86743], [-118.18557, 33.87069]]]} | Open Access 1 | Houghton Park | 20109 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 26.138 | Houghton Park | ||
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 | ||
5316 | 5316 | 5315 | {"type": "Polygon", "coordinates": [[[-118.12859, 33.79616], [-118.12861, 33.79621], [-118.12859, 33.79721], [-118.12654, 33.79721], [-118.12693, 33.79678], [-118.12699, 33.79668], [-118.12703, 33.79654], [-118.12704, 33.79618], [-118.12708, 33.79614], [-118.12853, 33.79614], [-118.12859, 33.79616]]]} | Open Access 1 | Los Altos Park | 21474 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 4.609 | Los Altos Park | ||
5317 | 5317 | 5316 | {"type": "Polygon", "coordinates": [[[-118.1318, 33.78335], [-118.13182, 33.7834], [-118.1318, 33.78348], [-118.13176, 33.78363], [-118.1317, 33.78373], [-118.13156, 33.7839], [-118.1315, 33.7839], [-118.13112, 33.78358], [-118.13112, 33.78353], [-118.13131, 33.78342], [-118.1315, 33.78334], [-118.13174, 33.78331], [-118.1318, 33.78335]]]} | Open Access 1 | Los Altos Plaza Park | 21475 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.637 | Los Altos Plaza Park | ||
5356 | 5356 | 5355 | {"type": "MultiPolygon", "coordinates": [[[[-118.19942, 33.8255], [-118.19859, 33.82589], [-118.19854, 33.82589], [-118.19827, 33.82551], [-118.1982, 33.82544], [-118.1982, 33.8254], [-118.19906, 33.82499], [-118.1991, 33.825], [-118.19941, 33.82546], [-118.19942, 33.8255]]], [[[-118.20044, 33.8271], [-118.19882, 33.82786], [-118.1986, 33.82599], [-118.19944, 33.82559], [-118.20044, 33.8271]]]]} | Open Access 1 | Los Cerritos Park | 21511 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.691 | Los Cerritos Park | ||
5437 | 5437 | 5436 | {"type": "Polygon", "coordinates": [[[-118.12099, 33.76215], [-118.12095, 33.76218], [-118.12089, 33.76215], [-118.12066, 33.76192], [-118.12054, 33.76183], [-118.11973, 33.76245], [-118.11976, 33.76251], [-118.11952, 33.76268], [-118.11946, 33.76265], [-118.119, 33.76301], [-118.11851, 33.76256], [-118.11853, 33.76255], [-118.11855, 33.76248], [-118.11858, 33.76245], [-118.11855, 33.7624], [-118.11988, 33.76164], [-118.1201, 33.76161], [-118.12043, 33.76165], [-118.12047, 33.76164], [-118.12057, 33.76171], [-118.12056, 33.76177], [-118.12099, 33.76215]]]} | Open Access 1 | Jack Dunster Marine Biological Reserve | 20302 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.223 | Jack Dunster Marine Biological Reserve | 2004 | |
5452 | 5452 | 5451 | {"type": "MultiPolygon", "coordinates": [[[[-118.17335, 33.85167], [-118.17333, 33.85169], [-118.17187, 33.8517], [-118.17186, 33.85125], [-118.17155, 33.85118], [-118.17166, 33.85115], [-118.1729, 33.85139], [-118.17313, 33.8514], [-118.17335, 33.85145], [-118.17335, 33.85167]]], [[[-118.17706, 33.85079], [-118.17676, 33.85084], [-118.17615, 33.85106], [-118.17614, 33.85132], [-118.17569, 33.85133], [-118.17568, 33.85168], [-118.17399, 33.85169], [-118.17399, 33.85161], [-118.17397, 33.8516], [-118.17395, 33.85169], [-118.17356, 33.85169], [-118.17353, 33.85166], [-118.17353, 33.85148], [-118.17409, 33.85159], [-118.17502, 33.85146], [-118.17612, 33.85101], [-118.17661, 33.85083], [-118.17705, 33.85077], [-118.17706, 33.85079]]]]} | Open Access 1 | Jackson Park | 20321 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.994 | Jackson Park | ||
5637 | 5637 | 5636 | {"type": "Polygon", "coordinates": [[[-118.16917, 33.76286], [-118.16902, 33.7637], [-118.16866, 33.76365], [-118.16869, 33.76343], [-118.16848, 33.7634], [-118.16848, 33.76327], [-118.16805, 33.76321], [-118.16809, 33.76292], [-118.16333, 33.76211], [-118.16329, 33.76239], [-118.16467, 33.76266], [-118.16452, 33.76307], [-118.16439, 33.76304], [-118.16446, 33.76281], [-118.16445, 33.76279], [-118.16349, 33.76263], [-118.15995, 33.76196], [-118.1582, 33.76158], [-118.15644, 33.76123], [-118.15284, 33.76035], [-118.15093, 33.75983], [-118.15086, 33.76], [-118.14821, 33.75924], [-118.14824, 33.75912], [-118.14834, 33.75913], [-118.14837, 33.75898], [-118.14791, 33.75888], [-118.1482, 33.75782], [-118.15107, 33.7587], [-118.15117, 33.7588], [-118.15507, 33.75983], [-118.15767, 33.76048], [-118.16043, 33.76106], [-118.16264, 33.76158], [-118.16496, 33.76209], [-118.16842, 33.76269], [-118.16917, 33.76286]]]} | Open Access 1 | Junipero Beach | 20529 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 48.528 | Junipero Beach | ||
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 |
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]);