superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 41 sorted by ACCESS_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
13970 | 13970 | 13969 | {"type": "Polygon", "coordinates": [[[-120.83063, 37.48901], [-120.8284, 37.48899], [-120.82841, 37.48718], [-120.83061, 37.4872], [-120.83063, 37.48901]]]} | Open Access 1 | Quaile Rand Norton Park | 32562 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 9.747 | Quaile Rand Norton 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 | |
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 |
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]);