I have some point reference data for an entire country, which is about 1.5 million points and for the most part the address number is one number, but in some cases it is a range, so for about 1.3 million of the records the house number column contains a single number e.g. 12, but for the other 200,000 it is a range e.g. 1-12.
When I use the Single house address style it doesn't find the address numbers in the range 6 Main Street, doesn't match as it's 1-12 Main Street in the reference data. If I use the address range style it doesn't work properly as it's designed for lines.
So my question is how can I get the address locator to match to a range that is a point not a line. Or how can I split the reference data up for ranges, so instead of one record for 1-12 Main Street, there is 12 different records all referencing the same point e.g. 1 Main Street, 2 Main Street, 3 Main Street and so on...