Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Proposal: "exports" process #120

Open
bertday opened this issue Apr 17, 2017 · 1 comment
Open

Proposal: "exports" process #120

bertday opened this issue Apr 17, 2017 · 1 comment

Comments

@bertday
Copy link
Contributor

bertday commented Apr 17, 2017

Right now AIS can ingest address data but doesn't have a way of exporting the standardized and geocoded version back to a common database, which means that some datasets need to be processed a second time in order to be mapped, analyzed, etc. (use case: RTT transactions). The only product is Address Summary, which is one-to-one with addresses and can be difficult to join back to source datasets that don't map cleanly to addresses. This feature would add a process to copy those source tables, append standardized address and XY fields, and place them back in the enterprise database.

The config could take a list of address sources that require an export:

'exports': [
    {
        'source_name': 'rtt_documents',
        # potentially more config here...
    }
]
@Alexander-M-Waldman
Copy link
Contributor

@rbrtmrtn is this as simple as joining address_summary to source_address table based on street_address?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants