Method and system for establishing a spatial street address data set
View Patent ↗A method for establishing a spatial street address data set including: First, in no particular order: ( 1 ) providing street address data; ( 2 ) providing postal data; ( 3 ) providing community translation data; and ( 4 ) providing a spatial layer base map. Second, establishing a first data base containing once-translated address entries, each relating to a selected community entry from the street address data or a selected community entry from the community translation data. Third, establishing a second data base containing twice-translated address entries, each relating to a selected street name entry from the postal data or a selected street name entry from the street address data. Fourth, treating the second data base with a geocoder routine to create geocoded address entries in a geocoded data set. Fifth, situating the geocoded data set in a spatial layer. Sixth, orienting the spatial layer with known loci in the spatial layer base map.
1. A method for establishing a spatial street address data set; the method comprising:
(a) in no particular order:
(1) providing a street address data set containing at least community entry and street name entry information;
(2) providing a postal data set containing at least street name entry information;
(3) providing a community translation data set containing at least community entry information; and
(4) providing a spatial layer base map containing at least one spatial community entry;
(b) employing selected information from said street address data set, said community translation data set and said spatial layer base map for establishing a first interim data base; said first interim data base containing a plurality of once-translated address entries; each respective once-translated address entry of said plurality of once-translated address entries replacing a respective spatial community entry of said at least one spatial community entry; each said respective once-translated address entry relating to a selected community entry from said street address data set or relating to a selected community entry from said community translation data set;
(c) employing said first interim data base and selected information from said street address data set and said postal data set for establishing a second interim data base; said second interim data base containing a plurality of twice-translated address entries; each respective twice-translated address entry of said plurality of twice-translated address entries replacing a respective street name entry in said first interim data base; each said respective twice-translated address entry relating to a selected street name entry from said postal data set or relating to a selected street name entry from said street address data set;
(d) treating said second interim data base with a geocoder routine to create geocoded address entries in a geocoded data set;
(e) situating said geocoded data set in a spatial layer; and
(f) orienting said spatial layer with respect to known loci in said spatial layer base map.
2. A method for establishing a spatial street address data set as recited in claim 1 wherein said establishing said first interim data base comprises:
(b)(1) culling address information from said street address data set to establish a culled address set;
(b)(2) selecting a community entry from said culled address set;
(b)(3) inquiring whether said community entry is extant as a spatial community entry in said spatial layer base map;
(b)(4) if said community entry is extant as a spatial community entry in said spatial layer base map, substituting said spatial community entry for said community entry in said first interim data base;
(b)(5) if said community entry is not extant as a spatial community entry in said spatial layer base map, checking whether said community entry is extant as a translation community entry in said community translation data set;
(b)(6) if said community entry is extant as a translation community entry in said community translation data set, substituting said translation community entry for said community entry in said first interim data base;
(b)(7) storing said spatial community entry or said translation community entry as a respective said once-translated data entry in said first interim data base;
(b)(8) if said community entry is not extant as a translation community entry in said community translation data set, discarding said community entry;
(b)(9) repeating steps (b)(1) through (b)(8) for treating a next community entry in said culled address set until all community entries in said culled address set have been treated.
3. A method for establishing a spatial street address data set as recited in claim 1 wherein said establishing a second interim data base comprises:
(c)(1) selecting a street entry from said first interim data base;
(c)(2) seeking to effect translating said street entry into a postal street name in said postal data set;
(c)(3) if said translating is achieved, substituting said postal street name for said street entry in said second interim data base;
(c)(4) if said translating is not achieved, seeking to effect matching said street entry with a listed street name in said street address data set;
(c)(5) if said matching is achieved, substituting said listed street name for said street entry in said second interim data base;
(c)(6) storing said postal street name or said listed street name as a respective said twice-translated entry in said second interim data base;
(c)(7) if said matching is not achieved, discarding said street entry;
(c)(8) repeating steps (c)(1) through (c)(7) for treating a next street entry in said first interim data base until all street entries have been treated.
4. A method for establishing a spatial street address data set as recited in claim 2 wherein said establishing a second interim data base comprises:
(c)(1) selecting a street entry from said first interim data base;
(c)(2) seeking to effect translating said street entry into a postal street name in a postal data base;
(c)(3) if said translating is achieved, substituting said postal street name for said street entry in said second interim data base;
(c)(4) if said translating is not achieved, seeking to effect matching said street entry with a listed street name in said street address data set;
(c)(5) if said matching is achieved, substituting said listed street name for said street entry in said second interim data base;
(c)(6) storing said postal street name or said listed street name as a respective said twice-translated entry in said second interim data base;
(c)(7) if said matching is not achieved, discarding said street entry;
(c)(8) repeating steps (c)(1) through (c)(7) for treating a next street entry in said first interim data base until all street entries have been treated.
5. A method for establishing a spatial street address data set as recited in claim 1 wherein said street address data set is embodied in an emergency service master street address guide.
6. A method for establishing a spatial street address data set as recited in claim 1 wherein said postal data set is a U.S. Postal Service postal address data base.
7. A method for establishing a spatial street address data set as recited in claim 4 wherein said street address data set is embodied in an emergency service master street address guide.
8. A method for establishing a spatial street address data set as recited in claim 7 wherein said postal data set is a U.S. Postal Service postal address data base.
9. A method for establishing a spatial street address data set; the method comprising:
(a) in no particular order:
(1) providing a first street address data set containing at least community entry and street name entry information;
(2) providing a second street address data set containing at least street name entry information;
(3) providing a community translation table containing at least community entry information; and
(4) providing a spatial layer base map containing at least one spatial community entry;
(b) employing selected information from said first street address data set, said community translation table and said spatial layer base map for establishing a first interim data base; said first interim data base containing a plurality of once-translated address entries; each respective once-translated address entry of said plurality of once-translated address entries replacing a respective spatial community entry of said at least one spatial community entry; each said respective once-translated address entry relating to a selected community entry from said first street address data set or relating to a selected community, entry from said community translation table;
(c) employing said first interim data base and selected information from said first street address data set and said second street address data set for establishing a second interim data base; said second interim data base containing a plurality of twice-translated address entries; each respective twice-translated address entry of said plurality of twice-translated address entries replacing a respective street name entry in said first interim data base; each said respective twice-translated address entry relating to a selected street name entry from said first street address data set or relating to a selected street name entry from said second street address data set;
(d) treating said second interim data base with a geocoder routine to create geocoded address entries in a geocoded data set;
(e) situating said geocoded data set in a spatial layer; and
(f) orienting said spatial layer with respect to known loci in said spatial layer base map.
10. A method for establishing a spatial street address data set as recited in claim 9 wherein said establishing said second interim data base comprises:
(b)(1) culling address information from said first street address data set to establish a culled address set;
(b)(2) selecting a community entry from said culled address set;
(b)(3) inquiring whether said community entry is extant as a spatial community entry in said spatial layer base map;
(b)(4) if said community entry is extant as a spatial community entry in said spatial layer base map, substituting said spatial community entry for said community entry in said first interim data base;
(b)(5) if said community entry is not extant as a spatial community entry in said spatial layer base map, checking whether said community entry is extant as a translation community entry in said community translation table;
(b)(6) if said community entry is extant as a translation community entry in said community translation able, substituting said translation community entry for said community entry in said first interim data base;
(b)(7) storing said spatial community entry or said translation community entry as a respective said once-translated data entry in said first interim data base;
(b)(8) if said community entry is not extant as a translation community entry in said community translation table, discarding said community entry;
(b)(9) repeating steps (b)(1) through (b)(8) for treating a next community entry in said culled address set until all community entries in said culled address set have been treated.
11. A method for establishing a spatial street address data set as recited in claim 9 wherein said establishing a first interim data base comprises:
(c)(1) selecting a street entry from said first interim data base;
(c)(2) seeking to effect translating said street entry into a postal street name in said second street address data set;
(c)(3) if said translating is achieved, substituting said postal street name for said street entry in said second interim data base;
(c)(4) if said translating is not achieved, seeking to effect matching said street entry with a listed street name in said first street address data set;
(c)(5) if said matching is achieved, substituting said listed street name for said street entry in said second interim data base;
(c)(6) storing said postal street name or said listed street name as a respective said twice-translated entry in said second interim data base;
(c)(7) if said matching is not achieved, discarding said street entry;
(c)(8) repeating steps (c)(1) through (c)(7) for treating a next street entry in said first interim data base until all street entries have been treated.
12. A method for establishing a spatial street address data set as recited in claim 10 wherein said establishing a first interim data base comprises:
(c)(1) selecting a street entry from said first interim data base;
(c)(2) seeking to effect translating said street entry into a postal street name in said second street address data set;
(c)(3) if said translating is achieved, substituting said postal street name for said street entry in said second interim data base;
(c)(4) if said translating is not achieved, seeking to effect matching said street entry with a listed street name in said first street address data set;
(c)(5) if said matching is achieved, substituting said listed street name for said street entry in said second interim data base;
(c)(6) storing said postal street name or said listed street name as a respective said twice-translated entry in said second interim data base;
(c)(7) if said matching is not achieved, discarding said street entry;
(c)(8) repeating steps (c)(1) through (c)(7) for treating a next street entry in said first interim data base until all street entries have been treated.
13. A method for establishing a spatial street address data set as recited in claim 9 wherein said first street address data set is embodied in an emergency service master street address guide.
14. A method for establishing a spatial street address data set as recited in claim 9 wherein said second street address data set is a U.S. Postal Service postal address data base.
15. A method for establishing a spatial street address data set as recited in claim 12 wherein said first street address data set is embodied in an emergency service master street address guide.
16. A method for establishing a spatial street address data set as recited in claim 15 wherein said second street address data set is a U.S. Postal Service postal address data base.
17. An apparatus for establishing a spatial street address data set;
the apparatus comprising:
(a) at least one computer-readable storage media; said at least one computer-readable storage media containing:
(1) a street address data set containing at least community entry and street name entry information;
(2) a postal data set containing at least street name entry information;
(3) a community translation data set containing at least community entry information; and
(4) a spatial layer base map containing at least one spatial community entry;
(b) a first data treating unit coupled with said at least one computer-readable storage media; said first data treating unit employing selected information from said street address data set, said community translation data set and said spatial layer base map for establishing a first interim data base containing a plurality of once-translated address entries; each respective once-translated address entry of said plurality of once-translated address entries replacing a respective spatial community entry of said at least one spatial community entry; each said respective once-translated address entry relating to a selected community entry from said street address data set or relating to a selected community entry from said community translation data set;
(c) a second data treating unit coupled with said first interim data base and with said at least one computer-readable storage media; said second data treating unit employing selected information from said street address data set and said postal data set for establishing a second interim data base containing a plurality of twice-translated address entries; each respective twice-translated address entry of said plurality of twice-translated address entries replacing a respective street name entry in said first interim data base; each said twice-translated address entry relating to a selected street name entry from said postal data set or relating to a selected street name entry from said street address data set;
(d) a geocoding unit coupled with said second interim data base; said geocoding unit effecting geocoding treatment of entries in said second interim data base to populate a geocoded data set; and
(e) an orienting unit coupled with said geocoding unit; said orienting unit effecting orientation of entries in said geo coded data set with respect to known loci in said spatial layer base map to establish said spatial street address data set.
18. An apparatus for establishing a spatial street address data set as recited in claim 17 wherein said first street address data set is embodied in an emergency service master street address guide.
19. An apparatus for establishing a spatial street address data set as recited in claim 17 wherein said second street address data set is a U.S. Postal Service postal address data base.
20. An apparatus for establishing a spatial street address data set as recited in claim 19 wherein said first street address data set is embodied in an emergency service master street address guide.