superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3684 | 3684 | 3683 | {"type": "Polygon", "coordinates": [[[-118.17515, 33.78271], [-118.17514, 33.78433], [-118.17425, 33.78433], [-118.17426, 33.78271], [-118.17515, 33.78271]]]} | Open Access 1 | Douglas MacArthur Park | 18245 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.647 | Douglas MacArthur Park | ||
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 | ||
15551 | 15551 | 15550 | {"type": "Polygon", "coordinates": [[[-118.09007, 33.81023], [-118.0898, 33.81023], [-118.08979, 33.81025], [-118.08952, 33.81025], [-118.08951, 33.81028], [-118.08939, 33.81028], [-118.08938, 33.81031], [-118.08901, 33.81031], [-118.08899, 33.81032], [-118.087, 33.81031], [-118.08681, 33.8103], [-118.08646, 33.81026], [-118.08528, 33.81025], [-118.08526, 33.80869], [-118.08528, 33.80858], [-118.08528, 33.80779], [-118.0838, 33.8078], [-118.08379, 33.80661], [-118.08225, 33.8066], [-118.0825, 33.80624], [-118.08262, 33.8061], [-118.08326, 33.80558], [-118.08379, 33.80511], [-118.08429, 33.80462], [-118.0848, 33.80407], [-118.08488, 33.80402], [-118.085, 33.80397], [-118.08519, 33.80394], [-118.08609, 33.80401], [-118.0878, 33.80432], [-118.08845, 33.8044], [-118.08878, 33.80441], [-118.08879, 33.80434], [-118.08978, 33.80435], [-118.09007, 33.81023]]]} | Open Access 1 | El Dorado Nature Center | 18502 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 87.566 | El Dorado Nature Ctr. | 1998 | |
4202 | 4202 | 4201 | {"type": "MultiPolygon", "coordinates": [[[[-118.18761, 33.80427], [-118.18745, 33.80427], [-118.18686, 33.80389], [-118.18692, 33.80382], [-118.18716, 33.80389], [-118.1873, 33.80394], [-118.18759, 33.80413], [-118.18761, 33.80416], [-118.18761, 33.80427]]], [[[-118.18785, 33.80426], [-118.18769, 33.80427], [-118.18769, 33.80415], [-118.18769, 33.80415], [-118.18785, 33.80426]]]]} | Open Access 1 | Fellowship Park | 18869 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.365 | Fellowship 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 | |
4995 | 4995 | 4994 | {"type": "MultiPolygon", "coordinates": [[[[-118.11639, 33.83036], [-118.11638, 33.83207], [-118.11633, 33.83212], [-118.10791, 33.83209], [-118.10789, 33.83205], [-118.1079, 33.83031], [-118.10859, 33.83031], [-118.10861, 33.83034], [-118.11639, 33.83036]]], [[[-118.125, 33.83134], [-118.12426, 33.83136], [-118.12427, 33.83168], [-118.12499, 33.83168], [-118.12499, 33.83216], [-118.1168, 33.83213], [-118.11674, 33.83208], [-118.11672, 33.83131], [-118.11672, 33.83032], [-118.125, 33.83035], [-118.125, 33.83134]]], [[[-118.1337, 33.83037], [-118.13369, 33.8321], [-118.13362, 33.83217], [-118.12534, 33.83215], [-118.12534, 33.83154], [-118.12601, 33.83153], [-118.12601, 33.83087], [-118.12532, 33.83085], [-118.12532, 33.83035], [-118.1337, 33.83037]]]]} | Open Access 1 | Heartwell Park | 19777 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 112.265 | Heartwell Park | ||
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 | ||
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 | ||
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 | ||
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 |
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]);