calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES

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

1 row where ACCESS_TYP = 1, DES_TP = 1264 and LAYER = 5

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
14744	14744	14743	{"type": "Polygon", "coordinates": [[[-119.83687, 36.85657], [-119.83636, 36.85653], [-119.83406, 36.8556], [-119.83382, 36.85617], [-119.83164, 36.85548], [-119.82956, 36.85467], [-119.82958, 36.85894], [-119.82911, 36.85877], [-119.82676, 36.85836], [-119.82546, 36.85798], [-119.82482, 36.85787], [-119.82444, 36.85787], [-119.82146, 36.85849], [-119.82124, 36.85821], [-119.82014, 36.85846], [-119.82014, 36.85839], [-119.82013, 36.85838], [-119.81682, 36.85918], [-119.8161, 36.85969], [-119.81549, 36.85966], [-119.81521, 36.85915], [-119.8137, 36.85798], [-119.8133, 36.85721], [-119.8141, 36.85621], [-119.81385, 36.85511], [-119.81452, 36.85355], [-119.81774, 36.85268], [-119.81816, 36.85175], [-119.81874, 36.85089], [-119.81827, 36.85053], [-119.81819, 36.84968], [-119.82062, 36.84889], [-119.82609, 36.8502], [-119.82888, 36.85138], [-119.82982, 36.85209], [-119.83077, 36.85256], [-119.83253, 36.85338], [-119.8334, 36.85372], [-119.83687, 36.85657]]]}	Open Access 1	45120	Sycamore Island	26131	233	San Joaquin River Conservancy 827	State 5	State Agency 5	http://sjrc.ca.gov/	Other State 5	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10		Madera 48	328.657	Sycamore Island		None 1264

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