calands: units_with_maps: 5 rows where ACCESS_TYP = 1 and MNG

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

5 rows where ACCESS_TYP = 1 and MNG_AGENCY = 61

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
11158	11158	11157	{"type": "Polygon", "coordinates": [[[-121.99562, 39.7515], [-121.99443, 39.75196], [-121.99393, 39.75211], [-121.9935, 39.75227], [-121.99296, 39.75235], [-121.99226, 39.75242], [-121.9914, 39.7524], [-121.99124, 39.75232], [-121.98861, 39.74682], [-121.98935, 39.74655], [-121.98963, 39.7472], [-121.99014, 39.74792], [-121.99059, 39.74829], [-121.99115, 39.74861], [-121.99158, 39.74873], [-121.99259, 39.74926], [-121.99323, 39.74964], [-121.99365, 39.75], [-121.99432, 39.75045], [-121.99562, 39.7515]]]}	Open Access 1	21526	Cummings	17857	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	Butte 42	35.635	Cummings	Private Conservation 16	2
11199	11199	11198	{"type": "MultiPolygon", "coordinates": [[[[-122.16861, 41.0736], [-122.1591, 41.07366], [-122.15932, 41.07718], [-122.15456, 41.07721], [-122.15501, 41.08423], [-122.15026, 41.08424], [-122.15048, 41.08775], [-122.13803, 41.08787], [-122.13515, 41.08779], [-122.13512, 41.0914], [-122.13501, 41.09459], [-122.12531, 41.09428], [-122.11003, 41.09415], [-122.10992, 41.09083], [-122.1052, 41.09078], [-122.10517, 41.08731], [-122.12543, 41.08751], [-122.12479, 41.08033], [-122.13466, 41.08054], [-122.13423, 41.07343], [-122.14957, 41.07371], [-122.14912, 41.06652], [-122.15864, 41.06646], [-122.1585, 41.05936], [-122.16834, 41.0594], [-122.16861, 41.0736]]], [[[-122.22646, 41.05957], [-122.22614, 41.07431], [-122.20728, 41.07442], [-122.20723, 41.05983], [-122.21203, 41.05976], [-122.21195, 41.06347], [-122.22154, 41.06335], [-122.2217, 41.05978], [-122.22166, 41.05963], [-122.22646, 41.05957]]]]}	Open Access 1	21514	McCloud River Preserve	13117	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	Shasta 27	2293.045	McCloud River Preserve	Private Conservation 16	2
12614	12614	12613	{"type": "Polygon", "coordinates": [[[-120.34554, 39.44561], [-120.3414, 39.44567], [-120.32941, 39.44556], [-120.32943, 39.44304], [-120.32932, 39.43928], [-120.32506, 39.43926], [-120.32499, 39.44302], [-120.32001, 39.44312], [-120.3199, 39.44554], [-120.31996, 39.44615], [-120.31954, 39.44615], [-120.31953, 39.44617], [-120.29558, 39.44618], [-120.29123, 39.44617], [-120.28646, 39.44619], [-120.28648, 39.44547], [-120.28742, 39.44547], [-120.28738, 39.44325], [-120.2919, 39.44327], [-120.29188, 39.43978], [-120.29181, 39.43209], [-120.29228, 39.43213], [-120.3108, 39.43208], [-120.31949, 39.4321], [-120.32004, 39.43168], [-120.31982, 39.42454], [-120.32436, 39.42465], [-120.32908, 39.42472], [-120.3292, 39.43206], [-120.34477, 39.43176], [-120.34534, 39.43206], [-120.34554, 39.44561]]]}	Open Access 1	29376	Independence Lake Preserve	30600	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	Nevada 30	1853.425	Independence Lake Preserve	Private Conservation 16	2
12615	12615	12614	{"type": "Polygon", "coordinates": [[[-120.31953, 39.44617], [-120.31926, 39.45364], [-120.30978, 39.45385], [-120.30493, 39.45374], [-120.30485, 39.45727], [-120.30979, 39.45734], [-120.30979, 39.46109], [-120.29148, 39.46136], [-120.2721, 39.46134], [-120.27215, 39.44682], [-120.28643, 39.44679], [-120.28646, 39.44619], [-120.29123, 39.44617], [-120.29558, 39.44618], [-120.31953, 39.44617]]]}	Open Access 1	29377	Independence Lake Preserve	30600	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	Sierra 58	1453.399	Independence Lake Preserve	Private Conservation 16	2
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	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]);