superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534 sorted by PARK_NAME descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11384 | 11384 | 11383 | {"type": "MultiPolygon", "coordinates": [[[[-121.45591, 38.60511], [-121.45575, 38.6057], [-121.45565, 38.60585], [-121.45547, 38.60602], [-121.45543, 38.6061], [-121.45441, 38.6061], [-121.45437, 38.60608], [-121.45435, 38.60605], [-121.45435, 38.60509], [-121.45436, 38.60506], [-121.45441, 38.60504], [-121.45506, 38.60501], [-121.45585, 38.60504], [-121.45589, 38.60506], [-121.45591, 38.60511]]], [[[-121.45815, 38.60582], [-121.45748, 38.60582], [-121.45746, 38.60593], [-121.45678, 38.60593], [-121.45683, 38.60556], [-121.45681, 38.60551], [-121.45676, 38.60546], [-121.45669, 38.60544], [-121.45625, 38.60546], [-121.45605, 38.60546], [-121.45597, 38.60544], [-121.45606, 38.60508], [-121.45609, 38.60505], [-121.45612, 38.60504], [-121.45659, 38.60506], [-121.4568, 38.6051], [-121.45717, 38.60521], [-121.45732, 38.60523], [-121.45746, 38.60522], [-121.45759, 38.60517], [-121.45764, 38.60517], [-121.45815, 38.60582]]]]} | Open Access 1 | Woodlake Park | 27717 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.151 | Woodlake Park | ||
11324 | 11324 | 11323 | {"type": "Polygon", "coordinates": [[[-121.48273, 38.50449], [-121.48083, 38.50449], [-121.48083, 38.50303], [-121.48266, 38.503], [-121.48273, 38.50449]]]} | Open Access 1 | Woodbine Park | 27681 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.592 | Woodbine Park | ||
11366 | 11366 | 11365 | {"type": "Polygon", "coordinates": [[[-121.42295, 38.46754], [-121.4229, 38.46761], [-121.42273, 38.46753], [-121.42271, 38.4675], [-121.42263, 38.46749], [-121.42248, 38.46742], [-121.42214, 38.46739], [-121.42183, 38.46766], [-121.42172, 38.46741], [-121.42167, 38.46737], [-121.42169, 38.4673], [-121.42164, 38.46723], [-121.42167, 38.46718], [-121.42139, 38.46663], [-121.42132, 38.4666], [-121.42132, 38.4665], [-121.4211, 38.46602], [-121.42104, 38.46595], [-121.42111, 38.46585], [-121.42087, 38.46535], [-121.42049, 38.46527], [-121.42045, 38.46527], [-121.42037, 38.46515], [-121.4207, 38.46505], [-121.42058, 38.46477], [-121.42115, 38.46459], [-121.42128, 38.46483], [-121.42135, 38.46487], [-121.42132, 38.46493], [-121.42133, 38.465], [-121.4216, 38.4655], [-121.42164, 38.46554], [-121.42171, 38.46558], [-121.42184, 38.46558], [-121.42201, 38.46589], [-121.42218, 38.4661], [-121.42227, 38.46614], [-121.42223, 38.46623], [-121.42225, 38.46676], [-121.42228, 38.46683], [-121.42233, 38.46688], [-121.42224, 38.46697], [-121.42224, 38.4673], [-121.42252, 38.46733], [-121.42295, 38.46754]]]} | Open Access 1 | Wood Park | 27678 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.584 | Wood Park | ||
11352 | 11352 | 11351 | {"type": "Polygon", "coordinates": [[[-121.53208, 38.63853], [-121.53194, 38.63857], [-121.5318, 38.63858], [-121.53175, 38.63862], [-121.53171, 38.63865], [-121.53169, 38.63865], [-121.531, 38.63886], [-121.5309, 38.63885], [-121.53077, 38.6389], [-121.53058, 38.63894], [-121.53032, 38.63896], [-121.53027, 38.63895], [-121.53025, 38.63893], [-121.53019, 38.63878], [-121.52943, 38.63721], [-121.52943, 38.63716], [-121.52947, 38.63713], [-121.52997, 38.63699], [-121.53012, 38.63697], [-121.53017, 38.63694], [-121.53021, 38.6369], [-121.53023, 38.63691], [-121.53092, 38.6367], [-121.53104, 38.63671], [-121.53117, 38.63665], [-121.53208, 38.63853]]]} | Open Access 1 | Witter Ranch Park | 27664 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 9.032 | Witter Ranch Park | ||
11338 | 11338 | 11337 | {"type": "Polygon", "coordinates": [[[-121.44494, 38.6102], [-121.44398, 38.6102], [-121.44398, 38.60939], [-121.44494, 38.60938], [-121.44494, 38.6102]]]} | Open Access 1 | Winner's Circle Park | 27648 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.889 | Winner's Circle Park | ||
11281 | 11281 | 11280 | {"type": "Polygon", "coordinates": [[[-121.51585, 38.68321], [-121.51543, 38.68328], [-121.51541, 38.68332], [-121.51446, 38.68333], [-121.5144, 38.68326], [-121.51447, 38.68322], [-121.51447, 38.68257], [-121.51539, 38.68237], [-121.51546, 38.68238], [-121.51551, 38.68242], [-121.51575, 38.68292], [-121.51585, 38.68321]]]} | Open Access 1 | Willow Park | 27584 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.516 | Willow Park | ||
11256 | 11256 | 11255 | {"type": "MultiPolygon", "coordinates": [[[[-121.4595, 38.57645], [-121.45919, 38.57719], [-121.45722, 38.57666], [-121.45758, 38.57593], [-121.4595, 38.57645]]], [[[-121.46367, 38.57597], [-121.46275, 38.57809], [-121.45934, 38.57718], [-121.46062, 38.57419], [-121.46066, 38.57416], [-121.46367, 38.57497], [-121.46378, 38.57509], [-121.46382, 38.57525], [-121.4638, 38.57535], [-121.46363, 38.57576], [-121.46363, 38.57587], [-121.46367, 38.57597]]], [[[-121.46413, 38.57503], [-121.46379, 38.57583], [-121.46377, 38.57583], [-121.46378, 38.57577], [-121.46392, 38.57542], [-121.46395, 38.5753], [-121.46394, 38.57514], [-121.46386, 38.57497], [-121.46389, 38.57497], [-121.46413, 38.57503]]]]} | Open Access 1 | William Mckinley Park | 27552 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 31.222 | William Mckinley Park | ||
11253 | 11253 | 11252 | {"type": "MultiPolygon", "coordinates": [[[[-121.50829, 38.5459], [-121.50751, 38.54716], [-121.50043, 38.54564], [-121.50093, 38.54409], [-121.50094, 38.544], [-121.49178, 38.54218], [-121.49175, 38.54214], [-121.49175, 38.54211], [-121.49388, 38.53524], [-121.50267, 38.53705], [-121.5031, 38.53721], [-121.50507, 38.5385], [-121.50524, 38.53859], [-121.50573, 38.53917], [-121.50588, 38.53951], [-121.5053, 38.5402], [-121.50479, 38.54046], [-121.50472, 38.54044], [-121.50323, 38.54454], [-121.50605, 38.54513], [-121.50663, 38.54532], [-121.50827, 38.54569], [-121.50822, 38.54587], [-121.50829, 38.5459]], [[-121.49918, 38.53783], [-121.50052, 38.53847], [-121.50102, 38.53797], [-121.49886, 38.53699], [-121.4949, 38.5357], [-121.49477, 38.53739], [-121.49458, 38.5393], [-121.49378, 38.53919], [-121.49363, 38.54119], [-121.49403, 38.5416], [-121.49458, 38.54138], [-121.49588, 38.54173], [-121.49617, 38.54169], [-121.49715, 38.54132], [-121.4973, 38.54134], [-121.49784, 38.54192], [-121.49803, 38.54218], [-121.49826, 38.54242], [-121.49851, 38.54254], [-121.49882, 38.54275], [-121.49948, 38.54293], [-121.50018, 38.54317], [-121.50105, 38.5435], [-121.50141, 38.5423], [-121.50031, 38.54177], [-121.49991, 38.54147], [-121.49957, 38.54116], [-121.49903, 38.54052], [-121.49876, 38.5401], [-121.49857, 38.53976], [-121.49915, 38.53856], [-121.49895, 38.53849], [-121.49918, 38.53783]]], [[[-121.50005, 38.54738], [-121.49997, 38.54753], [-121.49986, 38.54769], [-121.49983, 38.54772], [-121.49979, 38.54771], [-121.49978, 38.54769], [-121.4999, 38.54732], [-121.50005, 38.54738]]], [[[-121.50035, 38.54671], [-121.50011, 38.54724], [-121.50007, 38.54727], [-121.50001, 38.54727], [-121.49995, 38.54723], [-121.49994, 38.54719], [-121.50011, 38.54664], [-121.50014, 38.54661], [-121.50018, 38.5466], [-121.50031, 38.54664], [-121.50034, 38.54667], [-121.50035, 38.54671]]], [[[-121.50066, 38.54594], [-121.50044, 38.54648], [-121.50041, 38.54652], [-121.50036, 38.54653], [-121.50022, 38.54648], [-121.50019, 38.54645], [-121.50019, 38.54642], [-121.50036, 38.54586], [-121.50042, 38.54583], [-121.50061, 38.54587], [-121.50065, 38.5459], [-121.50066, 38.54594]]]]} | Open Access 1 | William Land Park | 27549 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 161.521 | William Land Park | ||
11246 | 11246 | 11245 | {"type": "MultiPolygon", "coordinates": [[[[-121.47968, 38.548], [-121.47963, 38.54804], [-121.47899, 38.54805], [-121.47897, 38.5475], [-121.47908, 38.54753], [-121.47922, 38.54764], [-121.47934, 38.54771], [-121.47961, 38.54778], [-121.47966, 38.54781], [-121.47968, 38.54786], [-121.47968, 38.548]]], [[[-121.48009, 38.54377], [-121.47905, 38.54378], [-121.479, 38.5406], [-121.48004, 38.54042], [-121.48009, 38.54377]]], [[[-121.48012, 38.5452], [-121.47907, 38.54521], [-121.47905, 38.54394], [-121.4801, 38.54393], [-121.48012, 38.5452]]], [[[-121.48013, 38.54591], [-121.47908, 38.54592], [-121.47907, 38.54537], [-121.48012, 38.54536], [-121.48013, 38.54591]]], [[[-121.48013, 38.54607], [-121.48015, 38.5473], [-121.48011, 38.54743], [-121.48006, 38.54751], [-121.47998, 38.54758], [-121.47988, 38.54764], [-121.47978, 38.54767], [-121.47955, 38.54769], [-121.47934, 38.54763], [-121.47924, 38.54756], [-121.47918, 38.5475], [-121.47911, 38.54735], [-121.47908, 38.54608], [-121.48013, 38.54607]]], [[[-121.48031, 38.54803], [-121.47996, 38.54804], [-121.47992, 38.54803], [-121.47989, 38.54799], [-121.47989, 38.54777], [-121.47992, 38.54771], [-121.48006, 38.54762], [-121.48015, 38.54753], [-121.48029, 38.54749], [-121.48031, 38.54803]]]]} | Open Access 1 | William Curtis Park | 27542 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 17.569 | William Curtis Park | ||
11244 | 11244 | 11243 | {"type": "Polygon", "coordinates": [[[-121.50124, 38.49928], [-121.49201, 38.49936], [-121.49199, 38.49761], [-121.49235, 38.49761], [-121.49249, 38.49753], [-121.49278, 38.49753], [-121.49291, 38.49756], [-121.49399, 38.49755], [-121.49471, 38.49745], [-121.49489, 38.49784], [-121.49518, 38.49819], [-121.4956, 38.49846], [-121.49608, 38.49863], [-121.49663, 38.49868], [-121.49716, 38.49863], [-121.49766, 38.49845], [-121.49807, 38.49818], [-121.49836, 38.49783], [-121.49851, 38.49745], [-121.4993, 38.49754], [-121.5004, 38.49753], [-121.50049, 38.4975], [-121.50123, 38.4975], [-121.50124, 38.49928]]]} | Open Access 1 | William Chorley Park | 27541 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 32.064 | William Chorley Park | ||
11200 | 11200 | 11199 | {"type": "Polygon", "coordinates": [[[-121.52709, 38.6697], [-121.52707, 38.66974], [-121.52471, 38.66974], [-121.52471, 38.66822], [-121.52709, 38.66822], [-121.52709, 38.6697]]]} | Open Access 1 | Wild Rose Park Site | 27498 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.62 | Wild Rose Park Site | ||
11135 | 11135 | 11134 | {"type": "Polygon", "coordinates": [[[-121.54712, 38.65619], [-121.5467, 38.65619], [-121.5466, 38.65618], [-121.54594, 38.65752], [-121.5455, 38.65742], [-121.5451, 38.65737], [-121.54468, 38.65737], [-121.54412, 38.65744], [-121.54408, 38.65743], [-121.54405, 38.65739], [-121.54394, 38.65712], [-121.54385, 38.6568], [-121.54377, 38.65637], [-121.54375, 38.65586], [-121.54377, 38.65583], [-121.54383, 38.6558], [-121.5468, 38.65578], [-121.54678, 38.65585], [-121.54678, 38.65586], [-121.54711, 38.65586], [-121.54712, 38.65619]]]} | Open Access 1 | Westlake Community Park | 27401 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 10.227 | Westlake Community Park | ||
11131 | 11131 | 11130 | {"type": "Polygon", "coordinates": [[[-121.5361, 38.67582], [-121.53603, 38.67614], [-121.53603, 38.67671], [-121.53601, 38.6768], [-121.53598, 38.67683], [-121.53431, 38.67655], [-121.53417, 38.67651], [-121.53405, 38.67645], [-121.53405, 38.67643], [-121.5343, 38.67605], [-121.5345, 38.67571], [-121.53461, 38.67554], [-121.53465, 38.67552], [-121.53478, 38.67558], [-121.53493, 38.67563], [-121.53602, 38.67579], [-121.5361, 38.6758], [-121.5361, 38.67582]]]} | Open Access 1 | Westhampton Park | 27398 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.317 | Westhampton Park | ||
11039 | 11039 | 11038 | {"type": "Polygon", "coordinates": [[[-121.48248, 38.58238], [-121.4821, 38.58326], [-121.48143, 38.58308], [-121.48181, 38.5822], [-121.48248, 38.58238]]]} | Open Access 1 | Washington Park | 27279 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.582 | Washington Park | ||
11019 | 11019 | 11018 | {"type": "Polygon", "coordinates": [[[-121.54774, 38.6485], [-121.5477, 38.64854], [-121.54769, 38.64858], [-121.5477, 38.64918], [-121.54773, 38.64925], [-121.54759, 38.64935], [-121.5476, 38.6497], [-121.54756, 38.64976], [-121.54748, 38.64975], [-121.54687, 38.64977], [-121.54666, 38.64982], [-121.54646, 38.64992], [-121.54643, 38.64804], [-121.54763, 38.64803], [-121.54764, 38.64837], [-121.54774, 38.6485]]]} | Open Access 1 | Warbler Park Site | 27253 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.086 | Warbler Park Site | ||
10779 | 10779 | 10778 | {"type": "Polygon", "coordinates": [[[-121.42536, 38.6435], [-121.42493, 38.64382], [-121.42471, 38.64363], [-121.42514, 38.64332], [-121.42536, 38.6435]]]} | Open Access 1 | Verano Creek Park | 26984 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.355 | Verano Creek Park | ||
10620 | 10620 | 10619 | {"type": "Polygon", "coordinates": [[[-121.53014, 38.67319], [-121.53005, 38.6734], [-121.52989, 38.67369], [-121.5297, 38.67394], [-121.5295, 38.67417], [-121.5292, 38.67444], [-121.52894, 38.67464], [-121.5276, 38.67551], [-121.52658, 38.67386], [-121.52689, 38.67393], [-121.5271, 38.67397], [-121.52771, 38.67398], [-121.52773, 38.67372], [-121.52779, 38.67344], [-121.52787, 38.67331], [-121.52799, 38.67317], [-121.52817, 38.67307], [-121.52869, 38.67285], [-121.52894, 38.67281], [-121.5292, 38.67281], [-121.5295, 38.67289], [-121.52986, 38.67308], [-121.53012, 38.67317], [-121.53014, 38.67319]]]} | Open Access 1 | Valley Oak Park Site | 26795 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.187 | Valley Oak Park Site | ||
10614 | 10614 | 10613 | {"type": "Polygon", "coordinates": [[[-121.42972, 38.46125], [-121.429, 38.46148], [-121.42897, 38.46155], [-121.42882, 38.46155], [-121.42821, 38.46176], [-121.42814, 38.4618], [-121.4281, 38.46184], [-121.42799, 38.46182], [-121.42733, 38.46204], [-121.42728, 38.46212], [-121.42713, 38.46212], [-121.42651, 38.46232], [-121.42642, 38.4624], [-121.42631, 38.46237], [-121.42595, 38.46248], [-121.42563, 38.46283], [-121.4255, 38.46284], [-121.42487, 38.46305], [-121.4248, 38.46312], [-121.42467, 38.4631], [-121.42399, 38.46332], [-121.42392, 38.46318], [-121.42373, 38.46293], [-121.42349, 38.4627], [-121.42382, 38.46247], [-121.4247, 38.46205], [-121.4258, 38.46165], [-121.4262, 38.46143], [-121.42657, 38.46119], [-121.42721, 38.46063], [-121.42734, 38.46039], [-121.42763, 38.46043], [-121.42792, 38.46044], [-121.42807, 38.46043], [-121.42836, 38.46037], [-121.42904, 38.46015], [-121.42911, 38.46015], [-121.42913, 38.46017], [-121.42972, 38.46125]]]} | Open Access 1 | Valley Hi Park | 26790 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 16.238 | Valley Hi Park | ||
14372 | 14372 | 14371 | {"type": "Polygon", "coordinates": [[[-121.38313, 38.64166], [-121.38312, 38.64229], [-121.38237, 38.64219], [-121.38248, 38.64206], [-121.38216, 38.64167], [-121.38222, 38.64159], [-121.38189, 38.64137], [-121.38288, 38.64043], [-121.38306, 38.64097], [-121.38306, 38.64164], [-121.38313, 38.64166]]]} | No Public Access 3 | Unnamed Site - Sacramento, City of | 32902 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.152 | |||
9120 | 9120 | 9119 | {"type": "MultiPolygon", "coordinates": [[[[-121.40892, 38.56163], [-121.4089, 38.5621], [-121.40883, 38.56227], [-121.40819, 38.56243], [-121.40787, 38.5625], [-121.40788, 38.56186], [-121.40892, 38.56163]]], [[[-121.40901, 38.56247], [-121.40895, 38.5634], [-121.4079, 38.56338], [-121.40793, 38.56264], [-121.40833, 38.56256], [-121.40901, 38.56247]]]]} | Open Access 1 | University Park | 26687 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.716 | University 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]);