calands: units_with_maps: 1 row where AGNCY_TYP = 9 and DES

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

1 row where AGNCY_TYP = 9 and DES_TP = 25

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
227	227	226	{"type": "MultiPolygon", "coordinates": [[[[-119.78248, 37.95765], [-119.78191, 37.95774], [-119.78114, 37.95783], [-119.78088, 37.95784], [-119.78032, 37.95783], [-119.7788, 37.95773], [-119.77779, 37.95769], [-119.77739, 37.95773], [-119.77684, 37.95775], [-119.77654, 37.95778], [-119.77451, 37.95853], [-119.77303, 37.95905], [-119.77224, 37.95938], [-119.77154, 37.95973], [-119.77095, 37.9601], [-119.77031, 37.9606], [-119.76965, 37.96095], [-119.76909, 37.96116], [-119.76827, 37.96156], [-119.76719, 37.96184], [-119.7603, 37.9612], [-119.76012, 37.96098], [-119.75864, 37.96028], [-119.75808, 37.95992], [-119.75757, 37.95963], [-119.75713, 37.95931], [-119.75672, 37.95906], [-119.75653, 37.95869], [-119.75582, 37.9585], [-119.75505, 37.95834], [-119.75446, 37.95813], [-119.75295, 37.95779], [-119.75197, 37.9575], [-119.75103, 37.95729], [-119.75009, 37.95703], [-119.74941, 37.95675], [-119.74898, 37.95664], [-119.74817, 37.95632], [-119.74784, 37.95604], [-119.74696, 37.95583], [-119.74646, 37.95572], [-119.74605, 37.95559], [-119.74406, 37.95515], [-119.74327, 37.95488], [-119.74253, 37.95468], [-119.74158, 37.95439], [-119.741, 37.95434], [-119.74041, 37.95435], [-119.73979, 37.95428], [-119.73889, 37.95439], [-119.73595, 37.95427], [-119.73595, 37.95391], [-119.74675, 37.95382], [-119.75448, 37.95395], [-119.75458, 37.9576], [-119.7592, 37.9576], [-119.75913, 37.95395], [-119.77308, 37.95392], [-119.77303, 37.95029], [-119.77768, 37.95032], [-119.77759, 37.94668], [-119.78225, 37.94672], [-119.78248, 37.95765]]], [[[-119.81885, 37.92147], [-119.81426, 37.92147], [-119.81426, 37.91421], [-119.81878, 37.91418], [-119.81885, 37.92147]]], [[[-119.84421, 37.96202], [-119.83931, 37.96193], [-119.83906, 37.95843], [-119.83448, 37.95825], [-119.83392, 37.95451], [-119.8388, 37.9546], [-119.83854, 37.95078], [-119.84372, 37.95079], [-119.84421, 37.96202]]], [[[-119.86036, 37.88501], [-119.84605, 37.88385], [-119.84611, 37.88774], [-119.84145, 37.8879], [-119.8413, 37.88039], [-119.84594, 37.88019], [-119.84585, 37.87654], [-119.8589, 37.87761], [-119.86025, 37.87771], [-119.86036, 37.88501]]], [[[-119.87668, 37.9827], [-119.8765, 37.98991], [-119.86682, 37.9901], [-119.86222, 37.99016], [-119.86254, 37.98852], [-119.86222, 37.98852], [-119.86315, 37.98805], [-119.86371, 37.98559], [-119.8637, 37.98558], [-119.86245, 37.98563], [-119.86245, 37.98296], [-119.86269, 37.97934], [-119.87214, 37.97921], [-119.87188, 37.98279], [-119.87668, 37.9827]]], [[[-120.12683, 37.81255], [-120.12681, 37.81333], [-120.1246, 37.81356], [-120.12358, 37.81349], [-120.11945, 37.81378], [-120.11816, 37.81402], [-120.11734, 37.8142], [-120.11595, 37.81463], [-120.11594, 37.81464], [-120.11624, 37.81517], [-120.11584, 37.81586], [-120.11552, 37.81623], [-120.11491, 37.81666], [-120.11067, 37.81676], [-120.11065, 37.81743], [-120.11024, 37.81743], [-120.10924, 37.81763], [-120.10873, 37.8177], [-120.10829, 37.8179], [-120.10831, 37.81866], [-120.10829, 37.8197], [-120.10723, 37.82005], [-120.1037, 37.82007], [-120.10369, 37.81959], [-120.10472, 37.81846], [-120.10506, 37.81819], [-120.1054, 37.81807], [-120.10557, 37.81803], [-120.10586, 37.81803], [-120.1062, 37.81811], [-120.10644, 37.81813], [-120.10674, 37.81812], [-120.10696, 37.81798], [-120.10817, 37.81751], [-120.10876, 37.81735], [-120.10895, 37.81728], [-120.10901, 37.8174], [-120.10927, 37.81734], [-120.11024, 37.81679], [-120.11052, 37.81661], [-120.11262, 37.81588], [-120.11356, 37.81545], [-120.11529, 37.81429], [-120.11538, 37.81417], [-120.11563, 37.814], [-120.11601, 37.81388], [-120.11636, 37.81372], [-120.11735, 37.81337], [-120.11953, 37.81312], [-120.11978, 37.81308], [-120.12037, 37.81291], [-120.12111, 37.81278], [-120.12197, 37.81273], [-120.12525, 37.81259], [-120.12683, 37.81255]]], [[[-120.15014, 37.82682], [-120.14782, 37.8271], [-120.1454, 37.82736], [-120.14411, 37.82748], [-120.14069, 37.82782], [-120.14069, 37.8275], [-120.14087, 37.82751], [-120.14154, 37.82747], [-120.14256, 37.82735], [-120.14749, 37.82689], [-120.15012, 37.8266], [-120.15014, 37.82682]]], [[[-120.17722, 37.83941], [-120.17684, 37.83942], [-120.17605, 37.83901], [-120.17507, 37.83868], [-120.17411, 37.83848], [-120.1733, 37.838], [-120.17323, 37.83688], [-120.17309, 37.83604], [-120.17225, 37.83522], [-120.17193, 37.83439], [-120.17183, 37.83408], [-120.17074, 37.83358], [-120.16942, 37.83328], [-120.16895, 37.83314], [-120.16896, 37.83286], [-120.16925, 37.83291], [-120.1695, 37.83301], [-120.17039, 37.8333], [-120.17157, 37.83356], [-120.17167, 37.83361], [-120.17194, 37.83378], [-120.17211, 37.83399], [-120.17217, 37.83412], [-120.17232, 37.83485], [-120.17239, 37.83502], [-120.17254, 37.83522], [-120.17265, 37.8353], [-120.17336, 37.83597], [-120.17353, 37.83621], [-120.17361, 37.83641], [-120.17364, 37.83654], [-120.17364, 37.83669], [-120.17363, 37.83682], [-120.1736, 37.83691], [-120.17348, 37.83711], [-120.17344, 37.83721], [-120.17342, 37.83728], [-120.17342, 37.83748], [-120.17347, 37.83769], [-120.17355, 37.83783], [-120.17365, 37.83795], [-120.17383, 37.83808], [-120.174, 37.83817], [-120.17484, 37.83834], [-120.17573, 37.83867], [-120.17664, 37.83898], [-120.17692, 37.83914], [-120.17702, 37.83922], [-120.17714, 37.83932], [-120.17722, 37.83941]]], [[[-120.21037, 37.81981], [-120.21034, 37.82012], [-120.20255, 37.82157], [-120.19985, 37.82195], [-120.20219, 37.82485], [-120.20173, 37.82485], [-120.19999, 37.82285], [-120.19998, 37.82287], [-120.20014, 37.82339], [-120.19922, 37.82363], [-120.19953, 37.82399], [-120.19979, 37.82441], [-120.19949, 37.82455], [-120.19901, 37.82447], [-120.1989, 37.82469], [-120.19872, 37.82419], [-120.19882, 37.82368], [-120.19704, 37.82292], [-120.19707, 37.82238], [-120.19657, 37.82229], [-120.19657, 37.82204], [-120.19702, 37.822], [-120.19706, 37.82181], [-120.19861, 37.82166], [-120.19862, 37.82143], [-120.19929, 37.82133], [-120.19937, 37.82165], [-120.20096, 37.82146], [-120.20257, 37.82125], [-120.21037, 37.81981]]], [[[-120.23699, 37.83811], [-120.23636, 37.83847], [-120.23608, 37.8386], [-120.23537, 37.83888], [-120.23469, 37.83909], [-120.23434, 37.83922], [-120.23383, 37.83927], [-120.23374, 37.83925], [-120.23328, 37.83907], [-120.23304, 37.83907], [-120.23286, 37.83912], [-120.23268, 37.83924], [-120.23261, 37.83941], [-120.23255, 37.83967], [-120.23246, 37.83986], [-120.23224, 37.84007], [-120.23213, 37.84013], [-120.23194, 37.84021], [-120.23166, 37.84027], [-120.23156, 37.84027], [-120.23105, 37.84017], [-120.23096, 37.84017], [-120.22998, 37.84046], [-120.22998, 37.84048], [-120.23026, 37.84045], [-120.23022, 37.84099], [-120.22955, 37.84118], [-120.22949, 37.84054], [-120.22896, 37.8407], [-120.22882, 37.84046], [-120.23099, 37.83988], [-120.2312, 37.8399], [-120.23165, 37.83998], [-120.23177, 37.83997], [-120.23195, 37.83991], [-120.23209, 37.83981], [-120.23222, 37.83965], [-120.23224, 37.83945], [-120.23229, 37.83927], [-120.23234, 37.83917], [-120.23247, 37.83901], [-120.23267, 37.83887], [-120.23287, 37.8388], [-120.23299, 37.83877], [-120.23322, 37.83877], [-120.23339, 37.8388], [-120.23347, 37.83882], [-120.23368, 37.83889], [-120.23389, 37.83899], [-120.23397, 37.83901], [-120.234, 37.83907], [-120.23407, 37.83908], [-120.23421, 37.83906], [-120.23433, 37.83903], [-120.23489, 37.83882], [-120.23488, 37.83876], [-120.23597, 37.83833], [-120.23649, 37.83806], [-120.23698, 37.83775], [-120.23699, 37.83811]]], [[[-120.25749, 37.82776], [-120.25721, 37.82808], [-120.25681, 37.82809], [-120.25739, 37.8276], [-120.25749, 37.82776]]], [[[-120.25981, 37.82614], [-120.25924, 37.82696], [-120.25895, 37.82759], [-120.25751, 37.8276], [-120.25747, 37.82751], [-120.25777, 37.82709], [-120.25796, 37.82686], [-120.25825, 37.82645], [-120.25831, 37.8264], [-120.2584, 37.8264], [-120.25848, 37.82636], [-120.2586, 37.82624], [-120.25895, 37.82598], [-120.25981, 37.82614]]], [[[-120.27489, 37.80614], [-120.27406, 37.80726], [-120.27256, 37.80864], [-120.27257, 37.80912], [-120.27216, 37.80916], [-120.2715, 37.81021], [-120.27171, 37.81044], [-120.27472, 37.81163], [-120.27473, 37.81233], [-120.27386, 37.81281], [-120.27232, 37.81374], [-120.2716, 37.81391], [-120.27119, 37.81346], [-120.27105, 37.81333], [-120.27042, 37.81346], [-120.27022, 37.81348], [-120.26932, 37.81365], [-120.26926, 37.81112], [-120.26928, 37.81], [-120.26467, 37.80999], [-120.26435, 37.80997], [-120.26431, 37.80629], [-120.25979, 37.80623], [-120.25979, 37.80548], [-120.25939, 37.80563], [-120.2594, 37.80488], [-120.25964, 37.80477], [-120.25985, 37.8047], [-120.26049, 37.80443], [-120.25943, 37.8026], [-120.26025, 37.80172], [-120.26005, 37.80147], [-120.25993, 37.80124], [-120.25972, 37.80109], [-120.25927, 37.80096], [-120.25927, 37.80071], [-120.25986, 37.80084], [-120.26014, 37.80102], [-120.26031, 37.80124], [-120.26036, 37.8014], [-120.26047, 37.80152], [-120.26189, 37.80062], [-120.26363, 37.7995], [-120.26411, 37.79928], [-120.2642, 37.79922], [-120.26428, 37.80258], [-120.26921, 37.8027], [-120.26922, 37.80246], [-120.26917, 37.79958], [-120.26919, 37.79941], [-120.26982, 37.79945], [-120.26988, 37.80024], [-120.2715, 37.80102], [-120.27278, 37.80276], [-120.27408, 37.80432], [-120.27439, 37.80542], [-120.27489, 37.80614]], [[-120.25998, 37.8061], [-120.26, 37.8061], [-120.26034, 37.80525], [-120.25998, 37.8054], [-120.25998, 37.8061]]], [[[-120.26282, 37.8227], [-120.26236, 37.82261], [-120.26216, 37.82238], [-120.26206, 37.82225], [-120.2619, 37.8221], [-120.26175, 37.82193], [-120.26165, 37.82169], [-120.26165, 37.82162], [-120.26165, 37.82151], [-120.26181, 37.82087], [-120.26215, 37.82087], [-120.26198, 37.82158], [-120.26197, 37.82165], [-120.26198, 37.8217], [-120.26202, 37.8218], [-120.26209, 37.82189], [-120.26227, 37.82206], [-120.26282, 37.8227]]], [[[-120.31147, 37.8132], [-120.31114, 37.81342], [-120.30983, 37.8125], [-120.30943, 37.81245], [-120.30958, 37.81274], [-120.30982, 37.81308], [-120.31022, 37.81349], [-120.31047, 37.81372], [-120.31049, 37.81378], [-120.30985, 37.81322], [-120.30863, 37.81205], [-120.30854, 37.8119], [-120.30841, 37.81145], [-120.30776, 37.81102], [-120.30699, 37.8104], [-120.30573, 37.81221], [-120.30627, 37.8124], [-120.30678, 37.81266], [-120.3072, 37.81318], [-120.30727, 37.81353], [-120.30655, 37.81343], [-120.30653, 37.81291], [-120.30142, 37.81283], [-120.29999, 37.81283], [-120.29887, 37.81286], [-120.29624, 37.8129], [-120.29586, 37.8126], [-120.2954, 37.81227], [-120.29312, 37.81041], [-120.29215, 37.80964], [-120.29207, 37.8097], [-120.29201, 37.80912], [-120.28667, 37.80904], [-120.28715, 37.81262], [-120.27683, 37.81248], [-120.27681, 37.80891], [-120.28132, 37.80898], [-120.28171, 37.80897], [-120.28172, 37.80895], [-120.28146, 37.80542], [-120.27675, 37.80535], [-120.27671, 37.80178], [-120.27701, 37.8018], [-120.28035, 37.80181], [-120.28129, 37.80185], [-120.28129, 37.801], [-120.28142, 37.80089], [-120.28156, 37.80081], [-120.28134, 37.80051], [-120.28269, 37.80025], [-120.2831, 37.80016], [-120.28244, 37.79947], [-120.28142, 37.79968], [-120.28114, 37.79831], [-120.28522, 37.79834], [-120.29614, 37.79847], [-120.29652, 37.79846], [-120.297, 37.79848], [-120.29725, 37.80562], [-120.30179, 37.80569], [-120.30176, 37.8074], [-120.30751, 37.80732], [-120.30856, 37.80739], [-120.30862, 37.8106], [-120.30975, 37.81069], [-120.31111, 37.81148], [-120.31147, 37.8132]], [[-120.29232, 37.80261], [-120.2914, 37.80229], [-120.29121, 37.80238], [-120.29098, 37.80252], [-120.29194, 37.80319], [-120.29254, 37.80279], [-120.29232, 37.80261]]], [[[-120.32796, 37.80551], [-120.3276, 37.80556], [-120.32758, 37.80528], [-120.32794, 37.80525], [-120.32796, 37.80551]]], [[[-120.4079, 37.79822], [-120.40753, 37.79825], [-120.40687, 37.79827], [-120.40677, 37.79754], [-120.40774, 37.79766], [-120.40778, 37.79759], [-120.40783, 37.79723], [-120.40781, 37.79697], [-120.40774, 37.79667], [-120.40756, 37.79638], [-120.40741, 37.7962], [-120.40723, 37.79605], [-120.40707, 37.79593], [-120.40743, 37.7959], [-120.40755, 37.79597], [-120.40772, 37.79613], [-120.40792, 37.79639], [-120.40803, 37.7966], [-120.40808, 37.79666], [-120.40816, 37.79688], [-120.40819, 37.79704], [-120.40821, 37.79736], [-120.40821, 37.79744], [-120.40817, 37.79766], [-120.4081, 37.79787], [-120.4079, 37.79822]]], [[[-120.5453, 37.8063], [-120.54393, 37.8097], [-120.54171, 37.80978], [-120.54178, 37.80813], [-120.53933, 37.80807], [-120.53929, 37.80704], [-120.5418, 37.80706], [-120.54182, 37.80634], [-120.5453, 37.8063]]], [[[-120.60815, 37.79881], [-120.60113, 37.80196], [-120.60157, 37.8032], [-120.59639, 37.8047], [-120.59213, 37.80472], [-120.59216, 37.80257], [-120.60009, 37.79989], [-120.60088, 37.80139], [-120.60752, 37.79831], [-120.60815, 37.79881]]]]}	Restricted Access 2	616	Hetch Hetchy Water and Power	19888	321	San Francisco - Public Utilities Commission, City and County of 31	County 3	County Agency - Other 9	http://sfwater.org/	County 3	321	San Francisco - Public Utilities Commission, City and County of 30	County 3	County Agency - Other 8		Tuolumne 21	2706.955	Hetch Hetchy Water and Power		None 25

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