superunits_with_maps

Table actions

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

1 row where LABEL_NAME = "Benicia SRA" and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
89 89 88 {"type": "Polygon", "coordinates": [[[-122.2051, 38.06835], [-122.20509, 38.06835], [-122.20506, 38.06798], [-122.20496, 38.06762], [-122.20478, 38.06728], [-122.20454, 38.06696], [-122.20423, 38.06669], [-122.20256, 38.06554], [-122.20241, 38.06545], [-122.20216, 38.06536], [-122.20222, 38.06523], [-122.20208, 38.06518], [-122.20198, 38.06533], [-122.20172, 38.06532], [-122.20103, 38.06536], [-122.20083, 38.06535], [-122.20063, 38.06532], [-122.20046, 38.06527], [-122.19975, 38.06496], [-122.19949, 38.06491], [-122.19931, 38.06491], [-122.19905, 38.06496], [-122.19881, 38.06507], [-122.19868, 38.06517], [-122.19837, 38.06549], [-122.19826, 38.0653], [-122.1971, 38.06557], [-122.19729, 38.06518], [-122.19637, 38.06487], [-122.19528, 38.06687], [-122.19535, 38.06692], [-122.19642, 38.07069], [-122.19953, 38.07633], [-122.19954, 38.07746], [-122.19953, 38.08275], [-122.1992, 38.08341], [-122.19785, 38.08291], [-122.19761, 38.08264], [-122.19624, 38.08225], [-122.19583, 38.08204], [-122.19532, 38.08174], [-122.19463, 38.08131], [-122.19407, 38.08094], [-122.19331, 38.08036], [-122.19279, 38.07989], [-122.19349, 38.07896], [-122.19365, 38.07881], [-122.19363, 38.07868], [-122.1936, 38.07863], [-122.19351, 38.07852], [-122.19339, 38.07842], [-122.1925, 38.07951], [-122.19245, 38.07959], [-122.19184, 38.07899], [-122.19146, 38.07857], [-122.19122, 38.07827], [-122.19187, 38.07756], [-122.19095, 38.07732], [-122.19073, 38.07723], [-122.19053, 38.07711], [-122.19035, 38.07698], [-122.19019, 38.07683], [-122.18975, 38.07638], [-122.18936, 38.0759], [-122.18926, 38.07587], [-122.1854, 38.07119], [-122.18489, 38.06964], [-122.18485, 38.06962], [-122.1847, 38.0698], [-122.18413, 38.06925], [-122.18359, 38.06866], [-122.18334, 38.06843], [-122.18313, 38.0678], [-122.18328, 38.06813], [-122.18341, 38.06837], [-122.18384, 38.0678], [-122.18561, 38.0686], [-122.1866, 38.06731], [-122.18914, 38.06871], [-122.18993, 38.0674], [-122.19034, 38.06692], [-122.19093, 38.06682], [-122.19117, 38.06644], [-122.19119, 38.06639], [-122.1918, 38.06559], [-122.19194, 38.06466], [-122.19236, 38.06408], [-122.19239, 38.06333], [-122.19228, 38.06204], [-122.19361, 38.06026], [-122.19408, 38.05999], [-122.19424, 38.05993], [-122.1944, 38.05996], [-122.19486, 38.06042], [-122.19502, 38.06052], [-122.19516, 38.06059], [-122.19551, 38.0607], [-122.19587, 38.06077], [-122.19609, 38.06067], [-122.19627, 38.06056], [-122.19657, 38.06057], [-122.19692, 38.06052], [-122.19723, 38.06058], [-122.19755, 38.06078], [-122.19789, 38.06093], [-122.19823, 38.06091], [-122.1984, 38.06079], [-122.19852, 38.06084], [-122.19895, 38.0609], [-122.19947, 38.06108], [-122.19975, 38.06107], [-122.19986, 38.0611], [-122.20001, 38.06125], [-122.20032, 38.06145], [-122.20055, 38.06153], [-122.20071, 38.0619], [-122.20079, 38.06191], [-122.20082, 38.06201], [-122.20099, 38.0622], [-122.20105, 38.06235], [-122.20116, 38.06247], [-122.20123, 38.06259], [-122.20113, 38.0628], [-122.20116, 38.063], [-122.2012, 38.0631], [-122.20118, 38.06333], [-122.20122, 38.06344], [-122.20118, 38.06395], [-122.20118, 38.06409], [-122.20116, 38.06421], [-122.20107, 38.06429], [-122.20108, 38.0644], [-122.20135, 38.06461], [-122.20164, 38.0646], [-122.20192, 38.0645], [-122.20212, 38.06427], [-122.20224, 38.06426], [-122.20239, 38.06432], [-122.20259, 38.06429], [-122.20282, 38.06419], [-122.20308, 38.0639], [-122.20319, 38.0639], [-122.20324, 38.06403], [-122.20328, 38.06484], [-122.20318, 38.06503], [-122.20328, 38.06524], [-122.20342, 38.06537], [-122.20372, 38.06547], [-122.20407, 38.06569], [-122.2041, 38.06609], [-122.20468, 38.06659], [-122.20487, 38.06665], [-122.20499, 38.06686], [-122.2051, 38.06699], [-122.2051, 38.06835]]]} Open Access 1 Benicia State Recreation Area http://www.parks.ca.gov/?page_id=476 1433 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 456.124 Benicia SRA 1957

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);