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 ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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 | |
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 | |
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 | |
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 | |
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 | |
7984 | 7984 | 7983 | {"type": "Polygon", "coordinates": [[[-118.26215, 34.14461], [-118.26182, 34.14461], [-118.26181, 34.14427], [-118.26214, 34.14427], [-118.26215, 34.14461]]]} | Open Access 1 | 20653 | Harvard Mini Park | 19716 | 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.286 | Harvard MP | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 | |
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 | |
8014 | 8014 | 8013 | {"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 | 24508 | Windsor Mini Park | 27636 | 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.347 | Windsor MP | 0 | Local Park 2 | 4 | |
15294 | 15294 | 15293 | {"type": "Polygon", "coordinates": [[[-118.23026, 34.16966], [-118.23015, 34.16981], [-118.2301, 34.16985], [-118.23004, 34.16995], [-118.22998, 34.16996], [-118.2299, 34.16992], [-118.22991, 34.16982], [-118.22989, 34.16978], [-118.22982, 34.16973], [-118.22962, 34.1697], [-118.22975, 34.16956], [-118.2298, 34.16948], [-118.23026, 34.16966]]]} | Restricted Access 2 | 46426 | Verdugo Skate Park | 29697 | 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/verdugo-skate-park | Los Angeles 6 | 0.355 | Verdugo Skate Park | 2004 | Local Recreation Area 3 | 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 | |
14747 | 14747 | 14746 | {"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 | 45092 | Maryland Avenue Park | 28047 | 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.parks.ca.gov/?Page_id=26462 | Los Angeles 6 | 0.483 | Maryland Avenue Park | 0 | Local Park 2 | 4 |
4394 | 4394 | 4393 | {"type": "Polygon", "coordinates": [[[-118.23041, 34.19871], [-118.23092, 34.19917], [-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]]]} | Restricted Access 2 | 46024 | Sparr Heights Community Center | 29349 | 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/sparr-heights-community-center | Los Angeles 6 | 0.504 | Sparr Heights Community Ctr. | 0 | Local Recreation Area 3 | 4 |
10859 | 10859 | 10858 | {"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.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], [-118.24075, 34.15204], [-118.24074, 34.1523]]]]} | Open Access 1 | 20650 | Piedmont Park | 23658 | 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.515 | Piedmont Park | 0 | Local Park 2 | 4 | |
15142 | 15142 | 15141 | {"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 | 46021 | Glendale Heritage Garden | 29346 | 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/city-departments/community-development/parks-facilities-historic-sites | Los Angeles 6 | 0.523 | Glendale Heritage Garden | 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]);