units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 152 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16331 | 16331 | 16330 | {"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.33086], [-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.32775], [-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.24096, 36.34188], [-119.23752, 36.34188], [-119.23746, 36.33925], [-119.23575, 36.33923], [-119.23565, 36.33449], [-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 | 48973 | East Side Regional Park | 33670 | 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 | https://docs.google.com/document/d/1oNuJp2ZETkV9htPzVHlYhz1D7kD7tlzxGEYdJEtsDPg/edit | Tulare 29 | 271.524 | East Side RP | 0 | Local Park 2 | 4 |
13041 | 13041 | 13040 | {"type": "Polygon", "coordinates": [[[-119.34092, 36.34566], [-119.34091, 36.34637], [-119.3409, 36.3464], [-119.34038, 36.3464], [-119.34037, 36.3468], [-119.33919, 36.34679], [-119.3392, 36.34562], [-119.34087, 36.34561], [-119.3409, 36.34563], [-119.34092, 36.34566]]]} | Open Access 1 | 34882 | Soroptimist Park | 25630 | 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.466 | Soroptimist 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 | |
12319 | 12319 | 12318 | {"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 | 25962 | Burke Park | 16522 | 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 | 5.879 | Burke 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 | |
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 | |
11507 | 11507 | 11506 | {"type": "Polygon", "coordinates": [[[-119.41873, 36.35262], [-119.42089, 36.35261], [-119.42092, 36.35277], [-119.42091, 36.35293], [-119.42085, 36.35317], [-119.42004, 36.35376], [-119.41908, 36.35453], [-119.41863, 36.35485], [-119.41864, 36.35473], [-119.41817, 36.35426], [-119.41801, 36.35403], [-119.41795, 36.35386], [-119.41791, 36.35368], [-119.41791, 36.35276], [-119.4179, 36.35272], [-119.41786, 36.35271], [-119.41791, 36.35264], [-119.41873, 36.35262]]]} | Open Access 1 | 48205 | Goshen Park | 32745 | 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 | 10.717 | Goshen 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 | |
8490 | 8490 | 8489 | {"type": "Polygon", "coordinates": [[[-119.38553, 36.32294], [-119.38391, 36.32361], [-119.38313, 36.32419], [-119.38113, 36.32421], [-119.3811, 36.31994], [-119.38099, 36.31272], [-119.38131, 36.31274], [-119.38155, 36.31279], [-119.38178, 36.3129], [-119.38549, 36.31585], [-119.38569, 36.31605], [-119.38727, 36.3181], [-119.38829, 36.31895], [-119.38855, 36.31913], [-119.38879, 36.31924], [-119.38901, 36.31932], [-119.38949, 36.31943], [-119.38976, 36.31954], [-119.39004, 36.31974], [-119.3902, 36.31992], [-119.3903, 36.32009], [-119.39038, 36.32034], [-119.39039, 36.3206], [-119.39036, 36.32078], [-119.3903, 36.32093], [-119.39015, 36.32116], [-119.39001, 36.3213], [-119.38987, 36.32141], [-119.38968, 36.32151], [-119.38952, 36.32157], [-119.38896, 36.3217], [-119.38874, 36.32178], [-119.38849, 36.32193], [-119.38828, 36.32212], [-119.38817, 36.32228], [-119.38808, 36.32248], [-119.3877, 36.32389], [-119.3877, 36.32401], [-119.38774, 36.32416], [-119.38802, 36.32477], [-119.3881, 36.32488], [-119.38818, 36.32496], [-119.38839, 36.32509], [-119.38863, 36.32517], [-119.38891, 36.32519], [-119.38914, 36.32514], [-119.38954, 36.32498], [-119.38967, 36.32496], [-119.38995, 36.32496], [-119.3898, 36.32615], [-119.38881, 36.32651], [-119.3882, 36.32664], [-119.3877, 36.3267], [-119.38715, 36.32673], [-119.38555, 36.32675], [-119.38466, 36.32696], [-119.38131, 36.32696], [-119.38114, 36.32683], [-119.38113, 36.32424], [-119.38315, 36.32421], [-119.38393, 36.32363], [-119.38553, 36.32297], [-119.39037, 36.32063], [-119.39035, 36.32062], [-119.39, 36.32078], [-119.38553, 36.32294]]]} | Restricted Access 2 | 1435 | Valley Oaks Golf Course | 32996 | 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 | 215.293 | Valley Oaks GC | 0 | Local Recreation Area 3 | 4 | |
6309 | 6309 | 6308 | {"type": "Polygon", "coordinates": [[[-119.31991, 36.34516], [-119.31941, 36.3452], [-119.3189, 36.34532], [-119.3191, 36.34604], [-119.31831, 36.34616], [-119.31821, 36.34592], [-119.31813, 36.34563], [-119.31804, 36.34512], [-119.31802, 36.34482], [-119.31803, 36.34452], [-119.31805, 36.3443], [-119.3181, 36.34409], [-119.31853, 36.34412], [-119.31879, 36.34412], [-119.3191, 36.34408], [-119.31943, 36.34402], [-119.31956, 36.34428], [-119.31981, 36.34472], [-119.31988, 36.34495], [-119.31991, 36.34516]]]} | Open Access 1 | 1472 | Woodland Park | 27725 | 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 | 6.573 | Woodland 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 | |
6297 | 6297 | 6296 | {"type": "Polygon", "coordinates": [[[-119.30678, 36.30204], [-119.30555, 36.30202], [-119.30554, 36.30206], [-119.30455, 36.30206], [-119.30455, 36.30179], [-119.30458, 36.30169], [-119.30456, 36.30161], [-119.3045, 36.30156], [-119.30442, 36.30154], [-119.30425, 36.30158], [-119.30424, 36.30101], [-119.30419, 36.30097], [-119.30423, 36.30092], [-119.30424, 36.30087], [-119.30423, 36.30081], [-119.30419, 36.30076], [-119.30424, 36.30071], [-119.30424, 36.30015], [-119.30526, 36.30015], [-119.30582, 36.30025], [-119.3066, 36.30025], [-119.30664, 36.30027], [-119.30667, 36.3003], [-119.30668, 36.30138], [-119.30664, 36.3015], [-119.30668, 36.30158], [-119.30678, 36.30163], [-119.30678, 36.30204]]]} | Open Access 1 | 1419 | Stonebrook Park | 25883 | 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 | 10.793 | Stonebrook Park | 0 | Local Park 2 | 4 | |
6293 | 6293 | 6292 | {"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 | 1407 | Seven Oaks Park | 25327 | 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 | 11.945 | Seven Oaks Park | 0 | Local Park 2 | 4 | |
6289 | 6289 | 6288 | {"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.3483], [-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.34913], [-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.26432, 36.34747], [-119.26433, 36.34713], [-119.26464, 36.34714], [-119.26491, 36.34718], [-119.26511, 36.34723], [-119.26553, 36.34737], [-119.26553, 36.34763], [-119.26737, 36.34765], [-119.26881, 36.34787], [-119.26951, 36.34801], [-119.26992, 36.34817], [-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.35143], [-119.27353, 36.35156], [-119.27409, 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.28321, 36.35512], [-119.2818, 36.35444], [-119.28031, 36.35383], [-119.27913, 36.3534], [-119.27913, 36.35273], [-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.35414], [-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 | 1404 | Saint Johns Riverway Park | 24790 | 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 | 123.256 | Saint Johns Riverway Park | 0 | Local Park 2 | 4 | |
6288 | 6288 | 6287 | {"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.29102, 36.35281], [-119.29244, 36.35212], [-119.29246, 36.35235], [-119.29253, 36.35258], [-119.29261, 36.35277], [-119.29281, 36.35312]]]} | Open Access 1 | 1392 | Riverbend Park | 24436 | 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.482 | Riverbend Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
6260 | 6260 | 6259 | {"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.30317, 36.33148], [-119.30537, 36.33147], [-119.30539, 36.3334]]]} | Open Access 1 | 1385 | Recreation Park | 24218 | 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 | 12.862 | Rec. Park | 0 | Local Recreation Area 3 | 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 |
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]);