units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AG_TYP = 1 and YR_EST = 1971
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15850 | 15850 | 15849 | {"type": "MultiPolygon", "coordinates": [[[[-124.16059, 40.87217], [-124.15935, 40.87441], [-124.1591, 40.87482], [-124.15841, 40.8758], [-124.15802, 40.87677], [-124.15793, 40.87692], [-124.15746, 40.8779], [-124.15736, 40.87804], [-124.15705, 40.87896], [-124.15707, 40.87975], [-124.15684, 40.88046], [-124.15643, 40.88132], [-124.1557, 40.88248], [-124.15463, 40.884], [-124.15341, 40.88618], [-124.1531, 40.88736], [-124.15228, 40.88842], [-124.15171, 40.88947], [-124.15081, 40.89237], [-124.14956, 40.89484], [-124.14901, 40.89714], [-124.14853, 40.8981], [-124.14798, 40.89904], [-124.14745, 40.90015], [-124.14717, 40.90077], [-124.14702, 40.90141], [-124.13758, 40.90143], [-124.13747, 40.8996], [-124.13857, 40.90032], [-124.13875, 40.90031], [-124.13832, 40.89956], [-124.1387, 40.89925], [-124.13869, 40.89655], [-124.13937, 40.89642], [-124.13968, 40.896], [-124.14294, 40.89593], [-124.14282, 40.89253], [-124.14069, 40.89256], [-124.14045, 40.89212], [-124.14002, 40.8921], [-124.14009, 40.89181], [-124.14043, 40.8918], [-124.14046, 40.89145], [-124.14131, 40.89143], [-124.14123, 40.89108], [-124.14161, 40.89089], [-124.14199, 40.89065], [-124.14188, 40.88971], [-124.14163, 40.88901], [-124.14138, 40.88848], [-124.14151, 40.88777], [-124.1413, 40.88692], [-124.13952, 40.88691], [-124.13952, 40.88663], [-124.13772, 40.8859], [-124.13786, 40.88519], [-124.13851, 40.88394], [-124.1395, 40.88337], [-124.13944, 40.87877], [-124.14934, 40.87533], [-124.15014, 40.87485], [-124.15078, 40.87451], [-124.15139, 40.87417], [-124.15184, 40.87381], [-124.15229, 40.87315], [-124.15289, 40.87208], [-124.15909, 40.87208], [-124.16059, 40.87217]]], [[[-124.15266, 40.87208], [-124.15216, 40.87294], [-124.15169, 40.8737], [-124.15123, 40.87407], [-124.14996, 40.87485], [-124.14922, 40.87527], [-124.14826, 40.87558], [-124.13943, 40.87863], [-124.13941, 40.87686], [-124.14005, 40.877], [-124.14048, 40.87722], [-124.14068, 40.87736], [-124.14092, 40.87725], [-124.14114, 40.877], [-124.14119, 40.87664], [-124.1414, 40.87629], [-124.14178, 40.87609], [-124.14228, 40.87601], [-124.14287, 40.87601], [-124.14336, 40.87594], [-124.1437, 40.87576], [-124.14384, 40.87549], [-124.1438, 40.87521], [-124.14359, 40.87486], [-124.14354, 40.87454], [-124.14353, 40.87433], [-124.1436, 40.87415], [-124.14359, 40.87401], [-124.1438, 40.87379], [-124.14391, 40.87365], [-124.14399, 40.87357], [-124.1441, 40.8735], [-124.14483, 40.87324], [-124.14558, 40.87319], [-124.14582, 40.87316], [-124.14666, 40.87311], [-124.1468, 40.87307], [-124.14695, 40.87296], [-124.14743, 40.87284], [-124.14768, 40.87267], [-124.14772, 40.87256], [-124.14772, 40.87249], [-124.14739, 40.87235], [-124.14716, 40.87219], [-124.14709, 40.87211], [-124.15266, 40.87208]]], [[[-124.14222, 40.91262], [-124.1418, 40.91338], [-124.14125, 40.91495], [-124.14071, 40.91627], [-124.13945, 40.91626], [-124.13942, 40.91259], [-124.14222, 40.91262]]]]} | Restricted Access 2 | 29383 | Humboldt Bay National Wildlife Refuge | 20143 | 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 | https://www.fws.gov/refuge/humboldt_bay/ | Humboldt 45 | 880.169 | Humboldt Bay NWR | 1971 | 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]);