units_with_maps

Table actions

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

170 rows where COUNTY = 33

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS

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
439 439 438 {"type": "Polygon", "coordinates": [[[-121.7605, 38.56573], [-121.7605, 38.56632], [-121.75984, 38.56631], [-121.75985, 38.56573], [-121.7605, 38.56573]]]} Open Access 1 21013 Hacienda Park 19586 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 0.923 Hacienda Park 0 Local Park 2 4
2232 2232 2231 {"type": "Polygon", "coordinates": [[[-121.88455, 38.68187], [-121.88395, 38.68408], [-121.88098, 38.68409], [-121.88058, 38.68408], [-121.88163, 38.68168], [-121.88308, 38.68183], [-121.88416, 38.68178], [-121.88455, 38.68187]]]} Open Access 1 47879 Wild Wings Park 31823 380 Yolo County Parks, County of 497 County 3 County Agency - Parks 7 http://www.yolocounty.org/general-government/general-government-departments/parks County 3 380 Yolo County Parks, County of 488 County 3 County Agency - Parks 7 https://www.yolocounty.org/general-government/general-government-departments/parks/parks-information/wild-wings-park Yolo 33 17.528 Wild Wings Park 0 Local Park 2 4
2689 2689 2688 {"type": "Polygon", "coordinates": [[[-121.96932, 38.8863], [-121.9688, 38.88631], [-121.9688, 38.88594], [-121.96932, 38.88593], [-121.96932, 38.8863]]]} Open Access 1 28059 Dunnigan Park 33723 332 Yolo, County of 545 County 3 County Agency 3 http://www.yolocounty.org/general-government/general-government-departments/parks County 3 332 Yolo, County of 538 County 3 County Agency 3   Yolo 33 0.458 Dunnigan Park 0 Local Park 2 4
2717 2717 2716 {"type": "Polygon", "coordinates": [[[-121.74025, 38.67015], [-121.73904, 38.67037], [-121.739, 38.67027], [-121.73832, 38.6704], [-121.73826, 38.67032], [-121.73803, 38.67042], [-121.73754, 38.66974], [-121.73757, 38.66967], [-121.73915, 38.66898], [-121.73967, 38.6688], [-121.74022, 38.66866], [-121.7402, 38.66999], [-121.74025, 38.67015]]]} Open Access 1 21366 Klenhard Park 20689 332 Yolo, County of 545 County 3 County Agency 3 http://www.yolocounty.org/general-government/general-government-departments/parks County 3 332 Yolo, County of 538 County 3 County Agency 3   Yolo 33 7.227 Klenhard Park 0 Local Park 2 4
2718 2718 2717 {"type": "Polygon", "coordinates": [[[-121.76079, 38.67012], [-121.76077, 38.67026], [-121.7607, 38.67044], [-121.76062, 38.67057], [-121.76043, 38.67077], [-121.76033, 38.67095], [-121.76028, 38.6711], [-121.76026, 38.67128], [-121.76023, 38.67131], [-121.76019, 38.67132], [-121.75856, 38.6713], [-121.75858, 38.6701], [-121.76079, 38.67012]]]} Open Access 1 21367 Campbell Park 16780 1665 Woodland, City of 547 City 2 City Agency 2 http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp City 2 1665 Woodland, City of 540 City 2 City Agency 2   Yolo 33 5.571 Campbell Park 0 Local Park 2 4
2725 2725 2724 {"type": "Polygon", "coordinates": [[[-121.52266, 38.59411], [-121.52228, 38.59582], [-121.52195, 38.59572], [-121.52142, 38.59544], [-121.5217, 38.59399], [-121.52266, 38.59411]]]} Open Access 1 21400 Elkhorn Park 18567 332 Yolo, County of 545 County 3 County Agency 3 http://www.yolocounty.org/general-government/general-government-departments/parks County 3 332 Yolo, County of 538 County 3 County Agency 3   Yolo 33 3.687 Elkhorn Park 0 Local Park 2 4
2726 2726 2725 {"type": "Polygon", "coordinates": [[[-121.53106, 38.56227], [-121.53106, 38.56302], [-121.52788, 38.56301], [-121.52797, 38.56281], [-121.52856, 38.56226], [-121.53106, 38.56227]]]} Open Access 1 21402 Sam Combs Park 24816 332 Yolo, County of 545 County 3 County Agency 3 http://www.yolocounty.org/general-government/general-government-departments/parks County 3 332 Yolo, County of 538 County 3 County Agency 3   Yolo 33 5.206 Sam Combs Park 0 Local Park 2 4
2727 2727 2726 {"type": "Polygon", "coordinates": [[[-121.53607, 38.601], [-121.53422, 38.60158], [-121.53396, 38.60162], [-121.53214, 38.60182], [-121.53161, 38.60192], [-121.53136, 38.60112], [-121.53194, 38.60097], [-121.53138, 38.59947], [-121.53493, 38.59854], [-121.53607, 38.601]]]} Open Access 1 21403 Bryte Park 16462 332 Yolo, County of 545 County 3 County Agency 3 http://www.yolocounty.org/general-government/general-government-departments/parks County 3 332 Yolo, County of 538 County 3 County Agency 3   Yolo 33 25.371 Bryte Park 0 Local Park 2 4
2728 2728 2727 {"type": "Polygon", "coordinates": [[[-121.53256, 38.56557], [-121.53187, 38.56634], [-121.53047, 38.56554], [-121.53114, 38.56477], [-121.53256, 38.56557]]]} Open Access 1 21404 Memorial Park 22120 332 Yolo, County of 545 County 3 County Agency 3 http://www.yolocounty.org/general-government/general-government-departments/parks County 3 332 Yolo, County of 538 County 3 County Agency 3   Yolo 33 3.929 Memorial Park 0 Local Park 2 4
2729 2729 2728 {"type": "Polygon", "coordinates": [[[-121.54825, 38.55019], [-121.54819, 38.55025], [-121.54759, 38.5506], [-121.54689, 38.55063], [-121.54661, 38.55055], [-121.54669, 38.55035], [-121.54681, 38.55018], [-121.54684, 38.55006], [-121.54689, 38.55001], [-121.54724, 38.55016], [-121.54736, 38.55], [-121.54751, 38.54987], [-121.54825, 38.55019]]]} Open Access 1 21406 Touchstone Park 26478 1376 West Sacramento, City of 548 City 2 City Agency 2 http://www.cityofwestsacramento.org/city/depts/pcs/default.asp City 2 1376 West Sacramento, City of 541 City 2 City Agency 2   Yolo 33 1.781 Touchstone Park 0 Local Park 2 4
3053 3053 3052 {"type": "Polygon", "coordinates": [[[-121.6994, 38.55535], [-121.69905, 38.55552], [-121.69885, 38.55568], [-121.69872, 38.55587], [-121.69905, 38.55598], [-121.699, 38.55612], [-121.69899, 38.55625], [-121.69911, 38.55765], [-121.69911, 38.5578], [-121.69908, 38.55781], [-121.69908, 38.55786], [-121.69905, 38.55789], [-121.69867, 38.55794], [-121.69827, 38.55803], [-121.69796, 38.55813], [-121.69769, 38.55824], [-121.69773, 38.55537], [-121.6994, 38.55535]]]} Open Access 1 20964 John Barovetto Park 20429 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 8.389 John Barovetto Park 0 Local Park 2 4
3054 3054 3053 {"type": "Polygon", "coordinates": [[[-121.69518, 38.5114], [-121.69508, 38.51983], [-121.68851, 38.52006], [-121.68757, 38.51999], [-121.68564, 38.51973], [-121.6857, 38.51651], [-121.68589, 38.51119], [-121.68639, 38.51123], [-121.68693, 38.51131], [-121.68724, 38.5115], [-121.68756, 38.51155], [-121.68808, 38.51159], [-121.68842, 38.51159], [-121.68891, 38.51151], [-121.68969, 38.51144], [-121.69076, 38.51144], [-121.6912, 38.51148], [-121.69175, 38.51148], [-121.69368, 38.51133], [-121.69441, 38.51133], [-121.69518, 38.5114]]]} Open Access 1 20980 South Fork Preserve 25651 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 191.285 South Fork Preserve 0 Local Conservation Area 4 2
3055 3055 3054 {"type": "Polygon", "coordinates": [[[-121.78648, 38.54919], [-121.78648, 38.55007], [-121.78525, 38.55004], [-121.78525, 38.54902], [-121.78605, 38.54902], [-121.78606, 38.54919], [-121.78648, 38.54919]]]} Open Access 1 20984 West Manor Park 27367 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 2.883 West Manor Park 0 Local Park 2 4
3056 3056 3055 {"type": "Polygon", "coordinates": [[[-121.52707, 38.54137], [-121.52696, 38.54158], [-121.52637, 38.5414], [-121.52649, 38.54118], [-121.52707, 38.54137]]]} Open Access 1 21010 Redwood Park 24250 1376 West Sacramento, City of 548 City 2 City Agency 2 http://www.cityofwestsacramento.org/city/depts/pcs/default.asp City 2 1376 West Sacramento, City of 541 City 2 City Agency 2   Yolo 33 0.36 Redwood Park 0 Local Park 2 4
3087 3087 3086 {"type": "Polygon", "coordinates": [[[-121.51926, 38.55343], [-121.51925, 38.55354], [-121.51922, 38.55357], [-121.51916, 38.5536], [-121.51764, 38.55377], [-121.51755, 38.55331], [-121.51742, 38.55303], [-121.51718, 38.55299], [-121.51696, 38.55306], [-121.51678, 38.55297], [-121.51656, 38.55293], [-121.51656, 38.55287], [-121.51658, 38.55283], [-121.51662, 38.55281], [-121.51676, 38.55279], [-121.51762, 38.55272], [-121.51785, 38.55274], [-121.51811, 38.55283], [-121.51831, 38.55297], [-121.51844, 38.55298], [-121.51846, 38.55303], [-121.51907, 38.55338], [-121.51914, 38.55336], [-121.51918, 38.5534], [-121.51926, 38.55343]]]} Open Access 1 21351 Delta Gardens Park 18070 1376 West Sacramento, City of 548 City 2 City Agency 2 http://www.cityofwestsacramento.org/city/depts/pcs/default.asp City 2 1376 West Sacramento, City of 541 City 2 City Agency 2   Yolo 33 3.26 Delta Gardens Park 0 Local Park 2 4
3088 3088 3087 {"type": "Polygon", "coordinates": [[[-121.57434, 38.53766], [-121.57434, 38.53813], [-121.57433, 38.53836], [-121.57427, 38.53868], [-121.57424, 38.53872], [-121.57419, 38.53874], [-121.57392, 38.53869], [-121.57353, 38.53859], [-121.57221, 38.53812], [-121.57216, 38.53806], [-121.57217, 38.53802], [-121.57229, 38.53773], [-121.57235, 38.53749], [-121.57326, 38.53766], [-121.57434, 38.53766]]]} Open Access 1 21352 Sunset Vista Park 26070 1376 West Sacramento, City of 548 City 2 City Agency 2 http://www.cityofwestsacramento.org/city/depts/pcs/default.asp City 2 1376 West Sacramento, City of 541 City 2 City Agency 2   Yolo 33 4.314 Sunset Vista Park 0 Local Park 2 4
3089 3089 3088 {"type": "MultiPolygon", "coordinates": [[[[-121.52195, 38.59572], [-121.52096, 38.59539], [-121.52097, 38.59391], [-121.5217, 38.59399], [-121.52142, 38.59544], [-121.52195, 38.59572]]], [[[-121.52271, 38.59411], [-121.52266, 38.5944], [-121.52237, 38.59585], [-121.52228, 38.59582], [-121.52266, 38.59411], [-121.52271, 38.59411]]]]} Open Access 1 21353 Elkhorn Park 18568 1376 West Sacramento, City of 548 City 2 City Agency 2 http://www.cityofwestsacramento.org/city/depts/pcs/default.asp City 2 1376 West Sacramento, City of 541 City 2 City Agency 2   Yolo 33 2.513 Elkhorn Park 0 Local Park 2 4
3090 3090 3089 {"type": "MultiPolygon", "coordinates": [[[[-121.77039, 38.68764], [-121.77038, 38.68822], [-121.77033, 38.68825], [-121.76935, 38.68824], [-121.76936, 38.68781], [-121.7694, 38.68763], [-121.77039, 38.68764]]], [[[-121.77039, 38.68738], [-121.77039, 38.68759], [-121.76942, 38.68758], [-121.76951, 38.6874], [-121.76953, 38.68729], [-121.76958, 38.68725], [-121.76963, 38.68725], [-121.77008, 38.68735], [-121.77039, 38.68738]]]]} Open Access 1 21362 Beamer Park 15917 1665 Woodland, City of 547 City 2 City Agency 2 http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp City 2 1665 Woodland, City of 540 City 2 City Agency 2   Yolo 33 2.064 Beamer Park 0 Local Park 2 4
3091 3091 3090 {"type": "Polygon", "coordinates": [[[-121.79776, 38.68261], [-121.79775, 38.68351], [-121.79513, 38.68348], [-121.79518, 38.68346], [-121.7952, 38.68342], [-121.79521, 38.68268], [-121.7952, 38.68264], [-121.79515, 38.6826], [-121.79514, 38.68257], [-121.79776, 38.68261]]]} Open Access 1 21363 Harris Park 19696 1665 Woodland, City of 547 City 2 City Agency 2 http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp City 2 1665 Woodland, City of 540 City 2 City Agency 2   Yolo 33 5.534 Harris Park 0 Local Park 2 4
3096 3096 3095 {"type": "Polygon", "coordinates": [[[-121.56121, 38.57756], [-121.56111, 38.57779], [-121.5607, 38.57841], [-121.56048, 38.57842], [-121.56046, 38.57809], [-121.56053, 38.57808], [-121.56053, 38.57804], [-121.56064, 38.57802], [-121.56048, 38.57635], [-121.56031, 38.57635], [-121.56033, 38.57592], [-121.56056, 38.57604], [-121.5608, 38.57622], [-121.56097, 38.57641], [-121.56111, 38.57662], [-121.56121, 38.57684], [-121.56126, 38.5771], [-121.56126, 38.57734], [-121.56121, 38.57756]]]} Open Access 1 21389 Meadowdale Park 22083 1376 West Sacramento, City of 548 City 2 City Agency 2 http://www.cityofwestsacramento.org/city/depts/pcs/default.asp City 2 1376 West Sacramento, City of 541 City 2 City Agency 2   Yolo 33 3.049 Meadowdale 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]);