superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 41 sorted by map 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8055 | 8055 | 8054 | {"type": "Polygon", "coordinates": [[[-120.88556, 37.52021], [-120.88521, 37.51984], [-120.88476, 37.51929], [-120.88313, 37.51663], [-120.88214, 37.51477], [-120.88239, 37.51468], [-120.88255, 37.51454], [-120.88545, 37.51453], [-120.88545, 37.51814], [-120.88544, 37.51869], [-120.88547, 37.51882], [-120.88554, 37.51896], [-120.88556, 37.52021]]]} | Open Access 1 | Pedretti Park | 23561 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 25.207 | Pedretti Park | ||
2197 | 2197 | 2196 | {"type": "Polygon", "coordinates": [[[-120.88136, 37.53461], [-120.88115, 37.53479], [-120.88095, 37.53489], [-120.88068, 37.53495], [-120.88041, 37.53495], [-120.88049, 37.53372], [-120.88047, 37.5333], [-120.88062, 37.5336], [-120.88084, 37.53392], [-120.88105, 37.53417], [-120.88134, 37.53445], [-120.88133, 37.53453], [-120.88136, 37.53461]]]} | Open Access 1 | Brad Bates Park | 16322 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1.958 | Brad Bates Park | ||
3611 | 3611 | 3610 | {"type": "Polygon", "coordinates": [[[-120.8808, 37.50024], [-120.87679, 37.50024], [-120.87679, 37.50016], [-120.87661, 37.50004], [-120.8766, 37.49988], [-120.87658, 37.4998], [-120.87646, 37.49955], [-120.87639, 37.49949], [-120.87634, 37.49942], [-120.87632, 37.49793], [-120.87652, 37.49793], [-120.87654, 37.49792], [-120.87651, 37.49766], [-120.87648, 37.49741], [-120.87645, 37.49733], [-120.87643, 37.49713], [-120.87642, 37.49561], [-120.87868, 37.49562], [-120.87871, 37.49551], [-120.88074, 37.4955], [-120.88077, 37.49712], [-120.88076, 37.49779], [-120.88078, 37.49844], [-120.8808, 37.50024]]]} | Open Access 1 | Dianne Park | 18150 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 49.275 | Dianne Park | ||
7472 | 7472 | 7471 | {"type": "Polygon", "coordinates": [[[-120.88049, 37.53372], [-120.88041, 37.53495], [-120.88038, 37.53654], [-120.87582, 37.53652], [-120.87585, 37.53545], [-120.87589, 37.53495], [-120.87593, 37.53376], [-120.88049, 37.53372]]]} | Open Access 1 | North Turlock Sports Complex | 22863 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 30.779 | North Turlock Sports Complex | ||
13971 | 13971 | 13970 | {"type": "Polygon", "coordinates": [[[-120.87765, 37.51347], [-120.87639, 37.51347], [-120.87637, 37.51177], [-120.87638, 37.51173], [-120.87641, 37.51168], [-120.87642, 37.51164], [-120.87639, 37.51156], [-120.8763, 37.5115], [-120.87639, 37.51151], [-120.87652, 37.51182], [-120.87665, 37.51203], [-120.87689, 37.51238], [-120.87736, 37.51296], [-120.87753, 37.51319], [-120.87765, 37.51347]]]} | Open Access 1 | Swanson Centennial Park | 32563 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 2.964 | Swanson Centennial Park | 2008 | |
13968 | 13968 | 13967 | {"type": "Polygon", "coordinates": [[[-120.87596, 37.53289], [-120.87589, 37.53495], [-120.87568, 37.53495], [-120.87543, 37.53491], [-120.8752, 37.53482], [-120.87494, 37.53462], [-120.87492, 37.53459], [-120.87493, 37.5345], [-120.87492, 37.53443], [-120.87532, 37.534], [-120.87558, 37.53365], [-120.8758, 37.53328], [-120.87596, 37.53289]]]} | Open Access 1 | Curt Andre Park | 32560 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 2.568 | Curt Andre Park | ||
4346 | 4346 | 4345 | {"type": "Polygon", "coordinates": [[[-120.87312, 37.52606], [-120.87307, 37.5261], [-120.87207, 37.5261], [-120.87192, 37.52599], [-120.87183, 37.52596], [-120.87175, 37.52596], [-120.87168, 37.52599], [-120.87161, 37.52607], [-120.87161, 37.52545], [-120.8719, 37.52544], [-120.87198, 37.52538], [-120.87199, 37.52531], [-120.87199, 37.52526], [-120.87194, 37.52518], [-120.87194, 37.52491], [-120.87197, 37.52481], [-120.87201, 37.52475], [-120.87213, 37.52464], [-120.87231, 37.52458], [-120.87256, 37.52457], [-120.87266, 37.52459], [-120.8728, 37.52467], [-120.87295, 37.52483], [-120.87306, 37.52554], [-120.87313, 37.52583], [-120.87312, 37.52606]]]} | Open Access 1 | Four Seasons Park | 19026 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 4.273 | Four Seasons Park | ||
13965 | 13965 | 13964 | {"type": "Polygon", "coordinates": [[[-120.87145, 37.5294], [-120.8714, 37.53098], [-120.87017, 37.53099], [-120.87014, 37.53131], [-120.86703, 37.53126], [-120.86714, 37.52943], [-120.87057, 37.52948], [-120.87145, 37.5294]]]} | Open Access 1 | Walnut Christoffersen Storm Basin | 32556 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 18.392 | Walnut Christoffersen Storm Basin | ||
13966 | 13966 | 13965 | {"type": "Polygon", "coordinates": [[[-120.8714, 37.53098], [-120.8714, 37.53114], [-120.87138, 37.53133], [-120.87014, 37.53131], [-120.87015, 37.53099], [-120.8714, 37.53098]]]} | Open Access 1 | BMX Bike Park | 32557 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1.024 | BMX Bike Park | ||
9033 | 9033 | 9032 | {"type": "Polygon", "coordinates": [[[-120.86724, 37.50022], [-120.86539, 37.50025], [-120.86541, 37.49801], [-120.86237, 37.49803], [-120.86236, 37.4969], [-120.86414, 37.49687], [-120.8642, 37.49471], [-120.8649, 37.49469], [-120.86489, 37.49284], [-120.86718, 37.49284], [-120.86717, 37.49545], [-120.86721, 37.49685], [-120.86724, 37.50022]]]} | Open Access 1 | Turlock Memorial Park Cemetery | 26582 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 49.4 | Turlock Memorial Park Cemetery | ||
10050 | 10050 | 10049 | {"type": "Polygon", "coordinates": [[[-120.86475, 37.5022], [-120.86468, 37.50228], [-120.86459, 37.50236], [-120.86459, 37.50246], [-120.86464, 37.50252], [-120.86467, 37.50344], [-120.86461, 37.5035], [-120.86437, 37.5035], [-120.8641, 37.50357], [-120.86391, 37.50365], [-120.86378, 37.50374], [-120.86361, 37.50389], [-120.86347, 37.50412], [-120.86342, 37.50434], [-120.86342, 37.50596], [-120.8635, 37.50621], [-120.86358, 37.50634], [-120.86384, 37.50658], [-120.86395, 37.5067], [-120.86403, 37.50681], [-120.86408, 37.50699], [-120.86409, 37.50712], [-120.86403, 37.50717], [-120.86253, 37.50715], [-120.86247, 37.50711], [-120.8625, 37.50223], [-120.86475, 37.5022]]]} | Open Access 1 | Summerfaire Park | 25955 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 16.647 | Summerfaire Park | ||
9010 | 9010 | 9009 | {"type": "Polygon", "coordinates": [[[-120.8625, 37.52003], [-120.86037, 37.52003], [-120.86039, 37.51965], [-120.86036, 37.51958], [-120.86035, 37.51911], [-120.8604, 37.51907], [-120.86243, 37.51907], [-120.8625, 37.51912], [-120.8625, 37.52003]]]} | Open Access 1 | Rotary International Park | 24685 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 4.976 | Rotary International Park | ||
9755 | 9755 | 9754 | {"type": "Polygon", "coordinates": [[[-120.86219, 37.49477], [-120.86219, 37.4956], [-120.86107, 37.49559], [-120.86107, 37.4953], [-120.86105, 37.49518], [-120.86094, 37.49497], [-120.86088, 37.49479], [-120.86219, 37.49477]]]} | Open Access 1 | Soderquist Park | 25590 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 2.339 | Soderquist Park | ||
13963 | 13963 | 13962 | {"type": "Polygon", "coordinates": [[[-120.86036, 37.48086], [-120.85915, 37.48087], [-120.85916, 37.48008], [-120.86035, 37.48008], [-120.86036, 37.48086]]]} | Open Access 1 | Montana Park | 32554 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 2.272 | Montana Park | 2016 | |
13964 | 13964 | 13963 | {"type": "Polygon", "coordinates": [[[-120.86035, 37.48086], [-120.86034, 37.48177], [-120.85923, 37.48177], [-120.85923, 37.48109], [-120.85915, 37.48107], [-120.85915, 37.48087], [-120.86035, 37.48086]]]} | Open Access 1 | Montana Park, Phase 2 | 32555 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 2.49 | Montana Park, Phase 2 | ||
3658 | 3658 | 3657 | {"type": "Polygon", "coordinates": [[[-120.85795, 37.51084], [-120.85467, 37.51087], [-120.85466, 37.51054], [-120.85329, 37.51053], [-120.85332, 37.508], [-120.8533, 37.50783], [-120.85319, 37.50749], [-120.85321, 37.50743], [-120.85506, 37.50741], [-120.85577, 37.50746], [-120.85794, 37.50748], [-120.85795, 37.51084]]]} | Open Access 1 | Donnelly Park | 18212 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 37.329 | Donnelly Park | ||
3120 | 3120 | 3119 | {"type": "Polygon", "coordinates": [[[-120.85675, 37.49166], [-120.85466, 37.49166], [-120.85468, 37.49088], [-120.85531, 37.49088], [-120.85532, 37.49057], [-120.85612, 37.49057], [-120.85614, 37.49088], [-120.85675, 37.4909], [-120.85675, 37.49166]]]} | Open Access 1 | Columbia Park | 17548 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 4.552 | Columbia Park | ||
4212 | 4212 | 4211 | {"type": "Polygon", "coordinates": [[[-120.8557, 37.53293], [-120.85571, 37.53303], [-120.85565, 37.53511], [-120.85523, 37.53496], [-120.85498, 37.53482], [-120.85405, 37.5341], [-120.85404, 37.53404], [-120.85513, 37.53316], [-120.85543, 37.53301], [-120.8557, 37.53293]]]} | Open Access 1 | Ferreira Ranch | 18885 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 5.042 | Ferreira Ranch | ||
1562 | 1562 | 1561 | {"type": "Polygon", "coordinates": [[[-120.85242, 37.4975], [-120.85158, 37.49809], [-120.85103, 37.4976], [-120.85187, 37.49701], [-120.85242, 37.4975]]]} | Open Access 1 | Broadway Park | 16408 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1.782 | Broadway Park | ||
8938 | 8938 | 8937 | {"type": "Polygon", "coordinates": [[[-120.85131, 37.52948], [-120.85129, 37.52985], [-120.8513, 37.53009], [-120.8513, 37.53114], [-120.84914, 37.53115], [-120.84914, 37.53039], [-120.84916, 37.53021], [-120.84914, 37.52964], [-120.84934, 37.52949], [-120.84954, 37.52949], [-120.84972, 37.52947], [-120.85131, 37.52948]]]} | Open Access 1 | Rose Circle Park | 24607 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 8.681 | Rose Circle 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]);