units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where MNG_AGENCY = 462
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2656 | 2656 | 2655 | {"type": "Polygon", "coordinates": [[[-119.71595, 36.83585], [-119.71583, 36.83599], [-119.71584, 36.83571], [-119.71594, 36.83571], [-119.71595, 36.83585]]]} | Open Access 1 | 18148 | Tenaya Sun Ranch Park | 26240 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.058 | Tenaya Sun Ranch Park | 0 | Local Park 2 | 4 | |
2672 | 2672 | 2671 | {"type": "Polygon", "coordinates": [[[-119.69652, 36.78529], [-119.69649, 36.78648], [-119.69565, 36.78653], [-119.69566, 36.78529], [-119.69652, 36.78529]]]} | Open Access 1 | 18382 | Westcal II Park | 27382 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.558 | Westcal II Park | 0 | Local Park 2 | 4 | |
2693 | 2693 | 2692 | {"type": "Polygon", "coordinates": [[[-119.67957, 36.84855], [-119.67913, 36.84855], [-119.67913, 36.84811], [-119.67917, 36.84808], [-119.67956, 36.84808], [-119.67957, 36.84855]]]} | Open Access 1 | 17804 | Rancho Paloma II Park | 24160 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.508 | Rancho Paloma II Park | 0 | Local Park 2 | 4 | |
2759 | 2759 | 2758 | {"type": "Polygon", "coordinates": [[[-119.66079, 36.81891], [-119.66078, 36.81946], [-119.66072, 36.81946], [-119.6606, 36.81949], [-119.65944, 36.81949], [-119.65944, 36.81891], [-119.66079, 36.81891]]]} | Open Access 1 | 18455 | Westcal III Park | 27383 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.881 | Westcal III Park | 0 | Local Park 2 | 4 | |
2774 | 2774 | 2773 | {"type": "Polygon", "coordinates": [[[-119.669, 36.82146], [-119.66889, 36.82161], [-119.66842, 36.82165], [-119.66797, 36.82148], [-119.66803, 36.82136], [-119.66806, 36.82116], [-119.66808, 36.82115], [-119.66849, 36.82115], [-119.66878, 36.82112], [-119.66881, 36.82113], [-119.66887, 36.82127], [-119.669, 36.82143], [-119.669, 36.82146]]]} | Open Access 1 | 18514 | Westcal New Colony Park | 27384 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.011 | Westcal New Colony Park | 0 | Local Park 2 | 4 | |
4174 | 4174 | 4173 | {"type": "Polygon", "coordinates": [[[-119.72489, 36.86517], [-119.72489, 36.86596], [-119.72426, 36.86594], [-119.72426, 36.8656], [-119.7243, 36.86551], [-119.72431, 36.86546], [-119.72428, 36.8654], [-119.72419, 36.86535], [-119.72428, 36.86504], [-119.72435, 36.86504], [-119.72465, 36.86517], [-119.72489, 36.86517]]]} | Open Access 1 | 48577 | European Parc Park | 33287 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.282 | European Parc Park | 0 | Local Park 2 | 4 | |
4185 | 4185 | 4184 | {"type": "Polygon", "coordinates": [[[-119.65164, 36.80532], [-119.65136, 36.8054], [-119.65113, 36.80545], [-119.65079, 36.80547], [-119.65055, 36.80544], [-119.64925, 36.8052], [-119.64921, 36.80516], [-119.64923, 36.80495], [-119.64927, 36.80492], [-119.65057, 36.80492], [-119.65085, 36.80494], [-119.65161, 36.80508], [-119.65164, 36.80522], [-119.65164, 36.80532]]]} | Open Access 1 | 48580 | Los Arbolitos Park | 33290 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.465 | Los Arbolitos Park | 0 | Local Park 2 | 4 | |
4530 | 4530 | 4529 | {"type": "MultiPolygon", "coordinates": [[[[-119.6514, 36.81889], [-119.65097, 36.81932], [-119.65097, 36.81957], [-119.65051, 36.81957], [-119.65033, 36.81959], [-119.65012, 36.8196], [-119.65006, 36.81956], [-119.65001, 36.8194], [-119.65, 36.81924], [-119.65003, 36.81904], [-119.65009, 36.81899], [-119.65035, 36.81897], [-119.65105, 36.81896], [-119.65116, 36.81894], [-119.6513, 36.81887], [-119.65135, 36.81887], [-119.6514, 36.81889]]], [[[-119.65415, 36.81664], [-119.65396, 36.81664], [-119.65381, 36.81677], [-119.65373, 36.81681], [-119.65341, 36.81684], [-119.65327, 36.81692], [-119.65319, 36.81703], [-119.65309, 36.81731], [-119.65302, 36.81735], [-119.65298, 36.81741], [-119.65298, 36.81748], [-119.653, 36.81752], [-119.65311, 36.8176], [-119.65281, 36.8176], [-119.65264, 36.81764], [-119.65225, 36.81764], [-119.65224, 36.81796], [-119.65232, 36.81798], [-119.65226, 36.81805], [-119.65206, 36.81812], [-119.6515, 36.81876], [-119.65136, 36.81869], [-119.65167, 36.81831], [-119.65202, 36.81792], [-119.65203, 36.81784], [-119.65211, 36.81778], [-119.65213, 36.81768], [-119.65206, 36.81758], [-119.65204, 36.81751], [-119.65263, 36.8175], [-119.65273, 36.81748], [-119.65281, 36.81744], [-119.6529, 36.81734], [-119.65303, 36.81699], [-119.65311, 36.81686], [-119.65322, 36.81677], [-119.65334, 36.81672], [-119.65346, 36.8167], [-119.65362, 36.81669], [-119.6537, 36.81666], [-119.6539, 36.81649], [-119.6539, 36.81631], [-119.65402, 36.81633], [-119.6541, 36.81639], [-119.65415, 36.81648], [-119.65415, 36.81664]]], [[[-119.65351, 36.79302], [-119.65342, 36.79309], [-119.65342, 36.79339], [-119.65311, 36.79339], [-119.65307, 36.79337], [-119.65306, 36.79334], [-119.65306, 36.79298], [-119.65348, 36.79298], [-119.65351, 36.79302]]], [[[-119.65478, 36.81582], [-119.65478, 36.81604], [-119.65463, 36.81604], [-119.65428, 36.81634], [-119.65418, 36.81624], [-119.6545, 36.81596], [-119.6545, 36.81582], [-119.65478, 36.81582]]], [[[-119.67228, 36.80779], [-119.67221, 36.80782], [-119.67211, 36.80781], [-119.67204, 36.80754], [-119.67204, 36.80747], [-119.67207, 36.80731], [-119.67213, 36.80716], [-119.6722, 36.80714], [-119.67227, 36.80717], [-119.67228, 36.80779]]], [[[-119.67672, 36.86383], [-119.67672, 36.86416], [-119.67562, 36.86415], [-119.67554, 36.86417], [-119.67549, 36.86419], [-119.67541, 36.86412], [-119.67597, 36.86398], [-119.67672, 36.86383]]]]} | Open Access 1 | 18266 | Unknown park - Clovis, City of | 28715 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 4.819 | 0 | Local Other or Unknown 14 | 4 | ||
4838 | 4838 | 4837 | {"type": "Polygon", "coordinates": [[[-119.70189, 36.85931], [-119.70185, 36.8596], [-119.70184, 36.85988], [-119.70172, 36.85989], [-119.70163, 36.85994], [-119.70148, 36.85994], [-119.70141, 36.85996], [-119.70132, 36.86003], [-119.7013, 36.86014], [-119.70091, 36.86015], [-119.70082, 36.86039], [-119.70059, 36.86065], [-119.70054, 36.86067], [-119.70037, 36.86091], [-119.69825, 36.8621], [-119.69711, 36.8622], [-119.6967, 36.8623], [-119.69669, 36.86282], [-119.6965, 36.86282], [-119.69649, 36.86285], [-119.69627, 36.86286], [-119.69606, 36.86297], [-119.69591, 36.86304], [-119.69574, 36.86308], [-119.69553, 36.8631], [-119.69543, 36.86315], [-119.69499, 36.86419], [-119.6946, 36.86486], [-119.69435, 36.86523], [-119.69435, 36.86528], [-119.69438, 36.86534], [-119.69442, 36.86537], [-119.69449, 36.8654], [-119.6945, 36.86574], [-119.69413, 36.86528], [-119.69427, 36.86512], [-119.69449, 36.86482], [-119.69488, 36.86416], [-119.69539, 36.86293], [-119.69604, 36.86293], [-119.69613, 36.86289], [-119.69631, 36.86277], [-119.69649, 36.86271], [-119.6965, 36.86225], [-119.69708, 36.86211], [-119.6982, 36.86201], [-119.70028, 36.86085], [-119.7009, 36.85991], [-119.70168, 36.85931], [-119.70189, 36.85931]]]} | Open Access 1 | 48575 | Dry Creek Trail | 33285 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 3.975 | Dry Creek Trail | 0 | Local Recreation Area 3 | 4 | |
4839 | 4839 | 4838 | {"type": "Polygon", "coordinates": [[[-119.71553, 36.86337], [-119.71552, 36.86421], [-119.71506, 36.86414], [-119.71502, 36.8641], [-119.71503, 36.8633], [-119.71507, 36.86328], [-119.71553, 36.86337]]]} | Open Access 1 | 48576 | Pinnacles Park | 33286 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.026 | Pinnacles Park | 0 | Local Park 2 | 4 | |
5005 | 5005 | 5004 | {"type": "Polygon", "coordinates": [[[-119.70199, 36.84945], [-119.70166, 36.8492], [-119.6998, 36.84806], [-119.69973, 36.84801], [-119.69944, 36.8476], [-119.69939, 36.84721], [-119.69943, 36.84702], [-119.69958, 36.84682], [-119.70058, 36.84598], [-119.70076, 36.8457], [-119.70083, 36.84536], [-119.7008, 36.84483], [-119.70149, 36.84483], [-119.70172, 36.84527], [-119.70192, 36.84589], [-119.70196, 36.8461], [-119.702, 36.84659], [-119.70199, 36.84693], [-119.70201, 36.848], [-119.70199, 36.84945]]]} | Unknown Access 4 | 17221 | Dry Creek | 18278 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 17.89 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | |
5439 | 5439 | 5438 | {"type": "Polygon", "coordinates": [[[-119.70562, 36.82441], [-119.70528, 36.82441], [-119.70528, 36.82399], [-119.70561, 36.82399], [-119.70562, 36.82441]]]} | Open Access 1 | 18340 | Well 2 Pocket Park | 27340 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.341 | Well 2 PP | 0 | Local Park 2 | 4 | |
6372 | 6372 | 6371 | {"type": "Polygon", "coordinates": [[[-119.7115, 36.79474], [-119.71149, 36.79491], [-119.70923, 36.79495], [-119.70923, 36.79464], [-119.70928, 36.79459], [-119.70973, 36.79456], [-119.71014, 36.7945], [-119.71114, 36.79423], [-119.71146, 36.79416], [-119.71146, 36.79424], [-119.71143, 36.79428], [-119.71144, 36.79468], [-119.7115, 36.79474]]]} | Open Access 1 | 1759 | Helm Ranch Community Park | 30988 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.786 | Helm Ranch Community Park | 0 | Local Park 2 | 4 | |
9386 | 9386 | 9385 | {"type": "MultiPolygon", "coordinates": [[[[-119.66768, 36.86208], [-119.66783, 36.86235], [-119.66787, 36.86248], [-119.66788, 36.86262], [-119.66783, 36.86282], [-119.66762, 36.86316], [-119.66757, 36.86318], [-119.66742, 36.86314], [-119.66726, 36.86311], [-119.66691, 36.86311], [-119.66684, 36.86309], [-119.66676, 36.86303], [-119.66667, 36.86301], [-119.66658, 36.86302], [-119.6665, 36.86309], [-119.66616, 36.86303], [-119.66617, 36.86222], [-119.66621, 36.86219], [-119.66677, 36.86219], [-119.66703, 36.86216], [-119.6673, 36.86216], [-119.66749, 36.86213], [-119.66768, 36.86208]]], [[[-119.67269, 36.86285], [-119.67267, 36.86289], [-119.67255, 36.86295], [-119.67248, 36.86302], [-119.67241, 36.86315], [-119.67241, 36.86324], [-119.67244, 36.86333], [-119.67255, 36.86348], [-119.67252, 36.86356], [-119.67215, 36.86343], [-119.67213, 36.86336], [-119.67207, 36.86331], [-119.67198, 36.86329], [-119.67192, 36.86329], [-119.67159, 36.86315], [-119.6712, 36.86324], [-119.67118, 36.8632], [-119.67113, 36.86314], [-119.67108, 36.86312], [-119.67099, 36.86311], [-119.67089, 36.86316], [-119.67084, 36.86324], [-119.67053, 36.86319], [-119.67023, 36.86324], [-119.67021, 36.8632], [-119.67017, 36.86314], [-119.67012, 36.86312], [-119.67003, 36.86311], [-119.66993, 36.86314], [-119.66988, 36.8632], [-119.66987, 36.86324], [-119.66956, 36.86318], [-119.66925, 36.86324], [-119.66923, 36.86319], [-119.66918, 36.86313], [-119.66906, 36.8631], [-119.66898, 36.86313], [-119.66891, 36.86318], [-119.66859, 36.86324], [-119.66859, 36.86343], [-119.66852, 36.86343], [-119.66855, 36.86336], [-119.66854, 36.86331], [-119.66847, 36.86324], [-119.66839, 36.86321], [-119.6683, 36.86322], [-119.66795, 36.86313], [-119.66809, 36.86288], [-119.66851, 36.86299], [-119.66895, 36.86287], [-119.66901, 36.86292], [-119.66908, 36.86295], [-119.6698, 36.86295], [-119.66989, 36.86293], [-119.66998, 36.86301], [-119.67066, 36.86301], [-119.67076, 36.86294], [-119.67084, 36.86296], [-119.67215, 36.86296], [-119.67224, 36.86293], [-119.6723, 36.86285], [-119.67269, 36.86285]]]]} | Open Access 1 | 17187 | Deauville Park | 17982 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 6.722 | Deauville Park | 0 | Local Park 2 | 4 | |
9515 | 9515 | 9514 | {"type": "Polygon", "coordinates": [[[-119.72301, 36.79798], [-119.72278, 36.79798], [-119.72278, 36.79769], [-119.723, 36.7977], [-119.72301, 36.79798]]]} | Open Access 1 | 17384 | Lift Station Pocket Park | 21229 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.154 | Lift Station PP | 0 | Local Park 2 | 4 | |
9915 | 9915 | 9914 | {"type": "MultiPolygon", "coordinates": [[[[-119.70001, 36.80871], [-119.69996, 36.81569], [-119.6998, 36.8157], [-119.69984, 36.80871], [-119.70001, 36.80871]]], [[[-119.70018, 36.82195], [-119.70018, 36.82219], [-119.6998, 36.82219], [-119.69982, 36.82158], [-119.69986, 36.8214], [-119.69986, 36.81767], [-119.70013, 36.81768], [-119.70013, 36.81777], [-119.70008, 36.81784], [-119.70006, 36.81871], [-119.7001, 36.82092], [-119.70008, 36.82153], [-119.70006, 36.82155], [-119.70006, 36.82194], [-119.70018, 36.82195]]], [[[-119.70006, 36.80177], [-119.70004, 36.80479], [-119.69986, 36.80479], [-119.69988, 36.80177], [-119.70006, 36.80177]]], [[[-119.70004, 36.80503], [-119.70001, 36.80834], [-119.70001, 36.80834], [-119.69987, 36.80833], [-119.69988, 36.80504], [-119.70004, 36.80503]]], [[[-119.70011, 36.7933], [-119.70006, 36.80155], [-119.70006, 36.80155], [-119.69988, 36.80155], [-119.6999, 36.79786], [-119.69993, 36.79505], [-119.69991, 36.79448], [-119.69991, 36.79352], [-119.69992, 36.79329], [-119.70011, 36.7933]]], [[[-119.70051, 36.82957], [-119.70051, 36.83008], [-119.70024, 36.83019], [-119.7001, 36.82987], [-119.69998, 36.82949], [-119.6999, 36.8279], [-119.69989, 36.82668], [-119.70013, 36.82668], [-119.70012, 36.82768], [-119.70013, 36.82769], [-119.70012, 36.82779], [-119.70015, 36.82918], [-119.70022, 36.82956], [-119.70051, 36.82957]]], [[[-119.70017, 36.78305], [-119.70015, 36.78694], [-119.69993, 36.78695], [-119.69993, 36.78607], [-119.69991, 36.78553], [-119.69993, 36.78539], [-119.69993, 36.78511], [-119.69993, 36.78306], [-119.70017, 36.78305]]], [[[-119.70015, 36.78723], [-119.70011, 36.79304], [-119.69992, 36.79304], [-119.69993, 36.78724], [-119.70015, 36.78723]]], [[[-119.70456, 36.83412], [-119.70442, 36.83419], [-119.70121, 36.83148], [-119.7008, 36.83109], [-119.70086, 36.83104], [-119.70062, 36.83075], [-119.70043, 36.83047], [-119.70036, 36.83049], [-119.70027, 36.83037], [-119.70066, 36.83037], [-119.70074, 36.83048], [-119.70147, 36.83048], [-119.70147, 36.8313], [-119.70455, 36.8339], [-119.70456, 36.83412]]], [[[-119.71211, 36.84032], [-119.71187, 36.84051], [-119.70618, 36.8357], [-119.7056, 36.83519], [-119.70571, 36.83489], [-119.71211, 36.84032]]], [[[-119.72976, 36.85595], [-119.72955, 36.85565], [-119.72929, 36.85533], [-119.72915, 36.85518], [-119.72884, 36.85488], [-119.71998, 36.84738], [-119.71973, 36.84715], [-119.7189, 36.84646], [-119.71209, 36.84069], [-119.7123, 36.84048], [-119.72909, 36.85468], [-119.72946, 36.85505], [-119.72975, 36.8554], [-119.72976, 36.85595]]]]} | Open Access 1 | 17049 | Clovis Old Town Trail | 17447 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 47.342 | Clovis Old Town Trail | 0 | Local Recreation Area 3 | 4 | |
9922 | 9922 | 9921 | {"type": "Polygon", "coordinates": [[[-119.70703, 36.84802], [-119.70703, 36.84873], [-119.70629, 36.84873], [-119.70625, 36.84869], [-119.70626, 36.84802], [-119.70703, 36.84802]]]} | Open Access 1 | 17085 | Colony Cambridge Park | 17532 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.35 | Colony Cambridge Park | 0 | Local Park 2 | 4 | |
9947 | 9947 | 9946 | {"type": "Polygon", "coordinates": [[[-119.70264, 36.84324], [-119.70263, 36.84465], [-119.70222, 36.84467], [-119.70201, 36.84464], [-119.70177, 36.84464], [-119.70148, 36.84424], [-119.70133, 36.84406], [-119.70264, 36.84324]]]} | Open Access 1 | 17114 | Cottonwood Park | 17689 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.858 | Cottonwood Park | 0 | Local Park 2 | 4 | |
9970 | 9970 | 9969 | {"type": "Polygon", "coordinates": [[[-119.6601, 36.81223], [-119.66009, 36.81231], [-119.66005, 36.8124], [-119.66004, 36.81247], [-119.65994, 36.81265], [-119.65988, 36.81286], [-119.65948, 36.81289], [-119.65909, 36.81287], [-119.65911, 36.81216], [-119.66006, 36.81217], [-119.6601, 36.81223]]]} | Open Access 1 | 17148 | Countrywood Park | 17711 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.561 | Countrywood Park | 0 | Local Park 2 | 4 | |
10055 | 10055 | 10054 | {"type": "Polygon", "coordinates": [[[-119.72616, 36.80409], [-119.72498, 36.80408], [-119.72498, 36.80306], [-119.72615, 36.80306], [-119.72616, 36.80409]]]} | Open Access 1 | 17892 | San Gabriel Park | 24895 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.958 | San Gabriel 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]);