calands: units_with_maps: 1 row where COUNTY = 41, DES_TP = 8 and MNG

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

1 row where COUNTY = 41, DES_TP = 8 and MNG_AGENCY = 470

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
11282	11282	11281	{"type": "Polygon", "coordinates": [[[-121.41367, 38.23999], [-121.41393, 38.24073], [-121.41403, 38.24115], [-121.41401, 38.24182], [-121.41387, 38.2422], [-121.41372, 38.24252], [-121.41349, 38.24273], [-121.4134, 38.24305], [-121.41338, 38.24337], [-121.41318, 38.24429], [-121.41301, 38.24479], [-121.41253, 38.2454], [-121.41205, 38.2458], [-121.41183, 38.24594], [-121.41149, 38.2461], [-121.41107, 38.24659], [-121.41077, 38.24686], [-121.41051, 38.24724], [-121.41014, 38.24789], [-121.40986, 38.24824], [-121.4098, 38.24835], [-121.40967, 38.24845], [-121.40943, 38.24856], [-121.40929, 38.24867], [-121.40924, 38.24878], [-121.40917, 38.24913], [-121.40828, 38.25009], [-121.40789, 38.25041], [-121.40766, 38.25056], [-121.40722, 38.25103], [-121.40677, 38.25159], [-121.40616, 38.25214], [-121.40585, 38.25266], [-121.40583, 38.25277], [-121.40585, 38.25291], [-121.40612, 38.25307], [-121.40671, 38.25329], [-121.4067, 38.25337], [-121.4064, 38.25349], [-121.40605, 38.25368], [-121.40588, 38.2538], [-121.4057, 38.25401], [-121.40567, 38.25411], [-121.40595, 38.25412], [-121.40522, 38.25423], [-121.40433, 38.25417], [-121.4041, 38.25411], [-121.40216, 38.2541], [-121.40127, 38.25383], [-121.40146, 38.25112], [-121.40144, 38.25103], [-121.40136, 38.25096], [-121.40126, 38.25093], [-121.39906, 38.25089], [-121.39863, 38.25068], [-121.3983, 38.25048], [-121.39765, 38.24996], [-121.39734, 38.24974], [-121.39617, 38.24779], [-121.39663, 38.24661], [-121.39638, 38.24624], [-121.39618, 38.246], [-121.39563, 38.24543], [-121.39533, 38.24509], [-121.39504, 38.24486], [-121.39474, 38.24467], [-121.39269, 38.24467], [-121.39251, 38.2447], [-121.39178, 38.24494], [-121.39059, 38.24485], [-121.39026, 38.24475], [-121.38955, 38.24426], [-121.38627, 38.24134], [-121.38819, 38.24132], [-121.3925, 38.24131], [-121.39949, 38.24126], [-121.39985, 38.24123], [-121.40024, 38.24113], [-121.40047, 38.24103], [-121.40227, 38.24019], [-121.40258, 38.24009], [-121.40298, 38.24003], [-121.41367, 38.23999]]]}	No Public Access 3	21821	Grizzly Slough	30567	207	California Department of Water Resources 477	State 5	State Agency 5	http://www.water.ca.gov/	Other State 5	207	California Department of Water Resources 470	State 5	State Agency 5		Sacramento 41	487.047	Grizzly Slough	0	State Conservation Area 8	2

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