Aggregate and geoserve multiple 3rd-party data sets

Data Repository

Without changing operational databases in any way, implement a software component that can harvest information from those databases, geocode them, and respond to geographic information requests, preferably as a Web Feature Service. This may involve creating a lookup table matching addresses with point locations. 3rd-party databases should maintain synchronization.

database tables with addresses

geospatial data service

Make an information request to the service, constrained by geographic area and/or attributes.
Response compliant with Web Feature Service interface.