Re: [UrbanSim-Users] San Francisco business model

Philippe,
I've put a copy of the data and table description you request on our
website: www.urbansim.org/download/files/SF_data_and_tables.zip . See also
my comments to your questions below.

Liming.

On Feb 8, 2008 6:27 AM, Zuccarello Philippe <philippe.zuccarello_at_wanadoo.fr>
wrote:

> Hi,
>
> I resume the remaining request I have and you can take abstraction of
> other demands done before (solved).
>
> ** I will be very please to have a dump of specification and coefficients
> tables but with data :
> **
> *mysqldump --host=localhost --user=root --password={root
> password} {database name} annual_business_control_totals
> annual_relocation_rates_for_business **business_location_choice_model_specification
> business_location_choice_model_coefficients >some_business_tables_data.sql
> *
> *mysqldump --host=localhost --user=root --password={root
> password} {database name} building_use
> building_use_classification nonresidential_building_location_choice_model_coefficients
> nonresidential_building_location_choice_model_specification** residential_building_location_choice_model_coefficients
> residential_building_location_choice_model_specification
> >some_buildings_tables_data.sql
> *
> **** *Is it possible to have a database create statement of tables :*
> *mysqldump --no-data --host=localhost --user=root --password={root
> password} {database name} >describe_all_tables.sql*
>
> I will appreciate if table columns have *comments** for having a small description.
> At least It can help me for main tables business, buildings and parcels.
> *
>
> ** That are the main differences beetween the Urbansim Building models and
> the models implemented on Sanfransico project (is the parcels table specific
> for sanfranciso) ?
>
The gridcell version of UrbanSim don't use the building dataset, but the
parcel version (urbansim_parcel) does use it. The developer model (Builidng
model) are different between the urbansim_parcel and sanfrancisco project in
that they are implemented from different prospect of the real estate market,
thus with different model structure. The The developer model in
urbansim_parcel is implement as a probabilistic profit maximization over
development site and property product type while the one in sanfrancisco
project is a spatial choice model of developers. The attributes in both
buildings and parcels would vary from application to application because of
difference in data availability and model structure.

>
>
> My other requests :
>
> - Do I need All .py files located in sanfrancisco/building directory ?
>
> No, you don't. .py files in sanfrancisco/building are variables defined
for the building dataset. You can include them in your model specification
or leave them out.

>
> - I wanted also to have the description of *business*, *buidings* tables
> with *comments* as possible, in fact this 2 tables we have many 'sqft'
> attribute : can You explain the difference for each ?.
>
> - I wanted also to have the description of *parcels* table.
>
>
>
>
Received on Tue Feb 12 2008 - 14:38:13 PST