units_with_maps

Table actions

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

2 rows where COUNTY = 39, DES_TP = 55 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 Resource Management 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
5484 5484 5483 {"type": "Polygon", "coordinates": [[[-121.45171, 37.99673], [-121.45157, 37.99753], [-121.45125, 37.99803], [-121.44772, 37.99697], [-121.449, 37.99516], [-121.45045, 37.99469], [-121.45112, 37.99482], [-121.4517, 37.99592], [-121.45175, 37.99649], [-121.45171, 37.99673]]]} No Public Access 3 18030 Acker Island 32009 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   San Joaquin 39 20.966 Acker Island 0 State Resource Management Area 55 3
10291 10291 10290 {"type": "Polygon", "coordinates": [[[-121.32414, 38.16873], [-121.32419, 38.16888], [-121.3242, 38.16903], [-121.32407, 38.16947], [-121.32391, 38.16971], [-121.32379, 38.16982], [-121.32359, 38.16992], [-121.32342, 38.16995], [-121.32332, 38.16994], [-121.32316, 38.16995], [-121.3231, 38.17], [-121.32285, 38.17029], [-121.32276, 38.17044], [-121.32275, 38.17058], [-121.32279, 38.17069], [-121.32322, 38.17134], [-121.32325, 38.17142], [-121.32323, 38.17154], [-121.32317, 38.17165], [-121.32301, 38.1718], [-121.32293, 38.17185], [-121.32273, 38.17193], [-121.32219, 38.17208], [-121.32157, 38.17221], [-121.32149, 38.17221], [-121.32132, 38.17227], [-121.321, 38.17242], [-121.32093, 38.17249], [-121.32064, 38.17281], [-121.32037, 38.17315], [-121.32031, 38.17332], [-121.3203, 38.17346], [-121.32031, 38.17362], [-121.3204, 38.17381], [-121.32051, 38.17395], [-121.32084, 38.17416], [-121.32115, 38.17431], [-121.3212, 38.17437], [-121.32119, 38.17444], [-121.321, 38.17452], [-121.32034, 38.17474], [-121.32021, 38.17476], [-121.32008, 38.17476], [-121.31994, 38.17473], [-121.31948, 38.17456], [-121.31929, 38.17442], [-121.31919, 38.17419], [-121.31922, 38.17414], [-121.31932, 38.17405], [-121.3194, 38.17407], [-121.31944, 38.17418], [-121.31956, 38.17418], [-121.3197, 38.17405], [-121.3198, 38.17387], [-121.31977, 38.17379], [-121.31972, 38.17372], [-121.31963, 38.17368], [-121.31953, 38.17369], [-121.31937, 38.17375], [-121.31924, 38.17373], [-121.31916, 38.17369], [-121.31911, 38.17365], [-121.31899, 38.17308], [-121.31922, 38.1731], [-121.31946, 38.17269], [-121.32024, 38.17242], [-121.32033, 38.17241], [-121.3206, 38.1725], [-121.32075, 38.17234], [-121.321, 38.17241], [-121.32131, 38.17205], [-121.32184, 38.17185], [-121.3227, 38.17159], [-121.32277, 38.17145], [-121.3227, 38.17127], [-121.32253, 38.17112], [-121.32241, 38.17081], [-121.3224, 38.17059], [-121.32249, 38.17038], [-121.32264, 38.17018], [-121.32286, 38.17], [-121.32309, 38.16986], [-121.32336, 38.16973], [-121.32344, 38.16953], [-121.32338, 38.16949], [-121.32249, 38.16966], [-121.32201, 38.16966], [-121.32149, 38.1697], [-121.32108, 38.16967], [-121.32088, 38.16929], [-121.32072, 38.16927], [-121.32054, 38.16927], [-121.32008, 38.16898], [-121.31985, 38.16888], [-121.31981, 38.1688], [-121.31971, 38.16885], [-121.31956, 38.1688], [-121.31923, 38.16878], [-121.31877, 38.16894], [-121.31816, 38.16903], [-121.31734, 38.16903], [-121.31667, 38.16922], [-121.31617, 38.16947], [-121.31573, 38.16964], [-121.31536, 38.1698], [-121.31491, 38.16981], [-121.31437, 38.16958], [-121.31441, 38.16952], [-121.31472, 38.16966], [-121.31492, 38.16972], [-121.31507, 38.16975], [-121.31545, 38.16967], [-121.31564, 38.1696], [-121.31622, 38.16927], [-121.31636, 38.16916], [-121.31652, 38.169], [-121.31696, 38.16867], [-121.3173, 38.16855], [-121.31772, 38.16846], [-121.3179, 38.16843], [-121.31823, 38.16843], [-121.31837, 38.16844], [-121.31866, 38.1685], [-121.31879, 38.16862], [-121.31906, 38.16862], [-121.31944, 38.16861], [-121.3197, 38.16857], [-121.31994, 38.16851], [-121.32027, 38.16837], [-121.32037, 38.16836], [-121.32044, 38.16837], [-121.32054, 38.16842], [-121.3206, 38.16848], [-121.32064, 38.16853], [-121.32069, 38.16867], [-121.32069, 38.16884], [-121.32062, 38.16915], [-121.32079, 38.16925], [-121.32098, 38.16933], [-121.32187, 38.16946], [-121.32214, 38.16945], [-121.32247, 38.16941], [-121.32293, 38.16928], [-121.32321, 38.16915], [-121.32351, 38.16893], [-121.32385, 38.16874], [-121.32399, 38.16869], [-121.32414, 38.16873]]]} No Public Access 3 18085 Mokelumne River 32229 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   San Joaquin 39 18.457 Mokelumne River 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]);