units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where AGNCY_WEB = "http://www.glendaleca.gov/government/city-departments/community-services-parks" and DES_TP = 2
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
250 | 250 | 249 | {"type": "Polygon", "coordinates": [[[-118.26941, 34.15733], [-118.26731, 34.15813], [-118.26727, 34.15765], [-118.26685, 34.15765], [-118.26684, 34.15655], [-118.2686, 34.15653], [-118.26939, 34.15648], [-118.2694, 34.15651], [-118.26941, 34.15733]]]} | Open Access 1 | 680 | Fremont Park | 19098 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 7.714 | Fremont Park | 0 | Local Park 2 | 4 | |
406 | 406 | 405 | {"type": "Polygon", "coordinates": [[[-118.29329, 34.16445], [-118.29239, 34.1653], [-118.29166, 34.16477], [-118.29256, 34.16391], [-118.29329, 34.16445]]]} | Open Access 1 | 1246 | Griffith Manor Park | 19516 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 2.805 | Griffith Manor Park | 0 | Local Park 2 | 4 | |
1039 | 1039 | 1038 | {"type": "Polygon", "coordinates": [[[-118.2613, 34.22804], [-118.26126, 34.22807], [-118.26112, 34.22799], [-118.26009, 34.22752], [-118.25962, 34.22724], [-118.25963, 34.22714], [-118.26005, 34.22742], [-118.26055, 34.22771], [-118.26105, 34.22794], [-118.2613, 34.22804]]]} | Open Access 1 | 6850 | Crescenta Valley Park | 17798 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.202 | Crescenta Valley Park | 0 | Local Park 2 | 4 | |
1058 | 1058 | 1057 | {"type": "Polygon", "coordinates": [[[-118.22811, 34.18711], [-118.22787, 34.18851], [-118.22784, 34.1885], [-118.22782, 34.18861], [-118.22785, 34.18863], [-118.22759, 34.19007], [-118.22734, 34.1901], [-118.22734, 34.19001], [-118.22728, 34.18982], [-118.22722, 34.18966], [-118.22712, 34.18948], [-118.22629, 34.18849], [-118.2259, 34.18796], [-118.22585, 34.1878], [-118.22586, 34.18756], [-118.2259, 34.18751], [-118.22597, 34.18748], [-118.22697, 34.18747], [-118.22777, 34.18736], [-118.22792, 34.18729], [-118.22806, 34.18714], [-118.22811, 34.18711]]]} | Open Access 1 | 6947 | Glorietta Park | 19348 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 8.61 | Glorietta Park | 0 | Local Park 2 | 4 | |
1177 | 1177 | 1176 | {"type": "Polygon", "coordinates": [[[-118.27889, 34.18179], [-118.27793, 34.18359], [-118.27783, 34.1838], [-118.27734, 34.18474], [-118.27639, 34.18401], [-118.27491, 34.18391], [-118.27505, 34.18031], [-118.27686, 34.18031], [-118.27889, 34.18179]]]} | Open Access 1 | 6848 | Brand Park | 4145 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/brand-park | Los Angeles 6 | 30.547 | Brand Park | 0 | Local Park 2 | 4 |
1179 | 1179 | 1178 | {"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.19988], [-118.24359, 34.19991]]]} | Open Access 1 | 6849 | Oakmont View Park | 23033 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 1.039 | Oakmont View Park | 0 | Local Park 2 | 4 | |
1203 | 1203 | 1202 | {"type": "Polygon", "coordinates": [[[-118.20224, 34.18028], [-118.20222, 34.18038], [-118.20222, 34.18051], [-118.20181, 34.18053], [-118.20179, 34.18078], [-118.20182, 34.18124], [-118.20177, 34.18125], [-118.2018, 34.18154], [-118.20179, 34.18154], [-118.20155, 34.18147], [-118.20095, 34.18115], [-118.20096, 34.18102], [-118.20086, 34.18095], [-118.20069, 34.18086], [-118.20042, 34.18077], [-118.20025, 34.18068], [-118.20016, 34.18061], [-118.20008, 34.18052], [-118.20002, 34.18041], [-118.19999, 34.18031], [-118.19995, 34.18025], [-118.20013, 34.1801], [-118.20067, 34.18007], [-118.20072, 34.17987], [-118.20086, 34.17974], [-118.20103, 34.17953], [-118.20134, 34.17941], [-118.20174, 34.17962], [-118.20194, 34.17986], [-118.20194, 34.17999], [-118.20186, 34.18029], [-118.20224, 34.18028]]]} | Open Access 1 | 6950 | Emerald Isle Park | 18616 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 6.204 | Emerald Isle Park | 0 | Local Park 2 | 4 | |
1204 | 1204 | 1203 | {"type": "Polygon", "coordinates": [[[-118.22149, 34.17394], [-118.2211, 34.17522], [-118.22096, 34.17516], [-118.22088, 34.1751], [-118.22025, 34.1749], [-118.21963, 34.17458], [-118.21952, 34.17411], [-118.22128, 34.17399], [-118.22131, 34.17398], [-118.22133, 34.17391], [-118.22149, 34.17394]]]} | Open Access 1 | 6951 | Mayor's Bicentennial Park | 21978 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 3.901 | Mayor's Bicentennial Park | 0 | Local Park 2 | 4 | |
1294 | 1294 | 1293 | {"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 | 5721 | Nibley Park | 22742 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 2.223 | Nibley Park | 0 | Local Park 2 | 4 | |
1342 | 1342 | 1341 | {"type": "Polygon", "coordinates": [[[-118.24873, 34.13131], [-118.24873, 34.13149], [-118.24795, 34.13149], [-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.24793, 34.13134], [-118.24794, 34.13131], [-118.24873, 34.13131]]]} | Open Access 1 | 7560 | Palmer Park | 23353 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 3.334 | Palmer Park | 0 | Local Park 2 | 4 | |
1366 | 1366 | 1365 | {"type": "Polygon", "coordinates": [[[-118.28187, 34.16241], [-118.28195, 34.16243], [-118.28198, 34.16246], [-118.28198, 34.1625], [-118.28144, 34.16435], [-118.2805, 34.16367], [-118.28181, 34.16243], [-118.28187, 34.16241]]]} | Open Access 1 | 8211 | Pelanconi Park | 23567 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 3.08 | Pelanconi Park | 0 | Local Park 2 | 4 | |
2594 | 2594 | 2593 | {"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 | 20644 | New York Park | 22711 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 1.78 | New York Park | 0 | Local Park 2 | 4 | |
4396 | 4396 | 4395 | {"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 | 46027 | Doran Gardens Mini Park | 29352 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.377 | Doran Gardens MP | 0 | Local Park 2 | 4 | |
6896 | 6896 | 6895 | {"type": "Polygon", "coordinates": [[[-118.26651, 34.14003], [-118.26593, 34.14003], [-118.26583, 34.13988], [-118.26593, 34.1398], [-118.26577, 34.13959], [-118.26554, 34.1394], [-118.26554, 34.13885], [-118.26557, 34.13885], [-118.2656, 34.13883], [-118.2665, 34.13883], [-118.26651, 34.14003]]]} | Open Access 1 | 5742 | Pacific Park | 23302 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 2.515 | Pacific Park | 0 | Local Park 2 | 4 | |
6921 | 6921 | 6920 | {"type": "Polygon", "coordinates": [[[-118.2328, 34.17325], [-118.23055, 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.17005], [-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.23185, 34.17165], [-118.23196, 34.17208], [-118.23213, 34.17233], [-118.23229, 34.17229], [-118.2328, 34.17325]], [[-118.22991, 34.16982], [-118.2299, 34.16992], [-118.22998, 34.16996], [-118.23004, 34.16995], [-118.2301, 34.16985], [-118.23016, 34.16981], [-118.23025, 34.16967], [-118.2298, 34.16948], [-118.22975, 34.16956], [-118.22962, 34.1697], [-118.22966, 34.16971], [-118.22982, 34.16973], [-118.2299, 34.16978], [-118.22991, 34.16982]]]} | Open Access 1 | 5815 | Verdugo Park | 26992 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 34.542 | Verdugo Park | 0 | Local Park 2 | 4 | |
7455 | 7455 | 7454 | {"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.22439, 34.20064], [-118.22472, 34.20048], [-118.22505, 34.2001], [-118.22519, 34.19984], [-118.22554, 34.2], [-118.22569, 34.20001], [-118.2257, 34.20005], [-118.22613, 34.20006], [-118.22667, 34.20064], [-118.22709, 34.2005], [-118.22734, 34.20062]]]} | Open Access 1 | 6944 | Montrose Community Park | 22442 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 15.081 | Montrose Community Park | 0 | Local Park 2 | 4 | |
7463 | 7463 | 7462 | {"type": "Polygon", "coordinates": [[[-118.21019, 34.15242], [-118.21018, 34.15244], [-118.2097, 34.15268], [-118.20966, 34.15269], [-118.20919, 34.15195], [-118.20912, 34.1518], [-118.20915, 34.15177], [-118.2096, 34.15154], [-118.20964, 34.15152], [-118.20969, 34.15154], [-118.20992, 34.1519], [-118.21019, 34.1524], [-118.21019, 34.15242]]]} | Open Access 1 | 6960 | Glenoaks Park | 19335 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 1.701 | Glenoaks Park | 0 | Local Park 2 | 4 | |
7543 | 7543 | 7542 | {"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 | 20649 | Milford Mini Park | 22221 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.264 | Milford MP | 0 | Local Park 2 | 4 | |
7982 | 7982 | 7981 | {"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 | 20651 | Wilson Mini Park | 27605 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.323 | Wilson MP | 0 | Local Park 2 | 4 | |
7983 | 7983 | 7982 | {"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 | 20652 | Elk Mini Park | 18564 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.316 | Elk MP | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);