calands: units_with_maps: 1 row where ACCESS_TYP = 1, COUNTY = 41 and MNG_AG

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

1 row where ACCESS_TYP = 1, COUNTY = 41 and MNG_AG_TYP = 10

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
13917	13917	13916	{"type": "Polygon", "coordinates": [[[-121.44101, 38.26353], [-121.44108, 38.26383], [-121.44114, 38.26415], [-121.44115, 38.26442], [-121.44115, 38.26468], [-121.44112, 38.26494], [-121.44106, 38.2652], [-121.44099, 38.26545], [-121.4409, 38.26568], [-121.44061, 38.26555], [-121.43901, 38.26458], [-121.439, 38.26459], [-121.43905, 38.26515], [-121.43872, 38.26566], [-121.43893, 38.26623], [-121.4405, 38.26654], [-121.43863, 38.27055], [-121.43851, 38.27088], [-121.43845, 38.27111], [-121.43842, 38.27134], [-121.4384, 38.27157], [-121.4384, 38.2718], [-121.43844, 38.27209], [-121.43847, 38.27226], [-121.43863, 38.27278], [-121.43743, 38.26945], [-121.43667, 38.26944], [-121.43619, 38.26994], [-121.43605, 38.27006], [-121.43581, 38.27022], [-121.43552, 38.27038], [-121.43528, 38.27049], [-121.43511, 38.27053], [-121.4349, 38.27054], [-121.43466, 38.27052], [-121.43453, 38.27047], [-121.4344, 38.27039], [-121.43435, 38.27034], [-121.43428, 38.27024], [-121.43426, 38.2701], [-121.4343, 38.2699], [-121.43437, 38.26968], [-121.43452, 38.26943], [-121.43364, 38.26943], [-121.43357, 38.27302], [-121.42942, 38.273], [-121.42926, 38.26865], [-121.42579, 38.26863], [-121.42578, 38.2663], [-121.42502, 38.26479], [-121.42414, 38.26368], [-121.42533, 38.26134], [-121.42541, 38.26004], [-121.42528, 38.25894], [-121.42669, 38.25701], [-121.42884, 38.25744], [-121.42873, 38.25424], [-121.42892, 38.25424], [-121.42904, 38.25441], [-121.42919, 38.25473], [-121.42927, 38.25482], [-121.42937, 38.2549], [-121.42962, 38.25497], [-121.43061, 38.25503], [-121.43105, 38.255], [-121.43174, 38.25486], [-121.43215, 38.25472], [-121.43217, 38.25476], [-121.43226, 38.25467], [-121.43411, 38.25429], [-121.43466, 38.2543], [-121.43514, 38.25444], [-121.43557, 38.25464], [-121.4358, 38.25485], [-121.43601, 38.25495], [-121.4365, 38.25511], [-121.4369, 38.25515], [-121.43711, 38.25516], [-121.43721, 38.25519], [-121.43817, 38.2551], [-121.439, 38.25512], [-121.43912, 38.25525], [-121.43959, 38.25548], [-121.43943, 38.25611], [-121.43866, 38.25662], [-121.43832, 38.25671], [-121.43828, 38.26168], [-121.43868, 38.26169], [-121.43893, 38.26255], [-121.43933, 38.26339], [-121.44101, 38.26353]], [[-121.43345, 38.25739], [-121.43346, 38.25738], [-121.4334, 38.25721], [-121.43308, 38.25731], [-121.43313, 38.25746], [-121.43345, 38.25739]]]}	Open Access 1	46982	Cosumnes River Preserve	30622	3091	The Nature Conservancy 63	Non Profit 6	Non Profit - Land Trust 10	http://www.nature.org/	Non Governmental Organization 10	3091	The Nature Conservancy 61	Non Profit 6	Non Profit - Land Trust 10		Sacramento 41	505.303	Cosumnes River Preserve	0	Private Conservation 16	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]);