units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
54 rows where DES_TP = 2 and MNG_AGENCY = 462 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
MNG_AG_TYP 1
- City Agency 54
MNG_AGENCY 1
- Clovis, City of · 54 ✖
DES_TP 1
- Local Park · 54 ✖
ACCESS_TYP 1
- Open Access 54
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14469 | 14469 | 14468 | {"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.76632], [-119.73994, 36.76646], [-119.74007, 36.76659], [-119.7402, 36.76665], [-119.74078, 36.76666]]]} | Open Access 1 | 47100 | Basin V Park | 30759 | 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 | http://www.fresnofloodcontrol.org/wp-content/uploads/2015/01/Map-of-parks.pdf | Fresno 9 | 7.59 | Basin V 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 | |
2302 | 2302 | 2301 | {"type": "Polygon", "coordinates": [[[-119.72538, 36.84211], [-119.72536, 36.84239], [-119.72493, 36.84241], [-119.72462, 36.84237], [-119.72461, 36.84214], [-119.72494, 36.8421], [-119.72538, 36.84211]]]} | Open Access 1 | 16941 | Birchwood Park | 16120 | 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.53 | Birchwood 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 | |
10501 | 10501 | 10500 | {"type": "Polygon", "coordinates": [[[-119.72301, 36.83559], [-119.72301, 36.83581], [-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 | 48590 | Been Park | 33299 | 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.698 | Been 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 | |
10487 | 10487 | 10486 | {"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 | 18580 | Williamsburg II Park | 27567 | 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.638 | Williamsburg II Park | 0 | Local Park 2 | 4 | |
2536 | 2536 | 2535 | {"type": "Polygon", "coordinates": [[[-119.72006, 36.8449], [-119.72006, 36.84705], [-119.71751, 36.84488], [-119.72006, 36.84489], [-119.72006, 36.8449]]]} | Open Access 1 | 17760 | Peach/Alluvial Park | 23541 | 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.735 | Peach/Alluvial Park | 0 | Local Park 2 | 4 | |
2443 | 2443 | 2442 | {"type": "Polygon", "coordinates": [[[-119.71617, 36.81755], [-119.71573, 36.81793], [-119.71532, 36.81861], [-119.71505, 36.81937], [-119.71502, 36.81938], [-119.71474, 36.81969], [-119.71464, 36.81984], [-119.71429, 36.82022], [-119.71413, 36.82034], [-119.71359, 36.82067], [-119.71352, 36.82067], [-119.71358, 36.81756], [-119.71617, 36.81755]]]} | Open Access 1 | 17352 | Letterman Park | 21185 | 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 | 11.27 | Letterman Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
2561 | 2561 | 2560 | {"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 | 17848 | Rotary Park | 24688 | 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 | 13.352 | Rotary Park | 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 | |
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 | |
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 | |
2437 | 2437 | 2436 | {"type": "Polygon", "coordinates": [[[-119.70433, 36.81802], [-119.70414, 36.81802], [-119.70414, 36.8176], [-119.70433, 36.8176], [-119.70433, 36.81802]]]} | Open Access 1 | 17319 | Kiwanis Pocket Park | 20684 | 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.196 | Kiwanis PP | 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 | |
10340 | 10340 | 10339 | {"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 | 18227 | Treasure Ingmire Park | 26517 | 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.19 | Treasure Ingmire Park | 0 | Local Park 2 | 4 | |
10367 | 10367 | 10366 | {"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 | 18301 | Veterans Memorial Park | 27026 | 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.801 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
2314 | 2314 | 2313 | {"type": "Polygon", "coordinates": [[[-119.69752, 36.84242], [-119.697, 36.84242], [-119.69698, 36.84194], [-119.69719, 36.84192], [-119.6975, 36.84192], [-119.69752, 36.84242]]]} | Open Access 1 | 16974 | Blackhorse II Park | 16143 | 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.623 | Blackhorse II 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]);