units_with_maps

Table actions

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

2 rows where LABEL_NAME = "West Hilmar Wildlife Area", MNG_AGENCY = 25 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 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
5057 5057 5056 {"type": "Polygon", "coordinates": [[[-120.99196, 37.38334], [-120.99213, 37.38331], [-120.99237, 37.38332], [-120.99268, 37.3835], [-120.99332, 37.38392], [-120.99352, 37.38418], [-120.99381, 37.38476], [-120.99395, 37.38514], [-120.99406, 37.38552], [-120.9941, 37.38597], [-120.99412, 37.38649], [-120.99404, 37.38737], [-120.99391, 37.38761], [-120.9937, 37.38775], [-120.99292, 37.38816], [-120.99246, 37.38826], [-120.99203, 37.38837], [-120.99173, 37.38848], [-120.99152, 37.3886], [-120.99138, 37.38871], [-120.99128, 37.38897], [-120.9909, 37.39073], [-120.99071, 37.39186], [-120.99061, 37.39263], [-120.9905, 37.39312], [-120.99041, 37.39369], [-120.99039, 37.39431], [-120.99032, 37.39473], [-120.99015, 37.39508], [-120.98991, 37.39541], [-120.98952, 37.39575], [-120.98855, 37.39625], [-120.988, 37.39662], [-120.98711, 37.39712], [-120.98665, 37.39723], [-120.98628, 37.39739], [-120.98594, 37.39762], [-120.98567, 37.39796], [-120.98521, 37.39849], [-120.98496, 37.39871], [-120.98472, 37.39901], [-120.98458, 37.39936], [-120.98059, 37.40094], [-120.97928, 37.40113], [-120.97877, 37.40117], [-120.97843, 37.40154], [-120.97804, 37.40162], [-120.97767, 37.40154], [-120.97748, 37.40127], [-120.97755, 37.39831], [-120.98063, 37.39399], [-120.98117, 37.3924], [-120.9817, 37.39185], [-120.98176, 37.39024], [-120.98226, 37.38896], [-120.98228, 37.38758], [-120.9827, 37.3859], [-120.98341, 37.3863], [-120.9837, 37.38641], [-120.98414, 37.38648], [-120.98472, 37.38649], [-120.98668, 37.3865], [-120.98736, 37.38651], [-120.98766, 37.38654], [-120.98799, 37.38665], [-120.9883, 37.3868], [-120.9887, 37.38705], [-120.98916, 37.38724], [-120.98966, 37.38734], [-120.98998, 37.38737], [-120.9902, 37.38731], [-120.9904, 37.38709], [-120.99066, 37.38684], [-120.991, 37.38663], [-120.99125, 37.38643], [-120.99142, 37.38624], [-120.99157, 37.38593], [-120.99169, 37.38391], [-120.99185, 37.3835], [-120.99196, 37.38334]]]} Open Access 1 17314 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 Merced 37 329.178 West Hilmar Wildlife Area 1994 State Conservation Area 8 2
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

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