units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 152 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6264 | 6264 | 6263 | {"type": "Polygon", "coordinates": [[[-119.29758, 36.3279], [-119.29746, 36.32786], [-119.29728, 36.32786], [-119.2971, 36.32783], [-119.29693, 36.32775], [-119.29682, 36.32772], [-119.29669, 36.32773], [-119.29669, 36.32756], [-119.29696, 36.32759], [-119.2973, 36.3277], [-119.29738, 36.32771], [-119.29758, 36.32767], [-119.29758, 36.3279]]]} | Open Access 1 | 1349 | Kaweah Park | 20562 | 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.374 | Kaweah Park | 0 | Local Park 2 | 4 | |
6271 | 6271 | 6270 | {"type": "Polygon", "coordinates": [[[-119.30991, 36.32998], [-119.30897, 36.32998], [-119.30897, 36.32962], [-119.30898, 36.32964], [-119.30915, 36.32973], [-119.30944, 36.32981], [-119.30991, 36.32996], [-119.30991, 36.32998]]]} | Open Access 1 | 1364 | Mayors Park | 21981 | 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.39 | Mayors 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 | |
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 | |
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 | ||
6273 | 6273 | 6272 | {"type": "Polygon", "coordinates": [[[-119.30992, 36.33057], [-119.30889, 36.33058], [-119.30888, 36.33016], [-119.30991, 36.33016], [-119.30992, 36.33057]]]} | Open Access 1 | 1369 | Memorial Park | 22138 | 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.046 | Memorial Park | 0 | Local Park 2 | 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 | |
6252 | 6252 | 6251 | {"type": "Polygon", "coordinates": [[[-119.29239, 36.33703], [-119.29255, 36.33713], [-119.29268, 36.33728], [-119.29276, 36.33743], [-119.29279, 36.33762], [-119.29277, 36.3378], [-119.29269, 36.33796], [-119.29254, 36.33813], [-119.29242, 36.33818], [-119.29234, 36.33817], [-119.29228, 36.33815], [-119.29214, 36.33801], [-119.29204, 36.33784], [-119.292, 36.33765], [-119.29202, 36.33746], [-119.29209, 36.33731], [-119.29222, 36.33715], [-119.29239, 36.33703]]]} | Open Access 1 | 1353 | Lincoln Oval Park | 21259 | 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.607 | Lincoln Oval Park | 0 | Local Park 2 | 4 | |
11510 | 11510 | 11509 | {"type": "Polygon", "coordinates": [[[-119.35977, 36.34883], [-119.35927, 36.34978], [-119.3591, 36.35015], [-119.35896, 36.35052], [-119.35885, 36.35089], [-119.35884, 36.34908], [-119.35926, 36.34907], [-119.35929, 36.34912], [-119.35936, 36.34916], [-119.35948, 36.34916], [-119.35958, 36.3491], [-119.35961, 36.34906], [-119.35961, 36.34901], [-119.35958, 36.34894], [-119.35948, 36.34887], [-119.35944, 36.34882], [-119.35977, 36.34883]]]} | Open Access 1 | 48208 | Foxwood Park | 32748 | 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.619 | Foxwood Park | 0 | Local Park 2 | 4 | |
6244 | 6244 | 6243 | {"type": "Polygon", "coordinates": [[[-119.32356, 36.30552], [-119.32287, 36.30553], [-119.32282, 36.3055], [-119.3228, 36.3045], [-119.32354, 36.30449], [-119.32356, 36.30552]]]} | Open Access 1 | 1320 | Crestwood Park | 17818 | 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.876 | Crestwood 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 | |
12298 | 12298 | 12297 | {"type": "Polygon", "coordinates": [[[-119.3361, 36.32834], [-119.33548, 36.3282], [-119.33497, 36.32802], [-119.33446, 36.32808], [-119.33395, 36.32829], [-119.33341, 36.32801], [-119.333, 36.32823], [-119.333, 36.32775], [-119.33365, 36.32777], [-119.33527, 36.3279], [-119.33595, 36.32792], [-119.33604, 36.328], [-119.3361, 36.32834]]]} | Open Access 1 | 25964 | Pappas Park | 23397 | 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.361 | Pappas Park | 0 | Local Park 2 | 4 | |
6255 | 6255 | 6254 | {"type": "Polygon", "coordinates": [[[-119.32059, 36.31705], [-119.31845, 36.31707], [-119.31844, 36.31672], [-119.31846, 36.31669], [-119.3185, 36.31668], [-119.31886, 36.31665], [-119.31915, 36.31658], [-119.31938, 36.31649], [-119.31967, 36.31631], [-119.31972, 36.3163], [-119.31976, 36.31631], [-119.32041, 36.31694], [-119.32059, 36.31705]]]} | Open Access 1 | 1329 | Houk Park | 20110 | 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.393 | Houk 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 | |
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 | |
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 | |
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 | |
6305 | 6305 | 6304 | {"type": "Polygon", "coordinates": [[[-119.34958, 36.33435], [-119.34956, 36.33439], [-119.34951, 36.3344], [-119.34774, 36.33434], [-119.34772, 36.33358], [-119.34958, 36.33356], [-119.34958, 36.33435]]]} | Open Access 1 | 1467 | Willow Glen Park | 27579 | 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.667 | Willow Glen Park | 0 | Local Park 2 | 4 | |
11499 | 11499 | 11498 | {"type": "Polygon", "coordinates": [[[-119.36509, 36.35194], [-119.36331, 36.35195], [-119.36331, 36.35172], [-119.36327, 36.3517], [-119.36329, 36.35165], [-119.3633, 36.3516], [-119.36324, 36.35151], [-119.36316, 36.35148], [-119.3631, 36.35147], [-119.36304, 36.35149], [-119.36293, 36.35154], [-119.36271, 36.35155], [-119.36271, 36.35115], [-119.36509, 36.35113], [-119.36509, 36.35194]]]} | Open Access 1 | 48207 | Lions Park | 32747 | 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 | 4.109 | Lions Park | 0 | Local Park 2 | 4 | |
12320 | 12320 | 12319 | {"type": "Polygon", "coordinates": [[[-119.26942, 36.30909], [-119.26793, 36.30907], [-119.26794, 36.30806], [-119.26829, 36.30801], [-119.26875, 36.30791], [-119.26896, 36.30787], [-119.26921, 36.30785], [-119.26938, 36.30786], [-119.26941, 36.3079], [-119.26942, 36.30909]]]} | Open Access 1 | 25963 | Cherry Meadow Park | 17171 | 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 | 4.157 | Cherry Meadow 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]);