units_with_maps

Table actions

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

8 rows where ACCESS_TYP = 1, COUNTY = 51 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 8 ✖

ACCESS_TYP 1

  • Open Access · 8 ✖
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
3320 3320 3319 {"type": "MultiPolygon", "coordinates": [[[[-119.66631, 38.70363], [-119.66343, 38.70457], [-119.66544, 38.70837], [-119.6635, 38.709], [-119.66551, 38.7128], [-119.66381, 38.71335], [-119.66357, 38.71294], [-119.66334, 38.71301], [-119.66316, 38.71267], [-119.66149, 38.71321], [-119.6596, 38.70988], [-119.65944, 38.70993], [-119.6592, 38.7095], [-119.65633, 38.71042], [-119.65537, 38.71075], [-119.65746, 38.71453], [-119.65376, 38.71577], [-119.65185, 38.71254], [-119.65178, 38.71255], [-119.6515, 38.71206], [-119.64875, 38.71298], [-119.64687, 38.70973], [-119.64878, 38.70903], [-119.64852, 38.70858], [-119.64669, 38.7051], [-119.64866, 38.70441], [-119.64787, 38.70305], [-119.65158, 38.70175], [-119.65135, 38.70135], [-119.65149, 38.7013], [-119.6515, 38.70128], [-119.65019, 38.6988], [-119.65493, 38.69704], [-119.65418, 38.69572], [-119.66371, 38.69226], [-119.66522, 38.69511], [-119.66035, 38.69666], [-119.66236, 38.70045], [-119.66253, 38.7004], [-119.66268, 38.70066], [-119.66439, 38.70001], [-119.66631, 38.70363]]], [[[-119.75141, 38.82304], [-119.75141, 38.82346], [-119.74497, 38.82344], [-119.73292, 38.81524], [-119.73293, 38.81048], [-119.75141, 38.82304]]]]} Open Access 1 23565 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Alpine 51 801.152 SLC 0 State Resource Management Area 55 3
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
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
15605 15605 15604 {"type": "Polygon", "coordinates": [[[-119.72836, 38.76932], [-119.72373, 38.76933], [-119.7237, 38.76577], [-119.72821, 38.76567], [-119.72836, 38.76932]]]} Open Access 1 20782 East Fork Carson River Fishing Access 32153 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 39.271 East Fork Carson River FA 0 State Recreation Area 39 4
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
16362 16362 16361 {"type": "Polygon", "coordinates": [[[-119.89135, 38.76567], [-119.89129, 38.77295], [-119.88657, 38.7729], [-119.88658, 38.76567], [-119.89135, 38.76567]]]} Open Access 1 44766 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Alpine 51 82.078 SLC 0 State Resource Management Area 55 3
16585 16585 16584 {"type": "MultiPolygon", "coordinates": [[[[-119.81188, 38.62827], [-119.81177, 38.63168], [-119.80886, 38.63167], [-119.809, 38.62826], [-119.81188, 38.62827]]], [[[-119.82776, 38.70943], [-119.82704, 38.70943], [-119.82703, 38.70945], [-119.82296, 38.70944], [-119.82299, 38.70571], [-119.82295, 38.70221], [-119.82715, 38.70214], [-119.82716, 38.70213], [-119.82772, 38.70211], [-119.82776, 38.70567], [-119.82776, 38.70943]]], [[[-119.8266, 38.69544], [-119.82656, 38.69632], [-119.82542, 38.69635], [-119.82541, 38.6968], [-119.82362, 38.6968], [-119.82361, 38.69672], [-119.82346, 38.69672], [-119.82346, 38.69537], [-119.82524, 38.69538], [-119.82523, 38.69545], [-119.8266, 38.69544]]], [[[-119.84591, 38.70211], [-119.84419, 38.7021], [-119.84419, 38.70386], [-119.84131, 38.70386], [-119.84132, 38.70923], [-119.83671, 38.70923], [-119.83669, 38.70563], [-119.83209, 38.70565], [-119.83204, 38.69857], [-119.832, 38.69632], [-119.8325, 38.6963], [-119.83288, 38.69624], [-119.83324, 38.69616], [-119.83505, 38.69565], [-119.83572, 38.69551], [-119.83664, 38.69535], [-119.83665, 38.69502], [-119.84582, 38.69513], [-119.84591, 38.70211]]], [[[-119.86428, 38.70565], [-119.85967, 38.70569], [-119.85963, 38.70212], [-119.86424, 38.70207], [-119.86428, 38.70565]]], [[[-119.86883, 38.6984], [-119.86422, 38.69848], [-119.86419, 38.69491], [-119.8688, 38.69479], [-119.86883, 38.6984]]]]} Open Access 1 20481 Grover Hot Springs State Park 1553 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=508 Alpine 51 547.314 Grover Hot Springs SP 1959 State Park 15 4

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