units_with_maps

Table actions

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

5 rows where COUNTY = 26 and MNG_AG_TYP = 1

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, DES_TP

MNG_AG_TYP 1

  • Federal Agency · 5 ✖
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
10037 10037 10036 {"type": "Polygon", "coordinates": [[[-121.66722, 38.31411], [-121.65589, 38.31399], [-121.6561, 38.31289], [-121.65713, 38.30805], [-121.65856, 38.30184], [-121.6597, 38.29795], [-121.6597, 38.29787], [-121.66153, 38.28986], [-121.66267, 38.28866], [-121.66359, 38.28633], [-121.66466, 38.28568], [-121.66479, 38.28461], [-121.66689, 38.29213], [-121.66711, 38.29214], [-121.66704, 38.30674], [-121.66722, 38.31411]]]} No Public Access 3 17394 Little Holland Tract 21338 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1   Solano 26 515.191 Little Holland Tract   None 865  
11150 11150 11149 {"type": "MultiPolygon", "coordinates": [[[[-122.03351, 38.48355], [-122.03249, 38.48361], [-122.03239, 38.48183], [-122.03345, 38.48187], [-122.03351, 38.48355]]], [[[-122.03946, 38.48542], [-122.03946, 38.48542], [-122.03322, 38.48545], [-122.03375, 38.48513], [-122.03417, 38.48477], [-122.03567, 38.48442], [-122.03631, 38.48379], [-122.0368, 38.48319], [-122.03723, 38.48287], [-122.03776, 38.48267], [-122.03808, 38.48219], [-122.03806, 38.48191], [-122.03944, 38.48188], [-122.03946, 38.48542]]], [[[-122.10663, 38.46777], [-122.10175, 38.46781], [-122.10178, 38.47137], [-122.09692, 38.47147], [-122.09695, 38.47847], [-122.10158, 38.47849], [-122.10165, 38.48238], [-122.09693, 38.48236], [-122.09689, 38.48559], [-122.0922, 38.4855], [-122.0925, 38.49092], [-122.09232, 38.49093], [-122.093, 38.50397], [-122.09305, 38.50722], [-122.09316, 38.50723], [-122.09324, 38.51097], [-122.0885, 38.51091], [-122.08834, 38.50388], [-122.07867, 38.50369], [-122.07839, 38.48927], [-122.0784, 38.48237], [-122.08233, 38.48242], [-122.08215, 38.47498], [-122.09179, 38.47496], [-122.09194, 38.47178], [-122.08706, 38.47171], [-122.08718, 38.46813], [-122.09221, 38.46813], [-122.09243, 38.4607], [-122.10661, 38.46096], [-122.10663, 38.46777]]], [[[-122.08306, 38.46779], [-122.08304, 38.4715], [-122.07841, 38.47151], [-122.07847, 38.46769], [-122.08306, 38.46779]]], [[[-122.10652, 38.43207], [-122.10612, 38.43946], [-122.09705, 38.43938], [-122.09698, 38.44612], [-122.09207, 38.44611], [-122.09225, 38.4394], [-122.09704, 38.43937], [-122.09694, 38.43196], [-122.10652, 38.43207]]], [[[-122.10648, 38.50743], [-122.10639, 38.50768], [-122.10582, 38.50758], [-122.10313, 38.50754], [-122.10294, 38.50043], [-122.10581, 38.50041], [-122.10572, 38.50064], [-122.10563, 38.50107], [-122.10562, 38.50191], [-122.10559, 38.50201], [-122.10535, 38.50345], [-122.10534, 38.50377], [-122.10536, 38.50404], [-122.10548, 38.50444], [-122.10562, 38.50509], [-122.10551, 38.5054], [-122.10549, 38.50567], [-122.10541, 38.50605], [-122.10548, 38.50623], [-122.1058, 38.50658], [-122.10596, 38.50682], [-122.10605, 38.50687], [-122.10622, 38.50713], [-122.10648, 38.50743]]], [[[-122.10898, 38.48246], [-122.10892, 38.48297], [-122.10882, 38.48345], [-122.10874, 38.48444], [-122.10865, 38.48497], [-122.10853, 38.48536], [-122.10844, 38.48559], [-122.10807, 38.48624], [-122.10791, 38.48639], [-122.10711, 38.48699], [-122.10692, 38.48719], [-122.10667, 38.4875], [-122.10633, 38.48814], [-122.10632, 38.48244], [-122.10898, 38.48246]]], [[[-122.10656, 38.49686], [-122.10655, 38.49628], [-122.10651, 38.4939], [-122.10673, 38.49398], [-122.1069, 38.49406], [-122.10707, 38.4942], [-122.10725, 38.49454], [-122.1073, 38.49486], [-122.1073, 38.49507], [-122.10721, 38.49546], [-122.10695, 38.49617], [-122.10686, 38.49636], [-122.10656, 38.49686]]], [[[-122.11892, 38.46099], [-122.11876, 38.46147], [-122.11852, 38.46199], [-122.11833, 38.46226], [-122.11817, 38.46255], [-122.11782, 38.46309], [-122.11763, 38.46348], [-122.11758, 38.46373], [-122.11743, 38.46414], [-122.11727, 38.46469], [-122.117, 38.4652], [-122.1166, 38.46574], [-122.11648, 38.46594], [-122.1156, 38.46759], [-122.11545, 38.4679], [-122.11533, 38.4682], [-122.11514, 38.46895], [-122.11462, 38.47026], [-122.11443, 38.47101], [-122.11413, 38.47165], [-122.11386, 38.47232], [-122.11363, 38.4733], [-122.11344, 38.47403], [-122.11318, 38.47487], [-122.1131, 38.47508], [-122.11299, 38.47528], [-122.11048, 38.47527], [-122.11038, 38.46479], [-122.11542, 38.4648], [-122.11552, 38.4611], [-122.11892, 38.46099]]], [[[-122.12518, 38.43695], [-122.12516, 38.44], [-122.12472, 38.44], [-122.12472, 38.44], [-122.12518, 38.43695]]]]} Open Access 1 21506 BLM 16162 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   Solano 26 2071.269 BLM 1899 National Public Lands 1 3
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

CSV options: 

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