units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 135 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4418 | 4418 | 4417 | {"type": "Polygon", "coordinates": [[[-118.30925, 34.17173], [-118.30908, 34.1716], [-118.30919, 34.17149], [-118.30919, 34.17149], [-118.30925, 34.17173]]]} | Open Access 1 | 46273 | Compass Tree Park | 29556 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/compass-tree-park | Los Angeles 6 | 0.044 | Compass Tree Park | 0 | Local Park 2 | 4 |
4419 | 4419 | 4418 | {"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 | 46274 | Santa Anita Playlot | 29558 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 0.353 | Santa Anita Playlot | 0 | Local Recreation Area 3 | 4 | |
3941 | 3941 | 3940 | {"type": "Polygon", "coordinates": [[[-118.32585, 34.19665], [-118.32533, 34.19665], [-118.32519, 34.19624], [-118.32572, 34.19625], [-118.32585, 34.19665]]]} | Open Access 1 | 46265 | Earthwalk Park | 29550 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/earthwalk-park | Los Angeles 6 | 0.538 | Earthwalk Park | 0 | Local Park 2 | 4 |
4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | 46266 | Maple Street Playground | 31626 | 2391 | Burbank Unified School District 759 | Special District 4 | School District 14 | http://www.burbankusd.org/ | Special District 4 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | Los Angeles 6 | 0.55 | Maple Street Playground | 0 | Local Recreation Area 3 | 4 |
13964 | 13964 | 13963 | {"type": "Polygon", "coordinates": [[[-118.32431, 34.18417], [-118.32398, 34.1841], [-118.32369, 34.18399], [-118.32355, 34.18389], [-118.32353, 34.18384], [-118.32354, 34.18379], [-118.3236, 34.18374], [-118.32402, 34.1836], [-118.32431, 34.18417]]]} | Open Access 1 | 36624 | 5 Points Art Monument | 28590 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 0.597 | 5 Points Art Monument | None 1195 | |||
5109 | 5109 | 5108 | {"type": "MultiPolygon", "coordinates": [[[[-118.29581, 34.19337], [-118.29578, 34.19349], [-118.29574, 34.19378], [-118.29561, 34.19383], [-118.29556, 34.19372], [-118.29574, 34.19353], [-118.29579, 34.19336], [-118.29581, 34.19337]]], [[[-118.29591, 34.19347], [-118.29593, 34.19378], [-118.29591, 34.19396], [-118.29586, 34.19409], [-118.29577, 34.19426], [-118.29568, 34.19436], [-118.29567, 34.1944], [-118.29568, 34.19442], [-118.29562, 34.19442], [-118.29578, 34.19411], [-118.29582, 34.19399], [-118.29591, 34.19347]]], [[[-118.29599, 34.19529], [-118.29577, 34.19538], [-118.29565, 34.19511], [-118.2956, 34.19497], [-118.29561, 34.1948], [-118.29564, 34.19469], [-118.29564, 34.19491], [-118.29577, 34.19517], [-118.29585, 34.19514], [-118.29592, 34.19518], [-118.29599, 34.19529]]], [[[-118.29578, 34.1959], [-118.29571, 34.19612], [-118.2955, 34.19549], [-118.29547, 34.1951], [-118.29542, 34.19493], [-118.29542, 34.19481], [-118.29545, 34.19468], [-118.29552, 34.19452], [-118.2956, 34.19443], [-118.29549, 34.19467], [-118.29545, 34.19486], [-118.29545, 34.19494], [-118.29551, 34.19516], [-118.29561, 34.19532], [-118.2957, 34.19573], [-118.29578, 34.19584], [-118.29578, 34.1959]]]]} | Open Access 1 | 7136 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 0.75 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
2991 | 2991 | 2990 | {"type": "Polygon", "coordinates": [[[-118.34084, 34.19642], [-118.3402, 34.1964], [-118.34021, 34.19568], [-118.34022, 34.19566], [-118.34025, 34.19564], [-118.34083, 34.19565], [-118.34084, 34.19642]]]} | Open Access 1 | 20656 | Robert E Lundigan Park | 24484 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 1.218 | Robert E Lundigan Park | 0 | Local Park 2 | 4 | |
12611 | 12611 | 12610 | {"type": "Polygon", "coordinates": [[[-118.3045, 34.17652], [-118.30428, 34.17673], [-118.304, 34.17654], [-118.3039, 34.17665], [-118.30416, 34.17684], [-118.30387, 34.17712], [-118.30379, 34.17713], [-118.30328, 34.17677], [-118.30406, 34.17602], [-118.30415, 34.17609], [-118.30405, 34.1762], [-118.3045, 34.17652]]]} | Open Access 1 | 29307 | Robert R. Ovrom Park and Community Center | 29535 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 1.464 | Robert R. Ovrom Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
9077 | 9077 | 9076 | {"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 | 15027 | Vickroy Park | 27069 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 1.466 | Vickroy Park | 0 | Local Park 2 | 4 | |
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | Los Angeles 6 | 1.599 | Miller Park | 0 | Local Park 2 | 4 |
4420 | 4420 | 4419 | {"type": "Polygon", "coordinates": [[[-118.33093, 34.16436], [-118.33123, 34.165], [-118.33123, 34.16503], [-118.33121, 34.16505], [-118.33044, 34.16531], [-118.3304, 34.1653], [-118.33007, 34.16463], [-118.33093, 34.16436]]]} | Open Access 1 | 46275 | Abraham Lincoln Park | 29559 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/abraham-lincoln-park | Los Angeles 6 | 1.699 | Abraham Lincoln Park | 0 | Local Park 2 | 4 |
1032 | 1032 | 1031 | {"type": "Polygon", "coordinates": [[[-118.31535, 34.20234], [-118.31479, 34.20286], [-118.31405, 34.20238], [-118.31459, 34.20179], [-118.31535, 34.20234]]]} | Open Access 1 | 6838 | Bel Air Ballfield | 29539 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 1.786 | Bel Air Ballfield | None 92 | |||
1122 | 1122 | 1121 | {"type": "Polygon", "coordinates": [[[-118.29627, 34.19919], [-118.29609, 34.19935], [-118.29614, 34.19953], [-118.29511, 34.19897], [-118.2953, 34.19878], [-118.29525, 34.19874], [-118.29588, 34.19813], [-118.29595, 34.19818], [-118.29627, 34.19919]]]} | Open Access 1 | 7138 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 2.037 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
5381 | 5381 | 5380 | {"type": "Polygon", "coordinates": [[[-118.31631, 34.15854], [-118.31547, 34.15882], [-118.31495, 34.15776], [-118.31495, 34.15772], [-118.31498, 34.1577], [-118.31512, 34.15767], [-118.31541, 34.15765], [-118.31566, 34.15767], [-118.3159, 34.15773], [-118.31601, 34.15791], [-118.31631, 34.15854]]]} | Open Access 1 | 5724 | Mountain View Park | 22551 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 2.482 | Mtn. View Park | 0 | Local Park 2 | 4 | |
9023 | 9023 | 9022 | {"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 | 14938 | Valley Park | 29534 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 3.434 | Valley Park | 0 | Local Park 2 | 4 | |
3940 | 3940 | 3939 | {"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 | 46260 | Whitnall Highway Park South | 29546 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/whitnall-highway-park-south | Los Angeles 6 | 4.502 | Whitnall Highway Park South | 0 | Local Park 2 | 4 |
2990 | 2990 | 2989 | {"type": "Polygon", "coordinates": [[[-118.34178, 34.19079], [-118.34176, 34.19181], [-118.34014, 34.19178], [-118.34014, 34.19041], [-118.34023, 34.19042], [-118.34024, 34.19046], [-118.34178, 34.19079]]]} | Open Access 1 | 20655 | Robert E. Gross Park | 29540 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 4.869 | Robert E. Gross Park | 0 | Local Park 2 | 4 | |
1319 | 1319 | 1318 | {"type": "Polygon", "coordinates": [[[-118.35346, 34.18853], [-118.35345, 34.18946], [-118.35127, 34.18943], [-118.35128, 34.18849], [-118.35346, 34.18853]]]} | Open Access 1 | 7419 | Larry Maxam Park | 21036 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 5.175 | Larry Maxam Park | 0 | Local Park 2 | 4 | |
9062 | 9062 | 9061 | {"type": "Polygon", "coordinates": [[[-118.34111, 34.16569], [-118.34111, 34.16573], [-118.34108, 34.16575], [-118.3406, 34.16591], [-118.33941, 34.16345], [-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 | 15002 | Verdugo Park | 26991 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 6.892 | Verdugo Park | 0 | Local Park 2 | 4 | |
7411 | 7411 | 7410 | {"type": "MultiPolygon", "coordinates": [[[[-118.29946, 34.19377], [-118.29936, 34.19386], [-118.29936, 34.19389], [-118.29915, 34.19409], [-118.29915, 34.19402], [-118.29932, 34.19385], [-118.29946, 34.19377]]], [[[-118.29955, 34.19439], [-118.29945, 34.19447], [-118.29928, 34.19425], [-118.29916, 34.19411], [-118.29917, 34.1941], [-118.29955, 34.19439]]], [[[-118.29935, 34.19458], [-118.29818, 34.19567], [-118.29755, 34.19631], [-118.29718, 34.19571], [-118.29721, 34.19553], [-118.29714, 34.19546], [-118.29597, 34.19535], [-118.29595, 34.19531], [-118.29645, 34.19512], [-118.2969, 34.19471], [-118.297, 34.19477], [-118.29711, 34.19477], [-118.29714, 34.19474], [-118.29724, 34.19449], [-118.29729, 34.19451], [-118.29759, 34.19414], [-118.29778, 34.19388], [-118.29804, 34.19363], [-118.29797, 34.19357], [-118.29804, 34.1935], [-118.29782, 34.19333], [-118.29783, 34.19329], [-118.29786, 34.19327], [-118.29859, 34.19334], [-118.29891, 34.19357], [-118.29896, 34.19365], [-118.299, 34.19416], [-118.29935, 34.19458]]]]} | Open Access 1 | 6831 | Palm Park | 23343 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 10.755 | Palm 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]);