superunits_with_maps

Table actions

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

1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Boden-Canyon-ER"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

ACCESS_TYP 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
14465 14465 14464 {"type": "MultiPolygon", "coordinates": [[[[-116.90585, 33.11018], [-116.90155, 33.11026], [-116.90157, 33.11865], [-116.90158, 33.12098], [-116.893, 33.12095], [-116.89298, 33.12113], [-116.88865, 33.12115], [-116.88869, 33.11726], [-116.88447, 33.11721], [-116.88451, 33.11343], [-116.88871, 33.11335], [-116.88873, 33.11158], [-116.88874, 33.10955], [-116.89293, 33.10949], [-116.89295, 33.1059], [-116.89294, 33.10396], [-116.89507, 33.10392], [-116.89513, 33.10205], [-116.8972, 33.10206], [-116.89725, 33.10587], [-116.90151, 33.10587], [-116.90581, 33.10592], [-116.90585, 33.11018]]], [[[-116.90602, 33.14166], [-116.90394, 33.1416], [-116.90398, 33.14337], [-116.89313, 33.14318], [-116.89299, 33.12481], [-116.90585, 33.12475], [-116.90589, 33.13228], [-116.90595, 33.13816], [-116.90597, 33.14], [-116.90602, 33.14166]]], [[[-116.90576, 33.0914], [-116.90149, 33.09135], [-116.90146, 33.08783], [-116.90156, 33.08786], [-116.9017, 33.08783], [-116.9018, 33.08773], [-116.90181, 33.08767], [-116.90179, 33.0875], [-116.90184, 33.08716], [-116.90182, 33.08706], [-116.90179, 33.08699], [-116.90167, 33.0868], [-116.90162, 33.08667], [-116.90162, 33.08651], [-116.90165, 33.08634], [-116.90165, 33.08626], [-116.90162, 33.08612], [-116.90164, 33.08595], [-116.90163, 33.0858], [-116.90167, 33.08574], [-116.90179, 33.08566], [-116.9019, 33.08552], [-116.90197, 33.08492], [-116.90202, 33.08483], [-116.90215, 33.08466], [-116.9023, 33.08453], [-116.90238, 33.08448], [-116.90246, 33.08447], [-116.90256, 33.08447], [-116.90259, 33.08452], [-116.90262, 33.0848], [-116.90269, 33.08515], [-116.90273, 33.08618], [-116.90278, 33.0863], [-116.90308, 33.08659], [-116.90314, 33.08669], [-116.90319, 33.08681], [-116.90322, 33.08706], [-116.90333, 33.08739], [-116.90339, 33.08778], [-116.90346, 33.08795], [-116.90362, 33.08813], [-116.90373, 33.08816], [-116.90389, 33.08816], [-116.90441, 33.088], [-116.90453, 33.08795], [-116.90466, 33.08785], [-116.90483, 33.08768], [-116.90516, 33.08741], [-116.90576, 33.08682], [-116.90576, 33.0914]]], [[[-116.90576, 33.08661], [-116.90576, 33.08669], [-116.90564, 33.08677], [-116.90549, 33.08689], [-116.90498, 33.08741], [-116.90472, 33.08761], [-116.90456, 33.08779], [-116.90446, 33.08786], [-116.90436, 33.0879], [-116.90391, 33.08805], [-116.90383, 33.08806], [-116.90372, 33.08805], [-116.90357, 33.08788], [-116.90352, 33.08776], [-116.90345, 33.08739], [-116.90333, 33.08696], [-116.90331, 33.08677], [-116.90327, 33.08668], [-116.9032, 33.08656], [-116.9029, 33.08624], [-116.90286, 33.08616], [-116.90283, 33.08516], [-116.90272, 33.08448], [-116.90266, 33.08441], [-116.90256, 33.08436], [-116.90235, 33.08437], [-116.90225, 33.08442], [-116.90206, 33.08459], [-116.90192, 33.08475], [-116.90186, 33.08488], [-116.90183, 33.08498], [-116.90182, 33.08525], [-116.90177, 33.08549], [-116.90171, 33.08557], [-116.90158, 33.08566], [-116.90154, 33.0857], [-116.90152, 33.08576], [-116.90151, 33.08581], [-116.90152, 33.08598], [-116.9015, 33.08614], [-116.90153, 33.08633], [-116.90149, 33.0865], [-116.90149, 33.08667], [-116.90154, 33.08683], [-116.90168, 33.08703], [-116.90171, 33.08714], [-116.90167, 33.08739], [-116.90169, 33.08766], [-116.90167, 33.08769], [-116.90164, 33.08773], [-116.9016, 33.08775], [-116.90146, 33.08771], [-116.90148, 33.08369], [-116.90368, 33.08366], [-116.9037, 33.08404], [-116.90365, 33.08499], [-116.9036, 33.08531], [-116.90351, 33.08566], [-116.90349, 33.08579], [-116.90349, 33.08594], [-116.90358, 33.08641], [-116.9037, 33.08676], [-116.90378, 33.08688], [-116.90391, 33.087], [-116.90412, 33.08713], [-116.90436, 33.0872], [-116.90462, 33.0872], [-116.90481, 33.08716], [-116.90499, 33.0871], [-116.90515, 33.087], [-116.90544, 33.08676], [-116.90559, 33.08668], [-116.90576, 33.08661]]], [[[-116.90576, 33.08644], [-116.90535, 33.08661], [-116.9052, 33.08671], [-116.90501, 33.08688], [-116.9049, 33.08695], [-116.90477, 33.087], [-116.90464, 33.08703], [-116.90443, 33.08704], [-116.9043, 33.08701], [-116.9041, 33.08693], [-116.90395, 33.0868], [-116.90387, 33.08668], [-116.90378, 33.08641], [-116.90369, 33.08603], [-116.90371, 33.08564], [-116.90379, 33.08537], [-116.90384, 33.08502], [-116.9039, 33.08404], [-116.90389, 33.08367], [-116.90575, 33.08365], [-116.90576, 33.08644]]]]} Open Access 1 Boden Canyon Ecological Reserve https://www.wildlife.ca.gov/Lands/Places-to-Visit/Boden-Canyon-ER 32059 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 1257.119 Boden Canyon ER 2000

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