units_with_maps

Table actions

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

1 row where AGNCY_LEV = 5, DES_TP = 1422 and LAYER = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

ACCESS_TYP 1

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
17007 17007 17006 {"type": "Polygon", "coordinates": [[[-121.30092, 39.26083], [-121.30093, 39.25141], [-121.29619, 39.25136], [-121.29138, 39.25136], [-121.29148, 39.25507], [-121.28722, 39.2551], [-121.28722, 39.25573], [-121.28719, 39.25571], [-121.2868, 39.25585], [-121.28659, 39.25617], [-121.28643, 39.25645], [-121.28622, 39.25661], [-121.28578, 39.25669], [-121.28505, 39.25674], [-121.28474, 39.25696], [-121.28466, 39.25718], [-121.28448, 39.25737], [-121.28427, 39.2575], [-121.28398, 39.25754], [-121.28378, 39.25754], [-121.28316, 39.2576], [-121.28261, 39.25767], [-121.28241, 39.25761], [-121.28191, 39.25751], [-121.28135, 39.25708], [-121.28104, 39.25682], [-121.28063, 39.25662], [-121.28032, 39.25643], [-121.27993, 39.25627], [-121.27955, 39.25596], [-121.27898, 39.25524], [-121.27852, 39.25483], [-121.27772, 39.25438], [-121.277, 39.25428], [-121.27645, 39.25429], [-121.27583, 39.25439], [-121.27542, 39.25453], [-121.2751, 39.25473], [-121.27493, 39.25496], [-121.27223, 39.25492], [-121.27226, 39.25134], [-121.27005, 39.25133], [-121.26974, 39.25132], [-121.26978, 39.25105], [-121.26978, 39.25075], [-121.26949, 39.25002], [-121.26946, 39.24989], [-121.26952, 39.24989], [-121.26953, 39.24988], [-121.26939, 39.24965], [-121.26923, 39.24933], [-121.26916, 39.24918], [-121.26909, 39.24896], [-121.26878, 39.24763], [-121.26876, 39.24718], [-121.26882, 39.24667], [-121.26904, 39.24527], [-121.26905, 39.2448], [-121.26891, 39.24278], [-121.26889, 39.24173], [-121.2689, 39.24109], [-121.27325, 39.24134], [-121.27327, 39.23722], [-121.27748, 39.23723], [-121.27788, 39.23052], [-121.27806, 39.23032], [-121.2796, 39.2303], [-121.28206, 39.23057], [-121.283, 39.23055], [-121.28773, 39.2288], [-121.28768, 39.23274], [-121.29249, 39.23272], [-121.29248, 39.22873], [-121.29618, 39.2287], [-121.29612, 39.22304], [-121.30887, 39.22298], [-121.30758, 39.22803], [-121.30814, 39.22973], [-121.3148, 39.23303], [-121.31623, 39.23359], [-121.32226, 39.23519], [-121.32623, 39.23328], [-121.3269, 39.23267], [-121.32789, 39.23237], [-121.32841, 39.23194], [-121.32872, 39.23012], [-121.32905, 39.23011], [-121.32909, 39.23355], [-121.3338, 39.23349], [-121.33372, 39.23727], [-121.3243, 39.23737], [-121.32429, 39.23738], [-121.32452, 39.24449], [-121.33368, 39.24449], [-121.33366, 39.24792], [-121.32917, 39.24796], [-121.32919, 39.25147], [-121.32924, 39.25513], [-121.33372, 39.25512], [-121.33371, 39.26605], [-121.31481, 39.26614], [-121.30732, 39.2662], [-121.30748, 39.27044], [-121.31484, 39.27044], [-121.31493, 39.2805], [-121.30538, 39.28061], [-121.30542, 39.28434], [-121.30106, 39.2844], [-121.301, 39.29499], [-121.30318, 39.295], [-121.30147, 39.29639], [-121.30123, 39.29678], [-121.30095, 39.29746], [-121.30085, 39.29796], [-121.30099, 39.29839], [-121.30121, 39.29871], [-121.30158, 39.29893], [-121.30153, 39.29925], [-121.30093, 39.29933], [-121.30101, 39.30572], [-121.29676, 39.30573], [-121.2967, 39.30303], [-121.28711, 39.30295], [-121.2869, 39.29512], [-121.28248, 39.29517], [-121.28234, 39.2807], [-121.28742, 39.28071], [-121.2873, 39.27731], [-121.29637, 39.27717], [-121.29623, 39.26629], [-121.30109, 39.26624], [-121.30092, 39.26083]]]} Restricted Access 2 620 Sierra Foothill Research & Extension Center 25454 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5   Yuba 25 5779.172 Sierra Foothill Research & Extension Ctr. 0 None 1422  

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