data model

[Ann]

Can someone provide me a data model for the address and parcel
information managed by the EAS? I'm curious how much we would need to
modify the tools or our data model to get the EAS to work for us.

Ann Boyd
City of Bellevue

[Adam Lodge]

Ann,

I can get a diagram to you mid next week. It would be interesting to compare notes on what you already have vs requirements for the EAS.

-Adam

[McCullough, Paul]

Ann,

We have 4 sources of information that are immediately available that may help you.

First, we have a very recent database dump which is here
http://code.google.com/p/eas/downloads/detail?name=mad-1_0-prod.backup&can=2&q=#makechanges
This is up to date, and has data.
To make sense of it, you would have to install postgresql 8.3.7(ish), with postgis.
And you could use pgadmin (a friendly client) to explore the database.

The remaining 3 sources are little bit dated but not significantly.

Here is a picture of the data model
http://code.google.com/p/eas/source/browse/trunk/database/erd_20100608.jpeg

Here is the SQL to create the database
http://code.google.com/p/eas/source/browse/trunk/database/archive/sfmad.SQL

And here is a TOAD project
http://code.google.com/p/eas/source/browse/trunk/database/archive/version10.txp


Adam,
Thanks for the offer to get the latest data model to Ann.
When you prepare a diagram, could you also post the raw SQL for the schema?
Seems to me this should all go here:
http://code.google.com/p/eas/source/browse/#svn%2Ftrunk%2Fdatabase
Does that make sense to anyone besides me :-?


Regards
Paul

[Karl Fogel]

"McCullough, Paul" <paul.mc...@sfgov.org> writes:
>Adam,
>Thanks for the offer to get the latest data model to Ann.
>When you prepare a diagram, could you also post the raw SQL for the schema?
>Seems to me this should all go here:
> http://code.google.com/p/eas/source/browse/#svn%2Ftrunk%2Fdatabase
>Does that make sense to anyone besides me :-?

Yes -- it makes sense to me too :-).