units_with_maps

Table actions

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

7 rows where ACCESS_TYP = 4 and COUNTY = 22

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME, GAP_STS

ACCESS_TYP 1

  • Unknown Access · 7 ✖
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
3478 3478 3477 {"type": "Polygon", "coordinates": [[[-116.10126, 34.74073], [-116.10125, 34.74791], [-116.09285, 34.74777], [-116.09283, 34.74063], [-116.10126, 34.74073]]]} Unknown Access 4 25830 Wilderness Land Trust 27510 3097 Wilderness Land Trust 603 Non Profit 6 Non Profit - Land Trust 10 http://www.wildernesslandtrust.org/ Non Governmental Organization 10 3097 Wilderness Land Trust 592 Non Profit 6 Non Profit - Land Trust 10   San Bernardino 22 151.196 Wilderness Land Trust 0 Private Conservation 16 2
3735 3735 3734 {"type": "MultiPolygon", "coordinates": [[[[-115.10406, 34.54508], [-115.08803, 34.54518], [-115.08805, 34.53083], [-115.08787, 34.53082], [-115.08786, 34.53069], [-115.08667, 34.53068], [-115.08667, 34.53042], [-115.10406, 34.53045], [-115.10406, 34.54508]]], [[[-115.12163, 34.51577], [-115.12163, 34.52303], [-115.12161, 34.53026], [-115.11284, 34.5303], [-115.10424, 34.53032], [-115.10424, 34.51581], [-115.12163, 34.51577]]], [[[-115.12164, 34.48689], [-115.12161, 34.50126], [-115.10425, 34.5013], [-115.10427, 34.48694], [-115.12164, 34.48689]]], [[[-115.12292, 34.54519], [-115.12277, 34.55666], [-115.10969, 34.55712], [-115.10968, 34.55726], [-115.10553, 34.55726], [-115.10557, 34.5452], [-115.12292, 34.54519]]]]} Unknown Access 4 31017 Native American Land Conservancy 22662 3125 Native American Land Conservancy 674 Non Profit 6 Non Profit - Land Trust 10 http://nalc4all.org/ Non Governmental Organization 10 3125 Native American Land Conservancy 664 Non Profit 6 Non Profit - Land Trust 10   San Bernardino 22 2369.21 Native American Land Conservancy 0 Private Conservation 16 2
4161 4161 4160 {"type": "Polygon", "coordinates": [[[-116.41278, 35.08058], [-116.41277, 35.09522], [-116.39514, 35.09528], [-116.39514, 35.0819], [-116.39506, 35.08051], [-116.40393, 35.08058], [-116.41278, 35.08058]]]} Unknown Access 4 44748 California State Lands Commission 16726 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   San Bernardino 22 647.887 SLC 0 State Resource Management Area 55 3
4475 4475 4474 {"type": "Polygon", "coordinates": [[[-117.51483, 34.17196], [-117.51477, 34.17839], [-117.51026, 34.17888], [-117.51022, 34.17196], [-117.51483, 34.17196]]]} Unknown Access 4 3291 Unnamed site - The Habitat Trust 28671 3089 The Habitat Trust 340 Non Profit 6 Non Profit - Land Trust 10   Non Governmental Organization 10 3089 The Habitat Trust 337 Non Profit 6 Non Profit - Land Trust 10   San Bernardino 22 76.971   0 Private Other or Unknown 399 4
12260 12260 12259 {"type": "Polygon", "coordinates": [[[-115.41747, 34.16754], [-115.41528, 34.16754], [-115.41526, 34.16572], [-115.41745, 34.16572], [-115.41747, 34.16754]]]} Unknown Access 4 25832 Wilderness Land Trust 27510 3097 Wilderness Land Trust 603 Non Profit 6 Non Profit - Land Trust 10 http://www.wildernesslandtrust.org/ Non Governmental Organization 10 3097 Wilderness Land Trust 592 Non Profit 6 Non Profit - Land Trust 10   San Bernardino 22 10.084 Wilderness Land Trust 0 Private Conservation 16 2
12612 12612 12611 {"type": "Polygon", "coordinates": [[[-114.71493, 34.89453], [-114.71491, 34.90936], [-114.71073, 34.90934], [-114.71076, 34.90206], [-114.70637, 34.90206], [-114.70643, 34.89457], [-114.71493, 34.89453]]]} Unknown Access 4 29372 Mojave Desert Land Trust Properties 22350 3124 Mojave Desert Land Trust 669 Non Profit 6 Non Profit - Land Trust 10 http://www.mojavedesertlandtrust.org/ Non Governmental Organization 10 3124 Mojave Desert Land Trust 657 Non Profit 6 Non Profit - Land Trust 10   San Bernardino 22 236.65 Mojave Desert Land Trust Properties 0 Private Conservation 16 2
16586 16586 16585 {"type": "Polygon", "coordinates": [[[-117.15468, 34.3852], [-117.15467, 34.39963], [-117.14592, 34.39962], [-117.14596, 34.38506], [-117.15468, 34.3852]]]} Unknown Access 4 44757 California State Lands Commission 16726 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   San Bernardino 22 319.202 SLC 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]);