units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where AGNCY_LEV = 6, AGNCY_WEB = "http://www.solanolandtrust.org/" and DES_TP = 16
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 |
6475 | 6475 | 6474 | {"type": "Polygon", "coordinates": [[[-121.89617, 38.24991], [-121.89615, 38.24998], [-121.87929, 38.26469], [-121.87398, 38.27128], [-121.87387, 38.27167], [-121.86064, 38.27158], [-121.84224, 38.27129], [-121.8423, 38.26401], [-121.85159, 38.26407], [-121.85163, 38.25686], [-121.86065, 38.25686], [-121.87945, 38.25708], [-121.87968, 38.24283], [-121.88134, 38.24278], [-121.88895, 38.24283], [-121.88894, 38.24989], [-121.89617, 38.24991]]]} | No Public Access 3 | 2063 | Wilcox Ranch | 27495 | 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 | 1547.196 | Wilcox Ranch | 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 |
10445 | 10445 | 10444 | {"type": "Polygon", "coordinates": [[[-122.03295, 38.30875], [-122.03267, 38.31033], [-122.03235, 38.31105], [-122.03223, 38.31116], [-122.03204, 38.31066], [-122.03188, 38.31051], [-122.03182, 38.31012], [-122.03152, 38.31008], [-122.03114, 38.30986], [-122.03106, 38.31005], [-122.03062, 38.31001], [-122.0305, 38.30968], [-122.03025, 38.30968], [-122.02986, 38.30979], [-122.0296, 38.30975], [-122.02941, 38.30957], [-122.02932, 38.30886], [-122.03083, 38.30883], [-122.03086, 38.30875], [-122.03295, 38.30875]]]} | No Public Access 3 | 18482 | Paradise Valley | 23407 | 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 | 10.888 | Paradise Valley | 1992 | 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]);