calands: units_with_maps: 5 rows where ACCESS_TYP = 2, DES

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

5 rows where ACCESS_TYP = 2, DES_TP = 87 and LAYER = 13

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
947	947	946	{"type": "MultiPolygon", "coordinates": [[[[-118.30927, 33.77858], [-118.30758, 33.77901], [-118.3066, 33.7792], [-118.30555, 33.77935], [-118.30359, 33.77951], [-118.30379, 33.77922], [-118.30356, 33.7791], [-118.30373, 33.77882], [-118.30371, 33.77863], [-118.30258, 33.77836], [-118.30228, 33.77858], [-118.30213, 33.77866], [-118.30196, 33.77871], [-118.30179, 33.77874], [-118.30145, 33.77873], [-118.30114, 33.77863], [-118.30124, 33.77834], [-118.3011, 33.7783], [-118.30143, 33.77756], [-118.3013, 33.77738], [-118.30092, 33.7772], [-118.30093, 33.77658], [-118.30075, 33.77653], [-118.30073, 33.77656], [-118.3002, 33.77642], [-118.30015, 33.77669], [-118.30004, 33.7768], [-118.29989, 33.77685], [-118.29945, 33.77691], [-118.29942, 33.77696], [-118.29941, 33.77494], [-118.296, 33.77494], [-118.2959, 33.77466], [-118.29444, 33.77083], [-118.29424, 33.77018], [-118.29413, 33.76975], [-118.29404, 33.76934], [-118.29402, 33.76908], [-118.29401, 33.76865], [-118.29405, 33.76753], [-118.29404, 33.76724], [-118.294, 33.76667], [-118.29394, 33.76629], [-118.29718, 33.76629], [-118.29719, 33.76641], [-118.29801, 33.76687], [-118.29825, 33.76705], [-118.29891, 33.76743], [-118.29912, 33.76759], [-118.29932, 33.7677], [-118.30005, 33.76787], [-118.30059, 33.76797], [-118.30179, 33.76827], [-118.30185, 33.76825], [-118.30188, 33.76819], [-118.30407, 33.76881], [-118.30522, 33.76959], [-118.30699, 33.77065], [-118.30701, 33.77105], [-118.30741, 33.77167], [-118.30772, 33.77175], [-118.30895, 33.77159], [-118.30875, 33.77225], [-118.30863, 33.77282], [-118.30859, 33.77321], [-118.3086, 33.77377], [-118.30863, 33.77407], [-118.30927, 33.77858]]], [[[-118.30012, 33.77981], [-118.29971, 33.77989], [-118.29931, 33.78001], [-118.29894, 33.78016], [-118.29858, 33.78034], [-118.29825, 33.78056], [-118.29796, 33.78081], [-118.29759, 33.78122], [-118.2974, 33.78122], [-118.29726, 33.78129], [-118.29689, 33.78086], [-118.29719, 33.7805], [-118.29739, 33.7803], [-118.2976, 33.78013], [-118.2979, 33.77991], [-118.29838, 33.77962], [-118.29904, 33.77935], [-118.29933, 33.77926], [-118.29938, 33.77939], [-118.29967, 33.77967], [-118.29978, 33.77974], [-118.3001, 33.77979], [-118.30012, 33.77981]]]]}	Restricted Access 2	5975	Defense Fuel Supply Point (DFSP) - Hab. Restoration	18013	199	Other Federal 284	Federal 1	Federal Agency 1		Other Federal 13	199	Other Federal 280	Federal 1	Federal Agency 1	Los Angeles 6	326.646	Defense Fuel Supply Point (DFSP) - Hab. Restoration	Federal Other or Unknown 87	4
11423	11423	11422	{"type": "MultiPolygon", "coordinates": [[[[-121.30305, 38.54735], [-121.30211, 38.5479], [-121.30127, 38.54837], [-121.2953, 38.55181], [-121.29482, 38.55207], [-121.29427, 38.55231], [-121.2937, 38.5525], [-121.29335, 38.5526], [-121.29265, 38.55275], [-121.29246, 38.55278], [-121.29003, 38.5528], [-121.28957, 38.55274], [-121.28897, 38.55261], [-121.28836, 38.55242], [-121.28791, 38.55226], [-121.28551, 38.5512], [-121.28518, 38.55109], [-121.28486, 38.55102], [-121.28379, 38.55086], [-121.28308, 38.55082], [-121.28265, 38.55083], [-121.28259, 38.54964], [-121.28298, 38.54965], [-121.28397, 38.54949], [-121.28537, 38.54886], [-121.28599, 38.54831], [-121.28692, 38.54751], [-121.28713, 38.54683], [-121.28788, 38.54565], [-121.28812, 38.54522], [-121.28839, 38.54526], [-121.28848, 38.54518], [-121.29005, 38.54547], [-121.29024, 38.54486], [-121.29018, 38.54435], [-121.28998, 38.54383], [-121.28964, 38.54334], [-121.28791, 38.54363], [-121.28759, 38.54403], [-121.28589, 38.54301], [-121.28583, 38.54294], [-121.28639, 38.54202], [-121.28574, 38.54162], [-121.28514, 38.54238], [-121.28501, 38.54227], [-121.28488, 38.54207], [-121.28543, 38.54142], [-121.28547, 38.54098], [-121.28481, 38.54044], [-121.28397, 38.54], [-121.28293, 38.54004], [-121.28244, 38.54027], [-121.28118, 38.53964], [-121.28064, 38.53961], [-121.27946, 38.54002], [-121.27897, 38.54049], [-121.27866, 38.54086], [-121.2783, 38.54113], [-121.27786, 38.54135], [-121.27631, 38.54189], [-121.2764, 38.54203], [-121.27556, 38.54252], [-121.27453, 38.54244], [-121.27376, 38.54246], [-121.27307, 38.54332], [-121.27282, 38.54358], [-121.27375, 38.54468], [-121.27278, 38.54507], [-121.27227, 38.54435], [-121.27224, 38.54368], [-121.27233, 38.54302], [-121.27252, 38.54256], [-121.27246, 38.54215], [-121.27209, 38.54127], [-121.27177, 38.54079], [-121.27132, 38.5405], [-121.27142, 38.5403], [-121.27227, 38.54066], [-121.27301, 38.5409], [-121.27377, 38.54112], [-121.27493, 38.54155], [-121.27598, 38.54132], [-121.27663, 38.54074], [-121.2757, 38.53913], [-121.27535, 38.53918], [-121.27453, 38.53879], [-121.2726, 38.53884], [-121.27114, 38.53948], [-121.27019, 38.54032], [-121.26992, 38.54086], [-121.26982, 38.54135], [-121.26894, 38.54175], [-121.26856, 38.54449], [-121.2689, 38.54555], [-121.26937, 38.54647], [-121.26788, 38.54711], [-121.26917, 38.54757], [-121.26919, 38.54759], [-121.26923, 38.54765], [-121.2689, 38.54865], [-121.2688, 38.54869], [-121.26872, 38.54877], [-121.26856, 38.54887], [-121.26839, 38.54894], [-121.26831, 38.549], [-121.26706, 38.54949], [-121.26703, 38.54956], [-121.2661, 38.54997], [-121.26584, 38.54992], [-121.26464, 38.54933], [-121.26446, 38.54912], [-121.2637, 38.54838], [-121.26341, 38.54821], [-121.26297, 38.54721], [-121.26298, 38.54713], [-121.26297, 38.54709], [-121.26302, 38.54687], [-121.26313, 38.54672], [-121.26313, 38.5467], [-121.26121, 38.54672], [-121.2612, 38.54482], [-121.26109, 38.54475], [-121.26111, 38.53501], [-121.26859, 38.53502], [-121.26859, 38.53527], [-121.28764, 38.5349], [-121.29213, 38.53601], [-121.2884, 38.53879], [-121.28755, 38.53809], [-121.28787, 38.53781], [-121.28787, 38.53779], [-121.28664, 38.53694], [-121.2863, 38.53673], [-121.28504, 38.53627], [-121.28387, 38.53604], [-121.28242, 38.53602], [-121.28172, 38.5361], [-121.28183, 38.53748], [-121.28205, 38.5376], [-121.28355, 38.53763], [-121.28389, 38.53766], [-121.28467, 38.53784], [-121.28628, 38.5387], [-121.28665, 38.5387], [-121.28746, 38.53816], [-121.28831, 38.53886], [-121.28745, 38.53963], [-121.28745, 38.53965], [-121.30255, 38.53981], [-121.30254, 38.54027], [-121.29962, 38.54163], [-121.30305, 38.54735]]], [[[-121.27303, 38.54697], [-121.27298, 38.54745], [-121.27276, 38.5477], [-121.27231, 38.54795], [-121.27189, 38.54805], [-121.27153, 38.54807], [-121.27114, 38.54797], [-121.27069, 38.5477], [-121.27032, 38.54743], [-121.27016, 38.54712], [-121.27014, 38.54691], [-121.27016, 38.54678], [-121.27086, 38.54634], [-121.27185, 38.54597], [-121.27209, 38.54611], [-121.27236, 38.54639], [-121.27303, 38.54697]]]]}	Restricted Access 2	22251	Mather	21950	199	Other Federal 284	Federal 1	Federal Agency 1		Other Federal 13	199	Other Federal 280	Federal 1	Federal Agency 1	Sacramento 41	927.044	Mather	Federal Other or Unknown 87	4
14324	14324	14323	{"type": "Polygon", "coordinates": [[[-122.35854, 38.67935], [-122.35842, 38.68289], [-122.35467, 38.68299], [-122.35479, 38.68008], [-122.3509, 38.68006], [-122.35088, 38.6765], [-122.3509, 38.67651], [-122.35493, 38.67653], [-122.35481, 38.67945], [-122.35854, 38.67935]]]}	Restricted Access 2	44307	United States Bureau of Reclamation	26666	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	103	United States Bureau of Reclamation 364	Federal 1	Federal Agency 1	Napa 11	65.157	United States Bureau of Reclamation	Federal Other or Unknown 87	4
14325	14325	14324	{"type": "Polygon", "coordinates": [[[-122.34626, 38.66214], [-122.34624, 38.66945], [-122.34626, 38.67298], [-122.34167, 38.67294], [-122.34167, 38.66942], [-122.33709, 38.66935], [-122.3371, 38.66574], [-122.33254, 38.66574], [-122.33258, 38.66221], [-122.34168, 38.66203], [-122.34626, 38.66214]]]}	Restricted Access 2	44308	United States Bureau of Reclamation	26666	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	103	United States Bureau of Reclamation 364	Federal 1	Federal Agency 1	Napa 11	237.315	United States Bureau of Reclamation	Federal Other or Unknown 87	4
14326	14326	14325	{"type": "Polygon", "coordinates": [[[-122.39024, 38.70124], [-122.3763, 38.70106], [-122.37657, 38.68983], [-122.38125, 38.69003], [-122.38112, 38.69738], [-122.39016, 38.69755], [-122.39024, 38.70124]]]}	Restricted Access 2	44309	United States Bureau of Reclamation	26666	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	103	United States Bureau of Reclamation 364	Federal 1	Federal Agency 1	Napa 11	206.55	United States Bureau of Reclamation	Federal Other or Unknown 87	4

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