superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where MNG_AGENCY = 639 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9064 | 9064 | 9063 | {"type": "Polygon", "coordinates": [[[-121.34316, 38.67726], [-121.34314, 38.67731], [-121.34317, 38.67742], [-121.34317, 38.67773], [-121.34315, 38.67776], [-121.34285, 38.67782], [-121.34266, 38.67788], [-121.34246, 38.67798], [-121.34233, 38.67808], [-121.34293, 38.67748], [-121.34304, 38.67739], [-121.34316, 38.67726]]]} | Open Access 1 | Rushmore Jeanine Park | 24735 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 0.434 | Rushmore Jeanine Park | ||
7929 | 7929 | 7928 | {"type": "Polygon", "coordinates": [[[-121.31655, 38.67259], [-121.31615, 38.67248], [-121.31541, 38.67249], [-121.31541, 38.67194], [-121.31568, 38.67194], [-121.31611, 38.67179], [-121.31649, 38.67247], [-121.31655, 38.67259]]]} | Open Access 1 | Park Oaks Park | 23430 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 1.367 | Park Oaks Park | ||
15424 | 15424 | 15423 | {"type": "Polygon", "coordinates": [[[-121.31914, 38.71495], [-121.31802, 38.71547], [-121.31774, 38.71523], [-121.31775, 38.7152], [-121.31825, 38.71465], [-121.31856, 38.71433], [-121.31877, 38.71448], [-121.31914, 38.71495]]]} | Open Access 1 | Sunrise Recreation and Park District 4 | 26033 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 1.821 | Sunrise Rec. and Park District 4 | ||
15427 | 15427 | 15426 | {"type": "Polygon", "coordinates": [[[-121.35167, 38.66825], [-121.35084, 38.66901], [-121.35035, 38.66886], [-121.35013, 38.66897], [-121.3501, 38.66894], [-121.35031, 38.66867], [-121.34997, 38.66857], [-121.34998, 38.66823], [-121.35167, 38.66825]]]} | Open Access 1 | Sunrise Recreation and Park District 7 | 26036 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2.014 | Sunrise Rec. and Park District 7 | ||
8575 | 8575 | 8574 | {"type": "Polygon", "coordinates": [[[-121.34087, 38.71225], [-121.34023, 38.71225], [-121.34026, 38.71078], [-121.34084, 38.71078], [-121.34087, 38.71225]]]} | Open Access 1 | Sunrise Recreation and Park District 2 | 26031 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2.129 | Sunrise Rec. and Park District 2 | ||
6807 | 6807 | 6806 | {"type": "Polygon", "coordinates": [[[-121.2692, 38.70536], [-121.2692, 38.70651], [-121.2682, 38.70653], [-121.2682, 38.70579], [-121.26831, 38.70574], [-121.2692, 38.70536]]]} | Open Access 1 | McDonald Field Park | 22021 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2.271 | McDonald Field Park | ||
11265 | 11265 | 11264 | {"type": "Polygon", "coordinates": [[[-121.33414, 38.69363], [-121.3342, 38.69366], [-121.33458, 38.694], [-121.33466, 38.6941], [-121.33472, 38.69423], [-121.33473, 38.6943], [-121.3347, 38.69445], [-121.33464, 38.69456], [-121.33456, 38.69465], [-121.33446, 38.69471], [-121.33424, 38.69479], [-121.33332, 38.69484], [-121.33324, 38.69482], [-121.33316, 38.69461], [-121.33302, 38.6944], [-121.33302, 38.69436], [-121.33414, 38.69363]]]} | Open Access 1 | William T Mason Park | 27560 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 3.199 | William T Mason Park | ||
7497 | 7497 | 7496 | {"type": "Polygon", "coordinates": [[[-121.25298, 38.69746], [-121.25298, 38.69861], [-121.25254, 38.69848], [-121.25252, 38.69849], [-121.25248, 38.69848], [-121.25142, 38.69879], [-121.2513, 38.6986], [-121.25118, 38.69846], [-121.25171, 38.69808], [-121.25203, 38.69779], [-121.25199, 38.69751], [-121.25245, 38.69746], [-121.25298, 38.69746]]]} | Open Access 1 | Northwoods Park | 22902 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 3.517 | Northwoods Park | ||
8574 | 8574 | 8573 | {"type": "Polygon", "coordinates": [[[-121.32665, 38.68958], [-121.32655, 38.69096], [-121.32515, 38.69004], [-121.32568, 38.68963], [-121.32578, 38.68948], [-121.32589, 38.68912], [-121.32664, 38.68924], [-121.32663, 38.68957], [-121.32665, 38.68958]]]} | Open Access 1 | Sunrise Recreation and Park District 11 | 26030 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 3.71 | Sunrise Rec. and Park District 11 | ||
8199 | 8199 | 8198 | {"type": "Polygon", "coordinates": [[[-121.34566, 38.67204], [-121.34568, 38.67208], [-121.34568, 38.6728], [-121.34566, 38.67292], [-121.34555, 38.67308], [-121.34524, 38.67338], [-121.34517, 38.6734], [-121.34512, 38.67339], [-121.34482, 38.67322], [-121.34451, 38.67307], [-121.3441, 38.6729], [-121.34373, 38.67278], [-121.34371, 38.67273], [-121.34374, 38.67257], [-121.34374, 38.67235], [-121.34378, 38.67232], [-121.34442, 38.67215], [-121.34483, 38.67207], [-121.34538, 38.67202], [-121.3456, 38.67202], [-121.34566, 38.67204]]]} | Open Access 1 | Pioneer Park | 23737 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 4.497 | Pioneer Park | ||
15425 | 15425 | 15424 | {"type": "Polygon", "coordinates": [[[-121.33686, 38.70649], [-121.33669, 38.7071], [-121.33335, 38.70713], [-121.33368, 38.70691], [-121.33402, 38.70678], [-121.33444, 38.70665], [-121.33575, 38.7064], [-121.33619, 38.70626], [-121.33645, 38.70616], [-121.33652, 38.70619], [-121.33664, 38.70634], [-121.33667, 38.70642], [-121.3367, 38.70645], [-121.33679, 38.70649], [-121.33686, 38.70649]]]} | Open Access 1 | Sunrise Recreation and Park District 5 | 26034 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 4.566 | Sunrise Rec. and Park District 5 | ||
10032 | 10032 | 10031 | {"type": "Polygon", "coordinates": [[[-121.37557, 38.67701], [-121.37555, 38.67836], [-121.37412, 38.67834], [-121.37415, 38.67699], [-121.37557, 38.67701]]]} | Open Access 1 | Strizek Park | 25928 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 4.606 | Strizek Park | ||
8573 | 8573 | 8572 | {"type": "Polygon", "coordinates": [[[-121.32934, 38.71856], [-121.32923, 38.71861], [-121.32919, 38.71868], [-121.3292, 38.71984], [-121.32918, 38.71987], [-121.32914, 38.71989], [-121.3281, 38.7199], [-121.32809, 38.71909], [-121.32763, 38.71908], [-121.32762, 38.71844], [-121.32934, 38.71841], [-121.32934, 38.71856]]]} | Open Access 1 | Sunrise Recreation and Park District 1 | 26029 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 4.648 | Sunrise Rec. and Park District 1 | ||
10102 | 10102 | 10101 | {"type": "Polygon", "coordinates": [[[-121.2716, 38.69851], [-121.27037, 38.69853], [-121.27035, 38.69672], [-121.27154, 38.69671], [-121.2716, 38.69851]]]} | Open Access 1 | Sunrise Oaks Park | 26020 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 5.237 | Sunrise Oaks Park | ||
9542 | 9542 | 9541 | {"type": "Polygon", "coordinates": [[[-121.31984, 38.6729], [-121.31981, 38.67403], [-121.3189, 38.67397], [-121.31903, 38.67441], [-121.31896, 38.67443], [-121.31884, 38.67402], [-121.31879, 38.674], [-121.31813, 38.6743], [-121.31755, 38.67431], [-121.31708, 38.6746], [-121.31694, 38.67505], [-121.31683, 38.6751], [-121.31647, 38.6751], [-121.31632, 38.67497], [-121.31602, 38.675], [-121.31607, 38.67479], [-121.31643, 38.67489], [-121.31661, 38.67481], [-121.31707, 38.67386], [-121.31767, 38.67391], [-121.31805, 38.67385], [-121.31831, 38.67374], [-121.31891, 38.67342], [-121.31937, 38.6729], [-121.31984, 38.6729]]]} | Open Access 1 | Shadowcreek Park | 25342 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 5.39 | Shadowcreek Park | ||
2875 | 2875 | 2874 | {"type": "Polygon", "coordinates": [[[-121.30119, 38.67445], [-121.30091, 38.67484], [-121.30047, 38.67468], [-121.30035, 38.67441], [-121.29992, 38.67421], [-121.2994, 38.67448], [-121.2988, 38.67434], [-121.29862, 38.67432], [-121.29864, 38.67415], [-121.29816, 38.6737], [-121.29776, 38.67344], [-121.29772, 38.67344], [-121.29767, 38.67337], [-121.29756, 38.67331], [-121.29688, 38.67257], [-121.29667, 38.67246], [-121.29633, 38.67237], [-121.29631, 38.67233], [-121.2963, 38.67214], [-121.29687, 38.67227], [-121.29722, 38.67242], [-121.29767, 38.67288], [-121.29844, 38.67353], [-121.29879, 38.67377], [-121.2998, 38.67379], [-121.30011, 38.67385], [-121.30119, 38.67445]]]} | Open Access 1 | Cherry Creek Park | 17168 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 5.477 | Cherry Creek Park | ||
3225 | 3225 | 3224 | {"type": "Polygon", "coordinates": [[[-121.32967, 38.66609], [-121.32964, 38.66739], [-121.3274, 38.66735], [-121.32743, 38.66607], [-121.32967, 38.66609]]]} | Open Access 1 | Eugene H. Ahner Park | 18747 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 6.924 | Eugene H. Ahner Park | ||
9057 | 9057 | 9056 | {"type": "Polygon", "coordinates": [[[-121.31568, 38.69751], [-121.31552, 38.69781], [-121.31481, 38.69827], [-121.31439, 38.69835], [-121.31419, 38.69842], [-121.31392, 38.69795], [-121.31381, 38.69784], [-121.31398, 38.69777], [-121.31397, 38.69775], [-121.31416, 38.69742], [-121.31415, 38.69721], [-121.31401, 38.69705], [-121.31375, 38.69696], [-121.31346, 38.69696], [-121.31317, 38.6971], [-121.31305, 38.69697], [-121.31275, 38.69713], [-121.31258, 38.69697], [-121.31224, 38.69659], [-121.31218, 38.6965], [-121.31212, 38.69647], [-121.31204, 38.69646], [-121.31195, 38.69648], [-121.31187, 38.69654], [-121.31177, 38.69634], [-121.31341, 38.69635], [-121.31343, 38.69584], [-121.31367, 38.69583], [-121.31372, 38.69604], [-121.31399, 38.69654], [-121.31426, 38.69684], [-121.31442, 38.69697], [-121.31478, 38.69722], [-121.31517, 38.69738], [-121.31519, 38.69736], [-121.31568, 38.69751]]]} | Open Access 1 | Twin Creek Park | 26611 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 6.987 | Twin Creek Park | ||
9571 | 9571 | 9570 | {"type": "Polygon", "coordinates": [[[-121.30473, 38.71495], [-121.30471, 38.71498], [-121.30415, 38.71518], [-121.30403, 38.71521], [-121.30394, 38.71529], [-121.30394, 38.71535], [-121.30359, 38.71547], [-121.30346, 38.71549], [-121.30209, 38.71555], [-121.30196, 38.71558], [-121.3018, 38.71563], [-121.30158, 38.71577], [-121.30262, 38.71457], [-121.3039, 38.7134], [-121.30404, 38.71349], [-121.30425, 38.7135], [-121.30427, 38.71358], [-121.30442, 38.71359], [-121.30442, 38.71386], [-121.30448, 38.71433], [-121.30462, 38.71472], [-121.30473, 38.71495]]]} | Open Access 1 | Westwood Park | 27443 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 8.006 | Westwood Park | ||
10656 | 10656 | 10655 | {"type": "Polygon", "coordinates": [[[-121.29753, 38.68641], [-121.2974, 38.68646], [-121.29736, 38.68685], [-121.29714, 38.68685], [-121.29667, 38.68717], [-121.29624, 38.68735], [-121.296, 38.68743], [-121.29578, 38.68746], [-121.29556, 38.68754], [-121.29524, 38.68772], [-121.29515, 38.68767], [-121.29549, 38.68754], [-121.29539, 38.68738], [-121.29508, 38.68749], [-121.29508, 38.68739], [-121.29513, 38.68721], [-121.29532, 38.68724], [-121.29552, 38.68715], [-121.29604, 38.68684], [-121.29589, 38.68649], [-121.29591, 38.68643], [-121.29593, 38.68599], [-121.2959, 38.68585], [-121.29584, 38.68574], [-121.29604, 38.68558], [-121.29603, 38.68548], [-121.2962, 38.68548], [-121.29621, 38.68546], [-121.29615, 38.68531], [-121.29596, 38.68523], [-121.29578, 38.68508], [-121.29591, 38.68501], [-121.29603, 38.68493], [-121.2961, 38.68484], [-121.29623, 38.68464], [-121.2963, 38.68458], [-121.29636, 38.68457], [-121.2965, 38.68458], [-121.29656, 38.6846], [-121.29672, 38.68479], [-121.29685, 38.68497], [-121.29698, 38.6852], [-121.29753, 38.68641]]]} | Open Access 1 | Van Maren Park | 26827 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 8.049 | Van Maren 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]);