units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 14 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11834 | 11834 | 11833 | {"type": "Polygon", "coordinates": [[[-119.78713, 36.78872], [-119.78713, 36.78889], [-119.78701, 36.78893], [-119.78668, 36.78911], [-119.78668, 36.78946], [-119.786, 36.78946], [-119.786, 36.7893], [-119.78631, 36.78913], [-119.78631, 36.78872], [-119.78713, 36.78872]]]} | Open Access 1 | 24160 | Granny's Park | 19433 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.17 | Granny's Park | 0 | Local Park 2 | 4 | |
6516 | 6516 | 6515 | {"type": "Polygon", "coordinates": [[[-119.79424, 36.75293], [-119.794, 36.75293], [-119.79398, 36.75284], [-119.79363, 36.75283], [-119.7936, 36.75262], [-119.7929, 36.75264], [-119.7929, 36.75233], [-119.79402, 36.75232], [-119.79402, 36.75259], [-119.79421, 36.75258], [-119.79424, 36.75293]]]} | Open Access 1 | 2496 | Ted C Wills Park & Community Center | 26212 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.226 | Ted C Wills Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
3769 | 3769 | 3768 | {"type": "Polygon", "coordinates": [[[-119.85853, 36.83271], [-119.85849, 36.83274], [-119.85745, 36.83274], [-119.8574, 36.83271], [-119.85741, 36.83201], [-119.85745, 36.83197], [-119.85754, 36.83198], [-119.8576, 36.832], [-119.85848, 36.83263], [-119.85853, 36.83271]]]} | Open Access 1 | 47313 | Emerald Pocket Park | 31020 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.276 | Emerald PP | 0 | Local Park 2 | 4 | |
3347 | 3347 | 3346 | {"type": "Polygon", "coordinates": [[[-119.78805, 36.73876], [-119.78766, 36.73903], [-119.78676, 36.73821], [-119.78714, 36.73794], [-119.78805, 36.73876]]]} | Open Access 1 | 24154 | Eaton Plaza | 18412 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.379 | Eaton Plaza | 0 | Local Park 2 | 4 | |
5602 | 5602 | 5601 | {"type": "Polygon", "coordinates": [[[-119.86893, 36.80535], [-119.86802, 36.80535], [-119.868, 36.8046], [-119.86867, 36.80459], [-119.86867, 36.80473], [-119.86875, 36.80487], [-119.86892, 36.80516], [-119.86893, 36.80535]]]} | Open Access 1 | 1774 | Basin AH1 Dog Park | 15848 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.48 | Basin AH1 Dog Park | 0 | Local Park 2 | 4 | |
4807 | 4807 | 4806 | {"type": "MultiPolygon", "coordinates": [[[[-119.67174, 36.72576], [-119.66919, 36.72576], [-119.66915, 36.72573], [-119.66915, 36.72558], [-119.67174, 36.72558], [-119.67174, 36.72576]]], [[[-119.82535, 36.71988], [-119.82534, 36.72036], [-119.82506, 36.72036], [-119.82504, 36.72034], [-119.82504, 36.7199], [-119.82507, 36.71989], [-119.82535, 36.71988]]]]} | Open Access 1 | 48591 | Unknown park - Fresno, City of | 33300 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.496 | 0 | Local Other or Unknown 14 | 4 | ||
5935 | 5935 | 5934 | {"type": "Polygon", "coordinates": [[[-119.79717, 36.7505], [-119.79716, 36.75054], [-119.79712, 36.75055], [-119.79669, 36.7507], [-119.79669, 36.75072], [-119.79608, 36.75095], [-119.79521, 36.75121], [-119.79516, 36.7512], [-119.79512, 36.75115], [-119.79511, 36.75056], [-119.79515, 36.75052], [-119.79644, 36.75054], [-119.79717, 36.7505]]]} | Open Access 1 | 47314 | San Pablo Pocket Park | 31021 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.9 | San Pablo PP | 0 | Local Park 2 | 4 | |
209 | 209 | 208 | {"type": "Polygon", "coordinates": [[[-119.80506, 36.72867], [-119.80285, 36.72866], [-119.80276, 36.7286], [-119.80374, 36.72791], [-119.80416, 36.72827], [-119.80436, 36.7284], [-119.80469, 36.72856], [-119.80505, 36.72866], [-119.80506, 36.72867]]]} | Open Access 1 | 47327 | Kearney and Fresno Pocket Park | 31034 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.936 | Kearney and Fresno PP | 0 | Local Park 2 | 4 | |
12091 | 12091 | 12090 | {"type": "Polygon", "coordinates": [[[-119.83131, 36.73084], [-119.83105, 36.73093], [-119.8308, 36.7311], [-119.83062, 36.73094], [-119.83057, 36.73087], [-119.83054, 36.73079], [-119.83057, 36.73064], [-119.83056, 36.73058], [-119.83053, 36.73053], [-119.83052, 36.72993], [-119.8313, 36.72992], [-119.83131, 36.73084]]]} | Open Access 1 | 24909 | Chandler Park | 17119 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.942 | Chandler Park | 0 | Local Park 2 | 4 | |
268 | 268 | 267 | {"type": "Polygon", "coordinates": [[[-119.88625, 36.80929], [-119.88539, 36.8101], [-119.88421, 36.8093], [-119.88556, 36.80929], [-119.88625, 36.80929]]]} | Open Access 1 | 737 | Highway City Park | 19952 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.017 | Highway City Park | 0 | Local Park 2 | 4 | |
122 | 122 | 121 | {"type": "Polygon", "coordinates": [[[-119.79182, 36.7434], [-119.79182, 36.74417], [-119.7913, 36.74417], [-119.79129, 36.74413], [-119.79071, 36.74413], [-119.79072, 36.7434], [-119.79182, 36.7434]]]} | Open Access 1 | 419 | Dicky Playground | 18152 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.025 | Dicky Playground | 0 | Local Recreation Area 3 | 4 | |
542 | 542 | 541 | {"type": "Polygon", "coordinates": [[[-119.72964, 36.73869], [-119.72964, 36.73915], [-119.72751, 36.73913], [-119.72751, 36.7387], [-119.72964, 36.73869]]]} | Open Access 1 | 2756 | Willow-Balch Park | 27572 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.327 | Willow-Balch Park | 0 | Local Park 2 | 4 | |
635 | 635 | 634 | {"type": "Polygon", "coordinates": [[[-119.77627, 36.79171], [-119.77626, 36.7921], [-119.77622, 36.79217], [-119.77614, 36.79222], [-119.77607, 36.79223], [-119.77477, 36.79223], [-119.77479, 36.79156], [-119.7761, 36.79158], [-119.77621, 36.79162], [-119.77627, 36.79171]]]} | Open Access 1 | 2573 | University Park | 26686 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.376 | University Park | 0 | Local Park 2 | 4 | |
3622 | 3622 | 3621 | {"type": "Polygon", "coordinates": [[[-119.79574, 36.86151], [-119.79571, 36.86193], [-119.79566, 36.86217], [-119.79552, 36.86243], [-119.79533, 36.86264], [-119.79448, 36.86334], [-119.79445, 36.86334], [-119.79405, 36.86302], [-119.79425, 36.86289], [-119.79478, 36.86239], [-119.79531, 36.86194], [-119.79547, 36.86178], [-119.79564, 36.86155], [-119.79574, 36.86151]]]} | Open Access 1 | 47312 | Audubon Pocket Park | 31019 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.439 | Audubon PP | 0 | Local Park 2 | 4 | |
12090 | 12090 | 12089 | {"type": "Polygon", "coordinates": [[[-119.79758, 36.71954], [-119.79741, 36.71954], [-119.79746, 36.71941], [-119.79746, 36.71911], [-119.79655, 36.71837], [-119.79595, 36.71837], [-119.79532, 36.71786], [-119.79536, 36.71783], [-119.79597, 36.71832], [-119.79654, 36.71832], [-119.79747, 36.71756], [-119.79747, 36.71786], [-119.79758, 36.71787], [-119.79758, 36.71954]]]} | Open Access 1 | 24908 | Bigby Park | 16096 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.439 | Bigby Park | 0 | Local Park 2 | 4 | |
10619 | 10619 | 10618 | {"type": "Polygon", "coordinates": [[[-119.79872, 36.7241], [-119.79791, 36.72469], [-119.797, 36.72386], [-119.79782, 36.72328], [-119.79872, 36.7241]]]} | Open Access 1 | 18921 | Ball Playground | 15785 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.938 | Ball Playground | 0 | Local Recreation Area 3 | 4 | |
22 | 22 | 21 | {"type": "Polygon", "coordinates": [[[-119.79976, 36.71887], [-119.79974, 36.71947], [-119.79972, 36.71963], [-119.7977, 36.7196], [-119.79769, 36.71907], [-119.79807, 36.71906], [-119.79808, 36.71894], [-119.7991, 36.71892], [-119.79911, 36.71887], [-119.79976, 36.71887]]]} | Open Access 1 | 60 | Bigby VIlla Park | 16097 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.426 | Bigby VIlla Park | 0 | Local Park 2 | 4 | |
14714 | 14714 | 14713 | {"type": "Polygon", "coordinates": [[[-119.73612, 36.75237], [-119.73611, 36.75296], [-119.73604, 36.75329], [-119.73604, 36.75376], [-119.73586, 36.75394], [-119.73526, 36.75388], [-119.73422, 36.75374], [-119.73422, 36.75317], [-119.73587, 36.75317], [-119.73588, 36.75235], [-119.73609, 36.75235], [-119.73612, 36.75237]]]} | Open Access 1 | 45053 | Martin Ray Reilly Park | 28046 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresnorda.com/index.php?rda=portfolio&n=port&p=44 | Fresno 9 | 3.489 | Martin Ray Reilly Park | 0 | Local Park 2 | 4 |
7281 | 7281 | 7280 | {"type": "Polygon", "coordinates": [[[-119.85946, 36.77405], [-119.85882, 36.77405], [-119.85878, 36.77397], [-119.85869, 36.77392], [-119.85806, 36.77392], [-119.858, 36.77393], [-119.85794, 36.77396], [-119.85791, 36.774], [-119.85789, 36.77406], [-119.85725, 36.77406], [-119.85727, 36.77397], [-119.85732, 36.7739], [-119.85734, 36.77374], [-119.85734, 36.77366], [-119.85729, 36.77359], [-119.85721, 36.77327], [-119.8572, 36.77314], [-119.85724, 36.77311], [-119.85724, 36.77327], [-119.85731, 36.77351], [-119.85762, 36.77351], [-119.8577, 36.77345], [-119.85786, 36.77349], [-119.85801, 36.77349], [-119.85816, 36.77344], [-119.85816, 36.77322], [-119.85813, 36.77319], [-119.85816, 36.77314], [-119.85817, 36.77309], [-119.85814, 36.77303], [-119.85809, 36.77299], [-119.85809, 36.77244], [-119.85794, 36.77232], [-119.85794, 36.77225], [-119.85788, 36.77218], [-119.85788, 36.77204], [-119.85791, 36.77202], [-119.85823, 36.77202], [-119.85828, 36.77199], [-119.85837, 36.77199], [-119.85837, 36.77221], [-119.85829, 36.77217], [-119.85819, 36.77217], [-119.85811, 36.77222], [-119.85809, 36.7723], [-119.8581, 36.77235], [-119.85815, 36.77239], [-119.85821, 36.77242], [-119.85829, 36.77242], [-119.85829, 36.77297], [-119.85841, 36.77306], [-119.85841, 36.77313], [-119.85845, 36.77319], [-119.85841, 36.77322], [-119.85842, 36.77343], [-119.85857, 36.77348], [-119.85865, 36.77348], [-119.85888, 36.77338], [-119.85903, 36.77338], [-119.85911, 36.7735], [-119.85946, 36.7735], [-119.85943, 36.77359], [-119.85939, 36.77365], [-119.85938, 36.77374], [-119.8594, 36.77391], [-119.85945, 36.77397], [-119.85946, 36.77405]]]} | Open Access 1 | 48940 | Westwood Park | 33656 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.656 | Westwood Park | 0 | Local Park 2 | 4 | |
1986 | 1986 | 1985 | {"type": "Polygon", "coordinates": [[[-119.79036, 36.76947], [-119.78888, 36.76947], [-119.78887, 36.7687], [-119.78891, 36.76869], [-119.78909, 36.7686], [-119.79, 36.76854], [-119.79001, 36.76798], [-119.79035, 36.76797], [-119.79036, 36.76947]]]} | Unknown Access 4 | 15187 | Ratcliffe Stadium | 24192 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.753 | Ratcliffe Stadium | None 158 |
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]);