units_with_maps

Table actions

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

3 rows where COUNTY = 26, DES_TP = 39 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 3 ✖

DES_TP 1

  • State Recreation Area · 3 ✖

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
3443 3443 3442 {"type": "Polygon", "coordinates": [[[-122.27607, 38.12156], [-122.27576, 38.12178], [-122.2757, 38.12104], [-122.27592, 38.12097], [-122.27607, 38.12156]]]} Open Access 1 25259 Vallejo Fishing Pier 32344 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   Solano 26 0.461 Vallejo Fishing Pier 0 State Recreation Area 39 4
7538 7538 7537 {"type": "Polygon", "coordinates": [[[-122.08865, 38.51565], [-122.08828, 38.51537], [-122.08787, 38.51513], [-122.08731, 38.51485], [-122.08639, 38.51468], [-122.08545, 38.51472], [-122.08468, 38.51491], [-122.08366, 38.51511], [-122.08246, 38.51529], [-122.08122, 38.51536], [-122.08014, 38.51521], [-122.07911, 38.51481], [-122.07845, 38.51475], [-122.07756, 38.51483], [-122.07722, 38.51473], [-122.07426, 38.51407], [-122.07323, 38.51437], [-122.07181, 38.51439], [-122.06966, 38.51436], [-122.0672, 38.51488], [-122.06675, 38.51502], [-122.06635, 38.51528], [-122.06574, 38.51557], [-122.06368, 38.51588], [-122.06207, 38.51641], [-122.06045, 38.51657], [-122.06011, 38.51666], [-122.05988, 38.51685], [-122.05962, 38.51711], [-122.05914, 38.51743], [-122.05697, 38.51763], [-122.05672, 38.51756], [-122.05628, 38.5175], [-122.05406, 38.51533], [-122.05188, 38.51338], [-122.05002, 38.51217], [-122.04939, 38.51199], [-122.0492, 38.51183], [-122.04854, 38.51109], [-122.04818, 38.51092], [-122.04799, 38.51086], [-122.04748, 38.51087], [-122.04484, 38.51008], [-122.04387, 38.50907], [-122.04332, 38.50861], [-122.04174, 38.50701], [-122.04165, 38.50677], [-122.04148, 38.50657], [-122.04138, 38.50596], [-122.04059, 38.50374], [-122.03966, 38.50201], [-122.03941, 38.50145], [-122.03914, 38.50112], [-122.03862, 38.50059], [-122.038, 38.4999], [-122.03736, 38.49902], [-122.0372, 38.49888], [-122.03674, 38.49872], [-122.0345, 38.49748], [-122.03323, 38.49636], [-122.03412, 38.4963], [-122.03469, 38.4967], [-122.03484, 38.49684], [-122.03564, 38.49724], [-122.03682, 38.49806], [-122.03721, 38.49835], [-122.03765, 38.49877], [-122.03858, 38.49992], [-122.03934, 38.5008], [-122.03961, 38.50119], [-122.04001, 38.50168], [-122.04071, 38.50304], [-122.04125, 38.50387], [-122.04113, 38.50428], [-122.04116, 38.50462], [-122.04145, 38.5054], [-122.04168, 38.50567], [-122.0427, 38.50633], [-122.04386, 38.50702], [-122.04445, 38.50754], [-122.04489, 38.50776], [-122.04518, 38.50787], [-122.04576, 38.50819], [-122.0463, 38.50857], [-122.04658, 38.50898], [-122.04717, 38.50945], [-122.04783, 38.5099], [-122.04825, 38.51013], [-122.05045, 38.51194], [-122.05078, 38.51195], [-122.051, 38.51199], [-122.05168, 38.51219], [-122.05677, 38.51707], [-122.05717, 38.51732], [-122.05761, 38.5174], [-122.05855, 38.51711], [-122.05886, 38.51688], [-122.05927, 38.51625], [-122.05962, 38.51612], [-122.06126, 38.51564], [-122.06235, 38.51545], [-122.0632, 38.51536], [-122.06399, 38.51531], [-122.06553, 38.51507], [-122.06638, 38.51488], [-122.06717, 38.51433], [-122.06761, 38.51419], [-122.06839, 38.51411], [-122.06913, 38.5141], [-122.07022, 38.51416], [-122.07058, 38.51402], [-122.071, 38.51375], [-122.07139, 38.51371], [-122.07204, 38.51371], [-122.07297, 38.51355], [-122.07377, 38.51359], [-122.07552, 38.51378], [-122.07595, 38.5137], [-122.07655, 38.51386], [-122.07713, 38.51407], [-122.07759, 38.51414], [-122.0801, 38.51391], [-122.08034, 38.51405], [-122.08068, 38.51438], [-122.08107, 38.51462], [-122.08209, 38.51488], [-122.08322, 38.51468], [-122.08433, 38.51453], [-122.08659, 38.51432], [-122.0882, 38.51445], [-122.08854, 38.51429], [-122.08865, 38.51565]]]} Open Access 1 9337 Putah Creek Fishing Access 32271 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   Solano 26 105.709 Putah Creek FA 0 State Recreation Area 39 4
15645 15645 15644 {"type": "Polygon", "coordinates": [[[-121.9752, 38.1883], [-121.97501, 38.18844], [-121.97456, 38.18828], [-121.97424, 38.18823], [-121.97403, 38.18826], [-121.97369, 38.18821], [-121.97322, 38.1882], [-121.97279, 38.18816], [-121.9715, 38.18789], [-121.97085, 38.18789], [-121.97038, 38.18761], [-121.97037, 38.18713], [-121.97034, 38.18699], [-121.97037, 38.18681], [-121.97046, 38.18671], [-121.97061, 38.18668], [-121.97351, 38.18742], [-121.97394, 38.18748], [-121.97425, 38.18755], [-121.97444, 38.18772], [-121.97491, 38.18782], [-121.97501, 38.18788], [-121.97501, 38.18814], [-121.9751, 38.18823], [-121.9752, 38.1883]]]} Open Access 1 29190 Belden's Landing Fishing Access 32045 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   Solano 26 9.739 Belden's Landing FA 0 State Recreation Area 39 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]);