calands: units_with_maps: 1 row where ACCESS_TYP = 1, COUNTY = 4, DES_TP = 13 and YR

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

1 row where ACCESS_TYP = 1, COUNTY = 4, DES_TP = 13 and YR_EST = 0

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
17012	17012	17011	{"type": "MultiPolygon", "coordinates": [[[[-116.66952, 32.58545], [-116.65644, 32.58549], [-116.65659, 32.59351], [-116.66097, 32.5936], [-116.66099, 32.59518], [-116.65976, 32.596], [-116.65962, 32.59606], [-116.65932, 32.59614], [-116.659, 32.5962], [-116.65874, 32.5962], [-116.65852, 32.59618], [-116.65794, 32.59608], [-116.65752, 32.59605], [-116.65731, 32.59606], [-116.65708, 32.59608], [-116.65665, 32.59617], [-116.65633, 32.59628], [-116.65579, 32.5965], [-116.65554, 32.59654], [-116.65527, 32.59653], [-116.65503, 32.59647], [-116.65229, 32.59549], [-116.65207, 32.59546], [-116.65179, 32.59546], [-116.65154, 32.59548], [-116.65116, 32.59558], [-116.6496, 32.5962], [-116.64944, 32.59628], [-116.64926, 32.59641], [-116.64905, 32.59666], [-116.64899, 32.59678], [-116.64893, 32.59702], [-116.64791, 32.597], [-116.64765, 32.58584], [-116.6366, 32.586], [-116.63657, 32.58513], [-116.63891, 32.58512], [-116.63889, 32.58424], [-116.63884, 32.58331], [-116.63649, 32.58333], [-116.63647, 32.58252], [-116.63882, 32.58251], [-116.63885, 32.57888], [-116.65193, 32.5786], [-116.65193, 32.57798], [-116.65189, 32.57602], [-116.65622, 32.57558], [-116.65629, 32.57851], [-116.66497, 32.57824], [-116.66509, 32.58175], [-116.66941, 32.58167], [-116.66952, 32.58545]]], [[[-116.6533, 32.5971], [-116.65119, 32.59706], [-116.65063, 32.59705], [-116.65175, 32.59664], [-116.65189, 32.59662], [-116.65199, 32.59664], [-116.6533, 32.5971]]], [[[-116.65667, 32.59717], [-116.65666, 32.59717], [-116.6561, 32.59716], [-116.65666, 32.59698], [-116.65667, 32.59717]]], [[[-116.66099, 32.59726], [-116.66062, 32.59725], [-116.65974, 32.59724], [-116.66042, 32.59697], [-116.66097, 32.59664], [-116.66099, 32.59726]]], [[[-116.69094, 32.5893], [-116.68244, 32.58943], [-116.68242, 32.58634], [-116.68241, 32.58132], [-116.68236, 32.57768], [-116.67392, 32.57797], [-116.67387, 32.57265], [-116.69077, 32.57124], [-116.69082, 32.58084], [-116.69094, 32.5893]]], [[[-116.70334, 32.59791], [-116.69922, 32.59788], [-116.69922, 32.6015], [-116.69093, 32.60139], [-116.69102, 32.59781], [-116.69512, 32.59784], [-116.69508, 32.59357], [-116.69923, 32.59356], [-116.69922, 32.58934], [-116.70332, 32.58937], [-116.70334, 32.59791]]], [[[-116.92353, 32.60446], [-116.92352, 32.60821], [-116.91928, 32.60821], [-116.91928, 32.60447], [-116.91927, 32.60446], [-116.89341, 32.60454], [-116.89345, 32.60825], [-116.88905, 32.60819], [-116.88903, 32.60446], [-116.88467, 32.60441], [-116.88463, 32.60063], [-116.88031, 32.60065], [-116.88021, 32.60807], [-116.88465, 32.60815], [-116.88462, 32.61186], [-116.88014, 32.61181], [-116.88012, 32.62274], [-116.87571, 32.62268], [-116.87572, 32.62635], [-116.87565, 32.63036], [-116.87073, 32.63034], [-116.8707, 32.63761], [-116.8663, 32.63756], [-116.86631, 32.63397], [-116.85686, 32.6339], [-116.84002, 32.63453], [-116.84011, 32.64195], [-116.83128, 32.64233], [-116.83109, 32.63121], [-116.8269, 32.63126], [-116.8268, 32.62758], [-116.8224, 32.62777], [-116.82127, 32.62783], [-116.82124, 32.62216], [-116.81805, 32.62245], [-116.81804, 32.62054], [-116.80539, 32.62125], [-116.79698, 32.62129], [-116.79693, 32.62499], [-116.7885, 32.62501], [-116.78411, 32.62491], [-116.78408, 32.62873], [-116.77983, 32.62853], [-116.7797, 32.63196], [-116.78828, 32.63215], [-116.80511, 32.63227], [-116.80468, 32.64311], [-116.81289, 32.6536], [-116.81324, 32.65404], [-116.81333, 32.65404], [-116.81331, 32.65413], [-116.81759, 32.65945], [-116.83284, 32.65961], [-116.83514, 32.65762], [-116.8352, 32.66305], [-116.82206, 32.66298], [-116.82204, 32.6671], [-116.82195, 32.66699], [-116.82184, 32.66682], [-116.82169, 32.66621], [-116.82162, 32.66621], [-116.82142, 32.66542], [-116.82134, 32.66523], [-116.82128, 32.66513], [-116.82116, 32.66497], [-116.82093, 32.66475], [-116.82034, 32.66432], [-116.82015, 32.66426], [-116.82018, 32.66419], [-116.82014, 32.66416], [-116.8197, 32.66402], [-116.81945, 32.66396], [-116.81903, 32.66392], [-116.81871, 32.66392], [-116.81835, 32.66395], [-116.81802, 32.66402], [-116.81665, 32.66416], [-116.8147, 32.6638], [-116.81353, 32.66304], [-116.81349, 32.66308], [-116.81299, 32.66274], [-116.81283, 32.66259], [-116.81198, 32.6612], [-116.81165, 32.66077], [-116.81131, 32.66042], [-116.80906, 32.65835], [-116.80887, 32.65814], [-116.80867, 32.65783], [-116.80746, 32.6553], [-116.80737, 32.65515], [-116.8073, 32.65504], [-116.80714, 32.65487], [-116.80688, 32.65466], [-116.80668, 32.65455], [-116.80645, 32.65446], [-116.80409, 32.65372], [-116.80368, 32.65363], [-116.80332, 32.65358], [-116.80301, 32.65352], [-116.801, 32.65292], [-116.80067, 32.65286], [-116.8003, 32.65285], [-116.80014, 32.65286], [-116.79985, 32.65293], [-116.79958, 32.65303], [-116.79887, 32.65339], [-116.79871, 32.6535], [-116.79802, 32.65409], [-116.79784, 32.6542], [-116.79764, 32.65429], [-116.79732, 32.65436], [-116.79621, 32.65445], [-116.79602, 32.65445], [-116.7948, 32.65428], [-116.79453, 32.65427], [-116.79449, 32.65412], [-116.79417, 32.65404], [-116.7939, 32.65403], [-116.79283, 32.65379], [-116.79267, 32.65372], [-116.79255, 32.65363], [-116.79244, 32.65353], [-116.79235, 32.65341], [-116.79233, 32.65335], [-116.79219, 32.65325], [-116.79204, 32.65328], [-116.79194, 32.65292], [-116.7919, 32.65287], [-116.79178, 32.65274], [-116.7916, 32.65265], [-116.79117, 32.65251], [-116.79093, 32.65247], [-116.79069, 32.65249], [-116.79051, 32.65254], [-116.79006, 32.65274], [-116.78987, 32.65278], [-116.78972, 32.65279], [-116.78965, 32.65288], [-116.78957, 32.65291], [-116.78945, 32.65291], [-116.78941, 32.65289], [-116.78933, 32.6528], [-116.78912, 32.65273], [-116.78903, 32.65266], [-116.78887, 32.65226], [-116.78885, 32.65212], [-116.78887, 32.65181], [-116.78886, 32.65164], [-116.78865, 32.65075], [-116.78856, 32.6506], [-116.78839, 32.65045], [-116.78821, 32.65038], [-116.78747, 32.65031], [-116.7873, 32.65026], [-116.78715, 32.65018], [-116.787, 32.65004], [-116.78651, 32.6492], [-116.7865, 32.64914], [-116.78655, 32.64872], [-116.78653, 32.64858], [-116.78648, 32.64846], [-116.78623, 32.64814], [-116.78618, 32.64804], [-116.78615, 32.64793], [-116.78614, 32.6467], [-116.7861, 32.64652], [-116.78601, 32.64637], [-116.78592, 32.64627], [-116.78582, 32.6462], [-116.78557, 32.64607], [-116.78533, 32.646], [-116.78514, 32.64597], [-116.78457, 32.64596], [-116.78441, 32.64594], [-116.78412, 32.64588], [-116.78382, 32.64575], [-116.78375, 32.6392], [-116.77518, 32.63919], [-116.77519, 32.63866], [-116.77518, 32.63865], [-116.76751, 32.63863], [-116.7673, 32.6385], [-116.76705, 32.63826], [-116.76623, 32.63782], [-116.7661, 32.63774], [-116.76592, 32.63759], [-116.76573, 32.63736], [-116.76529, 32.63658], [-116.76522, 32.63642], [-116.76511, 32.63606], [-116.76508, 32.63582], [-116.76508, 32.6355], [-116.77113, 32.6355], [-116.77119, 32.63178], [-116.76852, 32.63181], [-116.76851, 32.62902], [-116.7679, 32.62896], [-116.76886, 32.62859], [-116.76916, 32.62817], [-116.7696, 32.62758], [-116.77073, 32.62554], [-116.77121, 32.6245], [-116.77117, 32.62368], [-116.77114, 32.6207], [-116.77108, 32.61813], [-116.77104, 32.61797], [-116.771, 32.61696], [-116.77526, 32.6171], [-116.77528, 32.6134], [-116.77974, 32.61354], [-116.77974, 32.61082], [-116.78416, 32.61093], [-116.78415, 32.61368], [-116.78862, 32.61382], [-116.78869, 32.59913], [-116.77784, 32.59902], [-116.77453, 32.59558], [-116.77103, 32.59288], [-116.76957, 32.59388], [-116.77283, 32.59643], [-116.77527, 32.599], [-116.77069, 32.59896], [-116.76627, 32.59901], [-116.7663, 32.5999], [-116.76641, 32.60612], [-116.75414, 32.60618], [-116.7452, 32.6064], [-116.74503, 32.59923], [-116.74289, 32.59925], [-116.74288, 32.59926], [-116.7429, 32.6], [-116.74309, 32.60645], [-116.74105, 32.60651], [-116.74092, 32.6029], [-116.73263, 32.603], [-116.73261, 32.60297], [-116.72833, 32.60298], [-116.72821, 32.5994], [-116.72845, 32.59121], [-116.74514, 32.59151], [-116.74509, 32.59534], [-116.75351, 32.59539], [-116.75366, 32.59538], [-116.75374, 32.58427], [-116.76212, 32.58426], [-116.76217, 32.58046], [-116.77099, 32.58015], [-116.78401, 32.57978], [-116.78396, 32.56787], [-116.78817, 32.56748], [-116.79696, 32.56738], [-116.79686, 32.56361], [-116.80118, 32.56352], [-116.80114, 32.56182], [-116.82267, 32.56], [-116.82268, 32.56003], [-116.84085, 32.55849], [-116.84086, 32.55846], [-116.87505, 32.55557], [-116.87525, 32.56395], [-116.8841, 32.564], [-116.88412, 32.56637], [-116.88413, 32.57126], [-116.8929, 32.57127], [-116.89287, 32.57483], [-116.90172, 32.57481], [-116.9016, 32.58217], [-116.89281, 32.58218], [-116.89306, 32.58965], [-116.90622, 32.5896], [-116.90627, 32.59144], [-116.91066, 32.59141], [-116.9108, 32.59701], [-116.91929, 32.59695], [-116.91927, 32.59916], [-116.91928, 32.60446], [-116.92353, 32.60446]], [[-116.78863, 32.61382], [-116.78858, 32.61755], [-116.79276, 32.61755], [-116.79282, 32.61385], [-116.78863, 32.61382]], [[-116.86647, 32.62263], [-116.86654, 32.61903], [-116.86228, 32.61896], [-116.86235, 32.61529], [-116.85767, 32.61522], [-116.85766, 32.61523], [-116.85341, 32.61531], [-116.85328, 32.61895], [-116.85751, 32.61887], [-116.85736, 32.62253], [-116.86647, 32.62263]]], [[[-116.74547, 32.62115], [-116.74547, 32.62115], [-116.74495, 32.62098], [-116.74547, 32.62097], [-116.74547, 32.62115]]], [[[-116.77107, 32.62441], [-116.77107, 32.62448], [-116.77062, 32.6255], [-116.76948, 32.62752], [-116.76877, 32.62851], [-116.76764, 32.62894], [-116.76762, 32.62896], [-116.76737, 32.62893], [-116.76691, 32.62931], [-116.76692, 32.62916], [-116.76716, 32.62894], [-116.76692, 32.62889], [-116.76693, 32.62815], [-116.76761, 32.62815], [-116.76782, 32.62772], [-116.76781, 32.62771], [-116.76691, 32.62772], [-116.76682, 32.62455], [-116.76866, 32.62452], [-116.76866, 32.62443], [-116.77107, 32.62441]]]]}	Open Access 1	5515	Otay National Co-op Land & Wildlife Management Area	23244	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		San Diego 4	25221.302	Otay Nat. Co-op Land & WMA	0	Conservation Area 13	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]);