Category = Address
Description = US One Address with Zone

Version = 9.2
UseRelativePaths = False

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Properties Required by ArcGIS
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

CLSID = {B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
ArcGIS::CLSID = {B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
SDE::CLSID = {04FCADCF-ED3B-11D2-9F48-00C04F8ED1C4}
UICLSID = {AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}

Fields = Street
Fields = Zone

FieldAliases = Street
FieldAliases = Zone

FieldNames.0 = Address
FieldNames.0 = Addr
FieldNames.0 = Street

FieldNames.1 = Zip
FieldNames.1 = Zipcode
FieldNames.1 = City
FieldNames.1 = Zone

FieldsRequired = TRUE
FieldsRequired = FALSE

FieldSizes = 60
FieldSizes = 20

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Fundamental Locator Properties
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Locator.CLSID = {D9052385-AB46-11d2-AADA-00C04FA379E3}
Locator.FactoryCLSID = {68F5E953-06FF-11d3-AAFD-00C04FA379E3}
Locator.FactoryLibrary = mtchloc
Locator.Library = mtchloc

Query.CLSID = {1845B140-FC3B-11d2-AAFA-00C04FA379E3}
Query.Library = mtchloc

DBEnv.CLSID = {43BA3ECC-0120-11d4-AB58-00C04FA379E3}
DBEnv.Library = LocationQueryEngine

ArcGIS::DBEnv.CLSID = {43BA3ECC-0120-11d4-AB58-00C04FA379E3}
ArcGIS::DBEnv.Library = LocationQueryEngine

SDE::DBEnv.CLSID = {78E9FDDC-001A-11d4-AB58-00C04FA379E3}
SDE::DBEnv.Library = mtchloc

MKeyField = XX
MKeyField = ZN

SupportIntersections = FALSE
Interpolate = FALSE

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  ESRI Geocoder Optional Properties
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

FileMAT = us_snum1.mat
FileSTN = us_addr.stn
MinimumMatchScore = 60
MinimumCandidateScore = 10
SpellingSensitivity = 80
MatchIfScoresTie = True
WriteXYCoordFields = False
WriteStandardizedAddressField = False
WriteReferenceIDField = False

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  ESRI Geocoder Specific - aliases for standardization fields
;  (Names shown on the Geocoding Interactive Review Dialog)
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

MKeyAlias.HN = HouseNum
MKeyAlias.PD = PreDir
MKeyAlias.PT = PreType
MKeyAlias.SD = SufDir
MKeyAlias.SN = StreetName
MKeyAlias.ST = SufType
MKeyAlias.ZN = Zone

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Reference Data Properties
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

RD.Table = Table1,"Primary table"

RD.Table1.Column = HouseNum,"House Number",N,TRUE
RD.Table1.Column = PreDir,"Prefix Direction",N,FALSE
RD.Table1.Column = PreType,"Prefix Type",N,FALSE
RD.Table1.Column = StreetName,"Street Name",N,TRUE
RD.Table1.Column = StreetType,"Street Type",N,FALSE
RD.Table1.Column = SufDir,"Suffix Direction",N,FALSE
RD.Table1.Column = Zone,"Zone",N,TRUE
RD.Table1.Column = ID,"Record ID for the Primary table",N,TRUE
RD.Table1.Column = Shape,"Shape column",N,TRUE

RD.Table1.Filter = esriCatalog.GxFilterFeatureClasses

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Index tables
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

RD.IdxTable = IdxTable1,"IndexTable for Primary table"

RD.IdxTable1.IdxColumn = XID,"Soundex foreign key column",Y,$Table1.ID
RD.IdxTable1.IdxColumn = Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
RD.IdxTable1.IdxColumn = Zone,"Zone column",Y,@ZNSX($Table1.Zone)
RD.IdxTable1.IdxColumn = RoundHN,"Rounded House number column",Y,@RoundHN($Table1.HouseNum)

RD.IdxTable1.Prefix = GC_SZS

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Queries
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

RD.Query = Query1,"Main query"

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Address Queries
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

RD.Query1.Where = $IdxTable1.Sx = '@SDEX(%SN%)' AND $IdxTable1.RoundHN = '@RoundHN(%HN%)'
RD.Query1.ConditionalWhere = ZN, " AND $IdxTable1.Zone = '@ZNSX(%ZN%)'"
RD.Query1.FallbackWhere = SN, $IdxTable1.Sx = '@SDEX(%SN%)'
RD.Query1.Filter = @SpellSens(%SN%, $Table1.StreetName)
RD.Query1.InvariantWhere = " AND $Table1.ID = $IdxTable1.XID"
RD.Query1.Lox = Lox1

RD.Query1.MF = HouseNum,Table1.HouseNum
RD.Query1.MF = PreDir,Table1.PreDir
RD.Query1.MF = PreType,Table1.PreType
RD.Query1.MF = StreetName,Table1.StreetName
RD.Query1.MF = StreetType,Table1.StreetType
RD.Query1.MF = SufDir,Table1.SufDir
RD.Query1.MF = Zone,Table1.Zone
RD.Query1.MF = Shape,Table1.Shape
RD.Query1.MF = ID,Table1.ID

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Actual Reference Data values
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

RD.Val.IdxTable1 = GC_SZSaddress_points
RD.Val.IdxTable1.RoundHN = RHN
RD.Val.IdxTable1.Sx = SX
RD.Val.IdxTable1.XID = XID
RD.Val.IdxTable1.Zone = ZONE

RD.Val.Table1 = address_points
RD.Val.Table1.HouseNum = ADDR_NO
RD.Val.Table1.ID = FID
RD.Val.Table1.PreDir = PRE_DIR
RD.Val.Table1.PreType = PRE_TYPE
RD.Val.Table1.Shape = Shape
RD.Val.Table1.StreetName = STREETNAME
RD.Val.Table1.StreetType = STR_TYPE
RD.Val.Table1.SufDir = 
RD.Val.Table1.Zone = ZIPCODE

RD.WorkspaceString = ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = X:\GIS\AddressTools

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Indexing functions
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

RD.Func = SDEX,mtchloc,SX,""
RD.Func = ZNSX,mtchloc,ZoneSX,""
RD.Func = SpellSens,mtchloc,SpellSens,""
RD.Func = RoundHN,mtchloc,RoundHN,""

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;  Locator Index (LOX) File
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

RD.LocatorIndex = Lox1

RD.Lox1.Restrict = $Table1.StreetName <> 'UNNAMED STREET' AND $Table1.StreetName <> 'UNNAMED' AND $Table1.StreetName <> '' AND $Table1.StreetName <> ' '

RD.Lox1.SortBy = $IdxTable1.Zone
RD.Lox1.SortBy = $Table1.Zone
RD.Lox1.SortBy = $IdxTable1.Sx
RD.Lox1.SortBy = $Table1.StreetName
RD.Lox1.SortBy = $Table1.PreType,$Table1.PreDir,$Table1.SufDir,$Table1.StreetType
RD.Lox1.SortBy = $IdxTable1.RoundHN

RD.Lox1.SubtreeSplit = 1
RD.Lox1.Tail = $Table1.HouseNum,$Table1.ID,$Table1.Shape

BuildVersion = $Revision: 11$
BuildVersionDate = $Date: 7/12/2006 11:50:41 AM$
EmbedGeocodingRules = TRUE
Fallback = TRUE
LocatorWorkspaceString = ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path = X:\GIS\AddressTools\

RdDef::RD.Lox1.Restrict = $Table1.StreetName <> 'UNNAMED STREET' AND $Table1.StreetName <> 'UNNAMED' AND $Table1.StreetName <> '' AND $Table1.StreetName <> ' '

RdOra::RD.Lox1.Restrict = $Table1.StreetName <> 'UNNAMED STREET' AND $Table1.StreetName <> 'UNNAMED' AND $Table1.StreetName IS NOT NULL AND $Table1.StreetName <> ' '

RebuildStartTime = 128758167210450000
RebuildStartTimeAscii = 3:45:21 PM
SafeLocatorName = Address Points Shapefile
StoreStandardizedRefData = TRUE
