Hi,
I continue to work about this subject in the good direction ... .
The error describes bellow was due to a not valid value in specification
table because the variable I take for tests was based on "gricell"
I fill the parcels tables (I creaye 1 parcel for 1 zone) with ramdom values
for units attributes and some other attributes in buildings table.
Now the model works for the first Year, I think because my specification and
coefficients tables are not fill correctly to define the real model's
Equations.
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) ?
Regards,
Philippe ZUCCARELLO
-----Message d'origine-----
De : users-bounces_at_urbansim.org [mailto:users-bounces_at_urbansim.org]De la
part de Zuccarello Philippe
Envoyé : vendredi 1 février 2008 22:58
À : Liming Wang
Cc : users_at_urbansim.org
Objet : Re: [UrbanSim-Users] San Francisco business model
Hi Liming,
Fisrt, thanks for your responses ... I can progress.
Yes I have use the sanfrancisco/configs/controller_config.py config file
to build mine.
Regarding the files you send to me, specialy for
building_use_classification, the name attribute comment is 'nonresidential
or residential, used as prefix for building locaiton choice model'.
I dismiss the foreign key of class_id between building_use_classification
and building_use
Before, I created this tables but empty : so the error I ave before
provide from this.
For make tests :
I fill the building_use_classification table with following data (for
class_id, is_residential,units,name)
1;0;"residential_units";"nonresidential";
2;1;"residential_units";"residential";
I fill the table building_use with following data (for class_id,
building_use,building_use_id) :
1;"use 1";1
1;"use 2";2
I add building_id attribute (int32) in households table and randomize
values.
I add building_use_id attribute (int32) and unit_price attribute (double)
in development_event_history table and randomize values.
I add residential_units_capacity attribute (int32) in parcels table.
My other requests :
- Do I need All .py files located in sanfrancisco/building directory ?
- 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.
Now, I stop with this error :
Running Residential Building Location Choice Model (from
lyonprototype41.models.building_location_choice_model): completed...0.7 sec,
total 115872 KB, up 2832 KB
SIMBAD Eval:BuildingLocationChoiceModel(group_member,
number_of_units_string='lyonprototype41.parcel.UNITS_capacity',
capacity_string='UNITS_capacity',
estimate_config={'weights_for_estimation_string': None},
agents_grouping_attribute='lyonprototype41.building.building_class_id',
developable_minimum_unit_variable=None,
submodel_string='building.building_use_id', filter=None,
number_of_agents_string='lyonprototype41.parcel.UNITS',
run_config={'agent_units_string': 'lyonprototype41.building.building_size'},
location_set=parcel, developable_maximum_unit_variable='UNITS_capacity', )
'agents_grouping_attribute' set to
lyonprototype41.building.building_class_id.
Running Nonresidential Building Location Choice Model (from
lyonprototype41.models.building_location_choice_model): started on Fri Feb
01 22:49:33 2008
lyonprototype41.building.building_class_id
_building_class_id=building.disaggregate(building_use_classification.class
_id, intermediates=[building_use])....0.2 sec, total 117264 KB, up 1388 KB
lyonprototype41.building.building_class_id: completed...0.3 sec, total
117264 KB, up 1388 KB
lyonprototype41.building.building_size
unit_name=building_use.disaggregate(building_use_classification.units)....
0.0 sec, total 121296 KB, up 0 KB
unit_name=building.disaggregate(building_use.unit_name)....1.3 sec, total
127220 KB, up 5916 KB
lyonprototype41.building.building_size: completed...1.6 sec, total 128608
KB, up 7320 KB
Total number of individuals: 345799
Nonresidential BLCM chunk 1 out of 692.: started on Fri Feb 01 22:49:35
2008
Number of agents in this chunk: 500
SIMBAD name=gridcell
SIMBAD dataset_name=building_x_parcel
SIMBAD dataset_name1=building
SIMBAD dataset_name2=parcel
Nonresidential BLCM chunk 1 out of 692.: completed...0.2 sec, total 134148
KB, up 2828 KB
Running Nonresidential Building Location Choice Model (from
lyonprototype41.models.building_location_choice_model): completed...2.4 sec,
total 134148 KB, up 18272 KB
Simulate year 1981: completed.....6.3 sec, total 134148 KB, up 120796 KB
Closing log file: /tmp\run_143.opus\year_1981_log.txt
Starting simulation for year 1981: completed...6.3 sec, total 134148 KB,
up 120796 KB
Start simulation run: completed...........6.4 sec, total 134148 KB, up
120808 KB
Closing log file: /tmp\run_143.opus\run_multiprocess.log
Traceback (most recent call last):
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\model_coordinators\m
odel_system.py", line 576, in <module>
s.run(resources)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\model_coordinators\m
odel_system.py", line 137, in run
write_datasets_to_cache_at_end_of_year=write_datasets_to_cache_at_end_of_y
ear)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\model_coordinators\m
odel_system.py", line 363, in _run_year
self.vardict[outputvar] = self.do_process(locals())
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\model_coordinators\m
odel_system.py", line 445, in do_process
return eval(ev)
File "<string>", line 1, in <module>
File "C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\model.py",
line 48, in logged_run_method
results = run_method(*req_args, **opt_args)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\configurable.py",
line 38, in config_run_method
results = run_method(*req_args, **opt_args)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\models\building_loca
tion_choice_model.py", line 151, in run
return AgentLocationChoiceModelMember.run(self, *args, **kargs)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\models\agent_locatio
n_choice_model_member.py", line 46, in run
agents_index=agents_index[new_agents_index], **kwargs)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\models\agent_locatio
n_choice_model.py", line 75, in run
agents_index[unplaced], chunk_specification, run_config=run_config,
debuglevel=debuglevel)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\models\location_choi
ce_model.py", line 121, in run
debuglevel=debuglevel)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\choice_model.py",
line 141, in run
specification=specification, coefficients=coefficients)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\chunk_model.py",
line 72, in run
dataset, **kwargs).astype(result_array_type)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\models\agent_locatio
n_choice_model.py", line 89, in run_chunk
result = LocationChoiceModel.run_chunk(self, agents_index, agent_set,
specification, coefficients)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\urbansim\models\location_choi
ce_model.py", line 140, in run_chunk
choices = ChoiceModel.run_chunk(self,agents_index, agent_set,
specification, coefficients)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\choice_model.py",
line 171, in run_chunk
choice_indices = self.simulate_chunk()
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\choice_model.py",
line 179, in simulate_chunk
self.model_interaction.compute_variables()
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\choice_model.py",
line 594, in compute_variables
resources = self.interaction_resources)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\datasets\abstract_d
ataset.py", line 336, in compute_variables
(versions, value) =
self.compute_variables_return_versions_and_final_value(names, dataset_pool,
resources, quiet)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\datasets\abstract_d
ataset.py", line 355, in compute_variables_return_versions_and_final_value
qualified_name = self.create_and_check_qualified_variable_name(name)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\datasets\interactio
n_dataset.py", line 551, in create_and_check_qualified_variable_name
self._check_dataset_name(vname.get_dataset_name())
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\datasets\interactio
n_dataset.py", line 562, in _check_dataset_name
raise ValueError, 'different dataset names for variable and dataset or a
component'
ValueError: different dataset names for variable and dataset or a
component
Running UrbanSim for year 1981 in new process:
completed.................7.9 sec
Traceback (most recent call last):
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\tools\start_run.py"
, line 75, in <module>
run_manager.run_run(config)
File
"C:\Dev\_eclipse_workspace\Urbansim41\opus-4.1\opus_core\services\run_server
\run_manager.py", line 160, in run_run
I print the dataset_names to help you for analyse.
Best regards,
Philippe.
-----Message d'origine-----
De : lmwang_at_gmail.com [mailto:lmwang_at_gmail.com]De la part de Liming Wang
Envoyé : vendredi 1 février 2008 19:22
À : Zuccarello Philippe
Cc : users_at_urbansim.org
Objet : Re: [UrbanSim-Users] San Francisco business model
Hi,
I created a list of all the tables we have in our San Francisco
database. Some of them are for indicators only and you may not need them
(e.g. district14, district24 and tracts). Attached please also find the
structure of the tables you requested. ProcessPipeLineEvents model is
optional and is only necessary when you have pre-scheduled "pipeline"
development projects. But I'd recommend you to run real_estate_price_model,
which predicts real estate price for each simulation year, although other
models should work without it. The error you encountered with building
location choice (it could be with other model unless you can tell from the
log information you didn't include in your email) is likely caused by a
problem in your configuration (the original file is in
sanfrancisco/configs/controller_config.py).
Hope these help.
Liming.
...
Received on Fri Feb 08 2008 - 05:30:07 PST
This archive was generated by hypermail 2.2.0 : Fri Feb 08 2008 - 05:30:08 PST