superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 41 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4476 | 4476 | 4475 | {"type": "Polygon", "coordinates": [[[-120.84027, 37.49579], [-120.83997, 37.49599], [-120.83997, 37.49554], [-120.83997, 37.49554], [-120.84027, 37.49579]]]} | Open Access 1 | Gar Park | 19187 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 0.164 | Gar Park | ||
13972 | 13972 | 13971 | {"type": "Polygon", "coordinates": [[[-120.84391, 37.47676], [-120.8439, 37.47694], [-120.84332, 37.47693], [-120.84333, 37.47674], [-120.8434, 37.47668], [-120.84385, 37.47671], [-120.84391, 37.47676]]]} | Open Access 1 | Tot Lot | 32564 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 0.327 | Tot Lot | ||
2163 | 2163 | 2162 | {"type": "Polygon", "coordinates": [[[-120.83275, 37.48942], [-120.83182, 37.48941], [-120.83182, 37.48919], [-120.83251, 37.48918], [-120.83275, 37.48942]]]} | Open Access 1 | Bothun Park | 16292 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 0.451 | Bothun Park | ||
2067 | 2067 | 2066 | {"type": "Polygon", "coordinates": [[[-120.8462, 37.49432], [-120.846, 37.49446], [-120.84529, 37.49384], [-120.8455, 37.4937], [-120.8462, 37.49432]]]} | Open Access 1 | Central Park | 17063 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 0.538 | Central Park | ||
3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-120.83929, 37.49929], [-120.83836, 37.49996], [-120.83836, 37.49996], [-120.83834, 37.49928], [-120.83929, 37.49929]]]} | Open Access 1 | Denair Park | 18083 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 0.777 | Denair Park | ||
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 | ||
13967 | 13967 | 13966 | {"type": "Polygon", "coordinates": [[[-120.84495, 37.50234], [-120.84431, 37.50234], [-120.84432, 37.50155], [-120.84494, 37.50155], [-120.84495, 37.50234]]]} | Open Access 1 | Brandon Koch Memorial Skate Park | 32558 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1.221 | Brandon Koch Memorial Skate Park | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | |
13969 | 13969 | 13968 | {"type": "Polygon", "coordinates": [[[-120.83413, 37.53238], [-120.83406, 37.53263], [-120.83403, 37.53281], [-120.834, 37.5336], [-120.83395, 37.53364], [-120.83356, 37.53362], [-120.83335, 37.53355], [-120.83317, 37.53343], [-120.83307, 37.53331], [-120.833, 37.53313], [-120.83298, 37.53282], [-120.83293, 37.53237], [-120.83298, 37.53232], [-120.83408, 37.53233], [-120.83413, 37.53238]]]} | Open Access 1 | Dale Pinkney Park | 32561 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 3.122 | Dale Pinkney Park | ||
2266 | 2266 | 2265 | {"type": "Polygon", "coordinates": [[[-120.82047, 37.5121], [-120.8204, 37.51213], [-120.82023, 37.51213], [-120.81968, 37.512], [-120.81952, 37.51198], [-120.81935, 37.51201], [-120.81911, 37.51208], [-120.81873, 37.51224], [-120.81851, 37.51228], [-120.81832, 37.51227], [-120.81822, 37.51224], [-120.81804, 37.51217], [-120.81804, 37.5121], [-120.81817, 37.51194], [-120.81835, 37.5118], [-120.81868, 37.51157], [-120.81886, 37.51136], [-120.81893, 37.51131], [-120.81903, 37.51125], [-120.81915, 37.51121], [-120.81941, 37.51118], [-120.8197, 37.51121], [-120.81977, 37.51124], [-120.82014, 37.5114], [-120.82027, 37.5115], [-120.82037, 37.51163], [-120.82044, 37.51176], [-120.82047, 37.51187], [-120.82047, 37.5121]]]} | Open Access 1 | Bristol Park | 16401 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 3.932 | Bristol 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 | ||
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 | ||
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 | ||
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 |
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]);