units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, COUNTY = 12 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 1 ✖

ACCESS_TYP 1

  • No Public Access · 1 ✖
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
7851 7851 7850 {"type": "MultiPolygon", "coordinates": [[[[-121.57273, 38.07421], [-121.57253, 38.07435], [-121.57244, 38.07427], [-121.57223, 38.07429], [-121.57214, 38.07419], [-121.57213, 38.07406], [-121.57249, 38.07387], [-121.57253, 38.07388], [-121.57262, 38.07395], [-121.57264, 38.07407], [-121.57273, 38.07421]]], [[[-121.57438, 38.07592], [-121.57429, 38.07601], [-121.57417, 38.07588], [-121.57403, 38.07576], [-121.57388, 38.07574], [-121.57358, 38.07553], [-121.5735, 38.07527], [-121.57326, 38.07524], [-121.57305, 38.07491], [-121.57279, 38.07465], [-121.57278, 38.07453], [-121.57287, 38.07443], [-121.57307, 38.07457], [-121.57321, 38.07458], [-121.57405, 38.07536], [-121.57438, 38.07592]]], [[[-121.5776, 38.08607], [-121.57741, 38.08554], [-121.57727, 38.08444], [-121.57724, 38.08389], [-121.57733, 38.08337], [-121.57746, 38.08346], [-121.57745, 38.08396], [-121.57751, 38.08425], [-121.57749, 38.08464], [-121.57767, 38.08584], [-121.5776, 38.08607]]], [[[-121.57808, 38.09104], [-121.57799, 38.0911], [-121.57781, 38.09088], [-121.57774, 38.09021], [-121.57763, 38.08983], [-121.57766, 38.08935], [-121.57761, 38.08865], [-121.57766, 38.08817], [-121.57755, 38.08796], [-121.57762, 38.08776], [-121.57762, 38.08727], [-121.57778, 38.08728], [-121.5779, 38.08878], [-121.57799, 38.08899], [-121.57792, 38.08934], [-121.57801, 38.09071], [-121.57808, 38.09104]]], [[[-121.5899, 38.09453], [-121.58989, 38.09486], [-121.58973, 38.09589], [-121.58939, 38.09622], [-121.58897, 38.09627], [-121.58864, 38.09617], [-121.5882, 38.09595], [-121.58705, 38.09577], [-121.58672, 38.09542], [-121.5857, 38.09527], [-121.58549, 38.09529], [-121.5826, 38.09443], [-121.58233, 38.0945], [-121.58061, 38.0937], [-121.5785, 38.09293], [-121.57835, 38.09278], [-121.57802, 38.09168], [-121.57889, 38.09293], [-121.58011, 38.09339], [-121.58218, 38.09401], [-121.5847, 38.09464], [-121.58617, 38.09473], [-121.58716, 38.09455], [-121.58773, 38.09456], [-121.58796, 38.09455], [-121.58959, 38.09436], [-121.5899, 38.09453]]], [[[-121.58178, 38.067], [-121.58179, 38.06761], [-121.58168, 38.06822], [-121.58147, 38.06895], [-121.58134, 38.06923], [-121.58111, 38.06951], [-121.58092, 38.07014], [-121.58068, 38.07034], [-121.5807, 38.0705], [-121.58002, 38.07111], [-121.57961, 38.07125], [-121.57935, 38.07124], [-121.57895, 38.07133], [-121.57878, 38.07131], [-121.57977, 38.07038], [-121.58039, 38.06964], [-121.58106, 38.06862], [-121.58131, 38.06808], [-121.58154, 38.06701], [-121.58167, 38.06694], [-121.58178, 38.067]]], [[[-121.58216, 38.06424], [-121.58197, 38.06453], [-121.58194, 38.06504], [-121.58186, 38.06539], [-121.58186, 38.06572], [-121.58162, 38.06595], [-121.58088, 38.06523], [-121.5808, 38.06488], [-121.58107, 38.06439], [-121.58149, 38.06412], [-121.58177, 38.06416], [-121.58203, 38.064], [-121.58216, 38.06424]]], [[[-121.58724, 38.06295], [-121.58641, 38.06282], [-121.5862, 38.06263], [-121.58612, 38.06264], [-121.58593, 38.06269], [-121.58564, 38.06267], [-121.5855, 38.06257], [-121.58538, 38.06255], [-121.58526, 38.06259], [-121.58495, 38.06247], [-121.58475, 38.06254], [-121.58437, 38.06242], [-121.5838, 38.06256], [-121.5832, 38.06266], [-121.58304, 38.06266], [-121.583, 38.06258], [-121.58369, 38.06141], [-121.58387, 38.06134], [-121.584, 38.06137], [-121.58409, 38.06148], [-121.58386, 38.06187], [-121.58387, 38.06202], [-121.58411, 38.06218], [-121.5868, 38.06258], [-121.58724, 38.06295]]], [[[-121.58557, 38.06172], [-121.58514, 38.06154], [-121.58469, 38.06158], [-121.58427, 38.06144], [-121.58419, 38.06133], [-121.58425, 38.0612], [-121.58448, 38.06115], [-121.58557, 38.06172]]], [[[-121.5937, 38.09764], [-121.59334, 38.09764], [-121.59302, 38.09752], [-121.59249, 38.09739], [-121.59246, 38.09726], [-121.59215, 38.09717], [-121.59195, 38.09728], [-121.59174, 38.09705], [-121.59098, 38.09702], [-121.58999, 38.09624], [-121.59005, 38.09541], [-121.59035, 38.09481], [-121.59079, 38.09482], [-121.59117, 38.09494], [-121.59227, 38.09627], [-121.59301, 38.09713], [-121.59357, 38.09738], [-121.5937, 38.09764]]], [[[-121.59882, 38.09928], [-121.59864, 38.0994], [-121.59785, 38.09918], [-121.59713, 38.09895], [-121.59651, 38.09881], [-121.59572, 38.09849], [-121.59553, 38.09836], [-121.5955, 38.09825], [-121.59563, 38.0982], [-121.5962, 38.09836], [-121.59638, 38.09834], [-121.59678, 38.09862], [-121.59782, 38.09883], [-121.59841, 38.09912], [-121.59882, 38.09928]]], [[[-121.60053, 38.06151], [-121.60033, 38.06195], [-121.59998, 38.06206], [-121.5999, 38.0622], [-121.59966, 38.06226], [-121.59936, 38.06251], [-121.59926, 38.06268], [-121.59881, 38.0628], [-121.59961, 38.06179], [-121.60053, 38.06151]]], [[[-121.60806, 38.10138], [-121.6076, 38.10145], [-121.6076, 38.10145], [-121.6076, 38.10136], [-121.60769, 38.10132], [-121.60799, 38.10131], [-121.60806, 38.10138]]], [[[-121.60989, 38.10147], [-121.60957, 38.10149], [-121.60948, 38.10153], [-121.60904, 38.10138], [-121.60954, 38.1012], [-121.60985, 38.10125], [-121.60989, 38.10147]]], [[[-121.61126, 38.10095], [-121.61118, 38.10103], [-121.61072, 38.10119], [-121.61034, 38.10105], [-121.61055, 38.101], [-121.61079, 38.10096], [-121.6111, 38.10089], [-121.61126, 38.10095]]], [[[-121.61288, 38.10063], [-121.61276, 38.10092], [-121.61258, 38.10097], [-121.61249, 38.10087], [-121.61244, 38.10086], [-121.61225, 38.10101], [-121.6121, 38.10104], [-121.61193, 38.10084], [-121.61276, 38.10061], [-121.61288, 38.10063]]], [[[-121.61412, 38.05742], [-121.61397, 38.05759], [-121.61272, 38.05775], [-121.61286, 38.0574], [-121.61328, 38.05654], [-121.61343, 38.05648], [-121.61406, 38.05653], [-121.61412, 38.05742]]], [[[-121.6205, 38.09959], [-121.62046, 38.0999], [-121.61987, 38.10008], [-121.61956, 38.10013], [-121.61933, 38.10004], [-121.61886, 38.10014], [-121.61853, 38.10014], [-121.61841, 38.10008], [-121.61852, 38.0998], [-121.61873, 38.09978], [-121.61907, 38.0998], [-121.61931, 38.09967], [-121.61975, 38.09977], [-121.6205, 38.09959]]], [[[-121.62497, 38.09715], [-121.62482, 38.09769], [-121.62474, 38.09803], [-121.62483, 38.0982], [-121.6246, 38.09836], [-121.62459, 38.09865], [-121.62321, 38.09932], [-121.62282, 38.09933], [-121.62237, 38.09928], [-121.62166, 38.09943], [-121.62152, 38.09938], [-121.62153, 38.09927], [-121.62194, 38.099], [-121.62268, 38.09874], [-121.62306, 38.09863], [-121.62323, 38.09835], [-121.62345, 38.09826], [-121.62439, 38.09766], [-121.62476, 38.09683], [-121.62497, 38.09715]]], [[[-121.63477, 38.05192], [-121.63425, 38.05267], [-121.63414, 38.05269], [-121.63404, 38.0526], [-121.63363, 38.05174], [-121.63254, 38.05089], [-121.63383, 38.05123], [-121.63477, 38.05192]]], [[[-121.64211, 38.05522], [-121.64206, 38.05532], [-121.64172, 38.05532], [-121.63999, 38.05462], [-121.64104, 38.05475], [-121.64211, 38.05522]]], [[[-121.64638, 38.05643], [-121.64622, 38.05645], [-121.6449, 38.05611], [-121.64421, 38.05608], [-121.6435, 38.05581], [-121.64417, 38.05576], [-121.6463, 38.0563], [-121.64638, 38.05637], [-121.64638, 38.05643]]], [[[-121.6496, 38.08237], [-121.64928, 38.08334], [-121.64906, 38.08307], [-121.64874, 38.08293], [-121.64839, 38.08296], [-121.64827, 38.08307], [-121.64771, 38.08367], [-121.64738, 38.0839], [-121.6474, 38.08406], [-121.64715, 38.08433], [-121.64701, 38.0844], [-121.64696, 38.08439], [-121.6469, 38.0842], [-121.64661, 38.08429], [-121.64646, 38.08427], [-121.64648, 38.08417], [-121.64733, 38.08321], [-121.64755, 38.08155], [-121.64778, 38.08123], [-121.64821, 38.08098], [-121.64874, 38.08099], [-121.64903, 38.08103], [-121.64928, 38.08161], [-121.64952, 38.08176], [-121.64942, 38.08191], [-121.6494, 38.082], [-121.6496, 38.08237]]], [[[-121.64859, 38.0804], [-121.64859, 38.0805], [-121.64857, 38.08055], [-121.64759, 38.08076], [-121.64748, 38.08075], [-121.64745, 38.0807], [-121.64756, 38.08053], [-121.64753, 38.08039], [-121.64756, 38.08025], [-121.64755, 38.0801], [-121.64745, 38.08006], [-121.64751, 38.07993], [-121.64761, 38.07919], [-121.64752, 38.07828], [-121.64754, 38.07763], [-121.6476, 38.07735], [-121.64775, 38.07733], [-121.64787, 38.07751], [-121.64782, 38.07778], [-121.648, 38.07848], [-121.64804, 38.07893], [-121.64825, 38.07938], [-121.64831, 38.07955], [-121.64827, 38.07993], [-121.64847, 38.08027], [-121.64859, 38.0804]]], [[[-121.64883, 38.0836], [-121.64827, 38.08394], [-121.64802, 38.08402], [-121.64784, 38.08399], [-121.64783, 38.08394], [-121.64854, 38.08321], [-121.6488, 38.08333], [-121.64883, 38.0836]]], [[[-121.64865, 38.05664], [-121.64863, 38.05681], [-121.64842, 38.05729], [-121.64813, 38.05684], [-121.64821, 38.05657], [-121.64836, 38.05648], [-121.64865, 38.05664]]]]} No Public Access 3 9357 Delta Islands 32148 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   Contra Costa 12 88.012 Delta Islands 0 State Resource Management Area 55 3

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