Location: PHPKode > projects > Homeless Mangement Information System > hmis/include/services_taxonomy_insert.inc
<?php
echo 'Inserting services...';
run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 1,'B','Basic Needs','Programs that furnish survival level resources including food, housing, material goods, transportation and temporary financial assistance for low and fixed-income, indigent or elderly people or people with disabilities who are otherwise unable to adequately provide for themselves and their families. Also included are related services that are available to the community at large.','Basic Needs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 2,'BD','Food','Programs that seek to meet the basic nutritional needs of  the community by providing access to free or low cost food products.','Food',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 3,'BD-150','Community Wide Food Storage Facilities','Programs that provide access to community freezers, meat lockers or other storage facilities for individuals who do not have access to refrigerators, freezers or other private means of storage or who do not have enough space at home to store food purchased in bulk.','Community Wide Food Storage Facilities',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 4,'BD-180','Emergency Food','Programs that provide a limited amount of food for individuals or families during times of personal crisis, or for people who have no food or cannot afford to purchase food at retail costs.','Emergency Food',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 5,'BD-180.100','Brown Bag Programs','Programs offered by senior centers or other community organizations outside the food pantry network that pack shopping bags with a supply of nutritional donated and surplus food for distribution to low-income individuals or families or older adults to supplement their meals at home.','Brown Bag Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 6,'BD-180.200','Food Pantries','Programs that acquire food products through donations, canned food drives, food bank programs or direct purchase and distribute the food to people who are in emergency situations.','Food Pantries',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 7,'BD-180.200-20','Food Lines','Emergency food pantries that provide a limited number of boxes or bags of food on a first come, first served basis for eligible people who line up on a designated date and time to receive service.','Food Lines',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 8,'BD-180.200-62','Occasional Emergency Food Assistance','Food pantries that provide a box or bag of groceries on a one-time only or other limited basis for people who are unable to provide food for themselves or their families. Included are programs that provide enough food for an entire balanced meal or series of meals and those that provide a supplemental supply of groceries.','Occasional Emergency Food Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 9,'BD-180.200-64','Ongoing Emergency Food Assistance','Programs that provide an ongoing supply of groceries, usually once a month, for people whose income is not sufficient to meet their needs. Included are programs that provide enough food for an entire balanced meal or series of meals and those that provide a supplemental supply of groceries.','Ongoing Emergency Food Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 10,'BD-180.225','Food Vouchers','Programs that supply people who are in emergency situations with food coupons which can be exchanged in designated grocery stores and supermarkets for food products that have been approved by the issuing agency as nutritious.','Food Vouchers',0,1 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 11,'BD-180.250','Government Surplus Food Distribution Sites','Organizations that are authorized, on a periodic basis, to acquire targeted surplus commodities stockpiled by the federal government (the U.S.D.A) and distribute them to people who qualify for this service on the basis of income. Also available may be a distribution schedule and a listing of available commodities and distribution site locations.','Government Surplus Food Distribution Sites',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 12,'BD-180.800','Sack Lunches/Dinners','Programs that provide lunch or dinner in a small bag for people who would not otherwise have a meal. The program may target homeless, indigent or low-income people or other specific groups.','Sack Lunches/Dinners',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 13,'BD-180.820','Specialty Food Providers','Programs that provide necessary food items that are not regularly or even typically available through most food pantries for people who are in emergency situations and unable to purchase the items at retail prices or are unable to locate those items in their local stores due to shortages precipitated by a fire, flood, hurricane, earthquake, tornado or other disaster.','Specialty Food Providers',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 14,'BD-180.820-18','Drinking Water','Programs that provide bottled water or other sources of potable water for people who have no access to drinking water due to ruptured water mains, problems with water purification plants or other disruptions in the community water supply.','Drinking Water',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 15,'BD-180.820-20','Food Supplements','Programs that provide liquid nutrition supplements for older adults and/or people with disabilities who, for medical reasons, are unable to derive sufficient nutrients from a regular diet. Also included are programs that provide high calorie liquid supplements needed by cancer patients and others who have difficulty swallowing, digesting or keeping solid foods down.','Food Supplements',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 16,'BD-180.820-25','Formula/Baby Food','Programs that supply infant formula and/or baby food, usually in addition to other groceries.','Formula/Baby Food',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 17,'BD-180.820-33','Ice','Programs that supply ice during wide-spread power failures or other situations in which supplies are unavailable through ordinary means.','Ice',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 18,'BD-185','Emergency Food Clearinghouses','Programs that coordinate requests for emergency food assistance by screening individuals who apply using criteria established by the food pantries or other providers, maintaining lists of individuals who have been aided, and checking new applicants against the lists before referring them to a resource that can meet their needs.  Emergency food clearinghouses help to avoid duplication of service and maximize the availability of food resources while relieving the agencies of the task of handling requests directly.  Also included are programs that refer people needing food to an appropriate resource, but which are not the sole source for this information.','Emergency Food Clearinghouses',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 19,'BD-200','Food Banks','Nonprofit food clearinghouses that gather, sort, store and distribute to participating charitable agencies, surplus food products and edible but unmarketable food that has been acquired from grocery stores and other sources.','Food Banks',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 20,'BD-220','Food Gleaning Programs','Programs that obtain donated, unharvested crops for use by food banks, brown bag programs and other charitable food distribution programs from farmers whose fields have been professionally picked.','Food Gleaning Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 21,'BD-240','Food Outlets','Programs that supply consumers with food and other supermarket products at lower than retail prices.','Food Outlets',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 22,'BD-240.150','Community Supported Agriculture','Cooperative partnerships between local farmers and consumers that create economically stable farming operations, reconnect local residents with their local agricultural base, provide a guaranteed market for growers and ensure availability to consumers of freshly picked produce at a reasonable price. At the beginning of the growing season, consumers purchase a \"share\" of the season''s harvest. Revenue from the shares is used to purchase seeds and other supplies, pay for labor and equipment and cover other operating expenses. In return for their investment, each consumer receives a weekly supply, usually enough for a family of four, of fresh, often organic, fruits, vegetables and herbs. Flowers, meat, honey, eggs and dairy products may be available through some CSA programs.','Community Supported Agriculture',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 23,'BD-240.200','Farm Trails','Organizations composed of farmers in specific growing areas that sponsor the publication of maps which indicate the local farms that sell directly to individuals or community organizations at farm or roadside stands.','Farm Trails',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 24,'BD-240.225','Farmers Markets','Programs that enable farmers to gather in empty parking areas and sell freshly picked produce directly to consumers at lower than retail but higher than wholesale prices.','Farmers Markets',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 25,'BD-240.250','Food Cooperatives','Programs that allow groups of consumers to pool their grocery orders and purchase food in bulk directly from wholesalers at lower than retail prices. Also included are programs that allow people to volunteer a few hours of community service in exchange for discounts on groceries through designated food outlets, including cooperating markets, and programs that enable people to purchase a share of farm crops and receive produce during the growing season.  Some programs may accept food stamps.','Food Cooperatives',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 26,'BD-240.490','Markets Accepting EBT Cards','Supermarkets, grocery stores and other food outlets that are equipped to handle electronic benefits transfer (EBT) \"debit\" cards issued by the Food Stamps program.','Markets Accepting EBT Cards',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 27,'BD-240.500','Mini Markets','Programs, often operated in conjunction with senior centers, that make nutritious food and produce available to elderly or low-income individuals and families at lower than retail prices.','Mini Markets',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 28,'BD-240.700','Rent A Tree','Grower-sponsored programs that allow customers to pay a specified sum at the beginning of the season to reserve a fruit-bearing or syrup-producing tree. The grower cares for the tree through the season and notifies the customer when it is time to harvest the fruit or tap the sugar maple for syrup.','Rent A Tree',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 29,'BD-240.900','U-Pick Programs','Programs organized by growers that allow customers to come into their fields and pick or harvest the produce they want to purchase. Prices are lower than retail, and picking baskets and ladders are often provided.','U-Pick Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 30,'BD-260','Food Production','Programs that provide assistance for people who want to grow their own food or maintain their own gardens on a private basis; or which offer information, technical assistance and support for individuals who have commercial establishments that are engaged in the production of crops, plants, vines or trees;  raising livestock, poultry or other small farm animals; beekeeping; aquaculture projects; or other similar food production ventures.','Food Production',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 31,'BD-260.030','Agricultural Economics','Programs that are responsible for assuring the economic viability of establishments in the agricultural sector. Services may include agricultural loans and loan guarantees, financial assistance in times of drought or other disasters affecting agricultural income, and agricultural policy setting and regulatory assistance to assure a steady, stable market for agricultural products.','Agricultural Economics',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 32,'BD-260.030-03','Agricultural Loans','Programs that provide venture capital, loans or grants or other forms of financial support for individuals or groups who want to establish or expand a farming or ranching enterprise, upgrade equipment or purchase supplies.','Agricultural Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 33,'BD-260.030-06','Agricultural Marketing Information','Programs that provide price, demand, movement, volume and quality information regarding major agricultural commodities.','Agricultural Marketing Information',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 34,'BD-260.030-09','Agricultural Stabilization/Conservation','Programs that are responsible for ensuring that there is a steady market for farm products and stability in commodity prices and supplies. The objective of the program is to ensure that there is an adequate but not overabundant supply of wheat, corn, cotton, soybeans, crude pine gum, peanuts, rice, tobacco, milk, wool, mohair, tung nuts, barley, oats, sugar beets, sorghum, rye, honey and other targeted commodities; and that farmers and other producers of these commodities receive a return that is equal to or more than a specified target price. Services take the form of loans; purchase of commodities from farmers when there is a threatened glut; deficiency payments to farmers when prices fall below the target levels; and acreage allotments for specified crops, set-asides and marketing quotas to ensure that supplies meet, but do not exceed, demands.','Agricultural Stabilization/Conservation',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 35,'BD-260.030-13','Crop Disaster Financial Aid Programs','Programs that provide disaster assistance to farmers and others who suffer crop losses because of adverse weather conditions, insect infestations, plant diseases or other natural events; or who need financial assistance to perform emergency conservation measures to control wind erosion on farmlands, to rehabilitate farmlands damaged by wind erosion, floods, hurricanes, or other natural disasters or to carry out emergency water conservation or water enhancing measures during periods of severe drought.','Crop Disaster Financial Aid Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 36,'BD-260.030-15','Crop Insurance','A program available through the U.S. Department of Agriculture (USDA) which enables farmers to purchase insurance which protects them from financial loss due to the destruction of specified agricultural products as the result of rain, hail and other destructive natural forces.  Federal crop insurance does not cover losses that are the result of negligence or failure to observe good farming practices.','Crop Insurance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 37,'BD-260.030-20','Farmers Cooperative Purchasing Programs','Programs that allow farmers or ranchers to make collective arrangements to grade, market and ship their produce, livestock or other products and/or to make group purchases of materials and supplies as a means of obtaining better prices.','Farmers Cooperative Purchasing Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 38,'BD-260.030-90','USDA Dairy Indemnity Program','A program available through the U.S. Department of Agriculture (USDA) that protects dairy farmers and manufacturers of dairy products who, through no fault of their own, are directed to remove their milk or dairy products from commercial markets because of contamination from pesticides which have been approved for use by the federal government. Dairy farmers can also be indemnified because of contamination with chemicals or toxic substances, nuclear radiation or fallout.','USDA Dairy Indemnity Program',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 39,'BD-260.050','Agricultural Support Services','Programs that provide information, technical assistance and support regarding the planting, nurturing, protection, harvesting, marketing and utilization of agricultural products for individuals who maintain ranches, farms, orchards, greenhouses, nurseries or other agricultural establishments on a commercial basis.','Agricultural Support Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 40,'BD-260.050-02','Agricultural Pest/Disease Control Assistance','Programs that provide information, technical assistance and support to help agricultural establishments eradicate and/or control detrimental insects, mites, weeds and other pests or pathogens which cause plant disease using natural and/or chemical means.','Agricultural Pest/Disease Control Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 41,'BD-260.050-04','Agricultural Pollution Prevention/Mitigation Assistance','Programs that provide information, technical assistance and support to help agricultural establishments comply with regulations for the control of farming wastes including runoff and leaching of pesticides and fertilizers, erosion and dust from plowing; and improper disposal of animal manure and carcasses, crop residues and debris. Other contaminants may include growth regulating chemicals, mulching materials, pathogenic microorganisms, heavy metals, salts from deicing operations on roadways and allergens.','Agricultural Pollution Prevention/Mitigation Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 42,'BD-260.050-06','Agricultural Waste Management','Programs that provide information, technical assistance and support which help agricultural establishments collect, store, move, and dispose of animal, plant and other agricultural waste; and/or develop products, including biofuels, using waste materials.','Agricultural Waste Management',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 43,'BD-260.050-08','Agricultural Water Management','Programs that provide information, technical assistance and support regarding the availability and responsible use of water resources by agricultural establishments through the capture, storage and distribution of reclaimable water often lost to evaporation, seepage and runoff; the use of efficient irrigation and drainage systems; and other similar strategies. Also included are programs that provide irrigation systems for private individuals or commercial establishments or which offer or arrange for access to water for irrigation purposes.','Agricultural Water Management',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 44,'BD-260.050-10','Animal Husbandry Programs','Programs that provide information, technical assistance and support regarding the selection, breeding, care and marketing of livestock for individuals or commercial establishments including farms, ranches, dairies, stockyards and feedlots that are engaged in keeping, grazing, feeding and/or selling cattle, hogs, sheep, goats and other small farm animals.','Animal Husbandry Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 45,'BD-260.050-14','Aquaculture Support Services','Programs that provide information, technical assistance and support regarding the selection, culturing, propagation, harvesting and marketing of fresh and saltwater fish, shellfish and marine plants for individuals who are managing aquatic farms or other aquaculture projects. Aquatic farming enterprises generally focus on oysters, mussels, clams, shrimp and salmon which are grown in ponds, tanks, or cages on protected beds.','Aquaculture Support Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 46,'BD-260.050-16','Beekeeping Support Services','Programs that provide information, technical assistance and support for beekeeping establishments which may collect and gather honey and/or sell queen bees, packages of bees, royal jelly, bees'' wax, propolis, venom and/or other bee products.','Beekeeping Support Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 47,'BD-260.050-18','Crop Production Support','Programs that provide information, technical assistance and support regarding the cultivation and harvesting of oilseed, grain, fruit, vegetables, nuts, mushrooms, sugarcane, hay and other feed, and other crops for individuals who operate farms, orchards, groves, greenhouses or other agricultural establishments.','Crop Production Support',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 48,'BD-260.050-25','Farm/Ranch Management Support','Programs that provide information, technical assistance and support regarding the business side of managing a farm, ranch or other agricultural enterprise. Included is assistance in business management, accounting, taxation, capitalization, purchasing, marketing, planning, human resources management, government programs and regulations and other similar areas.','Farm/Ranch Management Support',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 49,'BD-260.050-63','Organic Farming Assistance','Programs that provide information, technical assistance and support regarding the development and maintenance of gardens in which fruit, vegetables and other produce are grown \"naturally\" without the use of chemically-formulated fertilizers or pesticides.','Organic Farming Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 50,'BD-260.050-65','Pollination Services','Beekeepers who are willing to make their hives available to pollinate fields, orchards and groves in areas where wild bees are unavailable.','Pollination Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 51,'BD-260.050-70','Poultry Farming Support','Programs that provide information, technical assistance and support regarding the selection, breeding, care and marketing of poultry for individuals or commercial establishments such as egg production facilities and hatcheries that are engaged in keeping, feeding and/or selling chickens, turkeys, ducks, geese and other poultry and/or their eggs.','Poultry Farming Support',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 52,'BD-260.050-80','Sustainable Agriculture Programs','Programs that provide information, technical assistance and support for farmers who want to implement an integrated system of plant and animal production practices that will meet the basic needs of the current population for food, feed and other fiber products and sustain the economic viability of farming operations while preserving nonrenewable resources and the fertility of farmlands enabling future generations to flourish. Sustainable farming practices include crop rotation; alternative crops and livestock; low input production for local markets; targeted marketing of organically produced meats, vegetables and grains; community-supported agriculture; free range raising of poultry; and nutrient and pest management practices that reduce the use or toxic pesticides and fertilizers and rely instead on resistant cultivars, timing of planting, use of compost and mulch, planting of cover crops, biological pest control and other alternatives.','Sustainable Agriculture Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 53,'BD-260.150','Community Gardening','Programs that provide land on which individuals can grow produce and other plants.','Community Gardening',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 54,'BD-260.300','Home Gardening Assistance','Programs that provide information, technical assistance and support for individuals who want to grow their own produce in a home garden setting.  Services may include consultation regarding planting times, soil care and preparation, produce selection and pest control; provision of materials such as seeds and gardening tools; and information and guidance regarding harvesting.','Home Gardening Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 55,'BD-500','Meals','Programs that provide supplementary nutrition, which may include hot meals, snacks or milk, for low-income, indigent or elderly individuals, low-income children and/or people with disabilities.','Meals',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 56,'BD-500.020','After School Meal Programs','Programs that provide hot, nutritious evening meals for disadvantaged children who live in low-income neighborhoods. The meals are often sponsored by local food banks that are part of the Second Harvest network; are served in a safe, accessible, convenient environment; and may be offered in combination with educational, recreational and social activities that draw upon existing community programs.','After School Meal Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 57,'BD-500.145','Child and Adult Care Food Programs','A program that provides supplementary nutrition in the form of healthy meals and snacks for preschool and school-age children and adults receiving day care. Licensed child care centers, Head Start programs, family day care homes, adult day care centers and homeless shelters serving families are eligible to participate and are reimbursed for a portion of the meals served. In the United States, the program is administered at the federal level by the Food and Nutrition Service (FNS) of the U.S. Department of Agriculture.','Child and Adult Care Food Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 58,'BD-500.150','Congregate Meals','Programs that provide hot meals on a regular basis for people who are elderly, adults with disabilities or other targeted populations who may be at risk for nutritional deficits without assistance and who can profit from an opportunity to socialize with others.  Congregate meals are often combined with recreational, educational and social activities.','Congregate Meals',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 59,'BD-500.350','Home Delivered Meals','Programs that prepare and deliver regular meals to older adults and people with disabilities who are unable to shop and/or prepare the food for themselves or travel to a site where a meal is being served.','Home Delivered Meals',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 60,'BD-500.450','Low Cost Meals','Restaurants, cafeterias and other eating establishments operated by hospitals, senior centers or other organizations or functioning independently which provide reduced-cost meals for low-income people, older adults or other targeted individuals.','Low Cost Meals',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 61,'BD-500.500','Meal Vouchers','Programs that provide vouchers that people can exchange for a meal in a restaurant with which the referring agency has a prior agreement.','Meal Vouchers',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 62,'BD-500.510','Milk Programs','A federally-funded program that provides supplementary nutrition in the form of free milk for income-eligible students who are enrolled in public and private, nonprofit schools of high school grades or lower, or in nonprofit nursery schools, child care centers, summer camps and similar organizations charged with the care and instruction of children. Participating agencies are reimbursed for the milk served.','Milk Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 63,'BD-500.800','School Breakfasts','A federally-funded program that provides supplementary nutrition in the form of a free or reduced-cost meal at the beginning of the school day for income-eligible school age children. Public and private, nonprofit schools participating in the program are reimbursed for the breakfasts served.','School Breakfasts',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 64,'BD-500.820','School Lunches','A federally-funded program that provides supplementary nutrition in the form of a free or reduced-cost meal at noon time for income-eligible students who are unable to pay the full cost. Public and private, nonprofit schools participating in the program are reimbursed for the lunches served.','School Lunches',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 65,'BD-500.830','Soup Kitchens','Programs offered by churches, restaurants and other organizations that provide meals in a central location for indigent people who are hungry.  The food may be distributed to people who line up for the meal or may be served to people seated in a dining hall setting, and participants rarely need to establish eligibility for the service.','Soup Kitchens',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 66,'BD-500.850','Summer Food Service Programs','A federally-funded program that operates during the summer when school is not in session which provides congregate nutritional meals (breakfasts, snacks, lunches and/or dinners) for children and youth age eighteen and younger who live in designated low-income areas.','Summer Food Service Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 67,'BH','Housing/Shelter','Programs that seek to meet the basic shelter needs of the community by providing temporary shelter for people who are in emergency situations, home improvement programs, housing location assistance and a variety of housing alternatives.','Housing/Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 68,'BH-180','Emergency Shelter','Programs that provide a temporary place to stay for newcomers, travelers, people who are in crisis, or homeless individuals in the community.','Emergency Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 69,'BH-180.150','Crisis Shelter','Programs that provide a temporary place to stay for people who are unable to return to their own homes due to sexual assault, domestic violence or other problems.','Crisis Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 70,'BH-180.150-05','Crisis Nurseries','Programs that provide temporary shelter for infants and young children who are at risk for or who have experienced child abuse or neglect in the home.','Crisis Nurseries',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 71,'BH-180.150-10','Domestic Violence Shelter','Programs that provide temporary emergency shelter for women who have experienced domestic violence, and for their children. Such facilities usually provide in-house individual, group and family counseling and the full range of secondary services related to domestic violence including referral to appropriate resources. Also included are similar facilities for battered men and those that can accommodate both men and women.','Domestic Violence Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 72,'BH-180.150-14','Elder Abuse Shelter','Programs that provide a safe, secure shelter environment for older adults who meet age requirements and are experiencing physical, psychological/emotional, financial or sexual abuse. Services generally include short-term housing, crisis intervention, support, advocacy, referrals and the necessities of daily living. Elder abuse shelters usually accept both men and women.','Elder Abuse Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 73,'BH-180.150-20','Family Crisis Shelter','Programs that provide temporary emergency shelter for certain members of or entire families who are involved in or at risk for child abuse or neglect. Such facilities usually provide in-house individual, group and family counseling and the full range of other secondary services that are related to child abuse including referral to appropriate resources.','Family Crisis Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 74,'BH-180.150-70','Runaway/Youth Shelter','Programs that provide temporary emergency shelter for children and youth who have run away from or have been pushed out of their homes or who are acting out and at risk for abuse pending return to their own families or suitable alternative placement. Such facilities usually provide in-house individual, group and family counseling and the full range of other secondary services related to runaways including referral to appropriate resources.','Runaway/Youth Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 75,'BH-180.150-75','Safe Houses','Networks of people who are willing to provide short or long-term shelter in private homes, churches or other facilities for battered women, sexual assault survivors, undocumented people and others who are fleeing a dangerous or threatening situation and who have no other safe alternatives. These homes or facilities may also provide for the basic subsistence needs of residents including food, clothing and, in some cases, a variety of social services. Also included are organizations that refer people who are in need of this service to the nearest safe house.','Safe Houses',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 76,'BH-180.150-80','Sexual Assault Shelter','Programs that provide temporary emergency shelter for women who have been victimized by rape and/or other forms of sexual assault. Such facilities usually provide in-house individual, group and significant other counseling and the full range of other secondary services related to sexual assault including referral to appropriate resources.','Sexual Assault Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 77,'BH-180.350','Homeless Drop In Centers','Programs that provide a center where homeless people can spend time during the day. The center may provide counseling and/or medication monitoring on a formal or informal basis; facilities for showering, shaving, napping, laundering clothes, making necessary telephone calls or attending to other personal needs; and/or other basic supportive services. Some centers may also provide food or facilities for cooking.','Homeless Drop In Centers',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 78,'BH-180.850','Homeless Shelter','Programs that provide a temporary place to stay for people who have no permanent housing.','Homeless Shelter',0,1 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 79,'BH-180.850-10','Bad Weather Shelter','Programs that provide a temporary place to stay or vouchers that can be exchanged for shelter in a hotel or motel for homeless people who have no other resources when the weather becomes cold, wet, windy or otherwise inclement enough to constitute a threat to their physical well-being if they remain outdoors. Also included are programs that provide air conditioned facilities which are open to the public during extremely hot weather.','Bad Weather Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 80,'BH-180.850-15','Community Shelters','Programs, usually sponsored by community organizations or coalitions, that provide temporary shelter (usually three days to two weeks) for  homeless people. Most community shelters offer support services which may include counseling, advocacy, referrals and help with future plans; and enforce house rules including curfews and mandatory household chores. Participation in religious activities is either optional or not a part of the program.','Community Shelters',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 81,'BH-180.850-17','Day Shelters','Programs that provide a temporary place for homeless people who work second or third shifts to sleep during the day until they are able to find permanent housing.','Day Shelters',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 82,'BH-180.850-18','Environmental Hazards Shelter','Programs that provide a temporary place to stay or vouchers that can be exchanged for shelter in a hotel or motel for homeless people who have no other resources when it becomes unsafe to remain in the open because of hazardous chemical leaks or spills, malathion spraying or other activities which affect the environment.','Environmental Hazards Shelter',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 83,'BH-180.850-50','Missions','Programs, usually with religious affiliations, that provide temporary shelter for homeless people in the community.  Most missions have minimal support services and strictly enforced house rules including curfews, mandatory attendance at religious services, and required participation in daily housework or other assigned chores.','Missions',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 84,'BH-180.850-53','Motel Vouchers','Programs that provide homeless people in the community with a temporary place to stay (usually one to three nights) utilizing a hotel or motel with which the referring agency has a prior agreement.','Motel Vouchers',0,1 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 85,'BH-180.850-90','Urban Campsites','Programs that provide temporary shelter for homeless people in outdoor locations which are equipped with tents or canopies, cots, and sanitation and cooking facilities; and which may assist residents who need linkage with community social service agencies.','Urban Campsites',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 86,'BH-180.855','Homeless Shelter Pickup Sites','Community service centers, parking lots and other areas where homeless people have been instructed to gather to await prearranged transportation to the shelter that serves their area.','Homeless Shelter Pickup Sites',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 87,'BH-180.900','Postshelter Housing','Programs that make affordable rental housing available to women who are coming directly out of a domestic violence shelter or other crisis shelter, often in apartment complexes owned by the shelter. Counseling and other support services are usually available to residents. The purpose of postshelter housing programs is to provide a support system which facilitates the individual''s eventual return to independent living.','Postshelter Housing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 88,'BH-180.950','Transitional Shelter','Programs that provide extended shelter (longer than two weeks but typically sixty days or more) for homeless people who indicate a willingness to participate in developing and implementing a case plan which has as a goal eventual independent living.','Transitional Housing',0,1 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 89,'BH-185','Emergency Shelter Clearinghouses','Programs that coordinate requests for emergency shelter by screening homeless individuals who apply using criteria established by the shelters, maintaining lists of individuals who have been aided, and checking new applicants against the lists before referring them to a resource that can meet their needs. Emergency shelter clearinghouses help to avoid duplication of service and maximize the availability of shelter resources while relieving the agencies of the task of handling requests directly. Also included are programs that refer people needing shelter to an appropriate resource, but which are not the sole source for this information.','Emergency Shelter Clearinghouses',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 90,'BH-300','Home Improvement/Accessibility','Programs that pay for or provide assistance in the form of consultation, labor and/or supplies for people who need to upgrade their homes to make them attractive, safe, accessible and energy-efficient.','Home Improvement/Accessibility',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 91,'BH-300.180','Energy Conservation Improvements','Programs that provide assistance in the form of labor and supplies, cash or tax rebates or consultation services for homeowners who want to make home improvements that are designed to reduce energy consumption.','Energy Conservation Improvements',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 92,'BH-300.180-18','Energy Conservation Rebates','Programs that provide cash or tax rebates for homeowners who have made approved home improvements that will enable them to reduce energy consumption.','Energy Conservation Rebates',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 93,'BH-300.180-95','Weatherization Programs','Programs that provide assistance in the form of labor and supplies to help people who qualify for the service on the basis of income, age or disability improve the energy efficiency of their homes and protect them from the elements. The program provides ceiling insulation, attic venting, double glazed windows, weather-stripping, minor housing envelope repairs, low-flow showerheads, evaporative cooler vent covers, water heater blankets, pipe wrap, duct wrap, switch and outlet gaskets, caulking, and other related energy conservation measures.','Weatherization Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 94,'BH-300.350','Home Barrier Evaluation/Removal','Programs that pay for or provide assistance in the form of labor and supplies for people with disabilities who need to install ramps, elevators, stair glides or lifts; widen doorways; install grab bars in showers and bathrooms; lower kitchen and other cabinets; or make other modifications in their homes or apartments to make them accessible. Also included are programs that assess the accessibility of homes and apartments of people who have disabilities and make recommendations regarding necessary modifications.','Home Barrier Evaluation/Removal',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 95,'BH-300.350-10','Bathroom Modifications','Programs that pay for or provide assistance in the form of labor and supplies for people with disabilities who need to restructure their bathrooms in order to make bath, shower and toilet facilities accessible.','Bathroom Modifications',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 96,'BH-300.350-35','Kitchen Modifications','Programs that pay for or provide assistance in the form of labor and supplies for people with disabilities who need to restructure their kitchens to make cupboards, counters, appliances and other kitchen structures accessible.','Kitchen Modifications',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 97,'BH-300.350-70','Ramp Construction','Programs that pay for or provide assistance in the form of labor and supplies for people with disabilities who need to modify multilevel homes or homes that have entrances preceded by steps in order to make them accessible by installing sloping walkways which transcend the levels.','Ramp Construction',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 98,'BH-300.350-75','Residential Lift Equipment','Programs that pay for or provide stairlifts, vertical platform lifts, inclined lifts, residential elevators or other devices that help people with physical disabilities overcome barriers created by stairways in multi-story homes.','Residential Lift Equipment',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 99,'BH-300.355','Home Rehabilitation/Repair','Programs that provide assistance for people who need to make essential repairs to their homes in order to eliminate health or safety hazards.','Home Rehabilitation/Repair',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 100,'BH-300.355-35','Home Rehabilitation/Repair Grants','Programs that provide cash assistance for people who need to make essential repairs to their homes in order to eliminate health or safety hazards and who qualify for this service on the basis of income, age or disability.','Home Rehabilitation/Repair Grants',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 101,'BH-300.355-39','Home Rehabilitation/Repair Services','Programs that provide assistance in the form of labor and supplies for people who need to make essential repairs to their homes in order to eliminate health or safety hazards and who qualify for this service on the basis of income, age or disability. Typical services include repair or replacement of broken doors and windows; accessibility improvements such as ramps and hand railings; correction of safety hazards such as repairs to porches, steps and sidewalks; home security improvements such as fences, security doors and smoke detectors; habitability improvements such as replacement of sinks, toilets and floor tiles; and interior and exterior painting.','Home Rehabilitation/Repair Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 102,'BH-300.450','Landscaping Services','Programs that provide professional assistance for individuals who want to develop and implement plans for their property which propose alterations in land contours; selection and placement of decorative plants; development and placement of paths and other walkways and driveways; construction or installation of walls, decking, lighting, fencing and planters; and other aspects of landscaping.','Landscaping Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 103,'BH-300.460','Low Cost Building Materials/Supplies','Programs that provide access to building materials at below market costs. In many cases, the materials have been recovered from obsolete buildings by building deconstruction programs and made available for reuse by communities as an alternative to purchasing new materials.','Low Cost Building Materials/Supplies',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 104,'BH-330','Home Insurance','Programs that issue insurance policies to homeowners and renters to protect them from loss of property due to theft, destruction or the inability to meet mortgage obligations.','Home Insurance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 105,'BH-350','Home Loans','Programs that provide direct or guaranteed loans for the construction, purchase, rehabilitation or repair of a home.','Home Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 106,'BH-350.300','Home Barrier Removal Loans','Programs that provide loans to qualified people with disabilities who want to install ramps or elevators, widen doorways, install grab bars in showers and bathrooms, lower kitchen and other cabinets or make other modifications in their homes in order to make them more accessible.','Home Barrier Removal Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 107,'BH-350.320','Home Construction Loans','Programs that provide loans for people who want to build their own homes.','Home Construction Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 108,'BH-350.330','Home Improvement Loans','Programs that provide loans for income-eligible people who want to repair or modify their homes or mobile homes to make them energy-efficient, attractive, safe and free of health hazards. Also included are programs that help eligible individuals find home improvement loans.','Home Improvement Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 109,'BH-350.340','Home Purchase Loans','Programs that provide loans for people who want to buy their own homes.','Home Purchase Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 110,'BH-350.340-20','FHA Loans','A program under HUD''s Federal Housing Administration that insures housing loans made by private lending institutions to individuals and families who are earning a fairly good income but who cannot secure a loan on the conventional loan market.','FHA Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 111,'BH-350.340-25','First Time Buyer Home Loans','Programs that provide low interest down payment/closing costs loans and/or home purchase loans for people with low incomes who are purchasing a home or a condominium for the first time. These loan programs generally require that the property be used as a primary residence; allow lower down payments, assistance with closing costs and alternative credit; and often require participation in home buyer training classes.','First Time Buyer Home Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 112,'BH-350.340-45','Low Income Home Loans','Programs outside of HUD that provide direct or guaranteed housing loans for low-income families who do not have sufficient resources to purchase a home for themselves and who could not otherwise secure credit for this purpose.','Low Income Home Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 113,'BH-350.340-80','Special Purpose Home Loans','Programs that provide direct or guaranteed housing loans for special target groups, such as people who are Jewish, or which seek to attract people to certain communities, e.g., areas that have been identified for redevelopment or high-crime residential communities that want to attract resident police officers.','Special Purpose Home Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 114,'BH-350.340-85','USDA Rural Home Purchase Loan Programs','Programs offered by the United States Department of Agriculture''s Rural Housing Service that make home loans and loan guarantees available to rural families with an income below 80% of the median income level in the communities where they live who do not qualify for a conventional loan. Direct loans are made for the purchase of a new home or for new home construction including site preparation. The loan guarantee program guarantees loans made by private lenders. Under the terms of this program, families may borrow up to 100% of the appraised value of a home eliminating the need for a down payment, a barrier to home ownership frequently faced by families with low incomes.','USDA Rural Home Purchase Loan Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 115,'BH-350.340-90','Veteran Home Loans','Programs that assist veterans who want to purchase or construct a home by issuing GI loans which feature moderate interest rates, no down payment, a long repayment period, and the right to pay all or a portion or the loan in advance without penalty.','Veteran Home Loans',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 116,'BH-360','Homeowner Associations','Membership organizations composed of residents who live in condominium or townhouse complexes, mobile home parks or other planned communities who make decisions about association fees, regulations for the complex, expenditures for maintenance or improvements and other issues; hear resident complaints; and keep residents informed regarding the financial status and current projects of the association.','Homeowner Associations',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 117,'BH-370','Housing Counseling','Programs that provide comprehensive assistance for people who want to rent or purchase housing including information and guidance about buying and rental costs; how to select affordable housing that meets individual needs; and how to provide for insurance, maintenance and other requirements related to acquiring and paying for housing.','Housing Counseling',0,1 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 118,'BH-370.280','Home Building Information','Programs that provide technical assistance for people who want to build a home. Services may include information and guidance about selecting a site, obtaining financing, and designing and constructing the home.','Home Building Information',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 119,'BH-370.300','Homeowner/Home Purchase Counseling','Programs that provide assistance for people who want to purchase a home by offering information and advice about locating affordable housing that meets their needs, solving potential credit problems, analyzing specific home purchase offers, obtaining necessary financing, understanding the home loan process, and completing all paperwork to acquire and close the loan and complete the sale.','Homeowner/Home Purchase Counseling',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 120,'BH-370.305','Home Seller Counseling','Programs that provide assistance for people who want sell their homes or other property by offering information and advice about the pros and cons of using a broker or selling the property themselves, choosing a listing agent, making the home ready for sale (painting, cleaning, fix-ups, yard work), arranging for a home inspection, if required, evaluating comparable properties and current market conditions, establishing an asking price, listing and marketing the home, assessing offers and completing the closing process.','Home Seller Counseling',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 121,'BH-370.320','HUD Counseling Agencies','Agencies funded by the federal Office of Housing and Urban Development to provide prepurchase and mortgage default counseling, home equity conversion (reverse mortgage) counseling and information about the HUD rent assistance program for current and prospective purchasers and tenants.','HUD Counseling Agencies',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 122,'BH-370.650','Predatory Lending Awareness Programs','Programs that provide information and guidance which protect consumers who are considering homeownership, refinancing a mortgage loan or making major repairs from unscrupulous lending institutions which attempt to pressure them into signing loan agreements they cannot afford putting them at risk of losing their homes. Predatory lending tactics include high pressure sales techniques; misleading or fraudulent direct mail campaigns; failure to disclose unusually high interest rates, hidden transaction costs, excessive fees and punitive penalty clauses such as balloon payments; and loan agreements that are based on home equity rather than a realistic ability to repay. Predatory lenders frequently target the most vulnerable consumers including older adults, low-income individuals, minorities who are struggling financially, and people residing in communities underserved by traditional banking institutions.','Predatory Lending Awareness Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 123,'BH-390','Housing Search and Information','Programs that assist people to find and select available purchasable or rental housing, commercial lots and/or residential lots which meet their individual needs.','Housing Search and Information',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 124,'BH-390.300','Home Purchase Listings','Programs that maintain lists of available purchasable housing that people who are in search of housing can review.','Home Purchase Listings',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 125,'BH-390.305','Home Rental Listings','Programs that maintain lists of available rental housing for review by people who are in search of housing.','Home Rental Listings',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 126,'BH-390.305-10','Barrier Free Home Rental Listings','Programs that maintain lists of available wheelchair-accessible rental homes or apartments for review by people with disabilities in search of housing.','Barrier Free Home Rental Listings',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 127,'BH-390.305-18','Elderly/Disabled Home Rental Listings','Programs that maintain lists of available rental housing for review by older adults and/or people with disabilities. The listings may include HUD Supportive Housing for the Elderly (Section 202), HUD Supportive Housing for People with Disabilities (Section 811), HUD Congregate Housing (Section 236) or other housing options for independent living specifically for these populations.','Elderly/Disabled Home Rental Listings',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 128,'BH-390.305-25','Government Subsidized Private Rental Housing Listings','Programs that maintain lists of privately owned apartment buildings that offer housing units at below market rates because public funding was used to develop the complex.','Government Subsidized Private Rental Housing Listings',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 129,'BH-390.305-44','Low Cost Home Rental Listings','Programs that maintain lists of available low-cost apartments and houses for lease or rent for review by low-income people in search of housing.','Low Cost Home Rental Listings',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 130,'BH-390.305-75','Section 8/Rental Assistance Program Rental Listings','Programs that maintain lists of available rental housing that is owned or managed by individuals who have agreed to accept tenants who have Section 8 certificates from the local housing authority or finance agency, or rental assistance certificates from other federal, state or locally funded rental assistance programs.','Section 8/Rental Assistance Program Rental Listings',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 131,'BH-390.310','Housing Search Assistance','Programs that assign a staff member to assist people who are looking for housing to survey the available residences and to choose and obtain the most suitable option.','Housing Search Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 132,'BH-390.450','Lot Lists','Programs that maintain lists of publicly-owned vacant residential and commercial lots that are available for purchase.  Included are both buildable and nonbuildable lots.','Lot Lists',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 133,'BH-390.700','Relocation Assistance','Programs that provide assistance for people who have been displaced from their current homes or rental housing by urban renewal, redevelopment, conversion or demolition of condemned housing.','Relocation Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 134,'BH-390.700-75','Relocation Counseling','Programs that help people who have to relocate due to urban renewal, redevelopment, conversion, or demolition of condemned housing and who are eligible for relocation services evaluate their options.','Relocation Counseling',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 135,'BH-390.700-78','Relocation Services','Programs that provide cash payment or suitable alternative housing for individuals who have to  relocate due to urban renewal, redevelopment, conversion or demolition of condemned housing.','Relocation Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 136,'BH-390.750','Roommate/Housemate Matching Assistance','Programs that assist people who need a shared housing arrangement to identify others with whom they can share. Included are share-a-home programs which match homeowners and apartment dwellers who want to share their living facilities with compatible individuals who need a place to rent. Most share-a-home programs are for older adults and require that at least one of each matched pair qualify on this basis.','Roommate/Housemate Matching Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 137,'BH-500','Moving Assistance','Programs that provide assistance for people who are moving from one residence to another or who are moving their homes from one location to another.','Moving Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 138,'BH-500.300','House Moving Assistance','Programs that provide or pay for the removal of a person''s home from its current location and its relocation to a different piece of property.','House Moving Assistance',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 139,'BH-500.310','Household Goods Storage','Programs that provide facilities for the long or short-term warehousing of furniture and other personal belongings.','Household Goods Storage',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 140,'BH-500.500','Movers','Programs that provide assistance in the form of transportation and workers for people who need to move their furniture and personal possessions from one residence to another.','Movers',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 141,'BH-680','Real Estate Appraisals','Programs that inspect a person''s commercial, industrial or residential property focusing on its structure, condition and features; research the recent sales prices of comparable properties; and provide a written estimate of the property''s value. An appraisal is required as a part of the process of obtaining a real estate loan.','Real Estate Appraisals',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 142,'BH-690','Resident Services Coordination Programs','Housing authorities, housing developers or nonprofit organizations operating rental housing communities that offer the assistance of resident services coordinators to the families, older adults or people with disabilities who live there. Resident services coordinators assess the needs of tenants within the project; determine their eligibility for community services; identify affordable resources; link them with appropriate providers; educate residents regarding service availability, application procedures and client rights; and provide advocacy as needed. RSC programs may also establish volunteer support relationships with service organizations in the community; help residents build informal support networks with other residents, family and friends; provide training for residents in the obligations of tenancy; and educate residents regarding issues that will assist them to live as independently as possible.','Resident Services Coordination Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 143,'BH-700','Residential Housing Options','Temporary or long-term residential options for people who do not want to establish independent households or cannot afford to do so, and who are capable of maintaining independent living in a communal environment without any form of supervision, care or support.','Residential Housing Options',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 144,'BH-700.310','Housing Cooperatives','Apartment or condominium complexes or other housing facilities that are owned and administered collectively by the people who live there. New residents are screened and selected by current residents and all pay equal shares of the cost of housing. Some housing cooperatives set aside a certain number of units for low-income people.','Housing Cooperatives',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 145,'BH-700.500','Mobile Home Parks','Planned communities that provide space on a rental or purchase basis and access to utilities for individuals who own a mobile home unit and require a spot to park it. Some mobile home parks have homeowners associations which maintain common areas which may include recreational facilities. Some parks also rent mobile homes.','Mobile Home Parks',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 146,'BH-700.720','Rooming Houses','A low-cost housing option, usually but not necessarily short-term, which offers individual or shared rooms for men or women and which may include communal meals.','Rooming Houses',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 147,'BH-700.800','Shared Housing Facilities','Apartments or other living spaces that are designed to be shared by two or more unrelated individuals each of whom pays a portion of the cost.  Residents generally have their own private space such as a bedroom and share common areas.','Shared Housing Facilities',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 148,'BH-700.820','SRO Housing','Single room occupancy housing, which may include shared bath or kitchen facilities, that is owned and maintained by nonprofit and/or public organizations and is made available to eligible individuals at low rates. Also included are hotels that have been converted for use as single room occupancy housing.','SRO Housing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 149,'BH-700.900','Unsubsidized Rental Housing','Apartments and houses that are available at market rates to the general public for lease or rent.','Unsubsidized Rental Housing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 150,'BH-800','Subsidized Home Purchase','Programs that make housing more readily available to middle or low-income individuals and families by offering lower priced housing and/or affordable payment plans, or by arranging for interest or mortgage subsidies for people who qualify on the basis of income.','Subsidized Home Purchase',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 151,'BH-800.430','Low Cost Homes/Housing Units','Programs that offer homes or housing units at lower than current real estate prices for individuals and families who qualify on the basis of income.','Low Cost Homes/Housing Units',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 152,'BH-800.450','Low Cost Housing Auctions','Programs that increase the amount of affordable housing which is available in the community by auctioning government-owned, residential property (including condominiums, duplexes, single family dwellings and undeveloped real estate) to individuals and families who meet income and resource guidelines, and who certify that they intend to occupy the property as their principal residence following the date of closing. Property is acquired by the government through defaults on government-insured loans or failed savings and loan institutions. Included are organizations which administer the programs and/or provide information about the certification process or auctions.','Low Cost Housing Auctions',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 153,'BH-800.800','Sweat Equity Programs','Programs that make low-cost housing available to people who have very low incomes by organizing a group of volunteers to design and construct houses which are then sold at cost and at no interest to individuals who qualify by making a small down payment and investing a specified number of hours of \"sweat equity\" working on the project.','Sweat Equity Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 154,'BH-800.900','Urban Homesteading','A federal program administered by HUD that allows low-income families to purchase abandoned single-family dwellings owned or acquired by HUD through defaults on government insured mortgages and which have the potential to be repaired for habitation.  Qualified families may purchase the dwellings for a very low price (usually one dollar) but are required to make necessary repairs and live in the homes for three years before receiving full title to the property.  Also included are programs administered by other public entities.','Urban Homesteading',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 155,'BH-830','Subsidized Rental Housing','Programs that make rental housing more readily available to low-income individuals and families through federal and local housing programs.','Subsidized Rental Housing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 156,'BH-830.200','Government Subsidized Private Rental Housing','Privately owned rental housing that is made available to low-income individuals and families at reduced rates based on a contract between HUD or the state housing authority and the property owner. Subsidies are paid directly to the owner of the property who then rents units to income-eligible families and people who are elderly or have disabilities. Some privately owned rental units that were developed or improved with public funds are also required to rent a designated number of units at reduced prices until the federal or state loans are paid.','Government Subsidized Private Rental Housing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 157,'BH-830.300','Housing Authorities','City, county, or state/provincial housing offices that provide information about eligibility for and vacancies in the subsidized housing properties that are under their jurisdiction; and, in the U.S., accept Section 8 applications, provide Section 8 rental certificates and vouchers, make approved Section 8 rental payments and administer public housing communities. In certain rural areas, the housing finance agency may play this role.','Housing Authorities',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 158,'BH-830.300-30','Public Housing','Housing developments or scattered single family dwellings that are owned and managed by local housing authorities and rented to income and program eligible individuals and families, including older adults and people with disabilities. The units are governed by federal regulations which determine the application process, eligibility requirements, and tenant payment and lease obligations. Eligible households pay approximately 30% of their income for rent.','Public Housing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 159,'BH-830.300-80','Section 8 Rental Certificates','A federally assisted housing program administered by local housing authorities which provides assistance in the form of rental certificates and vouchers that enable income-eligible families to find and lease approved privately owned housing where the landlord has agreed to enter into a contract with the housing authority and/or finance agency. Eligible households pay approximately 30% of their income for rent and the housing authority subsidizes the balance.','Section 8 Rental Certificates',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 160,'BH-830.320','HUD Management Companies','Real estate organizations that contract with HUD to manage HUD rental property. Responsibilities include screening of applicants; rental, maintenance and upkeep of the apartment units; and enforcement of rental agreements.','HUD Management Companies',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 161,'BH-830.450','Low Cost/Below Market Rental Housing','Private providers of low cost or below market apartments and houses for lease or rent, often sponsored or operated by religious and charitable organizations for the benefit of low-income families and people who are elderly or have disabilities. Also included is rental housing targeted to lower income households that has been purchased, rehabilitated or constructed by a developers who are receiving a federal income tax credit under the Low Income Housing Tax Credit (LIHTC) program or are participants in other similar affordable housing incentive programs.','Low Cost/Below Market Rental Housing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 162,'BH-900','Utilities Connection/Repair','Programs that provide gas, electricity, water and telephone services including the hook-up of services and the installation, maintenance and repair of necessary equipment.','Utilities Connection/Repair',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 163,'BH-900.150','Electricity Connection/Repair','Companies that provide electricity services including the hook-up of services and the installation, maintenance and repair of meters and other necessary equipment. Also included are programs that accept and respond to reports of downed or arcing power lines, transformers that have been hit by lightning or otherwise affected by bad weather or other problems which constitute a hazard or threaten to interrupt service.','Electricity Connection/Repair',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 164,'BH-900.275','Gas Connection/Repair','Companies that provide natural gas service including the hook-up of services and the installation, maintenance and repair of meters and other necessary equipment. Also included are programs that accept and respond to reports of gas leaks or other problems which constitute a hazard or threaten to interrupt service.','Gas Connection/Repair',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 165,'BH-900.875','Telephone Connection/Repair','Companies that provide local and long-distance telephone services including the hook-up of services and the installation, maintenance and repair of necessary equipment. Also included are programs that accept and respond to reports of downed telephone lines or other problems which threaten to interrupt service.','Telephone Connection/Repair',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 166,'BH-900.950','Water Connection/Repair','Companies that provide water services which include the hook-up of services and the installation, maintenance and repair of water lines, meters and other necessary equipment on private property from the point of connection to the street.','Water Connection/Repair',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 167,'BM','Material Goods','Programs that furnish and/or repair basic household, work-related, and personal necessities for people who cannot afford to purchase and/or repair these items at retail prices and who qualify for this service on the basis of income.','Material Goods',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 168,'BM-050','Automobiles','Programs that provide new and/or second hand automobiles for individuals who qualify on the basis of income, age or disability.  Also included are organizations that sell new or used automobiles at very low cost, refer people to automobile dealerships or otherwise help them acquire an automobile.','Automobiles',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 169,'BM-140','Consumer Goods Information','Programs that provide a telephone information service, an Internet Web site, specialty catalogs or other resources which help people obtain free or low-cost household and personal items and other basic material necessities as well as difficult-to-find items such as scissors for people who are left-handed.','Consumer Goods Information',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 170,'BM-170','Discount Programs','Programs that offer a special pricing structure for their own or a broader array of goods and services which may be open to the general public, be available to members only or be restricted based on an individual''s age, disability or other factors.','Discount Programs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 171,'BM-170.250','General Buying Clubs','Membership organizations that enable participants to purchase a variety of consumer goods at lower than retail prices.','General Buying Clubs',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 172,'BM-170.500','Merchandise Discount Cards','Programs, often available through senior centers, that issue identification cards which enable eligible older adults to purchase goods and services at discount prices from participating merchants.','Merchandise Discount Cards',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 173,'BM-175','Emergency Generators','Programs that pay for or provide portable generators which allow access to power when there are outages.','Emergency Generators',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 174,'BM-300','Household Goods','Programs that pay for or supply new, reconditioned or secondhand furnishings for the homes or apartments of people who cannot afford to equip their residences at retail prices.','Household Goods',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 175,'BM-300.050','Appliances','Programs that pay for or provide new or reconditioned refrigerators, freezers, stoves, irons and other essential equipment for people who cannot afford to purchase these items at retail prices.','Appliances',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 176,'BM-300.050-15','Clothes Dryers','Programs that pay for or provide new or secondhand clothes dryers for people who cannot afford to purchase one at retail prices.','Clothes Dryers',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 177,'BM-300.050-20','Fans/Air Conditioners','Programs that pay for or provide new or reconditioned fans or air conditioners during hot weather for people who cannot afford to purchase these items at retail prices.','Fans/Air Conditioners',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 178,'BM-300.050-35','Heaters','Programs that pay for or provide new or reconditioned heaters during cold weather for people who cannot afford to purchase these items at retail prices.','Heaters',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 179,'BM-300.050-70','Refrigerators','Programs that pay for or provide new or reconditioned refrigerators for people who cannot afford to purchase one at retail price.','Refrigerators',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 180,'BM-300.050-80','Stoves','Programs that pay for or provide new or reconditioned gas or electric ranges for people who cannot afford to purchase one at retail price.','Stoves',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 181,'BM-300.050-90','Vacuum Cleaners','Programs that pay for or provide new or secondhand appliances for cleaning carpets, floors and upholstery for people who cannot afford to purchase one at retail prices.','Vacuum Cleaners',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 182,'BM-300.050-95','Washing Machines','Programs that pay for or provide new or secondhand washing machines for people who cannot afford to purchase one at retail prices.','Washing Machines',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 183,'BM-300.100','Bedding/Linen','Programs that pay for or provide new or secondhand sheets, blankets, pillowcases, bedspreads, towels and other similar household essentials for people who cannot afford to purchase these items at retail prices.','Bedding/Linen',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 184,'BM-300.150','Cleaning Products','Programs that pay for or provide cleaning equipment and/or supplies such as brooms, mops, dust pans, cleansing powder, dish washing soap, window cleaner and furniture polish for people to use to clean their homes.','Cleaning Products',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 185,'BM-300.200','Furniture','Programs that pay for or provide new or secondhand sofas, chairs, tables, beds, dressers and other necessary home furnishings for people who cannot afford to purchase these items at retail prices.','Furniture',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 186,'BM-300.200-05','Adapted Furniture','Programs that pay for or provide new or secondhand sofas, chairs, beds, wardrobes, dressers, tables, trays or other furniture which has been especially modified to meet the needs of people who have physical disabilities.','Adapted Furniture',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 187,'BM-300.200-10','Baby Furniture','Programs that pay for or provide new or secondhand cribs, bassinets, strollers and other infant/baby furniture for families who cannot purchase these items at retail prices.','Baby Furniture',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 188,'BM-300.200-25','General Furniture Provision','Programs that provide furniture for people who need it. Available items depend on what at been donated and is on hand at any given time. The collection may include but does not specialize in adapted furniture, baby furniture or other specific items.','General Furniture Provision',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 189,'BM-300.300','Household Goods Vouchers','Programs that supply people who are in emergency situations with coupons that can be exchanged in designated thrift shops or nonprofit organizations for furniture, appliances, bedding and other household items.','Household Goods Vouchers',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 190,'BM-300.400','Kitchenware','Programs that pay for or provide new or secondhand dishes, utensils and other cookware for people who cannot afford to purchase these items at retail prices.','Kitchenware',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 191,'BM-300.500','Mattresses','Programs that pay for or provide new or secondhand mattresses for people who cannot afford to purchase one at retail prices. Included are mattress liquidators.','Mattresses',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 192,'BM-650','Personal Goods/Services','Programs that pay for or provide new or secondhand personal necessities for people who cannot afford to purchase these items at retail prices.','Personal Goods/Services',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 193,'BM-650.150','Clothing','Programs that pay for or provide new or secondhand clothing for people who cannot afford to purchase these items at retail prices. Included are clothing exchange programs.','Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 194,'BM-650.150-05','Adapted Clothing','Programs that offer clothing that has been especially designed for individuals who have physical disabilities.','Adapted Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 195,'BM-650.150-10','Baby Clothing','Programs that pay for or provide new or secondhand clothing and layettes for infants and young children whose parents are unable to obtain baby clothing without assistance.','Baby Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 196,'BM-650.150-12','Children''s Clothing','Programs that pay for or provide new or secondhand clothing for children and/or adolescents whose parents are unable to obtain clothing for their family without assistance.','Children''s Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 197,'BM-650.150-13','Clothing Vouchers','Programs that supply people who are in emergency situations with coupons that can be exchanged in designated thrift shops or nonprofit organizations for clothing.','Clothing Vouchers',0,1 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 198,'BM-650.150-15','Diapers','Programs that pay for or provide cloth or disposable diapers for families who are unable to obtain diapers without assistance.','Diapers',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 199,'BM-650.150-21','Formal Wear','Programs that provide new or secondhand gowns, tuxedos or other party apparel and, in some cases, appropriate accessories for people who are unable to obtain these items without assistance and need them for a special occasion.','Formal Wear',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 200,'BM-650.150-25','General Apparel','Programs that provide clothing to people who need it.  Available items depend on what at been donated and is on hand at any given time. The collection may include but does not specialize in childrenÂ’s clothes, work clothes, maternity clothes and shoes.','General Apparel',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 201,'BM-650.150-50','Maternity Clothing','Programs that pay for or provide clothing that women can wear during pregnancy.','Maternity Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 202,'BM-650.150-65','Plus Size Clothing','Programs that pay for or provide new or secondhand larger sized clothing for men and/or women who are unable to obtain clothing that fits them without assistance.','Plus Size Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 203,'BM-650.150-80','School Clothing','Programs that pay for or provide new or secondhand clothing or school uniforms for children who have nothing appropriate to wear to school and whose parents are unable to obtain these items without assistance.','School Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 204,'BM-650.150-83','Shoes','Programs that pay for or provide new or secondhand shoes for people who are unable to obtain footwear without assistance. Included are odd shoe exchanges.','Shoes',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 205,'BM-650.150-95','Work Clothing','Programs that pay for or provide new or secondhand uniforms or other working clothes for individuals who are unable to obtain these items without assistance. Also included are programs such as \"Dress for Success\" that provide interview suits and other professional attire for low income individuals (frequently women) who need this type of wardrobe to secure and/or retain gainful employment.','Work Clothing',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 206,'BM-650.155','Clothing Banks','Programs that gather, sort, store and distribute to participating charitable agencies, donated new and/or used clothing. Clothing banks do not distribute clothing directly to individuals who are in need.','Clothing Banks',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 207,'BM-650.650','Personal/Grooming Needs','Programs that provide basic personal services and supplies for homeless people, travelers and other individuals who do not have a local permanent address and who do not have access to private facilities or materials for grooming, baggage storage, cooking, communications and other basic needs.','Personal/Grooming Needs',0,1 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 208,'BM-650.650-10','Baggage Check Facilities','Public lockers or other facilities where travelers and other people in transit can temporarily store luggage or other personal possessions.','Baggage Check Facilities',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 209,'BM-650.650-15','Bathing Facilities','Public or private organizations that provide showers, baths or other facilities where homeless people, travelers and others who do not have access to private bathing facilities can wash. Also included are organizations that provide vouchers that people can use to access bathing facilities.','Bathing Facilities',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 210,'BM-650.650-17','Community Voicemail','Programs that provide voice messaging services which allow homeless people and other individuals with no access to a telephone to communicate in a dignified way with potential employers, landlords, service providers, family members and others regarding interviews, job offers, housing opportunities and other important business. Community voicemail enables clients to record a personal greeting for people who call and pick up messages at their own convenience, usually on a twenty-four hour basis.','Community Voicemail',0,0 )", "Error INSERT INTOing service taxonomy" );

run_query( "INSERT INTO services_taxonomy ( service_id, taxonomy_code, taxonomy_term, taxonomy_summary, service_display_term, service_custom, service_active ) VALUES ( 211,'BM-650.650-19','Cosmetics','Programs that pay for or provide lipstick, powder, liquid makeup, mascara, perfume, cleansing cream, hairsp