units_with_maps

Table actions

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

1 row where DES_TP = 8, MNG_AG_TYP = 5 and SUID_NMA = 30524

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

DES_TP 1

  • State Conservation Area · 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
12169 12169 12168 {"type": "MultiPolygon", "coordinates": [[[[-119.41373, 38.41613], [-119.39436, 38.41565], [-119.39436, 38.40839], [-119.40361, 38.40862], [-119.40384, 38.41226], [-119.41351, 38.4125], [-119.41373, 38.41613]]], [[[-119.41593, 38.35438], [-119.41093, 38.35364], [-119.40939, 38.35339], [-119.40726, 38.35299], [-119.40676, 38.35286], [-119.40674, 38.3522], [-119.41129, 38.35222], [-119.4159, 38.35211], [-119.41593, 38.35438]]], [[[-119.41595, 38.35572], [-119.41136, 38.35582], [-119.40681, 38.35578], [-119.40677, 38.35329], [-119.40713, 38.35339], [-119.40928, 38.3538], [-119.41083, 38.35404], [-119.41594, 38.3548], [-119.41595, 38.35572]]], [[[-119.43863, 38.33091], [-119.43406, 38.33097], [-119.43408, 38.33449], [-119.42958, 38.33456], [-119.42964, 38.33802], [-119.42497, 38.33802], [-119.4249, 38.33451], [-119.42483, 38.32729], [-119.42942, 38.32753], [-119.43397, 38.32747], [-119.43392, 38.32397], [-119.42934, 38.32391], [-119.42474, 38.32378], [-119.42015, 38.32377], [-119.42018, 38.32728], [-119.41558, 38.32727], [-119.41554, 38.32377], [-119.42013, 38.32377], [-119.42014, 38.32376], [-119.42005, 38.32027], [-119.41546, 38.32022], [-119.4154, 38.31696], [-119.41999, 38.31701], [-119.42007, 38.32027], [-119.42924, 38.32028], [-119.42917, 38.31703], [-119.43375, 38.31708], [-119.43383, 38.32034], [-119.43838, 38.32039], [-119.43863, 38.33091]]], [[[-119.42945, 38.37713], [-119.42547, 38.3772], [-119.42541, 38.37362], [-119.42701, 38.37359], [-119.42727, 38.37458], [-119.42788, 38.37539], [-119.42886, 38.37624], [-119.42914, 38.37653], [-119.42933, 38.37686], [-119.42945, 38.37713]]], [[[-119.42903, 38.38424], [-119.42772, 38.38609], [-119.42755, 38.38641], [-119.4274, 38.38673], [-119.42727, 38.38708], [-119.42709, 38.38776], [-119.42568, 38.38776], [-119.42561, 38.38427], [-119.42903, 38.38424]]], [[[-119.43485, 38.38774], [-119.43028, 38.38778], [-119.42751, 38.38777], [-119.42761, 38.38736], [-119.42777, 38.38686], [-119.42792, 38.38646], [-119.4286, 38.3855], [-119.42979, 38.38374], [-119.42996, 38.38346], [-119.43009, 38.3832], [-119.43085, 38.38054], [-119.43093, 38.38032], [-119.43082, 38.37917], [-119.4307, 38.37881], [-119.42971, 38.37661], [-119.42955, 38.37635], [-119.42931, 38.37612], [-119.42836, 38.37515], [-119.42784, 38.37459], [-119.42766, 38.37421], [-119.42747, 38.37358], [-119.43001, 38.37354], [-119.43001, 38.37343], [-119.43447, 38.37352], [-119.43485, 38.38774]]], [[[-119.43857, 38.33795], [-119.43855, 38.34153], [-119.43413, 38.34154], [-119.43415, 38.34507], [-119.42978, 38.34504], [-119.42971, 38.34155], [-119.43413, 38.34154], [-119.43411, 38.33801], [-119.43857, 38.33795]]], [[[-119.43015, 38.38132], [-119.43014, 38.38071], [-119.4301, 38.3787], [-119.43032, 38.37917], [-119.43039, 38.37968], [-119.43045, 38.38028], [-119.43015, 38.38132]]], [[[-119.45453, 38.45495], [-119.45452, 38.45516], [-119.45051, 38.45528], [-119.45051, 38.45455], [-119.45082, 38.45467], [-119.45105, 38.45474], [-119.45152, 38.45479], [-119.45186, 38.4548], [-119.45216, 38.45465], [-119.45257, 38.45452], [-119.45295, 38.45459], [-119.45315, 38.45464], [-119.4533, 38.45472], [-119.45343, 38.45477], [-119.45395, 38.45488], [-119.45401, 38.45493], [-119.45422, 38.45495], [-119.45453, 38.45495]]], [[[-119.45464, 38.45171], [-119.45453, 38.45477], [-119.45404, 38.45476], [-119.45387, 38.45467], [-119.45349, 38.45463], [-119.45331, 38.45458], [-119.45324, 38.45448], [-119.45281, 38.4544], [-119.45241, 38.45441], [-119.45226, 38.45445], [-119.45191, 38.45457], [-119.45171, 38.45467], [-119.45147, 38.45464], [-119.45108, 38.45456], [-119.45093, 38.45451], [-119.45071, 38.45443], [-119.45051, 38.45433], [-119.45054, 38.45183], [-119.45464, 38.45171]]]]} Open Access 1 25250 Burcham & Wheeler Flats Wildlife Area 30524 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Mono 32 1184.975 Burcham & Wheeler Flats Wildlife Area 2014 State Conservation Area 8 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]);