units_with_maps

Table actions

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

1 row where COUNTY = 14, LABEL_NAME = "Moss Landing Wildlife Area" and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 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
16766 16766 16765 {"type": "MultiPolygon", "coordinates": [[[[-121.78498, 36.81041], [-121.7853, 36.81099], [-121.78583, 36.8188], [-121.78574, 36.81952], [-121.78543, 36.8201], [-121.785, 36.82068], [-121.78416, 36.8214], [-121.78328, 36.82063], [-121.78122, 36.82062], [-121.78068, 36.82076], [-121.77974, 36.82134], [-121.77859, 36.82219], [-121.77819, 36.8223], [-121.77777, 36.82229], [-121.77684, 36.82209], [-121.77522, 36.8224], [-121.77508, 36.82253], [-121.77497, 36.82315], [-121.77441, 36.82306], [-121.77378, 36.82308], [-121.77337, 36.82295], [-121.77107, 36.81957], [-121.77087, 36.81951], [-121.76942, 36.8196], [-121.76898, 36.81939], [-121.76871, 36.81937], [-121.76762, 36.81936], [-121.7673, 36.81926], [-121.76639, 36.81919], [-121.76566, 36.81996], [-121.76188, 36.81992], [-121.75863, 36.81812], [-121.75618, 36.81886], [-121.75684, 36.82135], [-121.75558, 36.82135], [-121.75527, 36.82064], [-121.75332, 36.82008], [-121.75104, 36.81753], [-121.75044, 36.81779], [-121.74928, 36.81909], [-121.7509, 36.82139], [-121.74841, 36.82147], [-121.74846, 36.82275], [-121.74936, 36.82319], [-121.74909, 36.82944], [-121.7474, 36.83029], [-121.7474, 36.8303], [-121.74803, 36.83078], [-121.74673, 36.83198], [-121.74636, 36.83258], [-121.7462, 36.83307], [-121.74627, 36.83325], [-121.74735, 36.83371], [-121.74186, 36.83374], [-121.74173, 36.83289], [-121.74174, 36.8321], [-121.742, 36.83144], [-121.74274, 36.83083], [-121.74491, 36.82802], [-121.74511, 36.8275], [-121.74566, 36.82415], [-121.7457, 36.82394], [-121.74569, 36.82393], [-121.74647, 36.81919], [-121.74667, 36.81881], [-121.74719, 36.81836], [-121.74736, 36.8182], [-121.75085, 36.81605], [-121.75103, 36.81597], [-121.7514, 36.81598], [-121.75955, 36.81424], [-121.76284, 36.81372], [-121.7637, 36.81474], [-121.76375, 36.81535], [-121.76479, 36.8169], [-121.76496, 36.81747], [-121.76518, 36.81764], [-121.76531, 36.81759], [-121.76564, 36.81736], [-121.76712, 36.81734], [-121.76829, 36.81698], [-121.76934, 36.81621], [-121.76992, 36.8157], [-121.76996, 36.81491], [-121.77036, 36.81426], [-121.7711, 36.8136], [-121.77157, 36.81358], [-121.77355, 36.81382], [-121.77508, 36.8137], [-121.77614, 36.81332], [-121.77742, 36.81323], [-121.77913, 36.8132], [-121.77912, 36.81339], [-121.78035, 36.81343], [-121.78046, 36.8139], [-121.78097, 36.81447], [-121.78138, 36.81463], [-121.78182, 36.8146], [-121.78283, 36.81389], [-121.78276, 36.81212], [-121.78287, 36.81174], [-121.78308, 36.81141], [-121.78498, 36.81041]]], [[[-121.76, 36.84605], [-121.75684, 36.84594], [-121.75552, 36.84534], [-121.75484, 36.84485], [-121.75477, 36.84415], [-121.75439, 36.84386], [-121.75386, 36.84269], [-121.7536, 36.8423], [-121.75352, 36.8421], [-121.75309, 36.84163], [-121.75208, 36.84117], [-121.75213, 36.8383], [-121.75445, 36.83827], [-121.75587, 36.83906], [-121.76, 36.84605]]], [[[-121.78376, 36.82149], [-121.78185, 36.82253], [-121.77919, 36.82358], [-121.77569, 36.82363], [-121.77564, 36.82318], [-121.77587, 36.82278], [-121.77615, 36.8226], [-121.77682, 36.82257], [-121.77712, 36.82265], [-121.77752, 36.82291], [-121.7782, 36.82304], [-121.77849, 36.82307], [-121.77878, 36.82291], [-121.77978, 36.82192], [-121.78039, 36.82156], [-121.78163, 36.82119], [-121.78217, 36.82118], [-121.78288, 36.8211], [-121.78303, 36.82122], [-121.78326, 36.82149], [-121.78376, 36.82149]]]]} Open Access 1 25255 Moss Landing Wildlife Area 30476 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 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Moss-Landing-WA Monterey 14 758.448 Moss Landing Wildlife Area 1985 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]);