units_with_maps

Table actions

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

7 rows where COUNTY = 24, MNG_AGENCY = 25 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST, GAP_STS

ACCESS_TYP 2

MNG_AG_TYP 1

  • State Agency · 7 ✖

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 7 ✖
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
2853 2853 2852 {"type": "Polygon", "coordinates": [[[-123.12633, 39.12775], [-123.12199, 39.12765], [-123.12186, 39.12406], [-123.12181, 39.12124], [-123.12251, 39.12168], [-123.12399, 39.12253], [-123.12435, 39.12276], [-123.1246, 39.12316], [-123.12473, 39.12355], [-123.12507, 39.12389], [-123.12597, 39.1242], [-123.12633, 39.12775]]]} Open Access 1 22154 Mill Creek 32219 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   Mendocino 24 49.861 Mill Creek 0 State Resource Management Area 55 3
5846 5846 5845 {"type": "Polygon", "coordinates": [[[-123.25549, 38.89635], [-123.24599, 38.90389], [-123.24056, 38.90437], [-123.24061, 38.90254], [-123.2406, 38.89715], [-123.24069, 38.8935], [-123.24608, 38.89273], [-123.24609, 38.89637], [-123.25549, 38.89635]]]} Restricted Access 2 21623 Yorkville Ecological Reserve 27781 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   Mendocino 24 226.535 Yorkville ER 0 State Conservation Area 8 2
8586 8586 8585 {"type": "MultiPolygon", "coordinates": [[[[-123.79827, 39.42684], [-123.79795, 39.427], [-123.79736, 39.42734], [-123.79715, 39.42712], [-123.79702, 39.42701], [-123.79711, 39.42678], [-123.79719, 39.42651], [-123.7975, 39.4264], [-123.79826, 39.42676], [-123.79827, 39.42684]]], [[[-123.79844, 39.4263], [-123.7984, 39.42647], [-123.79767, 39.42638], [-123.79763, 39.42621], [-123.79802, 39.4263], [-123.79844, 39.4263]]]]} Open Access 1 21604 Noyo River Fishing Access 32248 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   Mendocino 24 1.819 Noyo River FA 0 State Recreation Area 39 4
8836 8836 8835 {"type": "Polygon", "coordinates": [[[-123.77317, 39.57239], [-123.77216, 39.57277], [-123.77198, 39.5719], [-123.77185, 39.57109], [-123.7719, 39.57063], [-123.77189, 39.57026], [-123.77167, 39.5697], [-123.77215, 39.56967], [-123.77221, 39.56979], [-123.77219, 39.56983], [-123.77223, 39.5699], [-123.77235, 39.57009], [-123.77244, 39.57018], [-123.77251, 39.5702], [-123.77259, 39.57034], [-123.77254, 39.57053], [-123.77255, 39.57063], [-123.77278, 39.57097], [-123.77279, 39.57107], [-123.77264, 39.57129], [-123.77262, 39.57138], [-123.77274, 39.57157], [-123.77274, 39.57166], [-123.77278, 39.57181], [-123.7729, 39.57212], [-123.77288, 39.57219], [-123.77283, 39.57227], [-123.7729, 39.57232], [-123.77295, 39.57226], [-123.77304, 39.57228], [-123.77317, 39.57239]]]} Open Access 1 21614 South Kibesillah Gulch Fishing Access 32315 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   Mendocino 24 5.236 South Kibesillah Gulch FA 0 State Recreation Area 39 4
15588 15588 15587 {"type": "Polygon", "coordinates": [[[-123.6721, 39.95973], [-123.67226, 39.96331], [-123.67206, 39.97058], [-123.66728, 39.97068], [-123.66757, 39.97778], [-123.66307, 39.9778], [-123.663, 39.97427], [-123.65839, 39.97425], [-123.65822, 39.97069], [-123.6582, 39.96352], [-123.66285, 39.96333], [-123.66745, 39.96334], [-123.66745, 39.95984], [-123.6721, 39.95973]]]} Restricted Access 2 21599 Little Butte Ecological Reserve 21334 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   Mendocino 24 391.018 Little Butte ER 0 State Conservation Area 8 2
15615 15615 15614 {"type": "MultiPolygon", "coordinates": [[[[-123.91968, 39.98375], [-123.91492, 39.9839], [-123.914, 39.97613], [-123.91873, 39.97602], [-123.91968, 39.98375]]], [[[-123.96249, 39.98687], [-123.962, 39.99028], [-123.96186, 39.99077], [-123.95691, 39.99086], [-123.95637, 39.9945], [-123.95565, 39.99833], [-123.95078, 39.99848], [-123.94607, 39.99858], [-123.94287, 39.9987], [-123.94143, 39.99865], [-123.94152, 39.99732], [-123.94436, 39.9974], [-123.94442, 39.9964], [-123.9472, 39.99647], [-123.94723, 39.99587], [-123.94839, 39.9959], [-123.94837, 39.99652], [-123.94966, 39.99655], [-123.94968, 39.99635], [-123.95085, 39.99638], [-123.95084, 39.9968], [-123.95136, 39.99681], [-123.95138, 39.99513], [-123.95154, 39.99466], [-123.95153, 39.99465], [-123.94675, 39.99478], [-123.94189, 39.99487], [-123.93693, 39.99515], [-123.93204, 39.99534], [-123.93296, 39.99152], [-123.93364, 39.98738], [-123.92876, 39.98741], [-123.92907, 39.98552], [-123.92928, 39.98465], [-123.92947, 39.98364], [-123.92442, 39.98374], [-123.92379, 39.97989], [-123.92333, 39.97598], [-123.92291, 39.97199], [-123.92323, 39.97231], [-123.92349, 39.97265], [-123.92392, 39.97272], [-123.92445, 39.97325], [-123.92472, 39.97355], [-123.92498, 39.97398], [-123.9256, 39.97426], [-123.92609, 39.97425], [-123.92666, 39.97416], [-123.92705, 39.97386], [-123.92769, 39.9736], [-123.92802, 39.97358], [-123.9293, 39.97297], [-123.92977, 39.97206], [-123.93004, 39.97141], [-123.93058, 39.97135], [-123.93097, 39.97108], [-123.93158, 39.97097], [-123.93178, 39.97066], [-123.93253, 39.97053], [-123.93302, 39.97069], [-123.93352, 39.97082], [-123.93378, 39.97041], [-123.93398, 39.97014], [-123.93416, 39.96999], [-123.93453, 39.96994], [-123.93473, 39.97], [-123.9349, 39.97009], [-123.93534, 39.97044], [-123.93552, 39.97051], [-123.93561, 39.97053], [-123.93572, 39.97053], [-123.93602, 39.97041], [-123.93611, 39.97033], [-123.93616, 39.97023], [-123.93622, 39.97002], [-123.93623, 39.9699], [-123.93631, 39.96977], [-123.93632, 39.96972], [-123.93628, 39.9694], [-123.93644, 39.96925], [-123.93687, 39.96902], [-123.9375, 39.97211], [-123.93799, 39.97583], [-123.9428, 39.97579], [-123.94359, 39.97961], [-123.94441, 39.98342], [-123.94918, 39.98338], [-123.95157, 39.98334], [-123.95371, 39.98337], [-123.95825, 39.98332], [-123.95756, 39.987], [-123.96249, 39.98687]]], [[[-123.95754, 39.97952], [-123.95303, 39.97953], [-123.95211, 39.97581], [-123.95187, 39.97456], [-123.95211, 39.97448], [-123.95233, 39.97451], [-123.95306, 39.97449], [-123.95373, 39.97435], [-123.95416, 39.97434], [-123.95428, 39.97437], [-123.95556, 39.97418], [-123.95569, 39.97402], [-123.95574, 39.97393], [-123.95581, 39.97364], [-123.95589, 39.97346], [-123.95597, 39.97334], [-123.95606, 39.97326], [-123.95616, 39.9732], [-123.95676, 39.97586], [-123.95754, 39.97952]]]]} Open Access 1 21603 Mattole River Ecological Reserve 32214 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/Mattole-River-ER Mendocino 24 1453.144 Mattole River ER 1993 State Conservation Area 8 2
16926 16926 16925 {"type": "Polygon", "coordinates": [[[-123.67585, 39.86241], [-123.67556, 39.87486], [-123.67546, 39.87608], [-123.66682, 39.87604], [-123.65783, 39.87597], [-123.65713, 39.87595], [-123.64776, 39.87607], [-123.64804, 39.87287], [-123.64796, 39.86931], [-123.65257, 39.86915], [-123.65252, 39.86823], [-123.65018, 39.8683], [-123.6502, 39.8676], [-123.64794, 39.86771], [-123.6478, 39.86589], [-123.64302, 39.86603], [-123.64322, 39.8728], [-123.64298, 39.8761], [-123.64382, 39.8761], [-123.64373, 39.8869], [-123.63912, 39.88694], [-123.63453, 39.88701], [-123.63448, 39.89067], [-123.63451, 39.89445], [-123.6299, 39.89439], [-123.62987, 39.89068], [-123.63001, 39.88714], [-123.6205, 39.88727], [-123.62047, 39.88367], [-123.61607, 39.88359], [-123.61609, 39.87995], [-123.61591, 39.87629], [-123.62046, 39.87631], [-123.62508, 39.87627], [-123.62501, 39.8729], [-123.62042, 39.87286], [-123.62037, 39.86924], [-123.61593, 39.86919], [-123.61593, 39.86211], [-123.61588, 39.85855], [-123.61596, 39.85496], [-123.61593, 39.85382], [-123.61593, 39.85146], [-123.62052, 39.85156], [-123.6206, 39.84809], [-123.6254, 39.84806], [-123.62975, 39.84811], [-123.63882, 39.84816], [-123.6388, 39.84454], [-123.64339, 39.84452], [-123.64332, 39.84811], [-123.64321, 39.85176], [-123.64302, 39.86259], [-123.6478, 39.86253], [-123.64782, 39.86589], [-123.65242, 39.86566], [-123.65235, 39.86245], [-123.65734, 39.86238], [-123.67167, 39.86238], [-123.67585, 39.86241]], [[-123.6339, 39.85532], [-123.63389, 39.85531], [-123.62946, 39.85529], [-123.62043, 39.85511], [-123.62028, 39.86222], [-123.62034, 39.86565], [-123.62453, 39.86567], [-123.62946, 39.8659], [-123.62953, 39.86679], [-123.6339, 39.86677], [-123.63381, 39.86255], [-123.6339, 39.85532]], [[-123.63372, 39.87352], [-123.63371, 39.87351], [-123.62953, 39.87358], [-123.62941, 39.87616], [-123.63373, 39.87614], [-123.63372, 39.87352]]]} Restricted Access 2 21600 Little Red Mountain Ecological Reserve 21355 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   Mendocino 24 2942.053 Little Red Mtn. ER 0 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]);