superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where MNG_AGENCY = 135 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME ▼ | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12483 | 12483 | 12482 | {"type": "Polygon", "coordinates": [[[-118.31176, 34.17125], [-118.31155, 34.17146], [-118.31116, 34.17117], [-118.31137, 34.17097], [-118.31176, 34.17125]]]} | Open Access 1 | Santa Anita Playlot | 29558 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 0.353 | Santa Anita Playlot | ||
12496 | 12496 | 12495 | {"type": "Polygon", "coordinates": [[[-118.31002, 34.22152], [-118.30136, 34.22159], [-118.30133, 34.2117], [-118.30256, 34.21169], [-118.30259, 34.21334], [-118.30502, 34.21331], [-118.30503, 34.21208], [-118.30563, 34.21152], [-118.30683, 34.21239], [-118.30698, 34.21227], [-118.30625, 34.21171], [-118.30636, 34.21158], [-118.30591, 34.21126], [-118.30749, 34.20978], [-118.30998, 34.21116], [-118.31002, 34.22152]]]} | Open Access 1 | Stough Canyon Nature Center | http://www.burbankca.gov/departments/parks-and-recreation/recreation/stough-canyon-nature-center | 29562 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 217.066 | Stough Canyon Nature Ctr. | |
12557 | 12557 | 12556 | {"type": "Polygon", "coordinates": [[[-118.31479, 34.20287], [-118.31023, 34.20722], [-118.30593, 34.21124], [-118.30637, 34.21159], [-118.30626, 34.21172], [-118.30699, 34.21225], [-118.30684, 34.2124], [-118.30564, 34.21152], [-118.3053, 34.21183], [-118.30512, 34.21138], [-118.30474, 34.21013], [-118.30461, 34.20958], [-118.30457, 34.20907], [-118.30457, 34.2087], [-118.30461, 34.20838], [-118.3047, 34.2079], [-118.30483, 34.2074], [-118.30511, 34.20595], [-118.30524, 34.20573], [-118.30538, 34.20556], [-118.30555, 34.20549], [-118.30566, 34.20549], [-118.30574, 34.20551], [-118.30578, 34.20553], [-118.30586, 34.20562], [-118.30605, 34.20574], [-118.30635, 34.20587], [-118.30652, 34.20591], [-118.30681, 34.20595], [-118.30718, 34.20595], [-118.30737, 34.20591], [-118.3072, 34.20581], [-118.30695, 34.20581], [-118.30664, 34.20578], [-118.30626, 34.20567], [-118.30609, 34.20558], [-118.30597, 34.20548], [-118.30586, 34.20536], [-118.30576, 34.20519], [-118.30572, 34.20507], [-118.3057, 34.20488], [-118.30574, 34.20466], [-118.30585, 34.20432], [-118.30586, 34.20418], [-118.30584, 34.20406], [-118.30579, 34.20395], [-118.30447, 34.20182], [-118.30438, 34.20161], [-118.30434, 34.20143], [-118.30434, 34.20126], [-118.30436, 34.20112], [-118.30448, 34.20074], [-118.30455, 34.20068], [-118.30591, 34.20076], [-118.30581, 34.2004], [-118.30577, 34.20015], [-118.30585, 34.19988], [-118.30646, 34.20031], [-118.30734, 34.20022], [-118.30818, 34.19953], [-118.30809, 34.19943], [-118.30791, 34.19937], [-118.30788, 34.19928], [-118.30781, 34.19924], [-118.30789, 34.19917], [-118.30847, 34.19934], [-118.30856, 34.19983], [-118.30839, 34.20055], [-118.30968, 34.20078], [-118.31122, 34.19933], [-118.3115, 34.19952], [-118.31459, 34.20179], [-118.31406, 34.20238], [-118.31479, 34.20287]]]} | Open Access 1 | Stough Canyon Park | 29668 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 175.993 | Stough Canyon Park | ||
10988 | 10988 | 10987 | {"type": "Polygon", "coordinates": [[[-118.35868, 34.17938], [-118.35838, 34.17938], [-118.35814, 34.1793], [-118.35775, 34.17925], [-118.35772, 34.17922], [-118.35774, 34.1777], [-118.35776, 34.17766], [-118.35838, 34.17767], [-118.35842, 34.17769], [-118.35868, 34.17938]]]} | Open Access 1 | Valley Park | 29534 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 3.433 | Valley Park | ||
10784 | 10784 | 10783 | {"type": "Polygon", "coordinates": [[[-118.34111, 34.16569], [-118.34111, 34.16573], [-118.34108, 34.16575], [-118.3406, 34.16591], [-118.33941, 34.16346], [-118.33881, 34.16365], [-118.33869, 34.16347], [-118.33852, 34.1633], [-118.33831, 34.16318], [-118.33804, 34.16307], [-118.33802, 34.16304], [-118.33803, 34.163], [-118.33952, 34.1625], [-118.33958, 34.16251], [-118.34111, 34.16569]]]} | Open Access 1 | Verdugo Park | 26991 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 6.898 | Verdugo Park | ||
10855 | 10855 | 10854 | {"type": "Polygon", "coordinates": [[[-118.33778, 34.18626], [-118.33777, 34.1863], [-118.33774, 34.18632], [-118.33708, 34.18657], [-118.33698, 34.18658], [-118.3369, 34.18656], [-118.33624, 34.1863], [-118.33621, 34.18625], [-118.33624, 34.1862], [-118.33691, 34.18596], [-118.33701, 34.18595], [-118.33709, 34.18596], [-118.33775, 34.18623], [-118.33778, 34.18626]]]} | Open Access 1 | Vickroy Park | 27069 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1.466 | Vickroy Park | ||
10996 | 10996 | 10995 | {"type": "Polygon", "coordinates": [[[-118.34516, 34.16437], [-118.34149, 34.16189], [-118.34149, 34.16189], [-118.34213, 34.16168], [-118.34488, 34.16374], [-118.34516, 34.16437]]]} | Open Access 1 | Whitnall Highway Park South | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/whitnall-highway-park-south | 29546 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 4.501 | Whitnall Highway Park South | |
27 | 27 | 26 | {"type": "MultiPolygon", "coordinates": [[[[-118.30517, 34.21196], [-118.30503, 34.21209], [-118.30504, 34.21331], [-118.30258, 34.21334], [-118.30255, 34.21169], [-118.3001, 34.21172], [-118.30012, 34.21602], [-118.29252, 34.21605], [-118.29251, 34.21842], [-118.29278, 34.22166], [-118.29156, 34.2202], [-118.28523, 34.21295], [-118.28068, 34.20771], [-118.28049, 34.20747], [-118.2925, 34.20743], [-118.29255, 34.20097], [-118.29355, 34.20036], [-118.29559, 34.19924], [-118.29683, 34.1999], [-118.29679, 34.2001], [-118.29704, 34.2002], [-118.29727, 34.20013], [-118.29826, 34.20066], [-118.30189, 34.19724], [-118.30222, 34.19742], [-118.30223, 34.19759], [-118.30229, 34.1977], [-118.30274, 34.19815], [-118.30281, 34.19827], [-118.30283, 34.19838], [-118.30282, 34.19851], [-118.30277, 34.19864], [-118.30249, 34.19898], [-118.30241, 34.19918], [-118.3024, 34.19929], [-118.30241, 34.19936], [-118.30265, 34.20005], [-118.30266, 34.20018], [-118.30265, 34.20026], [-118.30242, 34.20093], [-118.30232, 34.20105], [-118.30216, 34.20116], [-118.30153, 34.20152], [-118.30131, 34.20168], [-118.30118, 34.2018], [-118.3008, 34.20227], [-118.30068, 34.20236], [-118.30045, 34.20244], [-118.30033, 34.20246], [-118.30013, 34.20245], [-118.29982, 34.20236], [-118.29956, 34.20221], [-118.29945, 34.20216], [-118.29935, 34.20215], [-118.29914, 34.20216], [-118.29897, 34.20222], [-118.29851, 34.20258], [-118.29839, 34.20264], [-118.29817, 34.20272], [-118.29792, 34.20273], [-118.29789, 34.20285], [-118.29793, 34.20287], [-118.29808, 34.20286], [-118.29836, 34.20278], [-118.29851, 34.20278], [-118.29839, 34.20362], [-118.29845, 34.20413], [-118.29979, 34.20421], [-118.30177, 34.20593], [-118.30037, 34.20724], [-118.30033, 34.20757], [-118.30008, 34.20793], [-118.30031, 34.20799], [-118.30114, 34.20747], [-118.30183, 34.20757], [-118.3024, 34.2075], [-118.30298, 34.20777], [-118.30317, 34.2082], [-118.30288, 34.20918], [-118.30196, 34.21128], [-118.30216, 34.21136], [-118.30242, 34.21098], [-118.30349, 34.21114], [-118.30382, 34.21134], [-118.30382, 34.2116], [-118.30357, 34.21209], [-118.30369, 34.21252], [-118.30356, 34.21282], [-118.30369, 34.21305], [-118.30379, 34.21315], [-118.30396, 34.2131], [-118.30397, 34.21284], [-118.30404, 34.21258], [-118.30448, 34.21217], [-118.3048, 34.21198], [-118.30514, 34.21186], [-118.30517, 34.21196]]], [[[-118.3034, 34.1995], [-118.3033, 34.19956], [-118.30305, 34.19961], [-118.30267, 34.19977], [-118.30258, 34.19956], [-118.30251, 34.19933], [-118.30251, 34.19924], [-118.30253, 34.19915], [-118.30257, 34.19905], [-118.30279, 34.19878], [-118.30288, 34.19865], [-118.30293, 34.1985], [-118.30293, 34.19832], [-118.30289, 34.19821], [-118.30283, 34.1981], [-118.30241, 34.19769], [-118.30234, 34.19755], [-118.30233, 34.19742], [-118.30237, 34.19702], [-118.3024, 34.19695], [-118.30244, 34.19692], [-118.30246, 34.19692], [-118.30326, 34.19752], [-118.30346, 34.19855], [-118.3034, 34.1995]]], [[[-118.30517, 34.1989], [-118.30516, 34.19895], [-118.30485, 34.19924], [-118.30477, 34.19936], [-118.30445, 34.20033], [-118.30437, 34.19992], [-118.30394, 34.1996], [-118.30377, 34.19955], [-118.30387, 34.19795], [-118.30517, 34.1989]]], [[[-118.30463, 34.20056], [-118.30455, 34.20067], [-118.30448, 34.20074], [-118.30462, 34.20038], [-118.30463, 34.20056]]]]} | Open Access 1 | Wildwood Canyon Park | http://www.burbankca.gov/departments/park-recreation-and-community-services/parks-facilities/wildwood-canyon-park | 760 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 586.796 | Wildwood Canyon Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);