calands: units_with_maps: 4 rows where COUNTY = 40, DES_TP = 55 and MNG_AG

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

4 rows where COUNTY = 40, DES_TP = 55 and MNG_AG_TYP = 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	DES_TP	GAP_STS
4842	4842	4841	{"type": "Polygon", "coordinates": [[[-122.70265, 38.97554], [-122.70213, 38.97651], [-122.7016, 38.97676], [-122.7006, 38.97679], [-122.70085, 38.97617], [-122.70146, 38.9756], [-122.70265, 38.97554]]]}	No Public Access 3	2140	Monitor Island	32231	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Lake 40	3.761	Monitor Island	State Resource Management Area 55	3
8247	8247	8246	{"type": "MultiPolygon", "coordinates": [[[[-122.72165, 38.84391], [-122.72154, 38.84904], [-122.71487, 38.84901], [-122.70574, 38.84902], [-122.70549, 38.84378], [-122.70284, 38.84376], [-122.68431, 38.84373], [-122.68434, 38.84279], [-122.68496, 38.83865], [-122.685, 38.83772], [-122.68494, 38.83637], [-122.68039, 38.83604], [-122.68047, 38.83773], [-122.67152, 38.83772], [-122.67106, 38.83233], [-122.66655, 38.83217], [-122.66627, 38.82927], [-122.66623, 38.82554], [-122.66608, 38.81436], [-122.66616, 38.81074], [-122.67542, 38.81083], [-122.67552, 38.80719], [-122.68013, 38.80724], [-122.68023, 38.80362], [-122.68487, 38.80364], [-122.68479, 38.80728], [-122.69405, 38.80727], [-122.69369, 38.81492], [-122.69369, 38.8164], [-122.69361, 38.82063], [-122.69362, 38.82181], [-122.7029, 38.82182], [-122.70286, 38.8256], [-122.71223, 38.82569], [-122.71219, 38.82937], [-122.72053, 38.82944], [-122.72049, 38.83061], [-122.72084, 38.83179], [-122.72088, 38.83228], [-122.72097, 38.83257], [-122.72105, 38.8327], [-122.72116, 38.83279], [-122.72139, 38.83289], [-122.72139, 38.83408], [-122.72119, 38.83409], [-122.72119, 38.83662], [-122.72115, 38.83808], [-122.72115, 38.8387], [-122.72123, 38.84389], [-122.72165, 38.84391]]], [[[-122.72597, 38.83144], [-122.7259, 38.83145], [-122.72589, 38.83272], [-122.72595, 38.83273], [-122.72596, 38.83312], [-122.7226, 38.83309], [-122.72194, 38.83286], [-122.7213, 38.83267], [-122.72082, 38.83095], [-122.72131, 38.83138], [-122.72303, 38.8314], [-122.72304, 38.82939], [-122.72596, 38.82941], [-122.72586, 38.82956], [-122.72578, 38.82956], [-122.72579, 38.82991], [-122.72596, 38.8299], [-122.72598, 38.83025], [-122.72597, 38.83144]]]]}	Open Access 1	11240	Boggs Mountain Demonstration State Forest	1364	202	California Department of Forestry and Fire Protection 346	State 5	State Agency 5	http://www.fire.ca.gov/	Other State 5	202	California Department of Forestry and Fire Protection 343	State 5	State Agency 5	http://www.fire.ca.gov/resource_mgt/resource_mgt_stateforests_boggsmtn.php	Lake 40	3425.69	Boggs Mtn. DSF	State Resource Management Area 55	3
16502	16502	16501	{"type": "MultiPolygon", "coordinates": [[[[-122.59311, 39.11142], [-122.57646, 39.11071], [-122.57567, 39.09937], [-122.57539, 39.09558], [-122.59275, 39.09708], [-122.59311, 39.11142]]], [[[-122.64769, 39.14144], [-122.64763, 39.15707], [-122.62982, 39.15656], [-122.62966, 39.14127], [-122.64769, 39.14144]]], [[[-122.81901, 39.20575], [-122.81461, 39.20412], [-122.80594, 39.20081], [-122.80577, 39.19854], [-122.81895, 39.20218], [-122.81901, 39.20575]]], [[[-123.04349, 39.37838], [-123.04341, 39.38187], [-123.03893, 39.38189], [-123.039, 39.37835], [-123.04349, 39.37838]]], [[[-123.05676, 39.39292], [-123.05667, 39.39647], [-123.05226, 39.39644], [-123.0523, 39.39292], [-123.05676, 39.39292]]], [[[-123.07487, 39.4075], [-123.07427, 39.42172], [-123.06524, 39.42164], [-123.06528, 39.4199], [-123.06533, 39.41819], [-123.0657, 39.41096], [-123.06585, 39.40744], [-123.07487, 39.4075]]]]}	Unknown Access 4	44747	California State Lands Commission	16726	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	209	California State Lands Commission 73	State 5	State Agency 5		Lake 40	1718.203	SLC	State Resource Management Area 55	3
16879	16879	16878	{"type": "MultiPolygon", "coordinates": [[[[-122.42777, 38.9418], [-122.42751, 38.94518], [-122.40757, 38.94348], [-122.4076, 38.94723], [-122.40301, 38.94742], [-122.40305, 38.94182], [-122.40304, 38.94015], [-122.40753, 38.93973], [-122.42777, 38.9418]]], [[[-122.4423, 38.94636], [-122.44197, 38.95323], [-122.42701, 38.95196], [-122.42727, 38.94858], [-122.43222, 38.94897], [-122.43244, 38.94558], [-122.4423, 38.94636]]], [[[-122.45661, 38.9506], [-122.4565, 38.95403], [-122.4563, 38.96114], [-122.45156, 38.96097], [-122.45173, 38.95385], [-122.44696, 38.95365], [-122.44709, 38.9502], [-122.4471, 38.95022], [-122.45661, 38.9506]]], [[[-122.46898, 38.96257], [-122.46893, 38.96617], [-122.46544, 38.96619], [-122.46547, 38.96508], [-122.46556, 38.96256], [-122.46898, 38.96257]]], [[[-122.48359, 38.92405], [-122.48337, 38.93836], [-122.46636, 38.93845], [-122.46661, 38.9312], [-122.46946, 38.93119], [-122.46962, 38.92395], [-122.47437, 38.92395], [-122.47439, 38.92399], [-122.48359, 38.92405]]], [[[-122.48298, 38.98375], [-122.48278, 38.98736], [-122.47802, 38.98735], [-122.47817, 38.98377], [-122.48298, 38.98375]]], [[[-122.51668, 38.97933], [-122.51278, 38.97931], [-122.51256, 38.97569], [-122.51652, 38.97566], [-122.51668, 38.97933]]], [[[-122.54356, 38.96017], [-122.54353, 38.96365], [-122.53894, 38.96324], [-122.53896, 38.95982], [-122.54356, 38.96017]]], [[[-122.54931, 38.69544], [-122.54931, 38.69905], [-122.54468, 38.69905], [-122.54466, 38.70122], [-122.54467, 38.70264], [-122.54931, 38.70264], [-122.5493, 38.70625], [-122.54464, 38.70626], [-122.54465, 38.70265], [-122.54, 38.70265], [-122.54, 38.69904], [-122.54466, 38.69904], [-122.54468, 38.69544], [-122.54931, 38.69544]]], [[[-122.5968, 38.69882], [-122.59556, 38.70606], [-122.59508, 38.70606], [-122.59507, 38.70244], [-122.59052, 38.70241], [-122.59051, 38.70602], [-122.58595, 38.70599], [-122.58596, 38.69877], [-122.57687, 38.69872], [-122.56327, 38.69896], [-122.56327, 38.69177], [-122.55862, 38.69185], [-122.5586, 38.68452], [-122.56325, 38.68448], [-122.56327, 38.6887], [-122.56792, 38.68865], [-122.56793, 38.69529], [-122.57687, 38.69514], [-122.5769, 38.69154], [-122.58599, 38.69155], [-122.58598, 38.68794], [-122.58143, 38.68794], [-122.58139, 38.68073], [-122.58138, 38.68072], [-122.57683, 38.68077], [-122.57688, 38.68795], [-122.57257, 38.68801], [-122.57252, 38.68079], [-122.57682, 38.68076], [-122.57681, 38.67946], [-122.58596, 38.67735], [-122.58597, 38.68068], [-122.58807, 38.68066], [-122.58807, 38.68161], [-122.59052, 38.68159], [-122.59053, 38.69156], [-122.58599, 38.69156], [-122.58597, 38.69877], [-122.5968, 38.69882]]], [[[-122.73991, 38.80732], [-122.73048, 38.8074], [-122.73012, 38.81479], [-122.72579, 38.81476], [-122.72594, 38.8111], [-122.72159, 38.81109], [-122.72173, 38.80747], [-122.72206, 38.80024], [-122.72208, 38.79666], [-122.73082, 38.79655], [-122.73084, 38.80001], [-122.7396, 38.79979], [-122.73991, 38.80732]]], [[[-122.73752, 38.89622], [-122.7375, 38.89987], [-122.73281, 38.89991], [-122.73285, 38.89619], [-122.73752, 38.89622]]], [[[-122.77612, 38.84469], [-122.77135, 38.84456], [-122.77135, 38.84345], [-122.77612, 38.84339], [-122.77612, 38.84469]]], [[[-122.80113, 38.83962], [-122.7977, 38.84501], [-122.7977, 38.84658], [-122.79282, 38.84647], [-122.79283, 38.84493], [-122.79468, 38.84495], [-122.7947, 38.84329], [-122.78542, 38.84335], [-122.78545, 38.83972], [-122.80113, 38.83962]]], [[[-122.79279, 38.87201], [-122.78828, 38.87174], [-122.78818, 38.86816], [-122.79264, 38.86848], [-122.79279, 38.87201]]], [[[-122.81872, 38.85147], [-122.81819, 38.85621], [-122.81815, 38.85622], [-122.81768, 38.86053], [-122.8177, 38.86054], [-122.8177, 38.86057], [-122.80268, 38.8612], [-122.80257, 38.86501], [-122.79753, 38.86512], [-122.79266, 38.8648], [-122.79268, 38.86111], [-122.78825, 38.86084], [-122.78831, 38.85342], [-122.78832, 38.84989], [-122.79766, 38.85028], [-122.79763, 38.85399], [-122.81872, 38.85147]]], [[[-122.84701, 38.89143], [-122.8423, 38.89151], [-122.84252, 38.89529], [-122.83791, 38.89539], [-122.83758, 38.89159], [-122.83263, 38.89198], [-122.83234, 38.8883], [-122.83725, 38.88779], [-122.83691, 38.884], [-122.83203, 38.88461], [-122.83172, 38.88093], [-122.82202, 38.88238], [-122.82226, 38.88583], [-122.82715, 38.88522], [-122.82742, 38.8888], [-122.81758, 38.8898], [-122.8078, 38.8897], [-122.80796, 38.8931], [-122.8178, 38.89315], [-122.82769, 38.89237], [-122.82796, 38.89594], [-122.82776, 38.9064], [-122.83392, 38.90629], [-122.83387, 38.90983], [-122.83405, 38.91322], [-122.83994, 38.91321], [-122.84469, 38.91331], [-122.84465, 38.91678], [-122.83983, 38.91663], [-122.83424, 38.91662], [-122.83404, 38.91323], [-122.81733, 38.91328], [-122.81779, 38.90995], [-122.81795, 38.89986], [-122.80805, 38.89999], [-122.80799, 38.90346], [-122.79807, 38.9037], [-122.79813, 38.90011], [-122.80308, 38.90004], [-122.80314, 38.8965], [-122.80289, 38.88965], [-122.79797, 38.88959], [-122.79781, 38.88268], [-122.79301, 38.88274], [-122.79293, 38.87552], [-122.79766, 38.87575], [-122.79775, 38.87921], [-122.81704, 38.87974], [-122.83172, 38.87723], [-122.83173, 38.88092], [-122.83658, 38.8802], [-122.83692, 38.88399], [-122.84184, 38.88396], [-122.84208, 38.88773], [-122.84689, 38.88768], [-122.84701, 38.89143]]], [[[-122.80252, 38.87237], [-122.79758, 38.87229], [-122.7975, 38.86883], [-122.80247, 38.86881], [-122.80252, 38.87237]]], [[[-122.83471, 38.92453], [-122.81742, 38.92489], [-122.81687, 38.91662], [-122.82864, 38.91663], [-122.82922, 38.92062], [-122.83448, 38.92058], [-122.83471, 38.92453]]]]}	Open Access 1	23559	California State Lands Commission	16724	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	209	California State Lands Commission 73	State 5	State Agency 5		Lake 40	6195.603	SLC	State Resource Management Area 55	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]);