calands: units_with_maps: 5 rows where ACCESS_TYP = 2, DES_TP = 16, GAP_STS = 2 and MNG

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

5 rows where ACCESS_TYP = 2, DES_TP = 16, GAP_STS = 2 and MNG_AGENCY = 358

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
1404	1404	1403	{"type": "Polygon", "coordinates": [[[-122.19364, 38.14035], [-122.19255, 38.14085], [-122.19094, 38.14174], [-122.18499, 38.14511], [-122.18197, 38.14671], [-122.181, 38.14603], [-122.18073, 38.14577], [-122.17709, 38.14318], [-122.17439, 38.14115], [-122.17323, 38.14032], [-122.17291, 38.14042], [-122.17248, 38.14069], [-122.17242, 38.1407], [-122.17245, 38.14065], [-122.17237, 38.14024], [-122.17271, 38.14009], [-122.17271, 38.14007], [-122.1676, 38.13214], [-122.16758, 38.13205], [-122.1682, 38.13241], [-122.17857, 38.12654], [-122.18461, 38.12402], [-122.18657, 38.12318], [-122.18795, 38.12517], [-122.18982, 38.12792], [-122.18862, 38.12856], [-122.18862, 38.12858], [-122.18901, 38.1289], [-122.18938, 38.12931], [-122.18977, 38.1297], [-122.19033, 38.13018], [-122.19068, 38.13063], [-122.19095, 38.13094], [-122.19139, 38.13124], [-122.19179, 38.13148], [-122.19208, 38.13161], [-122.19238, 38.13177], [-122.19408, 38.13497], [-122.19423, 38.13573], [-122.19448, 38.13723], [-122.19412, 38.13869], [-122.19364, 38.14035]], [[-122.19099, 38.1342], [-122.19123, 38.13468], [-122.19131, 38.13478], [-122.19157, 38.13526], [-122.19183, 38.13515], [-122.19156, 38.13457], [-122.19133, 38.13422], [-122.1909, 38.13352], [-122.19067, 38.13331], [-122.19034, 38.13316], [-122.18936, 38.13246], [-122.18847, 38.13188], [-122.18796, 38.13157], [-122.18726, 38.13108], [-122.18631, 38.13097], [-122.1859, 38.13091], [-122.18525, 38.13097], [-122.18611, 38.13175], [-122.18555, 38.13206], [-122.18555, 38.13207], [-122.18649, 38.13293], [-122.18679, 38.13315], [-122.18704, 38.13336], [-122.18772, 38.13324], [-122.18846, 38.13375], [-122.18936, 38.13477], [-122.18982, 38.1347], [-122.1903, 38.13436], [-122.19041, 38.13416], [-122.19078, 38.13407], [-122.19099, 38.1342]]]}	Restricted Access 2	8824	Vallejo Swett	26783	3081	Solano Land Trust 361	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/	Non Governmental Organization 10	3081	Solano Land Trust 358	Non Profit 6	Non Profit - Land Trust 10		Solano 26	861.807	Vallejo Swett	1999	Private Conservation 16	2
2376	2376	2375	{"type": "Polygon", "coordinates": [[[-122.14962, 38.16492], [-122.14827, 38.16492], [-122.14383, 38.16372], [-122.14268, 38.16401], [-122.14097, 38.16366], [-122.1404, 38.16353], [-122.1403, 38.16348], [-122.13817, 38.16059], [-122.13799, 38.16055], [-122.13779, 38.16009], [-122.13516, 38.15925], [-122.13438, 38.15924], [-122.1332, 38.15863], [-122.13319, 38.15864], [-122.13323, 38.15938], [-122.13347, 38.16], [-122.13346, 38.16038], [-122.1328, 38.16056], [-122.12629, 38.16307], [-122.12495, 38.16282], [-122.12063, 38.16183], [-122.12048, 38.16095], [-122.11981, 38.16003], [-122.11869, 38.16047], [-122.11495, 38.1562], [-122.12004, 38.15349], [-122.12095, 38.14364], [-122.14773, 38.14371], [-122.14962, 38.16492]]]}	Restricted Access 2	17191	King Ranch	20659	3081	Solano Land Trust 361	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/	Non Governmental Organization 10	3081	Solano Land Trust 358	Non Profit 6	Non Profit - Land Trust 10		Solano 26	1313.512	King Ranch	2002	Private Conservation 16	2
5596	5596	5595	{"type": "Polygon", "coordinates": [[[-122.16317, 38.26342], [-122.16304, 38.26457], [-122.16289, 38.26488], [-122.16282, 38.26526], [-122.16275, 38.26549], [-122.16266, 38.2657], [-122.16195, 38.26717], [-122.16224, 38.2679], [-122.16257, 38.26905], [-122.16284, 38.27014], [-122.16307, 38.27081], [-122.16288, 38.27111], [-122.16026, 38.27474], [-122.15949, 38.27508], [-122.15854, 38.27538], [-122.15786, 38.27533], [-122.15697, 38.27515], [-122.15593, 38.27509], [-122.15389, 38.27474], [-122.15229, 38.27479], [-122.15135, 38.27503], [-122.15097, 38.2751], [-122.15009, 38.27511], [-122.14943, 38.27508], [-122.14882, 38.27519], [-122.14823, 38.27604], [-122.1478, 38.27661], [-122.14631, 38.27761], [-122.13521, 38.27753], [-122.12964, 38.27753], [-122.12964, 38.27358], [-122.12749, 38.27358], [-122.12613, 38.27372], [-122.12677, 38.27314], [-122.12722, 38.27235], [-122.12864, 38.27056], [-122.12997, 38.26942], [-122.13099, 38.26817], [-122.13233, 38.26904], [-122.13255, 38.26879], [-122.13276, 38.26866], [-122.13302, 38.26858], [-122.13329, 38.26857], [-122.1335, 38.26861], [-122.13368, 38.26868], [-122.13376, 38.26873], [-122.13394, 38.2689], [-122.13404, 38.26897], [-122.13452, 38.26921], [-122.13467, 38.26831], [-122.13469, 38.26791], [-122.13469, 38.26771], [-122.13465, 38.26747], [-122.1346, 38.26732], [-122.13447, 38.26712], [-122.13374, 38.26611], [-122.13321, 38.26499], [-122.13249, 38.26377], [-122.13207, 38.26273], [-122.13199, 38.26246], [-122.13191, 38.26232], [-122.13177, 38.26151], [-122.13167, 38.2608], [-122.13078, 38.26054], [-122.13299, 38.25698], [-122.13349, 38.25596], [-122.13646, 38.25362], [-122.13716, 38.25378], [-122.13767, 38.25385], [-122.1381, 38.25388], [-122.13872, 38.25387], [-122.13915, 38.25382], [-122.13974, 38.25371], [-122.14001, 38.25365], [-122.14171, 38.25305], [-122.14246, 38.25282], [-122.14343, 38.25454], [-122.14393, 38.2555], [-122.14397, 38.25573], [-122.14406, 38.25575], [-122.14825, 38.25531], [-122.14953, 38.25523], [-122.15289, 38.25406], [-122.15289, 38.25346], [-122.15461, 38.25303], [-122.15561, 38.25282], [-122.1576, 38.25255], [-122.15744, 38.25221], [-122.15741, 38.25212], [-122.15742, 38.25209], [-122.15733, 38.25189], [-122.15733, 38.25176], [-122.15735, 38.25169], [-122.15763, 38.25182], [-122.15782, 38.2522], [-122.15779, 38.25262], [-122.15788, 38.25266], [-122.15749, 38.25327], [-122.15828, 38.25467], [-122.15867, 38.25522], [-122.15877, 38.2554], [-122.15876, 38.2556], [-122.15817, 38.25561], [-122.15798, 38.25577], [-122.15808, 38.25637], [-122.15826, 38.25644], [-122.15879, 38.25637], [-122.15885, 38.25655], [-122.1589, 38.25716], [-122.159, 38.25759], [-122.15912, 38.25797], [-122.15928, 38.25874], [-122.15935, 38.25894], [-122.15937, 38.25965], [-122.15941, 38.26015], [-122.15918, 38.26085], [-122.15922, 38.26103], [-122.15916, 38.26174], [-122.15925, 38.26207], [-122.1592, 38.26243], [-122.15946, 38.26348], [-122.15969, 38.26398], [-122.15971, 38.26398], [-122.16233, 38.26243], [-122.16237, 38.26247], [-122.16206, 38.2631], [-122.1625, 38.26349], [-122.16317, 38.26342]]]}	Restricted Access 2	35116	Rockville Trails Preserve	28161	3081	Solano Land Trust 361	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/	Non Governmental Organization 10	3081	Solano Land Trust 358	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/RockvilleTrails.aspx	Solano 26	1573.93	Rockville Trails Preserve	0	Private Conservation 16	2
7795	7795	7794	{"type": "Polygon", "coordinates": [[[-122.1729, 38.16479], [-122.14962, 38.16492], [-122.14663, 38.13128], [-122.16514, 38.13302], [-122.16508, 38.13304], [-122.16505, 38.13338], [-122.16517, 38.13339], [-122.17024, 38.14122], [-122.17098, 38.14089], [-122.17096, 38.14104], [-122.17094, 38.14109], [-122.16917, 38.14194], [-122.16924, 38.14268], [-122.1697, 38.1454], [-122.17088, 38.15287], [-122.17224, 38.16075], [-122.1729, 38.16479]]]}	Restricted Access 2	8836	Eastern Swett	18392	3081	Solano Land Trust 361	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/	Non Governmental Organization 10	3081	Solano Land Trust 358	Non Profit 6	Non Profit - Land Trust 10		Solano 26	1715.026	Eastern Swett	2002	Private Conservation 16	2
10088	10088	10087	{"type": "Polygon", "coordinates": [[[-122.21548, 38.18844], [-122.20971, 38.18989], [-122.2097, 38.1899], [-122.20972, 38.18993], [-122.20957, 38.18997], [-122.20942, 38.19007], [-122.20927, 38.19031], [-122.20939, 38.19045], [-122.20962, 38.19067], [-122.2102, 38.19107], [-122.21063, 38.19142], [-122.21102, 38.19176], [-122.21125, 38.19204], [-122.21086, 38.19191], [-122.21039, 38.1919], [-122.20803, 38.19229], [-122.2065, 38.19244], [-122.20517, 38.19253], [-122.20303, 38.195], [-122.20038, 38.19816], [-122.19827, 38.19743], [-122.18154, 38.19131], [-122.17397, 38.18864], [-122.17227, 38.18783], [-122.17294, 38.18746], [-122.17317, 38.18734], [-122.17373, 38.1871], [-122.17404, 38.187], [-122.17455, 38.18669], [-122.17517, 38.18645], [-122.17589, 38.18624], [-122.177, 38.18601], [-122.17825, 38.18569], [-122.17876, 38.18564], [-122.17926, 38.1855], [-122.18022, 38.1852], [-122.18082, 38.18493], [-122.18155, 38.18446], [-122.18212, 38.18393], [-122.18282, 38.18333], [-122.18367, 38.18248], [-122.1846, 38.18173], [-122.18525, 38.18092], [-122.18609, 38.1804], [-122.18671, 38.18021], [-122.18724, 38.17988], [-122.18769, 38.1795], [-122.18813, 38.17926], [-122.18895, 38.17876], [-122.1896, 38.17833], [-122.1904, 38.17862], [-122.19569, 38.18033], [-122.20124, 38.18226], [-122.20456, 38.18336], [-122.20852, 38.17882], [-122.20856, 38.17702], [-122.20843, 38.17334], [-122.20855, 38.17294], [-122.20885, 38.17308], [-122.20916, 38.17343], [-122.21013, 38.17418], [-122.21058, 38.17411], [-122.21097, 38.17455], [-122.211, 38.17485], [-122.21097, 38.175], [-122.21098, 38.17511], [-122.21097, 38.17545], [-122.21112, 38.17572], [-122.21146, 38.17591], [-122.21166, 38.17631], [-122.21193, 38.17662], [-122.21208, 38.17687], [-122.21289, 38.17725], [-122.21347, 38.17773], [-122.21373, 38.17806], [-122.2141, 38.17832], [-122.21444, 38.1787], [-122.21482, 38.17925], [-122.21499, 38.17946], [-122.21492, 38.17987], [-122.21465, 38.18028], [-122.21414, 38.18069], [-122.21366, 38.18093], [-122.21364, 38.18099], [-122.21359, 38.18105], [-122.21344, 38.18133], [-122.21336, 38.18173], [-122.21328, 38.18201], [-122.21335, 38.1826], [-122.21346, 38.18297], [-122.21354, 38.18331], [-122.21342, 38.18371], [-122.21326, 38.18399], [-122.21298, 38.18429], [-122.21282, 38.18454], [-122.21286, 38.18479], [-122.21325, 38.1851], [-122.21363, 38.18587], [-122.2139, 38.18631], [-122.21544, 38.18836], [-122.21548, 38.18844]]]}	Restricted Access 2	17506	Lynch Canyon	29277	3081	Solano Land Trust 361	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/	Non Governmental Organization 10	3081	Solano Land Trust 358	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/LynchCanyon.aspx	Solano 26	1152.887	Lynch Canyon	1994	Private Conservation 16	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]);