units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where DES_TP = 2, MNG_AGENCY = 100 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 30 ✖
MNG_AGENCY 1
- Glendale, City of · 30 ✖
DES_TP 1
- Local Park · 30 ✖
ACCESS_TYP 1
- Open Access 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
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 | |
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 |
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 |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);