text:
Magna Britannia
Magna Britannia: Volume 3, Cornwall
Parishes: Egloshayle - St Ewe
Magna Britannia: Volume 3, Cornwall. Originally published by T Cadell and W Davies, London, 1814.
Egloshayle
Egloskerry
Endelyon
St. Enoder
St. Erme
St. Erney
St. Erth
St. Ervan
St. Evall
St. Ewe
EGLOSHAYLE, in the hundred of Trigg and deanery of Trigg-Minor, lies one mile south-east from Wadebridge, part of which is in this parish, and where there is a post-office and market (fn. n1), and about six miles nearly west from Bodmin; about eight east from Padstow, and somewhat more north-east from St. Columb. The principal villages in this parish, exclusively of the Church-town and Wadebridge, are Bodeeve or Bodive, Burlawn, Slade's-bridge, Trevilder, and Treworder.
The manor of Burnere or Brenere, where the Bishops had a country-seat, belonged to the see of Exeter when the survey of Domesday was taken. At a later period, it was held under the see by the Noseworthy family. The lease having dropped in by the sudden death of Edward Noseworthy, Esq., the last of the family, in 1701, Sir Jonathan Trelawney, then Bishop of Exeter, granted a fresh lease to his own family. The present lessee is James West, Esq., who resides near Swansea in Glamorganshire.
The manor of Treworder belonged to the ancient family of Roscarrock, and was one of the last estates which they had in the county. There is now no manor of that name: the barton of Lower Treworder, which probably was the seat of the Roscarrocks, is now the property of the Rev. Henry Hawkins Tremayne, in right of his wife, one of the coheiresses of the family of Hearle.
Crone or Croan, a seat of the Roscarrocks, was sold, by that family, to the Hills, and by the latter to the Hoblyns. Mrs. Damaris Kirkham, an heiress of the last-mentioned family, bequeathed it to the Rev. Henry Hawkins Tremayne, the present proprietor. The house, which was lately occupied by Francis Hearle Rodd, Esq., is at present inhabited by a bailiff.
The manor of Park was the property and seat of the Peverells, an ancient equestrian family, two of whom were buried in the church of the Grey-Friers at Bodmin. The coheiresses of Peverell brought this estate to the families of Basset and Bottreaux. "My Lorde of Huntingdune," says Leland, "hath a place caulled the Parke, wher Bottreaux had a faire manor castelle, a vi miles by south from Bottreaux. The late Lord Hungerford had half the lordship (fn. n2)." This estate was, at a later period, in the families of Opie and Hickes. In the reign of Queen Anne, it passed, by purchase, to Sir John Molesworth. It was afterwards in the Hoblyns, and passed, by the will of Mrs. Kirkham before-mentioned, to Mr. Tremayne, by whom it has been conveyed, in exchange for other lands, to the late Sir William Molesworth, Bart., father of the present proprietor. A farm-house now occupies the site of the barton: part of the remains of the old mansion has been converted into stables.
The manor of Pencarrow was, at an early period, in the family of Stapleton, nearly a century later in that of Serjeaux, which ended in coheiresses. It is now the property of Sir A. O. Molesworth, Bart. The barton was for many years the seat of a family to whom it gave name. It was forfeited, by attainder, in the reign of Henry VII., and was afterwards, successively, in the families of Walker and Molesworth. John Molesworth, a younger son of a Northamptonshire family, settled at Pencarrow, in the reign of Queen Elizabeth: his grandson Hender, some time governor of Jamaica, was created a baronet in 1689, with remainder to his elder brother, Sir John Molesworth, Knt., of Pencarrow (then Vice-Admiral of Cornwall) and his heirs-male. Pencarrow is now the property and seat of their descendant, Sir Arscot Ourry Molesworth, Bart. The present mansion was built about the year 1730, with stone from a quarry on the barton estate. Borlase speaks of it as perhaps the most capacious mansion in Cornwall.
The manor of Pendavy, which is said to have had extensive privileges with the royalties of the river and the bushelage of coals brought to Wade-bridge, is the property of Sir A. O. Molesworth, Bart. The barton, on which is now a farm-house, was a seat of the ancient family of Kestell, from whom it passed, by marriage, to the Moyles, and from the latter, by sale, to the Usticks.
Kestell, the original seat of the family of that name, as early as the reign of King John, is now also a farm-house of Sir A. O. Molesworth's. It was sold, in 1734, by James Kestell, Esq. Tregleah, a seat of the Keckwich family, and afterwards of the Hoblyns, is now a farm-house, the property of the Rev. H. H. Tremayne, by bequest from Mrs. Kirkham, as before-mentioned.
In the parish-church is the monument of Sir John Molesworth and his lady (without date), and some memorials of the family of Kestell (fn. n3). The church of Egloshayle was given by William, Earl of Gloucester, to the priory of St. James in Bristol, and confirmed by King Edward II. (fn. n4) The great tithes of this parish are now appropriated to the Subdean of Exeter cathedral: the Dean and Chapter of that church are patrons of the vicarage. In the registers of the see of Exeter, are records of chapels at Pendavy and St. Wence, in this parish (fn. n5). Two charityschools, the one for boys, and the other for girls, conducted upon the new system, and combining the plans of Dr. Bell and Mr. Lancaster, have been lately established, and are supported by voluntary subscription.
Wadebridge, which connects this parish and St. Breock, consisting of seventeen arches, and nearly 320 feet in length, was built in the reign of Edward IV., by public contributions, set on foot by John Lovibond, then vicar of Egloshayle. Hals says, that an indulgence was granted to the contributors to this bridge in the year 1485; but we find no record of any such document in the registers of the see of Exeter. The same author adds, that Lovibond gave lands then worth 20l. per annum, for the support of the bridge: these lands are not let now for quite so much. The profit of the tolls is very small. This bridge was made a county-bridge in the reign of James I.
Padstow haven is navigable to Wade-bridge, whither vessels of about forty or fifty tons go up with coals, salt, lime, &c.
Castle-Killibury, an ancient entrenchment, with a treble ditch inclosing about six acres, is in this parish.
EGLOSKERRY, in the hundred and deanery of Trigg-Major, lies four miles north-west from Launceston, which is the post-office town, and nine south-east from Camelford. The only villages, except the Church-town, and part of Tregeare, are Badharlick and Trebeath.
The manor of Penhele, which extends over the whole of this parish, is one of the few which can be satisfactorily traced from the time of the Domesday survey. It was then held, with several other manors, under Robert Moreton, Earl of Cornwall, by Ricardus, whose son, William Fitz-Richard, left a daughter and sole heiress, married to Reginald, Earl of Cornwall, natural son of King Henry I. (fn. n6) This Reginald gave Penhele to William Botterell or Bottreaux, the husband of his aunt, Alice Corbet; and it was afterwards confirmed by him to William Boterell the son (fn. n7), who, in 1199, gave a fine of 300 marks and two goshawks, for livery of this manor and other lands in Cornwall (fn. n8). From that of Bottreaux, Penhele passed, by heirs-female, to the families of Hungerford and Hastings: it was sold, in the reign of Queen Elizabeth, by Henry or George (fn. n9), Earl of Huntingdon, to George Grenville, Esq. The latter alienated it to John Speccot (fn. n10), Esq., who was sheriff of Cornwall in 1622. The grandson and namesake of this John, who was one of the members of the county in three parliaments of William III., died in 1703, having settled this estate on the heirs-male of his aunt Long. Thomas Long, Esq. of Penhele, was sheriff of Cornwall in 1724. Margaret, daughter and heiress of Mr. Long, brought this estate to the late John Bidlake Herring (fn. n11), Esq. who resided at Penhele, and died in 1806. Two-thirds of this estate are now vested in * * * Hill, Esq., a natural son of the late Mr. Herring; the remainder was recovered in a suit at law (after Mrs. Herring's death) of her surviving husband, by the Rev. Charles Sweet, of Kentisbury, in Devonshire. The old mansion is divided in like proportions: Mr. Hill's part is occupied by a servant. The house was new-fronted by the last of the Speccot family.
The barton of Tregeare, partly in this parish, and partly in Laneast and Tresmere, has belonged, for many years, to the family of Baron. The old bartonhouse is in the parish of Tresmere; a new mansion, built by the late Jasper Baron, Esq., on that part of the estate which is in the parish of Laneast, is now occupied by his widow: Mr. Baron left a son, who is a minor.
The barton of Treludick, in this parish, which belonged also to the Barons, passed, by marriage, to Saltern; of which family it was purchased, by the grandfather of Mr. Peter Hurdon, the present resident proprietor.
In the parish-church, said to have been dedicated to St. Kyryasius or St. Kyriacus, are some monuments of the Speccots. George Owen, Esq., of Tiverton, is patron of the vicarage, and impropriator of the great tithes, which belonged formerly to the priory of Launceston. There is a meeting-house of the Wesleyan methodists at Tregeare.
ENDELYON, now spelt Endellion, in the hundred of Trigg and deanery of Trigg-Minor, lies about five miles from Wade-bridge, and about seven from Camelford, which is the post-office town. The principal village in this parish is Port-Isaac, where a considerable pilchard-fishery is carried on, and there is a small market on Fridays for butchers'-meat. The principal export of this place is slate, from the Delabole quarries: coals are imported hither from Wales. Norden speaks of Port-Isaac as wonderfully increased in buildings. Port-Guin, which was formerly a large fishing-town, and has since declined, he observes, was increasing also. Leland also speaks of both these havens, and another in the same neighbourhood, called Porth Karne: at "Porthissk," he observes, "was a pere, and sum socour for fisschar botes." Norden describes Port-Kerne "as a little cove and haven, where had been divers buildings, all decayed since the growing up of PortIsaac."
The manor of Trefrike or Trefreke belonged to the family of Serjeaux. On the death of Sir Richard Serjeaux, in 1396, it passed, by a coheiress, to the Marneys, and was afterwards in the family of Passelew, descended from another coheiress of Serjeaux (fn. n12). In 1736 the manor of Trefrike belonged to John Hamley, Gent. It is now the property of Frederick Cock, Esq.
The manor of Treore or Treroare belonged to the Boscawens. The heiress of Hugh Boscawen, Esq., who died in 1701, brought it, in marriage, to Hugh Fortescue Esq., of Philleigh, in Devonshire, grandfather of Earl Fortescue, who is the present proprietor.
The manor of Roscarrock belonged to the ancient family of that name, as early as the year 1347, at which time John de Roscarrock was one of the representatives of the county. In 1670 it was sold by Charles Roscarrock, Esq., who is supposed to have been the last of the family, to Edward Boscawen, Esq. The manor has since been successively the property of the Earl of Westmorland and Dr. Mean. It was purchased of the latter by Mr. Warwick Guy, the present proprietor and occupier, who had been many years tenant of the barton.
The manor of Bodannan or Bodannon was formerly a seat of the ancient family of Chenduit, corruptly called Cheyney (fn. n13). Sir John Chenduit, of this family, was one of the representatives of the county in the reigns of Henry IV. and Henry V. His son, William, left two daughters coheiresses, married into the families of Trejago and Roscarrock. An ancient uninscribed tomb in the chancel is said to have belonged to one of this family, and is, by a vulgar but groundless tradition, said to be that of a Lord Cheyney. This manor fell to the share of the Roscarrocks, and was sold, in 1586, by John Roscarrock, Esq., to Nicholas Dagge, yeoman, who, in 1597, conveyed it to Henry Rolle, Esq. In 1739, it was purchased of a descendant of the same name by John Lyne, Esq., father of the Rev. Philip Lyne, LL. D., the present proprietor.
To this manor was anciently annexed the bailiffry of the hundred of Trigg, which, by Norden, is said to have been sometimes called the hundred of Bodannan. (fn. n14)
Strickstenton or Triggstenton, parcel of this manor, said to have been a seat of the Cheynduits, belonged to the Matthew's in the year 1620. It is now the property of Mrs. Clements. There are no remains of any mansion.
The barton of Tresonger or Tresungers, was, in Norden's time, a seat of the Matthew's, who had married the heiress of Tresonger; from the Matthew's it passed, by sale, to the Arthurs. It is now a farm-house, the property of William Wymond, Esq., who purchased the estate of the Arthurs.
Pennant, some time a seat of the Rowes, is now a farm-house, the property of Mr. John George.
Endellion church being situated on high ground, the tower is seen as a landmark at a great distance. The north aisle is the burial-place of the Roscarrocks. The church is collegiate, and has three prebendaries, exclusively of the rector. The rectory, and the prebend called the King's prebend, are in the patronage of the crown; the prebend of Trehaverock, in that of the Hon. Mrs. Agar, as representative of the family of Robartes, Earl of Radnor; and that of Heredum-Marney (fn. n15), in the patronage of Richardson Gray, Esq., whose family have possessed the advowson of it for more than a century. The prebends are sinecures; all the prebendaries have portions of tithes; and those of Heredum-Marney, and Trehaverock, houses and glebes.
The manor of Roscarrock pays, in lieu of tithes, a modus of 9l. per annum, which is divided in equal portions between the rector and two of the prebendaries. This modus was formerly paid, according to an ancient custom, on the morning of Michaelmas-day, before sun-rising, in the church porch.
There were formerly chapels at Roscarrock and St. Illick (fn. n16), of which the ruins are still to be seen.
At Port-Isaac is a charity school, established about the year 1804, and supported by voluntary subscriptions.
ST. ENODER, in the hundreds of Pyder and Powder, and in the deanery of Pyder, lies about five miles west from St. Columb, and about ten east from Truro, which is the post office-town. The principal villages in this parish, exclusively of the church-town, are Fraddon, Penhale, and Summer-Court. Part of the small borough of Michell, also, is in this parish. There are three great fairs held at Summer-Court for horses, bullocks, sheep, &c. One of these, held on the 28th of July, is of modern date, the others are ancient chartered fairs; and the right of holding them was lately purchased of the Rev. Dr. Luttrell Wynne, by Sir Christopher Hawkins, Bart. Both these fairs belonged to the Veres, Earls of Oxford; one of them, attached to the Earl's manor of Polsew in St. Erme, was held at a place called Long-Chepyng on Holyrood day (fn. n17); the other, still called Penhale fair, held on the 25th of September, has been transferred from that village to SummerCourt. It belonged, in the reign of Edward II., to John le Seneschall (fn. n18), and in that of Edward IV. to the Veres. (fn. n19)
The manor of Argallez or Arrallas was formerly in the Dinham family (fn. n20), afterwards in that of St. Aubyn. Having become vested in the crown, it was granted, successively, to the Duke of Clarence and the Duke of Gloucester (fn. n21) : it is now the joint property of Sir Carew Vyvyan, Bart., and William Rashleigh, Esq. of Menabilly, by inheritance and bequest from the Carew family. The site of the manor is occupied by a farm-house.
The manor of Borthy was many years in the family of Penrose; afterwards in the Boscawens: it is now the property of Lord Falmouth.
The barton of Carvynick was a seat of the Willoughbys, a Dorsetshire family, whose coheiress brought it to a branch of the Arundells of Lanherne. The heiress of Zach. Arundell married Anthony Tanner, a younger son of the Tanners of Court in Brannell, one of whose coheiresses brought it to the grandfather of the Rev. Thomas Penwarne, the present lessee of this estate under the church of Windsor. The mansion is occupied as a farm-house.
Pencoose or Pencorse, formerly a seat of the family of Jolly: it was purchased in the reign of Charles II. by Arthur Fortescue, whose descendant, Captain Fortescue of the guards, sold it, about the year 1790, to Mr. William Basset. The house has been modernized by Mr. Basset for his own residence.
Trewhela, some time the seat of a younger branch of the Hoblyns, is now the property of Mr. John Basset, of Chytane, in this parish.
The barton of Treweese, some time a seat of the Trewithicks, an ancient family now extinct, belongs to Sir Carew Vyvyan, Bart., and Francis Retallack, of St. Michell. The latter purchased his moiety of the late Philip Rashleigh, Esq. of Menabilly (fn. n22). The site of the barton is now occupied by a farm-house.
Gonronson, the seat some time of a younger branch of the Flamanks, was sold by them, in 1724, to the Hawkins family: it is now a farm-house, the property of Sir Christopher Hawkins, Bart. Boswallow, which was sold by the Richards family to John Stephens, Esq. of St. Ives, is now a farm-house, the property of Samuel Stephens, Esq., of Tregenna Castle.
Goonhaskin, spoken of by Norden as a house of the Coswarths, is now a farmhouse, belonging to a minor of the name of Bennet, as heir of the Gullys.
Bodanna or Bodannan, in this parish, belonged to the Footes of Lambesso, of whom it was purchased by Mr. Johnson Vivian, great uncle of John Vivian, Esq. of Pencallenick, the present proprietor.
The parish-church, which had fallen down, was rebuilt in the reign of Charles II. Tonkin supposes, that St. Athenodorus gave name to the church and parish. The great tithes, appropriated formerly to the college of Glaseney, are held on lease by Samuel Stephens, Esq., under the Bishop of Exeter, who is patron of the vicarage. At Arrallas are the ruins of a chapel, and a meadow, called the Chapelmeadow; at Michell and Hendra are meadows of the same name, but no remains of chapels. All these meadows pay great tithes to the vicar.
Partly in this parish as before observed, and partly in that of Newlyn, is the small borough-town of Michell, improperly so called, and still more improperly St. Michael: it is written in ancient records Modeshole. In the year 1301, John de Arundell certified his right to a market and fair in his manor of Modeshole: this market and fair had been granted to Walter de Ralegh, of whose son Peter, his ancestor, Ralph de Arundell, had purchased the manor (fn. n23). The market has been long disused; an annual fair is held on the 15th of October, chiefly for sheep, of which from three to four thousand head are generally offered for sale.
The manor of Michell passed, by sale, from the Arundells to the Scawens of Carshalton in Surrey: it was afterwards in Sir Francis Basset, Bart. (now Lord de Dunstanville), of whom it was purchased by Sir Christopher Hawkins, Bart. This borough, which has sent two members to parliament ever since the reign of Edward VI., is governed by a portreeve annually elected at the court-leet of the High Lord, by a jury consisting of the principal inhabitants of the borough nominated by the High Lord; which portreeve, by prescription, must be one of the five chief tenants or mesne-lords. The present portreeve (1812) is Mr. Richard Curgenven: the other deputy-lords are the Rev. Henry Hawkins Tremayne; Thomas Carlyon, Esq. of Tregrehan; the Rev. T. Carlyon, rector of Truro and vicar of Probus, and the Rev. Richard Hennah, vicar of St. Austell. "The members to serve in parliament," says Browne Willis, "have been elected several ways; sometimes by a jury of the principal inhabitants; and at others, by the inhabitants in general; but on the 20th of March 1700, the right of election was settled by a vote of the House of Commons to be in the lords of the said borough, capable of being portreeves, and in the inhabitants paying scot and lot, who were then not above sixteen, but are now twenty-six (fn. n24)." The present number of voters, exclusively of the lords, is only four.
Richard Carew, Esq., of Anthony, who wrote the survey of Cornwall, was one of the representatives of this borough. It appears by the registers of the see of Exeter, that there was formerly a chapel at Michell, dedicated to St. Francis; this chapel has been long ago demolished, and a dwelling house built on the site. The adjoining field is still called the Chapel-field.
ST. ERME, in the deanery, and in the west division of the hundred of Powder, lies three miles and a half from Truro, which is the post-office town. The principal villages in this parish, exclusively of the Church-town, are Trevispan, commonly called Trispan, Stairfoot, and that part of Tresilian which lies west of the bridge, that on the east side being in the parish of Merther. At this bridge was concluded the treaty between Sir Ralph Hopton and Sir Thomas Fairfax, in the month of March 1046, by which the county of Cornwall was surrendered to the parliament. There are two annual fairs at Tresilian bridge; viz. on the second Monday in February, and on the Monday before Whitsuntide, for cattle, &c.
The manor of Polsew or Polzue, called in the Domesday Survey, Polduh, was part of the large estate held under Robert, Earl of Cornwall, at the time of taking that survey by Ricardus, and passed with the daughter of his son William Fitz-Richard, to Reginald, Earl of Cornwall. This manor was one of the estates which came into the family of Vere, Earl of Oxford, by marriage with one of the coheiresses of Serjeaux. It was forfeited by the attainder of John, Earl of Oxford, who held St. Michael's Mount against King Edward IV., in 1471. (fn. n25) It appears, by an inquisition taken after the death of Richard, Earl of Oxford, in 1416, that the advowson of the church was attached to this manor, and a fair, called Long-Chepyng fair, now held at Summer-Court in St. Enoder, and that it was held of Sir John Dinham, as of his manor of Cardinham (fn. n26). At a later period, this manor was successively in the families of Mapowder and Luttrel (fn. n27); from the latter, it descended to Richard Wynne, Esq., Serjeant-at-law, father of the Rev. Luttrel Wynne, LL.D., the present proprietor. The barton of this manor is held on lease by Mr. Zaccheus Andrew, whose family have occupied it nearly a century.
The manor of Tregasa or Tregasow became, by purchase, the property of John Coke, Gent., about the year 1600. His son, Thomas Coke, Esq., was sheriff of the county in the latter end of the reign of Charles I. (fn. n28) His grandson sold this estate to Hugh Boscawen, Esq., ancestor of Lord Viscount Falmouth, who is the present proprietor. Tregasow house was built, but left in an unfinished state, by Thomas Coke the younger: it is now a farm-house.
The manor of Killigrew belonged to the ancient family, now extinct, to whom it gave name. They continued to possess it till about the year 1636, when it was sold to John Jagoe (fn. n29), Esq. His descendant, Itai Jagoe, alienated it to Mr. Robert Corker of Falmouth, who died in 1731. In 1737, Mr. John Stephens, of St. Ives, (ancestor of Samuel Stephens, Esq., the present proprietor,) bought this manor of Sir John Molesworth and Edmund Prideaux, Esq., who, the preceding year, had purchased of the Prince of Wales all the lands which had been Mr. Corker's, and afterwards Mr. Tregagle's. There are no remains of the ancient mansion, the site of which is now an arable field.
The manor of Trevenen, partly in this parish, and partly in Gorran, belonged to the priory of Tywardreth, and was one of those which, in 1540, were annexed to the duchy of Cornwall in lieu of the honour of Wallingford.
The barton of Ennis was formerly a seat of the Opies (fn. n30), and was sold by them, in the reign of James I., to the ancestor of Mr. Samuel Jagoe, who now resides at Ennis. The former residence of the Jagoe family had been at the barton of Truthan, which was held under the Borlases, as lessees under the see of Exeter, it being parcel of the Bishop's manor of Cargol in Newlyn. Mr. Borlase, who was sheriff of the county the two last years of James II., and is said to have been created a peer by that monarch after his abdication, had built a house on this barton for his own occasional residence (fn. n31). He afterwards leased the barton for lives to the family of Williams. John Williams, Esq., of Truthan, was sheriff in 1705; the last of that family who resided there, was John Williams, Esq., who died in 1764. Truthan is now the seat of Edward Collins, Esq., who purchased the lease of John Thomas, Esq., Vice-warden of the Stannaries. The see of the manor of Cargol, under which this barton is held, is now (by a late purchase made under the powers of the land-tax redemption act) vested in Sir Christopher Hawkins, Baronet.
The barton of Trevellow, which was for several descents a seat of the family of Laugherne, is now the property and residence of Mr. George Simmons.
The barton of Polglase was sold by the Killigrews in the year 1610; and having been successively in the families of Luxton and Rosogan, was purchased, in 1659, by Thomas Tonkin, Esq., of Trevaunance. This small estate, on which is a farmhouse, is now in severalties among his representatives, or persons who have purchased of them.
The barton of Treworgan belonged to the family of Trencreek, from whom it passed, by a female heir, to the Polwheles. John Polwhele, Esq. sold it, in the early part of the last century, to Mr. John Collins: it is now, by purchase from a cousin, the property of Edward Collins, Esq. of Truthan. The house, which was some time a seat of the Polwheles, and afterwards of the Collins family, is now occupied by a farmer.
Treworgan-Vean, which, in Hals's time, was the residence of Mr. Andrew Ley, is now a farm-house, the property of his descendant, Mr. Hugh Ley. Trehane-Vean, in Hals's time, a seat of a younger branch of the Courtenays of Trethurfe, passed, by female heirs through the Bawdens, to the present proprietor, Joseph Beauchamp, Esq. of Pengreep in Gwennap: it is now a farm-house.
In the parish-church are monuments of Robert Trencreek (fn. n32), Esq. of Trencreek in Creed, 1594; Joan, wife of John Coke, Esq. of Tregasow, 1630, and John Jagoe, Esq. (fn. n33) of Truthan, 1652. The benefice is a rectory in the patronage of Dr. Wynne, the advowson having been always attached to the manor of Polsew. There is no endowed school in this parish, but the poor children are taught to read at the expence of the Rev. Dr. Cornelius Cardew, the rector.
ST. ERNEY, in the hundred and deanery of East, lies about two miles north by east from St. Germans. The principal village, exclusively of the Church-town, is Markwell.
The manor of Trelugan was, at an early period, in the family of Dawney, from whom it passed, by a female heir, to the Courtenays, Earls of Devon, and continued in that family as late as the reign of Henry VII. (fn. n34) It is not now known as a manor: the barton is the property and residence of Francis O'Dogherty, Esq., who inherits it from the family of Blake.
The manor of Markwell was parcel of the estate of Thomas, Earl of Lancaster (fn. n35), attainted in the reign of Edward II.; afterwards of the Bodrugans (fn. n36). In the reign of Henry VII., it was granted (after the attainder of Henry Bodrugan) to Sir John Poulett, from whom it descended to the late Duke of Bolton: it is now vested in the Duchess Dowager.
At St. Erney, which is a daughter-church to Landrake, divine service is performed only on the first Sunday in every month, when there is no service at the mother-church. (fn. n37)
ST. ERTH, in the hundred and deanery of Penwith, is situated on the river Heyle, five miles from St. Ives, four from Marazion, which is the post-office town, and seven from Penzance, which is the chief market-town of the neighbourhood. Leland says, that St. Erth bridge was built 200 years before his time (which would carry it back to the middle of the fourteenth century), and that good tall ships came up to that place before the haven was barred up with sands.
The manor of Trelowith, in this parish, has been long in the St. Aubyn family, together with that of Trenhale, of which there is now no knowledge or remembrance, it having been long merged in the former. The barton of Trenhale or Trenhayle was formerly the seat of a family of that name (fn. n38); it is now in severalties; and there are no remains of any mansion upon it which has the appearance of having been a gentleman's seat.
The manor of Trelisick was purchased, in the reign of Charles II., of Sir James Smith, by the family of Paynter or De Camborne. The heiress of the elder branch of the Paynters brought Trelisick to the Hearles. It is now the property of Francis Hearle Rodd, Esq., whose mother was one of the coheiresses of the last-mentioned family. Great part of the old mansion on this estate has been taken down; what remains has been fitted up as a farm-house.
The barton of Trewinnard belonged to an ancient family of that name, two of whom were successively members for the county in the reign of Edward III. The last who appears to have possessed this barton was William Trewinnard, one of the members for Helston, in the reign of Henry VIII. From the Trewinnards it passed to the Mohuns, who some time resided at Trewinnard. It is said to have been settled, by one of this family, on his three daughters (fn. n39), one of whom brought her share to Arundell of Tolverne: this share, to which the mansion was annexed, was purchased of the Arundells by Sir Nicholas Hals of Fentongollan, who occasionally resided at Trewinnard; his son sold this share, with the mansion, to Thomas Hawkins, Esq., ancestor of Sir Christopher Hawkins, Bart., the present proprietor, who keeps Trewinnard house in his own hands, and occasionally resides there. The other shares were held some time by the Hawkins family under the families of Praed and Penrose (fn. n40). The fee of these is now vested in Sir John St. Aubyn, Bart. and Mr. Praed of Trevethow, under whom Sir Christopher Hawkins has a lease for life.
The barton of Cuskease belonged formerly to the family of Burges of Trethingey, and passed from them, by a female heir, to the Hoblyns of Nanswhyden, in whom it is still vested.
Gurlyn (fn. n41), successively a seat of the families of Gurlyn, Tregender, Nansperian, Matthew, Prideaux (fn. n42), and Gregor, is now the property of Francis Gregor, Esq., and occupied by the Rev. William Vaudrey. Gear, some time a residence of the Vivian family, is now occupied by John Vivian Tippet, Esq.
Tredrea, held on lease under the St. Aubyns, was formerly the seat of an ancient family who took their name from this barton, and afterwards successively of the families of Phillipps and Davies: it is now the residence of the Rev. Edward Giddy (fn. n43), who married the heiress of Davies. The Phillipps's had another mansion in this parish, called Boswordy.
This parish was anciently called Lanhudnow; a tenement of that name adjoining the Church-town, is now the property of Mr. Rodd, who is lessee of the great tithes under the church of Exeter. The south aisle of the parish-church is called Trewinnard's aisle. In the church-yard are some memorials of the family of Davies. There are the remains of an ancient chapel at Porthcullumb in this parish, the property of Mr. Andrew Hoskins. There is a charity-school at St. Erth, endowed with a house and 5l. 19s. 4d. per annum, being the interest of money given by the Rev. Thomas Ralph and Christopher Hawkins, Esq. (fn. n44)
A little above the vicarage-house is a circular double entrenchment, called Carhangives, said to have belonged to the Dinham family: it is still held under the manor of Cardinham.
ST. ERVAN, in the hundred and deanery of Pyder, lies four miles and a half north from St. Columb, which is the post-office town, and four miles south from Padstow. The principal villages are Penrose and Rumford.
The manor of Trewinnick, which, about the year 1500, passed from the family of Halep, whose coheiresses married Boscawen and Trefusis, was sold by Lord Falmouth, in the year 1774, to Mr. William Brewer, and by him, the same year, to the Rev. John Bassett Collins, father of G. F. Collins Browne, Esq.; the latter in 1805 sold the barton to Mr. William Eplett, by whose representatives it is now occupied as a farm. The remainder of the estate has since been sold in parcels. The manerial rights are now vested in Mr. Thomas Key. This manor was held under that of Trevose in St. Merryn.
The manor of Trembleth or Trembleigh was the property of an ancient family of that name, whose heiress brought it to the Arundells about or before the commencement of the fourteenth century. It was purchased, not many years ago, of Lord Arundell of Wardour, by Mr. Francis Crosse of Crediton, the present proprietor. Trembleth was the chief seat of the Arundells before their match with the heiress of Lanherne.
The manor of Trenowth was, for several generations, the property and residence of the family of Hore (fn. n45). It has long ceased to be considered as a manor. The barton is the property of Mr. Peter Day, whose ancestors had long occupied it as a farm under the family of Hawkins. The small manor of Bojea, in this parish, is claimed by Peter Bowen Harris, Esq. and by Mr. Peter Day.
Treraval, a seat of the Beres, is now a farm-house, the property of John Hicks, Esq.
In the parish-church are some memorials of the families of Keate and Pomeroy. The benefice is a rectory in the patronage of Sir A. O. Molesworth, Bart.
ST. EVALL, in the hundred and deanery of Pyder, lies about five miles northwest from St. Columb, which is the post-office town, and the same distance southwest from Padstow. The principal villages in this parish are Treburthick and Downhill. The manor of Trethewell belonged to the ancient family of Nanfan (fn. n46), several times sheriffs of the county in the fifteenth century. Richard Nanfan having died without male issue, this estate passed, by a female heir, to the family of Erisey, and, by successive sales, to those of Grenville, Smith, and Leach. It is now the property of Mrs. Crosse, a descendant of the last-mentioned family, who resided many years at Trethewell (fn. n47). The barton was purchased, about the year 1798, by Lovell Todd, Esq. (Captain of the Prince of Wales packet), who is the present proprietor: the house is occupied by a farmer.
The tower of the parish-church having fallen down towards the commencement of the last century, was rebuilt from the foundation, and completed in 1727. The expence, which amounted to nearly 400l., was defrayed by collections in the county, aided by a contribution from the Bristol merchants, to whose vessels navigating the north sea, it is, from its loftiness, a conspicuous sea-mark. In the church are some memorials of the family of Trevelick (1693 — 1731.) The Bishop of Exeter is patron of the vicarage; Captain Todd is lessee of the great tithes under the Bishop.
ST. EWE, in the deanery and in the east division of the hundred of Powder, lies about six miles from St. Austell, and three from Mevagissey, which is the postoffice town. The principal villages, exclusively of the Church-town, are Polmasick and Crowswin.
The manor of St. Ewe was in the family of Hiwis as early as the beginning of Edward the Third's reign (fn. n48), and passed, with Tremoderet (fn. n49), and other estates, to the coheiresses of Arundell, of that place: a portion of it, which fell to the share of the St. Aubyn family by the marriage with the coheiress of Whittington, was lately purchased of Sir John St. Aubyn, Bart. by Sir Christopher Hawkins, Bart. who is now proprietor of the whole; his family having inherited the remainder (which had passed through several hands) from the Seymours, Tredenhams, and Scobells.
The manor of Lansladron or Lanshadron, called in the Domesday Survey, Lanlaran, was held by Reginald de Valletort of Robert, Earl of Moreton and Cornwall: it was afterwards the seat of Serlo de Lansladron, who was summoned to parliament in the reign of Edward I. Miranda, his daughter, having married Govely, whose heiress married Trerice, on the failure of issue from the great grandson of this Serlo, the Trerices, or their representatives, the Arundells, appear to have been heirs of this ancient family. We find, however, that this manor, by purchase probably, came to the Arundells of Lanherne. The manor of Lanhadron, and that of Tregenna in St. Ewe, which belonged also to the Arundells, were, not many years ago, sold in severalties. The barton, on the site of which is now a farm-house, was purchased by the Rev. Henry Hawkins Tremayne. Norden calls Lanhadron "an auntient howse of the Arondells, where was the moste statelieste parke within the shire, now utterly decayde, and the woodes rooted up and the land sowed with corne. There is an oke within the circuit of this decayde parke, called Arondell's oke, which is sayde to beare leaves as whyte as whyte paper. Some suche leaves are ordinarye on manie others, but to be so generall is more straunge." The barton of Tregenna was, for many years, on lease to the family of Robins, afterwards to that of Randyll. The fee of this barton was purchased lately by Mr. John Gaved, of St. Mewan, who has rebuilt the house for his own residence.
The manors of Treworick, Tucoyse, and Penstrasa, belonged, anciently, to the family of Bodrugan. On the attainder of Sir Henry Bodrugan, they were granted by King Henry VII. to Sir Richard Edgcumbe, and are now the property of his descendant, the Earl of Mount-Edgcumbe. The barton of Treworick was for many years a seat of the Carkeits.
The manor of Helligan was, at an early period, in the Helligans, from whom it passed, by successive female heirs, to the Tregarthians and Whitleghs, and from the latter, by coheiresses, to the families of Grenville and Hals. In the reign of Queen Elizabeth, it was purchased by Sampson Tremayne, Esq., ancestor of the Rev. Henry Hawkins Tremayne, the present proprietor. Helligan-house, which was built by Sir John Tremayne, Serjeant-at-law, about the year 1692, is now the seat of his descendant above-mentioned.
The manor of Polsew is supposed to have been formerly in the family of Nanspyan or Nansperian; on a partition of whose estates among coheiresses, it fell to the share of the Vyvyan family. About the year 1611, it was purchased of the Vyvyans by the Seccombes of Merther, who alienated it to the Slades. It is now the property of * * * Allen, yeoman, of Perran-Zabuloe.
The manor of Tregian or Tregyan, gave name to an ancient family, who, upon their removal to Golden in Probus, suffered the mansion on this estate to go to ruin. The manor of Tregian was forfeited in the reign of Queen Elizabeth, Francis Tregian, Esq., its owner, having been convicted of secreting a Romish priest (fn. n50). This manor has been dismembered; the barton became the property of the Hicks's, a branch of the Gloucestershire family of that name, who possessed also the barton of Trevithick, in this parish. At the latter place they built a capital mansion, which continued to be the seat of the family till the death of John Hicks, Esq. without issue, in 1734. The barton of Tregian now belongs to Mr. Gaved of St. Mewan; what remains of Trevithick is a farm-house, belonging to Arthur Kempe, Esq., Admiral of the Blue.
There was formerly a manor called Trelewick or Treluige, in this parish, many years ago dismembered. The barton was the seat of John Archer, Esq., who died in 1733. The house soon afterwards fell to decay, and is now a farm-house, the property and residence of Mr. John Harris. The estate was sold, about twenty years ago, by Addis Archer, Esq., cousin of Mr. Archer, of Trelask.
Tonkin speaks of the following bartons in this parish: — Pensiquillis, the last seat of the Penkevills in this county (fn. n51) (where Benjamin Penkevill died unmarried, in 1699), now a farm-house, the property of Sir Christopher Hawkins, Bart.; Trelisick, within the manor of Polsew, some time a seat of the Tremaynes, afterwards of the Hookers, now a farm-house, belonging to Thomas Carlyon, Esq., of Tregrehan; Tregonan, within the manor of Tucoyse, some time a seat of the Beaumonts, afterwards, successively, of the Tredenhams and Scobells, partly dilapidated, the remainder being fitted up as a farm-house, the joint property of Mr. Tremayne and Thomas Hext, Esq., as descended from the Scobells; and Kestell-Wartha and Kestell-Wollas, formerly seats of the Tremaynes, now farms belonging to their descendant, the Rev. H. H. Tremayne. One of these was the residence of Colonel Lewis Tremayne during the civil war, and was plundered by the soldiers of the Earl of Essex.
Lithney alias Luny was the seat of a family of that name, one of whose coheiresses, in the reign of Queen Elizabeth, married into the family of Kempthorne of Tonacombe (fn. n52). It was afterwards a seat of the Mohuns, who rebuilt the old mansion about the year 1700. Luny is now a farm-house, the property of the Earl of Mount-Edgcumbe: his father, the late Earl, purchased it of the representatives of Mrs. Birkhead, who possessed it by bequest of her first husband, William Mohun, Esq.
Bosew, held some time under the Arundells, by the family of Crusse, is now a farm of Mr. Tremayne's.
Levalsa, some time a seat of the Henwoods, was, not long since, in the occupation of Captain Warwick, of the Navy, son-in-law of Mr. Peter, then proprietor: it is now a farm-house, belonging to the Earl of Mount-Edgcumbe.
Tonkin says, on the authority of Mr. Lewis Tremayne, that the famous Hugh Peters was born at Trelean, in this parish.
In the parish-church are monuments of the Penkevills of Pensiquillis; Robert Quarme, Esq., 1708; William Mohun, Esq., "the last of that ancient name and family," 1737; and of the Tredenham family, particularly that of Elizabeth, only daughter of Sir Edward Seymour, Bart., and wife of Sir Joseph Tredenham of Tregonan, who was buried in Westminster-Abbey, in 1706. (fn. n53) In the north aisle, belonging to the Tregonan estate, is a monument of one of the Scobell family.
The advowson of the rectory was purchased, about the year 1750, of the families of St. Aubyn and Hawkins (it having been annexed to the manor of St. Ewe), by the Rev. John Pomeroy, from whom it has passed, in moieties, to the representatives of his daughters, who married William Carlyon, Esq., and Edward Cregoe, Esq.
Dr. Hugh Atwell, rector of this parish, is spoken of by Carew for his singular practice of physic (fn. n54), which is said to have been applied with great benevolence, and to have been attended with such success, that his cures were ascribed to the magic art. Risdon says, that he lived to be 100 years of age, and that the maidservant who attended him was 120; but Prince tells us, that he died at the age of ninety-one years, on the 4th of May 1617: he adds, that it was a received tradition in the parish of St. Ewe, that he was buried naked, and that the shroud in which he had been wrapped, containing thirty ells of linen, was given, by his own direction, to the poor at his grave.
n1. The market is on the St. Breock side.
n2. Itin. III 133.
n3. In the reigns of Henry VIII. and Queen Elizabeth.
n4. Dugdale's Monasticon, I. 513.
n5. Borlase's Notes. There are no remains of these chapels, nor is the site of St. Wence known.
n6. Gesta Stephani, p. 950.
n7. Cart. Antiq. in the Record-office at the Tower.
n8. Dugdale's Baronage, I. 628.
n9. George succeeded Henry in 1595.
n10. This Mr. Speccot married Lady Essex Robartes, daughter of the Earl of Radnor, by whom he had no issue: he founded a mathematical school now established at Looe. (See the account of St. Martin's near Looe.)
n11. Her first husband was Thomas Davy, Esq. She had no issue by either.
n12. Esch. 1 Hen. IV., 13 Edw. IV., &c.
n13. There was a numerous race of the Cheynes or Cheyneys, anciently De Caisneto, quite a distinct family, dispersed into several counties; chiefly in Buckinghamshire, Cambridgeshire, and Bedfordshire.
n14. Extent. Ducat. Cornub. 17 Jac. I.
n15. The name points out this prebend to have been formerly in the patronage of the ancient family of Marney, who possessed the manor of Trefrike.
n16. In the Exeter Registers called St. Elente. (Borlase's MS. Notes.)
n17. Esch. 4 Hen. V.
n18. Esch. 2 Edw. II.
n19. Esch. 15 Edw. IV.
n20. See Carew's Survey, f. 44.
n21. Pat. 2 Edw. IV., and 4 Edw. IV.
n22. They purchased, in 1626, of Sir Bernard Grenville and his son Beville.
n23. Placita, 30 Edw. I.
n. Notitia Parliamentaria, published in 1716., II. 157.
n24. Notitia Parliamentaria; published in 1716, II. 157.
n26. Esch. 4 Hen. V. 53.
n27. Tonkin.
n28. Hals.
n29. The barton had been sold to the family of Michell about the year 1600, and passed afterwards to Jagoe. The Killigrews retained the manor some years longer, but had sold all the lands piecemeal, before 17 Jac. I. (Extent. Terrar. Ducat. Cornub., in the possession of Sir John St. Aubyn.)
n30. Opie had it as late as 17 Jac. I. (Extent. Terrar. Ducat, Cornub.)
n31. His chief seat was at Treluddra-Park.
n32. He married the coheiress of the families of Vivian and Kingdon, and left four daughters, married into the families of Carminow, Penwarne, Polwhele, and Mohun.
n33. Epitaph: — "He was more than he seem'd, yet seemed to be More than a thousand more; his pedigree Is drawn in Heaven, where, if ere you come, You'll see more of him than in verse or tombe."
n34. Dugdale's Baronage.
n35. Esch. 15 Edw. II.
n36. Esch. 6 Hen. VI.
n37. For an account of the patronage and impropriation, see Landrake.
n38. Hals says, that the Trenhales were extinct in the reign of Edward III., when the heiress married Trencreek, and that an heiress of Trencreek married Budcoxhed, which family became extinct in the reign of Queen Elizabeth. It appears by the parish-register, that some of the Trenhale or Trenhayle family remained in the seventeenth century. George Trenhayle, Gent., was buried at St. Erth in 1687, and is said to have been the last of the family who was possessed of the barton of Trenhayle.
n39. Hals says Sir Reginald, but by the pedigrees of the family, it does not appear that he had three daughters. He appears to have been son of Sir William Mohun and to have had three sisters; Bridget, married to Arundell of Tolverne, and two others married to Horsey and Speccot. Norden calls Trewinnard the seat of Mannering, by which it is probable that he meant Mohun, as he has written Biscow for Boscawen and Myntaye for Munday.
n41. The Dinhams had a manor of Gurlyn, 2 Hen. IV. (Arundell Papers.) We find no other place of this name: perhaps the Gurlyns held under the Dinhams.
n42. Matthew and Prideaux married the coheiresses of Nansperian about the year 1600, and successively possessed Gurlyn.
n43. He married the sister and heiress of Henry Davies, Esq., who died in 1760, by whom he had Davies Giddy, Esq., now M. P. for Bodmin. The father of Henry Davies married Elizabeth Phillipps of Tredrea.
n44. The Rev. Thomas Ralph, vicar of Ingatestone in Essex, gave, in 1754, the sum of 100l. for the purpose of endowing a school at St. Erth, to be laid out according to the discretion of Mr. Collins, vicar of St. Erth, and Christopher Hawkins, Esq. Mr. Hawkins, after the sum of 16l. had been expended in repairing a house for a school-house, added, by codicil to his will, the sum of 100l to the remainder.
n45. Tonkin. — It continued in the family of Hore in Norden's time.
n46. It is said to have been purchased by John Nanfan, in the reign of Henry VI. (Hals.)
n47. Her father, Francis Lewellyn, Esq., took the name of Leach, in addition to his own, when he became possessed of this estate. He died in 1744.
n48. Esch. 5 Edw. III.
n49. See p. 79. It was one of the manors which, having been forfeited by Sir Robert Trefilian's attainder, was granted to his widow (the heiress of Hiwis), and her second husband, Sir John Coleshill.
n50. It was granted, by Queen Elizabeth, to Sir George Carey (afterwards Lord Hunsdon), Pat. 21 Eliz. Lady Hunsdon sold it to the son of Francis Tregyan, by whom it had been forfeited: it was soon afterwards alienated from the family. (See the account of Golden in Probus.)
n51. It was purchased by Philip Hawkins, Esq., in 1706, of J. Rosevear and Francis Rose, as coheirs of the Penkevills.
n52. Borlase's Collections.
n53. Sir Joseph Tredenham died in 1707, and was buried also in Westminster Abbey, where is a monument to his memory.
n54. "Mary his practice is somewhat strange and varying from all others; for though now and then he use blood-letting, and do ordinarily minister Manus Christi, and such like cordials of his own compounding, (a poynt fitting well with my humour, as enabling nature, who best knoweth how to worke,) yet mostly, for all diseases, he prescribeth milk and very often milk and apples, a course deeply subject to the exception of the best esteemed practitioners; and such notwithstanding as whereby either the vertue of the medicine, or the fortune of the phisicion, or the credulitie of the patient, hath recovered sundry out of desperate and forlorne extremities." Carew's Survey, f. 60.


Nortel was the victim of a years-long network security breach that allowed hackers to extract its trade secrets, according to a veteran of the bankrupt Canadian telco systems biz.
The hackers stole at least seven passwords from top executives before downloading research, business plans, technical papers, corporate emails and other sensitive data, the Wall Street Journal reports.
Brian Shields, a veteran former worker at the firm who led an internal investigation, told the paper: "They had access to everything. They had plenty of time. All they had to do was figure out what they wanted."
The attackers, suspected to be based in China, planted carefully camouflaged spyware on client PCs in order to extract passwords, Shields said. The whole assault was so well-executed that it went undetected for years.
Shields, a Nortel employee for 19 years, said the firm only detected a possible breach in 2004 – when it discovered that some PCs were regularly sending sensitive data to an IP address in Shanghai. Subsequent investigations suggested the breach dated back as far back as 2000, if not earlier.
At the time, Nortel responded to the breach by changing compromised passwords, Shields to the WSJ. It discontinued an internal investigation into the breach after six months, reportedly because of lack of progress. Shields said Nortel's management ignored his recommendations on how to tighten up the firm's network.
Mike Zafirovski, Nortel's chief exec between 2005-2009, played down the significance of the breach. He told the Wall Street Journal that staff "did not believe it was a real issue".
China is routinely blamed for economic espionage-style attacks, which it has consistently denied. Questioned over the Nortel breach, the Chinese embassy denied any involvement and told the journal that cyberspying attacks are "transnational and anonymous".
Nortel went bankrupt three years ago, back in 2009. It allegedly failed to disclose the breach on its network to prospective buyers of its assets around the time it went under.
The reported breach against Nortel follows cyberespionage-style attacks against RSA, Google, US defence contractors and Mitsubishi Heavy industries in Japan – among several others.
Neil Roiter, director of research at Corero Network Security, commented: "We've seen time and again that enterprises are successfully breached and the cyber attackers continue to operate undetected for months, even years. The Nortel breach that apparently spanned over nearly a decade is a lesson to all that organizations must implement strong security policies and technology."
"Organisations need to ensure they have the proper tools at the perimeter and within their networks, and aggressive monitoring to detect outbound traffic and suspicious activity in the event of a breach. The Aurora attacks, the RSA breach and others demonstrate that Fortune 500 companies and other large enterprises are under constant threat from nation states such as China seeking shortcuts to technological advances."
The prevalence of breaches is likely to prompt tougher rules on breach disclosure, according to Roiter.
"Perhaps more disturbing, if the report is accurate, is the failure of Nortel to respond when the breach was discovered, and, less surprisingly, their failure to disclose it. Perhaps the danger was less clear eight years ago than it is now, but the continued failure of what was viewed as an innovative and sophisticated IT company to appreciate and address the risk is puzzling. We expect that the new SEC guidelines will result in more disclosures, such as the recent revelation of the VeriSign breach in 2010, and that companies will be more up front about these events for the sake of the business community at large."
Chris Petersen, CTO of LogRhythm, a log management company, noted that financially motivated industrial espionage has been going on for decades, long before the present focus on attacks from China.


Our team pride themselves on their expertise, punctuality, reliability and respect for your home. That us why we have so many happy customers.
"Dave organised a fast and superb fix with one of his engineers when I needed some reworking of my kitchen pipework. The engineer found a fault with my hot water system that would have caused untold damage to recently decorated rooms. Many thanks.


Just posted this as a comment to Clotilde's Pain au Levain post (8/24/10) - then realized the forum might be a better place.
This Art of Eating/Clotilde exchange is so interesting - it really highlights the complicated relationships in the food publishing world.
On the subject of publications...there is (of course) so much amazing food writing out there. I'm interested to hear how other people pick and choose - right now I'm trying to hone a list of websites and books to keep up with that's diverse, manageable, etc. One of the issues (as pointed out in the post) is depth vs width - i.e., short blog posts vs long mag articles.
Just interested to see how other people address information overload in the food world in particular.
Welcome to the forums Cara Mae, and thanks for the interesting question!
I use an RSS reader (Vienna) to keep up with blogs and other sites, and I regularly do some housekeeping, deleting subscriptions I feel don't inspire/educate me on a regular basis.
To avoid information overload, I also "mark all articles as read" every other week or so: if I haven't gotten around to reading to them in that time span, I probably never will and that's okay.
Another thing I do is use Instapaper to flag articles I want to read but don't have time to read right away. Then, when I have more time (or when I'm in line at the post office with my iphone) I can review those articles and do some reading.


text:
Chicago government housing targeted for warrantless searches for weapons
8 Apr 94.
CHICAGO (AP) -- The finer points of constitutional law mean little to many tenants at the Robert Taylor Homes, a public housing project where children sleep in bathtubs to escape the bullets that come crashing through windows.
Many tenants want to give police the right to search apartments without a warrant to get rid of the guns that make life in the projects so terrifying.
``You're weighing your life against your rights,'' said one Robert Taylor tenant who asked not to be identified for fear of reprisals.
On Thursday, however, U.S. District Judge Wayne Andersen ruled that police can't search the projects without a warrant. People in public housing do not lose their constitutional protection against unreasonable searches, he said.
And while people are free to let police search their homes if they want, they cannot waive the constitutional rights of their neighbors, Andersen said in refusing to lift a ban on police sweeps that he imposed last month.
``The erosion of the rights of people on the other side of town will ultimately undermine the rights of each of us,'' he said.
Lula Ford, principal of Beethoven Elementary School in the heart of the Robert Taylor complex, said she was ``incensed'' by the decision, adding that she is certain gang violence will erupt anew.
``The judge has decided to disregard this community and the children in it,'' Ford said.
Chronic violence last summer prompted the Chicago Housing Authority to ask police to conduct random, door-to-door gun searches without warrants in public housing complexes. The American Civil Liberties Union sued on behalf of the estimated 150,000 public housing tenants, and Andersen put a stop to the sweeps.
Gang warfare last month at Robert Taylor brought new urgency to the debate. In a five-day period, police received more than 300 reports of gunfire in the 28-building, 12,320-tenant complex that spreads over more than a dozen city blocks. One person was killed and six were wounded.
One tenant, Tammera Evans, said she has had to dodge bullets just to buy groceries. When she calls police to report shots, they tell her to stay away from the windows, which can be difficult in a one-bedroom apartment, she pointed out.
``Mothers put kids in their bathtubs in fear of their lives,'' CHA chairman Vincent Lane said before Thursday's hearing.
Lane was agitated as he left the courtroom after Andersen's ruling.
``My job is to protect the life and limbs of residents of public housing,'' he said. ``I'm not going to look for the ACLU to ask for their permission.''
Shortly after the ruling, President Clinton announced he has ordered Attorney General Janet Reno and Housing Secretary Henry Cisneros to develop a search policy for public housing that is both constitutional and effective.
``We must not allow criminals to find shelter in the public housing community they terrorize,'' Clinton said.
ACLU attorney Harvey Grossman praised Andersen's ruling. He argued that because public housing tenants are poor, authorities want to take unconstitutional shortcuts to deal with violence in the projects.
``You would not see weapons searches of apartments on Lake Shore Drive,'' one of Chicago's most affluent areas, Grossman said. ``The problem here is the inability to provide everyday law enforcement.''
``I don't care what they (ACLU) say,'' tenant Ron Newman said. ``I think sweeps are a good idea. I should feel free to come and go into my home without being afraid.''
But another tenant, Louis McCray, said: ``I'm not violating any law and I have nothing to hide, but police should have warrants before they come into your house.''
Home Ordering Email Articles US state historical int'l poles, etc
Former Detroit Mayor: Seal off Neighborhoods, Search House to House
Seal off Neighborhoods, Search House to House
for Guns--Detroit Mayor said.
American Survival Guide: The Magazine of Self Reliance
June 1993, Vol. 15, No. 6
Survival Line, page 8
The mayor of one of the nation's major cities is seriously proposing that the government should begin conducting massive gun searches.
Detroit Mayor Coleman Young said in a February 16th., 1993 interview in *USA Today* that he supports a plan to seal off entire neighborhoods with barriers in order to conduct massive gun searches.
Mayor Young said "drastic action" was needed because children were being killed by "people riding around in cars carrying guns. If we could cordon off an area and search everybody in that area for guns, we should." Young went on to say that, " I've been talking to various police officers and lawyers, trying to find some legal way of doing this. It's difficult...but we need to do it."
Previous Articles Next Articles
Home Ordering Email Articles US state historical int'l poles, etc Waco pics

redpajama_set_name: RedPajamaCommonCrawl


text:
Q: Getting phone call request in my app I have made a phone app in android, and I want that whenever there is a request for a phone call, my app should also be listed in the list of apps. What are the permissions required for this?

A: Try this code :
Manifest :
<uses-permission android:name="android.permission.READ_PHONE_STATE" />
<uses-permission android:name="android.permission.PROCESS_OUTGOING_CALLS"/>

<!--This part is inside the application-->
    <receiver android:name=".CallReceiver" >
        <intent-filter>
            <action android:name="android.intent.action.PHONE_STATE" />
        </intent-filter>
        <intent-filter>
            <action android:name="android.intent.action.NEW_OUTGOING_CALL" />
        </intent-filter>
    </receiver>

My base reusable call detector
import java.util.Date;

import android.content.BroadcastReceiver;
import android.content.Context;
import android.content.Intent;
import android.telephony.TelephonyManager;

public abstract class PhonecallReceiver extends BroadcastReceiver {

    //The receiver will be recreated whenever android feels like it.  We need a static variable to remember data between instantiations

    private static int lastState = TelephonyManager.CALL_STATE_IDLE;
    private static Date callStartTime;
    private static boolean isIncoming;
    private static String savedNumber;  //because the passed incoming is only valid in ringing

    @Override
    public void onReceive(Context context, Intent intent) {

        //We listen to two intents.  The new outgoing call only tells us of an outgoing call.  We use it to get the number.
        if (intent.getAction().equals("android.intent.action.NEW_OUTGOING_CALL")) {
            savedNumber = intent.getExtras().getString("android.intent.extra.PHONE_NUMBER");
        }
        else{
            String stateStr = intent.getExtras().getString(TelephonyManager.EXTRA_STATE);
            String number = intent.getExtras().getString(TelephonyManager.EXTRA_INCOMING_NUMBER);
            int state = 0;
            if(stateStr.equals(TelephonyManager.EXTRA_STATE_IDLE)){
                state = TelephonyManager.CALL_STATE_IDLE;
            }
            else if(stateStr.equals(TelephonyManager.EXTRA_STATE_OFFHOOK)){
                state = TelephonyManager.CALL_STATE_OFFHOOK;
            }
            else if(stateStr.equals(TelephonyManager.EXTRA_STATE_RINGING)){
                state = TelephonyManager.CALL_STATE_RINGING;
            }

            onCallStateChanged(context, state, number);
        }
    }

    //Derived classes should override these to respond to specific events of interest
    protected abstract void onIncomingCallReceived(Context ctx, String number, Date start);
    protected abstract void onIncomingCallAnswered(Context ctx, String number, Date start);
    protected abstract void onIncomingCallEnded(Context ctx, String number, Date start, Date end);

    protected abstract void onOutgoingCallStarted(Context ctx, String number, Date start);
    protected abstract void onOutgoingCallEnded(Context ctx, String number, Date start, Date end);

    protected abstract void onMissedCall(Context ctx, String number, Date start);

    //Deals with actual events

    //Incoming call-  goes from IDLE to RINGING when it rings, to OFFHOOK when it's answered, to IDLE when its hung up
    //Outgoing call-  goes from IDLE to OFFHOOK when it dials out, to IDLE when hung up
    public void onCallStateChanged(Context context, int state, String number) {
        if(lastState == state){
            //No change, debounce extras
            return;
        }
        switch (state) {
            case TelephonyManager.CALL_STATE_RINGING:
                isIncoming = true;
                callStartTime = new Date();
                savedNumber = number;
                onIncomingCallReceived(context, number, callStartTime);
                break;
            case TelephonyManager.CALL_STATE_OFFHOOK:
                //Transition of ringing->offhook are pickups of incoming calls.  Nothing done on them
                if(lastState != TelephonyManager.CALL_STATE_RINGING){
                    isIncoming = false;
                    callStartTime = new Date();
                    onOutgoingCallStarted(context, savedNumber, callStartTime);
                }
                else
                {
                    isIncoming = true;
                    callStartTime = new Date();
                    onIncomingCallAnswered(context, savedNumber, callStartTime);
                }

                break;
            case TelephonyManager.CALL_STATE_IDLE:
                //Went to idle-  this is the end of a call.  What type depends on previous state(s)
                if(lastState == TelephonyManager.CALL_STATE_RINGING){
                    //Ring but no pickup-  a miss
                    onMissedCall(context, savedNumber, callStartTime);
                }
                else if(isIncoming){
                    onIncomingCallEnded(context, savedNumber, callStartTime, new Date());
                }
                else{
                    onOutgoingCallEnded(context, savedNumber, callStartTime, new Date());
                }
                break;
        }
        lastState = state;
    }
}

Then to use it, simply derive a class from it and implement a few easy functions, whichever call types you care about:
public class CallReceiver extends PhonecallReceiver {

    @Override
    protected abstract void onIncomingCallReceived(Context ctx, String number, Date start)
    {
        //
    }

    @Override
    protected abstract void onIncomingCallAnswered(Context ctx, String number, Date start)
    {
        //
    }

    @Override
    protected abstract void onIncomingCallEnded(Context ctx, String number, Date start, Date end)
    {
        //
    }

    @Override
    protected abstract void onOutgoingCallStarted(Context ctx, String number, Date start)
    {
        //
    }

    @Override
    protected abstract void onOutgoingCallEnded(Context ctx, String number, Date start, Date end)
    {
        //
    }

    @Override
    protected abstract void onMissedCall(Context ctx, String number, Date start)
    {
        //
    }

}

Or
private MyPhoneStateListener phoneStateListener = new MyPhoneStateListener();

to register
TelephonyManager telephonyManager = (TelephonyManager) getSystemService(TELEPHONY_SERVICE);
telephonyManager.listen(phoneStateListener, PhoneStateListener.LISTEN_CALL_STATE);

and to unregister
TelephonyManager telephonyManager = (TelephonyManager) getSystemService(TELEPHONY_SERVICE);
telephonyManager.listen(phoneStateListener, PhoneStateListener.LISTEN_NONE);

redpajama_set_name: RedPajamaStackExchange


Halo e-liquid entered the market as one of the first American producers of vaping juice. They revolutionized the way e-liquid was presented, and in doing so gave themselves a ticket to the top table of US liquid manufacturers. Back then, nearly all e-liquid in the American market was imported from China. At first nothing was thought of this, until people began to question Chinese quality control methods, especially given the sensitive nature of vapor design to be inhaled into the lungs. Halo were quick to spot the opportunity and soon began producing an expertly-crafted range of e-juices, made at their very own Florida manufacturing plant.
All Halo liquids are independently tested for diacetyl and acetyl propionyl.
Halo has long been known for their ability to produce great flavors, but in 2015 five of their products gained prestigious "Spinfuel Choice" awards, confirming what many already believed, that Halo is right up there with the best juice makers in the country.


Re: $24.90 Modase 40L pack..
With all my gear for 30-40degree temps I'm in just under 12lbs without food and water. The lack of padding on the straps won't be an issue I dont think, for me anyways.
I am 5'10" ,155 lbs. I wonder if your belts are anchored different. I'm gonna take it on a 5 mile over night this weekend. I still need to strap my UQ on it and water/food. I'll find a way for $24.00 bucks. Good deal for sure. Do they make a larger version?
As far as I know its only one size. When I ordered I believe it said it was a "..large 40L.." so I assumed it meant for a taller framed person. It did look quite small when I opened it but it fits what I need so I'm happy lol. And on the hip pockets, they are a bit behind me rather than at my sides but I can deal with it (6ft 235lbs) I like the feel of the pack being centered and compact on my back. Enjoy your trip and hope it works out for you.
Hike yesterday went okay. Had some shoulder pain about mile 3. Had a plastic piece explode as well. Plain and simple , this bag might not be for me.
I'm going to give the pack a readjusting and manage weight and secure load a little better. I really want this pack to work.


text:
Broeder Corp was started in by two incoming dental students, Eric Bender and Jake Schroeder. (Bender + Schroeder = Broeder). Both Eric and Jake attended the University of Minnesota for their undergraduate studies in Biochemistry.
The Broeder Boys will be attending dental school at the University of Minnesota (Jake) and the University of Pittsburgh – Pennsylvania (Eric).
Having both line-striped in the past, the Broeder boys have come together to provide parking lot line-striping and sealcoating services.
Eric and Jake are happy to serve the Minneapolis Metro!
Eric Bender
Eric grew up in Fort Atkinson, Wisconsin. He moved to Minneapolis to attend the University of Minnesota, where he completed a minor in management in addition to his pre-dental studies. He knows what it takes to run a business and has a handle on all of the accounting and managerial duties.
Jake Schroeder
Jake Schroeder, of Elk River, MN, began working in the line-striping business at a very young age. With his father, a head-engineer for Graco Industries (one of the largest line-striping machine manufacturers), Jake learned early on what it takes to stripe a parking lot and maintain the hardware involved.
Jake has many other skills beyond line-striping. Such as welding and making pottery. Check out his Etsy page for more information.


text:
Home » Issues » November 1959 » M.G. Records at Utah
M.G. Records at Utah
Following the successful record attempts by the Austin-Healey Sprite at Utah, the supercharged M.G. EX-181 was taken out by Phil Hill to attack Class E (up to 2,000 c.c.) records.
The record for the flying kilometre was set at 254.91 m.p.h. and that for the flying mile at 254.53 m.p.h. Other records taken by Hill include the flying five kilometres at 232.97 m.p.h., the five miles at 238.36 m.p.h., the 10 kilometres at 234.49 m.p.h., and the 10 miles at 191.03 m.p.h. which is rather a drop on the 10 kilometres speed, suggesting that some trouble intervened, but full details of the run have not yet filtered back to Britain.
The record attempts were delayed for some time owing to the state of the Bonneville Salt Flats after some days of torrential rain.


text:
Home > Services / Finances
Get the latest updates of services and finance in the Mediterranean: media, distribution, information technology and communication, real estate, tourism, jobs, logistics, audit, consulting, banks, insurance companies, stock market, currency, funds investment, EBRD, ADB, EIB, stock market, IMF, public finance, loans, grants, venture capital, social economy ... in Algeria, Spain, France, Italy, Morocco, Tunisia, Portugal, Egypt, Greece, Turkey ...
Innovation funds fill the gaps left by the Moroccan State - 10/26/2015 - Julie Chaudier, CASABLANCA
Special edition no.15: FEMIP
Morocco has not reached the targets it set itself in 2009 in its Moroccan Innovation Strategy (Stratégie Maroc Innovation) plan. Innovative project holders are consequently struggling to find funding, especially in the initial stages of their business ventures.
Tunisia : "We are prioritising innovation in energy and the environment" - 10/26/2015 - Francis Mateo, BARCELONA
Special edition no.15 : FEMIP
Mustapha Kchir, SME sector manager at the Bank of Tunisia, takes stock of the difficulties and challenges in providing proper support to innovative SMEs, including vital technical assistance to ensure good access to finance.
Jordan targets regional leadership in innovation - 10/26/2015 - Caroline Garcia, MARSEILLE
JORDAN. In a difficult regional context, the Kingdom has advantages enabling it to consider its economic future from an innovation perspective.
"Innovation is an opportunity for Lebanon" - 10/26/2015 - Mélanie Houé, BEIRUT
Khater Abi Habib, President and CEO of the SME loan guarantee finance company, Kafalat, reviews the situation of innovation in Lebanon.
Innovating in the Mediterranean for growth and jobs - 10/26/2015
MEDITERRANEAN. Economic change in Southern Mediterranean countries will occur more easily if it results in direct benefits for employment, particularly for young people. Existing schemes to fund innovative SMEs cover a wide range of needs but can still progress.
A shattered world stands at a crossroads - 12/09/2013 - Jean-Christophe Barla
"The current uncertainties do not encourage investment in the MENA zone" confided the moderator Fatiha Dazi-Héni at the opening of the round table. Discussions have confirmed the diversity of the political, economic and social situations in a region where transitions are far from complete and there are still many...
More resources and greater freedom for projects - 12/09/2013 - Jean-Christophe Barla
Sustainable growth in the countries of the MENA region requires economic diversification. Such diversification requires tailored financing. Financing structures are emerging to support major projects and start-ups. Arab countries have problems with youth unrest, urbanisation, social inequality and political instability, to...
Africa, the Middle East and Europe: a game of three players - 12/09/2013 - Gérard Tur
The Mena Economic Forum advocates the constitution of an integration space that includes North Africa, the Gulf States and southern Europe. A triple alliance that is essential to draw the Mediterranean out of the economic and social depression into which it has fallen.
The irrepressible drive of tourism in the Southern Mediterranean - 11/26/2012 - Frédéric Dubessy with the correspondents
Morroco, Algeria, Tunisia, Egypt, Turkey…all these Southern Mediterranean countries are renewing their tourism strategies.
Mediterranean tourism evades the crisis - 11/26/2012 - Frédéric Dubessy with the correspondents
MEDITERRANEAN. In spite of the economic crisis and the Arab Spring, the Mediterranean countries are expected to record a growth in their tourism of between 2 and 4% in 2012. French version
Morocco counts on sustainable tourism - 11/26/2012 - Christelle Marot, CASABLANCA
MOROCCO. Sustainable tourism appears to be the only hope for a troubled industry. French version
A roadmap for recovery in Tunisia - 11/26/2012 - Nadia Chahed, TUNIS
TUNISIA. Once regarded as the jewel of the national economy, tourism in Tunisia has suffered enormously.
Egypt takes a gamble on diversification - 11/26/2012 - Safia Ouared, Cairo
EGYPT. Egypt is planning to upgrade its tourism industry. The country wants to build on its renewal using key international and domestic markets.


Jimmy Chen and Tammy Tan, the father and mother of Father's Factory, were both immigrants to the United States. They went to design school together and started their careers as designers thereafter. After losing his job in 2014, Jimmy decided to start his own business. As a father, Jimmy used cardboard to build toys for his two lovely daughters, Emma and Summer. Over time, his creations became an important part of the girls' lives. They decorated the cardboard castle that Jimmy built, and they imagined it populated by flying dragons, fighting knights, and dancing princesses.
Seeing the many magical moments that his creations bought to his family, Jimmy was inspired to spread the joy with parents and kids around the world. He started to design toys that would bring families together and create memories that would last lifetimes. He wanted his creation could spark children's imaginations. He spent 3 years to design, and look for the best wooden toy factory. He even prototyped them in his own factory (his garage), and the name "Father's Factory" was born.
Father's Factory's second product line is four styles of wooden digital cameras. They are working cameras with beautifully designed wooden bodies. These wooden digital cameras encourage the art of photography and the magic of capturing everyday moments with your little ones. They give us opportunities to enjoy the present moment rather than focusing on taking the perfect photos. In a world of "instant" and "now", these are perfect for teaching children patience, understanding delays, and even how to deal with disappointment. They are for kids of all ages, including adults who are kids at heart.
When Jimmy and Tammy are not busy designing their next wooden toys, they love spending time with their two daughters out in the garden, taking care of their plants.


text:
Q: Combine multiple similar queries into one I need to calculate a weighted average using the following table. I have to calculate this number for metric_1 up to metric_10. All the metric columns have a value from 1 to 5.
------------------------------------------------------
id | var      | weight | metric_1 | metric_2 | week
------------------------------------------------------
1  | 9        | 0.56   | 4        | 2        | 8
2  | 3        | 1      | 3        | 1        | 7
3  | 7        | 0.98   | 3        | 5        | 8
------------------------------------------------------

Here's the query I'm using. I need same query for each metric, from 1 to 10.
SELECT
    weight, sample_size, detractor,
    (promoter * 100) / weight AS promoter_p,
    (promoter - detractor) * 100 / weight AS score
FROM
    (
        SELECT
            COUNT(surveys.id) AS sample_size,
            SUM(weight),
            SUM(CASE WHEN var BETWEEN 9 AND 10 THEN pond END) AS promoter,
            SUM(CASE WHEN var BETWEEN 0 AND 6  THEN pond END) AS detractor,
            MAX(week)
        FROM surveys
        WHERE (var BETWEEN 0 AND 10) AND (metric_1 BETWEEN 1 AND 5)
    ) t

I there a way to combine those queries instead of having one query for each metric? The only difference is the WHERE clause:
        WHERE (...) AND (metric_1 BETWEEN 1 AND 5) /* metric_2, ...10 */

A: metric columns are redundant in survey table. we can create a new metric type column to differentiate multiple metrics and to normalize survey table. we can even do this normalization in inline view.
following sample query may explain this. it use SurveyNormalized inline view and it take aggregate group by metricType.
CREATE TABLE #Surveys(id int, VAR int, [weight] float, metric_1 int, metric_2 int, [week] int)

INSERT INTO #Surveys VALUES(1, 9, 0.56 , 4, 2, 8), (2, 3, 1, 3, 1, 7), (3, 7, 0.98 , 3, 5, 8)

SELECT
    weight, sample_size, detractor,
    (promoter * 100) / weight AS promoter_p,
    (promoter - detractor) * 100 / weight AS score,
    t.metricType
FROM
    (
        SELECT
            COUNT(id) AS sample_size,
            SUM(weight) [weight],
            SUM(CASE WHEN var BETWEEN 9 AND 10 THEN 1 END) AS promoter,
            SUM(CASE WHEN var BETWEEN 0 AND 6  THEN 2 END) AS detractor,
            MAX(week) wk,
            metricType
        FROM (
                SELECT id, var, weight, metric_1 AS metric, 'metric_1' AS metricType, week
                FROM #Surveys
                WHERE (var BETWEEN 0 AND 10) AND (metric_1 BETWEEN 1 AND 5)
                UNION
                SELECT id, var, weight, metric_2 AS metric, 'metric_2' AS metricType, week
                FROM #Surveys
                WHERE (var BETWEEN 0 AND 10) AND (metric_2 BETWEEN 1 AND 5)
            )SurveyNormalised
            GROUP BY SurveyNormalised.metricType

    ) t

A: Another way to solve this:
WITH cte AS
  ( SELECT
        q.query_id,
        COUNT(d.id) AS sample_size,
        SUM(d.weight) AS weight,
        SUM(CASE WHEN d.var BETWEEN 9 AND 10 THEN d.pond END) AS promoter,
        SUM(CASE WHEN d.var BETWEEN 0 AND 6  THEN d.pond END) AS detractor,
        MAX(d.week) AS max_week
    FROM
        generate_series(1, 3)      -- change 3 to the number of different queries
          AS q (query_id)
      CROSS JOIN
        surveys AS s
      LEFT JOIN LATERAL
        ( SELECT 1, s.*
          WHERE (metric_1 BETWEEN 1 AND 5)  --- query 1
        UNION ALL
          SELECT 2, s.*
          WHERE (metric_2 BETWEEN 3 AND 7)  --- query 2
        UNION ALL
          SELECT 3, s.*
          WHERE (metric_3 BETWEEN 6 AND 9)  --- query 3
        --- etc
        )
          AS d (query_id, id, var, weight, metric_1, metric_2, week)
        ON d.query_id = q.query_id
    WHERE
        (s.var BETWEEN 0 AND 10)
    GROUP BY
        q.query_id
    )
SELECT
    query_id,
    weight, sample_size, detractor, max_week,
    (promoter * 100) / weight AS promoter_p,
    (promoter - detractor) * 100 / weight AS score
FROM
    cte
ORDER BY
    query_id ;


text:
Kurkino () is the name of several inhabited localities in Russia.

Urban localities
Kurkino, Tula Oblast, an urban-type settlement in Kurkinsky District of Tula Oblast

Rural localities
Kurkino, Kaluga Oblast, a village in Yukhnovsky District of Kaluga Oblast
Kurkino, Krasnoyarsk Krai, a village in Cheremushinsky Selsoviet of Karatuzsky District of Krasnoyarsk Krai
Kurkino, Kursk Oblast, a selo in Kamyshinsky Selsoviet of Kursky District of Kursk Oblast
Kurkino, Moscow Oblast, a village in Seredinskoye Rural Settlement of Shakhovskoy District of Moscow Oblast
Kurkino, Pskov Oblast, a village in Kunyinsky District of Pskov Oblast
Kurkino, Ryazan Oblast, a village in Iskrovsky Rural Okrug of Ryazansky District of Ryazan Oblast
Kurkino, Smolensk Oblast, a village in Novoduginskoye Rural Settlement of Novoduginsky District of Smolensk Oblast
Kurkino, Republic of Tatarstan, a village in Kukmorsky District of the Republic of Tatarstan
Kurkino, Tver Oblast, a village in Kalininsky District of Tver Oblast
Kurkino, Nefedovsky Selsoviet, Vologodsky District, Vologda Oblast, a village in Nefedovsky Selsoviet of Vologodsky District of Vologda Oblast
Kurkino, Oktyabrsky Selsoviet, Vologodsky District, Vologda Oblast, a selo in Oktyabrsky Selsoviet of Vologodsky District of Vologda Oblast

redpajama_set_name: RedPajamaWikipedia


text:
Q: Stored Procedure with multi value parameter I am trying to create a stored procedure which will accept multi value parameter for the where condition like below
ALTER PROC spGetExpectedSalesOrActiveSales @Divisions NVARCHAR(200), @var1 int
AS
BEGIN
    SELECT *
    FROM ABC
    WHERE x = '0' and z=@var1
        AND y IN (@Divisions)

END
exec spGetExpectedSalesOrActiveSales 'EE, MM' ,1

In-place of @Divisions if I use 'ABC' or 'ABC,XYZ' then its working good and
when I am passing a single value through the API for the @Divisions then its executing that but when passing more than one value like 'ABC, XYX' then its simply displaying no records.
The values I am passing through my API, its an array of string.
I am not taking the @Divisions values from a query but from the API.

A: SQL Server does not support arrays. There are multiple ways to fake arrays, however, if you really must.

A: You are trying to fetch query like this
SELECT *
    FROM ABC
    WHERE x = '0'
        AND y IN ('ABC,XYZ')

And obviously you can't do select like above.
In this case you can go in 2 ways. One is Dynamic coding and another one is with User defind function.
Dynamic:
CREATE PROC spGetExpectedSalesOrActiveSales @Divisions NVARCHAR(200), @var1 int
AS
BEGIN
    DECLARE @QRY VARCHAR(MAX);
    SELECT @DIVISIONS = REPLACE (@DIVISIONS,' ','');
    SELECT  @DIVISIONS=''''+REPLACE(@DIVISIONS,',',''',''')+''''

    SELECT @QRY  = '
    SELECT *
    FROM ABC
    WHERE x = ''0'' AND z='+@var1
        +'AND y IN ('+@DIVISIONS+')'

    --PRINT @QRY
    EXEC (@QRY)
END

A: there is something like Table Valued Parameters https://www.mssqltips.com/sqlservertip/2112/table-value-parameters-in-sql-server-2008-and-net-c/
It allows passing array of elements to stored procedures.
DataTable _dt;
// create data table to insert items
_dt = new DataTable("Items");
_dt.Columns.Add("ItemID", typeof(string));
_dt.Columns.Add("Name", typeof(string));
_dt.Rows.Add(4, "SuperBowl 9 Hat");
_dt.Rows.Add(5, "SuperBowl 10 T-Shirt");
_dt.Rows.Add(6, "SuperBowl 13 Towel");
_dt.Rows.Add(7, "SuperBowl 14 Helmet");

then in stored procedure you have something like this
CREATE PROCEDURE [dbo].[InsertItemsTVP] @ItemTVP TVP_Items READONLY
AS
BEGIN
 INSERT INTO dbo.Items (ItemID, Name)
 SELECT ItemID, Name
 FROM @ItemTVP
END
GO

read about performace because sometimes its a lot faster using comma separated string than TVP


Borealis plans to invest EUR 80 million in Linz location.
Borealis, a leading provider of innovative solutions in the fields of polyolefins, base chemicals and fertilizers, announces a new round of investments in its melamine and fertilizer production facilities in Linz, Austria. The heart of the so-called "Linz 2020" programme is a EUR 80 million investment package to boost the overall long-term competitiveness of the Linz location. Programme goals include improving plant efficiency and achieving better environmental performance by installing and implementing state-of-the art equipment and processes.
This latest round of investment follows on the heels of the "Linz Fitness" programme, in which EUR 145 million were invested in plant modernisation between the years 2010 and 2014. Building on these modernisation measures, a variety of additional upgrades are scheduled for completion by 2019. Most are infrastructure-related and will be carried out in the Linz Chemical Park, such as modernisation of the facility's railway, including railway control systems, and installation of state-of-the-art lighting. Utility upgrades to the cooling water system and pipe racks will ensure reliable service in the long term to both Borealis and its Linz Chemical Park site partners.
The renovation and upgrade of Borealis' own fertilizer storage facilities includes the replacement of ageing equipment that, among other things, will help further reduce dust emissions and enhance overall energy efficiency.
The largest Borealis fertilizer production facility in Europe is in Linz, which is also the centre of melamine production. In addition, around 50,000 tonnes of melamine per year are produced at two plants located in the Linz Chemical Park. Major base chemicals produced here include ammonia, nitric acid and urea as well as NPK (nitrogen, phosphorous and potassium) and CAN (calcium ammonium nitrate) fertilizers.


text:
Hezbollah leader says Soleimani killing marks new phase for region
Lebanese Hezbollah Secretary-General Hassan Nasrallah. (Screen grab)
Reuters, Beirut
Published: 05 January ,2020: 12:00 AM GST Updated: 20 May ,2020: 10:56 AM GST
Lebanese Hezbollah Secretary-General Hassan Nasrallah said on Sunday the killing of Iranian Major General Qassem Soleimani marked a new phase in the history of the Middle East.
Referring to the date of Soleimani's killing in a US air strike in Baghdad, Nasrallah said it was a "date separating two phases in the region ... it is the start of a new phase and new history not just for Iran or Iraq but the whole region."
Nasrallah, speaking in a televised speech marking Soleimani's death in a targeted US airstrike, said responding to the killing was not only Iran's responsibility but the responsibility of its allies in the region too.
He said the US military in the Middle East would pay the price for the killing of Soleimani, and US soldiers and officers would return home in coffins.
Nasrallah said attacks on the US military presence in the Middle East would be "fair punishment" for the killing of Soleimani, listing US bases, naval ships and military personnel.
RELATED: Khamenei adviser tells CNN Iran's response will be a military one
Founded by Iran's Revolutionary Guards in 1982, Hezbollah is a critical part of an Iranian-backed regional military alliance.
The United States has designated Hezbollah as a terrorist group.
"When the coffins of American soldiers and officers begin to be transported ... to the United States, (US President Donald) Trump and his administration will realize that they have really lost the region and will lose the elections," Nasrallah said, referring to the 2020 US presidential election.
Nasrallah said such an approach would force the United States to withdraw from the Middle East "humiliated, defeated and in terror ... as they left in the past."
Nasrallah also said that US civilians in the region "should not be touched" because this would serve Trump's agenda.
Hezbollah leader says he warned Soleimani of assassination threat
Hassan Nasrallah said he had warned Soleimani of the risk of assassination and met him in the Lebanese capital Beirut on New Year's Day before he was killed in the US attack in Baghdad.
In his speech commemorating Soleimani, Nasrallah said he had told Iran's pre-eminent military commander some time ago of concern for his life.
"I told him ... there is great focus on you in the American media, press and magazines and they're printing your pictures on the front page as 'the irreplaceable general,' this is media and political priming for your assassination," Nasrallah said.
"Of course he laughed and told me, I hope so, pray for me."
Nasrallah said Soleimani had visited him in Beirut on January 1. "He just said 'I've come to say hello and have a chat,' and I told him this was a beautiful start to the Gregorian new year," Nasrallah said.
The 62-year-old major general Soleimani was regarded as the second-most powerful figure in Iran after Supreme Leader Ayatollah Ali Khamenei.
Hezbollah will avenge father's death: Soleimani's daughter
The daughter of Iran's General Qassem Soleimani said on Sunday that she knows that Hezbollah leader Hassan Nasrallah will avenge the death of ... Middle East
US carried out 'very stupid act' by killing Soleimani: Hezbollah deputy leader
The deputy leader of Lebanese Hezbollah says the United States carried out a "very stupid act" by killing Iran's General Qassem ... Middle East
Lebanese Hezbollah deputy chief in Tehran to pay respects after Soleimani killed
Lebanese Hezbollah's Deputy Secretary-General, Naim Qassem, arrived at slain IRGC commander Qassem Soleimani's house in Tehran on Sunday ... Middle East
'Axis of resistance' response to Soleimani killing will be decisive: Hezbollah official
A Lebanese Hezbollah official said the response of the Iran-backed "axis of resistance" to the killing of Iran's military commander Qassem ... Middle East