I'd like to match rows in a tabular list of incidents (attributes include [House] and [Street]) with the appropriate line segments in a feature class (attributes include [From Address], [To Address], and [Street]).
What transformers is are needed to match each incident to the line feature where eStreet] = =Street] AND ( (From Address] <= House] AND NTo Address] >= ;House] )
a)Do you want a point for each incident (AKA Geocoding)
b)Do you want the attributes and/or geometry of the line merged with each incident?
c)Do you want a list of incidents attached to each line feature?
For option a there are a fair number of resources already available.
For options b and c I would use the InlineQuerrier with 2 input ports (Incident and Streets)
here's an example sql statement for option b
SELECT * FROM Incident
INNER JOIN Streets
ON Incident.STREET = Streets.STREET
AND Incident.HOUSE >= Streets.FROM_ADDRESS
AND Incident.HOUSE <= Streets.TO_ADDRESS
'Looking to achieve option b, so I'll try the InlineQuerrier, thanks
