calands: units_with_maps: 1 row where ACCESS_TYP = 3, MNG_AG_TYP = 1 and YR

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

1 row where ACCESS_TYP = 3, MNG_AG_TYP = 1 and YR_EST = 1970

Search:

descending

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
15851	15851	15850	{"type": "Polygon", "coordinates": [[[-122.41973, 38.18637], [-122.41959, 38.18658], [-122.41933, 38.18683], [-122.41915, 38.18696], [-122.41892, 38.18707], [-122.41877, 38.18711], [-122.41845, 38.18716], [-122.41745, 38.18726], [-122.41494, 38.18742], [-122.41318, 38.18755], [-122.41097, 38.18769], [-122.4086, 38.18787], [-122.40807, 38.18789], [-122.40735, 38.18789], [-122.40637, 38.18787], [-122.40491, 38.18781], [-122.40366, 38.18775], [-122.40194, 38.18778], [-122.40183, 38.18781], [-122.40135, 38.18802], [-122.39969, 38.18868], [-122.39879, 38.189], [-122.39836, 38.18913], [-122.39776, 38.18928], [-122.39627, 38.18956], [-122.39572, 38.18969], [-122.3952, 38.18986], [-122.39494, 38.18996], [-122.39439, 38.19022], [-122.39395, 38.19045], [-122.39182, 38.1918], [-122.39144, 38.19208], [-122.39119, 38.19233], [-122.39095, 38.1926], [-122.3906, 38.19243], [-122.38982, 38.19296], [-122.38817, 38.19228], [-122.38616, 38.19298], [-122.38601, 38.19282], [-122.38598, 38.19276], [-122.38565, 38.19247], [-122.38493, 38.19193], [-122.38447, 38.19167], [-122.38408, 38.1915], [-122.38351, 38.19132], [-122.38295, 38.19122], [-122.3825, 38.19119], [-122.38227, 38.19116], [-122.38218, 38.19114], [-122.38207, 38.19116], [-122.38076, 38.19126], [-122.38071, 38.19128], [-122.38037, 38.19132], [-122.38027, 38.19136], [-122.37986, 38.19136], [-122.37964, 38.19132], [-122.37958, 38.19135], [-122.37943, 38.19137], [-122.37892, 38.19131], [-122.37825, 38.19116], [-122.37758, 38.19104], [-122.37725, 38.19094], [-122.377, 38.19081], [-122.37616, 38.19057], [-122.37546, 38.19026], [-122.37538, 38.19024], [-122.37442, 38.18977], [-122.37392, 38.18947], [-122.37341, 38.18887], [-122.37335, 38.18883], [-122.3732, 38.18864], [-122.37307, 38.18842], [-122.37293, 38.18804], [-122.37287, 38.18753], [-122.37287, 38.18716], [-122.37297, 38.18695], [-122.37312, 38.18672], [-122.37332, 38.1866], [-122.37359, 38.18648], [-122.37389, 38.18642], [-122.37424, 38.1864], [-122.375, 38.18631], [-122.37553, 38.1862], [-122.37626, 38.1859], [-122.37695, 38.18557], [-122.37742, 38.18525], [-122.37776, 38.18496], [-122.37869, 38.18401], [-122.37888, 38.18372], [-122.37898, 38.18364], [-122.37906, 38.1835], [-122.37907, 38.18345], [-122.37916, 38.18335], [-122.37947, 38.18275], [-122.37968, 38.18229], [-122.37968, 38.1822], [-122.37975, 38.18205], [-122.3798, 38.1819], [-122.37976, 38.18146], [-122.37969, 38.18124], [-122.37966, 38.18107], [-122.37959, 38.18101], [-122.37933, 38.18089], [-122.37891, 38.18063], [-122.37846, 38.18052], [-122.37819, 38.18049], [-122.37793, 38.1805], [-122.37782, 38.18054], [-122.37766, 38.18056], [-122.3769, 38.18083], [-122.37675, 38.18092], [-122.37647, 38.18102], [-122.37637, 38.18107], [-122.37616, 38.18115], [-122.37615, 38.18118], [-122.37595, 38.18128], [-122.37587, 38.18129], [-122.37582, 38.18134], [-122.37448, 38.18177], [-122.37424, 38.18181], [-122.37416, 38.18185], [-122.37381, 38.18186], [-122.37377, 38.18187], [-122.37333, 38.18193], [-122.3729, 38.18197], [-122.37282, 38.18195], [-122.37269, 38.182], [-122.37118, 38.18212], [-122.37012, 38.18227], [-122.36991, 38.18239], [-122.36965, 38.18249], [-122.36936, 38.18266], [-122.36884, 38.1831], [-122.3687, 38.18318], [-122.36858, 38.1832], [-122.3689, 38.18289], [-122.3693, 38.18234], [-122.3694, 38.182], [-122.36948, 38.18182], [-122.36956, 38.18151], [-122.36994, 38.18033], [-122.36999, 38.18013], [-122.37006, 38.17967], [-122.3702, 38.17839], [-122.37023, 38.17713], [-122.37018, 38.17621], [-122.37015, 38.17569], [-122.36997, 38.17417], [-122.36962, 38.17294], [-122.36911, 38.17188], [-122.36829, 38.17032], [-122.36792, 38.16953], [-122.36747, 38.16845], [-122.3673, 38.16794], [-122.36713, 38.16719], [-122.36703, 38.1666], [-122.36699, 38.16602], [-122.36698, 38.1646], [-122.36702, 38.16357], [-122.36704, 38.1633], [-122.36712, 38.16277], [-122.36722, 38.16237], [-122.3673, 38.16214], [-122.3674, 38.16191], [-122.36777, 38.1612], [-122.36806, 38.16079], [-122.36846, 38.1603], [-122.36869, 38.16005], [-122.36881, 38.15993], [-122.3691, 38.15973], [-122.36937, 38.1596], [-122.36997, 38.15938], [-122.37035, 38.15925], [-122.37082, 38.15914], [-122.37126, 38.15905], [-122.37175, 38.159], [-122.37199, 38.15899], [-122.37266, 38.159], [-122.37307, 38.15903], [-122.37369, 38.15914], [-122.37409, 38.15925], [-122.37505, 38.15958], [-122.3759, 38.15991], [-122.37673, 38.16017], [-122.37767, 38.1605], [-122.37957, 38.16118], [-122.38064, 38.16151], [-122.38197, 38.16184], [-122.3824, 38.16193], [-122.38282, 38.162], [-122.38308, 38.16202], [-122.38406, 38.16207], [-122.38439, 38.16205], [-122.38511, 38.16194], [-122.3857, 38.16192], [-122.38648, 38.16194], [-122.3873, 38.16202], [-122.38766, 38.16209], [-122.38828, 38.16224], [-122.38878, 38.16231], [-122.38946, 38.16236], [-122.39058, 38.1624], [-122.3916, 38.16239], [-122.39335, 38.16243], [-122.39441, 38.16242], [-122.39704, 38.16231], [-122.39805, 38.16225], [-122.39852, 38.1622], [-122.39947, 38.16206], [-122.40071, 38.16191], [-122.40177, 38.16173], [-122.40238, 38.1616], [-122.4033, 38.16136], [-122.40404, 38.16113], [-122.40566, 38.16051], [-122.40605, 38.16042], [-122.40646, 38.16039], [-122.40687, 38.16041], [-122.40722, 38.1605], [-122.40742, 38.16059], [-122.40758, 38.16071], [-122.40801, 38.1612], [-122.40852, 38.16164], [-122.40917, 38.16217], [-122.40951, 38.16235], [-122.41023, 38.1627], [-122.41097, 38.16299], [-122.41131, 38.16309], [-122.41231, 38.16333], [-122.41268, 38.16339], [-122.41309, 38.16342], [-122.41394, 38.1634], [-122.41433, 38.16334], [-122.41541, 38.16315], [-122.41642, 38.16292], [-122.41684, 38.16285], [-122.41712, 38.16285], [-122.41737, 38.16291], [-122.41746, 38.16297], [-122.41754, 38.16305], [-122.41759, 38.16313], [-122.41761, 38.16321], [-122.41761, 38.16342], [-122.41749, 38.1637], [-122.4174, 38.16383], [-122.41709, 38.16417], [-122.41627, 38.16498], [-122.41579, 38.16553], [-122.41526, 38.16631], [-122.41516, 38.16651], [-122.4149, 38.16694], [-122.41473, 38.16726], [-122.41444, 38.16789], [-122.41427, 38.16844], [-122.41416, 38.16892], [-122.41409, 38.16932], [-122.41403, 38.16988], [-122.414, 38.17051], [-122.414, 38.1711], [-122.41402, 38.17164], [-122.41416, 38.17237], [-122.4143, 38.17295], [-122.41442, 38.17369], [-122.41451, 38.17395], [-122.41457, 38.17411], [-122.41492, 38.17464], [-122.41512, 38.17523], [-122.41526, 38.17554], [-122.41567, 38.17674], [-122.41573, 38.17695], [-122.41597, 38.17753], [-122.41622, 38.17821], [-122.4169, 38.18035], [-122.41729, 38.18141], [-122.41756, 38.18205], [-122.41807, 38.18299], [-122.41855, 38.18375], [-122.41959, 38.1852], [-122.41983, 38.18559], [-122.41988, 38.18573], [-122.41991, 38.18584], [-122.4199, 38.18602], [-122.41985, 38.18618], [-122.41973, 38.18637]]]}	No Public Access 3	35054	San Pablo Bay National Wildlife Refuge	24962	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	3078.154	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]);