units_with_maps

Table actions

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

8 rows where ACCESS_TYP = 3, COUNTY = 22 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

Suggested facets: GAP_STS

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 8 ✖

ACCESS_TYP 1

  • No Public Access · 8 ✖
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
3167 3167 3166 {"type": "MultiPolygon", "coordinates": [[[[-116.68524, 34.06247], [-116.6852, 34.07681], [-116.66784, 34.07682], [-116.66779, 34.06235], [-116.65036, 34.06223], [-116.65034, 34.04784], [-116.66779, 34.04785], [-116.6678, 34.06235], [-116.68524, 34.06247]]], [[[-116.6938, 34.10576], [-116.69375, 34.11974], [-116.68527, 34.11965], [-116.6851, 34.10573], [-116.66771, 34.1057], [-116.66798, 34.09129], [-116.68529, 34.09155], [-116.6851, 34.10573], [-116.6938, 34.10576]]]]} No Public Access 3 21980 Mission Creek 32221 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   San Bernardino 22 2202.531 Mission Creek 0 State Resource Management Area 55 3
3439 3439 3438 {"type": "Polygon", "coordinates": [[[-116.69795, 34.67637], [-116.68049, 34.67634], [-116.68049, 34.67369], [-116.69794, 34.67376], [-116.69795, 34.67637]]]} No Public Access 3 25252 Ord Rodman 32252 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   San Bernardino 22 115.534 Ord Rodman 0 State Resource Management Area 55 3
7211 7211 7210 {"type": "MultiPolygon", "coordinates": [[[[-115.10424, 34.50144], [-115.10424, 34.51594], [-115.08672, 34.51599], [-115.08674, 34.50147], [-115.10424, 34.50144]]], [[[-115.22675, 34.55713], [-115.21271, 34.55713], [-115.20947, 34.55717], [-115.20945, 34.54492], [-115.21819, 34.54493], [-115.22674, 34.54496], [-115.22675, 34.55713]]], [[[-115.22005, 34.58613], [-115.21566, 34.58613], [-115.21566, 34.58265], [-115.22005, 34.58265], [-115.22005, 34.58613]]]]} No Public Access 3 6386 Old Woman Mountains Bighorn Sheep Range 32250 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   San Bernardino 22 1209.01 Old Woman Mtns. Bighorn Sheep Range 0 State Resource Management Area 55 3
8054 8054 8053 {"type": "Polygon", "coordinates": [[[-117.24639, 34.2514], [-117.24262, 34.25146], [-117.2426, 34.25152], [-117.24249, 34.25502], [-117.23823, 34.25519], [-117.23846, 34.24793], [-117.24636, 34.24797], [-117.24639, 34.2514]]]} No Public Access 3 11821 San Bernardino Mountains Wildlife Corridor 32288 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   San Bernardino 22 109.636 San Bernardino Mtns. Wildlife Corridor 0 State Conservation Area 8 2
8126 8126 8125 {"type": "MultiPolygon", "coordinates": [[[[-114.68296, 34.3398], [-114.6829, 34.35425], [-114.66553, 34.35431], [-114.66563, 34.33982], [-114.68296, 34.3398]]], [[[-114.68326, 34.51393], [-114.68325, 34.52852], [-114.66592, 34.52856], [-114.66591, 34.51398], [-114.68326, 34.51393]]], [[[-114.7991, 34.61705], [-114.7905, 34.61714], [-114.78964, 34.60968], [-114.79824, 34.60959], [-114.7991, 34.61705]]], [[[-114.88529, 35.17127], [-114.86761, 35.17123], [-114.86761, 35.15694], [-114.88528, 35.15695], [-114.88529, 35.17127]]], [[[-114.89428, 35.13283], [-114.87683, 35.13283], [-114.87681, 35.11849], [-114.88106, 35.11848], [-114.88548, 35.1185], [-114.89428, 35.11847], [-114.89425, 35.12797], [-114.89428, 35.13283]]], [[[-114.90745, 34.70247], [-114.89003, 34.70345], [-114.89002, 34.70331], [-114.88985, 34.70332], [-114.88985, 34.68886], [-114.90723, 34.68779], [-114.90724, 34.68794], [-114.90742, 34.68793], [-114.90745, 34.70247]]], [[[-114.90784, 34.96717], [-114.90772, 34.96717], [-114.90772, 34.96727], [-114.89044, 34.96737], [-114.89047, 34.95306], [-114.90783, 34.95295], [-114.90784, 34.96717]]], [[[-114.95009, 34.7308], [-114.95002, 34.7454], [-114.93246, 34.74534], [-114.93246, 34.74521], [-114.93228, 34.7452], [-114.93231, 34.73056], [-114.94991, 34.73067], [-114.94991, 34.7308], [-114.95009, 34.7308]]], [[[-114.95011, 34.64364], [-114.95011, 34.65819], [-114.93256, 34.65819], [-114.93254, 34.64359], [-114.95011, 34.64364]]], [[[-114.95123, 34.55668], [-114.95122, 34.57118], [-114.93355, 34.57114], [-114.9337, 34.55663], [-114.95123, 34.55668]]], [[[-114.99959, 34.51577], [-114.99957, 34.53029], [-114.98195, 34.53015], [-114.98202, 34.51566], [-114.99959, 34.51577]]], [[[-115.05707, 34.57155], [-115.03971, 34.57147], [-115.03971, 34.5571], [-115.05707, 34.55719], [-115.05707, 34.57155]]], [[[-115.26678, 34.83271], [-115.24935, 34.8326], [-115.24934, 34.83047], [-115.24988, 34.81813], [-115.26674, 34.81823], [-115.2668, 34.82226], [-115.26678, 34.83271]]]]} No Public Access 3 12300 East Mojave Desert 32154 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   San Bernardino 22 7795.792 East Mojave Desert 0 State Resource Management Area 55 3
11553 11553 11552 {"type": "MultiPolygon", "coordinates": [[[[-116.27983, 35.49216], [-116.27707, 35.49572], [-116.27495, 35.49496], [-116.2776, 35.49119], [-116.27983, 35.49216]]], [[[-116.28733, 35.48445], [-116.28702, 35.48523], [-116.28511, 35.48486], [-116.28546, 35.48401], [-116.28733, 35.48445]]]]} No Public Access 3 23604 Mountain Sheep Watering Area 32241 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   San Bernardino 22 29.9 Mtn. Sheep Watering Area 0 State Resource Management Area 55 3
12567 12567 12566 {"type": "Polygon", "coordinates": [[[-116.80776, 34.25506], [-116.80546, 34.25503], [-116.80552, 34.25267], [-116.80555, 34.25223], [-116.80581, 34.25222], [-116.80587, 34.25399], [-116.8077, 34.25401], [-116.80776, 34.25506]]]} No Public Access 3 29074 Shay Meadow 32307 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   San Bernardino 22 7.409 Shay Meadow 0 State Resource Management Area 55 3
14660 14660 14659 {"type": "Polygon", "coordinates": [[[-116.10145, 34.19582], [-116.10145, 34.19703], [-116.09814, 34.19705], [-116.09814, 34.19584], [-116.10145, 34.19582]]]} No Public Access 3 44923 Twentynine Palms - Valle Vista Road 32334 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   San Bernardino 22 10.115 Twentynine Palms - Valle Vista Road 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]);