units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where COUNTY = 29, MNG_AGENCY = 152 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
379 | 379 | 378 | {"type": "Polygon", "coordinates": [[[-119.30973, 36.31657], [-119.30811, 36.31656], [-119.30811, 36.31599], [-119.30871, 36.31599], [-119.30871, 36.31591], [-119.30973, 36.31592], [-119.30973, 36.31657]]]} | Open Access 1 | 1397 | Rotary Park | 24697 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 2.505 | Rotary Park | 0 | Local Park 2 | 4 | |
424 | 424 | 423 | {"type": "Polygon", "coordinates": [[[-119.29357, 36.30286], [-119.29341, 36.30336], [-119.29286, 36.30364], [-119.29231, 36.30375], [-119.29185, 36.30434], [-119.29179, 36.30191], [-119.29322, 36.30197], [-119.29357, 36.30286]]]} | Open Access 1 | 1307 | Blain Park | 16147 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 7.099 | Blain Park | 0 | Local Park 2 | 4 | |
437 | 437 | 436 | {"type": "Polygon", "coordinates": [[[-119.26048, 36.3315], [-119.26048, 36.33249], [-119.26047, 36.33253], [-119.26043, 36.33256], [-119.25979, 36.33265], [-119.25935, 36.33274], [-119.25908, 36.33282], [-119.25872, 36.33298], [-119.258, 36.33343], [-119.25742, 36.33278], [-119.25769, 36.33246], [-119.25781, 36.33241], [-119.25819, 36.3323], [-119.25849, 36.3323], [-119.25857, 36.33227], [-119.25898, 36.33176], [-119.2591, 36.33169], [-119.25933, 36.33166], [-119.26009, 36.3316], [-119.26034, 36.33152], [-119.26048, 36.3315]]]} | Open Access 1 | 1373 | Mill Creek Park | 22226 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 7.02 | Mill Creek Park | 0 | Local Park 2 | 4 | |
440 | 440 | 439 | {"type": "Polygon", "coordinates": [[[-119.26949, 36.32014], [-119.26948, 36.32187], [-119.2684, 36.32186], [-119.26942, 36.32014], [-119.26949, 36.32014]]]} | Open Access 1 | 1377 | Pinkham Park | 23697 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 2.438 | Pinkham Park | 0 | Local Park 2 | 4 | |
443 | 443 | 442 | {"type": "Polygon", "coordinates": [[[-119.39303, 36.32471], [-119.39295, 36.32489], [-119.3927, 36.32484], [-119.39045, 36.32479], [-119.39025, 36.32471], [-119.39042, 36.32429], [-119.39019, 36.32419], [-119.39003, 36.32446], [-119.38997, 36.3248], [-119.38972, 36.3248], [-119.38943, 36.32484], [-119.38905, 36.325], [-119.38869, 36.32501], [-119.38834, 36.32486], [-119.38818, 36.32466], [-119.38794, 36.32414], [-119.3879, 36.32397], [-119.38792, 36.32382], [-119.38827, 36.32255], [-119.38842, 36.32226], [-119.38852, 36.32213], [-119.38869, 36.32201], [-119.38888, 36.32191], [-119.38905, 36.32185], [-119.38952, 36.32175], [-119.38983, 36.32163], [-119.38997, 36.32155], [-119.39026, 36.32131], [-119.39047, 36.32109], [-119.39063, 36.32115], [-119.39073, 36.32123], [-119.39297, 36.3245], [-119.39303, 36.32471]]]} | Open Access 1 | 1382 | Plaza Park | 23789 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 30.735 | Plaza Park | 0 | Local Park 2 | 4 | |
448 | 448 | 447 | {"type": "Polygon", "coordinates": [[[-119.29575, 36.3494], [-119.29573, 36.34943], [-119.29569, 36.34945], [-119.29303, 36.34945], [-119.29303, 36.34908], [-119.29362, 36.34907], [-119.29362, 36.34869], [-119.29453, 36.34869], [-119.29474, 36.34876], [-119.29475, 36.34907], [-119.29575, 36.34907], [-119.29575, 36.3494]]]} | Open Access 1 | 1423 | Summers Park | 25962 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 3.543 | Summers Park | 0 | Local Park 2 | 4 | |
451 | 451 | 450 | {"type": "Polygon", "coordinates": [[[-119.35845, 36.30491], [-119.35812, 36.30491], [-119.35813, 36.30483], [-119.35808, 36.30476], [-119.35794, 36.30469], [-119.35539, 36.30267], [-119.35521, 36.30254], [-119.35495, 36.30239], [-119.3547, 36.30229], [-119.35443, 36.30221], [-119.35415, 36.30216], [-119.35414, 36.30183], [-119.35841, 36.30181], [-119.35845, 36.30491]]]} | Open Access 1 | 1428 | Sunset Park | 26060 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 17.015 | Sunset Park | 0 | Local Park 2 | 4 | |
455 | 455 | 454 | {"type": "Polygon", "coordinates": [[[-119.299, 36.30937], [-119.29899, 36.31088], [-119.29635, 36.31086], [-119.29632, 36.30936], [-119.29769, 36.30936], [-119.2977, 36.30976], [-119.29878, 36.30976], [-119.29879, 36.30937], [-119.299, 36.30937]]]} | Open Access 1 | 1455 | Whitendale Park | 27467 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 8.795 | Whitendale Park | 0 | Local Park 2 | 4 | |
3295 | 3295 | 3294 | {"type": "Polygon", "coordinates": [[[-119.25609, 36.31977], [-119.25602, 36.31982], [-119.25347, 36.31981], [-119.25306, 36.31979], [-119.25254, 36.31974], [-119.25194, 36.31973], [-119.25193, 36.31972], [-119.25193, 36.31945], [-119.25213, 36.31937], [-119.25339, 36.3194], [-119.2537, 36.31936], [-119.25504, 36.3188], [-119.25534, 36.31852], [-119.25606, 36.31735], [-119.25609, 36.31977]]]} | Open Access 1 | 48206 | Kiwanis Park | 32746 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 8.359 | Kiwanis Park | 0 | Local Park 2 | 4 | |
3297 | 3297 | 3296 | {"type": "Polygon", "coordinates": [[[-119.29982, 36.32794], [-119.29965, 36.32791], [-119.2994, 36.32779], [-119.29924, 36.32763], [-119.29911, 36.32757], [-119.29892, 36.32754], [-119.29892, 36.32746], [-119.29982, 36.32746], [-119.29982, 36.32794]]]} | Open Access 1 | 48209 | Miki City Park | 32749 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 0.631 | Miki City Park | 2017 | Local Park 2 | 4 | |
3298 | 3298 | 3297 | {"type": "Polygon", "coordinates": [[[-119.32391, 36.29146], [-119.32376, 36.29168], [-119.32378, 36.29355], [-119.32306, 36.29357], [-119.32316, 36.29408], [-119.32306, 36.29433], [-119.3229, 36.29447], [-119.32267, 36.29453], [-119.32262, 36.29411], [-119.32249, 36.29357], [-119.32246, 36.29324], [-119.32246, 36.29226], [-119.32249, 36.29199], [-119.32261, 36.29152], [-119.32267, 36.29147], [-119.32391, 36.29146]]]} | Open Access 1 | 48210 | Perry Family Park | 32750 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 7.781 | Perry Family Park | 0 | Local Park 2 | 4 | |
3299 | 3299 | 3298 | {"type": "Polygon", "coordinates": [[[-119.3038, 36.33243], [-119.30349, 36.33305], [-119.30313, 36.33297], [-119.30331, 36.33236], [-119.30375, 36.33236], [-119.3038, 36.33243]]]} | Open Access 1 | 48211 | Provident Skate Park | 32751 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 0.738 | Provident Skate Park | 0 | Local Recreation Area 3 | 4 | |
3964 | 3964 | 3963 | {"type": "Polygon", "coordinates": [[[-119.34315, 36.30141], [-119.34314, 36.30324], [-119.34078, 36.3032], [-119.34078, 36.30277], [-119.34081, 36.30223], [-119.34239, 36.30225], [-119.3424, 36.30142], [-119.34315, 36.30141]]]} | Open Access 1 | 1357 | Linwood Park | 21309 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 7.229 | Linwood Park | 0 | Local Park 2 | 4 | |
4039 | 4039 | 4038 | {"type": "Polygon", "coordinates": [[[-119.3057, 36.35936], [-119.30569, 36.36362], [-119.29729, 36.36359], [-119.29718, 36.36351], [-119.29718, 36.36299], [-119.2972, 36.36276], [-119.2972, 36.36186], [-119.29717, 36.36185], [-119.29718, 36.36115], [-119.2972, 36.36093], [-119.29719, 36.3602], [-119.29729, 36.36012], [-119.2973, 36.36001], [-119.29818, 36.35999], [-119.30454, 36.35938], [-119.30485, 36.35936], [-119.3057, 36.35936]]]} | Open Access 1 | 44284 | Visalia Riverway Sports Complex | 27162 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 82.276 | Visalia Riverway Sports Complex | 0 | Local Recreation Area 3 | 4 | |
4817 | 4817 | 4816 | {"type": "Polygon", "coordinates": [[[-119.26386, 36.30007], [-119.26391, 36.3001], [-119.26397, 36.30019], [-119.26399, 36.30025], [-119.26399, 36.30034], [-119.26394, 36.3005], [-119.2639, 36.30055], [-119.26383, 36.30074], [-119.26376, 36.30076], [-119.26331, 36.30076], [-119.26326, 36.30074], [-119.26324, 36.3007], [-119.26328, 36.30058], [-119.2634, 36.30041], [-119.26381, 36.30008], [-119.26386, 36.30007]]]} | Open Access 1 | 48855 | Unknown park - Visalia, City of | 33575 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 0.807 | 0 | Local Other or Unknown 14 | 4 | ||
5182 | 5182 | 5181 | {"type": "Polygon", "coordinates": [[[-119.29371, 36.33999], [-119.29303, 36.34055], [-119.29255, 36.34016], [-119.29323, 36.3396], [-119.29371, 36.33999]]]} | Open Access 1 | 1440 | Wittman Village Park | 27665 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 1.314 | Wittman Village Park | 0 | Local Park 2 | 4 | |
5249 | 5249 | 5248 | {"type": "Polygon", "coordinates": [[[-119.29586, 36.3249], [-119.29461, 36.32491], [-119.2946, 36.32373], [-119.29585, 36.32374], [-119.29586, 36.3249]]]} | Open Access 1 | 1346 | Jefferson Park | 20382 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 3.612 | Jefferson Park | 0 | Local Park 2 | 4 | |
6231 | 6231 | 6230 | {"type": "Polygon", "coordinates": [[[-119.34929, 36.30185], [-119.34928, 36.30188], [-119.34637, 36.30189], [-119.34623, 36.30204], [-119.34614, 36.3037], [-119.34592, 36.30409], [-119.34458, 36.3041], [-119.34457, 36.30187], [-119.34929, 36.30185]]]} | Open Access 1 | 1311 | Combs Park | 17558 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 8.928 | Combs Park | 0 | Local Park 2 | 4 | |
6238 | 6238 | 6237 | {"type": "Polygon", "coordinates": [[[-119.28765, 36.34795], [-119.28732, 36.34795], [-119.28732, 36.34788], [-119.28729, 36.34781], [-119.28722, 36.34777], [-119.28715, 36.34775], [-119.28707, 36.34777], [-119.28694, 36.34784], [-119.28672, 36.34786], [-119.28531, 36.34787], [-119.28485, 36.34793], [-119.28461, 36.34794], [-119.2846, 36.34726], [-119.28331, 36.34725], [-119.28331, 36.34682], [-119.28764, 36.34682], [-119.28765, 36.34795]]]} | Open Access 1 | 1303 | Alejandro R. Ruiz Sr. Park | 15353 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 9.301 | Alejandro R. Ruiz Sr. Park | 0 | Local Park 2 | 4 | |
6241 | 6241 | 6240 | {"type": "Polygon", "coordinates": [[[-119.34659, 36.32123], [-119.34577, 36.32123], [-119.34577, 36.32019], [-119.34579, 36.32016], [-119.34582, 36.32015], [-119.34658, 36.32014], [-119.34659, 36.32123]]]} | Open Access 1 | 1315 | Constitution Park | 17600 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 2.174 | Constitution 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]);