units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 14 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 67
- Local Recreation Area 7
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 75
MNG_AGENCY 1
- Fresno, City of · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11830 | 11830 | 11829 | {"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 | 24155 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 4.671 | East Fresno Boys Club | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
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 | |
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 | |
14318 | 14318 | 14317 | {"type": "Polygon", "coordinates": [[[-119.86925, 36.82653], [-119.86811, 36.82814], [-119.86772, 36.82791], [-119.86704, 36.82791], [-119.86704, 36.82627], [-119.86717, 36.82627], [-119.86782, 36.82561], [-119.86925, 36.82653]]]} | Open Access 1 | 44283 | Figarden Loop Park | 18895 | 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.603 | Figarden Loop Park | 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 | |
14434 | 14434 | 14433 | {"type": "Polygon", "coordinates": [[[-119.76952, 36.82039], [-119.76941, 36.82058], [-119.76874, 36.82111], [-119.76873, 36.82129], [-119.76932, 36.82178], [-119.76823, 36.82264], [-119.76813, 36.82282], [-119.76773, 36.82282], [-119.76774, 36.8215], [-119.76936, 36.82023], [-119.76952, 36.82039]]]} | Open Access 1 | 47091 | First & Bullard Park | 30752 | 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 | 5.08 | First & Bullard Park | 0 | Local Park 2 | 4 | |
14975 | 14975 | 14974 | {"type": "Polygon", "coordinates": [[[-119.77345, 36.74584], [-119.77272, 36.74583], [-119.7727, 36.74581], [-119.77269, 36.74549], [-119.77345, 36.74549], [-119.77345, 36.74584]]]} | Open Access 1 | 45614 | First and Nevada Pocket Park | 28443 | 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.629 | First and Nevada PP | 0 | Local Park 2 | 4 | |
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 | |
6374 | 6374 | 6373 | {"type": "Polygon", "coordinates": [[[-119.77927, 36.84098], [-119.77927, 36.84288], [-119.77707, 36.84288], [-119.77708, 36.84133], [-119.77769, 36.84134], [-119.77794, 36.84127], [-119.77843, 36.84127], [-119.77869, 36.84135], [-119.77899, 36.84134], [-119.77918, 36.84111], [-119.77919, 36.84097], [-119.77927, 36.84098]]]} | Restricted Access 2 | 1738 | Harry Goorabian Park | 31253 | 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.566 | Harry Goorabian 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 | |
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 | |
466 | 466 | 465 | {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} | Open Access 1 | 922 | Holmes Playground | 20056 | 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.725 | Holmes Playground | 0 | Local Recreation Area 3 | 4 | |
5513 | 5513 | 5512 | {"type": "Polygon", "coordinates": [[[-119.82618, 36.83182], [-119.82618, 36.8326], [-119.82604, 36.8327], [-119.82405, 36.83271], [-119.82405, 36.83183], [-119.82618, 36.83182]]]} | Open Access 1 | 973 | Howard B Holman Park | 20115 | 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.571 | Howard B Holman Park | 0 | Local Park 2 | 4 | |
6099 | 6099 | 6098 | {"type": "Polygon", "coordinates": [[[-119.81773, 36.71687], [-119.81772, 36.7176], [-119.81768, 36.71761], [-119.81768, 36.71769], [-119.81736, 36.71769], [-119.81732, 36.71765], [-119.81725, 36.71761], [-119.81224, 36.71764], [-119.81224, 36.71684], [-119.81244, 36.71655], [-119.81261, 36.71635], [-119.81283, 36.71618], [-119.81322, 36.716], [-119.81336, 36.71596], [-119.81337, 36.71604], [-119.81393, 36.71588], [-119.81415, 36.71584], [-119.81448, 36.71582], [-119.81487, 36.71582], [-119.81506, 36.71586], [-119.81559, 36.71585], [-119.8156, 36.71604], [-119.81773, 36.71687]]]} | Open Access 1 | 1019 | Hyde Park | 20165 | 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.493 | Hyde Park | 0 | Local Park 2 | 4 | |
3892 | 3892 | 3891 | {"type": "Polygon", "coordinates": [[[-119.89564, 36.80259], [-119.8936, 36.8026], [-119.89359, 36.80089], [-119.89393, 36.80088], [-119.89394, 36.80093], [-119.89471, 36.8009], [-119.89537, 36.80089], [-119.8954, 36.80092], [-119.89541, 36.80141], [-119.89563, 36.80212], [-119.89564, 36.80259]]]} | Open Access 1 | 46815 | Inspiration Park | 32570 | 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 | 7.973 | Inspiration Park | 2015 | 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 | |
3952 | 3952 | 3951 | {"type": "Polygon", "coordinates": [[[-119.83147, 36.70554], [-119.83023, 36.70554], [-119.83022, 36.70578], [-119.82573, 36.70578], [-119.8257, 36.69951], [-119.82599, 36.69934], [-119.82601, 36.69581], [-119.82675, 36.6958], [-119.82675, 36.69228], [-119.82703, 36.69232], [-119.82914, 36.69231], [-119.82914, 36.69402], [-119.83132, 36.69402], [-119.83133, 36.70305], [-119.83147, 36.70306], [-119.83147, 36.70554]]]} | Open Access 1 | 1125 | Jensen-West Regional Park | 20394 | 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 | 164.801 | Jensen-West RP | 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]);