units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 26 and MNG_AGENCY = 44
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2892 | 2892 | 2891 | {"type": "Polygon", "coordinates": [[[-122.3644, 38.14004], [-122.36438, 38.1412], [-122.36339, 38.14077], [-122.36341, 38.13972], [-122.36362, 38.13981], [-122.3644, 38.14004]]]} | Open Access 1 | 23003 | San Pablo Bay National Wildlife Refuge | 24963 | 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 | Solano 26 | 2.6 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 15853 | 15853 | 15852 | {"type": "Polygon", "coordinates": [[[-122.40701, 38.1558], [-122.4061, 38.15579], [-122.40609, 38.15581], [-122.40612, 38.15588], [-122.40423, 38.15594], [-122.40393, 38.15584], [-122.3963, 38.15586], [-122.36626, 38.15587], [-122.36687, 38.15482], [-122.36715, 38.15402], [-122.36716, 38.1538], [-122.36714, 38.15358], [-122.36709, 38.15336], [-122.36705, 38.15322], [-122.36685, 38.15288], [-122.36669, 38.15269], [-122.36638, 38.15247], [-122.36605, 38.1523], [-122.36565, 38.15225], [-122.36541, 38.15224], [-122.36505, 38.15233], [-122.36429, 38.15258], [-122.36438, 38.15181], [-122.36434, 38.15055], [-122.36431, 38.14595], [-122.36426, 38.14285], [-122.36434, 38.14207], [-122.36437, 38.14169], [-122.36576, 38.14221], [-122.36811, 38.14332], [-122.3696, 38.14394], [-122.37114, 38.14428], [-122.3755, 38.14554], [-122.37617, 38.14592], [-122.37659, 38.14629], [-122.37756, 38.14698], [-122.37939, 38.14793], [-122.38052, 38.14854], [-122.38053, 38.14853], [-122.38055, 38.14606], [-122.38003, 38.14598], [-122.37858, 38.14525], [-122.37742, 38.14504], [-122.37609, 38.14458], [-122.37307, 38.14323], [-122.36585, 38.14046], [-122.36362, 38.13981], [-122.36295, 38.13953], [-122.36133, 38.13896], [-122.36078, 38.13868], [-122.3602, 38.13857], [-122.35958, 38.13826], [-122.35892, 38.1379], [-122.35782, 38.13749], [-122.35577, 38.13678], [-122.35534, 38.13661], [-122.35486, 38.13658], [-122.35396, 38.13625], [-122.35318, 38.136], [-122.35183, 38.13539], [-122.35053, 38.13484], [-122.34938, 38.13437], [-122.34845, 38.13391], [-122.34763, 38.13358], [-122.3463, 38.13314], [-122.34561, 38.13282], [-122.34488, 38.13241], [-122.34449, 38.13229], [-122.34435, 38.13223], [-122.34434, 38.13224], [-122.34433, 38.13458], [-122.33483, 38.13109], [-122.32238, 38.12607], [-122.31734, 38.12411], [-122.31156, 38.12166], [-122.31076, 38.12118], [-122.30995, 38.12073], [-122.30911, 38.1203], [-122.30825, 38.1199], [-122.30738, 38.11952], [-122.30649, 38.11916], [-122.30559, 38.11883], [-122.30467, 38.11852], [-122.30374, 38.11824], [-122.30162, 38.11788], [-122.30003, 38.11771], [-122.29842, 38.11765], [-122.29514, 38.11767], [-122.29517, 38.12202], [-122.29391, 38.12176], [-122.29147, 38.12115], [-122.29096, 38.12095], [-122.28991, 38.12067], [-122.28949, 38.1205], [-122.28948, 38.12051], [-122.28961, 38.12104], [-122.28905, 38.12096], [-122.28843, 38.12096], [-122.28752, 38.12099], [-122.28684, 38.12105], [-122.28634, 38.12112], [-122.28545, 38.12115], [-122.28516, 38.12112], [-122.28475, 38.12104], [-122.28445, 38.12092], [-122.28428, 38.12081], [-122.28424, 38.12066], [-122.28424, 38.12054], [-122.28442, 38.12047], [-122.28489, 38.12022], [-122.2849, 38.12015], [-122.28483, 38.12013], [-122.28473, 38.12014], [-122.28458, 38.1202], [-122.28436, 38.12025], [-122.28389, 38.12032], [-122.28372, 38.12027], [-122.28358, 38.12021], [-122.28348, 38.12004], [-122.28343, 38.11989], [-122.28331, 38.11964], [-122.2837, 38.11942], [-122.28408, 38.11929], [-122.28482, 38.11962], [-122.28624, 38.11904], [-122.28761, 38.11865], [-122.28884, 38.11843], [-122.28879, 38.11821], [-122.2892, 38.11772], [-122.29018, 38.11765], [-122.29513, 38.11767], [-122.29515, 38.11712], [-122.29842, 38.11716], [-122.30296, 38.1171], [-122.30355, 38.11722], [-122.30514, 38.11791], [-122.30785, 38.11928], [-122.31264, 38.12161], [-122.3168, 38.12337], [-122.31755, 38.1222], [-122.31754, 38.12218], [-122.31088, 38.11879], [-122.3078, 38.11718], [-122.30626, 38.11634], [-122.30514, 38.11566], [-122.30214, 38.11361], [-122.29654, 38.11052], [-122.30158, 38.10554], [-122.37487, 38.10534], [-122.37578, 38.10654], [-122.37608, 38.10703], [-122.37609, 38.10709], [-122.37881, 38.1114], [-122.38859, 38.12709], [-122.39096, 38.13086], [-122.39201, 38.13255], [-122.39286, 38.13382], [-122.39433, 38.13619], [-122.39494, 38.13713], [-122.39602, 38.13888], [-122.3965, 38.13957], [-122.39688, 38.14018], [-122.39728, 38.14077], [-122.39768, 38.14148], [-122.3981, 38.14212], [-122.39867, 38.14315], [-122.39947, 38.14445], [-122.39999, 38.14523], [-122.40043, 38.14576], [-122.40084, 38.14642], [-122.40133, 38.14727], [-122.40173, 38.14786], [-122.40201, 38.14838], [-122.40308, 38.14995], [-122.40338, 38.15027], [-122.40366, 38.15067], [-122.40393, 38.15092], [-122.40435, 38.15143], [-122.40492, 38.15219], [-122.40548, 38.15285], [-122.40584, 38.1534], [-122.40649, 38.15446], [-122.40701, 38.1558]]]} | Restricted Access 2 | 44494 | San Pablo Bay National Wildlife Refuge | 24964 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 6803.264 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 15854 | 15854 | 15853 | {"type": "MultiPolygon", "coordinates": [[[[-122.31755, 38.12219], [-122.3168, 38.12337], [-122.31264, 38.12161], [-122.30785, 38.11928], [-122.30514, 38.11792], [-122.30354, 38.11722], [-122.30296, 38.1171], [-122.29842, 38.11716], [-122.29378, 38.1171], [-122.29378, 38.11315], [-122.29654, 38.11052], [-122.30214, 38.11361], [-122.30514, 38.11566], [-122.30626, 38.11634], [-122.3078, 38.11718], [-122.31088, 38.11879], [-122.31755, 38.12219]]], [[[-122.34433, 38.13458], [-122.34415, 38.15443], [-122.343, 38.15442], [-122.34265, 38.15444], [-122.34132, 38.15462], [-122.34103, 38.15471], [-122.34042, 38.15496], [-122.33985, 38.15526], [-122.33972, 38.15536], [-122.33934, 38.15573], [-122.33536, 38.1557], [-122.33583, 38.15539], [-122.33598, 38.15524], [-122.33613, 38.1549], [-122.3364, 38.15457], [-122.33713, 38.15379], [-122.33722, 38.15368], [-122.33741, 38.15329], [-122.33766, 38.15251], [-122.33765, 38.152], [-122.3376, 38.1514], [-122.3374, 38.15076], [-122.33735, 38.14974], [-122.33722, 38.1494], [-122.33595, 38.14868], [-122.33563, 38.14838], [-122.33474, 38.14766], [-122.33439, 38.14701], [-122.33421, 38.14628], [-122.33387, 38.1452], [-122.33335, 38.14458], [-122.33305, 38.14404], [-122.33248, 38.14341], [-122.33221, 38.14322], [-122.33127, 38.14273], [-122.33108, 38.14257], [-122.33098, 38.14243], [-122.33098, 38.14219], [-122.33083, 38.14193], [-122.32996, 38.14116], [-122.32968, 38.14087], [-122.32964, 38.14057], [-122.32982, 38.14001], [-122.32956, 38.13962], [-122.32927, 38.1394], [-122.32881, 38.13887], [-122.32858, 38.13844], [-122.32874, 38.13667], [-122.3287, 38.13601], [-122.32826, 38.13561], [-122.32805, 38.13513], [-122.32799, 38.13507], [-122.32762, 38.13486], [-122.32718, 38.13472], [-122.32694, 38.1347], [-122.32629, 38.13477], [-122.3258, 38.13509], [-122.32558, 38.13515], [-122.32441, 38.13495], [-122.32421, 38.13494], [-122.32363, 38.13508], [-122.32312, 38.13515], [-122.32293, 38.13525], [-122.32242, 38.13584], [-122.32213, 38.13601], [-122.32141, 38.13626], [-122.32117, 38.13641], [-122.32096, 38.13671], [-122.32087, 38.13704], [-122.32087, 38.13732], [-122.32074, 38.1376], [-122.32, 38.13836], [-122.31975, 38.13929], [-122.31953, 38.13936], [-122.31924, 38.13924], [-122.31882, 38.13895], [-122.31854, 38.13882], [-122.31826, 38.13882], [-122.31782, 38.13903], [-122.31768, 38.13874], [-122.31756, 38.13856], [-122.31729, 38.13829], [-122.31693, 38.13806], [-122.31672, 38.13786], [-122.31659, 38.13753], [-122.31658, 38.13706], [-122.3165, 38.13694], [-122.31635, 38.13682], [-122.31622, 38.13674], [-122.3155, 38.13649], [-122.31508, 38.13642], [-122.31445, 38.13638], [-122.31409, 38.13631], [-122.31376, 38.13622], [-122.31263, 38.1357], [-122.3123, 38.1356], [-122.31175, 38.13548], [-122.31102, 38.13541], [-122.31069, 38.13535], [-122.31042, 38.13521], [-122.31021, 38.13501], [-122.31008, 38.13488], [-122.30926, 38.13374], [-122.30907, 38.13355], [-122.30899, 38.13359], [-122.3089, 38.13348], [-122.30881, 38.13353], [-122.30861, 38.13321], [-122.30812, 38.13256], [-122.30796, 38.13217], [-122.30787, 38.13177], [-122.30767, 38.1312], [-122.30758, 38.13088], [-122.30787, 38.1305], [-122.30788, 38.1304], [-122.3078, 38.13032], [-122.30767, 38.13002], [-122.30723, 38.12944], [-122.30646, 38.12872], [-122.3062, 38.12851], [-122.30572, 38.1282], [-122.30526, 38.12801], [-122.30467, 38.12782], [-122.30353, 38.12756], [-122.30289, 38.12747], [-122.30178, 38.12743], [-122.30113, 38.12743], [-122.30033, 38.12738], [-122.30016, 38.12728], [-122.29999, 38.12714], [-122.29994, 38.12704], [-122.29978, 38.1269], [-122.30005, 38.12673], [-122.30031, 38.12628], [-122.30052, 38.12575], [-122.30077, 38.12485], [-122.30082, 38.12459], [-122.3008, 38.1244], [-122.30052, 38.12375], [-122.29916, 38.12339], [-122.29779, 38.12316], [-122.29555, 38.12291], [-122.29517, 38.12263], [-122.29514, 38.11767], [-122.29842, 38.11765], [-122.30003, 38.11771], [-122.30162, 38.11788], [-122.30374, 38.11824], [-122.30467, 38.11852], [-122.30559, 38.11883], [-122.30649, 38.11916], [-122.30738, 38.11952], [-122.30825, 38.1199], [-122.30911, 38.1203], [-122.30995, 38.12073], [-122.31076, 38.12118], [-122.31156, 38.12166], [-122.31734, 38.12411], [-122.32238, 38.12607], [-122.33483, 38.13109], [-122.34433, 38.13458]]], [[[-122.38055, 38.14606], [-122.38053, 38.14855], [-122.37939, 38.14793], [-122.37756, 38.14698], [-122.37659, 38.14629], [-122.37617, 38.14592], [-122.37551, 38.14554], [-122.37114, 38.14428], [-122.3696, 38.14394], [-122.36811, 38.14332], [-122.36576, 38.14221], [-122.36437, 38.14169], [-122.3644, 38.14004], [-122.36585, 38.14046], [-122.37307, 38.14323], [-122.37609, 38.14458], [-122.37742, 38.14504], [-122.37858, 38.14525], [-122.38003, 38.14598], [-122.38055, 38.14606]]]]} | Restricted Access 2 | 44495 | 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 | Solano 26 | 1733.092 | 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]);