units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, COUNTY = 54 and DES_TP = 55

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Resource Management Area · 2 ✖

ACCESS_TYP 1

  • No Public Access · 2 ✖
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
7673 7673 7672 {"type": "Polygon", "coordinates": [[[-120.99914, 40.31163], [-120.99859, 40.31171], [-120.99851, 40.31129], [-120.99668, 40.31149], [-120.9969, 40.31103], [-120.99705, 40.31094], [-120.99856, 40.31086], [-120.99813, 40.31023], [-120.99861, 40.31003], [-120.99911, 40.31023], [-120.99914, 40.31163]]]} No Public Access 3 7584 Mountain Meadows 32238 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   Lassen 54 4.353 Mtn. Meadows 0 State Resource Management Area 55 3
11497 11497 11496 {"type": "MultiPolygon", "coordinates": [[[[-120.12466, 40.68277], [-120.11052, 40.68277], [-120.11043, 40.6865], [-120.10551, 40.68656], [-120.10532, 40.67563], [-120.12453, 40.67551], [-120.12466, 40.68277]]], [[[-120.11974, 40.39579], [-120.11948, 40.41017], [-120.11474, 40.41017], [-120.115, 40.39571], [-120.11974, 40.39579]]], [[[-120.12886, 40.62809], [-120.1241, 40.628], [-120.12404, 40.62452], [-120.12877, 40.62458], [-120.12886, 40.62809]]], [[[-120.15173, 40.53762], [-120.1374, 40.53759], [-120.13739, 40.54122], [-120.13263, 40.54123], [-120.13264, 40.54485], [-120.12788, 40.54484], [-120.12789, 40.53761], [-120.13263, 40.5376], [-120.13266, 40.53398], [-120.14225, 40.53395], [-120.14698, 40.53396], [-120.14698, 40.5306], [-120.1472, 40.53077], [-120.14736, 40.53104], [-120.14794, 40.53158], [-120.14855, 40.53208], [-120.14962, 40.53254], [-120.15024, 40.53309], [-120.15079, 40.53341], [-120.15116, 40.53367], [-120.15173, 40.53415], [-120.15173, 40.53762]]], [[[-120.14737, 40.59576], [-120.14259, 40.59572], [-120.14251, 40.5921], [-120.14727, 40.59214], [-120.14737, 40.59576]]], [[[-120.15173, 40.5339], [-120.15131, 40.53355], [-120.15092, 40.53328], [-120.15039, 40.53296], [-120.14975, 40.5324], [-120.14867, 40.53194], [-120.1481, 40.53147], [-120.14754, 40.53095], [-120.14737, 40.53067], [-120.14698, 40.53036], [-120.15173, 40.53036], [-120.15173, 40.5339]]], [[[-120.17204, 40.98886], [-120.16735, 40.98892], [-120.16724, 40.99254], [-120.15318, 40.99267], [-120.15268, 40.97824], [-120.17159, 40.978], [-120.17189, 40.98472], [-120.17204, 40.98886]]], [[[-120.1673, 40.41377], [-120.16729, 40.41739], [-120.15781, 40.41734], [-120.15782, 40.41372], [-120.1673, 40.41377]]], [[[-120.16567, 40.62829], [-120.16569, 40.62854], [-120.16567, 40.63066], [-120.16565, 40.63153], [-120.16576, 40.63185], [-120.16579, 40.63201], [-120.16578, 40.63214], [-120.16573, 40.6323], [-120.16566, 40.63245], [-120.16561, 40.63263], [-120.16561, 40.6329], [-120.16557, 40.6339], [-120.16556, 40.63416], [-120.16552, 40.63438], [-120.16501, 40.63508], [-120.16455, 40.63564], [-120.1624, 40.63749], [-120.16211, 40.63786], [-120.16205, 40.6283], [-120.16567, 40.62829]]], [[[-120.18129, 40.64279], [-120.16216, 40.64287], [-120.16208, 40.63825], [-120.16238, 40.63782], [-120.16257, 40.63759], [-120.16473, 40.63573], [-120.1652, 40.63516], [-120.16573, 40.63442], [-120.16578, 40.63417], [-120.16583, 40.63291], [-120.16582, 40.63263], [-120.16587, 40.63249], [-120.16594, 40.63234], [-120.16599, 40.63216], [-120.166, 40.63199], [-120.16597, 40.63181], [-120.16587, 40.63151], [-120.16589, 40.63066], [-120.1659, 40.62854], [-120.16589, 40.62829], [-120.18114, 40.62824], [-120.18129, 40.64279]]], [[[-120.17565, 40.53036], [-120.16617, 40.53037], [-120.16614, 40.52674], [-120.17563, 40.52672], [-120.17565, 40.53036]]], [[[-120.19529, 40.62089], [-120.19053, 40.62089], [-120.19047, 40.61726], [-120.19523, 40.61727], [-120.19529, 40.62089]]], [[[-120.20528, 40.63904], [-120.20051, 40.63908], [-120.20044, 40.63545], [-120.2052, 40.63542], [-120.20528, 40.63904]]], [[[-120.26085, 40.70145], [-120.26081, 40.70507], [-120.25712, 40.70505], [-120.25605, 40.70506], [-120.25609, 40.70144], [-120.26085, 40.70145]]], [[[-120.29496, 40.6288], [-120.29474, 40.64327], [-120.27586, 40.64307], [-120.27576, 40.62888], [-120.29496, 40.6288]]], [[[-120.38113, 40.59584], [-120.38111, 40.5995], [-120.37636, 40.59955], [-120.37637, 40.59585], [-120.38113, 40.59584]]], [[[-120.40468, 40.64689], [-120.40467, 40.64827], [-120.40468, 40.65414], [-120.39992, 40.65413], [-120.39994, 40.65191], [-120.39992, 40.64689], [-120.40468, 40.64689]]], [[[-120.51051, 40.86288], [-120.50098, 40.86293], [-120.49624, 40.86292], [-120.49625, 40.86116], [-120.49207, 40.86105], [-120.49184, 40.86066], [-120.49146, 40.86011], [-120.49144, 40.85566], [-120.51049, 40.85567], [-120.51051, 40.86288]]]]} No Public Access 3 23355 Great Basin Springs 32178 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   Lassen 54 3488.087 Great Basin Springs 0 State Resource Management Area 55 3

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