calands: units_with_maps: 1 row where ACCESS_TYP = 1, COUNTY = 29 and MNG

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

1 row where ACCESS_TYP = 1, COUNTY = 29 and MNG_AGENCY = 343

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
16924	16924	16923	{"type": "MultiPolygon", "coordinates": [[[[-118.69888, 36.24772], [-118.68524, 36.24789], [-118.68526, 36.25153], [-118.6807, 36.25158], [-118.68034, 36.25523], [-118.67129, 36.25521], [-118.67077, 36.25956], [-118.65647, 36.25931], [-118.65611, 36.26667], [-118.6699, 36.26677], [-118.66907, 36.27351], [-118.66164, 36.27338], [-118.66181, 36.27005], [-118.65593, 36.27001], [-118.6561, 36.26667], [-118.65084, 36.26663], [-118.65119, 36.25926], [-118.64573, 36.25922], [-118.64585, 36.2553], [-118.64164, 36.25514], [-118.64141, 36.24797], [-118.63687, 36.24777], [-118.63674, 36.25123], [-118.63241, 36.25117], [-118.63239, 36.24762], [-118.62786, 36.24757], [-118.62783, 36.24395], [-118.62339, 36.24385], [-118.62338, 36.24022], [-118.64144, 36.24048], [-118.64152, 36.24407], [-118.6517, 36.24426], [-118.65187, 36.2371], [-118.66334, 36.23728], [-118.66382, 36.22994], [-118.65812, 36.22986], [-118.65846, 36.22224], [-118.66505, 36.2223], [-118.66502, 36.21524], [-118.66958, 36.21528], [-118.66955, 36.21169], [-118.67915, 36.21167], [-118.67922, 36.20462], [-118.68845, 36.20462], [-118.6885, 36.20825], [-118.68968, 36.20826], [-118.6897, 36.2087], [-118.6893, 36.20927], [-118.68932, 36.20994], [-118.68947, 36.21041], [-118.68867, 36.21152], [-118.68791, 36.21176], [-118.68733, 36.21139], [-118.68629, 36.21101], [-118.68549, 36.20962], [-118.68504, 36.20938], [-118.68448, 36.20976], [-118.68401, 36.21052], [-118.68364, 36.21057], [-118.68279, 36.21015], [-118.68228, 36.21033], [-118.6817, 36.21086], [-118.68085, 36.21094], [-118.68039, 36.21123], [-118.68048, 36.21177], [-118.68157, 36.21277], [-118.6815, 36.21328], [-118.68081, 36.21425], [-118.68083, 36.21617], [-118.68026, 36.21654], [-118.67937, 36.21634], [-118.67842, 36.21564], [-118.67801, 36.21504], [-118.67749, 36.21481], [-118.67685, 36.21414], [-118.67639, 36.2141], [-118.67604, 36.21488], [-118.67609, 36.21598], [-118.67545, 36.21798], [-118.67466, 36.21849], [-118.67262, 36.21945], [-118.67147, 36.22048], [-118.67025, 36.22108], [-118.66995, 36.22102], [-118.66927, 36.22081], [-118.66863, 36.22115], [-118.66828, 36.22184], [-118.66836, 36.22234], [-118.66856, 36.22234], [-118.66849, 36.22186], [-118.6688, 36.22124], [-118.66929, 36.22098], [-118.66989, 36.22117], [-118.67029, 36.22126], [-118.67161, 36.2206], [-118.67275, 36.21958], [-118.67477, 36.21864], [-118.67563, 36.21807], [-118.67629, 36.216], [-118.67625, 36.21491], [-118.67653, 36.21428], [-118.67674, 36.21429], [-118.67735, 36.21494], [-118.67787, 36.21516], [-118.67826, 36.21575], [-118.67926, 36.21649], [-118.68016, 36.21669], [-118.67993, 36.2175], [-118.67984, 36.21845], [-118.67961, 36.21893], [-118.67914, 36.21893], [-118.67444, 36.22236], [-118.66964, 36.22235], [-118.66991, 36.22606], [-118.67953, 36.22615], [-118.67932, 36.2224], [-118.67975, 36.22239], [-118.67964, 36.22269], [-118.67969, 36.22329], [-118.68027, 36.225], [-118.68046, 36.22575], [-118.68081, 36.22624], [-118.68105, 36.22671], [-118.68107, 36.22704], [-118.68094, 36.22742], [-118.68062, 36.22783], [-118.68022, 36.2282], [-118.67988, 36.22845], [-118.67883, 36.22894], [-118.6784, 36.22924], [-118.67818, 36.22949], [-118.67806, 36.22995], [-118.67813, 36.23029], [-118.67854, 36.23069], [-118.67905, 36.23078], [-118.67963, 36.23069], [-118.68019, 36.23057], [-118.68063, 36.2304], [-118.6811, 36.2303], [-118.68214, 36.23013], [-118.68262, 36.23013], [-118.68363, 36.23026], [-118.68412, 36.2304], [-118.68472, 36.23078], [-118.6857, 36.23119], [-118.6862, 36.23126], [-118.68667, 36.23127], [-118.68746, 36.2311], [-118.68864, 36.23109], [-118.68901, 36.23102], [-118.68919, 36.23329], [-118.69385, 36.23327], [-118.6938, 36.23256], [-118.69412, 36.23306], [-118.69424, 36.23342], [-118.69419, 36.2339], [-118.69404, 36.23426], [-118.69383, 36.23462], [-118.69373, 36.23488], [-118.69369, 36.23542], [-118.6935, 36.23574], [-118.69343, 36.23604], [-118.69344, 36.23614], [-118.69288, 36.23615], [-118.69227, 36.23631], [-118.69172, 36.23671], [-118.69129, 36.23718], [-118.69076, 36.2374], [-118.68994, 36.23753], [-118.68904, 36.23755], [-118.68789, 36.23748], [-118.68673, 36.23737], [-118.68619, 36.23739], [-118.6851, 36.23754], [-118.68397, 36.23773], [-118.68302, 36.23804], [-118.68233, 36.23842], [-118.6819, 36.23874], [-118.68189, 36.23918], [-118.68063, 36.2393], [-118.67997, 36.23951], [-118.67914, 36.24034], [-118.6784, 36.24116], [-118.67806, 36.24127], [-118.67711, 36.24169], [-118.67662, 36.24195], [-118.67632, 36.24223], [-118.67593, 36.2425], [-118.67498, 36.24266], [-118.67354, 36.24227], [-118.6725, 36.24191], [-118.67257, 36.24166], [-118.67281, 36.24104], [-118.67287, 36.24002], [-118.67284, 36.23813], [-118.67256, 36.23724], [-118.67194, 36.23646], [-118.67171, 36.23585], [-118.67168, 36.23554], [-118.67179, 36.23497], [-118.67173, 36.23428], [-118.6715, 36.23397], [-118.67133, 36.23404], [-118.67133, 36.23406], [-118.67154, 36.23432], [-118.67158, 36.23496], [-118.67147, 36.23552], [-118.6715, 36.23587], [-118.67175, 36.23653], [-118.67238, 36.23729], [-118.67264, 36.23814], [-118.67267, 36.24001], [-118.67261, 36.24101], [-118.67237, 36.24161], [-118.67204, 36.24285], [-118.67163, 36.24347], [-118.67144, 36.24385], [-118.67146, 36.24444], [-118.67181, 36.24493], [-118.67243, 36.24536], [-118.67273, 36.24586], [-118.67279, 36.24633], [-118.67267, 36.24693], [-118.67232, 36.24726], [-118.67177, 36.24764], [-118.67147, 36.24778], [-118.67148, 36.24796], [-118.67149, 36.24796], [-118.6719, 36.24777], [-118.67246, 36.24737], [-118.67286, 36.24702], [-118.673, 36.24635], [-118.67291, 36.24582], [-118.6726, 36.24527], [-118.67196, 36.24483], [-118.67166, 36.24441], [-118.67164, 36.24388], [-118.67182, 36.24355], [-118.67224, 36.24291], [-118.67246, 36.24207], [-118.67347, 36.24243], [-118.67499, 36.24283], [-118.67603, 36.24265], [-118.67647, 36.24236], [-118.67676, 36.24207], [-118.67721, 36.24182], [-118.67779, 36.24157], [-118.67854, 36.24129], [-118.67901, 36.24079], [-118.67931, 36.24043], [-118.6801, 36.23966], [-118.68017, 36.23963], [-118.68044, 36.24427], [-118.6828, 36.24427], [-118.68256, 36.23849], [-118.68312, 36.23818], [-118.68404, 36.2379], [-118.68515, 36.2377], [-118.68621, 36.23755], [-118.68674, 36.23753], [-118.68787, 36.23764], [-118.68903, 36.23772], [-118.68997, 36.2377], [-118.69083, 36.23755], [-118.69143, 36.2373], [-118.69187, 36.23681], [-118.69239, 36.23645], [-118.69292, 36.2363], [-118.69438, 36.23631], [-118.69533, 36.23596], [-118.69618, 36.23542], [-118.69701, 36.23481], [-118.69756, 36.23443], [-118.69788, 36.23408], [-118.69869, 36.23327], [-118.69888, 36.24772]]], [[[-118.68905, 36.23085], [-118.68861, 36.23093], [-118.68742, 36.23093], [-118.68663, 36.23111], [-118.68621, 36.2311], [-118.68577, 36.23104], [-118.68483, 36.23066], [-118.68422, 36.23027], [-118.68369, 36.23009], [-118.68261, 36.22998], [-118.6821, 36.22998], [-118.68104, 36.23015], [-118.68055, 36.23025], [-118.68011, 36.23042], [-118.67957, 36.23053], [-118.67904, 36.23062], [-118.67866, 36.23054], [-118.67832, 36.23022], [-118.67827, 36.22995], [-118.67838, 36.22957], [-118.67858, 36.22935], [-118.67897, 36.22906], [-118.68, 36.22859], [-118.68037, 36.22831], [-118.68079, 36.22794], [-118.68115, 36.22749], [-118.68127, 36.22705], [-118.68126, 36.22668], [-118.681, 36.22618], [-118.68066, 36.22569], [-118.68047, 36.22497], [-118.67991, 36.22327], [-118.67985, 36.22272], [-118.67997, 36.2224], [-118.68392, 36.22242], [-118.6844, 36.22973], [-118.68899, 36.2297], [-118.68905, 36.23085]]], [[[-118.69796, 36.21535], [-118.6886, 36.21533], [-118.68873, 36.22241], [-118.68642, 36.22241], [-118.68627, 36.21896], [-118.67982, 36.21893], [-118.68004, 36.21848], [-118.68013, 36.21752], [-118.68037, 36.21668], [-118.68103, 36.21625], [-118.68102, 36.21429], [-118.6817, 36.21333], [-118.68178, 36.21272], [-118.68066, 36.21169], [-118.6806, 36.2113], [-118.68093, 36.2111], [-118.68181, 36.21101], [-118.68241, 36.21046], [-118.68277, 36.21033], [-118.6836, 36.21073], [-118.68414, 36.21067], [-118.68463, 36.20987], [-118.68506, 36.20958], [-118.68534, 36.20973], [-118.68614, 36.21114], [-118.68722, 36.21153], [-118.68787, 36.21195], [-118.6888, 36.21165], [-118.68968, 36.21043], [-118.68952, 36.20991], [-118.6895, 36.20932], [-118.68991, 36.20874], [-118.68989, 36.20826], [-118.69775, 36.2083], [-118.69796, 36.21535]]], [[[-118.69867, 36.23304], [-118.69818, 36.23354], [-118.69771, 36.23398], [-118.6974, 36.23433], [-118.69605, 36.2353], [-118.69521, 36.23583], [-118.69433, 36.23615], [-118.69364, 36.23616], [-118.69364, 36.23606], [-118.6937, 36.2358], [-118.69389, 36.23545], [-118.69394, 36.23492], [-118.69402, 36.23468], [-118.69424, 36.23432], [-118.6944, 36.23394], [-118.69445, 36.23341], [-118.69432, 36.233], [-118.694, 36.2325], [-118.6937, 36.23187], [-118.6936, 36.22971], [-118.69852, 36.2298], [-118.69867, 36.23304]]], [[[-118.7127, 36.23619], [-118.71263, 36.23661], [-118.7123, 36.23741], [-118.70768, 36.23743], [-118.70775, 36.2444], [-118.70786, 36.25125], [-118.7033, 36.25131], [-118.70296, 36.23744], [-118.70767, 36.23742], [-118.70781, 36.22937], [-118.70795, 36.22939], [-118.70833, 36.23031], [-118.70878, 36.23091], [-118.70919, 36.23123], [-118.70995, 36.23141], [-118.71121, 36.23116], [-118.71177, 36.23108], [-118.71203, 36.23112], [-118.71229, 36.23121], [-118.71268, 36.23162], [-118.71242, 36.23233], [-118.71149, 36.23322], [-118.71104, 36.23386], [-118.71111, 36.23449], [-118.71129, 36.23489], [-118.71185, 36.23537], [-118.7124, 36.23576], [-118.7127, 36.23619]]], [[[-118.72582, 36.22984], [-118.72582, 36.23338], [-118.71689, 36.23331], [-118.71691, 36.23727], [-118.71249, 36.23742], [-118.71282, 36.23668], [-118.7129, 36.23616], [-118.71258, 36.23566], [-118.71199, 36.23526], [-118.71147, 36.23481], [-118.71131, 36.23446], [-118.71123, 36.2339], [-118.71166, 36.2333], [-118.7126, 36.23241], [-118.71289, 36.23159], [-118.71242, 36.23109], [-118.7121, 36.23097], [-118.71176, 36.23092], [-118.71116, 36.231], [-118.70996, 36.23124], [-118.7093, 36.23109], [-118.70894, 36.23082], [-118.70851, 36.23024], [-118.70811, 36.22926], [-118.70782, 36.22919], [-118.70781, 36.22625], [-118.71247, 36.22623], [-118.71243, 36.22257], [-118.71694, 36.2226], [-118.71699, 36.22626], [-118.72136, 36.22621], [-118.72135, 36.22986], [-118.72582, 36.22984]]]]}	Open Access 1	769	Mountain Home Demonstration State Forest	1371	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://calfire.ca.gov/resource_mgt/resource_mgt_stateforests_mtnhome.php	Tulare 29	5227.75	Mtn. Home DSF	0	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]);