units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1, COUNTY = 24 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 4 ✖
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
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
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

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]);