units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where DES_TP = 2 and MNG_AGENCY = 14 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 83
MNG_AGENCY 1
- Fresno, City of · 83 ✖
DES_TP 1
- Local Park · 83 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5027 | 5027 | 5026 | {"type": "Polygon", "coordinates": [[[-119.80571, 36.72831], [-119.8057, 36.72842], [-119.80555, 36.72842], [-119.80571, 36.72831], [-119.80571, 36.72831]]]} | Open Access 1 | 47319 | Merced and Pickford Pocket Park | 31025 | 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.022 | Merced and Pickford PP | 0 | Local Park 2 | 4 | |
5944 | 5944 | 5943 | {"type": "Polygon", "coordinates": [[[-119.74575, 36.73906], [-119.74575, 36.73914], [-119.74558, 36.73914], [-119.74558, 36.73906], [-119.74575, 36.73906]]]} | Open Access 1 | 47318 | Maple and Blach Pocket Park | 31024 | 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.032 | Maple and Blach PP | 0 | Local Park 2 | 4 | |
8164 | 8164 | 8163 | {"type": "Polygon", "coordinates": [[[-119.8072, 36.72725], [-119.80719, 36.72742], [-119.80696, 36.72742], [-119.8072, 36.72725], [-119.8072, 36.72725]]]} | Open Access 1 | 47302 | Merced & Stevens Pocket Park | 31009 | 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.047 | Merced & Stevens PP | 0 | Local Park 2 | 4 | |
5806 | 5806 | 5805 | {"type": "Polygon", "coordinates": [[[-119.80869, 36.72619], [-119.80868, 36.72637], [-119.80843, 36.72637], [-119.80869, 36.72619], [-119.80869, 36.72619]]]} | Open Access 1 | 47301 | Merced & Trinity Pocket Park | 31008 | 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.056 | Merced & Trinity PP | 0 | Local Park 2 | 4 | |
4115 | 4115 | 4114 | {"type": "Polygon", "coordinates": [[[-119.8102, 36.72512], [-119.81019, 36.72533], [-119.8099, 36.72533], [-119.8102, 36.72512], [-119.8102, 36.72512]]]} | Open Access 1 | 47320 | Merced and Modoc Pocket Park | 31026 | 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.075 | Merced and Modoc 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 | |
8192 | 8192 | 8191 | {"type": "Polygon", "coordinates": [[[-119.8023, 36.74348], [-119.80198, 36.74349], [-119.80205, 36.74325], [-119.80206, 36.74326], [-119.8023, 36.74348]]]} | Open Access 1 | 47321 | Broadway Pocket Park | 31027 | 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.09 | Broadway PP | 0 | Local Park 2 | 4 | |
16569 | 16569 | 16568 | {"type": "Polygon", "coordinates": [[[-119.74569, 36.76678], [-119.74568, 36.76709], [-119.74555, 36.76709], [-119.74555, 36.76678], [-119.74569, 36.76678]]]} | Open Access 1 | 45615 | North Maple Pocket Park | 28444 | 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.102 | North Maple PP | 0 | Local Park 2 | 4 | |
4351 | 4351 | 4350 | {"type": "Polygon", "coordinates": [[[-119.75892, 36.7433], [-119.75892, 36.74334], [-119.75857, 36.74341], [-119.75823, 36.74349], [-119.75823, 36.7433], [-119.75892, 36.7433]]]} | Open Access 1 | 45675 | Ninth and Tulare Pocket Park | 28489 | 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.182 | Ninth and Tulare PP | 0 | Local Park 2 | 4 | |
3609 | 3609 | 3608 | {"type": "Polygon", "coordinates": [[[-119.70709, 36.71049], [-119.70709, 36.71064], [-119.70641, 36.71063], [-119.70641, 36.71049], [-119.70643, 36.71047], [-119.70707, 36.71047], [-119.70709, 36.71049]]]} | Open Access 1 | 47306 | Rabe Pocket Park | 31013 | 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.268 | Rabe PP | 0 | Local Park 2 | 4 | |
8191 | 8191 | 8190 | {"type": "Polygon", "coordinates": [[[-119.88755, 36.85026], [-119.88755, 36.85071], [-119.88721, 36.85064], [-119.88722, 36.85027], [-119.88732, 36.85026], [-119.88736, 36.85022], [-119.88738, 36.85017], [-119.88739, 36.85025], [-119.88755, 36.85026]]]} | Open Access 1 | 47304 | Polk Overlook Pocket Park | 31011 | 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.349 | Polk Overlook PP | 0 | Local Park 2 | 4 | |
3614 | 3614 | 3613 | {"type": "Polygon", "coordinates": [[[-119.69873, 36.71265], [-119.69869, 36.71268], [-119.69834, 36.7127], [-119.69828, 36.71268], [-119.6982, 36.71257], [-119.6981, 36.71246], [-119.69839, 36.71238], [-119.69873, 36.71238], [-119.69873, 36.71265]]]} | Open Access 1 | 47311 | Centex Pocket Park | 31018 | 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.393 | Centex PP | 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 | |
3574 | 3574 | 3573 | {"type": "Polygon", "coordinates": [[[-119.81233, 36.72147], [-119.81183, 36.72183], [-119.81139, 36.72146], [-119.81147, 36.72147], [-119.81233, 36.72147]]]} | Open Access 1 | 47305 | Pride Pocket Park | 31012 | 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.403 | Pride PP | 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 | |
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 | |
13117 | 13117 | 13116 | {"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 | 45037 | Cultural Arts District Park | 27989 | 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.downtownfresno.org/go/cultural-arts-district | Fresno 9 | 0.782 | Cultural Arts District Park | 0 | Local Park 2 | 4 |
5758 | 5758 | 5757 | {"type": "Polygon", "coordinates": [[[-119.85482, 36.82922], [-119.85479, 36.82931], [-119.85447, 36.82937], [-119.85418, 36.8294], [-119.85409, 36.82933], [-119.85409, 36.82866], [-119.85415, 36.82861], [-119.8542, 36.82861], [-119.85428, 36.82864], [-119.85453, 36.82893], [-119.85482, 36.82922]]]} | Open Access 1 | 47300 | Safety Pocket Park | 31007 | 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.894 | Safety PP | 0 | Local Park 2 | 4 | |
5973 | 5973 | 5972 | {"type": "Polygon", "coordinates": [[[-119.79755, 36.72125], [-119.79751, 36.72155], [-119.79706, 36.72174], [-119.79668, 36.72196], [-119.79665, 36.72195], [-119.79658, 36.72188], [-119.79655, 36.7218], [-119.79655, 36.72146], [-119.79697, 36.72146], [-119.79702, 36.72143], [-119.79706, 36.72138], [-119.79706, 36.72125], [-119.79755, 36.72125]]]} | Open Access 1 | 47326 | Tupman Pocket Park | 31033 | 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.96 | Tupman PP | 0 | Local Park 2 | 4 | |
530 | 530 | 529 | {"type": "Polygon", "coordinates": [[[-119.80634, 36.85317], [-119.80522, 36.8539], [-119.80515, 36.85384], [-119.80519, 36.85369], [-119.8057, 36.85332], [-119.80577, 36.85314], [-119.80578, 36.85299], [-119.80575, 36.85279], [-119.80586, 36.8528], [-119.80601, 36.85278], [-119.80606, 36.85298], [-119.80629, 36.85309], [-119.80634, 36.85317]]]} | Open Access 1 | 1748 | Spano Park | 25714 | 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.962 | Spano 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]);