units_with_maps

Table actions

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

109 rows where COUNTY = 29 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_NAME, AGNCY_WEB

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 109 ✖
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
308 308 307 {"type": "Polygon", "coordinates": [[[-119.38657, 36.53614], [-119.38603, 36.53654], [-119.38602, 36.53567], [-119.38657, 36.53614], [-119.38657, 36.53614]]]} Open Access 1 1054 Gegory Park 19248 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 0.573 Gegory Park 0 Local Park 2 4
313 313 312 {"type": "Polygon", "coordinates": [[[-119.13591, 36.29543], [-119.13588, 36.29709], [-119.13271, 36.29702], [-119.1327, 36.29541], [-119.13591, 36.29543]]]} Open Access 1 1084 Exeter City Athletic Park 18774 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 12.899 Exeter City Athletic Park 0 Local Recreation Area 3 4
321 321 320 {"type": "Polygon", "coordinates": [[[-119.13639, 36.29924], [-119.13605, 36.29935], [-119.13609, 36.29885], [-119.13612, 36.2988], [-119.13639, 36.29924]]]} Open Access 1 1102 Rose Garden Park 24609 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 0.24 Rose Garden Park 0 Local Park 2 4
338 338 337 {"type": "Polygon", "coordinates": [[[-119.09585, 36.20318], [-119.09406, 36.19994], [-119.09406, 36.19994], [-119.09568, 36.19993], [-119.09574, 36.20151], [-119.09585, 36.20318]]]} Open Access 1 1164 Olive Bowl Park 23120 1176 Lindsay, City of 137 City 2 City Agency 2 http://www.lindsay.ca.us/citygov/works/parks.cfm City 2 1176 Lindsay, City of 134 City 2 City Agency 2   Tulare 29 6.405 Olive Bowl Park 0 Local Park 2 4
343 343 342 {"type": "Polygon", "coordinates": [[[-119.06923, 36.07235], [-119.06918, 36.07236], [-119.06918, 36.07248], [-119.06778, 36.07246], [-119.06781, 36.07093], [-119.06922, 36.07094], [-119.06923, 36.07235]]]} Open Access 1 1167 Burton Ballfields 16529 1260 Porterville, City of 139 City 2 City Agency 2 http://www.ci.porterville.ca.us/ City 2 1260 Porterville, City of 136 City 2 City Agency 2   Tulare 29 5.41 Burton Ballfields   None 34  
371 371 370 {"type": "Polygon", "coordinates": [[[-119.131, 36.29982], [-119.13097, 36.30053], [-119.1279, 36.30049], [-119.12801, 36.2971], [-119.13018, 36.29713], [-119.13005, 36.29768], [-119.13003, 36.29832], [-119.13033, 36.29892], [-119.13082, 36.29961], [-119.131, 36.29982]]]} Open Access 1 1081 Dobson Field 18175 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 20.718 Dobson Field 0 Local Recreation Area 3 4
375 375 374 {"type": "Polygon", "coordinates": [[[-119.14513, 36.29259], [-119.14488, 36.29215], [-119.14512, 36.29206], [-119.14512, 36.29206], [-119.14513, 36.29259]]]} Open Access 1 1107 Schelling Park 25182 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 0.159 Schelling Park 0 Local Park 2 4
378 378 377 {"type": "Polygon", "coordinates": [[[-119.20947, 36.30166], [-119.20848, 36.30166], [-119.20849, 36.30084], [-119.20946, 36.30084], [-119.20947, 36.30166]]]} Open Access 1 1136 Jennings Park 20389 1106 Farmersville, City of 155 City 2 City Agency 2   City 2 1106 Farmersville, City of 151 City 2 City Agency 2   Tulare 29 1.978 Jennings Park 0 Local Park 2 4
379 379 378 {"type": "Polygon", "coordinates": [[[-119.30973, 36.31657], [-119.30811, 36.31656], [-119.30811, 36.31599], [-119.30871, 36.31599], [-119.30871, 36.31591], [-119.30973, 36.31592], [-119.30973, 36.31657]]]} Open Access 1 1397 Rotary Park 24697 1368 Visalia, City of 156 City 2 City Agency 2 http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp City 2 1368 Visalia, City of 152 City 2 City Agency 2   Tulare 29 2.505 Rotary Park 0 Local Park 2 4
381 381 380 {"type": "Polygon", "coordinates": [[[-119.21304, 36.31701], [-119.213, 36.31821], [-119.20857, 36.31818], [-119.20859, 36.31659], [-119.20864, 36.31665], [-119.20877, 36.31669], [-119.20887, 36.31664], [-119.21059, 36.31665], [-119.21139, 36.31671], [-119.21209, 36.31679], [-119.21304, 36.31701]]]} Open Access 1 1141 Liberty Park 21210 1106 Farmersville, City of 155 City 2 City Agency 2   City 2 1106 Farmersville, City of 151 City 2 City Agency 2   Tulare 29 16.086 Liberty Park 0 Local Park 2 4
384 384 383 {"type": "Polygon", "coordinates": [[[-119.20715, 36.29112], [-119.20714, 36.29174], [-119.20533, 36.29176], [-119.20533, 36.29057], [-119.20679, 36.29058], [-119.20679, 36.29112], [-119.20715, 36.29112]]]} Open Access 1 1151 Roy Park 24712 1106 Farmersville, City of 155 City 2 City Agency 2   City 2 1106 Farmersville, City of 151 City 2 City Agency 2   Tulare 29 4.789 Roy Park 0 Local Park 2 4
388 388 387 {"type": "Polygon", "coordinates": [[[-119.08251, 36.21234], [-119.07974, 36.21234], [-119.07971, 36.21076], [-119.08249, 36.21075], [-119.08251, 36.21234]]]} Open Access 1 1155 Harvard Park 19717 1176 Lindsay, City of 137 City 2 City Agency 2 http://www.lindsay.ca.us/citygov/works/parks.cfm City 2 1176 Lindsay, City of 134 City 2 City Agency 2   Tulare 29 10.877 Harvard Park 0 Local Park 2 4
398 398 397 {"type": "Polygon", "coordinates": [[[-119.01425, 36.0474], [-119.01298, 36.04739], [-119.01299, 36.04636], [-119.01422, 36.04637], [-119.01425, 36.0474]]]} Open Access 1 1198 Pioneer Ballfields 23710 1260 Porterville, City of 139 City 2 City Agency 2 http://www.ci.porterville.ca.us/ City 2 1260 Porterville, City of 136 City 2 City Agency 2   Tulare 29 3.165 Pioneer Ballfields   None 41  
405 405 404 {"type": "Polygon", "coordinates": [[[-119.34539, 36.23661], [-119.3433, 36.23661], [-119.34258, 36.23569], [-119.34356, 36.2354], [-119.34401, 36.23528], [-119.3445, 36.23512], [-119.34479, 36.23504], [-119.34501, 36.23538], [-119.34514, 36.23564], [-119.34523, 36.23588], [-119.34531, 36.23614], [-119.34539, 36.23661]]]} Open Access 1 1245 Blain Park 16148 1398 Tulare, City of 163 City 2 City Agency 2 http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm City 2 1398 Tulare, City of 159 City 2 City Agency 2   Tulare 29 7.423 Blain Park 0 Local Park 2 4
407 407 406 {"type": "Polygon", "coordinates": [[[-119.35321, 36.21913], [-119.3532, 36.22023], [-119.35146, 36.22027], [-119.351, 36.21817], [-119.35206, 36.21818], [-119.35301, 36.21816], [-119.3532, 36.21824], [-119.35321, 36.21913]]]} Open Access 1 1252 Centennial Park 17030 1398 Tulare, City of 163 City 2 City Agency 2 http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm City 2 1398 Tulare, City of 159 City 2 City Agency 2   Tulare 29 10.109 Centennial Park 0 Local Park 2 4
419 419 418 {"type": "Polygon", "coordinates": [[[-119.35505, 36.20879], [-119.35454, 36.20886], [-119.35447, 36.20859], [-119.35391, 36.20865], [-119.35361, 36.2071], [-119.35416, 36.20701], [-119.35428, 36.20746], [-119.35473, 36.2074], [-119.35505, 36.20879]]]} Open Access 1 1293 Tyler Park 26629 1398 Tulare, City of 163 City 2 City Agency 2 http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm City 2 1398 Tulare, City of 159 City 2 City Agency 2   Tulare 29 3.989 Tyler Park 0 Local Park 2 4
421 421 420 {"type": "Polygon", "coordinates": [[[-119.34342, 36.20836], [-119.34235, 36.20852], [-119.34211, 36.20743], [-119.34318, 36.20728], [-119.34342, 36.20836]]]} Open Access 1 1297 Zumwalt Park 27871 1398 Tulare, City of 163 City 2 City Agency 2 http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm City 2 1398 Tulare, City of 159 City 2 City Agency 2   Tulare 29 2.969 Zumwalt Park 0 Local Park 2 4
424 424 423 {"type": "Polygon", "coordinates": [[[-119.29357, 36.30286], [-119.29341, 36.30336], [-119.29286, 36.30364], [-119.29231, 36.30375], [-119.29185, 36.30434], [-119.29179, 36.30191], [-119.29322, 36.30197], [-119.29357, 36.30286]]]} Open Access 1 1307 Blain Park 16147 1368 Visalia, City of 156 City 2 City Agency 2 http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp City 2 1368 Visalia, City of 152 City 2 City Agency 2   Tulare 29 7.099 Blain Park 0 Local Park 2 4
437 437 436 {"type": "Polygon", "coordinates": [[[-119.26048, 36.3315], [-119.26048, 36.33249], [-119.26047, 36.33253], [-119.26043, 36.33256], [-119.25979, 36.33265], [-119.25935, 36.33274], [-119.25908, 36.33282], [-119.25872, 36.33298], [-119.258, 36.33343], [-119.25742, 36.33278], [-119.25769, 36.33246], [-119.25781, 36.33241], [-119.25819, 36.3323], [-119.25849, 36.3323], [-119.25857, 36.33227], [-119.25898, 36.33176], [-119.2591, 36.33169], [-119.25933, 36.33166], [-119.26009, 36.3316], [-119.26034, 36.33152], [-119.26048, 36.3315]]]} Open Access 1 1373 Mill Creek Park 22226 1368 Visalia, City of 156 City 2 City Agency 2 http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp City 2 1368 Visalia, City of 152 City 2 City Agency 2   Tulare 29 7.02 Mill Creek Park 0 Local Park 2 4
440 440 439 {"type": "Polygon", "coordinates": [[[-119.26949, 36.32014], [-119.26948, 36.32187], [-119.2684, 36.32186], [-119.26942, 36.32014], [-119.26949, 36.32014]]]} Open Access 1 1377 Pinkham Park 23697 1368 Visalia, City of 156 City 2 City Agency 2 http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp City 2 1368 Visalia, City of 152 City 2 City Agency 2   Tulare 29 2.438 Pinkham 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]);