superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 152 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
3128 | 3128 | 3127 | {"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 | Combs Park | 17558 | 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.931 | Combs Park | ||
3164 | 3164 | 3163 | {"type": "Polygon", "coordinates": [[[-119.34659, 36.32123], [-119.34577, 36.32123], [-119.34577, 36.32019], [-119.34579, 36.32016], [-119.34582, 36.32014], [-119.34658, 36.32014], [-119.34659, 36.32123]]]} | Open Access 1 | Constitution Park | 17600 | 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.173 | Constitution Park | ||
3331 | 3331 | 3330 | {"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 | Crestwood Park | 17818 | 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.875 | Crestwood Park | ||
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 | ||
5266 | 5266 | 5265 | {"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 | Houk Park | 20110 | 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.392 | Houk 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 | ||
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 | ||
6233 | 6233 | 6232 | {"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.30224], [-119.3424, 36.30142], [-119.34315, 36.30141]]]} | Open Access 1 | Linwood Park | 21309 | 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.236 | Linwood Park | ||
6784 | 6784 | 6783 | {"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 | Mayors Park | 21981 | 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.39 | Mayors Park | ||
6928 | 6928 | 6927 | {"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 | Memorial Park | 22138 | 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.045 | Memorial 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 | ||
7923 | 7923 | 7922 | {"type": "Polygon", "coordinates": [[[-119.3361, 36.32834], [-119.33548, 36.3282], [-119.33497, 36.32802], [-119.33446, 36.32808], [-119.33395, 36.32829], [-119.3334, 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 | Pappas Park | 23397 | 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.363 | Pappas 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 | ||
8241 | 8241 | 8240 | {"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.3243], [-119.3902, 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 | Plaza Park | 23789 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 30.74 | Plaza Park | ||
7298 | 7298 | 7297 | {"type": "Polygon", "coordinates": [[[-119.30539, 36.3334], [-119.30537, 36.33344], [-119.30532, 36.33345], [-119.30506, 36.33343], [-119.30481, 36.33345], [-119.30349, 36.33305], [-119.3038, 36.33244], [-119.30375, 36.33236], [-119.30331, 36.33236], [-119.30313, 36.33297], [-119.30233, 36.33288], [-119.30231, 36.3311], [-119.30316, 36.3311], [-119.30318, 36.33148], [-119.30537, 36.33147], [-119.30539, 36.3334]]]} | Open Access 1 | Recreation Park | 24218 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 12.869 | Rec. 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]);