calands: units_with_maps: 1 row where COUNTY = 18, DES_TP = 82 and MNG

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

1 row where COUNTY = 18, DES_TP = 82 and MNG_AGENCY = 142

Search:

descending

This data as json, copyable, CSV (advanced)

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
8026	8026	8025	{"type": "Polygon", "coordinates": [[[-122.4349, 39.79966], [-122.4334, 39.80178], [-122.43212, 39.80268], [-122.43207, 39.80344], [-122.4309, 39.80446], [-122.43078, 39.80663], [-122.42338, 39.80657], [-122.42332, 39.8075], [-122.42162, 39.80751], [-122.42173, 39.809], [-122.42022, 39.80904], [-122.42013, 39.80829], [-122.41596, 39.80833], [-122.41599, 39.8116], [-122.41288, 39.81171], [-122.41278, 39.80624], [-122.41133, 39.80627], [-122.41132, 39.80628], [-122.41144, 39.80899], [-122.41016, 39.809], [-122.40997, 39.80677], [-122.40868, 39.80677], [-122.40866, 39.80841], [-122.38946, 39.80877], [-122.38968, 39.81393], [-122.3928, 39.81395], [-122.39278, 39.81681], [-122.38988, 39.81687], [-122.38986, 39.81576], [-122.38701, 39.81582], [-122.38701, 39.81393], [-122.37764, 39.81377], [-122.37778, 39.82248], [-122.38187, 39.82241], [-122.38187, 39.82492], [-122.38296, 39.82489], [-122.38309, 39.82634], [-122.37832, 39.82622], [-122.37826, 39.82826], [-122.37699, 39.82825], [-122.37697, 39.8293], [-122.3759, 39.82933], [-122.37581, 39.82829], [-122.37461, 39.82823], [-122.37465, 39.82496], [-122.3652, 39.82462], [-122.3639, 39.82601], [-122.36084, 39.8263], [-122.36112, 39.82454], [-122.35725, 39.82455], [-122.35715, 39.82813], [-122.34721, 39.82803], [-122.34727, 39.82255], [-122.33795, 39.82252], [-122.33715, 39.8227], [-122.33329, 39.82451], [-122.33017, 39.82263], [-122.32924, 39.82312], [-122.32807, 39.82419], [-122.32698, 39.8242], [-122.32594, 39.82399], [-122.32467, 39.82354], [-122.32379, 39.82312], [-122.32288, 39.82236], [-122.32233, 39.82171], [-122.32195, 39.8208], [-122.32162, 39.81949], [-122.32167, 39.81781], [-122.32387, 39.81786], [-122.32595, 39.81543], [-122.32728, 39.81425], [-122.32816, 39.81368], [-122.32817, 39.81253], [-122.32894, 39.81209], [-122.32955, 39.811], [-122.32974, 39.81032], [-122.33017, 39.8095], [-122.3311, 39.81015], [-122.33156, 39.81129], [-122.33185, 39.81171], [-122.33336, 39.81218], [-122.33365, 39.81262], [-122.33412, 39.81366], [-122.34106, 39.81363], [-122.341, 39.80911], [-122.33679, 39.80924], [-122.33699, 39.79918], [-122.33722, 39.79917], [-122.34655, 39.79923], [-122.38706, 39.79899], [-122.40884, 39.7993], [-122.40963, 39.79995], [-122.41067, 39.80023], [-122.41357, 39.8007], [-122.41555, 39.80081], [-122.41793, 39.80067], [-122.42138, 39.80023], [-122.42218, 39.80001], [-122.42357, 39.79947], [-122.42481, 39.79948], [-122.42477, 39.80295], [-122.42478, 39.80296], [-122.42813, 39.80292], [-122.42862, 39.80238], [-122.42975, 39.80161], [-122.43096, 39.80036], [-122.43225, 39.79961], [-122.4349, 39.79966]]]}	Open Access 1	11357	Black Butte Lake	13553	100	United States Army Corps of Engineers 146	Federal 1	Federal Agency 1	http://www.usace.army.mil/	Other Federal 13	100	United States Army Corps of Engineers 142	Federal 1	Federal Agency 1	http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/BlackButteLake.aspx	Tehama 18	4121.328	Black Butte Lake	0	Resource Management Area 82	3

Advanced export

JSON shape: default, array, newline-delimited

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