superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where MNG_AGENCY = 135 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12462 | 12462 | 12461 | {"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 | Compass Tree Park | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/compass-tree-park | 29556 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 0.044 | Compass Tree Park | |
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 | ||
10997 | 10997 | 10996 | {"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 | Earthwalk Park | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/earthwalk-park | 29550 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 0.538 | Earthwalk Park | |
14161 | 14161 | 14160 | {"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 | Maple Street Playground | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | 31626 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 0.55 | Maple Street Playground | |
11887 | 11887 | 11886 | {"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 | 5 Points Art Monument | 28590 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 0.596 | 5 Points Art Monument | ||
8821 | 8821 | 8820 | {"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 | Robert E Lundigan Park | 24484 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1.218 | Robert E Lundigan 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 | ||
12477 | 12477 | 12476 | {"type": "Polygon", "coordinates": [[[-118.3045, 34.17652], [-118.30428, 34.17673], [-118.304, 34.17655], [-118.3039, 34.17666], [-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.30406, 34.17621], [-118.3045, 34.17652]]]} | Open Access 1 | Robert R. Ovrom Park and Community Center | 29535 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1.471 | Robert R. Ovrom Park and Community Ctr. | ||
12501 | 12501 | 12500 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.1841], [-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 | Miller Park | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | 29568 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1.599 | Miller Park | |
12488 | 12488 | 12487 | {"type": "Polygon", "coordinates": [[[-118.33123, 34.16503], [-118.33121, 34.16505], [-118.33044, 34.16531], [-118.3304, 34.1653], [-118.33007, 34.16463], [-118.33093, 34.16436], [-118.33123, 34.165], [-118.33123, 34.16503]]]} | Open Access 1 | Abraham Lincoln Park | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/abraham-lincoln-park | 29559 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1.698 | Abraham Lincoln Park | |
10991 | 10991 | 10990 | {"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 | Bel Air Ballfield | 29539 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1.786 | Bel Air Ballfield | ||
15479 | 15479 | 15478 | {"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 | Mountain View Park | 22551 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 2.481 | Mtn. View 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 | ||
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 | |
10992 | 10992 | 10991 | {"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.19047], [-118.34178, 34.19079]]]} | Open Access 1 | Robert E. Gross Park | 29540 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 4.869 | Robert E. Gross Park | ||
6005 | 6005 | 6004 | {"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 | Larry Maxam Park | 21036 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 5.174 | Larry Maxam 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 | ||
7862 | 7862 | 7861 | {"type": "MultiPolygon", "coordinates": [[[[-118.29935, 34.19458], [-118.29818, 34.19567], [-118.29755, 34.19631], [-118.29718, 34.19571], [-118.29721, 34.19554], [-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.1945], [-118.29759, 34.19414], [-118.29778, 34.19388], [-118.29803, 34.19363], [-118.29797, 34.19357], [-118.29803, 34.19349], [-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]]], [[[-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]]]]} | Open Access 1 | Palm Park | 23343 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 10.76 | Palm Park | ||
8481 | 8481 | 8480 | {"type": "Polygon", "coordinates": [[[-118.34791, 34.18487], [-118.34789, 34.18565], [-118.34672, 34.18564], [-118.34668, 34.18681], [-118.34475, 34.18679], [-118.34479, 34.18487], [-118.34481, 34.18483], [-118.34791, 34.18487]]]} | Open Access 1 | Ralph Foy Park | 24100 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 11.884 | Ralph Foy Park | ||
5584 | 5584 | 5583 | {"type": "MultiPolygon", "coordinates": [[[[-118.33119, 34.15494], [-118.33115, 34.15496], [-118.32928, 34.15378], [-118.32878, 34.15395], [-118.32877, 34.15396], [-118.33062, 34.15513], [-118.32966, 34.15546], [-118.32949, 34.15541], [-118.32943, 34.15541], [-118.32936, 34.15545], [-118.32931, 34.15553], [-118.32928, 34.15554], [-118.32851, 34.15405], [-118.3279, 34.15424], [-118.32645, 34.15406], [-118.32822, 34.15345], [-118.33024, 34.15294], [-118.33119, 34.15491], [-118.33119, 34.15494]]], [[[-118.33005, 34.15255], [-118.33005, 34.15255], [-118.32835, 34.15287], [-118.32971, 34.15195], [-118.32977, 34.15195], [-118.32979, 34.15197], [-118.33005, 34.15255]]]]} | Open Access 1 | Johnny Carson Park | 20472 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 12.853 | Johnny Carson 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]);