superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
53 rows where MNG_AGENCY = 100 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10850 | 10850 | 10849 | {"type": "Polygon", "coordinates": [[[-118.23092, 34.19922], [-118.23089, 34.19923], [-118.23031, 34.19921], [-118.23026, 34.19919], [-118.23025, 34.19914], [-118.23034, 34.19874], [-118.23037, 34.19871], [-118.23041, 34.19871], [-118.23092, 34.19917], [-118.23092, 34.19922]]]} | Restricted Access 2 | Sparr Heights Community Center | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/sparr-heights-community-center | 29349 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.503 | Sparr Heights Community Ctr. | |
10852 | 10852 | 10851 | {"type": "Polygon", "coordinates": [[[-118.2315, 34.16842], [-118.23133, 34.16937], [-118.23121, 34.16952], [-118.23103, 34.1697], [-118.22982, 34.1692], [-118.23013, 34.16875], [-118.23049, 34.16829], [-118.2315, 34.16842]]]} | Open Access 1 | Stengel Field | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/stengel-field- | 29377 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 3.852 | Stengel Field | |
10785 | 10785 | 10784 | {"type": "Polygon", "coordinates": [[[-118.2328, 34.17325], [-118.23056, 34.17377], [-118.23078, 34.17435], [-118.23047, 34.17432], [-118.22915, 34.17433], [-118.22914, 34.17309], [-118.22915, 34.1719], [-118.22924, 34.17122], [-118.22935, 34.17064], [-118.22937, 34.17044], [-118.22936, 34.17013], [-118.22943, 34.17004], [-118.22939, 34.16986], [-118.22982, 34.1692], [-118.23103, 34.1697], [-118.23121, 34.16952], [-118.23133, 34.16937], [-118.2315, 34.16842], [-118.23194, 34.16835], [-118.23188, 34.1685], [-118.23187, 34.16867], [-118.23192, 34.1688], [-118.23206, 34.16902], [-118.23167, 34.16953], [-118.23228, 34.16985], [-118.23221, 34.17018], [-118.23216, 34.17084], [-118.2321, 34.17121], [-118.23206, 34.17168], [-118.23187, 34.17164], [-118.23186, 34.17165], [-118.23196, 34.17208], [-118.23213, 34.17233], [-118.23229, 34.17229], [-118.2328, 34.17325]], [[-118.22991, 34.16982], [-118.22991, 34.16992], [-118.22998, 34.16996], [-118.23004, 34.16995], [-118.2301, 34.16985], [-118.23016, 34.16981], [-118.23024, 34.16967], [-118.2298, 34.16949], [-118.22963, 34.1697], [-118.22966, 34.16971], [-118.22982, 34.16973], [-118.2299, 34.16978], [-118.22991, 34.16982]]]} | Open Access 1 | Verdugo Park | 26992 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 34.567 | Verdugo Park | ||
12390 | 12390 | 12389 | {"type": "Polygon", "coordinates": [[[-118.23294, 34.17995], [-118.23284, 34.17996], [-118.23285, 34.18027], [-118.23288, 34.18032], [-118.23246, 34.18032], [-118.23244, 34.18011], [-118.23197, 34.18011], [-118.23196, 34.17969], [-118.23239, 34.17952], [-118.23246, 34.17959], [-118.23272, 34.17974], [-118.23281, 34.17974], [-118.23292, 34.1797], [-118.23294, 34.17995]]]} | Open Access 1 | Catalina Verdugo Adobe | 29372 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.315 | Catalina Verdugo Adobe | ||
736 | 736 | 735 | {"type": "Polygon", "coordinates": [[[-118.2377, 34.13672], [-118.2377, 34.13703], [-118.23769, 34.13707], [-118.23763, 34.1371], [-118.23732, 34.13718], [-118.23732, 34.13682], [-118.2377, 34.13672]]]} | Open Access 1 | Windsor Mini Park | 27636 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.347 | Windsor MP | ||
7371 | 7371 | 7370 | {"type": "Polygon", "coordinates": [[[-118.23911, 34.16359], [-118.23908, 34.1641], [-118.23858, 34.16458], [-118.23833, 34.16471], [-118.23779, 34.16437], [-118.23808, 34.16399], [-118.2382, 34.16388], [-118.23833, 34.16378], [-118.23854, 34.16368], [-118.23874, 34.16362], [-118.23892, 34.16359], [-118.23911, 34.16359]]]} | Open Access 1 | Nibley Park | 22742 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 2.222 | Nibley Park | ||
11301 | 11301 | 11300 | {"type": "Polygon", "coordinates": [[[-118.24171, 34.14819], [-118.24171, 34.14857], [-118.24138, 34.14857], [-118.24138, 34.14818], [-118.24171, 34.14819]]]} | Open Access 1 | Wilson Mini Park | 27605 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.323 | Wilson MP | ||
455 | 455 | 454 | {"type": "Polygon", "coordinates": [[[-118.24223, 34.1324], [-118.24222, 34.13246], [-118.24219, 34.13251], [-118.24215, 34.13255], [-118.24208, 34.13257], [-118.24186, 34.13257], [-118.24179, 34.1323], [-118.24191, 34.1323], [-118.2419, 34.13224], [-118.24215, 34.13224], [-118.24223, 34.1324]]]} | Open Access 1 | Adams Square Park | 15264 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.293 | Adams Square Park | ||
7607 | 7607 | 7606 | {"type": "Polygon", "coordinates": [[[-118.24359, 34.19991], [-118.24357, 34.20027], [-118.24358, 34.20061], [-118.24299, 34.20061], [-118.24297, 34.20045], [-118.24299, 34.20029], [-118.24319, 34.19973], [-118.24326, 34.19984], [-118.24331, 34.19987], [-118.24359, 34.19991]]]} | Open Access 1 | Oakmont View Park | 23033 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.039 | Oakmont View Park | ||
12380 | 12380 | 12379 | {"type": "Polygon", "coordinates": [[[-118.24489, 34.14498], [-118.24441, 34.14498], [-118.2444, 34.14455], [-118.24489, 34.14455], [-118.24489, 34.14498]]]} | Open Access 1 | Glendale Heritage Garden | http://www.glendaleca.gov/government/city-departments/community-development/parks-facilities-historic-sites | 29346 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.522 | Glendale Heritage Garden | |
3946 | 3946 | 3945 | {"type": "Polygon", "coordinates": [[[-118.24545, 34.14167], [-118.24511, 34.14167], [-118.24511, 34.1413], [-118.24545, 34.1413], [-118.24545, 34.14167]]]} | Open Access 1 | Elk Mini Park | 18564 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.316 | Elk MP | ||
15513 | 15513 | 15512 | {"type": "Polygon", "coordinates": [[[-118.24617, 34.13854], [-118.24617, 34.13892], [-118.24479, 34.13892], [-118.24396, 34.13894], [-118.24396, 34.13817], [-118.24548, 34.13816], [-118.24549, 34.13854], [-118.24617, 34.13854]]]} | Open Access 1 | Maple Park & Community Center | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/maple-park-and-community-center | 29370 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 3.586 | Maple Park & Community Ctr. | |
7882 | 7882 | 7881 | {"type": "Polygon", "coordinates": [[[-118.24873, 34.13131], [-118.24873, 34.13149], [-118.24795, 34.1315], [-118.248, 34.13258], [-118.24703, 34.13258], [-118.24698, 34.13222], [-118.2465, 34.13213], [-118.24645, 34.13206], [-118.24711, 34.13179], [-118.24738, 34.13145], [-118.24766, 34.13134], [-118.24792, 34.13134], [-118.24794, 34.13131], [-118.24873, 34.13131]]]} | Open Access 1 | Palmer Park | 23353 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 3.344 | Palmer Park | ||
11565 | 11565 | 11564 | {"type": "Polygon", "coordinates": [[[-118.25358, 34.13679], [-118.25312, 34.1368], [-118.25312, 34.13653], [-118.2531, 34.13652], [-118.2531, 34.13638], [-118.25357, 34.13638], [-118.25358, 34.13679]]]} | Open Access 1 | Maryland Avenue Park | http://www.parks.ca.gov/?Page_id=26462 | 28047 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.482 | Maryland Avenue Park | |
7344 | 7344 | 7343 | {"type": "Polygon", "coordinates": [[[-118.25416, 34.23366], [-118.25404, 34.23433], [-118.25313, 34.23376], [-118.25314, 34.23305], [-118.25416, 34.23366]]]} | Open Access 1 | New York Park | 22711 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.78 | New York Park | ||
10851 | 10851 | 10850 | {"type": "Polygon", "coordinates": [[[-118.25429, 34.14353], [-118.25348, 34.14354], [-118.25269, 34.14354], [-118.25268, 34.14271], [-118.25429, 34.14269], [-118.25429, 34.14353]]]} | Open Access 1 | Central Park & Adult Recreation Center | 29376 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 3.389 | Central Park & Adult Rec. Ctr. | ||
12267 | 12267 | 12266 | {"type": "Polygon", "coordinates": [[[-118.25475, 34.12403], [-118.25415, 34.1241], [-118.25411, 34.12381], [-118.2542, 34.12358], [-118.25403, 34.12342], [-118.25422, 34.12328], [-118.25473, 34.12377], [-118.25477, 34.1239], [-118.25475, 34.12403]]]} | Open Access 1 | Cerritos Mini Park | 29371 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.89 | Cerritos MP | ||
469 | 469 | 468 | {"type": "Polygon", "coordinates": [[[-118.25518, 34.24981], [-118.25477, 34.25004], [-118.25479, 34.2503], [-118.25458, 34.25024], [-118.25397, 34.24973], [-118.25322, 34.25049], [-118.25252, 34.25095], [-118.25201, 34.25117], [-118.2518, 34.25157], [-118.25125, 34.25139], [-118.25086, 34.25122], [-118.25062, 34.25126], [-118.25024, 34.25107], [-118.25114, 34.25038], [-118.25163, 34.25013], [-118.25249, 34.24973], [-118.25319, 34.249], [-118.25371, 34.24856], [-118.25395, 34.2483], [-118.25432, 34.24838], [-118.25433, 34.2485], [-118.25438, 34.24862], [-118.25452, 34.24874], [-118.25454, 34.24895], [-118.25447, 34.2491], [-118.25432, 34.24923], [-118.25414, 34.24935], [-118.25413, 34.24936], [-118.25481, 34.24969], [-118.25518, 34.24981]]]} | Open Access 1 | Deukmejian Wilderness Park | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/deukmejian-wilderness-park | 4154 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 13.185 | Deukmejian Wilderness Park | |
12381 | 12381 | 12380 | {"type": "Polygon", "coordinates": [[[-118.25572, 34.14912], [-118.25522, 34.14913], [-118.25522, 34.14905], [-118.25572, 34.14904], [-118.25572, 34.14912]]]} | Open Access 1 | Chess Park | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/chess-park-photos | 29350 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.1 | Chess Park | |
3739 | 3739 | 3738 | {"type": "Polygon", "coordinates": [[[-118.25725, 34.23852], [-118.25724, 34.24032], [-118.25491, 34.23887], [-118.25501, 34.23876], [-118.25518, 34.23874], [-118.25518, 34.23724], [-118.25725, 34.23852]]]} | Open Access 1 | Dunsmore Park | 18307 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 9.506 | Dunsmore 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]);