units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
90 rows where AGNCY_LEV = 2 and MNG_AGENCY = 14 sorted by UNIT_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15707 | 15707 | 15706 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | 25456 | Airways Municipal Golf Course | 33086 | 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 | 88.161 | Airways Municipal GC | 0 | Local Recreation Area 3 | 4 | |
11832 | 11832 | 11831 | {"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 | 24157 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 14.34 | Al Radka 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 | |
3613 | 3613 | 3612 | {"type": "Polygon", "coordinates": [[[-119.74954, 36.87775], [-119.74952, 36.87906], [-119.74763, 36.87907], [-119.74752, 36.87875], [-119.7474, 36.87848], [-119.74723, 36.87819], [-119.74707, 36.87796], [-119.7471, 36.87785], [-119.74718, 36.87783], [-119.74738, 36.87779], [-119.74766, 36.87779], [-119.74779, 36.87776], [-119.74954, 36.87775]]]} | Open Access 1 | 47310 | Beamer Neighborhood Park | 31017 | 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.928 | Beamer Neighborhood Park | 0 | Local Park 2 | 4 | |
10630 | 10630 | 10629 | {"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 | 18981 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 5.493 | Belcher Park | 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 | |
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 | |
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 | |
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 | |
1393 | 1393 | 1392 | {"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.71483], [-119.75015, 36.71483]]]} | Open Access 1 | 12202 | 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 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 18.484 | Calwa 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 | |
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 | |
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 | |
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 |
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 | |
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 |
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]);