units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where AGNCY_LEV = 2 and MNG_AGENCY = 100
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 18
- Local Recreation Area 17
- Local Conservation Area 2
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 41
MNG_AGENCY 1
- Glendale, City of · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
4397 | 4397 | 4396 | {"type": "Polygon", "coordinates": [[[-118.29295, 34.15667], [-118.29283, 34.15679], [-118.29272, 34.15685], [-118.29263, 34.15686], [-118.29225, 34.15673], [-118.29186, 34.15665], [-118.28789, 34.15662], [-118.28805, 34.15645], [-118.28749, 34.15645], [-118.28325, 34.15668], [-118.28304, 34.15673], [-118.28303, 34.15676], [-118.28296, 34.15675], [-118.28302, 34.15668], [-118.28311, 34.15663], [-118.28716, 34.15642], [-118.28788, 34.1564], [-118.29158, 34.15642], [-118.29234, 34.15644], [-118.29235, 34.15646], [-118.29281, 34.15653], [-118.29287, 34.15657], [-118.29287, 34.15663], [-118.29295, 34.15667]]]} | Open Access 1 | 46029 | Narrows Riverwalk | 29354 | 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.607 | Narrows Riverwalk | None 393 | |||
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 | |
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 | |
7418 | 7418 | 7417 | {"type": "Polygon", "coordinates": [[[-118.25518, 34.24981], [-118.25477, 34.25004], [-118.25479, 34.2503], [-118.25458, 34.25025], [-118.25397, 34.24972], [-118.25322, 34.25049], [-118.25252, 34.25095], [-118.25201, 34.25117], [-118.2518, 34.25157], [-118.25125, 34.25139], [-118.25086, 34.25122], [-118.25062, 34.25126], [-118.25024, 34.25107], [-118.25114, 34.25038], [-118.25163, 34.25013], [-118.25249, 34.24973], [-118.25319, 34.249], [-118.25371, 34.24856], [-118.25395, 34.2483], [-118.25432, 34.24838], [-118.25433, 34.2485], [-118.25438, 34.24862], [-118.25452, 34.24874], [-118.25454, 34.24895], [-118.25447, 34.2491], [-118.25432, 34.24923], [-118.25413, 34.24935], [-118.25413, 34.24936], [-118.25481, 34.24969], [-118.25518, 34.24981]]]} | Open Access 1 | 6856 | Deukmejian Wilderness Park | 4154 | 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/deukmejian-wilderness-park | Los Angeles 6 | 13.175 | Deukmejian Wilderness Park | 0 | Local Conservation Area 4 | 2 |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
10573 | 10573 | 10572 | {"type": "Polygon", "coordinates": [[[-118.25725, 34.23852], [-118.25724, 34.24032], [-118.25491, 34.23887], [-118.25501, 34.23876], [-118.25518, 34.23875], [-118.25518, 34.23724], [-118.25725, 34.23852]]]} | Open Access 1 | 18830 | Dunsmore Park | 18307 | 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 | 9.505 | Dunsmore 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 | |||
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 |
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]);