units_with_maps

Table actions

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

2 rows where AGNCY_TYP = 1, MNG_AG_TYP = 5 and YR_EST = 1974

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

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
11472 11472 11471 {"type": "Polygon", "coordinates": [[[-121.0343, 37.08628], [-121.03425, 37.08903], [-121.02759, 37.08656], [-121.02759, 37.08625], [-121.0343, 37.08628]]]} Open Access 1 29207 O'Neill Forebay Wildlife Area 30483 103 United States Bureau of Reclamation 369 Federal 1 Federal Agency 1 http://www.usbr.gov/ Other Federal 13 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Merced 37 25.025 O'Neill Forebay Wildlife Area 1974 State Conservation Area 8 2
16737 16737 16736 {"type": "Polygon", "coordinates": [[[-121.21406, 37.06776], [-121.21298, 37.06812], [-121.21212, 37.06859], [-121.21188, 37.06961], [-121.2101, 37.07152], [-121.20869, 37.07416], [-121.20739, 37.07552], [-121.20099, 37.07677], [-121.19885, 37.07706], [-121.19884, 37.07707], [-121.19633, 37.07741], [-121.19525, 37.07718], [-121.19463, 37.07753], [-121.19516, 37.07966], [-121.19407, 37.08005], [-121.19383, 37.08125], [-121.1924, 37.08246], [-121.19156, 37.08301], [-121.19054, 37.08296], [-121.19005, 37.08424], [-121.18797, 37.08395], [-121.1871, 37.08434], [-121.18607, 37.08428], [-121.18542, 37.08347], [-121.18368, 37.0841], [-121.18212, 37.08385], [-121.17922, 37.08431], [-121.17713, 37.08548], [-121.17606, 37.08487], [-121.17821, 37.08307], [-121.17796, 37.07874], [-121.18424, 37.07983], [-121.18605, 37.07761], [-121.18322, 37.07575], [-121.18084, 37.07492], [-121.1802, 37.06942], [-121.18417, 37.07149], [-121.19435, 37.07428], [-121.19578, 37.0731], [-121.18894, 37.06847], [-121.18034, 37.06541], [-121.18358, 37.06544], [-121.18861, 37.06533], [-121.19068, 37.06551], [-121.1916, 37.06583], [-121.19232, 37.06645], [-121.19305, 37.06654], [-121.19453, 37.06725], [-121.195, 37.0677], [-121.1973, 37.06844], [-121.19909, 37.06839], [-121.201, 37.06716], [-121.2009, 37.06662], [-121.20154, 37.0658], [-121.20221, 37.06557], [-121.20246, 37.06481], [-121.20495, 37.06328], [-121.20792, 37.06482], [-121.20995, 37.06498], [-121.21014, 37.06529], [-121.21023, 37.06551], [-121.21019, 37.06568], [-121.21011, 37.06588], [-121.20996, 37.06606], [-121.20975, 37.06625], [-121.20933, 37.06659], [-121.20921, 37.06685], [-121.20914, 37.0671], [-121.2092, 37.06737], [-121.20941, 37.06751], [-121.20965, 37.06762], [-121.20996, 37.0677], [-121.2103, 37.06774], [-121.21065, 37.06784], [-121.21158, 37.06825], [-121.21174, 37.06826], [-121.21318, 37.06774], [-121.21347, 37.06769], [-121.21381, 37.06769], [-121.21406, 37.06776]]]} Open Access 1 17305 San Luis Reservoir Wildlife Area 30500 103 United States Bureau of Reclamation 369 Federal 1 Federal Agency 1 http://www.usbr.gov/ Other Federal 13 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Merced 37 861.266 San Luis Reservoir Wildlife Area 1974 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]);