units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, COUNTY = 16 and DES_TP = 105
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- National Wildlife Refuge · 3 ✖
ACCESS_TYP 1
- Restricted Access · 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3703 | 3703 | 3702 | {"type": "MultiPolygon", "coordinates": [[[[-122.39206, 38.19858], [-122.39175, 38.19903], [-122.3912, 38.1995], [-122.38991, 38.20004], [-122.38904, 38.20025], [-122.38812, 38.2004], [-122.38725, 38.20045], [-122.38627, 38.20039], [-122.38547, 38.20031], [-122.38464, 38.20032], [-122.38426, 38.20029], [-122.38372, 38.20009], [-122.38356, 38.20011], [-122.38313, 38.20021], [-122.38239, 38.20046], [-122.38198, 38.20067], [-122.38177, 38.2008], [-122.38142, 38.20105], [-122.38101, 38.20138], [-122.3802, 38.20223], [-122.37999, 38.20255], [-122.37985, 38.2029], [-122.37981, 38.20305], [-122.37973, 38.20354], [-122.37949, 38.20556], [-122.37936, 38.20647], [-122.3793, 38.20667], [-122.3792, 38.20679], [-122.37902, 38.2069], [-122.37891, 38.20692], [-122.37865, 38.20695], [-122.37836, 38.20691], [-122.37806, 38.20681], [-122.37776, 38.20664], [-122.37736, 38.20636], [-122.37719, 38.20622], [-122.37676, 38.20578], [-122.37654, 38.20554], [-122.37621, 38.20522], [-122.37575, 38.20468], [-122.37559, 38.20454], [-122.37543, 38.20442], [-122.37531, 38.20436], [-122.37513, 38.20429], [-122.3745, 38.2041], [-122.37389, 38.20395], [-122.3732, 38.20376], [-122.37298, 38.20367], [-122.3728, 38.20364], [-122.37209, 38.20364], [-122.37128, 38.20368], [-122.36941, 38.20378], [-122.36847, 38.20385], [-122.36815, 38.20383], [-122.36766, 38.20376], [-122.36751, 38.2037], [-122.36741, 38.20364], [-122.3673, 38.20355], [-122.36726, 38.20348], [-122.36722, 38.20337], [-122.36717, 38.20304], [-122.36721, 38.20292], [-122.36737, 38.20262], [-122.36738, 38.20237], [-122.36736, 38.20224], [-122.36725, 38.20205], [-122.36702, 38.20183], [-122.36677, 38.20166], [-122.36665, 38.2016], [-122.36641, 38.20153], [-122.3662, 38.20153], [-122.36581, 38.20158], [-122.36566, 38.20157], [-122.36539, 38.20153], [-122.36274, 38.20054], [-122.36014, 38.19988], [-122.35976, 38.19985], [-122.3592, 38.19985], [-122.359, 38.19983], [-122.35887, 38.19976], [-122.35882, 38.19967], [-122.35881, 38.19893], [-122.35878, 38.19845], [-122.35881, 38.19831], [-122.35886, 38.19818], [-122.35893, 38.19812], [-122.35961, 38.1978], [-122.36075, 38.19739], [-122.36092, 38.19732], [-122.36105, 38.19724], [-122.36132, 38.19702], [-122.36151, 38.19679], [-122.36158, 38.19667], [-122.36161, 38.19659], [-122.36162, 38.19645], [-122.36159, 38.19621], [-122.36143, 38.19554], [-122.36138, 38.19536], [-122.36121, 38.19495], [-122.36101, 38.19465], [-122.3608, 38.19438], [-122.36038, 38.19396], [-122.35977, 38.19331], [-122.35964, 38.19314], [-122.35927, 38.19274], [-122.35902, 38.1924], [-122.35857, 38.19167], [-122.35847, 38.19152], [-122.35839, 38.19137], [-122.35827, 38.19097], [-122.35814, 38.19043], [-122.35809, 38.19013], [-122.35803, 38.18988], [-122.35792, 38.18905], [-122.35793, 38.1884], [-122.35799, 38.18745], [-122.35802, 38.18678], [-122.35807, 38.18613], [-122.35824, 38.18473], [-122.3584, 38.184], [-122.35852, 38.18359], [-122.35859, 38.1834], [-122.35873, 38.18312], [-122.3589, 38.18287], [-122.35902, 38.18278], [-122.35912, 38.18271], [-122.35936, 38.18261], [-122.35948, 38.18259], [-122.35969, 38.18258], [-122.35991, 38.18263], [-122.36027, 38.18274], [-122.36094, 38.18302], [-122.36201, 38.18341], [-122.36279, 38.18362], [-122.36427, 38.18397], [-122.36486, 38.18405], [-122.36534, 38.18409], [-122.36619, 38.18407], [-122.36662, 38.18404], [-122.36717, 38.18395], [-122.36739, 38.18389], [-122.36762, 38.18379], [-122.36804, 38.18359], [-122.36848, 38.18329], [-122.36865, 38.18321], [-122.36884, 38.1831], [-122.36936, 38.18266], [-122.36965, 38.18249], [-122.36991, 38.18239], [-122.37012, 38.18227], [-122.37118, 38.18212], [-122.37269, 38.182], [-122.37282, 38.18195], [-122.3729, 38.18197], [-122.37333, 38.18193], [-122.37377, 38.18187], [-122.37381, 38.18186], [-122.37416, 38.18185], [-122.37423, 38.18181], [-122.37448, 38.18177], [-122.37581, 38.18134], [-122.37587, 38.18129], [-122.37595, 38.18128], [-122.37615, 38.18118], [-122.37615, 38.18115], [-122.37637, 38.18107], [-122.37647, 38.18102], [-122.37675, 38.18092], [-122.3769, 38.18083], [-122.37766, 38.18056], [-122.37782, 38.18054], [-122.37793, 38.1805], [-122.37819, 38.18049], [-122.37846, 38.18052], [-122.37891, 38.18063], [-122.37933, 38.18089], [-122.37959, 38.18101], [-122.37965, 38.18107], [-122.37969, 38.18124], [-122.37976, 38.18146], [-122.3798, 38.1819], [-122.37975, 38.18205], [-122.37968, 38.18219], [-122.37968, 38.18229], [-122.37947, 38.18275], [-122.37916, 38.18335], [-122.37907, 38.18345], [-122.37906, 38.1835], [-122.37898, 38.18364], [-122.37888, 38.18372], [-122.37869, 38.18401], [-122.37776, 38.18496], [-122.37742, 38.18525], [-122.37695, 38.18557], [-122.37626, 38.1859], [-122.37553, 38.1862], [-122.375, 38.18631], [-122.37424, 38.1864], [-122.37389, 38.18642], [-122.37359, 38.18649], [-122.37332, 38.1866], [-122.37312, 38.18672], [-122.37297, 38.18695], [-122.37287, 38.18716], [-122.37287, 38.18752], [-122.37293, 38.18804], [-122.37307, 38.18842], [-122.3732, 38.18864], [-122.37335, 38.18883], [-122.37341, 38.18887], [-122.37392, 38.18946], [-122.37442, 38.18977], [-122.37538, 38.19024], [-122.37546, 38.19026], [-122.37616, 38.19057], [-122.377, 38.19081], [-122.37725, 38.19094], [-122.37758, 38.19104], [-122.37825, 38.19116], [-122.37891, 38.19131], [-122.37943, 38.19137], [-122.37958, 38.19135], [-122.37964, 38.19132], [-122.37986, 38.19136], [-122.38027, 38.19136], [-122.38037, 38.19132], [-122.38071, 38.19128], [-122.38076, 38.19126], [-122.38207, 38.19116], [-122.38218, 38.19114], [-122.38227, 38.19116], [-122.3825, 38.19119], [-122.38295, 38.19122], [-122.38351, 38.19132], [-122.38408, 38.1915], [-122.38447, 38.19167], [-122.38493, 38.19193], [-122.38565, 38.19247], [-122.38598, 38.19276], [-122.38601, 38.19282], [-122.38616, 38.19298], [-122.38817, 38.19228], [-122.38982, 38.19295], [-122.3906, 38.19243], [-122.39105, 38.19265], [-122.39052, 38.19429], [-122.39062, 38.19495], [-122.39093, 38.19574], [-122.39188, 38.19767], [-122.39203, 38.19817], [-122.39206, 38.19858]]], [[[-122.49376, 38.11703], [-122.49205, 38.11836], [-122.48389, 38.1232], [-122.47161, 38.12781], [-122.47161, 38.12782], [-122.47197, 38.1283], [-122.47164, 38.12826], [-122.47067, 38.12757], [-122.47206, 38.12591], [-122.47326, 38.12358], [-122.47451, 38.11926], [-122.47456, 38.11893], [-122.4745, 38.11878], [-122.47439, 38.11865], [-122.47175, 38.11735], [-122.47077, 38.11682], [-122.47014, 38.11694], [-122.46924, 38.1173], [-122.46856, 38.11787], [-122.46755, 38.11832], [-122.46687, 38.1184], [-122.46604, 38.11802], [-122.46431, 38.11785], [-122.45945, 38.1183], [-122.45865, 38.11863], [-122.45771, 38.11917], [-122.45577, 38.1208], [-122.45528, 38.12149], [-122.45455, 38.12282], [-122.45402, 38.12467], [-122.45381, 38.12498], [-122.45358, 38.12529], [-122.45333, 38.12558], [-122.45307, 38.12587], [-122.45278, 38.12614], [-122.45195, 38.1269], [-122.45165, 38.12713], [-122.45134, 38.12733], [-122.45101, 38.12753], [-122.45066, 38.1277], [-122.4503, 38.12785], [-122.44994, 38.12799], [-122.44956, 38.1281], [-122.44917, 38.12819], [-122.44877, 38.12827], [-122.44837, 38.12832], [-122.44811, 38.12857], [-122.44742, 38.12858], [-122.44627, 38.12844], [-122.44514, 38.12834], [-122.44398, 38.12814], [-122.44347, 38.12808], [-122.44281, 38.12797], [-122.44213, 38.12776], [-122.44135, 38.12749], [-122.44065, 38.1272], [-122.44001, 38.12703], [-122.43955, 38.12687], [-122.43921, 38.1267], [-122.43891, 38.12662], [-122.43876, 38.1266], [-122.43836, 38.12669], [-122.43765, 38.12695], [-122.43736, 38.12716], [-122.43723, 38.12734], [-122.43713, 38.12755], [-122.43709, 38.12781], [-122.43711, 38.12807], [-122.43717, 38.1284], [-122.43735, 38.12893], [-122.43755, 38.1294], [-122.43771, 38.12967], [-122.43811, 38.13023], [-122.43886, 38.1314], [-122.43917, 38.13194], [-122.43958, 38.13247], [-122.44062, 38.13357], [-122.44168, 38.13464], [-122.44175, 38.13459], [-122.44276, 38.13578], [-122.44371, 38.13768], [-122.44356, 38.13763], [-122.44341, 38.13799], [-122.44347, 38.13839], [-122.44273, 38.13902], [-122.44194, 38.13975], [-122.44009, 38.14139], [-122.43858, 38.14212], [-122.43581, 38.14269], [-122.43463, 38.14305], [-122.43428, 38.14323], [-122.43428, 38.14347], [-122.43452, 38.14398], [-122.43544, 38.14477], [-122.43736, 38.14574], [-122.44119, 38.1476], [-122.44332, 38.14857], [-122.44386, 38.14899], [-122.44458, 38.14983], [-122.44481, 38.14975], [-122.44507, 38.15027], [-122.44568, 38.15076], [-122.44618, 38.15155], [-122.44472, 38.1519], [-122.44289, 38.15052], [-122.44116, 38.14994], [-122.4406, 38.14972], [-122.44026, 38.14972], [-122.43992, 38.14989], [-122.43953, 38.1502], [-122.43902, 38.15041], [-122.43846, 38.15037], [-122.43824, 38.15023], [-122.43785, 38.14988], [-122.43758, 38.14944], [-122.43719, 38.14873], [-122.43352, 38.14575], [-122.43246, 38.1453], [-122.4314, 38.14503], [-122.43039, 38.14463], [-122.42923, 38.14325], [-122.42929, 38.1429], [-122.43064, 38.14145], [-122.43423, 38.14018], [-122.43821, 38.13919], [-122.44034, 38.13785], [-122.44014, 38.13626], [-122.4388, 38.13479], [-122.43875, 38.13448], [-122.43786, 38.13377], [-122.43753, 38.13315], [-122.43736, 38.13275], [-122.43715, 38.13191], [-122.43593, 38.13023], [-122.43537, 38.12974], [-122.43504, 38.12934], [-122.43482, 38.12867], [-122.43483, 38.12814], [-122.43533, 38.12696], [-122.42823, 38.1274], [-122.42723, 38.12665], [-122.42655, 38.12638], [-122.42498, 38.12712], [-122.4229, 38.12839], [-122.42228, 38.12919], [-122.4216, 38.12993], [-122.42104, 38.1302], [-122.42009, 38.13046], [-122.41879, 38.13111], [-122.41688, 38.13234], [-122.41452, 38.13419], [-122.41373, 38.13467], [-122.41349, 38.13477], [-122.41337, 38.13526], [-122.41303, 38.13574], [-122.41241, 38.13614], [-122.41185, 38.13684], [-122.41094, 38.13838], [-122.41009, 38.14028], [-122.40963, 38.14094], [-122.40857, 38.14133], [-122.40811, 38.14164], [-122.40686, 38.14486], [-122.40634, 38.14605], [-122.40589, 38.14689], [-122.40554, 38.14797], [-122.40735, 38.15138], [-122.40802, 38.15196], [-122.4099, 38.1551], [-122.4099, 38.15581], [-122.40701, 38.1558], [-122.40649, 38.15446], [-122.40584, 38.1534], [-122.40548, 38.15285], [-122.40492, 38.15219], [-122.40435, 38.15143], [-122.40393, 38.15092], [-122.40366, 38.15067], [-122.40338, 38.15027], [-122.40308, 38.14995], [-122.40201, 38.14838], [-122.40173, 38.14786], [-122.40133, 38.14727], [-122.40084, 38.14642], [-122.40043, 38.14576], [-122.39999, 38.14523], [-122.39947, 38.14445], [-122.39867, 38.14315], [-122.3981, 38.14212], [-122.39768, 38.14148], [-122.39728, 38.14077], [-122.39688, 38.14018], [-122.3965, 38.13957], [-122.39602, 38.13888], [-122.39494, 38.13713], [-122.39433, 38.13619], [-122.39286, 38.13382], [-122.39201, 38.13255], [-122.39096, 38.13086], [-122.38859, 38.12709], [-122.37881, 38.1114], [-122.37609, 38.10709], [-122.37608, 38.10703], [-122.37578, 38.10654], [-122.37487, 38.10534], [-122.45452, 38.10507], [-122.46556, 38.10994], [-122.4853, 38.1113], [-122.49218, 38.11182], [-122.49048, 38.11561], [-122.49245, 38.11561], [-122.49376, 38.11703]], [[-122.44977, 38.12227], [-122.44993, 38.12215], [-122.44997, 38.1217], [-122.45051, 38.12042], [-122.45071, 38.12005], [-122.45072, 38.11987], [-122.45069, 38.11962], [-122.45053, 38.11935], [-122.45042, 38.119], [-122.45023, 38.11872], [-122.44909, 38.11763], [-122.44893, 38.11754], [-122.44865, 38.11743], [-122.44807, 38.11716], [-122.44795, 38.11707], [-122.44771, 38.11713], [-122.44688, 38.11696], [-122.44576, 38.11658], [-122.44463, 38.11632], [-122.4437, 38.11626], [-122.44295, 38.11662], [-122.44133, 38.11721], [-122.44046, 38.11737], [-122.43995, 38.11765], [-122.43948, 38.11769], [-122.43899, 38.11781], [-122.43775, 38.11894], [-122.43694, 38.12018], [-122.43655, 38.12044], [-122.43478, 38.12108], [-122.43421, 38.12145], [-122.43677, 38.12567], [-122.43739, 38.12522], [-122.43776, 38.12506], [-122.43889, 38.12424], [-122.43963, 38.12438], [-122.43978, 38.12433], [-122.44203, 38.12452], [-122.44261, 38.12454], [-122.44339, 38.1246], [-122.44384, 38.12469], [-122.44487, 38.12528], [-122.44506, 38.12543], [-122.44752, 38.12626], [-122.4481, 38.12618], [-122.44865, 38.12577], [-122.44897, 38.12491], [-122.44915, 38.1241], [-122.4492, 38.12382], [-122.4494, 38.12316], [-122.44977, 38.12227]]]]} | Restricted Access 2 | 44493 | San Pablo Bay National Wildlife Refuge | 24964 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 6942.1 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 14675 | 14675 | 14674 | {"type": "Polygon", "coordinates": [[[-122.47515, 38.13287], [-122.47433, 38.13449], [-122.47417, 38.13476], [-122.47263, 38.1359], [-122.47016, 38.13751], [-122.46989, 38.13761], [-122.45908, 38.14432], [-122.45902, 38.14444], [-122.4586, 38.14458], [-122.45822, 38.14483], [-122.45782, 38.14507], [-122.45741, 38.14529], [-122.45698, 38.1455], [-122.45654, 38.14569], [-122.45609, 38.14586], [-122.45563, 38.14601], [-122.45503, 38.14618], [-122.45426, 38.14635], [-122.45113, 38.13668], [-122.45572, 38.13485], [-122.46439, 38.13148], [-122.47061, 38.12912], [-122.47065, 38.12918], [-122.46943, 38.12969], [-122.46948, 38.12974], [-122.4707, 38.12925], [-122.47091, 38.12953], [-122.47242, 38.12891], [-122.47469, 38.13179], [-122.47508, 38.13258], [-122.47514, 38.1326], [-122.47515, 38.13287]]]} | Restricted Access 2 | 44952 | San Pablo Bay National Wildlife Refuge | 24964 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 490.121 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 15841 | 15841 | 15840 | {"type": "Polygon", "coordinates": [[[-122.44992, 38.12215], [-122.44977, 38.12227], [-122.4494, 38.12316], [-122.4492, 38.12382], [-122.44915, 38.1241], [-122.44897, 38.12491], [-122.44865, 38.12577], [-122.4481, 38.12618], [-122.44752, 38.12626], [-122.44506, 38.12543], [-122.44487, 38.12528], [-122.44384, 38.12469], [-122.44339, 38.1246], [-122.44261, 38.12454], [-122.44203, 38.12452], [-122.43979, 38.12433], [-122.43963, 38.12438], [-122.4389, 38.12424], [-122.43776, 38.12506], [-122.43739, 38.12522], [-122.43677, 38.12567], [-122.43421, 38.12145], [-122.43478, 38.12108], [-122.43655, 38.12044], [-122.43694, 38.12018], [-122.43775, 38.11894], [-122.43899, 38.11781], [-122.43948, 38.11769], [-122.43995, 38.11765], [-122.44046, 38.11737], [-122.44133, 38.11721], [-122.44295, 38.11662], [-122.4437, 38.11626], [-122.44463, 38.11632], [-122.44576, 38.11658], [-122.44688, 38.11696], [-122.44771, 38.11713], [-122.44794, 38.11707], [-122.44807, 38.11716], [-122.44865, 38.11743], [-122.44893, 38.11754], [-122.44909, 38.11763], [-122.45023, 38.11872], [-122.45042, 38.119], [-122.45053, 38.11935], [-122.45069, 38.11962], [-122.45072, 38.11987], [-122.45071, 38.12005], [-122.45051, 38.12042], [-122.44997, 38.1217], [-122.44992, 38.12215]]]} | Restricted Access 2 | 44497 | San Pablo Bay National Wildlife Refuge | 24964 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 259.859 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 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]);