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

Implement Street model #63

Closed
bertday opened this issue Nov 25, 2016 · 1 comment
Closed

Implement Street model #63

bertday opened this issue Nov 25, 2016 · 1 comment

Comments

@bertday
Copy link
Contributor

bertday commented Nov 25, 2016

Currently AIS has a single model for street segments, but for implementing a /search endpoint that supports a generic street lookup we'll need a more abstract model called Street that relates all the segs with the same street code. The fields should be:

predir: text (not null)
name: text (not null)
suffix: text (not null)
postdir: text (not null)
full: text (not null, indexed, unique)
code: integer (not null, indexed, unique)

Add a foreign key to StreetSegment called street that references a Street object via its street code. This should be indexed as well. Remove fields in StreetSegment that are covered in the new model (street_predir, street_name, street_suffix, street_postdir, street_code).

Some of the engine scripts will need to be tweaked to use this model, most importantly load_streets, load_dor_parcels, and load_addresses.

@bertday
Copy link
Contributor Author

bertday commented Jan 4, 2017

Not sure what the use case was for this; closing for now.

@bertday bertday closed this as completed Jan 4, 2017
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