units_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 ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
10500 | 10500 | 10499 | {"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 | 48589 | Music Avenue Park | 33298 | 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.174 | Music Avenue Park | 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 | |
2494 | 2494 | 2493 | {"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 | 17523 | Monte Vista 26 Park | 22397 | 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.279 | Monte Vista 26 Park | 0 | Local Park 2 | 4 | |
10458 | 10458 | 10457 | {"type": "Polygon", "coordinates": [[[-119.65231, 36.79585], [-119.65231, 36.79617], [-119.65185, 36.79611], [-119.65214, 36.79577], [-119.65218, 36.79576], [-119.65228, 36.7958], [-119.65231, 36.79585]]]} | Open Access 1 | 48584 | Arrowhead Park | 33294 | 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.289 | Arrowhead 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 | |
2005 | 2005 | 2004 | {"type": "Polygon", "coordinates": [[[-119.68907, 36.79478], [-119.68907, 36.79478], [-119.6883, 36.79422], [-119.68889, 36.79423], [-119.68907, 36.79478]]]} | Open Access 1 | 16909 | Basin IE Park | 15850 | 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.401 | Basin IE Park | 0 | Local Park 2 | 4 | |
2168 | 2168 | 2167 | {"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 | 17643 | Northwood Park | 22901 | 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.444 | Northwood Park | 0 | Local Park 2 | 4 | |
2509 | 2509 | 2508 | {"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 | 17563 | Monte Vista 31 Park | 22398 | 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.451 | Monte Vista 31 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 | |
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 | |
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 | |
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 | |
10140 | 10140 | 10139 | {"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 | 17723 | Quail Hollow | 24042 | 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.686 | Quail Hollow | None 879 | |||
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 | |
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 | |
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 | |
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 | |
13365 | 13365 | 13364 | {"type": "Polygon", "coordinates": [[[-119.72541, 36.85784], [-119.72537, 36.85789], [-119.7249, 36.85789], [-119.72489, 36.85762], [-119.72456, 36.85762], [-119.72456, 36.85735], [-119.72541, 36.85735], [-119.72541, 36.85784]]]} | Open Access 1 | 35449 | Clovis holding 1 | 17446 | 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.906 | Clovis holding 1 | 0 | Local Other or Unknown 14 | 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]);