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 PARK_NAME 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | |||
10449 | 10449 | 10448 | {"type": "Polygon", "coordinates": [[[-119.7013, 36.82931], [-119.7013, 36.83026], [-119.70079, 36.83026], [-119.70079, 36.82931], [-119.7013, 36.82931]]]} | Open Access 1 | Treasure Ingmire Park | 26517 | 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.19 | Treasure Ingmire 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 | ||
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 | |
8755 | 8755 | 8754 | {"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 | Tenaya Sun Ranch Park | 26240 | 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.058 | Tenaya Sun Ranch 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 | ||
9907 | 9907 | 9906 | {"type": "Polygon", "coordinates": [[[-119.68973, 36.84654], [-119.68973, 36.84842], [-119.68867, 36.84844], [-119.68868, 36.84677], [-119.68875, 36.84667], [-119.68892, 36.84656], [-119.68973, 36.84654]]]} | Open Access 1 | Stanford El Paso Park | 25786 | 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.822 | Stanford El Paso Park | ||
9688 | 9688 | 9687 | {"type": "Polygon", "coordinates": [[[-119.66697, 36.81099], [-119.66697, 36.81158], [-119.66646, 36.81159], [-119.66647, 36.81091], [-119.66697, 36.81099]]]} | Open Access 1 | Silverton II Park | 25500 | 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.783 | Silverton II Park | ||
9644 | 9644 | 9643 | {"type": "Polygon", "coordinates": [[[-119.66392, 36.83292], [-119.65948, 36.83293], [-119.65947, 36.83112], [-119.6617, 36.83111], [-119.6617, 36.82964], [-119.66386, 36.82964], [-119.66386, 36.83008], [-119.66389, 36.83028], [-119.6639, 36.83041], [-119.66392, 36.83292]]]} | Open Access 1 | Sierra Meadows Park | 25459 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 27.526 | Sierra Meadows Park | ||
9636 | 9636 | 9635 | {"type": "Polygon", "coordinates": [[[-119.69326, 36.83383], [-119.69114, 36.83381], [-119.69112, 36.83115], [-119.69109, 36.83041], [-119.69323, 36.83041], [-119.69326, 36.83383]]]} | Open Access 1 | Sierra Bicentennial Park | 25447 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 17.657 | Sierra Bicentennial Park | ||
9528 | 9528 | 9527 | {"type": "Polygon", "coordinates": [[[-119.66782, 36.7926], [-119.66782, 36.79282], [-119.66779, 36.79318], [-119.66729, 36.79318], [-119.66729, 36.79286], [-119.66733, 36.79255], [-119.66772, 36.79257], [-119.66782, 36.7926]]]} | Open Access 1 | Seville II Park | 25328 | 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.767 | Seville II Park | ||
7756 | 7756 | 7755 | {"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 | San Gabriel Park | 24895 | 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.957 | San Gabriel Park | ||
9013 | 9013 | 9012 | {"type": "Polygon", "coordinates": [[[-119.71344, 36.81389], [-119.71341, 36.8156], [-119.71337, 36.81563], [-119.71008, 36.81563], [-119.71009, 36.81479], [-119.71047, 36.81478], [-119.71048, 36.81389], [-119.71344, 36.81389]]]} | Open Access 1 | Rotary Park | 24688 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 13.355 | Rotary 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]);