superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 25 and PARK_NAME = "Mad River Slough Wildlife Area"

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
11905 11905 11904 {"type": "MultiPolygon", "coordinates": [[[[-124.12531, 40.85813], [-124.12529, 40.86476], [-124.12073, 40.86481], [-124.1207, 40.86395], [-124.11999, 40.86397], [-124.12001, 40.86482], [-124.10588, 40.86488], [-124.10584, 40.86837], [-124.1025, 40.86836], [-124.10117, 40.86831], [-124.1012, 40.86756], [-124.10229, 40.86745], [-124.10234, 40.86726], [-124.10239, 40.86695], [-124.10243, 40.86646], [-124.10275, 40.86627], [-124.10283, 40.86624], [-124.10292, 40.86618], [-124.10298, 40.86611], [-124.1031, 40.86585], [-124.10311, 40.8658], [-124.10308, 40.86571], [-124.10302, 40.86563], [-124.10292, 40.86556], [-124.10247, 40.8652], [-124.10243, 40.86513], [-124.10241, 40.86497], [-124.10237, 40.86492], [-124.10226, 40.86484], [-124.10189, 40.86465], [-124.10168, 40.86419], [-124.10253, 40.86395], [-124.10277, 40.86358], [-124.10279, 40.86351], [-124.10288, 40.8634], [-124.10312, 40.86323], [-124.10327, 40.86308], [-124.1033, 40.86301], [-124.10337, 40.86274], [-124.10334, 40.86264], [-124.10303, 40.86232], [-124.1029, 40.8623], [-124.10278, 40.86232], [-124.10268, 40.86237], [-124.10223, 40.86276], [-124.10192, 40.8629], [-124.10182, 40.8629], [-124.10161, 40.86288], [-124.10142, 40.86281], [-124.10128, 40.86273], [-124.10121, 40.86266], [-124.10088, 40.86186], [-124.10042, 40.86097], [-124.10041, 40.86063], [-124.10043, 40.86052], [-124.10064, 40.86045], [-124.10088, 40.86046], [-124.10134, 40.86058], [-124.10146, 40.86053], [-124.10141, 40.86041], [-124.10135, 40.86038], [-124.10107, 40.86017], [-124.10103, 40.86007], [-124.10107, 40.85986], [-124.10199, 40.86019], [-124.10285, 40.86056], [-124.10337, 40.86051], [-124.10398, 40.86006], [-124.10443, 40.85988], [-124.10464, 40.85949], [-124.10497, 40.85905], [-124.10569, 40.85852], [-124.10587, 40.85835], [-124.10595, 40.85874], [-124.10608, 40.859], [-124.1061, 40.859], [-124.1064, 40.85874], [-124.10655, 40.85863], [-124.1065, 40.85849], [-124.1064, 40.85829], [-124.10641, 40.85814], [-124.10647, 40.85809], [-124.10693, 40.85811], [-124.1074, 40.85832], [-124.10865, 40.85833], [-124.10875, 40.85819], [-124.10886, 40.85816], [-124.10905, 40.85799], [-124.10931, 40.8578], [-124.10928, 40.85765], [-124.10914, 40.85764], [-124.10974, 40.8568], [-124.10988, 40.85672], [-124.11054, 40.85674], [-124.11169, 40.85578], [-124.11169, 40.85544], [-124.11172, 40.85543], [-124.11243, 40.85541], [-124.11487, 40.85342], [-124.11565, 40.85276], [-124.11701, 40.85267], [-124.11805, 40.85275], [-124.11907, 40.85304], [-124.11935, 40.8532], [-124.11956, 40.85342], [-124.11963, 40.85357], [-124.11999, 40.85391], [-124.12015, 40.85405], [-124.12067, 40.85445], [-124.12138, 40.85505], [-124.12176, 40.85527], [-124.12223, 40.85549], [-124.12242, 40.85561], [-124.12267, 40.85581], [-124.12284, 40.85593], [-124.12326, 40.85627], [-124.1234, 40.85636], [-124.1239, 40.85647], [-124.12405, 40.85648], [-124.1243, 40.85655], [-124.12443, 40.85661], [-124.12468, 40.85685], [-124.12487, 40.8575], [-124.12525, 40.85808], [-124.12531, 40.85813]]], [[[-124.15789, 40.85899], [-124.15628, 40.8612], [-124.15561, 40.8612], [-124.1556, 40.86125], [-124.15588, 40.86147], [-124.15586, 40.8615], [-124.15592, 40.86154], [-124.15535, 40.86197], [-124.15547, 40.86215], [-124.1549, 40.86228], [-124.15478, 40.86246], [-124.15477, 40.8625], [-124.15446, 40.86278], [-124.1536, 40.8635], [-124.15328, 40.86368], [-124.15308, 40.86328], [-124.15303, 40.86305], [-124.15296, 40.86291], [-124.15255, 40.86254], [-124.15182, 40.86135], [-124.1513, 40.86072], [-124.15097, 40.8604], [-124.15067, 40.86004], [-124.15025, 40.85945], [-124.15012, 40.85909], [-124.15008, 40.85888], [-124.1501, 40.8587], [-124.15018, 40.85856], [-124.15044, 40.85837], [-124.15079, 40.85837], [-124.15164, 40.8585], [-124.1518, 40.85849], [-124.15212, 40.85846], [-124.1524, 40.85838], [-124.15395, 40.85782], [-124.15432, 40.85766], [-124.15463, 40.85748], [-124.15518, 40.85725], [-124.15548, 40.85719], [-124.15612, 40.85727], [-124.15655, 40.85738], [-124.15646, 40.85747], [-124.15721, 40.85805], [-124.15757, 40.85832], [-124.15753, 40.85846], [-124.15712, 40.85905], [-124.15789, 40.85899]]]]} Open Access 1 Mad River Slough Wildlife Area https://www.wildlife.ca.gov/Lands/Places-to-Visit/Mad-River-Slough-WA 30469 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 564.749 Mad River Slough Wildlife Area 1989

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);