superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where MNG_AGENCY = 462 sorted by MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7131 | 7131 | 7130 | {"type": "Polygon", "coordinates": [[[-119.68921, 36.83919], [-119.68885, 36.83919], [-119.6885, 36.83919], [-119.68853, 36.83903], [-119.68919, 36.83902], [-119.68921, 36.83919]]]} | Open Access 1 | Monte Vista 26 Park | 22397 | 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.279 | Monte Vista 26 Park | ||
7132 | 7132 | 7131 | {"type": "Polygon", "coordinates": [[[-119.6895, 36.8419], [-119.6895, 36.84242], [-119.68915, 36.84242], [-119.68915, 36.8419], [-119.6895, 36.8419]]]} | Open Access 1 | Monte Vista 31 Park | 22398 | 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.451 | Monte Vista 31 Park | ||
7251 | 7251 | 7250 | {"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 | Rancho Paloma II Park | 24160 | 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.508 | Rancho Paloma II Park | ||
7496 | 7496 | 7495 | {"type": "Polygon", "coordinates": [[[-119.67094, 36.84746], [-119.67055, 36.84751], [-119.67054, 36.84701], [-119.67091, 36.84701], [-119.67094, 36.84746]]]} | Open Access 1 | Northwood Park | 22901 | 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.444 | Northwood 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 | ||
8039 | 8039 | 8038 | {"type": "Polygon", "coordinates": [[[-119.72006, 36.8449], [-119.72006, 36.84705], [-119.71751, 36.84488], [-119.71751, 36.84488], [-119.72006, 36.8449]]]} | Open Access 1 | Peach/Alluvial Park | 23541 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 6.733 | Peach/Alluvial Park | ||
8444 | 8444 | 8443 | {"type": "Polygon", "coordinates": [[[-119.71613, 36.84877], [-119.71566, 36.84877], [-119.71566, 36.84814], [-119.71596, 36.84816], [-119.71602, 36.8482], [-119.71611, 36.84822], [-119.71613, 36.84845], [-119.71613, 36.84877]]]} | Open Access 1 | Quail Hollow | 24042 | 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.686 | Quail Hollow | ||
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 | ||
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 | ||
9512 | 9512 | 9511 | {"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 | Los Arbolitos Park | 33290 | 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.464 | Los Arbolitos 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
10498 | 10498 | 10497 | {"type": "MultiPolygon", "coordinates": [[[[-119.68381, 36.86402], [-119.68381, 36.86413], [-119.68281, 36.86369], [-119.68253, 36.86359], [-119.68195, 36.86349], [-119.68145, 36.86345], [-119.6805, 36.86361], [-119.67987, 36.86368], [-119.67953, 36.86369], [-119.67899, 36.86363], [-119.6787, 36.86373], [-119.67845, 36.86377], [-119.67705, 36.86377], [-119.67597, 36.86398], [-119.675, 36.86422], [-119.67499, 36.86431], [-119.67482, 36.86406], [-119.67468, 36.8639], [-119.67418, 36.8635], [-119.67387, 36.86332], [-119.6743, 36.86317], [-119.6743, 36.8629], [-119.67433, 36.86277], [-119.6744, 36.86266], [-119.67455, 36.86247], [-119.67483, 36.86221], [-119.67489, 36.86211], [-119.67495, 36.86196], [-119.67495, 36.86052], [-119.6749, 36.86037], [-119.67479, 36.86023], [-119.67463, 36.86014], [-119.6743, 36.86018], [-119.67406, 36.8602], [-119.67381, 36.86015], [-119.67357, 36.86007], [-119.67344, 36.85999], [-119.67321, 36.85984], [-119.67306, 36.85964], [-119.67298, 36.85922], [-119.6731, 36.85922], [-119.67318, 36.85961], [-119.6733, 36.85977], [-119.67363, 36.85998], [-119.67385, 36.86006], [-119.67407, 36.8601], [-119.67466, 36.86004], [-119.67487, 36.86016], [-119.67501, 36.86031], [-119.675, 36.86215], [-119.67493, 36.86226], [-119.67465, 36.86253], [-119.6745, 36.86271], [-119.67444, 36.8628], [-119.67442, 36.86291], [-119.67441, 36.86305], [-119.67445, 36.86333], [-119.67448, 36.86347], [-119.67455, 36.86361], [-119.67465, 36.86374], [-119.67482, 36.8639], [-119.67509, 36.86403], [-119.67529, 36.86405], [-119.67593, 36.86388], [-119.67703, 36.86367], [-119.67843, 36.86368], [-119.67866, 36.86364], [-119.67897, 36.86353], [-119.67953, 36.8636], [-119.67986, 36.86359], [-119.68048, 36.86352], [-119.68144, 36.86335], [-119.68197, 36.86339], [-119.68258, 36.8635], [-119.68286, 36.8636], [-119.68381, 36.86402]]], [[[-119.68852, 36.86591], [-119.68852, 36.86601], [-119.68834, 36.86601], [-119.68787, 36.8659], [-119.6879, 36.86586], [-119.6879, 36.86584], [-119.68778, 36.86577], [-119.68773, 36.86581], [-119.68656, 36.86498], [-119.68633, 36.86483], [-119.68616, 36.86476], [-119.6853, 36.86455], [-119.68422, 36.86423], [-119.68422, 36.86413], [-119.68534, 36.86446], [-119.68621, 36.86467], [-119.6864, 36.86475], [-119.68664, 36.86491], [-119.68759, 36.86558], [-119.68788, 36.86576], [-119.68811, 36.86586], [-119.68835, 36.86591], [-119.68852, 36.86591]]]]} | Open Access 1 | Enterprise Canal Trail | 33283 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 5.247 | Enterprise Canal Trail | ||
10499 | 10499 | 10498 | {"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.69671, 36.8623], [-119.69669, 36.86282], [-119.69651, 36.86282], [-119.69649, 36.86285], [-119.69627, 36.86286], [-119.69606, 36.86297], [-119.69591, 36.86304], [-119.69573, 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.69648, 36.86271], [-119.6965, 36.86225], [-119.69709, 36.86211], [-119.69821, 36.862], [-119.70028, 36.86085], [-119.7009, 36.85991], [-119.70168, 36.85931], [-119.70189, 36.85931]]]} | Open Access 1 | Dry Creek Trail | 33285 | 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.988 | Dry Creek Trail | ||
10500 | 10500 | 10499 | {"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 | Pinnacles Park | 33286 | 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.026 | Pinnacles Park | ||
10518 | 10518 | 10517 | {"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.86547], [-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 | European Parc Park | 33287 | 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.282 | European Parc 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]);