superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
53 rows where MNG_AGENCY = 100
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6995 | 6995 | 6994 | {"type": "Polygon", "coordinates": [[[-118.26713, 34.15245], [-118.26713, 34.15277], [-118.2668, 34.15277], [-118.2668, 34.15246], [-118.26713, 34.15245]]]} | Open Access 1 | Milford Mini Park | 22221 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.264 | Milford MP | ||
7168 | 7168 | 7167 | {"type": "Polygon", "coordinates": [[[-118.22734, 34.20062], [-118.22717, 34.20088], [-118.22704, 34.20115], [-118.227, 34.20129], [-118.22604, 34.20271], [-118.22576, 34.20258], [-118.22561, 34.2027], [-118.22415, 34.20202], [-118.2243, 34.20123], [-118.22357, 34.20119], [-118.22361, 34.20088], [-118.22438, 34.20064], [-118.22472, 34.20048], [-118.22505, 34.2001], [-118.22519, 34.19984], [-118.22554, 34.2], [-118.22569, 34.20001], [-118.22571, 34.20005], [-118.22613, 34.20006], [-118.22667, 34.20064], [-118.22709, 34.2005], [-118.22734, 34.20062]]]} | Open Access 1 | Montrose Community Park | 22442 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 15.092 | Montrose Community 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 | ||
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 | ||
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 | ||
7848 | 7848 | 7847 | {"type": "Polygon", "coordinates": [[[-118.26651, 34.14003], [-118.26593, 34.14003], [-118.26583, 34.13988], [-118.26592, 34.13979], [-118.26577, 34.13959], [-118.26554, 34.1394], [-118.26554, 34.13885], [-118.2656, 34.13883], [-118.2665, 34.13883], [-118.26651, 34.14003]]]} | Open Access 1 | Pacific Park | 23302 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 2.517 | Pacific Park | ||
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 | ||
8067 | 8067 | 8066 | {"type": "Polygon", "coordinates": [[[-118.28198, 34.16246], [-118.28198, 34.1625], [-118.28144, 34.16435], [-118.2805, 34.16367], [-118.28181, 34.16243], [-118.28187, 34.16241], [-118.28195, 34.16243], [-118.28198, 34.16246]]]} | Open Access 1 | Pelanconi Park | 23567 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 3.079 | Pelanconi Park | ||
8131 | 8131 | 8130 | {"type": "MultiPolygon", "coordinates": [[[[-118.24092, 34.15301], [-118.24091, 34.15305], [-118.24087, 34.15307], [-118.24062, 34.15306], [-118.24056, 34.15302], [-118.24055, 34.15297], [-118.24058, 34.15281], [-118.24057, 34.15262], [-118.24059, 34.15255], [-118.24065, 34.15249], [-118.24073, 34.15247], [-118.24078, 34.15248], [-118.24083, 34.15251], [-118.24087, 34.15257], [-118.24089, 34.15264], [-118.24088, 34.15286], [-118.24092, 34.15301]]], [[[-118.24079, 34.15191], [-118.24075, 34.15204], [-118.24074, 34.1523], [-118.24071, 34.15231], [-118.24071, 34.15211], [-118.24066, 34.15192], [-118.24068, 34.15187], [-118.24072, 34.15186], [-118.24077, 34.15187], [-118.24079, 34.15191]]]]} | Open Access 1 | Piedmont Park | 23658 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.515 | Piedmont Park | ||
8347 | 8347 | 8346 | {"type": "Polygon", "coordinates": [[[-118.20232, 34.16387], [-118.20106, 34.1656], [-118.19947, 34.16766], [-118.19941, 34.16746], [-118.19749, 34.16476], [-118.19693, 34.16344], [-118.19695, 34.1634], [-118.19691, 34.16337], [-118.19799, 34.1627], [-118.19908, 34.16182], [-118.19934, 34.16179], [-118.19954, 34.16174], [-118.20232, 34.16387]]]} | Open Access 1 | Poulsen Open Space | 23929 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 42.17 | Poulsen OS | ||
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 | ||
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. | |
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. | ||
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 | |
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 | ||
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 | |
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 | ||
12372 | 12372 | 12371 | {"type": "Polygon", "coordinates": [[[-118.25959, 34.15416], [-118.25912, 34.15417], [-118.25912, 34.15385], [-118.25959, 34.15384], [-118.25959, 34.15416]]]} | Open Access 1 | Doran Gardens Mini Park | 29352 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.376 | Doran Gardens MP | ||
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 | |
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 |
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]);