superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 152 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15128 | 15128 | 15127 | {"type": "MultiPolygon", "coordinates": [[[[-119.24297, 36.33127], [-119.24195, 36.33139], [-119.23951, 36.33153], [-119.23811, 36.33164], [-119.2372, 36.33193], [-119.23691, 36.33215], [-119.2366, 36.33228], [-119.23591, 36.33246], [-119.23541, 36.33252], [-119.23479, 36.3325], [-119.23421, 36.33281], [-119.23394, 36.33292], [-119.23392, 36.33213], [-119.23394, 36.33087], [-119.23399, 36.33085], [-119.23391, 36.32725], [-119.23517, 36.32722], [-119.23546, 36.32724], [-119.23575, 36.32727], [-119.23603, 36.32734], [-119.2363, 36.32742], [-119.23655, 36.32753], [-119.2369, 36.32772], [-119.23721, 36.32796], [-119.23841, 36.32919], [-119.23856, 36.32932], [-119.23893, 36.3293], [-119.23936, 36.32919], [-119.23997, 36.32911], [-119.24016, 36.32898], [-119.24006, 36.3285], [-119.24069, 36.32807], [-119.24185, 36.32776], [-119.24203, 36.3275], [-119.24227, 36.32731], [-119.24259, 36.32726], [-119.24262, 36.32724], [-119.24291, 36.32724], [-119.24297, 36.33127]]], [[[-119.24313, 36.34277], [-119.24142, 36.3433], [-119.24141, 36.34287], [-119.24097, 36.34288], [-119.24095, 36.34188], [-119.23752, 36.34188], [-119.23746, 36.33926], [-119.23575, 36.33923], [-119.23564, 36.3345], [-119.23398, 36.33447], [-119.23394, 36.33295], [-119.23423, 36.33284], [-119.2348, 36.33253], [-119.23541, 36.33254], [-119.23591, 36.33249], [-119.23661, 36.33231], [-119.23693, 36.33217], [-119.23723, 36.33195], [-119.23812, 36.33167], [-119.23952, 36.33156], [-119.24297, 36.33135], [-119.24313, 36.34277]]]]} | Open Access 1 | East Side Regional Park | https://docs.google.com/document/d/1oNuJp2ZETkV9htPzVHlYhz1D7kD7tlzxGEYdJEtsDPg/edit | 33670 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 271.569 | East Side RP | |
9112 | 9112 | 9111 | {"type": "MultiPolygon", "coordinates": [[[[-119.25191, 36.34922], [-119.24316, 36.34925], [-119.24316, 36.34903], [-119.24402, 36.34901], [-119.24477, 36.34896], [-119.24627, 36.34872], [-119.24802, 36.34852], [-119.24977, 36.34836], [-119.25139, 36.34816], [-119.25181, 36.34804], [-119.25182, 36.34829], [-119.2519, 36.34828], [-119.25191, 36.34922]]], [[[-119.27881, 36.3533], [-119.27645, 36.35274], [-119.27441, 36.3524], [-119.27326, 36.35214], [-119.27018, 36.34914], [-119.26993, 36.34913], [-119.26992, 36.34889], [-119.26868, 36.34835], [-119.26737, 36.34824], [-119.26354, 36.34826], [-119.26247, 36.34819], [-119.26098, 36.34803], [-119.26093, 36.34928], [-119.25208, 36.3495], [-119.25207, 36.34816], [-119.25211, 36.3481], [-119.25643, 36.34808], [-119.26093, 36.34755], [-119.26097, 36.34753], [-119.26097, 36.34749], [-119.26431, 36.34747], [-119.26433, 36.34713], [-119.26464, 36.34714], [-119.26491, 36.34718], [-119.26511, 36.34723], [-119.26553, 36.34737], [-119.26554, 36.34763], [-119.26737, 36.34765], [-119.26881, 36.34787], [-119.26951, 36.34801], [-119.26991, 36.34816], [-119.26993, 36.34755], [-119.27024, 36.34765], [-119.27053, 36.34779], [-119.27077, 36.34795], [-119.27099, 36.34815], [-119.27114, 36.34833], [-119.27125, 36.3485], [-119.27159, 36.34929], [-119.27173, 36.34952], [-119.27193, 36.34975], [-119.27214, 36.34994], [-119.27238, 36.3501], [-119.27264, 36.35023], [-119.27253, 36.35042], [-119.27278, 36.35061], [-119.27308, 36.35113], [-119.27318, 36.35127], [-119.27334, 36.35142], [-119.27353, 36.35156], [-119.27408, 36.3518], [-119.27441, 36.35186], [-119.27441, 36.35127], [-119.27878, 36.35125], [-119.27881, 36.3533]]], [[[-119.28832, 36.36688], [-119.28789, 36.36688], [-119.28791, 36.35975], [-119.2876, 36.35907], [-119.28587, 36.35742], [-119.28442, 36.35567], [-119.2839, 36.35543], [-119.28321, 36.35543], [-119.2832, 36.35512], [-119.2818, 36.35444], [-119.28031, 36.35383], [-119.27913, 36.3534], [-119.27913, 36.35274], [-119.27908, 36.35272], [-119.27907, 36.35261], [-119.28321, 36.35389], [-119.28322, 36.35397], [-119.28328, 36.35397], [-119.28386, 36.35418], [-119.28495, 36.35401], [-119.28495, 36.35406], [-119.28496, 36.35407], [-119.2856, 36.35391], [-119.2856, 36.35406], [-119.28519, 36.35415], [-119.28519, 36.35428], [-119.2853, 36.35442], [-119.2853, 36.35457], [-119.28519, 36.35467], [-119.28519, 36.3547], [-119.28513, 36.35471], [-119.28513, 36.35497], [-119.28543, 36.35543], [-119.28507, 36.35543], [-119.28506, 36.35545], [-119.28516, 36.35559], [-119.28537, 36.35583], [-119.28774, 36.35801], [-119.28823, 36.35856], [-119.28832, 36.36688]]]]} | Open Access 1 | Saint Johns Riverway Park | 24790 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 123.295 | Saint Johns Riverway Park | ||
872 | 872 | 871 | {"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.25369, 36.31936], [-119.25504, 36.3188], [-119.25534, 36.31852], [-119.25606, 36.31735], [-119.25609, 36.31977]]]} | Open Access 1 | Kiwanis Park | 32746 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 8.36 | Kiwanis Park | ||
6974 | 6974 | 6973 | {"type": "Polygon", "coordinates": [[[-119.26048, 36.3315], [-119.26048, 36.33249], [-119.26047, 36.33253], [-119.26043, 36.33256], [-119.25979, 36.33265], [-119.25936, 36.33274], [-119.25908, 36.33282], [-119.25872, 36.33298], [-119.258, 36.33343], [-119.25742, 36.33277], [-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 | Mill Creek Park | 22226 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 7.021 | Mill Creek Park | ||
14392 | 14392 | 14391 | {"type": "Polygon", "coordinates": [[[-119.26391, 36.3001], [-119.26399, 36.30025], [-119.26399, 36.30034], [-119.26394, 36.3005], [-119.2639, 36.30056], [-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], [-119.26391, 36.3001]]]} | Open Access 1 | Unknown park - Visalia, City of | 33575 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.805 | |||
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-119.26942, 36.30909], [-119.26793, 36.30907], [-119.26794, 36.30806], [-119.2683, 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 | Cherry Meadow Park | 17171 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.155 | Cherry Meadow Park | ||
8162 | 8162 | 8161 | {"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 | Pinkham Park | 23697 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.438 | Pinkham Park | ||
8106 | 8106 | 8105 | {"type": "Polygon", "coordinates": [[[-119.28075, 36.32363], [-119.27883, 36.32363], [-119.27878, 36.32023], [-119.27927, 36.32023], [-119.27928, 36.32092], [-119.28073, 36.32188], [-119.28075, 36.32363]]]} | Open Access 1 | Seven Oaks Park | 25327 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 11.945 | Seven Oaks Park | ||
2366 | 2366 | 2365 | {"type": "Polygon", "coordinates": [[[-119.2843, 36.30187], [-119.28423, 36.30209], [-119.2842, 36.30237], [-119.28416, 36.30246], [-119.28417, 36.30251], [-119.2842, 36.30256], [-119.28419, 36.30361], [-119.28293, 36.3036], [-119.28289, 36.30358], [-119.28287, 36.30355], [-119.28287, 36.30186], [-119.28288, 36.30184], [-119.28293, 36.30181], [-119.28367, 36.30182], [-119.28424, 36.30181], [-119.28429, 36.30183], [-119.2843, 36.30187]]]} | Open Access 1 | Burke Park | 16522 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 5.879 | Burke Park | ||
1078 | 1078 | 1077 | {"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.34792], [-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 | Alejandro R. Ruiz Sr. Park | 15353 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 9.308 | Alejandro R. Ruiz Sr. Park | ||
6189 | 6189 | 6188 | {"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 | Lincoln Oval Park | 21259 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.606 | Lincoln Oval Park | ||
8776 | 8776 | 8775 | {"type": "Polygon", "coordinates": [[[-119.29281, 36.35312], [-119.2928, 36.35315], [-119.29277, 36.35317], [-119.29255, 36.35324], [-119.29236, 36.35334], [-119.2919, 36.35373], [-119.29154, 36.35395], [-119.29133, 36.35368], [-119.29089, 36.35286], [-119.29103, 36.35281], [-119.29244, 36.35212], [-119.29246, 36.35235], [-119.29253, 36.35258], [-119.29261, 36.35278], [-119.29281, 36.35312]]]} | Open Access 1 | Riverbend Park | 24436 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.482 | Riverbend Park | ||
2045 | 2045 | 2044 | {"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 | Blain Park | 16147 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 7.099 | Blain Park | ||
11353 | 11353 | 11352 | {"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 | Wittman Village Park | 27665 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.314 | Wittman Village Park | ||
10058 | 10058 | 10057 | {"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.29476, 36.34907], [-119.29575, 36.34907], [-119.29575, 36.3494]]]} | Open Access 1 | Summers Park | 25962 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.549 | Summers Park | ||
5508 | 5508 | 5507 | {"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 | Jefferson Park | 20382 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.611 | Jefferson Park | ||
5665 | 5665 | 5664 | {"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 | Kaweah Park | 20562 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.374 | Kaweah Park | ||
11185 | 11185 | 11184 | {"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 | Whitendale Park | 27467 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 8.803 | Whitendale Park | ||
875 | 875 | 874 | {"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 | Miki City Park | 32749 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.631 | Miki City Park | 2017 | |
4159 | 4159 | 4158 | {"type": "Polygon", "coordinates": [[[-119.30127, 36.35336], [-119.30081, 36.35336], [-119.3008, 36.35338], [-119.3006, 36.35344], [-119.30002, 36.35344], [-119.29983, 36.35341], [-119.29965, 36.35334], [-119.29857, 36.35273], [-119.29855, 36.3527], [-119.29855, 36.35267], [-119.29898, 36.35215], [-119.29905, 36.35199], [-119.29908, 36.35181], [-119.30126, 36.35183], [-119.30127, 36.35336]]]} | Open Access 1 | Fairview Village Park | 18820 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 8.896 | Fairview Village 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]);