Home > Lines >

Set up additional geographical boundaries for rating

If clients set up additional geographical boundaries, they can rate based upon geographical location.

The census Block Group is a geographical unit used by the United States Census Bureau that is between the Census Tract and the Census Block. It is the smallest geographical unit for which the bureau publishes sample data, such as data that is collected from only a fraction of all households. Typically, Block Groups have a population of 600 to 3,000 people.

Waterway polygons identify the shape of waterways.

When a client collects both census block group and waterway polygons, they can query the data from each to determine if a specific latitude and longitude are contained within a given polygon for rating purposes.

Follow the instructions below when:

  • Applying data obtained from a web service to determine whether specific latitudes and longitudes are contained within a given polygon for rating purposes.
  • Importing census block group and miscellaneous polygon data into new categories (census_block_groups and waterway_polygons).

Load Shapefile data

To load Shapefile data:

  1. In your web browser, navigate to https://www.census.gov/cgi-bin/geo/shapefiles/index.php.
  2. In the Select a layer type dropdown, select Block Groups, and then, select Submit.
  3. In the Select a State dropdown, select the applicable state, and then, select Download.
  4. On the server running the import, complete the following steps:
    1. In a temp directory, add the file you downloaded.
    2. Ensure bin/postfix_scripts/281_add_geometry_tables.py has run and the database tables exist.
    3. Run python bin/load_shapefile_data.py -c -p to import the shapefile you downloaded.

Note: To test truncate functionality and truncate the table before populating, add the `-t` argument.

  1. To import data as a waterway polygon, repeat steps 4b and 4c while omitting the -c flag.

Add rating categories

To add use-census-blockgroups and use-waterway-polygons as new rating categories:

  1. Log in to BriteCore as an Administrator.
  2. In the BriteCore menu, select Settings.
  3. On the Settings screen, select Advanced.
  4. On the Advanced Settings screen, in the search box, type use-census-block-groups.
  5. In the use-census-block-groups box, select True.
  6. In the search box, type use-waterway-polygons.
  7. In the use-waterway-polygons box, select True.
  8. In the BriteCore menu, select Lines.
  9. On the Effective Dates screen, select the applicable effective date.
  10. On the Policy Types screen, complete the following steps:
    1. In the Select State or Province dropdown, select a state or province.
    2. Navigate to the applicable Policy Type, and then select Edit .
  11. On the Details screen, in the Primary Exposures section, navigate to the applicable Line Item, and then select Edit .
  12. On the Edit Line Item screen, select Rating, and complete the following steps:
    1. In the Rate Chain section, select Add to Chain .
    2. In the Rate Object dropdown list, select Categories.
    3. In the Chain Details section, select Rate Categories, and then select Add a Category .
    4. In the Category dialog box, in the Category Type dropdown list, select Census Block Group, and then select Done.
    5. At the bottom of the screen, select Save, and then select Exit.