units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
92 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 14
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
- City Agency 92
MNG_AGENCY 1
- Fresno, City of · 92 ✖
ACCESS_TYP 1
- Open Access · 92 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75845], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.75791], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.73131, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} | Open Access 1 | 125 | Carozza Park | 16891 | 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 | 6.025 | Carozza Park | 0 | Local Park 2 | 4 | |
65 | 65 | 64 | {"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 | 189 | Carver Park | 16927 | 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 | 8.052 | Carver Park | 0 | Local Park 2 | 4 | |
88 | 88 | 87 | {"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 | 250 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.198 | Cary 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 | |
145 | 145 | 144 | {"type": "Polygon", "coordinates": [[[-119.86216, 36.76989], [-119.86214, 36.77167], [-119.86209, 36.77171], [-119.86059, 36.77173], [-119.86058, 36.77176], [-119.86044, 36.77177], [-119.85782, 36.77178], [-119.85781, 36.76991], [-119.86216, 36.76989]]]} | Open Access 1 | 365 | Victoria West Community Park | 27084 | 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 | 19.669 | Victoria West Community Park | 0 | Local Park 2 | 4 | |
174 | 174 | 173 | {"type": "Polygon", "coordinates": [[[-119.75401, 36.83145], [-119.75399, 36.83147], [-119.7525, 36.83155], [-119.75249, 36.83068], [-119.75238, 36.83067], [-119.75238, 36.83038], [-119.75399, 36.83038], [-119.754, 36.83039], [-119.75401, 36.83145]]]} | Open Access 1 | 473 | Rotary Park East | 24702 | 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 | 4.268 | Rotary Park East | 0 | Local Park 2 | 4 | |
178 | 178 | 177 | {"type": "Polygon", "coordinates": [[[-119.87918, 36.84588], [-119.87897, 36.84588], [-119.87868, 36.84562], [-119.87868, 36.84536], [-119.87885, 36.84521], [-119.87913, 36.84521], [-119.87916, 36.84522], [-119.87918, 36.84588]]]} | Open Access 1 | 47315 | Milburn Overlook Pocket Park | 31022 | 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 | 0.682 | Milburn Overlook PP | 0 | Local Park 2 | 4 | |
179 | 179 | 178 | {"type": "Polygon", "coordinates": [[[-119.81169, 36.72405], [-119.81168, 36.72428], [-119.81137, 36.72428], [-119.81169, 36.72405], [-119.81169, 36.72405]]]} | Open Access 1 | 47316 | Merced and Plumas Pocket Park | 31023 | 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 | 0.087 | Merced and Plumas PP | 0 | Local Park 2 | 4 | |
193 | 193 | 192 | {"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 | 535 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 12.015 | Einstein Park | 0 | Local Park 2 | 4 | |
198 | 198 | 197 | {"type": "MultiPolygon", "coordinates": [[[[-119.79639, 36.72267], [-119.796, 36.72295], [-119.79592, 36.72287], [-119.7963, 36.7226], [-119.79639, 36.72267]]], [[[-119.79685, 36.72239], [-119.79647, 36.72266], [-119.79635, 36.72256], [-119.79673, 36.72229], [-119.79685, 36.72239]]], [[[-119.79744, 36.72197], [-119.79706, 36.72225], [-119.79699, 36.72218], [-119.79699, 36.72216], [-119.79707, 36.72211], [-119.79736, 36.72197], [-119.79741, 36.72194], [-119.79744, 36.72197]]]]} | Open Access 1 | 47324 | California and Mayor Pocket Park | 31028 | 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 | 0.396 | California and Mayor 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 | |
211 | 211 | 210 | {"type": "Polygon", "coordinates": [[[-119.80854, 36.73507], [-119.80853, 36.73775], [-119.80829, 36.73838], [-119.80717, 36.73775], [-119.80712, 36.73767], [-119.8067, 36.73737], [-119.8063, 36.73715], [-119.80607, 36.73691], [-119.80606, 36.73684], [-119.80773, 36.73567], [-119.80854, 36.73507]]]} | Open Access 1 | 664 | Fink-White Park | 18902 | 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 | 10.68 | Fink-White Park | 0 | Local Park 2 | 4 | |
214 | 214 | 213 | {"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 | 584 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.297 | El Dorado Park | 0 | Local Park 2 | 4 | |
229 | 229 | 228 | {"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 | 622 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.952 | Euless Park | 0 | Local Park 2 | 4 | |
242 | 242 | 241 | {"type": "Polygon", "coordinates": [[[-119.80436, 36.7161], [-119.80433, 36.71604], [-119.80427, 36.71602], [-119.8021, 36.71603], [-119.8021, 36.71598], [-119.80207, 36.71592], [-119.80202, 36.71588], [-119.80194, 36.71586], [-119.8021, 36.71586], [-119.8021, 36.71486], [-119.80278, 36.71485], [-119.80278, 36.71423], [-119.80426, 36.71423], [-119.80426, 36.71586], [-119.80429, 36.71594], [-119.80436, 36.716], [-119.80436, 36.7161]]]} | Open Access 1 | 787 | Hinton Park | 20004 | 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 | 8.498 | Hinton 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 | |
370 | 370 | 369 | {"type": "Polygon", "coordinates": [[[-119.79519, 36.69593], [-119.79314, 36.69594], [-119.79314, 36.6942], [-119.79519, 36.69419], [-119.79519, 36.69593]]]} | Open Access 1 | 1072 | Ivy Park | 20287 | 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 | 8.734 | Ivy Park | 0 | Local Park 2 | 4 | |
397 | 397 | 396 | {"type": "Polygon", "coordinates": [[[-119.77928, 36.8429], [-119.77926, 36.84455], [-119.77813, 36.84457], [-119.77814, 36.84285], [-119.77928, 36.8429]]]} | Open Access 1 | 1179 | Kaiser Park | 20544 | 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 | 4.696 | Kaiser Park | 0 | Local Park 2 | 4 | |
417 | 417 | 416 | {"type": "Polygon", "coordinates": [[[-119.79275, 36.7758], [-119.79168, 36.77582], [-119.79168, 36.77414], [-119.79274, 36.77413], [-119.79275, 36.7758]]]} | Open Access 1 | 1290 | Lafayette Park | 20831 | 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 | 4.353 | Lafayette 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]);