units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

95 rows where MNG_AGENCY = 14

View and edit SQL

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST

MNG_AG_TYP

MNG_AGENCY

  • Fresno, City of · 95
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 72.184ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette