units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 41 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 5
MNG_AG_TYP 1
- City Agency 32
MNG_AGENCY 1
- Turlock, City of · 32 ✖
ACCESS_TYP 1
- Open Access 32
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME ▼ | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11371 | 11371 | 11370 | {"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 | 48065 | BMX Bike Park | 32557 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 1.024 | BMX Bike Park | 0 | Local Park 2 | 4 | |
113 | 113 | 112 | {"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 | 328 | Bothun Park | 16292 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 0.451 | Bothun Park | 0 | Local Park 2 | 4 | |
12330 | 12330 | 12329 | {"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 | 25997 | Brad Bates Park | 16322 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 1.958 | Brad Bates Park | 0 | Local Park 2 | 4 | |
3212 | 3212 | 3211 | {"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 | 48066 | Brandon Koch Memorial Skate Park | 32558 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 1.221 | Brandon Koch Memorial Skate Park | 0 | Local Recreation Area 3 | 4 | |
121 | 121 | 120 | {"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.81869, 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.51175], [-120.82047, 37.51187], [-120.82047, 37.5121]]]} | Open Access 1 | 334 | Bristol Park | 16401 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 3.933 | Bristol Park | 0 | Local Park 2 | 4 | |
5882 | 5882 | 5881 | {"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 | 340 | Broadway Park | 16408 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 1.782 | Broadway Park | 0 | Local Park 2 | 4 | |
135 | 135 | 134 | {"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 | 344 | Central Park | 17063 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 0.538 | Central Park | 0 | Local Park 2 | 4 | |
117 | 117 | 116 | {"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 | 349 | Christoffersen Park | 17230 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 11.803 | Christoffersen Park | 0 | Local Park 2 | 4 | |
5213 | 5213 | 5212 | {"type": "Polygon", "coordinates": [[[-120.85675, 37.49166], [-120.85466, 37.49166], [-120.85468, 37.49088], [-120.85532, 37.49088], [-120.85532, 37.49057], [-120.85612, 37.49057], [-120.85613, 37.49088], [-120.85675, 37.4909], [-120.85675, 37.49166]]]} | Open Access 1 | 355 | Columbia Park | 17548 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 4.548 | Columbia Park | 0 | Local Park 2 | 4 | |
5905 | 5905 | 5904 | {"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 | 360 | Crane Park | 17758 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 7.919 | Crane Park | 0 | Local Park 2 | 4 | |
12331 | 12331 | 12330 | {"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 | 26000 | Curt Andre Park | 32560 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 2.568 | Curt Andre Park | 0 | Local Park 2 | 4 | |
11377 | 11377 | 11376 | {"type": "Polygon", "coordinates": [[[-120.83413, 37.53238], [-120.83405, 37.53263], [-120.83402, 37.53281], [-120.834, 37.5336], [-120.83395, 37.53364], [-120.83356, 37.53362], [-120.83334, 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 | 48067 | Dale Pinkney Park | 32561 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 3.122 | Dale Pinkney Park | 0 | Local Park 2 | 4 | |
5911 | 5911 | 5910 | {"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 | 368 | Denair Park | 18083 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 0.777 | Denair Park | 0 | Local Park 2 | 4 | |
5917 | 5917 | 5916 | {"type": "Polygon", "coordinates": [[[-120.88077, 37.49712], [-120.88076, 37.49779], [-120.88078, 37.49844], [-120.8808, 37.50024], [-120.87679, 37.50024], [-120.8768, 37.50017], [-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.87653, 37.49793], [-120.87654, 37.49792], [-120.87651, 37.49766], [-120.87647, 37.49741], [-120.87645, 37.49733], [-120.87643, 37.49713], [-120.87642, 37.49561], [-120.87869, 37.49562], [-120.87871, 37.49551], [-120.88074, 37.4955], [-120.88077, 37.49712]]]} | Open Access 1 | 374 | Dianne Park | 18150 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 49.277 | Dianne Park | 0 | Local Park 2 | 4 | |
148 | 148 | 147 | {"type": "Polygon", "coordinates": [[[-120.85795, 37.51084], [-120.85467, 37.51087], [-120.85467, 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 | 380 | Donnelly Park | 18212 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 37.329 | Donnelly Park | 0 | Local Park 2 | 4 | |
12387 | 12387 | 12386 | {"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.85514, 37.53316], [-120.85543, 37.53301], [-120.8557, 37.53293]]]} | Open Access 1 | 26531 | Ferreira Ranch | 18885 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 5.042 | Ferreira Ranch | 0 | Local Park 2 | 4 | |
5522 | 5522 | 5521 | {"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.52525], [-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 | 384 | Four Seasons Park | 19026 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 4.273 | Four Seasons Park | 0 | Local Park 2 | 4 | |
151 | 151 | 150 | {"type": "Polygon", "coordinates": [[[-120.84027, 37.49579], [-120.83997, 37.49599], [-120.83997, 37.49554], [-120.84027, 37.49579], [-120.84027, 37.49579]]]} | Open Access 1 | 390 | Gar Park | 19187 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 0.164 | Gar Park | 0 | Local Park 2 | 4 | |
5529 | 5529 | 5528 | {"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 | 395 | Markley Park | 21875 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 6.503 | Markley Park | 0 | Local Park 2 | 4 | |
4787 | 4787 | 4786 | {"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 | 48062 | Montana Park | 32554 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 2.273 | Montana Park | 2016 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);