calands: units_with_maps: 1 row where COUNTY = 16, DES_TP = 1 and MNG

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

1 row where COUNTY = 16, DES_TP = 1 and MNG_AGENCY = 1

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
10419	10419	10418	{"type": "MultiPolygon", "coordinates": [[[[-122.42296, 38.32604], [-122.42294, 38.33326], [-122.4138, 38.33332], [-122.41375, 38.33137], [-122.41382, 38.33119], [-122.41382, 38.33103], [-122.41374, 38.33078], [-122.41362, 38.32602], [-122.42296, 38.32604]]], [[[-122.535, 38.46239], [-122.53494, 38.46612], [-122.5299, 38.46625], [-122.52989, 38.46251], [-122.53058, 38.46251], [-122.53059, 38.46249], [-122.535, 38.46239]]], [[[-122.7066, 38.71406], [-122.69732, 38.71412], [-122.69737, 38.71774], [-122.70191, 38.71772], [-122.70192, 38.72144], [-122.6971, 38.7215], [-122.69693, 38.72126], [-122.69684, 38.72117], [-122.69685, 38.72108], [-122.69682, 38.72103], [-122.69653, 38.72085], [-122.69659, 38.72067], [-122.69669, 38.7205], [-122.69729, 38.71974], [-122.69733, 38.71952], [-122.69738, 38.71954], [-122.69753, 38.71938], [-122.69761, 38.71919], [-122.69761, 38.719], [-122.69758, 38.7189], [-122.69747, 38.71872], [-122.69742, 38.71862], [-122.69728, 38.71843], [-122.69707, 38.71828], [-122.6968, 38.71816], [-122.69669, 38.71807], [-122.69665, 38.71801], [-122.69656, 38.71779], [-122.69649, 38.71748], [-122.69645, 38.71708], [-122.69647, 38.71697], [-122.69644, 38.71686], [-122.69641, 38.71681], [-122.69626, 38.71668], [-122.69621, 38.7166], [-122.69618, 38.71649], [-122.69614, 38.71644], [-122.696, 38.71631], [-122.69589, 38.71613], [-122.69578, 38.716], [-122.69557, 38.7158], [-122.69551, 38.71572], [-122.69543, 38.71555], [-122.69542, 38.71546], [-122.69546, 38.71493], [-122.69558, 38.71438], [-122.6956, 38.71418], [-122.69732, 38.71411], [-122.69732, 38.71043], [-122.69277, 38.71047], [-122.69274, 38.71204], [-122.69268, 38.71176], [-122.69257, 38.71162], [-122.69206, 38.71125], [-122.69195, 38.71111], [-122.69177, 38.71098], [-122.69138, 38.71081], [-122.69086, 38.71073], [-122.69041, 38.71076], [-122.69014, 38.71073], [-122.68945, 38.71077], [-122.68917, 38.71077], [-122.68879, 38.71069], [-122.68794, 38.71044], [-122.6874, 38.71038], [-122.68716, 38.71031], [-122.68678, 38.71015], [-122.6862, 38.70987], [-122.68563, 38.70967], [-122.68534, 38.70954], [-122.68418, 38.7091], [-122.68312, 38.70808], [-122.68243, 38.70785], [-122.68223, 38.70787], [-122.68193, 38.70787], [-122.68169, 38.70785], [-122.68125, 38.70773], [-122.68086, 38.70755], [-122.68047, 38.70735], [-122.68027, 38.70737], [-122.67999, 38.70744], [-122.67967, 38.7076], [-122.67858, 38.70801], [-122.67808, 38.70807], [-122.67739, 38.70801], [-122.67718, 38.70803], [-122.67649, 38.7079], [-122.67587, 38.70752], [-122.6757, 38.70714], [-122.67558, 38.70699], [-122.67545, 38.7069], [-122.67525, 38.70686], [-122.6748, 38.7068], [-122.67428, 38.70651], [-122.67387, 38.70637], [-122.67344, 38.7063], [-122.67329, 38.70625], [-122.67329, 38.70646], [-122.67316, 38.70643], [-122.67316, 38.706], [-122.66862, 38.70591], [-122.65453, 38.70628], [-122.65453, 38.70268], [-122.65993, 38.70257], [-122.66373, 38.70263], [-122.66368, 38.69911], [-122.66831, 38.6992], [-122.66828, 38.69567], [-122.67295, 38.69574], [-122.67287, 38.69539], [-122.67289, 38.69226], [-122.67743, 38.69234], [-122.67738, 38.69584], [-122.68193, 38.69596], [-122.68206, 38.69945], [-122.68806, 38.6996], [-122.68812, 38.70313], [-122.69724, 38.70316], [-122.69724, 38.70673], [-122.702, 38.70672], [-122.70198, 38.7104], [-122.70659, 38.71035], [-122.7066, 38.71406]]], [[[-122.7025, 38.72381], [-122.70017, 38.72333], [-122.69824, 38.72306], [-122.69825, 38.72267], [-122.69809, 38.7225], [-122.69805, 38.72226], [-122.69799, 38.72214], [-122.69787, 38.72202], [-122.69738, 38.72168], [-122.7025, 38.72381]]], [[[-122.70171, 38.72776], [-122.70062, 38.72747], [-122.70068, 38.72632], [-122.69948, 38.72569], [-122.69892, 38.72533], [-122.6985, 38.72464], [-122.69958, 38.72488], [-122.70041, 38.72551], [-122.70169, 38.72589], [-122.70171, 38.72776]]], [[[-122.70956, 38.72815], [-122.70928, 38.7285], [-122.70571, 38.72766], [-122.70528, 38.72874], [-122.70467, 38.72847], [-122.70595, 38.72718], [-122.70463, 38.72661], [-122.70599, 38.7246], [-122.70671, 38.72351], [-122.70671, 38.7246], [-122.70648, 38.7245], [-122.70538, 38.7258], [-122.70956, 38.72815]]], [[[-122.72576, 38.73257], [-122.72489, 38.73394], [-122.72471, 38.73416], [-122.72371, 38.73377], [-122.7238, 38.7336], [-122.7238, 38.73359], [-122.72039, 38.73223], [-122.71954, 38.73358], [-122.71583, 38.73211], [-122.7158, 38.73313], [-122.71595, 38.73325], [-122.71474, 38.73407], [-122.71364, 38.73312], [-122.71445, 38.73254], [-122.71481, 38.73261], [-122.71569, 38.7304], [-122.71441, 38.72986], [-122.71536, 38.72841], [-122.71675, 38.72896], [-122.71748, 38.72865], [-122.71883, 38.72792], [-122.71883, 38.72791], [-122.71812, 38.72707], [-122.71593, 38.72463], [-122.7158, 38.72451], [-122.71073, 38.72726], [-122.71136, 38.72802], [-122.70997, 38.72773], [-122.71074, 38.72686], [-122.70746, 38.72501], [-122.71132, 38.72501], [-122.71135, 38.72136], [-122.71111, 38.72135], [-122.71113, 38.71763], [-122.71578, 38.71761], [-122.71578, 38.71394], [-122.72039, 38.71391], [-122.72038, 38.72127], [-122.72492, 38.72128], [-122.72487, 38.72854], [-122.72487, 38.73218], [-122.72576, 38.73257]]], [[[-122.75588, 38.75843], [-122.75411, 38.75933], [-122.75286, 38.75783], [-122.75285, 38.75783], [-122.75367, 38.75959], [-122.75347, 38.75969], [-122.75346, 38.7597], [-122.75517, 38.76186], [-122.75554, 38.76206], [-122.75134, 38.76407], [-122.75035, 38.76503], [-122.74817, 38.76505], [-122.74807, 38.76521], [-122.74792, 38.76003], [-122.74346, 38.76008], [-122.73923, 38.76008], [-122.73466, 38.76031], [-122.73472, 38.76511], [-122.72587, 38.76524], [-122.72587, 38.76488], [-122.72591, 38.76483], [-122.72565, 38.7646], [-122.72535, 38.76448], [-122.72496, 38.7644], [-122.72483, 38.76433], [-122.72466, 38.76412], [-122.72457, 38.76385], [-122.72439, 38.76358], [-122.72407, 38.76328], [-122.72372, 38.76311], [-122.7235, 38.76308], [-122.72299, 38.76311], [-122.72289, 38.76304], [-122.72282, 38.76295], [-122.7228, 38.76281], [-122.72292, 38.76256], [-122.72312, 38.76225], [-122.72325, 38.76198], [-122.72342, 38.76153], [-122.7235, 38.76105], [-122.72348, 38.75987], [-122.72337, 38.75942], [-122.72325, 38.75907], [-122.72324, 38.75871], [-122.72325, 38.7585], [-122.72332, 38.75832], [-122.72363, 38.75763], [-122.72372, 38.75752], [-122.7239, 38.75707], [-122.72399, 38.75656], [-122.72344, 38.75652], [-122.72318, 38.75655], [-122.72205, 38.75665], [-122.72157, 38.75667], [-122.72132, 38.75651], [-122.7211, 38.75618], [-122.72103, 38.75591], [-122.72069, 38.75509], [-122.72016, 38.75408], [-122.71922, 38.75321], [-122.71899, 38.75318], [-122.71792, 38.75313], [-122.71744, 38.75299], [-122.71733, 38.75293], [-122.71718, 38.75273], [-122.71684, 38.75221], [-122.71665, 38.75206], [-122.71638, 38.75197], [-122.71603, 38.7519], [-122.71572, 38.7519], [-122.71511, 38.75199], [-122.71464, 38.75193], [-122.7142, 38.75165], [-122.71306, 38.75109], [-122.71284, 38.75102], [-122.71255, 38.75097], [-122.7123, 38.7509], [-122.71206, 38.75088], [-122.71183, 38.75083], [-122.71166, 38.75074], [-122.71147, 38.75061], [-122.71138, 38.75048], [-122.71135, 38.75027], [-122.71146, 38.74991], [-122.71143, 38.74991], [-122.71115, 38.74971], [-122.71095, 38.74962], [-122.71042, 38.74932], [-122.71018, 38.74914], [-122.70974, 38.7489], [-122.70937, 38.74891], [-122.70905, 38.74895], [-122.70889, 38.7489], [-122.70879, 38.74881], [-122.70865, 38.74863], [-122.70857, 38.74834], [-122.70857, 38.7482], [-122.70863, 38.74802], [-122.70863, 38.7474], [-122.70866, 38.74705], [-122.70865, 38.74698], [-122.70865, 38.74666], [-122.70869, 38.7465], [-122.70879, 38.74632], [-122.70893, 38.74616], [-122.70931, 38.74581], [-122.70964, 38.74567], [-122.70971, 38.74553], [-122.70979, 38.74522], [-122.7099, 38.74504], [-122.71006, 38.74501], [-122.71035, 38.7449], [-122.71054, 38.74479], [-122.71066, 38.7447], [-122.71072, 38.7446], [-122.71071, 38.74386], [-122.71098, 38.7436], [-122.71108, 38.74339], [-122.71136, 38.74297], [-122.71162, 38.74273], [-122.7119, 38.74258], [-122.71211, 38.74252], [-122.71224, 38.74246], [-122.71234, 38.74231], [-122.7124, 38.74201], [-122.71243, 38.7417], [-122.71243, 38.74154], [-122.71239, 38.74137], [-122.71231, 38.74128], [-122.71192, 38.74103], [-122.71178, 38.74091], [-122.71147, 38.74044], [-122.71134, 38.74029], [-122.71108, 38.74009], [-122.71096, 38.73994], [-122.71095, 38.73979], [-122.71099, 38.73963], [-122.71117, 38.73966], [-122.71125, 38.73955], [-122.71552, 38.73967], [-122.71525, 38.74361], [-122.72374, 38.74408], [-122.72493, 38.73587], [-122.73224, 38.7358], [-122.73224, 38.73586], [-122.73411, 38.73596], [-122.73413, 38.73578], [-122.73529, 38.73573], [-122.73517, 38.7376], [-122.73402, 38.73766], [-122.73391, 38.73951], [-122.73392, 38.73952], [-122.73865, 38.73927], [-122.73872, 38.73742], [-122.74109, 38.73728], [-122.74111, 38.73637], [-122.73875, 38.73651], [-122.73878, 38.73557], [-122.7434, 38.73536], [-122.74341, 38.7426], [-122.74862, 38.74282], [-122.74868, 38.74582], [-122.7474, 38.74649], [-122.74988, 38.75166], [-122.75012, 38.75155], [-122.75588, 38.75843]]], [[[-122.7397, 38.77866], [-122.73668, 38.7787], [-122.73617, 38.77714], [-122.73632, 38.77694], [-122.73635, 38.77683], [-122.73623, 38.77638], [-122.73607, 38.77606], [-122.73602, 38.7758], [-122.73593, 38.77563], [-122.73568, 38.77563], [-122.73557, 38.77528], [-122.73969, 38.77525], [-122.7397, 38.77866]]], [[[-122.76708, 38.78507], [-122.75787, 38.78503], [-122.7574, 38.7922], [-122.74934, 38.79217], [-122.74783, 38.79219], [-122.74799, 38.78498], [-122.74428, 38.78501], [-122.74428, 38.78497], [-122.74418, 38.78495], [-122.74404, 38.78481], [-122.74376, 38.78432], [-122.74374, 38.78425], [-122.74353, 38.78384], [-122.7433, 38.78355], [-122.74311, 38.78338], [-122.74289, 38.78314], [-122.74249, 38.78251], [-122.74226, 38.78237], [-122.74217, 38.78236], [-122.74147, 38.78234], [-122.74114, 38.78241], [-122.74082, 38.78235], [-122.74048, 38.78234], [-122.74025, 38.78228], [-122.73996, 38.78223], [-122.7396, 38.7822], [-122.73926, 38.78206], [-122.73915, 38.78198], [-122.73915, 38.78193], [-122.73908, 38.78192], [-122.73911, 38.78158], [-122.75743, 38.78164], [-122.76682, 38.78171], [-122.76708, 38.78507]], [[-122.75677, 38.7907], [-122.757, 38.79088], [-122.75741, 38.79054], [-122.75745, 38.79024], [-122.75706, 38.78982], [-122.75639, 38.78983], [-122.75562, 38.79001], [-122.75525, 38.78984], [-122.75445, 38.78977], [-122.75404, 38.78951], [-122.75367, 38.78952], [-122.75378, 38.79], [-122.75433, 38.7902], [-122.75376, 38.79074], [-122.75376, 38.79076], [-122.75543, 38.79134], [-122.75677, 38.7907]]], [[[-122.77926, 38.75504], [-122.77694, 38.75516], [-122.77558, 38.7552], [-122.77176, 38.75789], [-122.76889, 38.7554], [-122.76758, 38.75544], [-122.76769, 38.75961], [-122.75775, 38.75968], [-122.75648, 38.75813], [-122.75631, 38.75821], [-122.7551, 38.75569], [-122.75816, 38.75564], [-122.75807, 38.75149], [-122.76682, 38.75115], [-122.76682, 38.75114], [-122.76646, 38.75082], [-122.76802, 38.74972], [-122.76955, 38.75104], [-122.77676, 38.75073], [-122.77685, 38.75294], [-122.77917, 38.75286], [-122.77926, 38.75504]]], [[[-122.76383, 38.76553], [-122.76241, 38.7644], [-122.76255, 38.76422], [-122.76255, 38.76422], [-122.76383, 38.76553]]], [[[-122.77698, 38.76917], [-122.77581, 38.77052], [-122.77062, 38.76883], [-122.7711, 38.7682], [-122.76676, 38.76598], [-122.76501, 38.7642], [-122.76725, 38.7661], [-122.77698, 38.76917]]], [[[-122.77895, 38.76489], [-122.77746, 38.76605], [-122.77666, 38.76542], [-122.77654, 38.76537], [-122.77646, 38.76527], [-122.77009, 38.76026], [-122.771, 38.75961], [-122.77161, 38.75912], [-122.77223, 38.7596], [-122.77642, 38.76292], [-122.77642, 38.76297], [-122.77895, 38.76489]]], [[[-122.79498, 38.7957], [-122.79501, 38.79914], [-122.79489, 38.80289], [-122.78073, 38.80291], [-122.78072, 38.79918], [-122.78538, 38.79914], [-122.79023, 38.79914], [-122.7902, 38.79571], [-122.79498, 38.7957]]], [[[-122.84224, 38.75864], [-122.83561, 38.75861], [-122.83538, 38.7534], [-122.83971, 38.75332], [-122.84064, 38.75518], [-122.84224, 38.75864]]], [[[-123.03688, 38.67899], [-123.0283, 38.67911], [-123.02823, 38.67871], [-123.02856, 38.67185], [-123.03678, 38.67174], [-123.03688, 38.67899]]], [[[-123.04144, 38.74921], [-123.04142, 38.75059], [-123.03697, 38.75057], [-123.03701, 38.74919], [-123.04144, 38.74921]]], [[[-123.0504, 38.61262], [-123.04641, 38.61291], [-123.04632, 38.60913], [-123.05029, 38.60885], [-123.0504, 38.61262]]], [[[-123.06269, 38.61542], [-123.05861, 38.61576], [-123.05876, 38.61952], [-123.05464, 38.61985], [-123.05439, 38.61233], [-123.06251, 38.61166], [-123.06269, 38.61542]]], [[[-123.0704, 38.60723], [-123.06233, 38.6079], [-123.06215, 38.60414], [-123.05814, 38.60447], [-123.05795, 38.60082], [-123.06189, 38.60041], [-123.06216, 38.60414], [-123.07017, 38.60347], [-123.0704, 38.60723]]], [[[-123.13538, 38.61068], [-123.13093, 38.61074], [-123.12629, 38.61072], [-123.12641, 38.61175], [-123.12702, 38.61971], [-123.1273, 38.62393], [-123.12734, 38.62491], [-123.1274, 38.62536], [-123.12765, 38.62913], [-123.12778, 38.62914], [-123.12782, 38.63911], [-123.12198, 38.63904], [-123.12143, 38.63536], [-123.11665, 38.63527], [-123.11664, 38.63528], [-123.11763, 38.63899], [-123.10914, 38.63892], [-123.10722, 38.64038], [-123.10584, 38.63666], [-123.10446, 38.63805], [-123.10343, 38.63347], [-123.10171, 38.63682], [-123.10183, 38.63269], [-123.10225, 38.63086], [-123.10308, 38.63163], [-123.10568, 38.63057], [-123.10572, 38.63053], [-123.10496, 38.62932], [-123.10677, 38.62855], [-123.10566, 38.62664], [-123.09992, 38.61755], [-123.09939, 38.61674], [-123.11505, 38.6166], [-123.11444, 38.60317], [-123.10527, 38.60349], [-123.1051, 38.59985], [-123.11924, 38.59944], [-123.11925, 38.603], [-123.12569, 38.60277], [-123.12577, 38.60351], [-123.13042, 38.60349], [-123.13048, 38.60708], [-123.13529, 38.6071], [-123.13538, 38.61068]]], [[[-123.14491, 38.62141], [-123.14203, 38.62143], [-123.14062, 38.62137], [-123.14053, 38.61789], [-123.14481, 38.61793], [-123.1448, 38.61956], [-123.14491, 38.62141]]]]}	Open Access 1	21477	BLM	16162	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1		Sonoma 16	6979.926	BLM	1899	National Public Lands 1	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]);