units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 100 and MNG_AG_TYP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST, GAP_STS
DES_TP 8
- Local Park 30
- Local Recreation Area 24
- Local Conservation Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 61 ✖
MNG_AGENCY 1
- Glendale, City of · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13053 | 13053 | 13052 | {"type": "Polygon", "coordinates": [[[-118.24215, 34.13224], [-118.24223, 34.1324], [-118.24223, 34.13246], [-118.24219, 34.13251], [-118.24215, 34.13255], [-118.24209, 34.13257], [-118.24186, 34.13257], [-118.24179, 34.1323], [-118.24191, 34.1323], [-118.2419, 34.13224], [-118.24215, 34.13224]]]} | Open Access 1 | 34907 | Adams Square Park | 15264 | 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.292 | Adams Square Park | 0 | Local Park 2 | 4 | |
15166 | 15166 | 15165 | {"type": "Polygon", "coordinates": [[[-118.22889, 34.17235], [-118.22885, 34.17311], [-118.22852, 34.17309], [-118.22846, 34.17311], [-118.2284, 34.17322], [-118.22786, 34.17311], [-118.22818, 34.17231], [-118.22889, 34.17235]]]} | Open Access 1 | 46053 | Babe Herman Little League Field | 29382 | 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/babe-herman-little-league-field-photos#ad-image-1 | Los Angeles 6 | 1.758 | Babe Herman Little League Field | 0 | Local Recreation Area 3 | 4 |
1034 | 1034 | 1033 | {"type": "MultiPolygon", "coordinates": [[[[-118.23666, 34.17567], [-118.23647, 34.17586], [-118.23619, 34.17567], [-118.23572, 34.17578], [-118.23554, 34.17587], [-118.23499, 34.17561], [-118.23476, 34.17536], [-118.23454, 34.17541], [-118.23446, 34.17549], [-118.234, 34.17501], [-118.23397, 34.17453], [-118.23454, 34.17416], [-118.23381, 34.17346], [-118.23415, 34.17304], [-118.23413, 34.17291], [-118.23421, 34.17251], [-118.2343, 34.17251], [-118.23447, 34.17271], [-118.23477, 34.17283], [-118.23504, 34.17279], [-118.23504, 34.17283], [-118.23508, 34.17287], [-118.23516, 34.17287], [-118.23518, 34.17285], [-118.23524, 34.17296], [-118.23558, 34.17323], [-118.23509, 34.17382], [-118.23608, 34.17433], [-118.23613, 34.17509], [-118.23627, 34.17509], [-118.23633, 34.1751], [-118.23648, 34.17532], [-118.23654, 34.17532], [-118.23656, 34.17545], [-118.2366, 34.17554], [-118.23666, 34.17561], [-118.23666, 34.17567]]], [[[-118.23693, 34.17586], [-118.23692, 34.17586], [-118.23663, 34.17592], [-118.23676, 34.17579], [-118.23693, 34.17586]]]]} | Open Access 1 | 6844 | Bachman Open Space | 15749 | 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 | 12.374 | Bachman OS | 0 | Local Recreation Area 3 | 4 | |
16237 | 16237 | 16236 | {"type": "Polygon", "coordinates": [[[-118.28033, 34.19262], [-118.27496, 34.19266], [-118.27505, 34.20609], [-118.2751, 34.20718], [-118.27514, 34.20974], [-118.27513, 34.211], [-118.2747, 34.2106], [-118.27456, 34.21049], [-118.27419, 34.21017], [-118.27382, 34.20931], [-118.27345, 34.20873], [-118.27305, 34.20791], [-118.27354, 34.20634], [-118.27271, 34.20513], [-118.27144, 34.20385], [-118.26751, 34.20362], [-118.26625, 34.20347], [-118.26623, 34.20192], [-118.26608, 34.19554], [-118.26606, 34.19274], [-118.26591, 34.18029], [-118.26627, 34.18037], [-118.26633, 34.18021], [-118.26621, 34.17987], [-118.26642, 34.1796], [-118.26652, 34.17912], [-118.26684, 34.17878], [-118.26688, 34.17833], [-118.26999, 34.17828], [-118.27, 34.17892], [-118.27013, 34.17915], [-118.27127, 34.17875], [-118.27158, 34.17918], [-118.27142, 34.17932], [-118.27165, 34.17944], [-118.27193, 34.17949], [-118.27224, 34.1794], [-118.2728, 34.17963], [-118.27313, 34.17937], [-118.27345, 34.17935], [-118.27369, 34.1791], [-118.27402, 34.17917], [-118.27439, 34.1793], [-118.27466, 34.17951], [-118.27447, 34.17966], [-118.27465, 34.17982], [-118.27507, 34.1797], [-118.27491, 34.1839], [-118.27639, 34.18401], [-118.27734, 34.18474], [-118.27721, 34.18501], [-118.27736, 34.18508], [-118.27614, 34.18742], [-118.27562, 34.18829], [-118.27604, 34.18854], [-118.27822, 34.18973], [-118.27752, 34.19051], [-118.2778, 34.19073], [-118.27813, 34.19035], [-118.27876, 34.19003], [-118.27998, 34.1907], [-118.28032, 34.19087], [-118.28033, 34.19262]]]} | Open Access 1 | 46045 | Brand Canyon Open Space | 29367 | 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 | 651.63 | Brand Canyon OS | 0 | Local Recreation Area 3 | 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 |
8825 | 8825 | 8824 | {"type": "Polygon", "coordinates": [[[-118.22962, 34.14428], [-118.22941, 34.14428], [-118.22941, 34.14436], [-118.22877, 34.14436], [-118.22876, 34.14288], [-118.22961, 34.14287], [-118.22962, 34.14428]]]} | Open Access 1 | 14386 | Carr Park | 16905 | 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.131 | Carr Park | 0 | Local Park 2 | 4 | |
10858 | 10858 | 10857 | {"type": "Polygon", "coordinates": [[[-118.26403, 34.16642], [-118.26341, 34.16651], [-118.26342, 34.16647], [-118.26321, 34.16561], [-118.26383, 34.16552], [-118.26403, 34.16642]]]} | Open Access 1 | 20648 | Casa Adobe de San Rafael | 29364 | 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.447 | Casa Adobe de San Rafael | None 946 | |||
1264 | 1264 | 1263 | {"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.17958], [-118.23272, 34.17974], [-118.23281, 34.17974], [-118.23292, 34.1797], [-118.23294, 34.17995]]]} | Open Access 1 | 7147 | Catalina Verdugo Adobe | 29372 | 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.312 | Catalina Verdugo Adobe | None 109 | |||
5228 | 5228 | 5227 | {"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 | 1047 | Central Park & Adult Recreation Center | 29376 | 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.389 | Central Park & Adult Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
11916 | 11916 | 11915 | {"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 | 24507 | Cerritos Mini Park | 29371 | 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.89 | Cerritos MP | 0 | Local Park 2 | 4 | |
13655 | 13655 | 13654 | {"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 | 46025 | Chess Park | 29350 | 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/chess-park-photos | Los Angeles 6 | 0.101 | Chess Park | 0 | Local Park 2 | 4 |
1243 | 1243 | 1242 | {"type": "Polygon", "coordinates": [[[-118.25098, 34.17212], [-118.25095, 34.17243], [-118.25087, 34.17251], [-118.25076, 34.17252], [-118.25042, 34.17245], [-118.25036, 34.17242], [-118.25034, 34.17238], [-118.25034, 34.17208], [-118.2503, 34.17197], [-118.25018, 34.17186], [-118.24999, 34.1718], [-118.24996, 34.17176], [-118.25, 34.17174], [-118.2503, 34.17172], [-118.25062, 34.1719], [-118.25084, 34.17211], [-118.25098, 34.17212]]]} | Open Access 1 | 7146 | City of Glendale Open Space | 17315 | 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.988 | City of Glendale OS | 0 | Local Recreation Area 3 | 4 | |
1268 | 1268 | 1267 | {"type": "Polygon", "coordinates": [[[-118.25078, 34.1714], [-118.25076, 34.17144], [-118.25067, 34.17152], [-118.25055, 34.17158], [-118.24999, 34.17163], [-118.24993, 34.17162], [-118.24985, 34.17158], [-118.24975, 34.17141], [-118.25004, 34.17087], [-118.25034, 34.17093], [-118.25056, 34.17087], [-118.25078, 34.17138], [-118.25078, 34.1714]]]} | Open Access 1 | 7144 | City of Glendale Open Space | 17315 | 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.454 | City of Glendale OS | 0 | Local Recreation Area 3 | 4 | |
1269 | 1269 | 1268 | {"type": "Polygon", "coordinates": [[[-118.26461, 34.17807], [-118.26461, 34.17807], [-118.26442, 34.17818], [-118.2644, 34.17805], [-118.26441, 34.17804], [-118.26459, 34.17797], [-118.26461, 34.17807]]]} | Open Access 1 | 7148 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.061 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
7634 | 7634 | 7633 | {"type": "Polygon", "coordinates": [[[-118.25521, 34.22126], [-118.25496, 34.22127], [-118.25483, 34.22122], [-118.25495, 34.22109], [-118.25521, 34.22114], [-118.25521, 34.22126]]]} | Open Access 1 | 7154 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.128 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
7635 | 7635 | 7634 | {"type": "Polygon", "coordinates": [[[-118.25546, 34.22082], [-118.25537, 34.22087], [-118.25538, 34.22104], [-118.25521, 34.22098], [-118.25528, 34.22083], [-118.25519, 34.2208], [-118.25539, 34.2207], [-118.25546, 34.22082]]]} | Open Access 1 | 7155 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.115 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16894 | 16894 | 16893 | {"type": "Polygon", "coordinates": [[[-118.25507, 34.22173], [-118.25501, 34.22183], [-118.25501, 34.22186], [-118.25476, 34.22188], [-118.25472, 34.22164], [-118.25499, 34.2216], [-118.25501, 34.22174], [-118.25507, 34.22173]]]} | Open Access 1 | 7153 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.178 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16937 | 16937 | 16936 | {"type": "Polygon", "coordinates": [[[-118.26513, 34.17801], [-118.26487, 34.17804], [-118.26484, 34.17792], [-118.2651, 34.1779], [-118.26513, 34.17801]]]} | Open Access 1 | 7149 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.075 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16947 | 16947 | 16946 | {"type": "MultiPolygon", "coordinates": [[[[-118.25672, 34.22182], [-118.25668, 34.22188], [-118.25664, 34.22198], [-118.2566, 34.22203], [-118.25639, 34.2213], [-118.25648, 34.22117], [-118.25649, 34.22109], [-118.25642, 34.22099], [-118.25636, 34.22096], [-118.25629, 34.22095], [-118.25619, 34.22057], [-118.25626, 34.22051], [-118.2563, 34.22056], [-118.25635, 34.22057], [-118.25666, 34.22162], [-118.25657, 34.22176], [-118.25659, 34.22177], [-118.25667, 34.22165], [-118.25672, 34.22182]]], [[[-118.25635, 34.22055], [-118.25629, 34.22052], [-118.2563, 34.22046], [-118.25626, 34.2205], [-118.25614, 34.22037], [-118.25612, 34.22026], [-118.25623, 34.22012], [-118.25626, 34.22011], [-118.25626, 34.22008], [-118.25653, 34.21972], [-118.2566, 34.21988], [-118.25639, 34.22017], [-118.25627, 34.22012], [-118.25626, 34.22013], [-118.25626, 34.2203], [-118.25628, 34.22032], [-118.25632, 34.22042], [-118.25631, 34.22044], [-118.25635, 34.22055]]], [[[-118.25642, 34.22109], [-118.25641, 34.22115], [-118.25637, 34.22122], [-118.25631, 34.22102], [-118.25637, 34.22103], [-118.25642, 34.22109]]], [[[-118.2574, 34.22379], [-118.2572, 34.2237], [-118.25679, 34.22242], [-118.25673, 34.22244], [-118.25662, 34.2221], [-118.2567, 34.22201], [-118.25674, 34.22191], [-118.25681, 34.22216], [-118.25672, 34.22224], [-118.25673, 34.22224], [-118.25682, 34.22219], [-118.25687, 34.22236], [-118.25694, 34.22235], [-118.25695, 34.22236], [-118.2574, 34.22379]], [[-118.25671, 34.22225], [-118.2567, 34.22224], [-118.25668, 34.22226], [-118.2567, 34.22227], [-118.25671, 34.22225]]]]} | Open Access 1 | 7151 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.571 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16967 | 16967 | 16966 | {"type": "Polygon", "coordinates": [[[-118.25611, 34.22203], [-118.2561, 34.22216], [-118.25605, 34.22218], [-118.25594, 34.22219], [-118.25582, 34.22216], [-118.25578, 34.22213], [-118.25573, 34.22206], [-118.25573, 34.22201], [-118.25577, 34.22187], [-118.25583, 34.22183], [-118.2559, 34.22181], [-118.25601, 34.22182], [-118.25607, 34.22186], [-118.25611, 34.22198], [-118.25611, 34.22203]]]} | Open Access 1 | 7152 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.299 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 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]);