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 LABEL_NAME 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
10203 | 10203 | 10202 | {"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 | 48572 | Town & Country Park | 33281 | 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.054 | Town & Country Park | 0 | Local Park 2 | 4 | |
15020 | 15020 | 15019 | {"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.65774, 36.80474], [-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.65864, 36.80506], [-119.65899, 36.80507], [-119.65901, 36.80515], [-119.65909, 36.8052], [-119.65916, 36.80522], [-119.65943, 36.80522], [-119.65948, 36.80526]]]} | Open Access 1 | 45667 | Thorburn Park | 28484 | 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 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | Fresno 9 | 3.907 | Thorburn 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 | |
10474 | 10474 | 10473 | {"type": "Polygon", "coordinates": [[[-119.66006, 36.7975], [-119.65992, 36.79756], [-119.65992, 36.79787], [-119.65915, 36.79787], [-119.65911, 36.79783], [-119.65911, 36.79725], [-119.65915, 36.79722], [-119.65982, 36.79722], [-119.65998, 36.79726], [-119.66006, 36.79725], [-119.66006, 36.7975]]]} | Open Access 1 | 48588 | Summit 5 Park | 33297 | 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.365 | Summit 5 Park | 0 | Local Park 2 | 4 | |
10473 | 10473 | 10472 | {"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 | 48587 | Summit 4 Park | 33296 | 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.164 | Summit 4 Park | 0 | Local Park 2 | 4 | |
2646 | 2646 | 2645 | {"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 | 18107 | Stanford El Paso Park | 25786 | 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.823 | Stanford El Paso Park | 0 | Local Park 2 | 4 | |
2634 | 2634 | 2633 | {"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 | 18063 | Silverton II Park | 25500 | 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.783 | Silverton II Park | 0 | Local Park 2 | 4 | |
2625 | 2625 | 2624 | {"type": "Polygon", "coordinates": [[[-119.66392, 36.83292], [-119.65948, 36.83293], [-119.65947, 36.83112], [-119.66171, 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 | 18019 | Sierra Meadows Park | 25459 | 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 | 27.516 | Sierra Meadows Park | 0 | Local Park 2 | 4 | |
2542 | 2542 | 2541 | {"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 | 17971 | Sierra Bicentennial Park | 25447 | 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.659 | Sierra Bicentennial Park | 0 | Local Park 2 | 4 | |
2223 | 2223 | 2222 | {"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 | 17929 | Seville II Park | 25328 | 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.767 | Seville II 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 | |
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 | |
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 |
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]);