units_with_maps

Table actions

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

1 row where COUNTY = 45, DES_TP = 104 and MNG_AGENCY = 128

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Other State · 1 ✖

DES_TP 1

  • State Other or Unknown · 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
4768 4768 4767 {"type": "MultiPolygon", "coordinates": [[[[-123.79434, 40.47335], [-123.79344, 40.47461], [-123.79172, 40.47464], [-123.7917, 40.47345], [-123.79184, 40.4734], [-123.79189, 40.47397], [-123.7929, 40.47349], [-123.7938, 40.47316], [-123.79434, 40.47335]]], [[[-123.80067, 40.46825], [-123.80044, 40.46859], [-123.80036, 40.4688], [-123.80034, 40.46903], [-123.80011, 40.46906], [-123.80066, 40.46963], [-123.79996, 40.46972], [-123.79992, 40.46966], [-123.79964, 40.46971], [-123.79961, 40.46959], [-123.79997, 40.46954], [-123.8001, 40.46907], [-123.80009, 40.46906], [-123.79735, 40.46919], [-123.79647, 40.46944], [-123.79653, 40.46852], [-123.79661, 40.46843], [-123.79718, 40.46811], [-123.79754, 40.46817], [-123.79789, 40.46815], [-123.7983, 40.46803], [-123.7993, 40.46811], [-123.79937, 40.46813], [-123.79941, 40.46807], [-123.79936, 40.46805], [-123.79938, 40.46802], [-123.80067, 40.46825]]], [[[-124.09997, 41.25922], [-124.0996, 41.26108], [-124.09945, 41.26144], [-124.09924, 41.26217], [-124.09926, 41.26243], [-124.09904, 41.26333], [-124.09904, 41.26429], [-124.09931, 41.26516], [-124.09974, 41.26573], [-124.09975, 41.2659], [-124.0997, 41.2661], [-124.09935, 41.26665], [-124.09928, 41.26672], [-124.09862, 41.26813], [-124.09732, 41.27163], [-124.097, 41.27279], [-124.09665, 41.27363], [-124.09622, 41.27454], [-124.09616, 41.27463], [-124.09565, 41.27589], [-124.09539, 41.27717], [-124.09365, 41.27719], [-124.09391, 41.2761], [-124.09413, 41.27503], [-124.09435, 41.27356], [-124.09491, 41.27158], [-124.09529, 41.27031], [-124.09573, 41.26915], [-124.09606, 41.2682], [-124.09669, 41.26687], [-124.09668, 41.26686], [-124.09536, 41.26684], [-124.09563, 41.26017], [-124.09518, 41.25926], [-124.09688, 41.25931], [-124.09997, 41.25922]]], [[[-124.19517, 40.77569], [-124.19492, 40.77704], [-124.19447, 40.77695], [-124.19466, 40.77632], [-124.19483, 40.77561], [-124.19517, 40.77569]]], [[[-124.26888, 40.62856], [-124.26886, 40.62923], [-124.26704, 40.62852], [-124.26888, 40.62856], [-124.26888, 40.62856]]]]} Open Access 1 46915 Unnamed site - Other State 28654 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 140.719   0 State Other or Unknown 104 4

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