units_with_maps

Table actions

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

2 rows where COUNTY = 2, DES_TP = 8 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 2 ✖

DES_TP 1

  • State Conservation Area · 2 ✖

ACCESS_TYP 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
5955 5955 5954 {"type": "Polygon", "coordinates": [[[-120.98655, 37.40316], [-120.98645, 37.4037], [-120.9858, 37.40327], [-120.98326, 37.4014], [-120.98204, 37.40081], [-120.98154, 37.40063], [-120.98443, 37.39949], [-120.98456, 37.39989], [-120.98467, 37.40012], [-120.98472, 37.40027], [-120.98493, 37.40061], [-120.98501, 37.40078], [-120.98513, 37.40095], [-120.98522, 37.40114], [-120.98557, 37.40154], [-120.98567, 37.40168], [-120.98599, 37.40248], [-120.98621, 37.40281], [-120.98643, 37.40306], [-120.98655, 37.40316]]]} Open Access 1 518 West Hilmar Wildlife Area 30516 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/West-Hilmar-WA Stanislaus 2 16.656 West Hilmar Wildlife Area 1994 State Conservation Area 8 2
16685 16685 16684 {"type": "MultiPolygon", "coordinates": [[[[-120.97841, 37.3416], [-120.97836, 37.34177], [-120.97784, 37.34216], [-120.97724, 37.34226], [-120.97631, 37.34346], [-120.97602, 37.34421], [-120.97597, 37.34438], [-120.97593, 37.34444], [-120.97592, 37.34454], [-120.97571, 37.34488], [-120.97566, 37.34507], [-120.97566, 37.34529], [-120.97585, 37.34562], [-120.97595, 37.3457], [-120.9761, 37.34578], [-120.97616, 37.34583], [-120.97623, 37.34593], [-120.97631, 37.34599], [-120.97645, 37.34618], [-120.9765, 37.34622], [-120.97653, 37.3465], [-120.97648, 37.34664], [-120.97638, 37.34675], [-120.97592, 37.34681], [-120.97522, 37.34713], [-120.97439, 37.34803], [-120.97413, 37.34834], [-120.97409, 37.349], [-120.97401, 37.34925], [-120.97384, 37.34926], [-120.9733, 37.34921], [-120.97302, 37.34913], [-120.97249, 37.34892], [-120.97213, 37.34876], [-120.97184, 37.3486], [-120.97152, 37.34829], [-120.97138, 37.34808], [-120.97134, 37.34775], [-120.97134, 37.34749], [-120.97126, 37.34733], [-120.97109, 37.34711], [-120.96997, 37.34605], [-120.96958, 37.34575], [-120.96932, 37.34557], [-120.96885, 37.34538], [-120.9684, 37.34534], [-120.96801, 37.34533], [-120.96768, 37.34541], [-120.96728, 37.34554], [-120.96644, 37.34592], [-120.966, 37.34606], [-120.9657, 37.34614], [-120.96509, 37.34611], [-120.96489, 37.34605], [-120.96472, 37.34591], [-120.96458, 37.34575], [-120.96456, 37.3457], [-120.96414, 37.34562], [-120.96368, 37.34567], [-120.96483, 37.34478], [-120.96516, 37.34488], [-120.96913, 37.34174], [-120.97186, 37.33963], [-120.97223, 37.34008], [-120.9724, 37.34033], [-120.97254, 37.34045], [-120.9729, 37.34067], [-120.97314, 37.34073], [-120.97354, 37.34078], [-120.97394, 37.34076], [-120.97433, 37.34066], [-120.97448, 37.34049], [-120.9746, 37.34029], [-120.97481, 37.34028], [-120.97511, 37.34037], [-120.97545, 37.34056], [-120.97565, 37.34081], [-120.97561, 37.34127], [-120.97572, 37.34147], [-120.97589, 37.34162], [-120.97629, 37.34168], [-120.97656, 37.34166], [-120.97675, 37.34156], [-120.97696, 37.34126], [-120.97724, 37.34099], [-120.97745, 37.34086], [-120.97767, 37.3408], [-120.97841, 37.3416]]], [[[-120.98615, 37.33757], [-120.98331, 37.3402], [-120.98007, 37.33795], [-120.97985, 37.33808], [-120.97922, 37.33829], [-120.97886, 37.33864], [-120.9787, 37.33868], [-120.97846, 37.33862], [-120.97829, 37.33845], [-120.97835, 37.33802], [-120.9782, 37.33758], [-120.97827, 37.33732], [-120.97864, 37.33699], [-120.9787, 37.33671], [-120.97849, 37.33651], [-120.97757, 37.33614], [-120.97721, 37.33617], [-120.97642, 37.33657], [-120.97703, 37.33682], [-120.97706, 37.33694], [-120.97694, 37.33726], [-120.9765, 37.3376], [-120.97605, 37.33773], [-120.97615, 37.33803], [-120.97617, 37.3384], [-120.97616, 37.33881], [-120.97622, 37.33908], [-120.97606, 37.33931], [-120.97641, 37.33963], [-120.97653, 37.33999], [-120.9768, 37.34041], [-120.97736, 37.34051], [-120.97778, 37.34046], [-120.97722, 37.34065], [-120.97696, 37.34083], [-120.97683, 37.34099], [-120.97666, 37.34109], [-120.9765, 37.34136], [-120.97641, 37.3414], [-120.9763, 37.34142], [-120.97606, 37.34137], [-120.97598, 37.34132], [-120.97594, 37.34122], [-120.97599, 37.34099], [-120.97599, 37.34083], [-120.9759, 37.34057], [-120.97565, 37.34034], [-120.97522, 37.34011], [-120.97487, 37.34], [-120.97475, 37.33999], [-120.97453, 37.34002], [-120.97436, 37.34007], [-120.9743, 37.34013], [-120.97421, 37.34031], [-120.97413, 37.3404], [-120.97404, 37.34044], [-120.97388, 37.34049], [-120.97357, 37.3405], [-120.97322, 37.34047], [-120.97311, 37.34045], [-120.97279, 37.34026], [-120.97265, 37.34015], [-120.97252, 37.33994], [-120.97224, 37.3396], [-120.97211, 37.33943], [-120.975, 37.33717], [-120.97945, 37.33371], [-120.98484, 37.33624], [-120.98615, 37.33757]]]]} Open Access 1 493 North Grasslands Wildlife Area 30482 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/North-Grasslands-WA Stanislaus 2 253.111 North Grasslands Wildlife Area 1992 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]);