units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 26 and DES_TP = 55

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open 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
14181 14181 14180 {"type": "Polygon", "coordinates": [[[-121.66704, 38.30674], [-121.66711, 38.29215], [-121.66689, 38.29214], [-121.66479, 38.28461], [-121.66567, 38.28461], [-121.66546, 38.28383], [-121.66512, 38.28384], [-121.66506, 38.2834], [-121.66532, 38.28258], [-121.6652, 38.28236], [-121.66582, 38.2792], [-121.66565, 38.27778], [-121.66604, 38.27487], [-121.66586, 38.2745], [-121.6662, 38.27417], [-121.66682, 38.27319], [-121.66798, 38.27229], [-121.66873, 38.27113], [-121.66893, 38.27056], [-121.67055, 38.26728], [-121.67071, 38.26663], [-121.67115, 38.26627], [-121.67166, 38.26594], [-121.67172, 38.26571], [-121.67128, 38.26549], [-121.67108, 38.2653], [-121.67117, 38.26509], [-121.67135, 38.26481], [-121.67137, 38.26456], [-121.6713, 38.26404], [-121.67114, 38.26361], [-121.67086, 38.26332], [-121.671, 38.2631], [-121.67108, 38.26268], [-121.6708, 38.26223], [-121.6711, 38.26175], [-121.67118, 38.26061], [-121.67141, 38.25938], [-121.6719, 38.25794], [-121.67193, 38.25681], [-121.67226, 38.25623], [-121.67221, 38.25603], [-121.67205, 38.25592], [-121.67175, 38.25486], [-121.67171, 38.2545], [-121.6722, 38.25419], [-121.67289, 38.25384], [-121.67332, 38.2534], [-121.67328, 38.25262], [-121.6734, 38.25189], [-121.67488, 38.24991], [-121.67537, 38.2491], [-121.67571, 38.24824], [-121.67615, 38.24774], [-121.67768, 38.24681], [-121.67798, 38.24622], [-121.67884, 38.24467], [-121.6796, 38.24357], [-121.67995, 38.24296], [-121.68045, 38.24277], [-121.68096, 38.24265], [-121.68156, 38.2422], [-121.68197, 38.24163], [-121.6821, 38.24018], [-121.6823, 38.23991], [-121.68291, 38.23965], [-121.6835, 38.23914], [-121.68373, 38.23907], [-121.68396, 38.23915], [-121.68414, 38.23999], [-121.68443, 38.24064], [-121.68682, 38.2428], [-121.68722, 38.24331], [-121.6874, 38.24379], [-121.68732, 38.2444], [-121.68723, 38.2447], [-121.68625, 38.24654], [-121.68615, 38.24708], [-121.68627, 38.2481], [-121.68604, 38.24866], [-121.68596, 38.24898], [-121.68645, 38.24994], [-121.6867, 38.25102], [-121.68674, 38.25173], [-121.68639, 38.25299], [-121.68645, 38.25409], [-121.68668, 38.25514], [-121.68686, 38.25555], [-121.68787, 38.25645], [-121.68873, 38.25706], [-121.6907, 38.25773], [-121.69112, 38.25798], [-121.69112, 38.25842], [-121.69098, 38.25908], [-121.69069, 38.26088], [-121.69048, 38.26148], [-121.69042, 38.26187], [-121.69038, 38.26242], [-121.69017, 38.26295], [-121.69025, 38.26341], [-121.69106, 38.26589], [-121.69161, 38.26645], [-121.69192, 38.26775], [-121.69201, 38.26829], [-121.69176, 38.26862], [-121.6915, 38.26951], [-121.69164, 38.27004], [-121.69274, 38.27049], [-121.69295, 38.27093], [-121.69269, 38.27144], [-121.6924, 38.27197], [-121.69227, 38.27236], [-121.69283, 38.27315], [-121.69344, 38.27387], [-121.69361, 38.27471], [-121.69394, 38.27552], [-121.69417, 38.27629], [-121.69443, 38.27699], [-121.69449, 38.27782], [-121.69429, 38.27817], [-121.69371, 38.27938], [-121.69339, 38.27988], [-121.69231, 38.28247], [-121.69222, 38.28336], [-121.69228, 38.28474], [-121.69337, 38.28475], [-121.6934, 38.28572], [-121.69344, 38.2912], [-121.69345, 38.30007], [-121.69343, 38.30224], [-121.69348, 38.3024], [-121.69346, 38.30395], [-121.69348, 38.3055], [-121.69345, 38.30655], [-121.69172, 38.30635], [-121.69169, 38.30626], [-121.69052, 38.30645], [-121.67593, 38.30641], [-121.67594, 38.30653], [-121.69054, 38.30657], [-121.69123, 38.30649], [-121.69181, 38.30646], [-121.6932, 38.3066], [-121.69345, 38.30671], [-121.69341, 38.31443], [-121.66772, 38.31408], [-121.66723, 38.31409], [-121.66704, 38.30674]]]} Open Access 1 43100 Liberty Island 32352 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/Liberty-Island-ER Solano 26 3873.908 Liberty Island 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]);