Question: Dean, in the province Pictou Island is located in, shares a border with what county?

full_context: Document 1: Geography of Prince Edward Island: Prince Edward Island's geography is mostly pastoral with red soil, white sand, and scattered communities. Known as the "Garden of the Gulf", the island is located in the Gulf of Saint Lawrence north of Nova Scotia and east of New Brunswick, with which it forms the Northumberland Strait.
Document 2: Woodlawn, Nova Scotia: Woodlawn is an area of eastern Dartmouth, Nova Scotia in the Halifax Regional Municipality, Nova Scotia that is mainly residential and retail. It is situated within an area with Highway 111 on the west, Portland Street (Route 207) on the east and Main Street (Trunk 7) on the North side. The first three digits of the postal code are B2W.
Document 3: Woodville, Nova Scotia: Woodville is a community in Kings County of about 200 people located in the Annapolis Valley of Nova Scotia. The community is situated north of Cambridge and Waterville at the foot of the North Mountain. Centred along Route 221, Woodville has a volunteer fire department, a Baptist church, two auto body shops, a home run automotive mechanic business, and many family-run farms. It is administratively part of the village of Cornwallis Square. A community centre is located in the former school, built in 1942. The former Wesley Knox United Church, built in 1921, was sold in 2006 is now a residence and artist's workshop.
Document 4: Prince Edward Island: Prince Edward Island (PEI or P.E.I.; French: Île - du - Prince - Édouard) is a province of Canada consisting of the island of the same name, and several much smaller islands. Prince Edward Island is one of the three Maritime Provinces and is the smallest province in both land area and population. It is part of the traditional lands of the Mi'kmaq, and became a British colony in the 1700s and was federated into Canada as a province in 1873. Its capital is Charlottetown. According to the 2016 census, the province of Prince Edward Island has 142,907 residents.
Document 5: Middle Island (Lake Erie): Middle Island is a small island, just 18.5 hectares (46 acres) in size. It is the southernmost point of land in Canada, located at 41 ° 41'N, 82 ° 41 ``W (41.685, - 82.684), or about 41.7 degrees north latitude. It lies in Lake Erie, just south of Pelee Island, and is part of Point Pelee National Park. It forms part of the province of Ontario. The southernmost part of the island lies some 150 metres (164 yards) from the U.S. maritime boundary. The distance to the northernmost point of land in Canada -- Cape Columbia, Ellesmere Island -- is 4,640 kilometres (2,883 miles).
Document 6: Prince Edward Island: Prince Edward Island Île - du - Prince - Édouard (French) Epekwitk (Mi'kmaq) Flag Coat of arms Motto (s): Latin: Parva sub ingenti (The small protected by the great) BC AB SK MB ON QC NB PE NS NL YT NT NU Confederation July 1, 1873 (8th) Capital Charlottetown Largest city Charlottetown Largest metro Charlottetown Government Lieutenant Governor Antoinette Perry Premier Wade MacLauchlan (Liberal) Legislature Legislative Assembly of Prince Edward Island Federal representation (in Canadian Parliament) House seats 4 of 338 (1.2%) Senate seats 4 of 105 (3.8%) Area Total 5,660 km (2,190 sq mi) Land 5,660 km (2,190 sq mi) Water 0 km (0 sq mi) 0% Area rank Ranked 13th 0.1% of Canada Population (2016) Total 142,907 Estimate (2018 Q1) 152,768 Rank Ranked 10th Density 25.25 / km (65.4 / sq mi) Demonym (s) Prince Edward Islander, Islander Official languages English (de facto) GDP Rank 10th Total (2011) C $5.353 billion Per capita C $36,740 (13th) Time zone Atlantic: UTC - 4 Postal abbr. PE Postal code prefix ISO 3166 code CA - PE Flower Pink lady's slipper Tree Red oak Bird Blue jay Website www.princeedwardisland.ca Rankings include all provinces and territories
Document 7: Little Tancook Island: Little Tancook Island is a Canadian island located off the coast of Nova Scotia. The island is one of the 365 islands dotting Mahone Bay. The island is long by wide and is roughly triangular in shape. It is separated from Big Tancook Island by the wide strait called "The Chops". It is located approximately off the Aspotogan Peninsula.
Document 8: Upper Lakeville: Upper Lakeville is a small cottage community on the Eastern Shore of the Halifax Regional Municipality, in the Musquodoboit/Sheet Harbour region of the Marine Drive, in Nova Scotia. Upper Lakeville road is located on the junction of Trunk 7, 55.3 km from Dartmouth, and 58.9 km from Halifax.
Document 9: Puffin Island (Baccalieu Tickle), Newfoundland and Labrador: Puffin Island is a small island in Newfoundland and Labrador, Canada, in a navigation channel called Baccalieu Tickle and just off the coast of Baccalieu Island. The island is an ecological reserve for its population of Atlantic puffin. The island is inaccessible from the water and provides ideal protection for the breeding colonies of Atlantic puffin that makes Puffin Island their home.
Document 10: Pictou Island (Nova Scotia): Pictou Island is a Canadian island located in the Northumberland Strait approximately 4 NM north of Nova Scotia and 10 NM south of Prince Edward Island. Measuring 9.5 km in length and 2.5 km in width, the total area is 23.75 km. The island is administratively part of Pictou County. The island's highest elevation is 24 meters (78 feet) above sea level, and its current full-time residents population (as of 2016) stands at 28, with the seasonal population rising and lowering.
Document 11: Great Village: Great Village is a rural community of approximately 500 people located along Trunk 2 and the north shore of Cobequid Bay in Colchester County, Nova Scotia. It is considered locally to incorporate the areas of Highland Village to the west and Scrabble Hill to the north northwest.
Document 12: Dean, Nova Scotia: Dean is a small farming & forestry community in the North Branch Musquodoboit in the Musquodoboit Valley along the Halifax Regional Municipality/Colchester County county line, in the Canadian province of Nova Scotia, along Route 336. Other communities in the North Branch include Elmsvale, Greenwood, Upper Musquodoboit, and Moose River Gold Mines, among others.
Document 13: Halifax County, Nova Scotia: Halifax County is a county in the Canadian province of Nova Scotia. The Municipality of the County of Halifax was the municipal government of Halifax County, apart from the separately incorporated towns and cities therein. The Municipality was dissolved in 1996, together with those town and city governments, in their amalgamation into Halifax Regional Municipality.
Document 14: Sherbrooke, Nova Scotia: Sherbrooke is a rural community on the Eastern Shore of Nova Scotia, Canada, in Guysborough County. It is located along the St. Mary's River, a major river in Nova Scotia. The community is named for Sir John Coape Sherbrooke, a colonial era Lieutenant Governor of Nova Scotia. Gold was discovered in the area in 1861 and Sherbrooke entered a gold rush in the which lasted two decades. The economy of the community today revolves around fishing, tourism and lumber. The community is the site of an open-air museum called "Sherbrooke Village" which depicts life in the later 1800s in the wake of the gold rush era.
Document 15: Rural Municipality of Cornwallis: Cornwallis is a rural municipality located in the Canadian province of Manitoba. It surrounds the east, south and west sides of Brandon, Manitoba. Most of the land comprising the municipality is farmland, but it contains a few settlements. One of the larger settlements, Sprucewoods, sits at the north gate of Canadian Forces Base Shilo and contains a large group of the municipal population. In the past, there has been friction between the community and the farming base that make up much of Cornwallis.
ground_truth: Colchester County
sub_queries: Pictou Island >> located in the administrative territorial entity Answer: Nova Scotia
Dean, Nova Scotia >> shares border with Answer: Colchester County