superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where MNG_AGENCY = 462 and MNG_AG_TYP = 2 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15635 | 15635 | 15634 | {"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 | Well 2 Pocket Park | 27340 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.341 | Well 2 PP | ||
14314 | 14314 | 14313 | {"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.81765], [-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.81793], [-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.81648], [-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.7931], [-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.81605], [-119.65428, 36.81634], [-119.65418, 36.81624], [-119.65449, 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.67206, 36.80731], [-119.67213, 36.80716], [-119.6722, 36.80714], [-119.67227, 36.80718], [-119.67228, 36.80779]]], [[[-119.67672, 36.86383], [-119.67672, 36.86416], [-119.67563, 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 | Unknown park - Clovis, City of | 28715 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 4.825 | |||
13991 | 13991 | 13990 | {"type": "Polygon", "coordinates": [[[-119.69353, 36.82035], [-119.69353, 36.82052], [-119.69309, 36.82052], [-119.69312, 36.82035], [-119.69353, 36.82035]]]} | Open Access 1 | Music Avenue Park | 33298 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.174 | Music Avenue Park | ||
13989 | 13989 | 13988 | {"type": "MultiPolygon", "coordinates": [[[[-119.70632, 36.86297], [-119.7063, 36.86309], [-119.70618, 36.86318], [-119.70604, 36.86324], [-119.70605, 36.86297], [-119.70632, 36.86297]]], [[[-119.70745, 36.86319], [-119.70703, 36.86364], [-119.70606, 36.86364], [-119.70606, 36.86342], [-119.70611, 36.86337], [-119.70621, 36.86333], [-119.7063, 36.86328], [-119.70643, 36.86318], [-119.70672, 36.86311], [-119.70733, 36.86312], [-119.70743, 36.86313], [-119.70745, 36.86319]]]]} | Open Access 1 | Lennar Park | 33284 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.494 | Lennar Park | ||
13988 | 13988 | 13987 | {"type": "Polygon", "coordinates": [[[-119.68004, 36.86487], [-119.68004, 36.86535], [-119.67921, 36.86534], [-119.67921, 36.86486], [-119.67926, 36.86482], [-119.67999, 36.86483], [-119.68004, 36.86487]]]} | Open Access 1 | Town & Country Park | 33281 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.054 | Town & Country Park | ||
13556 | 13556 | 13555 | {"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 | Helm Ranch Community Park | 30988 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 2.785 | Helm Ranch Community Park | ||
13387 | 13387 | 13386 | {"type": "Polygon", "coordinates": [[[-119.74078, 36.76666], [-119.74078, 36.76756], [-119.73882, 36.76755], [-119.73863, 36.76741], [-119.73864, 36.76569], [-119.73984, 36.7657], [-119.73982, 36.76611], [-119.73979, 36.76627], [-119.73981, 36.76633], [-119.73994, 36.76646], [-119.74007, 36.76659], [-119.7402, 36.76665], [-119.74078, 36.76666]]]} | Open Access 1 | Basin V Park | http://www.fresnofloodcontrol.org/wp-content/uploads/2015/01/Map-of-parks.pdf | 30759 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 7.59 | Basin V Park | |
13378 | 13378 | 13377 | {"type": "Polygon", "coordinates": [[[-119.64146, 36.86082], [-119.64061, 36.86083], [-119.64054, 36.86081], [-119.64033, 36.86071], [-119.64039, 36.86063], [-119.64038, 36.86058], [-119.64034, 36.86054], [-119.64039, 36.86048], [-119.64043, 36.86048], [-119.6405, 36.86041], [-119.64048, 36.86038], [-119.64055, 36.86031], [-119.64068, 36.86025], [-119.64076, 36.86015], [-119.64076, 36.86006], [-119.64074, 36.85999], [-119.64069, 36.85994], [-119.6406, 36.85989], [-119.64045, 36.85988], [-119.64032, 36.85992], [-119.64025, 36.86], [-119.64022, 36.8601], [-119.64016, 36.86016], [-119.64013, 36.86016], [-119.64004, 36.86025], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86029], [-119.63977, 36.86035], [-119.63963, 36.86019], [-119.63964, 36.86015], [-119.64081, 36.85949], [-119.64109, 36.85938], [-119.64137, 36.85932], [-119.64142, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | Harlan Ranch Community Park | https://www.visitclovis.com/clovis-parks/ | 33431 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 3.577 | Harlan Ranch Community Park | |
11838 | 11838 | 11837 | {"type": "Polygon", "coordinates": [[[-119.65948, 36.80526], [-119.65948, 36.80591], [-119.65943, 36.80595], [-119.65932, 36.80594], [-119.65899, 36.80589], [-119.65869, 36.80578], [-119.65817, 36.80552], [-119.6581, 36.80542], [-119.65802, 36.80537], [-119.65792, 36.80535], [-119.65781, 36.80537], [-119.65758, 36.80531], [-119.65724, 36.80527], [-119.65717, 36.80524], [-119.65717, 36.80511], [-119.65756, 36.80478], [-119.65764, 36.80478], [-119.6577, 36.80477], [-119.6578, 36.80467], [-119.65787, 36.80464], [-119.65816, 36.80464], [-119.65822, 36.80466], [-119.65832, 36.80475], [-119.6584, 36.80477], [-119.65852, 36.80474], [-119.65858, 36.80465], [-119.65864, 36.80465], [-119.65865, 36.80506], [-119.65899, 36.80507], [-119.65901, 36.80515], [-119.65909, 36.8052], [-119.65917, 36.80522], [-119.65943, 36.80522], [-119.65948, 36.80526]]]} | Open Access 1 | Thorburn Park | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | 28484 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 3.911 | Thorburn Park | |
11252 | 11252 | 11251 | {"type": "Polygon", "coordinates": [[[-119.72248, 36.84862], [-119.72219, 36.84884], [-119.72162, 36.84836], [-119.72192, 36.84814], [-119.72231, 36.84848], [-119.72248, 36.84862]]]} | Open Access 1 | Williamsburg II Park | 27567 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.638 | Williamsburg II Park | ||
11123 | 11123 | 11122 | {"type": "Polygon", "coordinates": [[[-119.669, 36.82146], [-119.66889, 36.82161], [-119.66843, 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 | Westcal New Colony Park | 27384 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.01 | Westcal New Colony Park | ||
11122 | 11122 | 11121 | {"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 | Westcal III Park | 27383 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.88 | Westcal III Park | ||
11121 | 11121 | 11120 | {"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 | Westcal II Park | 27382 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 2.557 | Westcal II Park | ||
10811 | 10811 | 10810 | {"type": "Polygon", "coordinates": [[[-119.69836, 36.82468], [-119.69775, 36.82468], [-119.69775, 36.82405], [-119.69808, 36.82405], [-119.69824, 36.82415], [-119.69829, 36.8242], [-119.69825, 36.82428], [-119.69824, 36.82433], [-119.69825, 36.82442], [-119.69828, 36.82447], [-119.69833, 36.82453], [-119.69836, 36.82468]]]} | Open Access 1 | Veterans Memorial Park | 27026 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.801 | Veterans Memorial Park | ||
10603 | 10603 | 10602 | {"type": "Polygon", "coordinates": [[[-119.72301, 36.83559], [-119.72301, 36.8358], [-119.72299, 36.83592], [-119.72294, 36.83596], [-119.72228, 36.83597], [-119.72224, 36.83593], [-119.72224, 36.83559], [-119.72301, 36.83559]]]} | Open Access 1 | Been Park | 33299 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.698 | Been Park | ||
10595 | 10595 | 10594 | {"type": "Polygon", "coordinates": [[[-119.66006, 36.79725], [-119.66006, 36.7975], [-119.65992, 36.79756], [-119.65992, 36.79787], [-119.65915, 36.79787], [-119.65911, 36.79783], [-119.65911, 36.79726], [-119.65915, 36.79722], [-119.65982, 36.79722], [-119.65998, 36.79726], [-119.66006, 36.79725]]]} | Open Access 1 | Summit 5 Park | 33297 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.365 | Summit 5 Park | ||
10582 | 10582 | 10581 | {"type": "Polygon", "coordinates": [[[-119.65955, 36.79238], [-119.65888, 36.79238], [-119.65883, 36.79234], [-119.65887, 36.79206], [-119.65882, 36.79175], [-119.65887, 36.7917], [-119.65955, 36.7917], [-119.65955, 36.79238]]]} | Open Access 1 | Summit 4 Park | 33296 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.163 | Summit 4 Park | ||
10581 | 10581 | 10580 | {"type": "MultiPolygon", "coordinates": [[[[-119.64718, 36.793], [-119.64648, 36.79352], [-119.64647, 36.79366], [-119.64621, 36.79366], [-119.64621, 36.79344], [-119.64632, 36.79344], [-119.64705, 36.7929], [-119.64718, 36.793]]], [[[-119.65109, 36.792], [-119.65109, 36.7923], [-119.65104, 36.79235], [-119.65025, 36.79234], [-119.64996, 36.79228], [-119.64946, 36.79221], [-119.64938, 36.79223], [-119.64932, 36.79227], [-119.64907, 36.79223], [-119.64845, 36.79223], [-119.64833, 36.79229], [-119.64825, 36.79228], [-119.64815, 36.79232], [-119.64797, 36.79232], [-119.64783, 36.79238], [-119.64758, 36.79265], [-119.64731, 36.7929], [-119.64718, 36.79281], [-119.64745, 36.79256], [-119.6477, 36.79229], [-119.64776, 36.7923], [-119.64784, 36.79228], [-119.64789, 36.79225], [-119.64793, 36.79219], [-119.64821, 36.79216], [-119.64843, 36.79211], [-119.64917, 36.7921], [-119.64995, 36.79199], [-119.65109, 36.792]]], [[[-119.65208, 36.79231], [-119.65203, 36.79235], [-119.65131, 36.79235], [-119.65126, 36.7923], [-119.65126, 36.79226], [-119.65208, 36.79225], [-119.65208, 36.79231]]], [[[-119.65294, 36.79232], [-119.65294, 36.7924], [-119.65279, 36.7924], [-119.65272, 36.79242], [-119.65228, 36.79238], [-119.65225, 36.79226], [-119.65273, 36.79226], [-119.65294, 36.79232]]]]} | Open Access 1 | Camden Place Park | 33295 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 2.905 | Camden Place Park | ||
10565 | 10565 | 10564 | {"type": "Polygon", "coordinates": [[[-119.65231, 36.79585], [-119.65231, 36.79617], [-119.65185, 36.79611], [-119.65214, 36.79577], [-119.65218, 36.79576], [-119.65227, 36.7958], [-119.65231, 36.79585]]]} | Open Access 1 | Arrowhead Park | 33294 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.289 | Arrowhead Park | ||
10552 | 10552 | 10551 | {"type": "MultiPolygon", "coordinates": [[[[-119.65091, 36.79722], [-119.65091, 36.79784], [-119.65005, 36.79784], [-119.65005, 36.79766], [-119.65008, 36.79749], [-119.65008, 36.79719], [-119.65013, 36.79715], [-119.65062, 36.79715], [-119.65086, 36.79719], [-119.65091, 36.79722]]], [[[-119.65111, 36.79636], [-119.65092, 36.79659], [-119.65082, 36.79672], [-119.6507, 36.79702], [-119.6505, 36.79701], [-119.6505, 36.79654], [-119.65083, 36.79654], [-119.65102, 36.79631], [-119.65111, 36.79636]]]]} | Open Access 1 | East West Park | 33293 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.827 | East West 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]);