units_with_maps

Table actions

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

1 row where ACRES = "1863.721" and MNG_AGENCY = 87

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • East Bay Regional Park District · 1 ✖

ACCESS_TYP 1

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
16292 16292 16291 {"type": "MultiPolygon", "coordinates": [[[[-121.67806, 37.79522], [-121.67803, 37.79746], [-121.67656, 37.7979], [-121.67616, 37.79857], [-121.67612, 37.79859], [-121.67597, 37.79878], [-121.6754, 37.7997], [-121.67492, 37.80009], [-121.67541, 37.80039], [-121.67538, 37.80065], [-121.67536, 37.80197], [-121.67532, 37.80224], [-121.67526, 37.80251], [-121.67517, 37.80278], [-121.67506, 37.80304], [-121.6748, 37.80351], [-121.67451, 37.80389], [-121.67258, 37.8059], [-121.67234, 37.80613], [-121.67208, 37.80635], [-121.6718, 37.80655], [-121.67145, 37.80676], [-121.67056, 37.80724], [-121.6694, 37.80781], [-121.66898, 37.80786], [-121.66769, 37.80896], [-121.66685, 37.80846], [-121.66602, 37.80903], [-121.66557, 37.80902], [-121.6654, 37.80925], [-121.66545, 37.81035], [-121.6652, 37.81067], [-121.66313, 37.8119], [-121.66159, 37.81407], [-121.66136, 37.81479], [-121.66138, 37.81545], [-121.6597, 37.81654], [-121.65071, 37.81652], [-121.65068, 37.8092], [-121.65067, 37.80919], [-121.64118, 37.80928], [-121.64132, 37.81849], [-121.64125, 37.81861], [-121.64123, 37.81872], [-121.64125, 37.82008], [-121.63212, 37.82017], [-121.63206, 37.81663], [-121.62298, 37.81671], [-121.62296, 37.81534], [-121.62287, 37.81524], [-121.62277, 37.80946], [-121.64117, 37.80928], [-121.64107, 37.80217], [-121.65063, 37.80208], [-121.65066, 37.79507], [-121.65956, 37.7951], [-121.65957, 37.79539], [-121.66106, 37.79539], [-121.67806, 37.79522]]], [[[-121.6549, 37.82518], [-121.65508, 37.82781], [-121.65506, 37.82809], [-121.65507, 37.82849], [-121.65505, 37.82891], [-121.65501, 37.82933], [-121.65491, 37.82988], [-121.65484, 37.83016], [-121.65435, 37.83148], [-121.65402, 37.83287], [-121.65386, 37.83332], [-121.65364, 37.83375], [-121.65339, 37.8341], [-121.65267, 37.8344], [-121.65286, 37.8347], [-121.65276, 37.83481], [-121.65226, 37.83516], [-121.65176, 37.83543], [-121.64933, 37.83643], [-121.649, 37.83659], [-121.64869, 37.83677], [-121.64825, 37.83706], [-121.64785, 37.83739], [-121.64749, 37.83775], [-121.6472, 37.83812], [-121.64171, 37.83818], [-121.6416, 37.83149], [-121.64187, 37.83108], [-121.64172, 37.8305], [-121.64159, 37.83019], [-121.64159, 37.82926], [-121.65076, 37.82923], [-121.65072, 37.82378], [-121.65482, 37.82378], [-121.65485, 37.82477], [-121.65487, 37.82489], [-121.65488, 37.82517], [-121.6549, 37.82518]]]]} No Public Access 3 29412 Byron Vernal Pools Regional Preserve 31517 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Contra Costa 12 1863.721 Byron Vernal Pools RPr 0 Local Conservation Area 4 2

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]);