units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 2, COUNTY = 29 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_WEB

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 4 ✖

ACCESS_TYP 1

  • Restricted 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
402 402 401 {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} Restricted Access 2 1556 Springville Ecological Reserve 25751 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   Tulare 29 4.947 Springville ER 0 State Conservation Area 8 2
1947 1947 1946 {"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]} Restricted Access 2 29177 Yaudanchi Ecological Reserve 27765 220 California Department of Health Services 459 State 5 State Agency 5 http://www.dhcs.ca.gov/Pages/default.aspx Other State 5 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Tulare 29 184.306 Yaudanchi ER 0 State Conservation Area 8 2
6188 6188 6187 {"type": "Polygon", "coordinates": [[[-118.81911, 36.36224], [-118.81837, 36.36643], [-118.81325, 36.3665], [-118.81331, 36.3666], [-118.81367, 36.3667], [-118.8139, 36.36703], [-118.80688, 36.3671], [-118.80404, 36.36685], [-118.80466, 36.36608], [-118.80756, 36.36631], [-118.81069, 36.36259], [-118.8113, 36.36337], [-118.81146, 36.36387], [-118.81161, 36.36413], [-118.81196, 36.36425], [-118.81237, 36.36429], [-118.81278, 36.36423], [-118.81313, 36.36425], [-118.81339, 36.3643], [-118.8143, 36.36459], [-118.81486, 36.36464], [-118.81543, 36.36452], [-118.81601, 36.36424], [-118.81643, 36.3637], [-118.81693, 36.36319], [-118.81792, 36.36255], [-118.81911, 36.36224]]]} Restricted Access 2 1503 Kaweah Ecological Reserve 20561 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   Tulare 29 83.672 Kaweah ER 0 State Conservation Area 8 2
6316 6316 6315 {"type": "MultiPolygon", "coordinates": [[[[-118.8669, 36.28058], [-118.85857, 36.28042], [-118.85009, 36.28028], [-118.85005, 36.26722], [-118.86682, 36.26716], [-118.8669, 36.28058]]], [[[-118.87852, 36.33542], [-118.8742, 36.3354], [-118.87424, 36.34262], [-118.86989, 36.34266], [-118.85062, 36.34313], [-118.85055, 36.32735], [-118.86987, 36.32809], [-118.87846, 36.32824], [-118.87852, 36.33542]]]]} Restricted Access 2 1493 Blue Ridge Ecological Reserve 16186 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   Tulare 29 1499.176 Blue Ridge ER 0 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]);