units_with_maps

Table actions

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

2 rows where COUNTY = 11 and DES_TP = 105 sorted by AGNCY_LEV

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • National Wildlife Refuge · 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
15834 15834 15833 {"type": "Polygon", "coordinates": [[[-122.33934, 38.15573], [-122.33919, 38.15592], [-122.33894, 38.15637], [-122.33875, 38.15679], [-122.33872, 38.15693], [-122.33861, 38.15714], [-122.33856, 38.15758], [-122.33841, 38.15832], [-122.33829, 38.15856], [-122.33809, 38.15884], [-122.33779, 38.1591], [-122.33759, 38.15913], [-122.33741, 38.15909], [-122.33694, 38.15895], [-122.33503, 38.15824], [-122.33482, 38.15813], [-122.33419, 38.15741], [-122.33391, 38.15692], [-122.33396, 38.15657], [-122.33421, 38.15609], [-122.33447, 38.15581], [-122.33474, 38.15559], [-122.33545, 38.15565], [-122.33538, 38.15569], [-122.33539, 38.15571], [-122.33934, 38.15573]]]} Restricted Access 2 35998 San Pablo Bay National Wildlife Refuge 24964 106 United States Fish and Wildlife Service 45 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1   Napa 11 31.587 San Pablo Bay NWR 1970 National Wildlife Refuge 105 2
15855 15855 15854 {"type": "Polygon", "coordinates": [[[-122.40525, 38.15593], [-122.40518, 38.15666], [-122.40508, 38.15728], [-122.40499, 38.15753], [-122.40485, 38.15777], [-122.4046, 38.15805], [-122.40434, 38.15824], [-122.40366, 38.15857], [-122.40302, 38.15881], [-122.40228, 38.159], [-122.40151, 38.15906], [-122.39974, 38.15901], [-122.39583, 38.15898], [-122.39499, 38.159], [-122.39251, 38.15914], [-122.39105, 38.15916], [-122.38851, 38.15912], [-122.38645, 38.15901], [-122.38456, 38.15884], [-122.38322, 38.15866], [-122.38237, 38.15848], [-122.38056, 38.15787], [-122.37873, 38.15751], [-122.37574, 38.15745], [-122.37394, 38.15744], [-122.37281, 38.15745], [-122.37204, 38.15748], [-122.37137, 38.15755], [-122.37074, 38.15771], [-122.36935, 38.15815], [-122.36896, 38.15829], [-122.36834, 38.15854], [-122.36712, 38.1591], [-122.3662, 38.15877], [-122.36573, 38.15817], [-122.36558, 38.15777], [-122.36522, 38.15586], [-122.38279, 38.15589], [-122.40393, 38.15584], [-122.40423, 38.15594], [-122.40525, 38.15593]]]} Restricted Access 2 44496 San Pablo Bay National Wildlife Refuge 24964 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1   Napa 11 249.551 San Pablo Bay NWR 1970 National Wildlife Refuge 105 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]);