superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
465 rows where MNG_AGENCY = 24
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7389 | 7389 | 7388 | {"type": "Polygon", "coordinates": [[[-118.30014, 34.04536], [-118.29922, 34.04533], [-118.29922, 34.04401], [-118.30011, 34.04389], [-118.30014, 34.04391], [-118.30014, 34.04536]]]} | Open Access 1 | Normandie Playground | 22801 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.266 | Normandie Playground | ||
7420 | 7420 | 7419 | {"type": "Polygon", "coordinates": [[[-118.35858, 34.00041], [-118.35763, 34.00065], [-118.35669, 33.99999], [-118.35658, 33.99999], [-118.35652, 33.99996], [-118.35658, 33.99981], [-118.35666, 33.99953], [-118.35687, 33.99825], [-118.35694, 33.99803], [-118.35703, 33.99787], [-118.35722, 33.99764], [-118.35746, 33.99746], [-118.35771, 33.99735], [-118.35777, 33.99738], [-118.35809, 33.9993], [-118.35813, 33.9995], [-118.35824, 33.9998], [-118.35835, 34.00003], [-118.35858, 34.00041]]]} | Open Access 1 | Norman O. Houston Park | 22797 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.496 | Norman O. Houston Park | ||
7426 | 7426 | 7425 | {"type": "Polygon", "coordinates": [[[-118.2731, 34.13143], [-118.27238, 34.13344], [-118.27177, 34.13345], [-118.27176, 34.1313], [-118.27296, 34.1313], [-118.27298, 34.13127], [-118.27305, 34.13127], [-118.2731, 34.13143]]]} | Open Access 1 | North Atwater Park | 22805 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.385 | North Atwater Park | ||
7432 | 7432 | 7431 | {"type": "Polygon", "coordinates": [[[-118.30142, 33.82395], [-118.29959, 33.82397], [-118.29959, 33.82333], [-118.29946, 33.82332], [-118.29945, 33.82232], [-118.30141, 33.82231], [-118.30142, 33.82395]]]} | Open Access 1 | Normandale Recreation Center | 22800 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 7.97 | Normandale Rec. Ctr. | ||
7440 | 7440 | 7439 | {"type": "Polygon", "coordinates": [[[-118.46718, 34.23094], [-118.46568, 34.23093], [-118.46569, 34.22986], [-118.46572, 34.22988], [-118.46643, 34.22989], [-118.46646, 34.22987], [-118.46646, 34.22984], [-118.46669, 34.23011], [-118.46686, 34.23034], [-118.46703, 34.23063], [-118.46718, 34.23094]]]} | Open Access 1 | North Hills Community Park | 22823 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.153 | North Hills Community Park | ||
7441 | 7441 | 7440 | {"type": "MultiPolygon", "coordinates": [[[[-118.38194, 34.16461], [-118.38166, 34.16467], [-118.38168, 34.1648], [-118.37909, 34.1648], [-118.37909, 34.16221], [-118.37913, 34.16219], [-118.37913, 34.16182], [-118.37913, 34.1613], [-118.37908, 34.16128], [-118.37908, 34.15962], [-118.3791, 34.1596], [-118.37916, 34.15894], [-118.37922, 34.1589], [-118.37945, 34.15917], [-118.3796, 34.15913], [-118.37965, 34.15929], [-118.37981, 34.15962], [-118.38037, 34.16069], [-118.38135, 34.16306], [-118.38194, 34.16461]]], [[[-118.38348, 34.16829], [-118.38339, 34.16829], [-118.38338, 34.1683], [-118.38282, 34.1683], [-118.38265, 34.16822], [-118.38217, 34.16815], [-118.38163, 34.168], [-118.38136, 34.16795], [-118.37909, 34.16795], [-118.37909, 34.16756], [-118.37911, 34.16754], [-118.37911, 34.16751], [-118.37909, 34.1675], [-118.37909, 34.16709], [-118.37911, 34.16707], [-118.37911, 34.16691], [-118.37909, 34.1669], [-118.37909, 34.16499], [-118.38187, 34.16499], [-118.3819, 34.16508], [-118.38202, 34.16523], [-118.38207, 34.16535], [-118.38221, 34.16533], [-118.38221, 34.16539], [-118.38235, 34.16578], [-118.38249, 34.16611], [-118.38348, 34.16829]]]]} | Open Access 1 | North Hollywood Park | 22824 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 53.014 | North Hollywood Park | ||
7473 | 7473 | 7472 | {"type": "Polygon", "coordinates": [[[-118.36859, 34.14674], [-118.36749, 34.14674], [-118.3674, 34.14663], [-118.3674, 34.14632], [-118.36716, 34.14632], [-118.36695, 34.14604], [-118.36602, 34.14589], [-118.36593, 34.14584], [-118.36573, 34.14583], [-118.36573, 34.1452], [-118.36577, 34.14509], [-118.36583, 34.145], [-118.36583, 34.14401], [-118.36681, 34.14404], [-118.36731, 34.14467], [-118.36781, 34.14566], [-118.36859, 34.14674]]]} | Open Access 1 | North Weddington Park | 22864 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 10.167 | North Weddington Park | ||
7549 | 7549 | 7548 | {"type": "Polygon", "coordinates": [[[-118.446, 34.13918], [-118.44599, 34.13919], [-118.44597, 34.13919], [-118.44542, 34.13894], [-118.44542, 34.13891], [-118.446, 34.13918]]]} | Open Access 1 | Oak Forest West Access | 22965 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.044 | Oak Forest West Access | ||
7759 | 7759 | 7758 | {"type": "Polygon", "coordinates": [[[-118.31904, 34.27061], [-118.31739, 34.27184], [-118.31705, 34.27189], [-118.31679, 34.27195], [-118.31654, 34.27201], [-118.31592, 34.27222], [-118.31585, 34.2722], [-118.31584, 34.27218], [-118.31584, 34.27187], [-118.3158, 34.27185], [-118.31581, 34.2706], [-118.31904, 34.27061]]]} | Open Access 1 | Oro Vista Park | 23209 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.225 | Oro Vista Park | ||
7885 | 7885 | 7884 | {"type": "Polygon", "coordinates": [[[-118.41789, 34.03357], [-118.41779, 34.03361], [-118.4177, 34.03353], [-118.41757, 34.03334], [-118.41748, 34.03341], [-118.41759, 34.0336], [-118.41767, 34.0337], [-118.41738, 34.03386], [-118.41757, 34.03413], [-118.41704, 34.03441], [-118.41665, 34.03371], [-118.41633, 34.03326], [-118.41652, 34.03316], [-118.41673, 34.03311], [-118.41679, 34.03316], [-118.4169, 34.03309], [-118.41687, 34.03304], [-118.41751, 34.03264], [-118.41755, 34.03265], [-118.41766, 34.03279], [-118.41691, 34.03321], [-118.41711, 34.03345], [-118.41744, 34.0333], [-118.41758, 34.0332], [-118.41781, 34.03349], [-118.41789, 34.03357]]]} | Open Access 1 | Palms Park | 23357 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.75 | Palms Park | ||
7898 | 7898 | 7897 | {"type": "Polygon", "coordinates": [[[-118.35623, 34.07486], [-118.35519, 34.07487], [-118.35519, 34.07602], [-118.35332, 34.07604], [-118.35331, 34.07573], [-118.35376, 34.07571], [-118.3537, 34.07347], [-118.35455, 34.07345], [-118.35465, 34.07169], [-118.35463, 34.07167], [-118.35399, 34.07165], [-118.35397, 34.07085], [-118.35328, 34.07074], [-118.35326, 34.0705], [-118.35488, 34.07077], [-118.35621, 34.07092], [-118.35623, 34.07486]]]} | Open Access 1 | Pan Pacific Park | 23384 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 26.262 | Pan Pacific Park | ||
7918 | 7918 | 7917 | {"type": "Polygon", "coordinates": [[[-118.44216, 34.22785], [-118.44214, 34.22788], [-118.44095, 34.22851], [-118.44091, 34.22851], [-118.43989, 34.22719], [-118.44116, 34.22652], [-118.44215, 34.22783], [-118.44216, 34.22785]]]} | Open Access 1 | Panorama Recreation Center | 23393 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.983 | Panorama Rec. Ctr. | ||
7995 | 7995 | 7994 | {"type": "Polygon", "coordinates": [[[-118.59935, 34.22803], [-118.59933, 34.22806], [-118.59929, 34.22807], [-118.59851, 34.22806], [-118.59851, 34.2274], [-118.59935, 34.2274], [-118.59935, 34.22803]]]} | Open Access 1 | Parthenia Park | 23485 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.413 | Parthenia Park | ||
8036 | 8036 | 8035 | {"type": "Polygon", "coordinates": [[[-118.43921, 34.26819], [-118.43853, 34.26946], [-118.43808, 34.26979], [-118.43659, 34.26838], [-118.43713, 34.26827], [-118.43745, 34.26823], [-118.43921, 34.26819]]]} | Open Access 1 | Paxton Park | 23537 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.753 | Paxton Park | ||
8051 | 8051 | 8050 | {"type": "MultiPolygon", "coordinates": [[[[-118.30941, 33.74716], [-118.30905, 33.74992], [-118.30655, 33.74992], [-118.30653, 33.75195], [-118.29918, 33.75195], [-118.29869, 33.75043], [-118.29877, 33.75041], [-118.29876, 33.75009], [-118.29899, 33.7501], [-118.299, 33.74996], [-118.29939, 33.74995], [-118.2994, 33.7493], [-118.29992, 33.74931], [-118.30002, 33.74933], [-118.30002, 33.75029], [-118.30005, 33.75031], [-118.30005, 33.75063], [-118.30097, 33.75064], [-118.30098, 33.75155], [-118.30151, 33.75155], [-118.30153, 33.75144], [-118.30207, 33.75144], [-118.30209, 33.75111], [-118.30232, 33.7511], [-118.30232, 33.75064], [-118.30245, 33.75063], [-118.30245, 33.75032], [-118.30281, 33.7503], [-118.3028, 33.75018], [-118.30265, 33.75018], [-118.30266, 33.74988], [-118.30273, 33.74988], [-118.30283, 33.74985], [-118.30297, 33.74976], [-118.30304, 33.74963], [-118.30303, 33.74947], [-118.30306, 33.74944], [-118.30357, 33.74943], [-118.30358, 33.74897], [-118.30385, 33.74897], [-118.30385, 33.74863], [-118.30391, 33.74862], [-118.304, 33.74858], [-118.30425, 33.74837], [-118.3043, 33.74831], [-118.30473, 33.74832], [-118.30474, 33.74818], [-118.30654, 33.74818], [-118.30655, 33.74709], [-118.30658, 33.74706], [-118.30661, 33.74705], [-118.30864, 33.74706], [-118.30903, 33.74708], [-118.30937, 33.74713], [-118.30941, 33.74716]]], [[[-118.30098, 33.74904], [-118.30071, 33.74905], [-118.30006, 33.74885], [-118.29989, 33.74895], [-118.29989, 33.74917], [-118.29941, 33.74917], [-118.29941, 33.74883], [-118.29967, 33.74883], [-118.29968, 33.74851], [-118.30055, 33.74851], [-118.30055, 33.74883], [-118.30098, 33.74884], [-118.30098, 33.74904]]]]} | Open Access 1 | Peck Park and Community Center | 23556 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 66.703 | Peck Park and Community Ctr. | ||
8073 | 8073 | 8072 | {"type": "Polygon", "coordinates": [[[-118.31416, 34.09327], [-118.31383, 34.09327], [-118.31383, 34.09286], [-118.31416, 34.09286], [-118.31416, 34.09327]]]} | Open Access 1 | Seily Rodriguez Park | 25288 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.344 | Seily Rodriguez Park | ||
8090 | 8090 | 8089 | {"type": "Polygon", "coordinates": [[[-118.45939, 34.0057], [-118.45587, 34.00756], [-118.4551, 34.00656], [-118.45684, 34.00566], [-118.45688, 34.00569], [-118.45867, 34.00476], [-118.45939, 34.0057]]]} | Open Access 1 | Penmar Recreation Center | 23586 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 12.169 | Penmar Rec. Ctr. | ||
8103 | 8103 | 8102 | {"type": "Polygon", "coordinates": [[[-118.254, 34.04804], [-118.2528, 34.04933], [-118.25195, 34.04877], [-118.25315, 34.04749], [-118.254, 34.04804]]]} | Open Access 1 | Pershing Square | 23619 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.434 | Pershing Square | ||
8130 | 8130 | 8129 | {"type": "Polygon", "coordinates": [[[-118.28465, 34.04135], [-118.28428, 34.04135], [-118.28427, 34.04052], [-118.28434, 34.04052], [-118.28436, 34.04058], [-118.28464, 34.04058], [-118.28465, 34.04135]]]} | Open Access 1 | Pico Union Park | 23657 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.722 | Pico Union Park | ||
8273 | 8273 | 8272 | {"type": "MultiPolygon", "coordinates": [[[[-118.28571, 33.70795], [-118.28557, 33.70813], [-118.28545, 33.70824], [-118.28531, 33.70832], [-118.28513, 33.7085], [-118.28504, 33.70839], [-118.28553, 33.7081], [-118.28558, 33.70795], [-118.28571, 33.70795]]], [[[-118.30561, 33.71193], [-118.30525, 33.71265], [-118.30517, 33.71261], [-118.30177, 33.71122], [-118.29937, 33.71073], [-118.29871, 33.71067], [-118.29868, 33.71063], [-118.29868, 33.7106], [-118.29891, 33.71015], [-118.2989, 33.71013], [-118.2987, 33.71012], [-118.29845, 33.71064], [-118.29755, 33.71043], [-118.29633, 33.70938], [-118.29561, 33.70905], [-118.29491, 33.70831], [-118.29436, 33.70704], [-118.29206, 33.70604], [-118.29175, 33.70592], [-118.29138, 33.70582], [-118.29113, 33.70577], [-118.29062, 33.70571], [-118.29009, 33.70572], [-118.28951, 33.70579], [-118.28926, 33.70585], [-118.28878, 33.70601], [-118.28777, 33.70645], [-118.28776, 33.70673], [-118.28737, 33.70689], [-118.28713, 33.7065], [-118.287, 33.70659], [-118.28685, 33.70664], [-118.28652, 33.7067], [-118.2863, 33.70676], [-118.28602, 33.70697], [-118.28586, 33.7072], [-118.28581, 33.70734], [-118.28576, 33.70761], [-118.28571, 33.70779], [-118.28562, 33.70779], [-118.28567, 33.70761], [-118.28575, 33.70719], [-118.28599, 33.70683], [-118.28634, 33.70666], [-118.28693, 33.70653], [-118.28743, 33.70623], [-118.28772, 33.70597], [-118.28875, 33.70543], [-118.29059, 33.70521], [-118.29106, 33.70521], [-118.29143, 33.70532], [-118.2925, 33.70517], [-118.29494, 33.70637], [-118.29516, 33.70697], [-118.29508, 33.7076], [-118.29556, 33.70845], [-118.29666, 33.70914], [-118.29764, 33.7097], [-118.29897, 33.70991], [-118.3006, 33.71011], [-118.3016, 33.71051], [-118.30274, 33.71118], [-118.30343, 33.71128], [-118.30448, 33.71172], [-118.30561, 33.71193]]]]} | Open Access 1 | Point Fermin Park | 23850 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 33.597 | Point Fermin 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]);