How to find nearest body of water to a location using Spectrum

Products Affected: Spectrum™ Technology Platform, MapInfo Professional, Street Pro, Location Intelligence Module
Operating System: Windows Server, Linux, AIX, Solaris, HP-UX
An important part of insurance rating is knowing the distance between a property and the nearest body of water. The proximity to water affects both the property's value and the likelihood of a flood. Pitney Bowes Street Pro data contains two sets of files that can be used to determine the proximity to inland water features like rivers and lakes.

Throughout these instructions xx will refer to a standard US state abbreviation such as NY or FL.
  1. Open the file in MapInfo Professional.
  2. Use SQL Select to choose these columns from the xxrivers table:
    • Name
    • Name_Lng
    • Type
    • DispClass
    • miCode
    • ID
    • Longitude
    • Latitude
    • A2_Code
  3. (Optional) Include a where Condition: Name <> ""
  4. Save a copy of the Query1 table with the results, for example
  5. Click Home > Close > Close All and do not save the workspace.
  6. Open the and files in MapInfo Professional.
  7. Use SQL Select to choose the same columns from the xxwaterbodies table.
  8. Click Table > Append Rows to append the Query1 table to the xxNamedWaters table.
  9. Save the xxNamedWaters table.
  10. (Optional) Repeat these steps for additional states.
  11. (Optional) Use the Seamless Manager tool in MapInfo Professional to create a seamless table for the nation or region.
  12. Use the Spectrum Spatial Manager or the Map Uploader utilities to define the xxNamedWaters tables to Location Intelligence Module.
  13. Use the Find Nearest or Query Spatial Data stages in a dataflow to determine the closest water feature to a given location.  For information regarding those stages, refer to the Spectrum Spatial Guide.

UPDATED:  August 28, 2017