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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
6696 | 6696 | 6695 | {"type": "Polygon", "coordinates": [[[-120.83065, 37.52046], [-120.83065, 37.52154], [-120.83048, 37.52167], [-120.82841, 37.52165], [-120.82836, 37.52161], [-120.82836, 37.52118], [-120.8284, 37.52093], [-120.82851, 37.52077], [-120.82865, 37.52063], [-120.82884, 37.52052], [-120.82909, 37.52043], [-120.82919, 37.52042], [-120.83059, 37.52042], [-120.83065, 37.52046]]]} | Open Access 1 | Markley Park | 21875 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 6.503 | Markley Park | ||
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 | ||
3287 | 3287 | 3286 | {"type": "Polygon", "coordinates": [[[-120.83346, 37.50072], [-120.83346, 37.50072], [-120.83084, 37.50259], [-120.83086, 37.50036], [-120.83313, 37.5004], [-120.83346, 37.50072]]]} | Open Access 1 | Crane Park | 17758 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 7.918 | Crane 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 | ||
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 | ||
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 | ||
2923 | 2923 | 2922 | {"type": "Polygon", "coordinates": [[[-120.84436, 37.53193], [-120.84235, 37.53192], [-120.84237, 37.52946], [-120.84402, 37.52949], [-120.84431, 37.52954], [-120.84434, 37.52957], [-120.84436, 37.53193]]]} | Open Access 1 | Christoffersen Park | 17230 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 11.802 | Christoffersen 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);