units_with_maps

Table actions

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

5 rows where COUNTY = 51, DES_TP = 8 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • State Agency · 5 ✖

DES_TP 1

  • State Conservation Area · 5 ✖
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
3146 3146 3145 {"type": "MultiPolygon", "coordinates": [[[[-119.59583, 38.57678], [-119.59581, 38.58119], [-119.5958, 38.58194], [-119.59564, 38.58174], [-119.59533, 38.58142], [-119.595, 38.58092], [-119.59477, 38.58071], [-119.59399, 38.58033], [-119.59373, 38.58025], [-119.59347, 38.58012], [-119.59267, 38.57962], [-119.59227, 38.5792], [-119.5921, 38.57897], [-119.59194, 38.57871], [-119.59185, 38.57861], [-119.5917, 38.57817], [-119.59165, 38.57793], [-119.59159, 38.57737], [-119.59122, 38.57651], [-119.59583, 38.57678]]], [[[-119.59585, 38.59055], [-119.59576, 38.59048], [-119.5955, 38.59013], [-119.59536, 38.58982], [-119.5953, 38.5896], [-119.5951, 38.58914], [-119.59489, 38.58855], [-119.59481, 38.58787], [-119.59481, 38.58753], [-119.59486, 38.58703], [-119.59482, 38.58624], [-119.59487, 38.58572], [-119.59505, 38.58513], [-119.59543, 38.58417], [-119.59564, 38.5837], [-119.59573, 38.58345], [-119.59574, 38.58324], [-119.59579, 38.58309], [-119.59579, 38.58396], [-119.59585, 38.59055]]], [[[-119.59594, 38.58261], [-119.59594, 38.58261], [-119.59594, 38.58261], [-119.59594, 38.58261], [-119.59594, 38.58261]]]]} Open Access 1 21612 Slinkard / Little Antelope Wildlife Area 30505 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/Slinkard-Little-Antelope-WA Alpine 51 47.817 Slinkard / Little Antelope Wildlife Area 1979 State Conservation Area 8 2
5517 5517 5516 {"type": "MultiPolygon", "coordinates": [[[[-119.95634, 38.71971], [-119.95634, 38.72329], [-119.95166, 38.72325], [-119.95168, 38.71982], [-119.95175, 38.71981], [-119.95176, 38.71976], [-119.95627, 38.71969], [-119.95628, 38.71971], [-119.95634, 38.71971]]], [[[-119.96098, 38.70512], [-119.956, 38.70507], [-119.95595, 38.70137], [-119.96086, 38.70139], [-119.96093, 38.70508], [-119.96098, 38.70512]]], [[[-119.96537, 38.68314], [-119.96078, 38.68316], [-119.96075, 38.68315], [-119.96072, 38.67619], [-119.96075, 38.67616], [-119.96075, 38.67577], [-119.96525, 38.67573], [-119.96537, 38.68314]]], [[[-119.98409, 38.70137], [-119.97475, 38.70153], [-119.97477, 38.70426], [-119.97402, 38.7044], [-119.97321, 38.70452], [-119.97231, 38.70459], [-119.97089, 38.7048], [-119.97027, 38.70492], [-119.96945, 38.70491], [-119.96901, 38.70476], [-119.96813, 38.7044], [-119.96786, 38.70425], [-119.9676, 38.70404], [-119.96738, 38.70379], [-119.96725, 38.70359], [-119.96708, 38.70327], [-119.96695, 38.70295], [-119.96687, 38.70217], [-119.96678, 38.70021], [-119.96673, 38.69977], [-119.96657, 38.69949], [-119.96636, 38.69929], [-119.96612, 38.69909], [-119.96605, 38.69839], [-119.966, 38.69814], [-119.96588, 38.69785], [-119.96569, 38.69744], [-119.96549, 38.69717], [-119.96524, 38.69701], [-119.9652, 38.69405], [-119.96079, 38.69407], [-119.96075, 38.6904], [-119.96977, 38.69038], [-119.96975, 38.68689], [-119.97469, 38.68689], [-119.9747, 38.69405], [-119.98407, 38.69397], [-119.98409, 38.70137]]], [[[-119.96575, 38.74152], [-119.961, 38.74152], [-119.96102, 38.7379], [-119.96097, 38.73427], [-119.961, 38.73427], [-119.96102, 38.73424], [-119.96108, 38.73424], [-119.96113, 38.73428], [-119.96569, 38.73427], [-119.96575, 38.74152]]], [[[-119.97452, 38.67576], [-119.96983, 38.67573], [-119.96489, 38.67568], [-119.96485, 38.67263], [-119.97445, 38.67245], [-119.97452, 38.67576]]]]} Open Access 1 22165 Red Lake Wildlife Area 30491 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/Red-Lake-WA Alpine 51 861.648 Red Lake Wildlife Area 1988 State Conservation Area 8 2
10876 10876 10875 {"type": "MultiPolygon", "coordinates": [[[[-119.80682, 38.86625], [-119.79722, 38.85963], [-119.8053, 38.85961], [-119.79472, 38.85244], [-119.79749, 38.85241], [-119.7975, 38.84901], [-119.8067, 38.849], [-119.8068, 38.85962], [-119.80682, 38.86625]]], [[[-119.81138, 38.86695], [-119.81131, 38.86934], [-119.80784, 38.86695], [-119.81138, 38.86695], [-119.81138, 38.86695]]], [[[-119.82541, 38.8742], [-119.82076, 38.8742], [-119.82075, 38.86696], [-119.82536, 38.86696], [-119.82541, 38.8742]]]]} Restricted Access 2 20781 Fay Canyon Wildlife Area 18856 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   Alpine 51 356.586 Fay Canyon Wildlife Area 0 State Conservation Area 8 2
10881 10881 10880 {"type": "MultiPolygon", "coordinates": [[[[-119.9415, 38.78188], [-119.93669, 38.78193], [-119.9367, 38.78558], [-119.93216, 38.78569], [-119.93225, 38.79296], [-119.93675, 38.79297], [-119.93688, 38.79666], [-119.93223, 38.7967], [-119.93237, 38.80739], [-119.90078, 38.80744], [-119.90069, 38.8021], [-119.90051, 38.79664], [-119.90049, 38.79482], [-119.9005, 38.79293], [-119.9005, 38.78571], [-119.91313, 38.78565], [-119.91284, 38.7781], [-119.90367, 38.77831], [-119.90368, 38.77491], [-119.93212, 38.77478], [-119.93218, 38.77117], [-119.93685, 38.77116], [-119.93687, 38.7748], [-119.94149, 38.77481], [-119.9415, 38.78188]], [[-119.91769, 38.79281], [-119.91765, 38.78919], [-119.91298, 38.78919], [-119.91293, 38.79293], [-119.91768, 38.79293], [-119.91769, 38.79281]], [[-119.92264, 38.78562], [-119.92263, 38.78561], [-119.91768, 38.78554], [-119.91766, 38.78919], [-119.92258, 38.78922], [-119.92264, 38.78562]]], [[[-119.94131, 38.71713], [-119.9391, 38.71751], [-119.93822, 38.71414], [-119.94031, 38.71353], [-119.94131, 38.71713]]], [[[-119.95643, 38.74524], [-119.95181, 38.74522], [-119.95191, 38.75984], [-119.94729, 38.75991], [-119.94725, 38.75254], [-119.94271, 38.75251], [-119.94259, 38.74885], [-119.94725, 38.74883], [-119.9472, 38.74525], [-119.94258, 38.74525], [-119.94254, 38.73835], [-119.94724, 38.73835], [-119.94714, 38.73053], [-119.95093, 38.73053], [-119.95094, 38.73064], [-119.95166, 38.73063], [-119.95171, 38.73432], [-119.95182, 38.73433], [-119.95184, 38.7379], [-119.95638, 38.73789], [-119.95643, 38.74524]]]]} Open Access 1 20780 Hope Valley Wildlife Area 30455 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/Hope-Valley-WA Alpine 51 2943.748 Hope Valley Wildlife Area 1989 State Conservation Area 8 2
16277 16277 16276 {"type": "Polygon", "coordinates": [[[-119.66865, 38.66286], [-119.65953, 38.66295], [-119.65059, 38.66299], [-119.64097, 38.66305], [-119.63176, 38.66296], [-119.62739, 38.663], [-119.62274, 38.663], [-119.62279, 38.65938], [-119.63176, 38.65931], [-119.63167, 38.65577], [-119.63616, 38.65566], [-119.63601, 38.65204], [-119.64056, 38.65198], [-119.6498, 38.65179], [-119.6495, 38.64812], [-119.65431, 38.64829], [-119.65412, 38.64097], [-119.65439, 38.64097], [-119.6544, 38.64096], [-119.65419, 38.63732], [-119.65398, 38.63731], [-119.65383, 38.63367], [-119.66704, 38.63358], [-119.66786, 38.64086], [-119.6685, 38.64808], [-119.66862, 38.65551], [-119.66865, 38.66286]]]} Open Access 1 20784 Heenan Lake Wildlife Area 30447 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/Heenan-Lake-WA Alpine 51 1655.526 Heenan Lake Wildlife Area 1983 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]);