units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where GAP_STS = 4 and MNG_AGENCY = 41
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 3
MNG_AG_TYP 1
- City Agency 30
MNG_AGENCY 1
- Turlock, City of · 30 ✖
ACCESS_TYP 1
- Open Access 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | 100 | {"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 | 317 | Pedretti Park | 23561 | 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 | 25.207 | Pedretti 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
158 | 158 | 157 | {"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.53022], [-120.84914, 37.52964], [-120.84934, 37.52949], [-120.84954, 37.52949], [-120.84972, 37.52947], [-120.85131, 37.52948]]]} | Open Access 1 | 404 | Rose Circle Park | 24607 | 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 | 8.682 | Rose Circle Park | 0 | Local Park 2 | 4 | |
161 | 161 | 160 | {"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.51911], [-120.8625, 37.52003]]]} | Open Access 1 | 410 | Rotary International Park | 24685 | 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.977 | Rotary International Park | 0 | Local Park 2 | 4 | |
162 | 162 | 161 | {"type": "Polygon", "coordinates": [[[-120.86475, 37.5022], [-120.86469, 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.86362, 37.50389], [-120.86347, 37.50412], [-120.86342, 37.50435], [-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.50712], [-120.8625, 37.50223], [-120.86475, 37.5022]]]} | Open Access 1 | 423 | Summerfaire Park | 25955 | 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 | 16.647 | Summerfaire Park | 0 | Local Park 2 | 4 | |
164 | 164 | 163 | {"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 | 426 | Quaile Rand Norton Park | 32562 | 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 | 9.749 | Quaile Rand Norton 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 | |
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 | |
5117 | 5117 | 5116 | {"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 | 48072 | Tot Lot | 32564 | 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.327 | Tot Lot | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
5530 | 5530 | 5529 | {"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 | 399 | North Turlock Sports Complex | 22863 | 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 | 30.78 | North Turlock Sports Complex | 0 | Local Recreation Area 3 | 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 | |
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 |
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]);