units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 3, COUNTY = 36 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 4 ✖

ACCESS_TYP 1

  • No Public Access · 4 ✖
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
1949 1949 1948 {"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]} No Public Access 3 16653 Elk Hills 32158 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   Kern 36 517.552 Elk Hills 0 State Resource Management Area 55 3
1956 1956 1955 {"type": "Polygon", "coordinates": [[[-117.8303, 35.57191], [-117.83026, 35.57926], [-117.82582, 35.57925], [-117.82581, 35.58284], [-117.82577, 35.58649], [-117.82128, 35.58644], [-117.82132, 35.58281], [-117.82141, 35.57924], [-117.82581, 35.57924], [-117.82587, 35.57561], [-117.82586, 35.5756], [-117.82143, 35.57557], [-117.82145, 35.57191], [-117.8303, 35.57191]]]} No Public Access 3 16665 Indian Wells Valley 32190 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   Kern 36 201.555 Indian Wells Valley 0 State Resource Management Area 55 3
3491 3491 3490 {"type": "MultiPolygon", "coordinates": [[[[-119.50998, 35.36521], [-119.50076, 35.36536], [-119.50076, 35.36145], [-119.50129, 35.36134], [-119.50218, 35.36122], [-119.50274, 35.36122], [-119.50324, 35.36126], [-119.50374, 35.36134], [-119.50422, 35.36146], [-119.50467, 35.36161], [-119.50529, 35.36191], [-119.50667, 35.36283], [-119.50706, 35.36313], [-119.50998, 35.36521]]], [[[-119.63933, 35.48483], [-119.63646, 35.48481], [-119.63652, 35.47193], [-119.63789, 35.47208], [-119.63786, 35.47474], [-119.63778, 35.47861], [-119.63933, 35.48483]]]]} No Public Access 3 25905 California Aqueduct, Region 4 32081 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   Kern 36 118.425 California Aqueduct, Region 4 0 State Resource Management Area 55 3
9067 9067 9066 {"type": "MultiPolygon", "coordinates": [[[[-117.82662, 35.23575], [-117.81509, 35.23582], [-117.81509, 35.23107], [-117.8151, 35.23091], [-117.81518, 35.23054], [-117.81528, 35.23023], [-117.81543, 35.22993], [-117.81562, 35.22965], [-117.8157, 35.2295], [-117.81591, 35.22901], [-117.81599, 35.22876], [-117.81598, 35.22847], [-117.82661, 35.22835], [-117.82662, 35.23575]]], [[[-117.87993, 35.22116], [-117.87991, 35.22825], [-117.86265, 35.22824], [-117.86238, 35.21375], [-117.87118, 35.21361], [-117.8714, 35.22089], [-117.87589, 35.22102], [-117.87993, 35.22116]]], [[[-117.93302, 35.23571], [-117.91518, 35.23571], [-117.91515, 35.23206], [-117.91515, 35.22838], [-117.93289, 35.2284], [-117.93302, 35.23571]]], [[[-117.93339, 35.26495], [-117.93335, 35.2724], [-117.91564, 35.27255], [-117.91564, 35.26502], [-117.93339, 35.26495]]], [[[-117.9422, 35.25764], [-117.93338, 35.25766], [-117.93313, 35.24303], [-117.942, 35.24297], [-117.9422, 35.25764]]], [[[-117.9505, 35.22952], [-117.95058, 35.23373], [-117.95048, 35.23562], [-117.94188, 35.23572], [-117.94185, 35.22833], [-117.94604, 35.22832], [-117.9461, 35.22101], [-117.95042, 35.22093], [-117.9505, 35.22565], [-117.95045, 35.22831], [-117.94855, 35.22833], [-117.94854, 35.22954], [-117.94855, 35.22955], [-117.9505, 35.22952]]], [[[-117.96803, 35.18428], [-117.95909, 35.18426], [-117.95025, 35.1843], [-117.95019, 35.17697], [-117.95022, 35.16971], [-117.96347, 35.16954], [-117.96794, 35.16951], [-117.96794, 35.17677], [-117.96803, 35.18428]]]]} No Public Access 3 16644 Desert Tortoise Habitat 32149 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   Kern 36 2547.98 Desert Tortoise Habitat 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]);