superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 14 sorted by PARK_URL descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11564 | 11564 | 11563 | {"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 | Martin Ray Reilly Park | http://www.fresnorda.com/index.php?rda=portfolio&n=port&p=44 | 28046 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 3.496 | Martin Ray Reilly Park | |
15059 | 15059 | 15058 | {"type": "MultiPolygon", "coordinates": [[[[-119.77984, 36.87156], [-119.77966, 36.87362], [-119.77899, 36.87362], [-119.77909, 36.87304], [-119.77923, 36.8718], [-119.77984, 36.87156]]], [[[-119.77985, 36.8713], [-119.77924, 36.87154], [-119.77958, 36.86783], [-119.77973, 36.86805], [-119.77993, 36.8686], [-119.77999, 36.86929], [-119.77985, 36.8713]]], [[[-119.79146, 36.87061], [-119.78964, 36.87074], [-119.78963, 36.87116], [-119.78948, 36.87117], [-119.78764, 36.8717], [-119.78655, 36.87182], [-119.78507, 36.87095], [-119.78472, 36.8708], [-119.78322, 36.87198], [-119.78336, 36.8725], [-119.78317, 36.87293], [-119.78262, 36.87323], [-119.78149, 36.87337], [-119.78108, 36.87363], [-119.77986, 36.87363], [-119.78006, 36.87141], [-119.78019, 36.86929], [-119.78012, 36.86857], [-119.77992, 36.868], [-119.77961, 36.86751], [-119.77973, 36.86629], [-119.77997, 36.86552], [-119.78036, 36.86468], [-119.78061, 36.86427], [-119.7828, 36.86076], [-119.78288, 36.86073], [-119.78347, 36.86095], [-119.78398, 36.86117], [-119.78432, 36.86127], [-119.78469, 36.86134], [-119.78481, 36.86134], [-119.78498, 36.86136], [-119.78531, 36.86136], [-119.78674, 36.86118], [-119.78719, 36.86116], [-119.78817, 36.86119], [-119.78935, 36.86117], [-119.79014, 36.86126], [-119.79103, 36.86126], [-119.7911, 36.86129], [-119.79113, 36.86134], [-119.79118, 36.86235], [-119.79119, 36.8629], [-119.7914, 36.86729], [-119.79136, 36.87004], [-119.79125, 36.87043], [-119.7913, 36.87054], [-119.79146, 36.87061]]]]} | Open Access 1 | Woodward Regional Park | http://www.fresno.gov/government/departmentdirectory/parksandrecreation/parksandfacilities/regional+parks/woodwardpark.htm | 3935 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 290.78 | Woodward RP | |
9927 | 9927 | 9926 | {"type": "Polygon", "coordinates": [[[-119.79776, 36.74007], [-119.79738, 36.74034], [-119.79686, 36.73987], [-119.79725, 36.7396], [-119.79776, 36.74007]]]} | Open Access 1 | Cultural Arts District Park | http://www.downtownfresno.org/go/cultural-arts-district | 27989 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 0.782 | Cultural Arts District Park | |
775 | 775 | 774 | {"type": "Polygon", "coordinates": [[[-119.68886, 36.75301], [-119.68793, 36.75307], [-119.68654, 36.75303], [-119.68652, 36.75053], [-119.68884, 36.75054], [-119.68886, 36.75301]]]} | Open Access 1 | Al Radka Park | 15310 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 14.339 | Al Radka Park | ||
1284 | 1284 | 1283 | {"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 | 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 | 2.937 | Ball Playground | ||
1790 | 1790 | 1789 | {"type": "Polygon", "coordinates": [[[-119.86893, 36.80535], [-119.86802, 36.80535], [-119.868, 36.8046], [-119.86867, 36.80459], [-119.86868, 36.80473], [-119.86875, 36.80488], [-119.86892, 36.80516], [-119.86893, 36.80535]]]} | Open Access 1 | Basin AH1 Dog Park | 15848 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1.479 | Basin AH1 Dog Park | ||
1913 | 1913 | 1912 | {"type": "Polygon", "coordinates": [[[-119.74445, 36.84495], [-119.74445, 36.84683], [-119.74325, 36.84684], [-119.74325, 36.84496], [-119.74445, 36.84495]]]} | Open Access 1 | Belcher Park | 15964 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 5.493 | Belcher Park | ||
1999 | 1999 | 1998 | {"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.79909, 36.71892], [-119.79911, 36.71887], [-119.79976, 36.71887]]]} | Open Access 1 | 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 | 3.428 | Bigby VIlla Park | ||
2010 | 2010 | 2009 | {"type": "Polygon", "coordinates": [[[-119.79758, 36.71954], [-119.79741, 36.71954], [-119.79746, 36.71941], [-119.79745, 36.7191], [-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 | 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 | 2.446 | Bigby Park | ||
2529 | 2529 | 2528 | {"type": "Polygon", "coordinates": [[[-119.75015, 36.71483], [-119.75014, 36.7177], [-119.74792, 36.71771], [-119.74793, 36.71426], [-119.74995, 36.71425], [-119.74995, 36.71482], [-119.75015, 36.71483]]]} | Open Access 1 | Calwa Park | 16743 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 18.485 | Calwa Park | ||
2645 | 2645 | 2644 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75844], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.7579], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.7313, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} | Open Access 1 | Carozza Park | 16891 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.026 | Carozza Park | ||
2668 | 2668 | 2667 | {"type": "Polygon", "coordinates": [[[-119.79845, 36.71057], [-119.79843, 36.71219], [-119.7971, 36.71219], [-119.79701, 36.71221], [-119.79693, 36.71228], [-119.79644, 36.71228], [-119.79644, 36.71058], [-119.79845, 36.71057]]]} | Open Access 1 | Carver Park | 16927 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.052 | Carver Park | ||
2669 | 2669 | 2668 | {"type": "Polygon", "coordinates": [[[-119.7813, 36.80352], [-119.7813, 36.80494], [-119.77923, 36.80494], [-119.77923, 36.80318], [-119.78046, 36.80319], [-119.78045, 36.80352], [-119.7813, 36.80352]]]} | Open Access 1 | Cary Park | 16928 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.2 | Cary Park | ||
2828 | 2828 | 2827 | {"type": "Polygon", "coordinates": [[[-119.83131, 36.73084], [-119.83104, 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 | 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 | 1.942 | Chandler Park | ||
3612 | 3612 | 3611 | {"type": "Polygon", "coordinates": [[[-119.79182, 36.7434], [-119.79182, 36.74417], [-119.7913, 36.74417], [-119.79128, 36.74413], [-119.79071, 36.74413], [-119.79072, 36.7434], [-119.79182, 36.7434]]]} | Open Access 1 | 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 | 2.025 | Dicky Playground | ||
3792 | 3792 | 3791 | {"type": "Polygon", "coordinates": [[[-119.75449, 36.7259], [-119.75449, 36.72681], [-119.75239, 36.72681], [-119.75238, 36.72591], [-119.75449, 36.7259]]]} | Open Access 1 | East Fresno Boys Club | 18368 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 4.671 | East Fresno Boys Club | ||
3821 | 3821 | 3820 | {"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 | 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 | 1.378 | Eaton Plaza | ||
3875 | 3875 | 3874 | {"type": "Polygon", "coordinates": [[[-119.76796, 36.7851], [-119.76795, 36.78577], [-119.76709, 36.78578], [-119.76707, 36.78673], [-119.76453, 36.78674], [-119.76455, 36.78559], [-119.76459, 36.78548], [-119.76458, 36.78543], [-119.76455, 36.78538], [-119.76467, 36.78503], [-119.76736, 36.78502], [-119.7674, 36.78511], [-119.7675, 36.78515], [-119.76759, 36.78515], [-119.76771, 36.7851], [-119.76796, 36.7851]]]} | Open Access 1 | Einstein Park | 18471 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 12.022 | Einstein Park | ||
3896 | 3896 | 3895 | {"type": "Polygon", "coordinates": [[[-119.76535, 36.81453], [-119.76535, 36.8157], [-119.76314, 36.81569], [-119.76317, 36.81453], [-119.76535, 36.81453]]]} | Open Access 1 | El Dorado Park | 18504 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.296 | El Dorado Park | ||
4090 | 4090 | 4089 | {"type": "Polygon", "coordinates": [[[-119.7883, 36.76862], [-119.78615, 36.76863], [-119.78615, 36.76692], [-119.78829, 36.76692], [-119.7883, 36.76862]]]} | Open Access 1 | Euless Park | 18749 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.95 | Euless 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]);